RAJESH KONAKALLA
Software Engineering
Delaware,OH
Summary
Results-driven IT professional with over 15 years of experience in software development, support analysis, and data engineering. Proven expertise in designing and implementing complex data-driven solutions, translating functional and non-functional requirements into scalable architectures, and driving full lifecycle Data Warehousing (DWH) projects—particularly within the finance domain.
Highly analytical and technically adept, with a strong track record of solving intricate business problems through innovative design and efficient execution. Skilled in data analysis, process optimization, and solution engineering, consistently delivering high-quality outcomes that enhance business performance.
Experienced in managing offshore teams, optimizing effort utilization, and ensuring timely, customer-focused deliverables. Adept at collaborating with cross-functional stakeholders and leveraging deep technical knowledge to guide product development from concept to deployment.
A dependable asset to any organization, committed to continuous improvement, technical excellence, and adding measurable value to business processes.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Applications Support Engineer
JP Morgan Chase & Co.
12.2023 - Current
- As a Production Support Analyst, I will be responsible for leading the Incident and Problem resolution for aligned LOBs, providing end-to-end resolution to ensure completion of all jobs within defined objectives. Troubleshoot production issues and coordinate with other teams to remediate and implement to production to minimize impact to customers and/or downstream.
- The role also involves engaging and partnering with Application Development teams, and various platform owners like TD, ETL, BI, etc. and interfacing with executive and sr. management with Root Cause Analysis (RCA) and remediation actions. The responsibility will include but not limited to following functions -
- End-to-end Incident and Problem resolution for responsible LOBs.
- Responsible to ensure that the applications met their required service levels
- Responsible to support process improvements to continuously improve the stability and performance of the applications.
- Weekend and evenings rotational support.
- Identify system bottlenecks and opportunities for betterment
- Perform service transition from development to support
- Prioritize workload, provide timely and accurate resolutions.
- Perform in-depth research and identify sources of production issues.
- Effectively perform root cause analysis of issues and report the outcome to business community and Management.
- Develop / utilize core support tools and processes to perform work while improving day-to-day practices for support team members with the goal of delivering service improvements to the business.
- Coordinate and work with the global production support team.
- Documenting the Legacy ETL Mapping Design.
- Promoting changes to testing environment for product and LOB teams to perform validations.
- Support to major Firmwide application within including EOL upgrades and working with build & Support partners to create a more resilient and stable applications.
- Maintain Business Process Indicator of 99.99% or higher. This includes monitoring of the environment, managing, tracking, and resolving Production issues.
- Responsible for generation of key metrics for different reporting work streams which are useful for senior management as needed.
- Partner closely with Application Development, Testing teams, all data consumers, and users on Projects or any Incidents.
- Participate in on-call rotation for application support, including weekends and off-hours.
- Improve productivity, supportability, and efficiency by automation of repeatable tasks using tools and scripting.
- Participate in Disaster Recovery events and Major Event Changes. Ensure infrastructure has adequate capacity and are refreshed on a periodic basis.
- Build and foster relationships across multiple organizations.
- Address production incidents on daily basis and fixing the issues to avoid the reoccurrence.
- Drive continuous improvement of services and processes inorder to increase application stability, improved operational efficiencies & Automation for continuous improvements.
- The operations require a diverse set of technologies and programming skills, including GOS, Oracle, Teradata, Hadoop, PySpark, AWS, Jules, Jenkins, Confluence, Jira, and several additional platforms.
- Role: Applications Developer (Dec 2023 – Till date)
- Applications: CCB
- Application Organization: IPM Production Management
- Current Employer: JP Morgan Chase & Co.
- Location: Columbus, OH, USA
Applications Developer
JP Morgan Chase & Co.
12.2022 - 12.2023
- Support to major Firmwide application within including EOL upgrades and working with build & Support partners to create a more resilient and stable applications.
- Maintain Business Process Indicator of 99.99% or higher. This includes monitoring of the environment, managing, tracking, and resolving Production issues.
- Responsible for generation of key metrics for different reporting work streams which are useful for senior management as needed.
- Partner closely with Application Development, Testing teams, all data consumers, and users on Projects or any Incidents.
- Participate in on-call rotation for application support, including weekends and off-hours.
- Improve productivity, supportability, and efficiency by automation of repeatable tasks using tools and scripting.
- Participate in Disaster Recovery events and Major Event Changes. Ensure infrastructure has adequate capacity and are refreshed on a periodic basis.
- Build and foster relationships across multiple organizations.
- Address production incidents on daily basis and fixing the issues to avoid the reoccurrence.
- Drive continuous improvement of services and processes inorder to increase application stability, improved operational efficiencies & Automation for continuous improvements.
- Working in an Agile software development framework to develop system and database solutions.
- Participation in the Scrum Model and for meeting the Client and Business needs.
- Designed technology programs in various languages including ETL, Pentaho, MSSQL, Oracle, BI Tools and Database to meet feature goals.
- Development of ETL flows, DB Procedures and standards using GOS, Oracle and Informatica.
- Setting-up Database and Data Models for Relational Database Management Needs.
- To Develop and facilitate the Source Configuring Repositories for ETL and BI tools
- Designed, developed, and implemented automated control frameworks to ensure the PAM work stream is operating effectively and according to detailed Business/Technical requirements
- Utilized Pentaho/Informatica and BI reporting tools to develop automated access frameworks that increase the efficiency and security of access to JPMC’s systems
- Performing Unit testing & UAT Testing of the code developed.
- Documenting the new Design and Enhancements for feasible knowledge Transfer.
- Participation in the Permit to Operate & Project Working Group sessions for connectivity between the Application Development & Support teams there by working towards the SRE Model.
- Gathering, analyzing, and ensuring business and technical requirements are met within automation platforms, frameworks, and risk control systems
- Promoting changes to testing environment for product and LOB teams to perform validations.
- Role: Applications Developer (Dec 2022 – Dec 2023)
- Applications: CCTDM Compliance – Corporate Technology
- Application Organization: Corporate Sector/Enterprise Technology/CORP OVERSIGHT AND GOVERNANCE TECH
- Current Employer: JP Morgan Chase & Co.
- Location: Columbus, OH, USA
Applications Developer
JP Morgan Chase & Co.
08.2019 - 12.2022
- Support to major Firmwide application within including EOL upgrades and working with build & Support partners to create a more resilient and stable applications.
- Maintain Business Process Indicator of 99.99% or higher. This includes monitoring of the environment, managing, tracking, and resolving Production issues.
- Responsible for generation of key metrics for different reporting work streams which are useful for senior management as needed.
- Partner closely with Application Development, Testing teams, all data consumers, and users on Projects or any Incidents.
- Participate in on-call rotation for application support, including weekends and off-hours.
- Improve productivity, supportability, and efficiency by automation of repeatable tasks using tools and scripting.
- Participate in Disaster Recovery events and Major Event Changes. Ensure infrastructure has adequate capacity and are refreshed on a periodic basis.
- Build and foster relationships across multiple organizations.
- Address production incidents on daily basis and fixing the issues to avoid the reoccurrence.
- Drive continuous improvement of services and processes inorder to increase application stability, improved operational efficiencies & Automation for continuous improvements.
- Working in an Agile software development framework to develop system and database solutions.
- Participation in the Scrum Model and for meeting the Client and Business needs.
- Designed technology programs in various languages including ETL, Pentaho, MSSQL, Oracle, BI Tools and Database to meet feature goals.
- Development of ETL flows, DB Procedures and standards using Pentaho and MSSQL
- Setting-up Database and Data Models for Relational Database Management Needs.
- To Develop and facilitate the Source Configuring Repositories for ETL and BI tools
- Designed, developed, and implemented automated control frameworks to ensure the PAM work stream is operating effectively and according to detailed Business/Technical requirements
- Utilized Pentaho/Informatica and BI reporting tools to develop automated access frameworks that increase the efficiency and security of access to JPMC’s systems
- Performing Unit testing & UAT Testing of the code developed.
- Documenting the new Design and Enhancements for feasible knowledge Transfer.
- Participation in the Permit to Operate & Project Working Group sessions for connectivity between the Application Development & Support teams there by working towards the SRE Model.
- Gathering, analyzing, and ensuring business and technical requirements are met within automation platforms, frameworks, and risk control systems
- Promoting changes to testing environment for product and LOB teams to perform validations.
- Role: Applications Developer (Aug 2019 – Dec 2022)
- Applications: CTC-CYBER GIAM ALM(Applications Life Cycle Management)
- Application Organization: GLOBAL IDENTITY & ACCESS MGMT
- Current Employer: JP Morgan Chase & Co.
- Location: Columbus, OH, USA
Applications Support Analyst
JP Morgan Chase & Co.
06.2015 - 08.2019
- Support to major infrastructure projects within including EOL upgrades and working with build partners to create a more resilient and stable applications.
- Maintain Business Process Indicator of 99.99% or higher. This includes monitoring of the environment, managing, tracking, and resolving incidents and escalations.
- Responsible for generation of key metrics for different reporting work streams which are useful for senior management in analysing the Business statistics and growth.
- Partner closely with Application Development, Testing teams, all data consumers, and users on Projects or any Incidents. Participate in on-call rotation for application support, including weekends and off-hours. Improve productivity, supportability, and efficiency by automation of repeatable tasks using tools and scripting.
- Configure and conduct Disaster Recovery events and Major Event Changes. Ensure infrastructure has adequate capacity and are refreshed on a periodic basis.
- Chair and participate in Project Working Group to improve production stability and Business Resiliency. Build and foster relationships across multiple organizations. Address production incidents on daily basis, performing the RCA and taking appropriate steps in preventing of reoccurrences.
- Drive continuous improvement of services and processes inorder to increase platform stability, improved operational efficiencies & Automation and continuous improvements in the environment.
- Role: Applications Support Analyst (June 2015 – Aug 2019)
- Applications: Centralized Production Support for CTR Applications - Cyber Security Applications
- Current Employer: JP Morgan Chase & Co.
- Location: Columbus, OH, USA
Project: Phoenix – Operational Risk Project
JP Morgan Chase & Co.
08.2012 - 05.2015
- Company Overview: JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $2 trillion and operations in more than 60 countries. The firm is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity.
- New Enhancements requirements gathering and analysis.
- Develop, deploy the Informatica PowerCenter/ Oracle & Business Objects.
- Functional analysis & Production fixes on the existing processes
- Data analysis to provide various results to business
- Design/Code review for modules in Informatica PowerCenter and Oracle
- Prepare detailed documentation for Informatica PowerCenter used applications like Design Documents, Run Books, Code & DB/ETL deployment Checklists and so on.
- Full control on the Database/ETL changes going on in the system.
- Proper checklist and validation of code maintenance through SVN, EQM.
- Core member in the Stabilization Project.
- DB/ETL regular refresh activities and Monitoring of Regular ETL Reporting Refresh activity.
- Responsibility of project role outs and implementations within the specified SLAs.
- Maintenance & monitoring of Upstream and downstream dataflow and fixing production issues.
- Guiding offshore and onshore on Database, ETL design & data issues and in bringing them to closure.
- Leads L2 analysis team. Guides L3 team in putting the valid and generic fix for the tickets.
- Environment: Informatica 9.1.0, Oracle 10g, Pl/Sql developer 3.0, Business Objects XI R3, Windows XP, SubVersion, Autosys, Linux, JIRA, EQM 4.0
Project: Phoenix – Operational Risk Project
Wipro ltd.
07.2011 - 08.2012
- Company Overview: JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $2 trillion and operations in more than 60 countries. The firm is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity.
- New Enhancements requirements gathering and analysis.
- Develop, deploy the Informatica PowerCenter/ Oracle & Business Objects.
- Functional analysis & Production fixes on the existing processes
- Data analysis to provide various results to business
- Design/Code review for modules in Informatica PowerCenter and Oracle
- Prepare detailed documentation for Informatica PowerCenter used applications like Design Documents, Run Books, Code & DB/ETL deployment Checklists and so on.
- Full control on the Database/ETL changes going on in the system.
- Leading Phoenix stabilization.
- DB/ETL regular refresh activities and Monitoring of Regular ETL Reporting Refresh activity.
- Responsibility of project role outs and implementations within the specified SLAs.
- Maintenance & monitoring of Upstream and downstream dataflow and fixing production issues.
- Environment: Informatica 8.6.1, Oracle 10g, Pl/Sql developer 3.0, Business Objects XI R3, Windows XP, SubVersion, Informatica Scheduler, EQM 4.0
Project: Phoenix – Operational Risk Project
Wipro Technologies.
08.2008 - 07.2011
- Company Overview: JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $2 trillion and operations in more than 60 countries. The firm is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity.
- Interacted with business users to gather requirements and prepared design documents(HLD & LLD)
- Developing ETL code based on requirements.
- Created and Implemented performance tuning techniques like:
- Tuned source qualifier queries to make use of indexes.
- For Heavy data, created Oracle Stored Procedures and created temporary mappings to execute the same as part of Daily ETL Refresh Activities.
- Used bulk load whenever feasible.
- Followed the SCD 2 and change data capture (CDC) technique for Clients Requirements.
- Implemented dependency between workflows by using event-wait task.
- Used Informatica schedulers to – run continuously, run at fixed time, run on demand.
- Developed create & delete indexes on temp tables technique, to improve the performance of a stored procedure significantly.
- Created around 20 Procedures as part of Migration and almost converted the important Self-Assessment Existing Application logic into Database Stored Procedures for Migrating the CSA source data to ASA for Association purpose.
- Environment: Informatica 8.1.1, Oracle 9i.
Education
Bachelor’s of Technology -
JNT University
Higher Secondary - undefined
Siddhartha Vidyalaya
Skills
- Proficient in SQL database management
- Proficient in data warehousing practices
- Experienced ETL developer using Informatica
- Advanced Oracle programming skills
- SQL database developer
- Reporting solutions developer
- Data visualization skills
- Experience with Python - Pandas, Streamlit and PySpark
- Familiarity with Databricks tools
- AWS Cloud Practitioner Certification Holder
- Proficient in DPL pipeline management with AWS support
- Knowledgeable in ETL tool integration
- Proficient in Unix shell scripting
- Skilled in using Autosys and Control-M for task scheduling
- Skilled in production support operations
- Proficient in Liquibase for CI/CD processes in Oracle environments
- Knowledgeable in agile and waterfall methodologies
- Informatica workflow design and implementation
- Oracle database programming
- BI – BO-XIR3 Development/Support
- Data analysis expertise
- Proficient in conducting code and design reviews
- Effort/Resource Management
- SDLC & Agile methodologies
- Enhancing task efficiency through automation
- Constructing structured task hierarchies
- Proficient in impact analysis
- Effective Work Progress Tracking
- Consistently meet deadlines
- Experienced with Microsoft Excel
- Unix Shell scripting
- Security protocols
- Automated processes
- Technical troubleshooting
- Process automation
- Performance tuning
- Quality assurance
- Disaster recovery
- Root cause identification
- Performance evaluation
- Application monitoring
- Server maintenance
- Incident management
- Software development
- User support
PROJECT MANAGEMENT
- Supervised a team of 4 offshore developers (new to IT industry) for a critical implementation project and post-implementation support in an unexpected complex time.
- Coordinated with multiple customers (AM DASHBOARD, RADAR (CONTROL ROOM)) on a daily basis.
- Planned and supervised training and transition of new resources as part of team building and mentoring.
- Documentation of business processes, system architecture, technical system support guides and technical support handbooks (including business decisions and assumptions)
- Involved in Integrated Test Plans for the testing team and the user acceptance testing (UAT).
- Compiled and managed project estimations, capacity planning and resource/effort estimations, defect management based on the Service Level Agreement (SLA) for reviews and quality audits.
- Provided suggestions to business owners explaining Fast Tracking and thus shrinking the overall project deadlines
- Demonstrated team ability to work under pressure, conflicting priorities and achieve aggressive delivery schedule.
Certification
AWS Cloud Practitioner
Languages
English
Native or Bilingual
Telugu
Native or Bilingual
Timeline
Applications Support Engineer
JP Morgan Chase & Co.
12.2023 - Current
Applications Developer
JP Morgan Chase & Co.
12.2022 - 12.2023
Applications Developer
JP Morgan Chase & Co.
08.2019 - 12.2022
Applications Support Analyst
JP Morgan Chase & Co.
06.2015 - 08.2019
Project: Phoenix – Operational Risk Project
JP Morgan Chase & Co.
08.2012 - 05.2015
Project: Phoenix – Operational Risk Project
Wipro ltd.
07.2011 - 08.2012
Project: Phoenix – Operational Risk Project
Wipro Technologies.
08.2008 - 07.2011
Higher Secondary - undefined
Siddhartha Vidyalaya
Bachelor’s of Technology -
JNT University
Similar Profiles
Lisa Olivia GrenviczLisa Olivia Grenvicz
Private Client Banker at JP Morgan Chase & Company (Chase Bank)Private Client Banker at JP Morgan Chase & Company (Chase Bank)
Taylor SimsTaylor Sims
Client Services Specialist & Associate Banker at JP Morgan Chase & Chase BankClient Services Specialist & Associate Banker at JP Morgan Chase & Chase Bank
Miranda GuerreroMiranda Guerrero
Associate Banker Market Expansion at Jp Morgan Chase ChaseAssociate Banker Market Expansion at Jp Morgan Chase Chase
Mahesh TelgadiMahesh Telgadi
Team Leader at JP Morgan Chase pvt LtdTeam Leader at JP Morgan Chase pvt Ltd
Dylan MurphyDylan Murphy
Care and Enrichment Technician at American Society for Prevention of Cruelty to Animals (ASPCA), Cruelty Recovery CenterCare and Enrichment Technician at American Society for Prevention of Cruelty to Animals (ASPCA), Cruelty Recovery Center