Candidates About

 

Himanshu Agarwal

• 12+ years of professional experience in different Informatica Tool set in Business Intelligence/ETL/Data Quality Solution and Designing using Informatica Power center and Informatica IDQ along with Informatica MDM.
• Solid experience in Informatica Power Center 9X/Data Stage, Data profiling/Data quality strategies using Informatica IDQ 9.X along with Informatica MDM 9.7.1
• Data Profiling/Data Quality/ETL: Extensive experience in Data Warehousing (ETL) Requirements Gathering, Analysis, Design, Development, Implementation, Integration, Testing, Profiling, Cleansing and Validation of data using the Technology, Informatica Power Center/Data Stage, Data Quality (IDQ) from versions 9.x for Health Care, Insurance, Banking and Retail Industries in different Methodologies.
• Experienced to Profile, Analysis, Standardize, Clean, Integrate, Score Carding, and Reference Data from Various source systems using Informatica Data Quality (IDQ) Toolkit.

·         Worked with Address Doctor (Address Validations), Different matching algorithms Biagram / Jaro / Edit / Hamming / Reverse distance in IDQ.

·         Worked with Informatica Data Quality Developer/Analyst Tools to remove the noises of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc. 

·          Experienced in Migration of codes from Repository to Repository, wrote up Technical/Functional Mapping specification Documents for each Mapping along with unit testing for future development.  

·         Proficient in Designing, Configuration and scheduling the Automation Process of Workflows for load frequencies. Skilled to Develop, Test, Tune and Debug the Mappings, Sessions and Monitor the system. 

·         Integrate Informatica MDM and IDQ to profile data and finalizing match rules for MDM hub.

• MDM Solution: with custom and party data model for Finance – Product, Security, Instrument, Account, Cost Center and Customer. HealthCare – Consumer, Provider. Retail - Customer, Vendor, Item.
• Data Governance, Metadata Management, Master Data Management, Reference Data Management, Business Rules Management, Information Knowledge Management, Information and Data Architecture, Database Design, Strategic Data Consulting.
• MDM Hub: Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.

·         Configured source systems collaboratively and performed Batch group with Stage and Load jobs.

·         Implemented Landing Process for loading the customer Data Set into Informatica MDM from various source systems.

·         Design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.

• Data Warehousing: Dimensional modeling Kimball and Inmon’s methodology, Star Schema, Snowflake Schema. Extensive experience with ETL from disparate Data sources like RDBMS, COBOL, XML, main frame system into a common reporting and analytical Data Model.
• Using Scheduling tools Tidal, Control- M and Informatica tasks established the daily batch load.
• Proficient in applying business logic using PL/SQL packages, stored procedures, functions.
• Writing UNIX shell scripts and automating Informatica Jobs/procedure

• Experience working for Disaster Recovery (DR) Testing.
• Informatica ETL Certification (Developer Level) is completed.
• Informatica MDM Certification (HUB) is completed.
• Six Sigma Green Belt Certification is completed.
• Worked on Remedy Force Ticket (Incident, Service Request& Change Request) in SLA environment based out of salesforce platform.
• Experience with On-Site/Off- Shore Model of project delivery.
• Possesses excellent communication and interpersonal skills and ability to work in a team as well as individually.

 

 

Technical Skills:

 

BI Tools	Informatica Power center 9x/ Informatica Cloud, Informatica Developer (IDQ), Informatica MDM,
Reporting Tools	BO Xi R2
Scripting Languages	UNIX Shell scripting
Databases	Oracle, SQL Server, Teradata
Database Tools	TOAD, SQL Developer
Loaders	SQL loader, Salesforce Data Loader, Fload, Mload, Bteq scripts
Testing tools/ALM	HP Quality center
Scheduling tools	Unix Cron Tab, Control-M
Operating systems	UNIX, Windows
Languages	SQL, PL/SQL

 

 

 

• Master of Computer Applications (MCA) from Pt. Ravi Shankar Shukla University, India.

 

Bayer corporations, Whippany, NJ

May 2017- Till Date

 

