Software Engineer - ETL & Data Warehousing
Resume:
Charlotte, US • *************@*****.*** • 312-***-**** • linkedin.com/in/jayaprakash-kesavan-65023b77
JAYAPRAKASH KESAVAN
Software Engineer
PROFESSIONAL SUMMARY
Software Engineer building resilient ETL pipelines and enterprise data warehouses using Oracle PL/SQL, Informatica, and Python automation to improve reporting accuracy and operational visibility. Leads development of data quality dashboards, executive level reports, and performance tuning initiatives that reduce query times and enforce strong data governance. Mentors teams, prepares ADO based estimates, and coordinates with application partners to ensure consistent, high quality delivery across complex data environments.
EMPLOYMENT HISTORY
SOFTWARE ENGINEER
Jan 2023 – Jul 2026
Bank of America
Charlotte, NC
Analysis of User/system/functional Requirements and functional Requirements preparation based on business user needs.
Provide prototype to dashboard and report development team.
Provide database object, Record Set, Scripts for Report development team.
Review, Consolidate and Guide reporting team.
Development of Data Quality executive report and dashboards.
Development of Data Quality operations reports to track the application performance.
Application Partner Coordination and Point of Contact.
Training, Knowledge Transfer, Audit and Daily Meetings and interaction.
Project Estimate Preparation based on team size, task, deadline using Microsoft Dev-ops [ADO].
Preparing design document with source and target table mapping, Code review, Informatica development.
Developed stored procedures and complex packages extensively using PL/SQL and shell programs.
Developed and Created Database Objects in OLTP and OLAP Systems by Creating triggers, packages, procedures and functions using PL/SQL.
Optimal in loading data from various Flat files using SQL* Loader and implementing Data Cleansing Procedures.
Well Experienced in Tuning SQL Queries, Database Objects on OLTP Systems by Creating Indexes, Optimizers, and Hints and analyzing the Explain Plan.
Building Data warehouse by summarizing the Data on Yearly Granularity and Populating the Data in Star Schema and Snowflake Schema.
Maintaining and organizing the Data warehouse Building in Hierarchical level as per the Business Rules of data management.
Performing Performance Tuning on the SQL Queries using TKPROOF utility.
Developing the Scrips by Using Unix Shell Scripting.
Reviewing Unit Test Plan & Results.
Delegating the task to the Team and preparing the check list for the same.
Participating in the daily status call with the offshore team to work in sync with the team on their understanding level by each individual item.
Designed and developed 50+ ETL mappings and workflows to integrate data from Oracle, SQL Server, and flat files into the enterprise data warehouse.
Implemented incremental loads, CDC logic, and reusable transformations to standardize ETL processes.
Improved ETL performance by 40% through mapping optimization, pushdown processing, and SQL tuning.
Built automated error handling, logging, and workflow recovery mechanisms to ensure high reliability.
Developed Python automation scripts to streamline repetitive database tasks, reducing manual effort and improving operational efficiency.
Built Python utilities for log parsing, error detection, and automated notifications to support production monitoring.
Automated data validation workflows using Python to ensure completeness, accuracy, and consistency across ETL pipelines.
Integrated ETL pipelines with data governance rules, data quality checks, and secure data handling practices.
Collaborated with business teams to define data requirements, lineage, and validation rules for critical datasets.
SR SOFTWARE DEVELOPER
Jun 2022 – Dec 2022
Duke Energy
Charlotte,NC
Coordinated and implemented Trading and Fuels application configuration changes and deployments.
Managed change requests and ensured compliance with organizational change management standards.
Developed and supported Oracle databases using PL/SQL and performed SQL troubleshooting.
Designed, developed, and maintained .NET/C# applications and MSRS reports.
Monitored application performance, system health checks, and production environments.
Provided 24x7 on-call support and resolved production incidents within SLA requirements.
Led troubleshooting efforts for complex application, database, and system issues.
Performed root cause analysis and implemented preventive solutions for recurring problems.
Supported code migration, release management, and deployment activities across environments.
Processed QA documentation and change records for application enhancements and support releases.
Conducted code reviews, design walkthroughs, and ensured adherence to coding and source control standards.
Collaborated with business stakeholders to analyze requirements and estimate work efforts.
Mentored support and development team members while providing technical guidance.
Coordinated response activities for critical incidents, system disruption events, and major outages.
Communicated application status, system issues, and change activities to business and IT stakeholders.
Managed multiple support and development initiatives while maintaining system reliability and operational excellence.
SOFTWARE ENGINEER
Dec 2020 – May 2022
Bank of America
Charlotte, NC
Analysis of User/system/functional Requirements and functional Requirements preparation based on business user needs.
Provide prototype to dashboard and report development team.
Provide database object, Record Set, Scripts for Report development team.
Review, Consolidate and Guide reporting team.
Development of Data Quality executive report and dashboards.
Development of Data Quality operations reports to track the application performance.
Application Partner Coordination and Point of Contact.
Training, Knowledge Transfer, Audit and Daily Meetings and interaction.
Project Estimate Preparation based on team size, task, deadline using Microsoft Dev-ops [ADO].
Preparing design document with source and target table mapping, Code review, Informatica development.
Developed stored procedures and complex packages extensively using PL/SQL and shell programs.
Developed and Created Database Objects in OLTP and OLAP Systems by Creating triggers, packages, procedures and functions using PL/SQL.
Optimal in loading data from various Flat files using SQL* Loader and implementing Data Cleansing Procedures.
Well Experienced in Tuning SQL Queries, Database Objects on OLTP Systems by Creating Indexes, Optimizers, and Hints and analyzing the Explain Plan.
Building Data warehouse by summarizing the Data on Yearly Granularity and Populating the Data in Star Schema and Snowflake Schema.
Maintaining and organizing the Data warehouse Building in Hierarchical level as per the Business Rules of data management.
Performing Performance Tuning on the SQL Queries using TKPROOF utility.
Developing the Scrips by Using Unix Shell Scripting.
Reviewing Unit Test Plan & Results.
Delegating the task to the Team and preparing the check list for the same.
Participating in the daily status call with the offshore team to work in sync with the team on their understanding level by each individual item.
Designed and developed 50+ ETL mappings and workflows to integrate data from Oracle, SQL Server, and flat files into the enterprise data warehouse.
Implemented incremental loads, CDC logic, and reusable transformations to standardize ETL processes.
Improved ETL performance by 40% through mapping optimization, pushdown processing, and SQL tuning.
Built automated error handling, logging, and workflow recovery mechanisms to ensure high reliability.
Developed Python automation scripts to streamline repetitive database tasks, reducing manual effort and improving operational efficiency.
Built Python utilities for log parsing, error detection, and automated notifications to support production monitoring.
Automated data validation workflows using Python to ensure completeness, accuracy, and consistency across ETL pipelines.
Integrated ETL pipelines with data governance rules, data quality checks, and secure data handling practices.
Collaborated with business teams to define data requirements, lineage, and validation rules for critical datasets.
SR. PL/SQL/INFORMATICA DEVELOPER
Oct 2015 – Dec 2020
Crown Castle
Canonsburg, PA
Analyzed user and system requirements and produced detailed functional specs to guide development.
Prepared project estimates in ADO based on team capacity, tasks, and deadlines to align delivery.
Authored design documents with source-to-target mappings and performed code reviews for ETL clarity.
Developed PL/SQL stored procedures and packages to support backend data processing and integrations.
Created database objects (triggers, procedures, functions, packages) across OLTP and OLAP environments.
Loaded flat-file data with SQL*Loader and implemented data cleansing routines to improve data quality.
Optimized SQL queries and database objects with indexes and hints to improve OLTP performance.
Designed and populated star and snowflake schemas to build a yearly-granularity data warehouse.
Organized hierarchical data warehouse structures to enforce business data management rules.
Tuned query performance using TKPROOF to reduce execution time and resource usage.
Wrote Unix shell scripts to automate ETL tasks and deployment steps for repeatable runs.
Reviewed unit test plans and results to validate ETL logic and data integrity.
Assigned tasks and maintained checklists to coordinate team work and track completion.
Coordinated daily status calls with offshore teams to align understanding and progress on items.
Developed Informatica mappings, mapplets, tasks, and APIs to support ETL workflows.
SR. PL/SQL/ DATABASE DEVELOPER
Jan 2014 – Oct 2015
CIGNA
Wilmington, DE
Developed stored procedures and complex packages extensively using PL/SQL and shell programs.
Developed and Created Database Objects in OLTP and OLAP Systems by Creating triggers, packages, procedures and functions using PL/SQL.
Optimal in loading data from various Flat files using SQL* Loader and implementing Data Cleansing Procedures.
Well Experienced in Tuning SQL Queries, Database Objects on OLTP Systems by Creating Indexes, Optimizers, Hints and analyzing the Explain Plan.
Building Data warehouse by Summarizing the Data on Yearly Granularity and Populating the Data in Star Schema and Snowflake Schema.
Maintaining and organizing the Data warehouse Building in Hierarchical level as per the Business Rules of data management.
Performing Performance Tuning on the SQL Queries using TKPROOF utility.
Developing the Scrips by Using Unix Shell Scripting.
Reviewing Unit Test Plan & Results.
Delegating the task to the Team and preparing the check list for the same.
Participating in the daily status call with the offshore team to work in sync with the team on their understanding level by each individual item.
EDUCATION
BACHELOR OF TECHNOLOGY DEGREE (B.TECH) IN INFORMATION TECHNOLOGY
Adiprasakthi Engg College, Madras of University
Chennai, India
COURSES
ORACLE DATABASE 11G: PERFORMANCE TUNING CERTIFICATION
Oracle University
ORACLE OCA LEVEL 1 CERTIFICATION
Oracle University
BANKING AND INVESTMENT SERVICES FOUNDATION COURSE & L0 CERTIFICATION
Cognizant Academy
AI ML
Feb 2026 – Present
Up Level
SKILLS
Informatica IICS, Pro*c, UNIX, SQL, PL/SQL, Hadoop, Spark, Kafka, SQL* Loader, Data Cleansing, Data Modeling, Data Warehousing, ETL, Unix Shell Scripting, Performance Tuning, Agile Methodologies, Machine Learning, Leadership, Communication, Mentoring, Data Visualization, Data Governance, Data Quality, Informatica, Python, AI ML, Oracle 19C
Contact this candidate