Business Intelligence Consultant
2021 - PRESENTMiles Technologies- Met with clients to discuss business intelligence and data warehousing solutions. Recommended software and best practices for clients' reporting needs.
- Developed a data warehouse and reporting solution for nursing homes to track patients enrolled in Medicare and when they are paid.
- Built a data warehouse and reporting solution from a company's internal ERP system to track sales and company productivity.
- Created a reporting solution for an energy company to track energy prices over time.
- Wrote documents for managing and developing a business intelligence project for clients from the consulting side.
Technologies: Microsoft Power BI, SQL, DAX, Azure Data Factory, IT Consulting, Relational Database Design, Databases, Data Analysis, Microsoft SQL Server, Data VisualizationSenior Data Analyst
2014 - 2021Auto-owners Insurance- Created reports with SSRS and Power BI, mainly working with the company's marketing and sales group to help analyze production numbers, determine the best marketing strategies, and analyze competitiveness in the market.
- Developed SQL databases and ETLs around insurance quoting, including creating a data warehouse from multiple data sources so the company could request new robust reporting solutions.
- Helped lead the project for designing and developing a new customer portal website as a business analyst. Gathered requirements from stakeholders, conducted market research on website designs, and helped developers plan Agile workloads.
- Assisted in actuarial ratemaking by reporting on sales figures and the company's competitiveness in the market.
- Trained newer developers in SQL Server and best BI practices and technologies.
Technologies: Business Intelligence (BI), Applied Mathematics, SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Actuarial, ETL, Data Engineering, Data Warehousing, Microsoft Excel, Statistics, Microsoft Power BI, Relational Database Design, Databases, Excel Macros, Data Analysis, Microsoft SQL Server, Data Visualization, Data Science, Data Analytics, Transact-SQL, Data Queries, Performance Tuning, SQL Performance, T-SQL
Jameson Edgeworth
Database Developer in Birmingham, AL, United States
Member since June 22, 2022
Jameson brings together a blend of business knowledge and mathematics. With skills in data modeling and statistical analysis, Jameson has helped companies from small businesses to the Fortune 500 understand their business operations and analyze trends through data.
Jameson is now available for hire
Portfolio
- Miles TechnologiesMicrosoft Power BI, SQL, DAX, Azure Data Factory, IT Consulting...
- Auto-owners InsuranceBusiness Intelligence (BI), Applied Mathematics, SQL...
Experience
- Mathematics 10 years
- Statistics 10 years
- SQL 8 years
- Microsoft Excel 8 years
- Business Intelligence (BI) 8 years
- Data Engineering 7 years
- Data Warehousing 7 years
- ETL 7 years
Availability
Part-time
Preferred Environment
SQL, Windows, Relational Database Design, Databases, Microsoft SQL Server
The most amazing...
...challenge I've faced is to build a predictive sales forecasting model using actuarial data science techniques.
Employment
Experience
- Data Warehouse for Insurance Quotes
Designed the structure and built the ETL to load a data warehouse for insurance quotes. Data involved seven different sources that needed to be compiled daily for reporting needs.
Spoke regularly with the company's users to determine the requirements of the model and eventual reporting needs. - Custom Reporting Solution for Nursing Homes
Worked on a custom reporting solution for nursing homes to track patients eligible for Medicare payments and when those payments come in.
Developed a data warehouse to track patients, medical diagnoses, and Medicare payment forms. Created several Power BI reports that would be embedded in an extensive web application. Secured reports and sensitive data based on the user who was logged in. - Corporate ERP System to Data Warehouse
Designed a data warehouse based on a company's ERP system.
Used Azure Data Factory to read from the system's API and transformed it into useable data for reporting. Built Power BI reports to track the company's sales and performance daily. Communicated with company executives to gather reporting requirements and present solutions.
Skills
Languages
SQL, C++, Transact-SQL, T-SQL, Python, C#.NETTools
Microsoft Excel, Microsoft Power BIParadigms
Business Intelligence (BI), ETL, Data ScienceOther
Applied Mathematics, Statistics, Data Warehousing, Data Engineering, Relational Database Design, Mathematics, Computer Science, Actuarial, DAX, Agile Sprints, Excel Macros, Data Analysis, Data Visualization, Data Analytics, Data Queries, Performance Tuning, Microsoft Azure, Azure Data Factory, IT ConsultingStorage
SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Databases, Microsoft SQL Server, SQL Performance, Azure SQLPlatforms
Windows
Education
- Bachelor's Degree in Mathematics2009 - 2013Lawrence Technological University - Southfield, MI, USA