Informatica Architect (Apptad Inc.)

 

Project Profile:

 

Bayer Corporation is one of the leading pharma companies in US which produces multiple health care products for different business units like WHC, NHR, Oncology, and cardiology. Bayer is implementing MDM solution (Veeva network) so that they can better manage their business which contains mainly the collaboration between HCO (Health care organization) and HCP (Health care practitioner) with multiple other attributes.  Data is coming from different-different sources and we have to profile the data, find out the anomalies and overcome those with the help of Informatica Data quality different transformation, different strategies, And address cleanup using IDQ’s address validator before passing data to Power center so that it can feed the cleansed date to MDM solution.

 

Responsibilities: 

·         Requirements gathering, analysis and prepared BRD and TDD Document.

·         Working with Informatica Data Quality Developer/Analyst Tools to remove the noises of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Key Generator, Lookup etc. 

·         Address cleanup with the help of Address Validator transformation.

·         Worked on profiling the source data to understand and perform Data quality checks and load the cleansed data to Veeva objects before MDM can master the accounts (HCO) and practitioner (HCP) attributes.

·         Performed data domain discovery and Identified data standardization, validation, de-duplication in source data.

·         Worked on exception handling, and reporting and monitoring capabilities of IDQ.

·         Experience in implementing the data rules in Mapplets and Exception record management.

·         Created Reference tables using IDQ Analyst tools. Used the Address Doctor Geo-coding table to validate the address and performed exception handling, reporting and monitoring the data. 

·         Built the Logical Data Objects (LDO) and developed various mapping, mapplets/rules using the Informatica Data Quality (IDQ) based on requirements to profile, validate and cleanse the data.

·         Create the test cases and perform  for each scenario before mi

 

PFG(Performance Food Group), Richmond, VA

Aug 2016- April 2017

 

Informatica Developer (Apptad Inc.)

 

Project Profile:                                                    

Performance Food Group delivers more than 150,000 food and related products to customers across the United States .PFG decided to implement master data management to manage their customer/vendor and products (items). This implementation involves data migration from various source systems (IFH,GEMINI,ROMA,CIDB,FOOD STAR) to MDM .Data profiling, data standardization, match merge and generate the best outcome of the golden information of the customer/vendor/product are the key  requirements in this implementation.

 

Responsibilities: 

·         Performed Requirements Analysis and prepared HLD, LLD Document preparation process for mass update and mass extend MDM new process for vendor domain.

·         Worked with Informatica Data Quality Developer/Analyst Tools to remove the noises of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc. 

·         Performed data domain discovery and Identified data standardization, validation, de-duplication in source data.

·         Worked on profiling the source data to understand and perform Data quality checks using Informatica Data Quality and load the cleansed data to landing tables before Informatica MDM can master the accounts and contacts attributes.

·         Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, address standardization, exception handling, and reporting and monitoring capabilities of IDQ.

·         Experience in implementing the data rules in mapplets and Exception record management.

·         Created Reference tables using IDQ Analyst tools. Used the Address Doctor Geo-coding table to validate the address and performed exception handling, reporting and monitoring the data. 

·         Built the Logical Data Objects (LDO) and developed various mapping, mapplets/rules using the Informatica Data Quality (IDQ) based on requirements to profile, validate and cleanse the data.

·         Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1. for MDM. 

·         Implemented Address Doctor as Address Validator transformation for address cleansing.

·         Used Metadata Manager to Import/Export Metadata and promote Incremental changes between the DEV/QA/PRD environments

·         Experience using Metadata Manager for data lineage and Business Glossary to define business terms.

·         Define the roles and access privileges for developer/administrator/data steward/requestor etc. on requirement basis.

·         Create the test cases and Test plan for each scenario.

·         Performed sanity checks in Dev/SIT and UAT boxes as need basis for Vendor domain.

·         Create the tasks that generate automated emails for each CRUD requests. Experience in load performance, query performance, archiving, etc.

 

 

Meritor Inc, Troy, MI

Aug 2014- Jul 2016

 

