Ramkumar Ponnurangam
Ajax,ON
Summary
Accomplished Senior ETL Developer with a proven track record at Royal Bank of Canada, RBC, enhancing data workflows and driving a data-driven culture. Expert in Data Warehousing and SQL Programming, I've spearheaded several ETL development, significantly improving data accuracy. My problem-solving skills have been pivotal in optimizing data processes, showcasing a commitment to excellence and innovation. 14+ years of diverse experience in the field of Information Technology with emphasis on Data ware housing and ETL development in banking and financial domains in agile methodology. · Strong technical knowledge and experience in ETL- IBM DataStage (DataStage Designer, DataStage Director and Administrator), SQL Programming (Teradata, SQL Server, Oracle, Spark SQL), ZEKE and Devops tools-Github,Jenkins,IBM Urbancode Deploy.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Senior Datastage Developer
Royal Bank of Canada, RBC
05.2018 - Current
- Acted as expert technical resource to programming staff in program development, testing and implementation process.
- ·Spearhead and co-ordinate the overall ETL development process of IFRS9 application which feeds data into Enterprise Risk Data Lake- ERDL and also EFTR Transaction reporting.
- Design, Develop and unit test jobs to build Datawarehouse using DataStage jobs.
- Build Common Framework to reuse entire Datastage pipeline for different sources with Metadata feed.
- Intensively used Shell scripting to build wrapper scripts to perform File transmission through S3 Bucket.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Developed efficient stored procedures and BTEQ Scripts for complex business logic, reducing processing time and improving system stability.
- Enhanced database performance by optimizing SQL queries and indexing strategies.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Increased efficiency through the automation of routine tasks using shell scripting and cron jobs.
- Increased accuracy in data analysis by creating robust, reusable ETL pipelines to clean and transform raw data into usable formats.
- Streamlined workflow processes by automating repetitive tasks using Unix shell scripting.
- Assisted in driving a data-driven culture within the organization by evangelizing the value of big data analytics to key stakeholders across various departments.
- Expertise in Data Warehousing/ETL programming and fulfillment of data warehouse project tasks such as existing data analysis, data extraction, cleansing, transforming and loading.
- Implemented ETL process to read/write data to Data lake using HDFS files (AVRO, parquet) and Hive DB.
- Develop plans, strategies and standards for data within the AML systems.
- Analyze and fix that ingestion issues to Data Lake in form parquet files and Hive db.
- Co-ordinates Release Management Activities for ETL deliverables between Change the Bank, Run the Bank, Project Stakeholders and Business users.
- Provide guidance for business by creating various type of views in Hive.
- Estimate and provide proposal for new data pipelines
- Optimized ETL performance by identifying bottlenecks and streamlining workflows.
- Solved complex business problems by developing custom ETL strategies tailored to specific needs.
- Implemented automation within ETL processes to reduce manual tasks and improve efficiency.
- Developed complex SQL queries for improved data extraction and accurate reporting.
- Enhanced data integration by designing and implementing efficient ETL processes.
- Implemented robust error handling techniques, resulting in fewer data discrepancies during the ETL process.
- Conducted thorough testing of developed solutions, ensuring optimal performance upon deployment.
- Reduced maintenance costs by creating reusable components within ETL pipelines.
- Increased application performance by identifying bottlenecks and optimizing algorithms through profiling tools.
- Reduced project delivery time by efficiently managing tasks using JIRA, prioritizing urgent issues, and maintaining open communication with the team.
- Collaborated effectively with cross-functional teams including QA engineers, business analysts, architects, UX/UI designers, and product managers.
- Optimized deployments by automating repetitive tasks using scripting languages like Python or Bash for increased operational efficiency.
- Enhanced delivery quality by implementing Agile methodologies and participating in daily stand-up meetings.
- Assisted software engineering team to develop solutions in Agile environment.
Data Engineering Lead
Ally Financial Inc.
05.2016 - 05.2018
- Setting up ETL jobs to fetch data from Teradata through Datastage connections
- Tech lead and coordinator for ERDL Data ingestion development team by onboarding them on to pipeline of continuous integration and delivery. Automated deployment of DataStage, Shell and Hive artifacts through scripts for IFRS9 Project.
- Develop plans, strategies and standards for data within enterprise data service
- Design, Develop and unit test jobs to build Datawarehouse using DataStage jobs for IFRS9 feeds
- Analyze and fix that ingestion issues to Data Lake in form avro, parquet files and Hive db.
- Performed unit to integration testing on Hadoop platform using HIVE, ETL testing using Data Stage, SQL and SHELL programming.
- Increased efficiency through the automation of routine tasks using shell scripting and cron jobs.
- Increased accuracy in data analysis by creating robust, reusable ETL pipelines to clean and transform raw data into usable formats.
- Streamlined workflow processes by automating repetitive tasks using Unix shell scripting.
- Collaborated effectively with cross-functional teams including QA engineers, business analysts, architects, UX/UI designers, and product managers.
- Optimized deployments by automating repetitive tasks using scripting languages like Python or Bash for increased operational efficiency.
- Enhanced delivery quality by implementing Agile methodologies and participating in daily stand-up meetings.
Senior Data Engineer
HTC Global Services
04.2014 - 05.2016
- Collaborated with cross-functional teams to define requirements and develop end-to-end solutions for complex data engineering projects.
- Evaluated emerging technologies and tools to identify opportunities for enhancing existing systems or creating new ones.
- Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
- Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
Data Engineer II
HP Global Soft
08.2010 - 04.2014
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
Education
MBA - International Business Management
Madras University
01.2011
Bachelor in Engineering - Electronics And Communication
Anna University
05.2010
Skills
- ETL development - DataStage
- SQL Databases - Teradata, SQL Server, Sybase, SnowFlake, Oracle
- Unix Shell Scripting
- Scala Programming
- Apache Spark
- Hadoop Ecosystem
- Mainframe
- Control-M
- Hive
- AGILE Tools - Jenkins/GitHUB/JIRA/Helios
- Data Engineering
- Data Warehousing
- Performance Tuning
- Problem-Solving
Languages
English
Full Professional
Tamil
Native or Bilingual
Certification
- Certified IBM Datastage Solution Developer.
- Certified Teradata Solution Specialist.
Timeline
Senior Datastage Developer
Royal Bank of Canada, RBC
05.2018 - Current
Data Engineering Lead
Ally Financial Inc.
05.2016 - 05.2018
Senior Data Engineer
HTC Global Services
04.2014 - 05.2016
Data Engineer II
HP Global Soft
08.2010 - 04.2014
MBA - International Business Management
Madras University
Bachelor in Engineering - Electronics And Communication
Anna University