Philip Lancaster Email & Phone Number

New Orleans, LA, US

• Coordinates with dashboard development and project management teams to source and provide ongoing data for some of the most critical dashboards in Aetna Medicaid. Many of these dashboards are viewed and utilized for.
• Utilizes SQL and SSIS in the development and ongoing maintenance of 100+ data warehouse processes.
• Developed a Python library to handle ETL of an expanding number of QuickBase applications for data inclusion in the data warehouse. https://github.com/plancaster88/python_projects/tree/master/quickbase
• Managed a team of 4 business intelligence consultants by providing project guidance and ensuring thatdepartment goals and initiatives were achieved. Projects included development of Power BI dashboards, SSRS reports.

• Led analytics projects for Medicaid plans and proactively generated solutions for reporting, dashboarding, and data management.
• Instructed 5+ analytics departments in Aetna Medicaid plans outside of LA on how to use and implement scalable, in-cloud Power BI reporting solutions.
• Implemented automation by VM to automate Power BI reporting suite, data refresh, and Python scripts.

• Worked directly with Louisiana executive leadership by providing analysis to inform decision-making.
• Independently managed business intelligence initiatives with the following functions: gathered report and data needs from users, developed data models and metrics, designed interactive.
• Automated various tasks such as data prep and loading of routine files to SQL Server with Python.
• Developed star schema data warehouse in SQL Server to enable quick and accurate analysis/ad-hoc reporting.

Metairie, LA

• Supported operational and strategic decisions through the collection, analysis, interpretation, and communication of information to key decision-makers.
• Utilized SQL to develop queries to pull data on claims utilization, membership, and pharmacy utilization. Created views and stored procedures to better extract complex data.
• Developed interactive reports and dashboards for management in SSRS and PowerPivot.
• Designed and maintained SSAS/PowerPivot tabular data models used by the department to analyze large data sets for actionable information.

Greater New Orleans Area

• Reduced departmental backlog by over 10% for the Fraud Investigation Department by identifying low-risk subsets of the backlog population. This resulted in roughly 2,000 work hours saved.
• Functioned as liaison between Internal Audit team and Fraud Waste and Abuse team.
• Assisted management with ad hoc data analysis and special projects.
• Performed independent and objective audits of claims to ensure that claims were processed in accordance with settlement policy and to identify process weaknesses.