● Design data warehouse structure and implement data management solutions● Provide guidance on short and long-term data validation to ensure clinical data integrity● Coordinate information with insurance payers, employers, and network providers● Analyze and aggregate data across multiple technology resources to bring together in an actionable format● Write advanced scripting to provide data regarding contract specific goals● Data normalization and field mapping recommendations across servers and data platforms

● Build dynamic dashboard for committee presentations. Use visuals to immediately answer questions during meetings with filter actions● Create ETL packages with SQL Server Data Tools to import disparate data sets and merge into consistent data format● Create data hierarchies in Tableau with level of detail and context filtering for end user functionality● Extract/aggregate data from flat files, excel, and SQL databases for Tableau reporting● Manage payer/insurance claim data consistency across multiple file types and formats and normalize to a static schema● Created process to facilitate the network physician coverage and status. Physician tables updated monthly and distributed to insurers/payers and in-network stakeholders● Slice medical data by hospital, geography, cost and rendering provider to analyze ED and Inpatient utilization trends. Discuss strategies to retain business and steer population towards Urgent care● Data mine medical claims to identify potential wasteful utilization in network● Build and maintain network-wide pharmaceutical reporting tool that showed prescribing trends and notified physicians of opportunities for cost-savings through therapeutic alternatives

● Gathered reporting requirements and guided analytics team to develop metrics and data visuals for customers● Assembled complex reporting packages for executive and management presentations● Evaluated data to help steer product team towards issues within software releases● Publish dashboards to Tableau server for use by internal management and/or customer presentation● Statistical analysis on large data sets to create benchmarks and comparison reports for customers● Presented proof of concept of new Tableau reports to management and product leaders● Created SQL Views, Tables and Stored Procedures to accommodate aggregate Tableau reporting● Automated previously manual Excel reporting to Tableau● Collaborated with DBA to ensure data formats are consistent and ETL processes flow smoothly● Developed key performance indicators (KPI) related to software performance and medical data● Worked with product management to identify reporting requirements for analyses. Develop database queries and design reports based on this information● Assisted in retaining at-risk customer who contributes $2 million in annual revenue by working side by side with them to provide patient outcome analysis and financial impact reports in real time

● Wrote SQL queries and built reports to view data across various timeframes for trend evaluation● Eliminated inefficient data gathering methods by building SQL Scripts that cycled through records automatically in order to identity critical data points● Data mined records and helped create models for data normalization● Produced reports for sales presentation to prospective clients, often for high revenue accounts more than $1M in additional revenue● Designed reports for client retention, focusing on at-risk clients that generated at least $300k in annual revenue● Wrote ad hoc SQL queries as needed for urgent reporting requests● Created and modified SQL queries to make data more user friendly for internal organization and for customers● Reported aggregate data trends to client managers to monitor performance and compliance. These reports showed both product value and that the product was being used properly in accordance with medical coding guidelines