Driving the creation of the GEICO Data Hub a cloud warehouse utilizing Snowflake as a single source-of-truth to transform the way source systems provide data to analytics dashboards and ML. KEY ACCOMPLISHMENTS:• Built data engineering pipelines to ingest both streaming and batch data from 23 different Policy and Billing sources into the Snowflake cloud warehouse• Set up Confluent Kafka connectors on connect clusters to read data from Microsoft Azure Service Bus subscription topics and load into Snowflake• Redesigned and developed the MDM Reference Data ingestion using Microsoft Azure Data Factory, retiring 800 Kafka connectors • Migrated pipeline versions to newer frameworks using ingestion tools such as Fivetran and HVR for live replication into Snowflake• Utilized the Data Build Tool (DBT) for Snowflake and VS code to transform data across different logical layers in Snowflake• Utilized the Azure DevOps CI/CD process for version control, deployment to environments, and delivery of data pipelines• Provided technical leadership and mentoring to data engineers to design, develop, and maintain scalable data pipelines• Realized savings of over $150K in Snowflake credits by implementing Query tagging and eliminating redundant pipelines• Participated in PI planning sessions, worked with Scrum Masters to organize the Mural Board, managed teams’ ADO Boards and deliverables through Scrum cycles• Stood up L1/L3 production support teams, organized knowledge share sessions, helped document runbooks and implemented Incident management procedures• Helped streamline the hiring process by gathering resource estimations, defining interview dimensions, interview panels by stage, and robust feedback policy• Created onboarding documentation for new associates, identified training requirements, set their team and individual level goals• Managed software vendor relationships, highlighted issues and tracked feature requests through General Availability

Create innovative near real-time ingestions helping pharmacy technicians track productivity. Architect and Implement migration of legacy on-premises SSIS based applications into the Microsoft Azure cloud and Snowflake warehouse.KEY ACCOMPLISHMENTS:• Lead a team of data engineers responsible for developing data engineering solutions and cloud migrations• Designed and presented to leadership a roadmap to migrate on prem applications into the cloud• Architected a framework using Snowflake’s Python connector and API’s to ingest data, migrate applications to cloud including historical data extracts. • Worked with the Data Governance council to certify that applications are compliant per masking standards for PHI/PII information, and HIPAA compliance• Implemented cloud-based solutions contributing to savings of over $350k in second half of 2021.• Collaborated with multiple teams to define and implement innovative solutions and development processes resulting in over 50% YoY increase in SLA performance of the Business Intelligence team• Developed Near-Realtime solutions for Pharmacy technicians to track their work goals for order fulfillment including Home Delivery and Specialty pharmacy• Organized and Managed deliverables through Scrum cycles using Agile Framework• Implement customer stakeholder meetings and daily standups to drive accountability and performance• Presented senior leadership with key metrics including Turn-around-Time (TAT), Work Force Management tracking, Scorecards and Daily Production Inventory • Subject matter expertise in healthcare domains including Rx Home Delivery Pharmacy, Behavioral Health Claims, Clinical and Workers Compensation• Significantly enhanced the organization’s BI capabilities in the Patient Care Opportunity area with a focus on improving the STARS rating

• Led the Integrated Clinical Solutions Program to identify at-risk claims using Predictive Analytics techniques and provide Triage Nurses and Adjusters the information needed to make an appropriate Clinical Recommendation• This led to improved patient outcomes and better turnaround times in returning the workers back to their jobs• This also facilitated automatic workflow routing for Prior Authorizations, Telephonic and Field Case Management and Utilization reviews• Designed and developed an Enterprise Data warehouse from the ground up for the Clinical business• Designed and created a conformed layer centralized around Claims, creating Clinical Decision support systems• Developed layouts for different file types such as XML, fixed width and delimited into the warehouse • Worked closely with Data governance to maintain metadata of data models on SharePoint• Mentored developers, provided guidance and resources to them, and lead code reviews• Evaluated various tools such as IBM Optim to mask PHI information and IBM Quality Stage for Provider matching• Created framework for loading Encounter Claims and HEDIS data sets• Designed the move from ICD-9 to ICD10 codes

• Involved in improving throughput of ETL processes and T-SQL scripts eliminating performance bottlenecks• Performed Dimensional data modeling of the EDW creating Star schemas, including Type II dimensions• Created the as-is and to-be diagrams of the existing processes using Visio and present them to management• Worked closely with the Project Managers to ensure that Aetna Project Life Cycle(APLC) requirements are met• Participated in the migration of the data warehouse from Oracle to Netezza appliance• Generate extracts out of the warehouse using SAS to support business requirements