Delivered five large multi-year programs, guiding Sunlife- DentaQuest through digital transformation in Big Data and AnalyticsEnabled foundational, shared data services to deliver improved data quality while reducing the firm’s overall data spend via strategic programs:• Strategic Onboarding ($15MM spend) to enable digital-native and cloud native (SaaS) insurance analytics processes. Define global operating model for member onboarding through Big data to support the needs of Payments, Risk, and Financial operations• Enterprise Data Platform ($8 MM spend) that enables advanced analytics, reporting, and supports operational data needs across all lines of business and horizontal functions.• Develop a pool of innovative, data-minded resources by sourcing top tech talent and enabling existing resources with the tools and creative vision required to drive business outcomes and cultural transformation faster.• Assisting in new product launches (business cases, KPIs/metrics discovery & tracking, ramp strategy, etc.), bench-marking and forecasting of KPI trends through PowerBI• Delivered predictive models measuring COVID-19 Impacts at 85% Accuracy and financial predictive analytics at 97% Accuracy on important strategic initiatives for multiple business domains across the enterprise• Expanding capabilities in data science techniques including deep learning, ML for fraud detection and sentiment analysis • Development & automation of visually appealing executive dashboards (Tableau)/reports (PowerBI), deep dives and root cause analyses to improve product/platform performance, resolution of merchant/partner escalations, building and monitoring real-time alerts, and development of smart analytics tools and services to improve customer experiences and drive monetization

Spearhead the Solution design, Data Modeling and ETL development for our data marts using different technologies such as Informatica, SQL Server, Microsoft Azure Tabular Models meeting 98% SLAs• Automate 30% of processes such as batch job monitoring, critical job alerts, data sync and verification, auto removal of null data records using Informatica resulting in delivering 99% of program on time• Lead the design and development of BI Solutions that consolidate 60% of data into Enterprise Datawarehouse and Azure data lake, specifically around Client Performance• Generated key insights from Outreach Campaign giveaway programs, that helped in targeted marketing using push text notifications, increasing the customer registration rate in specific markets by 40%• Helped define technical requirements and data architecture (3NF) for the underlying data warehouses• Designed the data architecture to ingest large amount of structured and unstructured datasets in the new cloud cluster and Enterprise Datawarehouse (EDW)• Implement and Drive towards automation and self-service of IBM Cognos ® and Tableau Dashboards• Reduced the footprint of reporting by over 30% through Reporting Archival and Persona generation

• Lead the definition, requirements, architecture, master data management and development of data marts and defined / maintained corporate standards, access, definitions, and integrationfor new data and reporting.• Acted as liaison between Data Warehouse team, client, and front end systems group. Identified required enhancements, architecture, ETL, and Use Cases\testing.• Hands on Project Management and Lead of the ETL team with SSIS and Custom Dot Net Application including product evaluation, training and architecture and team management. • Led Data Governance and One Vision of Data initiatives.• Conceptualized and Managed Business Information Architecture of DW / BI initiative to provide balanced scorecard re-engineering reporting (MS SQL Server/.NET). • Integrated and replaced current metrics management reporting with dashboards, data mining, and guided analysis to manage the Financial, Operational and Customer Service Analytics.• Served as both the Business and Technical leads for the EDW, IT – architecture, DBA’s, BA’s, ETL (Data Stage/SSIS) and Reporting (Cognos). • Led project to model, design and build reporting and analytics for Business Process Management (BPM) system (MS SQL Server back end) to control submission and renewal processes and workflow management.

Played a vital role of Track Manager for LIHEAP (Low Income Home Energy Assistance Program)application and system lead for LIHEAP/eCIS Integration initiative:• The initiative’s business goal is to integrate the existing functionalities from a standalone LIHEAP application to eCIS (electronic Client Information System) to align with the public welfare department’s goals and objectives of a single process workflow• Implemented over 600+ new reports and migrated over 300+ reports required for managing the program in Microsoft BI Reporting Services• Expand stability of various production support programs across multiple public agency systems, improving clients’ SLAs from 85% to 98%, ensuring 500+ end-users get reports with high data accuracy on time• Upgraded SQL Server from version 2008 to 2012 for 1450+ Reports improving performance by 30% with zero defects under tight timelines 8 months• Reduced Expenses (35% Cost savings) converting 8800 legacy documerge enterprise correspondence forms to HP OpenText Exstream under aggressive timelines

• Involved in Business Process Study, Functional Specifications of the existing system• Lead the efforts to build a document repository to archive over 50,000 Scholarship Certificates• Built and automated 100% of data test scenarios used for performance and up-time testing