Harsh Kumar Email & Phone Number

 Currently leading a large MDM project based on multiple ETL & MDM technologies like Informatica P360, PowerCenter, Informatica E360, Kafka, ActiveVos etc. Advisor to US clients in choosing right technology offerings and best practices Built relationship with Functional Clients & Project Owners to get future releases Led ETL & MDM Development Team of 8-10 members Worked as Architect and Sprint Planner for project releases Efficiently managed project deliveries & deployments Worked as SME/Architect & Senior ETL/MDM core developer ETL Informatica specialist –Power Center & Cloud/IICS MDM Specialist – Informatica P360 (PIM), E360 (Customer360 MDM) Experience in SalesForce/SFDC Data Integration & Migration using Informatica Managed dev team work. Created healthy and balanced working environment

Bangalore

The overall project involves integration of Item & Product domains data from various sources to Informatica PIM & MDM applications and sends useful information to other downstream applications. It involves delivering new development releases as well existing production release maintenance and enhancements requests.Responsibilities:• Worked as an end-end offshore lead for this project• MDM integrations using P360-PIM/MDM applications• Utilized ETL tool for data integration purpose• Designed Conceptual, Physical and Logical Data Models• Ensure each requirement is met as per project design• Acted as SME and Guide team to meet quality deliverables• Daily client coordination for existing issues and upcoming release plans• Taking lead into code deployments into production• Advisor to functional clients to choose right solution approach• Assigned team work for every 15 days sprint cycle and ensured deliveryTechnical Environment: Informatica P360, PowerCenter ETL, E360, Oracle, ActiveVos, TFS for Sprint Planning, MS Office, Visio etc.

Bangalore

The overall project involves integration of Item & Product domains data from various sources to Informatica PIM & MDM applications and sends useful information to other downstream applications. It involves delivering new development releases as well existing production release maintenance and enhancements requests.Responsibilities:• Worked as an end-end offshore lead for this project• MDM integrations using P360-PIM/MDM applications• Utilized ETL tool for data integration purpose• Designed Conceptual, Physical and Logical Data Models• Ensure each requirement is met as per project design• Acted as SME and Guide team to meet quality deliverables• Daily client coordination for existing issues and upcoming release plans• Taking lead into code deployments into production• Advisor to functional clients to choose right solution approach• Assigned team work for every 15 days sprint cycle and ensured deliveryTechnical Environment: Informatica P360, PowerCenter ETL, E360, Oracle, ActiveVos, TFS for Sprint Planning, MS Office, Visio etc.

Noida, Uttar Pradesh, India

This is a project where the overall technology was based on Mainframe Technology and the program codes was written in Cobol language. Our task was to Re-Platform all such programs written for 90+ different business module into ETL Informatica technology.Role: End-End responsibility to design, develop and deploy Informatica codes and create a Re-Platformed system using technology like Informatica, Linux & Oracle to replace the legacy system built in Mainframe technology. Worked as a Senior Resource in a team, which was spread across all locations in India as well as in US location having around 25 head counts from Delhi location only.• Informatica PowerCenter ETL Development Lead & SME (Subject matter Expert)• Single point of contact for any type of new development request or change request• Project Planning, Estimation & Resource Management for any new release/business requirement• Understanding business requirements and get them documented• Create a business requirement document to cater client’s requirement & expectation from new system• Create Functional Design Documents for various business feeds/logics• Create Technical Design Document to cater the technical approaches to be used to develop new system• Thorough usage of Technology like Informatica, Oracle, SQL, DVO, Unix Scripting, MS Office, Visio, HP-QC, AutosysTechnical Environment: ETL-Informatica, Oracle 12G Database, DVO, Unix Shell scripts, Quest toad, SQL, Visio etc.

Noida, Uttar Pradesh, India

It is a Telecom VAS provider in India. It provides services to leading telecom operators majorly in INDIA, Afghanistan, and Bangladesh. It has four major verticals OBD, IBD, ARPU and IVR. It has countrywide installation of the servers to cater its own clients with the data availability and break free services.Project Description:Manage Telecom Vas Data Ware House using different ETL tools and database mechanism. Used Linux platform.Role: ETL codes development, modification and successfully implementation on server. Solely taking Care of implementation & deployment of ETL for OBD verticals.• Creating and reviewing Low/Mid-Level Design documents.• Developing and modifying the existing data load structure used for loading data files correctly to Datawarehouse.• Use SQL Loader to load csv format files to database and handle column data transformation within SQL loader.• Developing the ETL workflows, jobs.• Monitoring of workflows. Handle performance tuning part for failed/slow running tasks.Technical Environment: Oracle, ETL, PL/SQL, Data Mapping, SQL loader, Shell scripts etc.