Summary
Overview
Work History
Skills
Timeline
Generic

Ruchith Kumar

Richmond,VA

Summary

Experienced DataStage Developer with over 12 years of expertise in designing, developing, and optimizing high-performance ETL solutions across various industries, including financial services, automotive, and healthcare. Proficient in IBM Infosphere DataStage, Mainframe COBOL, Python, PySpark, and cloud-based data solutions (AWS, Snowflake), with a strong track record in transforming legacy systems to modern architectures, improving efficiency, and enhancing data processing workflows.

Skilled in automating ETL processes, troubleshooting complex data issues, and providing 24x7 production support. Experienced in designing end-to-end data integration solutions that consolidate data from multiple sources, enabling business intelligence and reporting. Adept at working with cross-functional teams to gather business requirements, translating them into actionable technical solutions, and driving continuous improvement initiatives. Known for taking ownership of large-scale migration projects, streamlining processes, and reducing operational costs through automation and cloud integration.

Throughout my career, I have played a pivotal role in leading data migration projects, improving data quality, and ensuring regulatory compliance through optimized ETL and reporting solutions. I thrive in dynamic environments, continuously enhancing my technical skill set, and leveraging industry best practices to deliver scalable, high-performance data integration systems.

Overview

12
12
years of professional experience

Work History

Senior DataStage ETL Developer

Atlantic Financial Services
Richmond, VA
04.2023 - Current
  • Developed and optimized ETL pipelines using IBM DataStage and Mainframe COBOL, integrating financial data from various sources to support regulatory reporting.
  • Automated data transformation processes with Python, reducing manual intervention by 30% and improving data accuracy for reporting.
  • Integrated cloud-based data sources (AWS S3, Snowflake) into existing ETL workflows, improving scalability and reducing on-premise data storage costs by 25%.
  • Troubleshot and resolved complex data-related issues in production, ensuring 24x7 support for critical systems with minimal downtime.
  • Provided solutions to improve data reporting efficiency, enabling real-time compliance reporting for financial regulatory agencies.
  • Led performance optimization initiatives for ETL processes, improving data processing speed by 15%.
  • Implemented cloud-based data integration solutions (AWS, Snowflake) that improved data accessibility and scalability, supporting business intelligence and decision-making.
  • Developed high-performance ETL pipelines to automate regulatory reporting and reduce report generation time by 40% for financial data analysis.

Lead DataStage Developer

Blue Ridge Auto Parts
Roanoke, VA
01.2021 - 03.2023
  • Designed and implemented ETL solutions using DataStage 11.7 and Mainframe COBOL, processing customer and inventory data to improve operational reporting.
  • Leveraged PySpark for real-time data transformation and processing, significantly improving the throughput of data pipelines and reducing batch processing times by 20%.
  • Integrated legacy systems with modern data storage solutions (Snowflake), ensuring efficient data migration and minimizing data duplication.
  • Automated manual ETL jobs with Python, reducing job failure rates and improving system reliability.
  • Collaborated with business analysts to optimize data reporting workflows, enabling business stakeholders to gain insights from data faster.
  • Developed data transformation frameworks that integrated multiple legacy systems with cloud-based solutions (Snowflake, AWS), enabling better data management and storage.
  • Led the migration of on-premise data solutions to cloud platforms, reducing data storage costs by 20% and improving scalability.

Senior DataStage ETL Developer

Blue Cross Blue Shield
Reston, VA
06.2018 - 12.2020
  • Led migration projects for legacy Mainframe COBOL systems, converting ETL processes to DataStage 9.1/11.7, improving system performance and reporting accuracy.
  • Designed and implemented ETL sequences for integrating claims data, reducing the batch processing time by 25% and improving overall system performance.
  • Enhanced automation of routine data load and transformation tasks using Python and Shell scripts, improving job execution efficiency and reducing manual intervention.
  • Provided 24x7 production support, maintaining high availability for critical healthcare systems and addressing production incidents promptly.
  • Worked with stakeholders to refine data reporting requirements, ensuring timely and accurate regulatory reporting.
  • Led the integration of real-time data processing for healthcare claims, reducing batch processing times by 30% and enhancing system reliability.
  • Optimized data workflows and performed data validation, ensuring timely and accurate reporting for healthcare compliance and regulatory requirements.

ETL Developer

Bharat Technical solutions
Banglore, India
11.2012 - 05.2018
  • Developed and optimized ETL processes using DataStage 8.x and Mainframe COBOL, integrating multiple data sources to support large-scale data integration projects.
  • Led the migration of legacy ETL jobs to DataStage 11.x, improving data processing speeds and reducing system resource consumption by 30%.
  • Implemented automation using Python, streamlining the data transformation process, and improving system reliability by 20%.
  • Designed and implemented cloud-based data solutions (AWS S3, Snowflake) for improved data storage and accessibility, reducing on-premise storage costs by 25%.
  • Mentored junior team members in DataStage development, helping to build expertise in data transformation, troubleshooting, and optimization.
  • Led the data migration project for a critical client system, ensuring zero data loss and a smooth transition from legacy systems to new ETL frameworks.
  • Optimized data pipelines for real-time data processing, reducing data latency by 30%, enabling quicker business decision-making.
  • Provided 24x7 production support, addressing and resolving incidents promptly to ensure minimal disruption to data operations and reporting.
  • Designed and implemented data pipelines for large-scale client applications, reducing data processing time by 25% and improving system efficiency.
  • Developed custom error handling solutions and automated ETL workflows, resulting in a 20% reduction in job failures and ensuring high-quality data processing.

Skills

  • ETL Development & Integration: IBM Infosphere DataStage (8x–117), DataStage parallel jobs, QualityStage, Talend, Pentaho Data Integrator, Mainframe COBOL, Data Transformation, Cloud Integration (AWS S3, Snowflake)
  • Programming & Scripting: Python, PySpark, PL/SQL, SQL, UNIX Shell scripting (Korn, Bourne), Mainframe COBOL
  • Data Modeling & Reporting: Dimensional modeling (Star, Snowflake), Data Modeling Tools (ERwin), SQL, Power BI, Tableau, OBIEE
  • Automation & Job Scheduling: Control-M, Automic (UC4), GitLab, Jenkins, Process Automation, Python scripting for ETL jobs, Real-time Data Transformation
  • Database Systems: Oracle (9i–19c), DB2, Sybase, MS SQL Server, Teradata, Snowflake
  • Production Support & Troubleshooting: 24x7 support, Incident management, Performance tuning, Root Cause Analysis, Data Quality Assurance
  • Agile Development: Agile/Scrum methodologies, JIRA, Bitbucket, Sprint Planning, Requirements gathering
  • Cloud & Data Architecture: Hybrid Data Architectures, Cloud-based Data Integration (AWS, Snowflake), ETL optimization, Data Pipeline Automation
  • Communication & Collaboration: Cross-functional collaboration, Stakeholder management, Excellent verbal and written communication skills

Timeline

Senior DataStage ETL Developer

Atlantic Financial Services
04.2023 - Current

Lead DataStage Developer

Blue Ridge Auto Parts
01.2021 - 03.2023

Senior DataStage ETL Developer

Blue Cross Blue Shield
06.2018 - 12.2020

ETL Developer

Bharat Technical solutions
11.2012 - 05.2018

Similar Profiles

CREATE PROFILE
Ruchith Kumar