Pranav Kumar
Mckinney,TX
Summary
Strategic Senior Data Engineering Leader with 14 years of experience in data architecture and Data Lakehouse implementation across SQL Server, Oracle, and Azure. HEDIS CMS Certified with expertise in NCQA/CMS standards and Revenue Cycle Management. Skilled in developing ETL/ELT pipelines and Medallion Architecture using Azure Data Factory and Databricks. Proven success in managing cross-functional teams and optimizing cloud resources to enhance system reliability and support organizational objectives.
Overview
19
19
years of professional experience
Work History
Senior Data Engineer
FisherSMB
Plano, Texas
07.2024 - Current
- Developed data pipelines to efficiently ingest and process large datasets for analytics.
- Developed data pipelines for efficient data processing and integration.
- Integrated heterogeneous sources into unified data repositories via ETL processes to enhance data accessibility.
- Implemented data models to support analytics and reporting initiatives.
- Managed database systems ensuring data integrity and security protocols.
- Collaborated with cross-functional teams to define data requirements and specifications.
- Collaborated with other teams to understand their requirements and deliver solutions accordingly.
- Participated in code reviews to ensure best practices and maintain quality standards.
- Assisted in troubleshooting and resolving data-related issues promptly.
- Monitored system health and performance metrics to ensure smooth functioning of the system.
- Documented data processes, tools, and methodologies to support knowledge transfer and maintain operational standards.
Senior Data Engineer
Fisher Investment
Plano, Texas
08.2022 - 07.2024
- Developed data models that enhanced analytics and reporting capabilities.
- Optimized queries to improve performance, reducing server load and enhancing responsiveness.
- Managed database systems ensuring data integrity and security protocols.
- Integrated multiple heterogeneous sources into one unified source via ETL processes.
- Collaborated with cross-functional teams to clarify and define data requirements and specifications.
- Participated in code reviews to ensure best practices and maintain quality standards.
EDW Team Lead
US Anesthesia Partners Of TX
Dallas, Texas
04.2018 - 07.2022
- Developed and built team to execute design initiatives for new EDW architectures, enhancing Revenue Cycle Management and Patient Engagement.
- Integrated EDW technologies with business applications, leading vendor integration projects to improve system functionality.
- Directed Coverage Detection process for insurance discovery, collaborating with third-party vendors to establish requirements and design processes.
- Coordinated with Centricity Business and RCM teams on ETM process management and file creation, streamlining operational workflows.
- Managed statement billing reconciliation between EDW and Centricity Business systems, creating reports for various departments.
- Resolved business issues arising from data discrepancies in reconciliation processes.
- Oversaw production support for existing and new operational processes, ensuring system setup for daily operations.
- Led resolution of production issues in collaboration with team members, maintaining seamless business operations.
Sr. Data Warehouse Developer
San Antonio Water Services
San Antonio, Texas
06.2017 - 03.2018
- Developed and delivered ETL processes and reporting solutions to meet business objectives within established timelines.
- Collaborated with team member to enhance data analysis on customer information, water and sewer consumption, billing cycles, adjustments, affordability, meter usage, and delinquency.
- Facilitated business requirement gathering sessions with City of San Antonio stakeholders, reviewing SDLC processes and defining deliverable objectives for new programs.
EDW Team Lead
Welled Medical Group
San Antonio, Texas
06.2014 - 06.2017
- Expertly conducted health care data analytics and trend analysis to enhance Star Ratings for submission processes.
- Developed ETL packages and reporting tables for HEDIS and C- and D-Measures according to CMS requirements.
- Developed data mining process to identify members not meeting criteria, providing actionable reports to clinics for score improvement.
- Migrated EDW database from 2008 R2 to 2012, facilitating seamless transfer of objects, SSIS packages, and reports.
- Designed a robust Data Warehouse for processing and reporting, focusing on schema integrity and performance.
- Enhanced SQL queries through performance tuning, improving data integrity and application consistency.
- Acquired extensive knowledge of healthcare data, including Claims, Pharmacy, Lab, and HEDIS Measures.
- Gathered business requirements from stakeholders and documented them as Business Requirement Documents (BRDs) to support project alignment.
SQL Developer/Business Intelligence
Hewlett-Packard
Austin, Texas
01.2014 - 06.2014
- Gathered business requirements for projects, analyzed existing data sources for fit-gap analysis, and managed entire SDLC for development processes.
- Built and deployed new processes, monitored jobs and packages, and resolved issues in production environment by checking logs for failures.
- Maintained database backups and conducted health check-ups, contributed to disaster recovery processes, and developed CDC processes for capturing changed data.
SQL Developer/Business Intelligence/ DBA Admin
Access Midstream
Oklahoma City, Oklahoma
06.2013 - 01.2014
- Collaborated with business stakeholders to identify needs for new and legacy EDW and delivered solutions to align with business goals.
- Evaluated legacy data and built automated processes to load new EDW databases, create underlying objects and security protocols, and establish operational requirements for the company.
- Partnered with DBA team to implement new solutions, oversee deployment jobs, and monitor process health for optimal performance.
SQL Developer/Business Intelligence Analyst
Torchmark Corporation
McKinney, Texas
06.2012 - 06.2013
- Developed SSIS/SSRS packages for ETL processes, enhancing data transformation and report generation efficiency.
- Created stored procedures for complex business logic, facilitating integration with Sitecore and website design teams.
- Designed SSIS package to import and validate legacy data for integrity and consistency in new database.
- Established Change Data Capture (CDC) to audit Inserts, Updates, and Deletes across databases.
- Implemented stored procedure error handling to facilitate logging and debugging processes.
- Analyzed existing database components and designed improved schema, optimizing business functionality.
PeopleSoft Technical Developer
State Accounting Office
Atlanta, Georgia
09.2006 - 11.2009
- Supported ERP implementation team for AP, AR, PO, GL, CM, and TR modules in PeopleSoft at SAO, facilitating project success.
- Led customization efforts for finance modules, enhancing applications and reporting needs.
- Played key role in upgrading financial modules from version 8.8 to 9.0.
- Coordinated with cross-functional teams to enhance system functionality, improving user experience and system integration.
- Conducted system tests to ensure quality and reliability of software.
- Integrated banking projects into customized applications, enhancing overall application functionality.
Education
MBA -
Wichita State University
Wichita, KS06-2012
Master of Science - Applied Geology
Auburn University
Auburn, Alabama, AL06-2004
Master of Science - Applied Geology
IIT Bombay
Mumbai06-2002
Skills
- Team Building & Hiring: Successfully hired and managed a diverse team of Developers, QA Analysts, and DBAs Defined roles, conducted performance reviews, and established a culture of continuous learning and technical excellence
- Mentoring & Growth: Served in a key mentoring role, upskilling junior developers in advanced SQL optimization and Azure Databricks workflows
- Environment Oversight: Managed the stability and security of multiple environments (Dev/Test/Prod), ensuring seamless code promotion and data consistency across on-prem and cloud
- Operational Excellence: Established daily performance monitoring protocols using custom SQL scripts and Azure Monitor, reducing system downtime by 30% through proactive bottleneck identification
- Modernization: Orchestrated the migration of legacy on-premises ETL frameworks to Azure Data Factory and Databricks, implementing Industry Best Practices for scalable cloud data processing
- Financial Systems: Architected and deployed a specialized Billing Application for Retirement Plan Management and clients, managing high-integrity data for complex contribution and fee structures
- Data Visualization: Designed executive-level Power BI and SSRS dashboards to track real-time KPIs, enabling data-driven decision-making for senior stakeholders
- Performance Tuning: Spearheaded performance initiatives for Oracle and SQL Server, reducing pipeline latency by 40% and optimizing high-load report rendering
Timeline
Senior Data Engineer
FisherSMB
07.2024 - Current
Senior Data Engineer
Fisher Investment
08.2022 - 07.2024
EDW Team Lead
US Anesthesia Partners Of TX
04.2018 - 07.2022
Sr. Data Warehouse Developer
San Antonio Water Services
06.2017 - 03.2018
EDW Team Lead
Welled Medical Group
06.2014 - 06.2017
SQL Developer/Business Intelligence
Hewlett-Packard
01.2014 - 06.2014
SQL Developer/Business Intelligence/ DBA Admin
Access Midstream
06.2013 - 01.2014
SQL Developer/Business Intelligence Analyst
Torchmark Corporation
06.2012 - 06.2013
PeopleSoft Technical Developer
State Accounting Office
09.2006 - 11.2009
MBA -
Wichita State University
Master of Science - Applied Geology
Auburn University
Master of Science - Applied Geology
IIT Bombay