Business Intelligence Consultant2021 - PRESENTMiles Technologies
Technologies: Microsoft Power BI, SQL, DAX, Azure Data Factory, IT Consulting, Relational Database Design, Databases, Data Analysis, Microsoft SQL Server, Data Visualization
- 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 Analyst2014 - 2021Auto-owners Insurance
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
- 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.