Data Etl

Prakash Jha Informatica MDM

Certified

Profile:

** ***** ** ********* ********* consulting solutions to various industries. Expertise in solutions design, developments, support and improvement methodologies using Informatica ETL Power centre and Data Warehouse solutions for commercial operations to achieve organization goals.

Banking Business Process focus

Business Intelligence Micro strategy 9.1, Oracle D2k forms.

Informatica PowerCenter 9.2

Informatica MDM 10.2

Informatica IDQ

LS Solution Accelerators, Toad Data modeler, Tools, Utilities, Service Now and GIT-HUB

Unix shell script, Oracle PL/SQL

DWH Solutions Analysis, Architecture & Design

Migration and implementation of MDM 9.5 to 10.2 and DB Sybase 12.5 to 15

Job scheduler Tivoli, Connect direct. Maestro, Autosys

Core Competencies:

Education and Certification:

Diploma in Business Management (PGDBM - Systems), ICFAI University.

Bachelor’s degree in Computer Science and Engineering (B.E), VTU University Belgaum India.

Oracle Certified Associate (OCA) in PL/SQL 9i.

Informatica MDM 10.1 Developer certified

IBM AIX certified.

Caremark Health domain certified.

Professional Experience:

ETL Architect

Client: - Amex

Location Phoenix

April 2019 – Till date

Working as a solution architect in FDE team to Ensure data quality monitoring process output for the Data Quality scorecard(s) are produced accurately and timely by the Data Governance team. Ensure data quality monitoring and tracking output is produced accurately and timely on a quarterly frequency for the DQ/Reconciliation Scorecards and the Attestation packages are produced accurately and timely on a quarterly frequency by the Finance Data Governance team.

Worked as an ETL architect.

Assess the as-is architecture and work with business data management team to come up with the solution best suited to the business needs.

Data profiling is key job to fix data coming from the inbound sources.

Fine Tuning the existing database process.

Creating design for the new enhance process.

Defined data migration auto rules between Working on optimization and tuning of SQL queries and indexes.

Created and performed unit tests; coordinated user acceptance

ETL Sr Consultant

Client: - State-Street

Location Boston

Dec 2017 – Mar 2019

Private equity services supports with the day-to-day management of Investor funds, focus on core activity: developing products, generating returns for your investors and identifying new opportunities.

Maintains flexible and scalable fund accounting solutions that promote rapid adoption, reduce operational risk and keep pace with regulatory change. Also works for portfolio analysis and performance measurement solutions to give you concise reporting of Investor portfolio’s composition and results. The GX Private Equity Index also delivers one of the market’s most comprehensive data sets.

Working under agile methodology with stories and below roles

Role:

Understanding the business, requirement gatherings with the users and documenting business specification and technical design. Conducted user trainings.

Developed and delivered presentations to all levels of management.

Worked as an ETL architect and consultant.

Assess the as-is architecture and work with business data management team to come up with the solution best suited to the business needs.

Data profiling of the inbound source CRM systems

Defining the match rules and data cleanse/ validation rules

Analysis and feasibility of the acceptance criteria for MDM solution.

Design the bidirectional integration solution using real time SIF APIs on IIB middleware and IDQ/ Power center ETL technologies

Data steward UI implementation with search capability of the master data, match tasks for data stewards to review and merge the duplicate customer/participants.

Fuzzy match key, match rule design and develop for the search before create functionality at source system.

Match rule, match purpose, key width tuning and update to the population file to include the project specific key words.

Active VOS configuration for task workflow on data steward UI.

Survivorship rule configuration for each of the attributes for various sources to ensure the record level survivorship.

Worked on merge handler and open handler to provide business validation before merging the tasks.

Implementation of e360 and Business Entity using Provisioning Tool.

Integration with the address doctor to provide recommended cleanse address before creation/update of the master data.

MDM SIF service integration with IDQ mapping for the batch processing of the SIF calls

Defined data migration auto rules between Working on optimization and tuning of SQL queries and indexes.

Created and performed unit tests; coordinated user acceptance.

ETL support lead

Otsuka pharmaceutical

