Madhukar Katam
CVS Health
Greensboro,NC
1
Language
1
Certification
11
years of professional experience
Experienced GCP-certified Data Engineer with over 10 years in healthcare, automotive, insurance, and retail. Skilled in SQL Server, T-SQL, database design, and ETL processes using SSIS, while optimizing queries and performance. Drives data workflows and business intelligence initiatives through innovative solutions, leveraging expertise in SQL, Python, Spark, and cloud platforms.
Work History
Sr. Data Engineer
4 Years 2 Months- Designed and developed scalable near real-time data pipelines to replicate operational data from legacy systems into cloud-based data platforms, enabling low-latency API and application access.
- Built and maintained Change Data Capture (CDC) solutions using enterprise replication technologies to synchronize transactional data from source systems into PostgreSQL databases.
- Developed ETL/ELT frameworks using Python and SQL to transform, enrich, and load high-volume operational data into optimized data stores.
- Designed and implemented MongoDB document models, aggregation pipelines, indexing strategies, and sharding approaches to support high-throughput API workloads.
- Optimized PostgreSQL database performance through schema design, query tuning, indexing, partitioning, and capacity planning, reducing data retrieval times by up to 40%.
- Built cloud-native data processing solutions on Google Cloud Platform (GCP) utilizing Cloud SQL, Dataproc, Cloud Composer (Airflow), IAM, and monitoring services.
- Collaborated with application and API development teams to design cache-ready domain models, enhancing application response times and reducing dependency on legacy systems.
- Implemented near real-time data synchronization processes to ensure high data freshness, reliability, and availability across distributed systems.
- Developed automated monitoring, alerting, and operational dashboards to proactively identify and resolve data pipeline issues.
- Led root cause analysis and production support activities for data integration platforms, minimizing downtime and ensuring SLA compliance.
- Designed and maintained scalable transactional and operational data stores capable of supporting millions of daily records and API requests.
- Automated data quality validation, reconciliation, and exception handling processes, enhancing data integrity and consistency.
- Mentored junior engineers on Python development, CDC architecture, SQL optimization, cloud-native data engineering, and data modeling best practices.
- CVS Health is an American healthcare company that owns CVS Pharmacy, a retail pharmacy chain, CVS Caremark, Aetna, a health insurance provider, among many other brands.
Data Engineer
10 Months- Analyzed business requirements in BI context and designed data models to transform raw data into actionable insights.
- Implemented CDC-based replication pipelines that achieved sub-minute latency between source systems and PostgreSQL databases.
- Developed scalable GCP-based ETL solutions processing multi-terabyte datasets while maintaining high availability and reliability.
- Optimized MongoDB collections through indexing and query tuning, improving read performance by 60% for customer-facing APIs.
- Reduced data pipeline failures by 35% through proactive monitoring, automated alerting, and robust operational support procedures.
- Engineered scalable GCP-based ETL solutions for multi-terabyte datasets, ensuring high availability and reliability.
- (remote)
Power BI Developer
8 Months- Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archive data files for different RDBMS.
- Expertise in all areas of data warehousing (architecture, data sourcing/acquisition, integration, transformation, presentation)
- Team has Agile methodology and used Jira for project tracking.
- Expertise in developing applications using PowerApps. Experience in power BI governance and security.
- Design ETL architecture including CDC, mappings, data flows, procedures, schedules, etc
- Developed data and BI reporting systems along with associated models and architectures to support business needs.
- Resolved complex production issues across multiple tiers in BI/DW technology stack, enhancing system reliability.
- Extensively worked on SSIS, SSRS and SSAS.
- Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
- Designed and implemented Data Integration and ETL processes with SSIS packages to make data available for reporting purposes within a data warehouse.
- Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL. Experience in working with Python APIS in connecting to SQL server.
- Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.
- Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.
- Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
- Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
- Worked on migration project from cognos to Power BI report Builder. Experience designing and developing datasets to ensure ease of use and minimal knowledge by the end users for self-service.
- Automated operational processes and data workflows with Python scripting, streamlining tasks and enhancing deployment efficiency.
- Delivered production support and troubleshooting for cloud and on-premises data platforms.
SQL Developer/ Production Support
2 Years 11 Months- Migrated data from SQL Server 2014 to SQL Server 2016, working with integration services to transfer and review data from heterogeneous sources like Excel, CSV, flat files, and text format data.
- Experience on Epic Clarity in CVS health (Accordant) project. Experience working with Service Now CMDB database.
- Architect of Power BI reporting solution, create Dashboards / Reports using Power BI as well as guides team of Power BI developers.
- Creation of Tabular Data Models (SSAS), SSRS Reports and ETL jobs (SSIS)
- Resolved database design and data modeling issues to enhance report performance and user accessibility. Performance analysis & improvements in Power BI reports and SSAS models
- Expertise in advanced calculations using MS Power BI Desktop (Aggregate, Date, Logical, String, Table)
- Created calculated measures and columns using DAX in MS Power BI Desktop, enabling more advanced data analysis and reporting capabilities.
- Extensively used Script task in SSIS to Zip the flat files and used FTP and SFTP Tasks in SSIS to deliver the files to third party companies.
- Experience in development in Power BI Report Builder, Power BI Desktop and Power BI Online
SQL Developer
1 Year 11 Months- Performed T-SQL programming – writing new stored procedures, updating & enhancing the existing code.
- Scheduled and maintained SQL packages by daily, weekly and monthly using SQL Server Agent in SSMS.
- Developed complex stored procedures to generate drill-through, parameterized, tabular, matrix, and linked reports using SSRS, enhancing reporting capabilities.
- Scheduled and maintained packages by daily, weekly and monthly using SQL Server Agent in SSMS.
- Created Azure Data Storage accounts within Azure Data Factory for cloud-based big data storage, streamlining data management.
- Delivered SME in Power BI Modelling, usage of DAX, and implementation of Row-level security with Power BI (RLS).
- Determined business requirements and translated them into reporting solution, while collaborating with business analysts and subject matter experts.
- Improved efficiency of Power BI reports by devising solution, including preparing DAX code to handle calculations.
- Enhanced Power BI report efficiency by devising solutions and preparing DAX code for complex calculations.
- Experience managing Power BI Workspaces, Datasets reports and Dashboards. Experience managing and implementing Power BI development pipelines.
- Strong understanding of Power BI application security layer models, row-Level Security, Restricting Sharing and Publishing, Restricting Export and Printing
- Worked at Ford Motor Company is an American Multinational automaker headquartered in Dearborn, Michigan. This is automotive Project about Migrating Ford applications to Next Generation Data center build in Dearborn.
Education
Masters - Electrical and Electronic Engineering
Bachelors - Electronics and Communication Engineering
Skills
Data engineering
Databases: PostgreSQL
MongoDB
MySQL
SQL Server
Cloud: Google Cloud Platform (Cloud SQL
Dataproc
Workflow orchestration
IAM
Monitoring)
Programming: Python
SQL
Shell Scripting
Data Processing Frameworks
Monitoring and alerting
Data governance
Operating Systems: Linux
Unix
Certification
GCP-Cloud Digital Leader Certification, GCP-Professional Data Engineer Certification
Personal Information
Title: Data Engineer
Languages
English
Full Professional
Timeline
Sr. Data Engineer
CVS Health
08.2022 - CurrentRead More
Data Engineer
PepsiCo
09.2021 - 07.2022Read More
Power BI Developer
HomeSite Insurance
01.2021 - 09.2021Read More
SQL Developer/ Production Support
CVS Health
01.2018 - 12.2020Read More
SQL Developer
Ford Motor Company
01.2016 - 12.2017Read More
Wright State University
Masters from Electrical and Electronic Engineering
Read More
Lovely Professional University
Bachelors from Electronics and Communication Engineering
Read More