Project Description: Working for a Fortune 500 company which manufactures automobile components and offers business, digital and technology solutions to help organizations get better return on their investment while improving their own process and relationships with their customers and suppliers.

 

Informatica Developer

 

Environment: Informatica MDM, IDD, Informatica power center9.5.1, Informatica Developer 9.5.1,  Jboss 6.1, Flat files, ORACLE, UNIX Scripting, Putty, CTRL-M, Salesforce CRM, Remedy force.

 

Responsibilities:

·   Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to Data Model for new requirements.

·   Worked closely with Project Manager, Architects, Data Modelers and cross team (Salesforce) to understand the business process and functional requirements in an Agile environment.

·   Created High level and low level design documents, ETL specification documents and unit test cases.

·   Plan the efforts for the development team and assign the work as per scheduled project plan and provide technical guidance and supervision to the team. Also worked on Design and code reviews of ETL Jobs.

·   Worked on profiling the source data to understand and perform Data quality checks using Informatica Data Quality and load the cleansed data to landing tables before Informatica MDM can master the accounts and contacts attributes.

·   Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, address standardization, exception handling, and reporting and monitoring capabilities of IDQ.

·   Experience in using the IDQ specific transformations like key generator, labeler, Parser and standardizer transformation.

·   Experience in implementing the data rules in mapplets and Exception record management.

·   Expertise in Exporting IDQ mappings into Informatica designer and creating tasks in workflow manager and scheduling the mapping with scheduling tools to run these mappings.

·   Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.

·   Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.

·   Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.

·    Extensively used Informatica to develop jobs to extract, transform and load data from various source systems into the staging and landing tables.

·   Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.

·         Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor.

·         Involved with Master Data Management (MDM) for Customer Data Integration using Siperian tool.

·         Handled Mater Data Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration, Hierarchy Manager Configuration.

·         Created Match and Merge Setups like Match path, Match columns, and Match rules and tuning of Match Rules.

·         Analyzed the background tables for the Data analysis purpose. Tables included Stage tables (RAW table, REJ Table, PRL table), XREF table, MTCH Table, HIS table, STRP table.

·         Created cleansing functions for effective result set of mapping results.

·         Implemented cleanse list functions and pre-defined functions.

·         Created reusable cleanse components using Graph Function, Regular Expression function, cleanse list.

·         Created queries and packages in the MDM (Master Data Management) HUB Console.

·         Created Applications in the IDD (Informatica Data Director) and performed Match and Merge operations.

·         Implemented Various user exit process.

·         Integrated with the ETL team and developed a new approach for Initial Data loads

 

Eli Lilly – BI Development, Noida, India

Oct 2011- Aug 2014

 

Project Description: Eli Lilly is the 10th largest Global Pharmaceutical Company in the world. It is basically a data migration kind of project which will process all the information coming from an ODS Source Systems to a Sales Force (Veeva) Cloud System and Vice-versa.

 

Informatica consultant/BI Lead

 

Environment: Windows 7, Informatica 8.6, Informatica Cloud, Teradata, Sales Force (Veeva), Unix, HP Quality Center.

Responsibilities:

• Working as the ETL Architect to handle all kind of development, production Support as well as enhancement activities.
• Creating Integration Test and strategy document, Test Summary report document, Technical Design and mapping Documents.
• Conducting status meeting with client using traceability matrix.
• Doing estimation of new development work as well as for change in existing.
• Requirement gathering from client and ETL Specification creation as per the business requirement.
• Monitoring the daily scheduled jobs running.
• Resolving issues during data loading to sales force objects within the given time limit.
• Used Informatica Power center and Informatica cloud to Create, schedule and monitor Workflows/task flows.
• Develop, test and review mappings against any Change Request given by client or new one.

 

 

XCS AOP 2035 SIEBEL CRM DESIGN, Noida, India

Oct 2010- Oct 2011

 

Project Description: Xerox corporation’s campaign data was managed by this project which contains multiple small module and it's a windows based environment which includes Siebel also for analytical purpose.

Informatica consultant/BI Lead

