Dechamma UC
Bengaluru
Summary
Dynamic Senior NAS Storage Engineer with expertise in T-SQL and Agile methodologies, driving successful ETL processes at JP Morgan Chase & Co. Proven track record in optimizing database performance and enhancing data integration efficiency. Recognized for innovative problem-solving and delivering tailored solutions that meet client needs.
Overview
12
12
years of professional experience
Work History
Senior NAS Storage Engineer/ETL Developer
JP Morgan Chase & Co
01.2024 - Current
- Developed the T-SQL procedures and SQL Server Agent jobs.
- Developed mappings to load the target tables, such as stage, dimension, and fact tables.
- Developed views and temporary tables in SQL Server as per the requirement.
- Involved in preparing the specification documents for individual mapping customization.
- Developed ETL processes using SSIS packages for loading data from various sources into a data warehouse environment.
- Conducted unit testing of all database objects before deployment.
- Directed programming and documentation development team, offering insight into design process and procedures.
- Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
- Developed stored procedures to support application requirements.
- Created database objects such as tables, indexes, and synonyms.
- Developed technical specifications and plans, documenting details into user manuals for future reference.
- NetApp to C-Mode Migration: Involved in NetApp C-Mode planning, implementation, and migration of volumes.
- EMC Isilon Migration - Involved in planning and migration of volumes to Isilon
Senior Solution Lead
MResult Services Pvt. Ltd
Bengaluru
04.2022 - 11.2022
- Created mappings and workflows for loading target tables including stage, dimension, and fact tables.
- Developed stored procedures, views, and temporary tables in SQL Server according to requirements.
- Prepared specification documents for mapping customization to meet project needs.
- Utilized Agile methodologies to enhance project delivery efficiency.
- Contributed innovative ideas to improve team performance and outcomes.
- Collaborated effectively within teams to boost workplace productivity.
- Executed daily duties with accuracy and efficiency.
- Identified customer needs promptly to deliver tailored solutions.
ASSOCIATE
JP Morgan Chase & Co
Bengaluru
08.2017 - 04.2022
- Executed comprehensive SDLC phases from requirement gathering through production deployment.
- Developed business logic using SQL and T-SQL procedures in SQL Server 2008 R2.
- Implemented database structures in production environments, enhancing data accessibility.
- Managed planning and migration of volumes during NetApp 7 mode to C-Mode transition.
- Coordinated volume migration from NetApp 7 mode to EMC Isilon via StorageX Migration Tool.
- Promptly addressed customer needs through timely issue resolution.
- Conducted rigorous testing across multiple environments to validate system functionality.
- Collaborated with teams to optimize project workflows and deliver results efficiently.
PROJECT ASSOCIATE
Pride technologies Consulting India Pvt. Ltd
Bengaluru
02.2017 - 08.2017
- Evaluated requirements and collaborated with internal teams to define project scope.
- Gathered and analyzed business processes to identify optimal solutions and conduct impact analysis.
- Demonstrated comprehensive knowledge of SDLC phases, including requirement gathering and testing.
- Developed T-SQL procedures to enhance database functionality.
- Conducted performance tuning for SQL queries and SSIS packages to improve efficiency.
- Deployed database structures in production environments, ensuring operational readiness.
- Created SSIS packages to automate data integration workflows.
- Served as primary contact for deliverable inquiries, facilitating problem resolution and smooth operations.
SOFTWARE ENGINEER
Fidelity Investments Pvt. Ltd
Bengaluru
09.2016 - 01.2017
- Gathered data requirements to inform project specifications.
- Engineered T-SQL stored procedures, views, and temporary tables for efficient data audits.
- Constructed mappings for seamless loading into target tables.
- Reviewed audit results with internal teams and clients for clarity and alignment.
- Developed high-quality, tested code across multiple software projects.
SENIOR SOFTWARE DEVELOPER
MResult Services Pvt. Ltd
Bengaluru
03.2013 - 09.2016
- Developed T-SQL procedures and SQL Server Agent jobs to enhance data processing efficiency.
- Created mappings for loading target tables, including Stage, Dimension, and Fact tables.
- Monitored job execution to ensure reliability and performance of processes.
- Engineered stored procedures, views, and temporary tables in SQL Server based on requirements.
- Prepared specification documents for customized mapping solutions.
- Established jobs for initial (full load) and daily load packages; monitored performance.
- Developed SSIS packages and SSRS reports to support data integration needs.
- Conducted testing and deployment of SSIS packages while creating comprehensive technical documentation.
Education
Bachelor of Engineering - Information Science Engineering
VTU
01.2012
Skills
- T-SQL
- RDBMS
- SQL SERVER 2008
- SQL SERVER 2014
- Agile methodology
- Windows 7
- SSIS 2008 R2
- SSRS
- SSIS 2012
- Informatica 951
- SQL
Languages
- English
- Kannada
- Hindi
Timeline
Senior NAS Storage Engineer/ETL Developer
JP Morgan Chase & Co
01.2024 - Current
Senior Solution Lead
MResult Services Pvt. Ltd
04.2022 - 11.2022
ASSOCIATE
JP Morgan Chase & Co
08.2017 - 04.2022
PROJECT ASSOCIATE
Pride technologies Consulting India Pvt. Ltd
02.2017 - 08.2017
SOFTWARE ENGINEER
Fidelity Investments Pvt. Ltd
09.2016 - 01.2017
SENIOR SOFTWARE DEVELOPER
MResult Services Pvt. Ltd
03.2013 - 09.2016
Bachelor of Engineering - Information Science Engineering
VTU
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)
Miranda GuerreroMiranda Guerrero
Associate Banker Market Expansion at Jp Morgan Chase ChaseAssociate Banker Market Expansion at Jp Morgan Chase Chase
Antara GuhaAntara Guha
Senior Product Manager at JP Morgan ChaseSenior Product Manager at JP Morgan Chase
Vanessa CardenasVanessa Cardenas
Branch Operations Lead at JP Morgan & ChaseBranch Operations Lead at JP Morgan & Chase
Yaman KalraYaman Kalra
Senior Project Manager at Define LabsSenior Project Manager at Define Labs