•15+ years of professional experience with 3+ years of experience as a lead and 5+ years in custom ETL design, implementation, and maintenance.•Sound knowledge of Database Modeling and Normalization. •Led a team to leverage claims data and co-morbidity analysis to accurately identify potentially eligible members for state sponsored health care plans.•Spearheaded the design and development of a Table-Driven Methodology, revolutionizing ETL, CI/CD, Data Pipelines, Data Quality, Data Validation and Parallel Computing processes reducing development time by 50%.•Utilized Exploratory Data Analysis techniques and Machine Learning algorithms to uncover data relationships, detect outliers and anomalies and support predictive modeling reducing data exploration time from 3 weeks to 1 week.•Led cross-functional teams in collaborative projects to deliver Analytical Data Marts for predictive modeling, integrating multiple data sources and fostering synergistic outcomes.•Managed end-to-end data pipelines and reporting of Key Performance Indicators (KPI), ensuring high Data Quality and Data governance by implementing encryption methods for Personal Identifiable Information (PII) while maintaining Service Level Agreements (SLAs).•Automated monitoring of Risk Models KPIs for proactive identification of performance issues and prompt remedial actions.•Successfully orchestrated the migration of processes from DB2 to Teradata, showcasing adept management skills in complex data environments.•Produced automated visually compelling reports using Tableau and SAS BI Tools to drive Decision Making.•Developed self-serving Stored Procedures to empower stakeholders with direct access to valuable data insights and saving the programmer’s time for ad-hoc requests.•Utilized Jira and Confluence to efficiently document project processes, tasks, and discussions, ensuring transparent communication and streamlined collaboration among team members.