Environment: Informatica 8.5, Oracle 9i, BOXI R2, Siebel

Responsibilities:

 

• Written some of the Batch File to FTP data from one server to another.
• Worked to handle all kind of development, production Support activities.
• Doing estimation of new development work as well as for change in existing.
• Requirement gathering from client and ETL Specification creation as per the business requirement.
• Monitoring the daily scheduled jobs running.

 

GE-AI Data warehousing, Noida, India

Feb2008- Aug 2010

 

Project Description: This is a development as well as production support project based on onsite/offshore delivery model. Basically the goal of this data warehouse to track the device and asset related data of the customer. In this regard we have some dimensions and fact table on the basis of which BO reports are generated. Also this includes monitoring and fixing production bugs, Support and enhancements of existing BO Reports and creating new Informatica mappings, scheduling of workflows for loading new data from different source systems.

 

Role: Informatica Developer

Environment: Windows XP and Linux, Oracle 9i, Informatica 8.1, BO-XI

Responsibilities:

• Worked as a team member and attended status meeting with client.
• Help doing estimation to other team members of new development work.
• Create unit test cases and perform testing against them.
• Monitoring the daily scheduled jobs running.

·         Resolving issues during data loading to warehouse within the given time limit.

·         Used Informatica Power center to Create, schedule and monitor Workflows and Send the Messages in case of process failures.

• Develop, test and review mappings against any Change Request given by client or new one.
• Currently working in BOXI also. Creating reports in BO Info view, report migration, taking backup of reports and manage users as well.

 

HAVI Global solutions - ETL Support Operation, Kolkata, India

May2007- Dec2007

 

Project Description: HAVI provides international leadership in Packaging and Supply Chain Services to the food service and beverage industries. HAVI handle all the details of moving product & planning, forecasting, tracking, storage, product delivery, intelligence, etc. HAVI provides services to McDonald’s and Coca-Cola Company on a global scale. This project is built for creating and populating the data tables in the Data Warehouse tables. This includes all the Fact tables, dimension tables and aggregate tables.

 

Informatica Developer

Environment: Windows XP, UNIX, Informatica 8.1, Oracle 9i, Seibel

Responsibilities:

 

• Worked as the Team member and handled the support and enhancement work successfully.
• Updating and monitoring the daily job monitoring sheet.

·         Accepting client’s tickets for any issues and solving it within the given time limit.

·         Used Informatica Power center to Create, Schedule, and Monitor the mappings and Send the Messages in case of process failures.

• Develop and test mapping against any Change Request given by client.
• Running the workflows through UNIX shell scripts.

 

PCNA 1 UP Sap Legacy Integration, Chennai, India

Aug2006- Apr2007

 

Project Description: PepsiCo, New York is the leading company in the food and beverage in the world. They are implementing the SAP in the company, so the requirement was to generate the flat file taking the data as source from their existing system, which was the source to upload the data in SAP.

 

Informatica Developer

Environment: Windows 2000, UNIX, Informatica 8.1, Oracle 9i

Responsibilities:

·         Designed the ETL processes using Informatica tool to load data from File system, and Oracle into the target Oracle 9i database.

·         Developed mappings/sessions using Informatica power center for data loading.

·         Used Informatica Workflow Manager & Monitor to Create, Schedule, and Monitor and Send the Messages in case of process failures.

·         Test mapping to assure that data is loaded as per ETL Specification.

·         Performed testing as per UTC & FTC.

 

Trans-Miguel Finance Analysis, Bangalore, India

Jun2004- Jul2006

 

Project Description: Trans Miguel Global Pvt. Ltd. Is one of the leading finance company dealing with Insurance, Real estate, Automobiles The company offers complete solutions of Finance related problems and make it easy to take loans & have insurance. This project involved creating a data warehouse for the customers who have Insurance, taken loans for Real estate & for Automobiles as well as maintains the records of their revenue & employee information. Data would be extracted, transformed and loaded from the ODS into data warehouse using Informatica. This is the project to support the business applications & requirements so that the company can enhance its business in different perspectives.

 

Informatica Developer

Env