SUMMARY:

• Around 12+ years of experience in Informatica Power Design, Development, Testing, Informatica Data quality implementation. Oracle, Sql server, DB2, Netzza, Informatica Power center Administration, Informatica data quality Administration and Unix shell scripting.
• Around 5 years experience Master data management (MDM).
• Excellent knowledge in Insurance (property and casualty), Investment Banking, Informatica Big data management.
• Excellent hands experience in Unix shell script.
• Excellent experience in Data modeling and dimensional modeling.
• Developed MDM reference architecture, solution architecture, Data flow, Process flow, E2E exceptional handling flow for all the MDM projects.
• Demonstrated expertise in utilizing Informatica Transformations and Performance Optimization techniques to provide robust solution.
• Installation & configuration of MDM hub & Cleanse in JBoss on both Windows and Linux environments.
• Highly experienced in Data modeling to support business requirement and Informatica MDM velocity recommendations and best practices.
• Solution architect / designer for interfacing applications to support real time & batch updates.
• With business acumen and advance technical concepts, implemented highly integrated, scalable, real - time solutions in Master Data Management and Data Governance areas.
• Extensive experience in Program/Project management helped clients achieve their enterprise goals within timeline and budget.
• Identified issues with the Informatica MDM application and interfaced with Informatica Support & Engineering team for resolution. This helped the product to enhance more and benefited other customers.
• Expertise in MDM Project Implementation & support for multiple industries.
• A highly motivated, energetic individual and a team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

• Data warehouse / Data Modeling: Informatica Power Center 10.1/9.5.1, ER Data modeling and Statistical, Informatica data quality (IDQ) 10.2, Informatica Master Management (MDM) 10.2, Informatica Power Center 10.2, Informatica Meta Data Manager 10.2
• Informatica Big data Management (BDM ) 10.2
• OLAP Tools: WebFocus 7.1,Hyperion 8.1
• Database: Oracle 11g, Teradata, DB2, TOAD, Teradata, SQL Server 2016,Netezza
• Languages: C, SQL, PL/SQL, Perl scripting
• Tools: MSOffice, Rational clear case, Remedy7/6
• Operating System: Windows98/NT/2000/XP /UNIX.
• Scheduler Tools: Maestro, ESP, Autosys
• Requirement assessment/analysis by meeting with SMEs, creating process flow and context diagrams
• Developing full SDLC plans to implement ETL solutions
• Defining and implementing ETL development standards and procedures
• Identifying, recommending and implementing ETL process and architecture improvement
• Data Modeling: Expertise in Dimensional Data modeling, Relational Data modeling, Star Join Schema modeling, Snow-Flake modeling, FACT and Dimensions tables, XML Schema, Physical and logical data modeling, Erwin Data Modeler
• Data Governance: Defining Data Governance framework, analyzing data quality, defining and implementing data quality procedures and reporting policies, issues and corrective council to the Data Governance executive council for their approval
• Accountable for identifying and verifying appropriate application solution alternatives and driving the entire technical design for the project including functional, integration, data and infrastructur design, and working closely with dedicated resources for each area.
• Collaborated with enterprise architecture organization to provide Next 3 Year Stratergy for MasterData Management and related Integrated layers like Data lakes, Middleware.
• Collaborate with the MDM Service team, SOA Team, Data Governance, and Business Partners to define functional and technical requirements for MDM technology.
• Define/Design MDM solution/architecture.
• Create the MDM implementation roadmap.
• Lead the MDM application and technical architecture analysis, design, and implementation, and ensure that the product fulfills the requirements.
• Informatica Data Quality Developer Specialist Certified
• MDM Developer Specialist Certified
• MDM Hub Implementation Workshop Certified
• MDM Interface Implementation Workshop Certified
• Big Data Management: Black Belt Enablement Certified
• Big Data Management Implementation workshop Certified

PROFESSIONAL EXPERIENCE:

MDM- customer data model

Responsibilities:

• 1. Accountable for identifying and verifying appropriate application solution alternatives and driving the entire technical design for the project including functional, integration, data and infrastructur design, and working closely with dedicated resources for each area.
• 2.Collaborated with enterprise architecture organization to provide Next 3 Year Stratergy for MasterData Management and related Integrated layers like Data lakes, Middleware.
• 3. Collaborate with the MDM Service team, SOA Team, Data Governance, and Business Partners to define functional and technical requirements for MDM technology.
• 4. Define/Design MDM solution/architecture.
• 5. Create the MDM implementation roadmap.
• 6. Lead the MDM application and technical architecture analysis, design, and implementation, and ensure that the product fulfills the requirements.
• 7. Define and review to-be Processes and Governance model.
• 8. Define/Design Data quality framework in IDQ
• 9. Collaborate with Data Architect team.
• 10. Define the Match Rules and Trust settings based on discussions with Business discussion
• 11. Define/design Address doctor and Web service API for real time.

Daman - Syntax Diamond info system

Responsibilities:

• Gathering requirements based on discussion with stake holders.
• Create profile and analyze profile in IDQ for Data anomalies
• Designing Cleans/Validation rules in IDQ.
• Manage and Architect the development MDM Solution Integrations of the mastering customer and provider information or data.
• Design the data quality framework to enrich the customer data
• Worked with Data Architect to created Data Model.
• Create data quality Rules, Mappletes and mappings in IDQ for standardization.
• Provide Promote IDQ rules, Mappletes and mappings from IDQ to Power Centre.
• Create address doctor Mapping for address validation.
• Create schema for Base objects
• Configure hierarchies and relational type
• Create and Configure Landing, Base objects, Staging tables,
• Created ETL mappings to load Landing tables
• Created mappings for Staging tables and Batch Groups for job and configured Delta detection in stage process.
• Finalizing the Match Rules and Trust settings based on discussions with data stewards and data analysis.
• Configured Fuzzy, Exact match types and configured Match and Merge settings.
• Designed and implemented data governance hierarchies (region based hierarchy; based hierarchy, go to market view hierarchy).
• Worked on POC and provide end to end solution for IDQ and MDM.
• Arranging Meetings with business stake holders to understand source systems.
• Creating Functional, HLD and LLD documents.
• Written Queries and packages for displaying and updating data by Data Manager and Merge Manager.
• Configure Address doctor and support in Web service API for real time.
• Used User Exit interface, SIF API and IDD.
• Understand source Hierarchy model and designing same in MDM.
• Designing Matching and Trust rules in MDM based on discussions with stake holders.
• Presenting matched/unmatched customers information to stakeholders during the review
• Involved the MDM Target data model creation (i.e. creating the base objects).
• Create mappings for loading landing tables.

Environment: Informatica PC 10.2 IDQ 10.2, Sql Server 2012, ORACLE12c,MDM 10.2

MDM - Customer Data Model

Responsibilities:

• Work on POC and provide end to end solution for MDM
• Arranging Meetings with business stake holders to understand source systems.
• Gathering requirements based on discussion with stake holders.
• Creating HLD documents, LLD document, mapping sheets and also explaining to team.
• Hands on experience on Informatica MDM- Creating Landing, Base objects, Staging tables, mappings by using cleanse functions and configured Delta detection in stage process
• Configured Fuzzy, Exact match types and configured Match and Merge settings.
• Written Queries and packages for displaying and updating data by Data Manager and Merge Manager also created the Batch Group.
• Used User Exit interface, SIF API and IDD
• Understand source Hierarchy model and designing same in MDM.
• Designing Cleans/Validation rules in IDQ
• Create Rules, Mappletes and mappings in IDQ
• Promote IDQ rules, mappletes and mappings from IDQ to power center.
• Designing Matching and Trust rules in MDM based on discussions with stake holders.
• Presenting matched/unmatched customers information to stakeholders during the review
• Involved the MDM Target data model creation (i.e. creating the base objects).
• Create mappings for loading landing tables
• Create profiles in IDQ to check anomalies in the data
• Create standardization rules in IDQ
• Assign tasks to Team members

Environment: Informatica 10.1/9.5, IDQ 9.6, MDM 9.7.1, Sql Server2012, DVO, Netezza

PREDICTIVE MODEL

Responsibilities:

• Analyze the business requirement and check the feasible in Informatica and pl/sql
• Involved Data modeling
• Design mapping technical and functional document and develop the mappings
• Prepare Approach document and design document.
• Migrate the informatica mappings and workflows from Dev to UAT and from UAT to Production Repositories
• Involved informatica Administration
• Optimizing the bad Performing mappings
• Optimizing bad performing queries sql queries (Recommend index, partition or materialized view based queries bad status).
• Doing POC to check feasible solutions in informatica
• Assigning and tracking individual task with Team members
• Review the code developed by Peers
• Involved in recruitment process
• Review the code developed by Peers
• Involved in Informatica and Data modeling Practice in the company
• Create profile in IDQ analyze data

Environment: Informatica 9.5, IDQ 9.5.1 Sql Server, Oracle 10g,DVO,Netezza

Confidential, Morgan Stanley, New York

Responsibilities:

• Analyze the business requirement and check the feasible in Informatica, Unix and Pl/Sql
• Involved Data modeling
• Design mapping technical and functional document and develop the mappings
• Create stored procedures and Unix shell scripts
• Prepare Approach document and design document.
• Migrate the Informatica mappings and workflows from Dev to UAT and from UAT to Production Repositories
• Involved Informatica Administration
• Optimizing the bad Performing mappings
• Creating test cases and testing the Informatica sessions
• Optimizing bad performing queries Sql queries (Recommend index, partition or materialized view based queries bad status).
• Write complex queries and shell script to execute workflow, to create parameter files which can used in Informatica
• Doing POC to check feasible solutions Informatica
• Assigning and tracking individual task with Team members
• Review the code developed by Peers
• Involved in recruitment process
• Review the code developed by Peers
• Involved in Informatica and Data modeling Practice in the company

Environment: Informatica 9.1,8.6, 8.1, DB2,Oracle 10g, BO, Unix, Autosys

IMM

Responsibilities:

• Get the requirement and do the impact analysis
• Assigned the task to Team members
• Analyze Db2 system and Mappings
• Prepare Approach document and design document.
• Prepared up gradation approach document and coordinating with various team
• Upgraded Informatica 8.6 .1 to Informatica 9.0.1
• Optimizing the mappings
• Coordinating the production move
• Involved Informatica Administration act ivies
• Developed the Mapping Design Document.
• Creating test cases and testing the Informatica sessions
• Used most of the transformations such as the Source qualifier, Router, Aggregator, Joiner, Lookups, Expression, and Filters & Sequence to integrate data to the target.
• Worked with Different sources such as Relational Databases, Flat Files.
• Optimizing Sql queries.
• Review the Informatica code

Environment: Informatica 8.6, 8.1, 9.0.1 Sql server 2008, DB2 MicroStrategy

Confidential - Los Angeles

Responsibilities:

• Get the requirement and do the impact analysis
• Assigned the task to Team members
• Analyze Db2 system and Mappings
• Prepare Approach document and design document.
• Prepared up gradation approach document and coordinating with various team
• Upgraded Informatica 8.6 .1 to Informatica 9.0.1
• Optimizing the mappings
• Coordinating the production move
• Involved Informatica Administration act ivies
• Developed the Mapping Design Document.
• Creating test cases and testing the Informatica sessions
• Used most of the transformations such as the Source qualifier, Router, Aggregator, Joiner, Lookups, Expression, and Filters & Sequence to integrate data to the target.
• Worked with Different sources such as Relational Databases, Flat Files.
• Optimizing Sql queries.
• Review the Informatica code

Confidential, Pershing - New Jersey

ETL Developer

Responsibilities:

• Get the requirement and do the impact analysis
• Assigned the task to Team members
• Analyze Db2 system and Mappings
• Prepare Approach document and design document.
• Prepared up gradation approach document and coordinating with various team
• Upgraded Informatica 8.6 .1 to Informatica 9.0.1
• Optimizing the mappings
• Coordinating the production move
• Involved Informatica Administration act ivies
• Developed the Mapping Design Document.
• Creating test cases and testing the Informatica sessions
• Used most of the transformations such as the Source qualifier, Router, Aggregator, Joiner, Lookups, Expression, and Filters & Sequence to integrate data to the target.
• Worked with Different sources such as Relational Databases, Flat Files.
• Optimizing Sql queries.
• Review the Informatica code