Sanket Kamat

Experience

• 

  Central Connecticut State University

  Aug 2006 - Dec 2007

  Graduate Assistant and Internship

  - Provided desktop support, including PC imaging, software installation, and maintenance of campus IT network.- Supported and maintained IT inventory database, developing SQL queries in MS Access for IT support applications.

• 

  Dillards

  Jan 2008 - May 2008

  SAS programmer analyst

  - Conducted analysis on sales data, generated reports for strategic campaign launches, and performed post-campaign analysis.- Coordinated with statisticians for predictive modeling data preparation, using SAS/SQL pass-thru, data step functions for data extracts.- Extensively used SAS procedures for reporting, HTML for website output, and MS Excel features for graphical reports.- Proficient in SAS 9.1 BASE, SAS Enterprise Miner, SAS/MACROS, SAS/STAT, HTML, UNIX, Oracle, and MS Office. Show less

• 

  Enterprise Rent-A-Car

  Jun 2008 - Nov 2008

  SAS Developer

  - As part of Integrated Claims Environment Developed SAS routines for Data load and Report Migration project, ensuring SDLC adherence.- Analyzed Oracle stored procedures, developed SAS routines for initial data load from Oracle to Teradata level 1.- Conducted ETL processes using SAS and Teradata tables, built Materialized tables, User views; tuned SQL queries for improved efficiency.- Proficient in SAS 9.1.3, UNIX, Teradata, Oracle, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ODS, and Windows XP. Show less

• 

  Harvard Pilgrim Health Care

  Jan 2009 - Dec 2021

  - Designed and developed HEDIS Quality Measurement applications, measuring effectiveness of care, analyzing claims trends, integrating diverse data sources and transformations. Leveraged SAS/SQL programming steps, and reporting. - Implemented data analysis and integration strategies for quality rate improvement, maintaining quality rating comparable with regional benchmark or above 90th percentile thus achieving as the top performing Health Plan in America.- Provided analytical support for key outreach programs, developing SAS graphical and tabular reporting applications to present actionable insights; Implemented reporting automation and validations as required.- Led UAT tasks, ensuring periodic data loads to EDW, collaborating with Data Management and Vendor achieving department data needs. Show less - Followed Agile methodology, remediating legacy data warehouse queries and data steps for SAS analytical reports migration to EDW.- Developed Teradata/SAS SQL queries and SAS macros for extracting and integrating claims data into SAS datasets.- Conducted data quality checks across legacy and enterprise DW systems, following SAS-Teradata center of excellence guidelines.- Proficient in SAS 9.1.3, HP UNIX, Teradata, SAS/BASE, SAS/CONNECT, SAS/MACROS, SAS/SQL, SAS/ODS, and Windows XP. Show less

  • Sr EDW Analyst

    Nov 2017 - Dec 2021

  • Informatics Analyst

    Feb 2013 - Oct 2017

  • Business Analyst

    Apr 2010 - Apr 2013

  • SAS Application Specialist

    Jan 2009 - Mar 2010
• 

  Point32Health

  Jan 2022 - now

  Senior Business Data Analyst

  - Spearheaded the EDW Data Quality team, leading end-to-end solutions for data quality challenges, from root cause analysis using SQL to, updating Data Model, View updates, refining ETL logic and UAT, collaborating with diverse teams. Presented thorough understanding of Data Model & Data Flow.- Directed Data Integration and Data Extracts projects as the Data Product Owner using Agile methodology, involving SQL query design, Data Modeling, Source-Target mapping/Technical Specs development, Reference Data update, ETL design, data flow and designing UAT scripts.- Led UAT tasks for newly developed applications, derivation for EDW, Data Tokenization, Data Masking projects; developed automated scripts using SQL and SAS macros to streamline the validation process.- Played key role in design, development and enhancing the Quality Measurement analytics application; Developed SAS and SQL code to execute data transformations, ensuring accurate validation and receiving NCQA code certification.- Designed and developed data marts using SQL queries and data processing steps for KPI measure Corporate Dashboards and BI Applications. Development and monitoring of SQL data cubes for MicroStrategy BI Applications. Show less