Hello, I'm
Ramkumar Pitchai
Senior Data Analyst
Accomplished data professional with 8+ years of experience in SQL, ETL automation, Python, and Power BI. Specialized in healthcare analytics, optimizing data pipelines, and delivering strategic insights across US healthcare and financial services sectors.
About Me
Professional Summary
Accomplished Senior Data Analyst with over 8 years of hands-on experience in data extraction, ETL process automation, and analytics.
Demonstrated success in optimizing large-scale data pipelines, reducing ETL processing times by 90%, and generating strategic insights for US healthcare, financial services, and BPM sectors.
Proficient in SQL, Python, Power BI, and cloud data platforms, with certifications in Google Data Analytics and Microsoft Azure DP-900.
Performance Optimization
Reduced ETL processing times by 90% (2hrs → 20min) through advanced SQL optimization
Large-Scale Data Management
Led archival of 16B+ healthcare records, reducing database load by 40%
Delivery Excellence
Recognized for 99% on-time delivery of analytical insights across healthcare and BPM projects
Certifications
Microsoft Azure Data Fundamentals
DP-900 | 2023
Google Data Analytics
Professional Certificate | 2022
Azure AI Fundamentals
AI-900 | Jul 2025
Education
B.Sc. Computer Science
Rajapalayam Rajus College, Madurai Kamaraj University
2012 | Grade: 73%
Technical Skills
Programming & Tools
Data Visualization
Databases & ETL
Project Management
Cloud & Platforms
Domain Expertise
Core Competencies
Professional Experience
Senior Data Analyst
Optum Health & Technology India Pvt Ltd
Chennai
Domain: EpiSubmitter - Healthcare Claims Platform
- Collaborated in Agile sprints using Rally for bug fixes, ETL automation, and client deliverables
- Reduced ETL processing time by 90% (2hrs → 20min) through SQL optimization and performance tuning
- Achieved 99% SLA compliance resolving high-priority client tickets for database errors and data discrepancies
- Led archival of 16B+ healthcare records, reducing database load by 40%
- Automated ETL workflows using SQL Agent Jobs and SSIS packages, reducing manual effort by 50%
- Improved query efficiency by 35% through database health analysis using SQL Profiler
Technical Process Specialist
Infosys BPM Ltd
Chennai
Domain: Business Process Management & Analytics
- Prepared daily, weekly, and monthly dashboards for KPI tracking and visualization
- Generated team performance reports from Salesforce and SAP data consolidation
- Developed Salesforce reports and dashboards for business insights
- Designed VBA-enabled automation tools to streamline reporting processes
- Managed Tableau reports ensuring accurate data ingestion and refreshments
Processing Officer
Computer Age Management Services Ltd
Chennai
Domain: Mutual Fund Data Management
- Led quality assurance for client data with 100% compliance to business requirements
- Developed automated Excel tools using VBA, accelerating quarterly reporting by 30%
- Optimized data collection procedures for weekly, monthly, and quarterly reports
- Identified and reconciled errors in client data ensuring accuracy
Featured Projects
EpiSubmitter Healthcare Platform
Proprietary platform enabling US healthcare organizations to validate and submit Medicare, Medicaid, and ACA claims to federal/state authorities, ensuring CMS compliance.
Technologies:
Key Achievements:
- Reduced system downtime by 30% through proactive bug fixes
- Achieved 99% SLA compliance for client ticket resolution
- Implemented root-cause analysis reducing ticket recurrence by 40%
ETL Pipeline Optimization
Comprehensive ETL automation and optimization project reducing processing times and improving data flow efficiency across healthcare data systems.
Technologies:
Key Achievements:
- Reduced ETL processing time by 90% (2hrs → 20min)
- Improved SSIS package performance by 40% via parallel processing
- Automated workflows reducing manual effort by 50%
Healthcare Data Archival System
Large-scale data archival project managing 16 billion+ healthcare records, optimizing database performance and storage efficiency.
Technologies:
Key Achievements:
- Successfully archived 16B+ Medicare/Medicaid claims
- Reduced database load by 40%
- Implemented cold storage migration strategy
Power BI Analytics Dashboards
Comprehensive business intelligence dashboards providing real-time insights into healthcare operations, SLA metrics, and system performance.
Technologies:
Key Achievements:
- Generated SLA reports and system availability dashboards
- Created ad-hoc client deliverables with SQL and Python
- Enabled data-driven decision making for stakeholders
Latest Insights
My First Blog Post
This is an example blog post to test the portfolio system.
Get In Touch
I'm always open to discussing new opportunities, collaborations, or data analytics projects. Feel free to reach out!
Connect With Me
Let's connect on LinkedIn or drop me an email to discuss opportunities in data analytics and healthcare technology.
Send Message