Sumalatha

Insightful ETL Architect known for high productivity and efficient task completion. Skilled in data integration, warehouse design, and performance tuning to ensure seamless flow and storage of information. Excel in problem-solving, teamwork, and communication, leveraging these soft skills to facilitate effective collaboration across technology teams. Demonstrates adaptability in rapidly changing environments, ensuring project objectives are met with precision and timeliness.

• Informatica Certified Developer
• Certified SQL Developer - OCA Certification paper 1(Introduction to SQL)
• Certified AWS Solution Architect

Title: Engineering Manager, ETL Lead, Big Data Developer

• FIMC award for CISCO Project
• Pat on the back award for contributions in the RADAR project handled
• Star of the Month award for the month of July2010 for SAFECO BI Support project
• Appreciations from Client (BOA) in very short time

Associate, July 2016 – Present

JPMorgan Chase & Co, Hyderabad.

Project -1: July 2016 - Present

Title: Risk Assessment, Data Analytics and Reporting (RADAR)

Client: Internal Application.

Software: Informatica 9.6, 10.2 & 10.4.1, 10.5.5, Oracle & GOS (GAIA Oracle Service), UNIX, Autosys, Python Scripting, Pentaho.

Duration: Jul 2016 – Present

Location: Hyderabad

Responsibilities:

· Engineering Manager driving the delivery of end to end data warehousing solution. 

. Collaborated with Product Owner and other business stakeholders in gathering the requirements.

· Managing and coaching the team of 6 members.

. Designing solutions for visualization and downstream data consumption using GraphQL.

· Architected ETL Audit Framework & Threshold validation implementations.

· Involved in code reviews for all the code.

· Troubleshooting Informatica related problems encountered by developers.

· Review the mappings and tuning them if necessary (Mapping level and Session level).

· Automated Informatica, UNIX Deployment using AIM/Jules.

· Automated Oracle Deployment using Liquibase.

· Upgraded Informatica from 9.6 to 10.2 and then 10.4.

· Database Migration to Cloud Oracle Service.

· Acted as single point of contact at the time of Production Releases.

· Involved in developing POC (piece of code) for new requirements.

· Extensively involved in developing Informatica mappings/workflows.

· Involved in Unit Testing and Integration Testing.

Associate, April 2012 – June 2016

Cognizant Technology Solutions, Hyderabad.

Project -3: July 2015 - Present

Title: CNO ADM Transition - Landing Zone

Client: CNO Financial Group.

Software: Informatica 9.1, Oracle, UNIX, Harvest, Autosys, Informatica DVO.

Duration: Jul 2015 – Present

Location: Hyderabad

Responsibilities:

· Involved in gathering the requirements from the Client/Onshore Counterparts.

· Managed the team of 5 members at offshore.

· Involved in preparing LLDs (Low Level Design documents).

· Extensively involved in developing Informatica mappings/workflows.

· Involved in Unit Testing and Integration Testing.

· Involved in peer reviews for all the code.

· Sorting out all Informatica related problems encountered by developers.

· Review the mappings and tuning them if necessary (Mapping level and Session level).

· Developed mappings using various transformations like Connected and Unconnected lookups, Update strategy, Aggregator, Router, Filter, Joiner and Expression transformation.

· Performance Tuning in Informatica.

· Acted as single point of contact at the time of Production Release.

· Involved in developing POC (piece of code) for new requirements.

Project -2: Feb 2015 – June 2015

Title: Gladius

Client: Electronic Arts Inc.

Software: Informatica 9.1, 9.5 Oracle, UNIX.

Duration: Feb 2015 – Present

Location: Hyderabad

Responsibilities:

· Involved in gathering the requirements from the Client/Onshore Counterparts.

· Managed the team of 3 members at offshore.

· Involved in preparing LLDs (Low Level Design documents).

· Extensively involved in developing Informatica mappings/workflows.

· Involved in Unit Testing and Integration Testing.

· Involved in peer reviews for all the code.

· Sorting out all Informatica related problems encountered by developers.

· Review the mappings and tuning them if necessary (Mapping level and Session level).

· Developed mappings using various transformations like Connected and Unconnected lookups, Update strategy, Aggregator, Router, Filter, Joiner and Expression transformation.

· Performance Tuning in Informatica.

· Acted as single point of contact at the time of Production Release.

· Involved in developing POC (piece of code) for new requirements.

Project -1: April 2012 – August 2014

Title: CWM – Data Initiative Phase – 1&2 (Chase Wealth Management)

Client: JP Morgan Chase

Software: Informatica 9.1, Teradata, UNIX, Control-M.

Duration: April2012 to till date

Location: Hyderabad

Responsibilities:

· Involved in gathering the requirements from the Client/Onshore Counterparts.

· Managed the team of 6 members at offshore.

· Involved in preparing LLDs (Low Level Design documents).

· Extensively involved in developing Informatica mappings/workflows.

· Implemented SCD-2 and SCD-1 Type logics in the mappings.

· Involved in Unit Testing and Integration Testing.

· Involved in peer reviews for all the code.

· Sorting out all Informatica related problems encounters by developers.

· Review the mappings and tuning them if necessary (Mapping level and Session level).

· Developed mappings using various transformations like Connected and Unconnected lookups, Update strategy, Aggregator, Router, Filter, Joiner and Expression transformation.

· Performance Tuning in Informatica.

· Usage of UNIX to execute the workflows.

· Acted as single point of contact at the time of Production Release.

· Supported the Onshore team on weekends for code migrations and running the workflows.

· Involved in developing POC (piece of code) for new requirements.

Systems Engineer, August 2011 – April 2012
Tata Consultancy Services, Hyderabad.

Project -1:

Title: MIS – GoR (Globalization of Reporting)

Client: Bank of America

Software: Informatica 8.6, Netezza, Oracle, UNIX.

Modules: Payments, Trade and Credit

Duration: August2011 to April2012

Location: Hyderabad

Responsibilities:

· Involved in preparing LLDs (Low Level Design documents).

·  Extensively involved in developing Informatica mappings/workflows.

· Implemented SCD-2 and SCD-1 Type logics in the mappings.

· Involved in Unit Testing and Integration Testing.

· Involved in peer reviews for all the code.

· Sorting out all Informatica and Netezza related problems encounters by developers.

· Review the mappings and tuning them if necessary (Mapping level and Session level).

· Developed mappings using various transformations like Connected and Unconnected lookups, Update strategy, Aggregator, Router, Filter, Joiner and Expression transformation.

· Performance Tuning in Informatica, Netezza.

· Minimal usage of UNIX to execute the workflows.

· Acted as single point of contact at the time of Production Release of one of the Data Mart.

· Supported the Client team on weekends for code migrations and running the workflows.

· Involved in developing POC (piece of code) for new requirements.

Software Engineer, May 2010 – August 2011
Accenture Services Pvt Ltd, Hyderabad.

Project -1:

Title: SAFECO BI Support

Client: Liberty Mutual

Software: Informatica 8.6, Teradata, UNIX, ESP Scheduling tool, DB2.

Duration: May2010 to till date

Location: Hyderabad

Responsibilities:

· Analyze client’s requests for new enhancement requests.

· Implement ETL (Extract-Transform-Load), Code Review all the requirements for the upcoming modules.

· Plan, develop and test proposed enhancements with client interaction for verification.

· Developing and modifying mappings in Informatica and Teradata.

· Creation of Design documents as per business requirements.

· Modifying the existing Scripts in UNIX.

· Involved in Unit Testing, Integration Testing.

· Identifying the jobs to be scheduled in ESP tool.

· Involved in migrating Informatica objects and scripts from Dev to Test and Stage and Production environments using ESP tool.

· Work on reducing re-occurring failures and provide permanent fix to the same.

Project Engineer, March2008 - Aug2009

Software Engineer, Aug 2009 - May 2010

Wipro Technologies, Hyderabad.

Project -1:

Title: PMC 2.0

Client: CISCO

Software: Informatica 8.6, Oracle 9i, Pvcs, Kintana, UNIX, Dollar Universe 5.3

Duration: March 2008 to till date

Location: Hyderabad

Responsibilities:

· Involved in gathering Functional Requirements.

· Creation of Design documents and mapping specs as per business requirements.

· Sorting out all Informatica, Oracle related problems encounters by developers and testers.

· For few modules, Single point of contact at offshore to communicate with client in resolving queries, decision making etc (Any Functional Changes, Code Changes).

· Review the mappings and tuning them if necessary (Mapping level and Session level).

· Developed mappings using various transformations like Connected and Unconnected lookups, Update strategy, Aggregator, Router, Filter, Joiner and Expression transformation.

· Involved in Unit Testing, Integration Testing.

· Performance Tuning in Informatica, Oracle.

· Developed Procedures, Triggers, Cursors in Oracle.

· Involved in migrating Informatica objects from Dev to Stage and Production environments using PVCS, Kintana tools.

· Involved in Production Support (24*7) on Weekends.