Deepesh Jhamar Email & Phone Number

Seattle, Wa, Us

Seattle, Wa, Us

Seattle, Wa, Us

Bangalore, Karnataka, In

San Diego - Us | Tokyo - Jp, Us

• Worked with upstream teams in identifying impacted list of fields that are Logically/Structurally impacted or required conversion• Created new ETL interface to load data from retiring applications like mainframes ORA apps into new SAP (DRP) System• Created new BAPI/Idoc interfaces to extract data from SAP BAPI’s and Idoc’s.• Created functional specification /Technical designs for all impacted ETL/New ETL’s and created UAT/SIT docs forthe same after required changes are complete.• Communicated to downstream systems about the impact analysis and handle the changes from reporting endextensively worked with offshore teams and evaluated the timely changes to the coding as a part of conversion.• Reviewed and approved the code changes done by team members.• Used of ripple queries to identify the data lineage.• Extensive use of metadata queries to create a requirement specific metadata table

San Diego - Us | Tokyo - Jp, Us

• Production support maintenance such as monitoring the ETL batch jobs and fixing the job failures, bug fixes and data issue reporting.• Carried out extensive data analysis that led to the resolution of complex problems.• Following the change management activities such creating a CR/FR and attend the CAB meetings.• Tuned the performance of Informatica, Database and Reporting performance. Some of the steps used to tunethe performance include indexes, Informatica and database partitioning, Explain Plan, Effective rewriting thequery and SQL Hints• Enhancements of the existing ETL systems as per business requirement, Enhancements activities includerequirement gathering, design, development and testing• Worked on Offshore Onshore model, held meetings on a daily basis for coordination and planning.• Worked with offshore team and conducted daily meetings to get status update.• Use of BO reporting tool, to understand the data issues raised by the end users.• Supporting the Informatica platform activities like deployments, creating new connection objects, to ensure allthe services are up and running fine, creating new users.• Frequent meetings with the Business to understand the new business requirements and providing the estimateson the same.• Presenting the Weekly status review (WSR) to Client.

San Diego - Us | Tokyo - Jp, Us

• Worked with Business Analyst to gather the requirements and created functional and Technical specifications• Coordinated with data modeler in designing the various schemas for planning and manufacturing modules.• Handled client enquiries and prepared daily workloads for the team members.• Created mapping documents and estimates for each mapping.• Worked with SAP team to identify the tables, Functional modules and data sources.• Extensively used various transformations like Aggregator, Expression, connected and unconnected Lookup’s andupdate strategy transformations to load data into target.• Worked on performance issues and bottlenecks to reduce the load time and monitored the data loads.• Created mappings to support delta loads into target using mapping variables.• Production support maintenance such as Monitoring of the ETL batch jobs and fixing the job failures, bug fixesand data issue reported• Participating in knowledge transactions and providing the Sign off.

Pune, Maharashtra, In

London, England, Gb

• Developed detailed functional specifications, enhancements and modifications documentation and track development progress partnering with on-site coordinator.• Offered solutions to the top management regarding project related queries• Participated in testing at all levels (unit, integration and user testing); designing and driving testing initiatives;develop and execute test plans; provide leadership to others in support role; documentation and training endusers on processes• Moved the logic of Credit cards key based on cards numbers from Informatica to source systems.• Truncated the card numbers stored in the files on the Informatica servers, so as to make the application PCIcompliance.• Coordinated the UAT and migration to the production environment.

London, England, Gb

• Extensively used Informatica Power Center for Extracting, Transforming, and Loading into different databases.• Created mappings using Informatica designer, sessions using workflow manager and tested the sessions usingtest data.• Extensively used ETL to load data from Oracle database, SQL server database, and Flat files to Oracle.• Created necessary test plans and design documents for the mappings.• Analyzing the data model and identification of heterogeneous data sources.• Designing and testing the different mappings according to the requirements.• Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator,Rank, Lookup, Update Strategy, Stored Procedure, Sequence Generator and Joiner.• Integrated various sources into the staging area in Data Warehouse.• Monitoring of Informatica Platform for CPU and Memory Usage• Migrating Informatica objects from Development repository to Production repository.• Creating Informatica users.