Jameson Edgeworth
Verified Expert in Engineering
Database Developer
Birmingham, AL, United States
Toptal 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.
Portfolio
Experience
- Mathematics - 10 years
- Statistics - 10 years
- Microsoft Excel - 8 years
- SQL - 8 years
- Business Intelligence (BI) - 8 years
- Data Warehousing - 7 years
- ETL - 7 years
- Data Engineering - 7 years
Work Experience
Business Intelligence Consultant
Miles 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.
Senior Data Analyst
Auto-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.
Project History
Data Warehouse for Insurance Quotes
Spoke regularly with the company's users to determine the requirements of the model and eventual reporting needs.
Custom Reporting Solution for Nursing Homes
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
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.
Education
Bachelor's Degree in Mathematics
Lawrence Technological University - Southfield, MI, USA
Skills
Tools
Microsoft Excel, Microsoft Power BI
Languages
SQL, C++, Transact-SQL (T-SQL), Python, C#.NET
Paradigms
Business Intelligence (BI), ETL, Database Design
Storage
SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Databases, Microsoft SQL Server, SQL Performance, Azure SQL
Platforms
Windows
Other
Applied Mathematics, Statistics, Data Warehousing, Data Engineering, Relational Database Design, Database Schema 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 (ADF), IT Consulting, Data Science
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring