Principal Consultant2002 - PRESENTeSolutions, Inc.
Technologies: Microsoft Power BI, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft SQL Server
- Reduced the processing time of SQL Server stored procedures for monthly calculation of healthcare KPIs (HEDIS) by 90%.
- Developed data models, dashboards, and reports for sales representatives in SQL Server and Power BI, integrating data from several sources and automating lengthy processes that were previously done manually.
- Designed and developed an end-to-end analytics solution for healthcare data, from the loading of millions of records each month in a SQL Server database to the production of dashboards and reports in Power BI.
- Created and lead a team of developers for the development of a web-based application to capture, validate, report, and exchange data on participants of a government workforce investment system.
- Designed several support systems for a pharmaceutical plant using web technologies and SQL Server, including systems for tracking manufacturing effort, for tracking the movement of fixed assets, and for managing of action items.