Nov 2014 – Aug 2017

Defined, promoted and deployed information management solutions and enterprise class insight as a platform capability in support of company’s new commercial go-to-market strategies. Enablers deployed to key business areas such as,Veeva Sales Force and multi-channel marketing resource allocation integration to Data warehouse.

MDM solution for customers, Call Plan, Payer, PBM, Products.

Flexible alignment and targeting system by redesigning legacy alignment application.

Customer, Account and Affiliations insight development.

Involved in the configured and installation Informatica MDM Hub server 10.2, cleanse Server,

resource kit in development, QA, Pre-Prod and Prod Environments.

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 ETL from various source systems, defined the base objects, staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.

Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation.

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

Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.

Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right

master records.

Configured match rule set property by enabling search by rules in MDM according to Business Rules.

Involved in monitoring, modifying, & communicating the project plan with other team members.

Performed match/merge and ran match rules to check the effectiveness of MDM process on data.

Created Unit Test Case document.

ETL Consultant

Client :-CVS Health/ Morgan Stanley

April 2010 – Nov 2014

Understanding the business, requirement gatherings with the users and documenting business specification and technical design.

Developing the mappings as per the requirement and design document.

Loading only the normalized and valid data through mappings.

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.

Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation.

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

Fixing the invalid mappings and trouble-shoot the technical problems of the database.

Debugging the sessions by utilizing the logs of the sessions.

Implementing upgrade plan including testing of all production mappings, sessions, workflow.

Creation of Stored Procedures and Functions written in T-SQL implementing business logic

Involved in creation and modification of Package, Stored Procedure and Functions to create data extract to be run on Oracle database.

Database Architect

Morgan Stanley

May 2013 – Oct 2014

Understanding the business, requirement gatherings with the users and documenting business specification and technical design.

Design and develop the mappings as per the requirement.

Work intensively for data profiling and data standardization using IDQ.

Loading only the normalized and valid data through mappings.

Fixing the invalid mappings and trouble-shoot the technical problems of the database.

Debugging the sessions by utilizing the logs of the sessions.

Implementing upgrade plan including testing of all production mappings, sessions, workflow.

Creation of Stored Procedures and Functions written in T-SQL implementing business logic

Involved in creation and modification of Package, Stored Procedure and Functions to create data extract to be run on Oracle database.

Working on optimization and tuning of SQL queries and indexes.

Created and performed unit tests; coordinated user acceptance.

oProduction release, support and enhancements.

Sr Developer

IBM/AT&T

Feb 2007 – Mar 2010

Actively involved in ETL Development, Testing and Implementation.

Developed complex PowerCenter mappings, Routines, Oracle Packages, stored procedures and Triggers.

Involved in ETL Optimization and tuned some key Informatica jobs for better performance

Created UNIX shell scripts for Handling, Validating Files from FTP Server and executing Datastage jobs.

Exposure to Maintain and deal Configuration Management / Release Management/ Change Management through tools like Visual Source safe, CVS and clear case.

Involved in Production Support and Enhancement and Data Validations.

ETL Developer

Birla Corp/Others

April 2005 – Oct 2006

Actively involved in ETL Development, Testing and Implementation.

Developed complex ETL mappings, Routines, Oracle Packages, stored procedures and Triggers.

Involved in ETL Optimization and tuned some key Informatica powercentre jobs for better performance

Created UNIX shell scripts for Handling, Validating Files from FTP Server and executing DataStage jobs.

Exposure to Maintain and deal Configuration Management / Release Management/ Change Management through tools like Visual Source safe, CVS and clear case.

Involved in Production Support and Enhancement.

Involved in Manual Data Validations.

Accolades:

Year 2014: “Individual order of Merit” from Genpact Morgan Stanley team.

Year 2013: “Team of the Year” from Genpact Caremark team.

Year 2010: “Silver award” from Genpact account team.

Year 2009: “Best Employee Award” from IBM GBS team.

Year 2007: Multiple Appreciation awards from IBM India for successful implementation of various AT&T projects honoring Strong technical skills, Lateral thinking, Client Appreciation.

Contact this candidate