SUMMARY:

• Around 12 years of IT experience in design, analysis, development, documentation, coding and implementation including Databases, Data Warehouse, MDM, ETL Design, Oracle, PL/SQL, SQL Server databases, SSIS, Informatica Power Center, Informatica Data Quality (IDQ), etc.
• Expertise in Master Data Management concepts, Methodologies, and ability to apply this knowledge in building MDM solutions
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, DB2, SQL Server, MS Access, Teradata, Flat Files, XML files and other sources like Salesforce, etc.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server, and Cleanse Adapter in Windows.
• Defining and configuring Landing Tables, Staging Tables, Base Objects, Hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
• Proficient in creating Packages , Queries , Stored procedures , functions , views and triggers, cursors, composite data types, collections and exception handling
• Experienced in using Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling / IDQ Developer client, applying rules and develop mappings to move data from source to target systems
• Implement Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies.
• Help business to understand the Match rules configuration and decide the trust factor and Configure match/merge rules.
• Implement IDD applications to maintain/manage data, access relationship hierarchies and configure task management to route tasks to the Data stewards.
• Proficient in Design, Development and Transformation of Conceptual and Logical Data models into Physical Data models using Erwin and ER Studio.
• Configure charts on the dashboard according to business requirements in IDD and user exits in IDD for selective validation alert pop ups.
• Developed complex mappings using Informatica Data Quality (IDQ) Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address Validation, Key Generator, Lookup, Decision etc. transformations and performed testing.
• Proficient in developing the Data mart in Star Schema and Snowflake Schema, Flat files and building the Data warehouse, Efficient in developing the Data model, OLTP/OLAP, ER Diagrams and organizing the data as per the Business requirements.
• Extensively worked with complex mappings using Informatica Power Center with various transformations like Filter, Joiner, Router, Expression, Union, Unconnected / Connected Lookup, Aggregator, Stored Procedure, Normalize, Sequence Generator, Update Strategy, etc.
• Experienced in the development and deployment of Reports. Defined, designed & developed the use of Reports by blending the financial knowledge of the client with the available technical know-how.
• Strong experience in SQL, PL/SQL, Tables, DB Links, Materialized views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Joins, Unions, Cursors, Collections and Indexes
• Experience in using tools like SQL * Plus, SQL developer, PL/SQL developer, TOAD
• Experienced in writing UNIX shell scripts for automating the data loading & Batch Processing
• Knowledge in E-commerce and Web related tools such as HTML, JavaScript, Applets, Servlets, Java Server Pages, EJB and XML, SOA (Service Oriented Architecture)
• Excellent communication, interpersonal, Versatile team player with problem solving and analytical skills

TECHNICAL SKILLS:

Backend: Oracle 12c/11g/10g/9i, Database Enterprise Edition, Oracle 10g/9i Application Server, Unix, MS-SQL server 2008/2005

Frontend: Informatica MDM Multi Domain 10.2, Informatica Data Quality (IDQ), MDM, SSIS, Oracle Developer Suite 10g/9i/2000, REPORTS Builder 10g/9i/6i, SQL * Loader, XML Publisher, Discoverer, Informatica Power Center 10.1/9.6/8.6

Programming: ORACLE PL/SQL 11g/10g/9i/8.0, UNIX Shell Scripting, XML, HTML C/C++, JAVA, Eclipse, Websphere, Java Script, Visual Basic, Informatica Data Quality 9.x, Informatica MDM 9.x, 10.2, Hive, Cloudera

Data Modeling: Relational Modeling, Dimensional Modeling (Star Schema, Snowflake, FACT, Dimensions), Physical, Logical Data Modeling, and ER Diagrams, Hadoop, SOA

Third Party Tools: Erwin, ER Studio, TOAD 9/8.6, PL/SQL Developer, Putty, Workflows, PC Anywhere, MS-Office 2000, Informatica, Clearcase, Clearquest, Autosys, Tidal Scheduler, Crontab, SOAP UI, Eclipse

Operating System: Windows 10/98/2000/XP/NT, UNIX, LINUX, OS X

PROFESSIONAL EXPERIENCE:

Confidential, CA

Lead MDM Consultant

Responsibilities:

• Involved in the full SDLC of the project including Design, Development, Testing and Production deployment
• Designed, documented and configured the Informatica MDM Hub to support loading, cleansing of data
• Involved in implementing the Land Process of loading the Provider Data Set into Informatica MDM from various source systems
• Configure foreign-key relationships, lookups, query groups, queries/custom queries and packages in MDM.
• Configure hierarchy system tables and user defined tables and configured entity types and relationship types.
• Configure match paths, match columns, match rule sets and match rules according to the requirement.
• Created mapping document to map the SPF (Standardized Provider Format) data sent by multiple PPGs from Mark Logic to MDM Base Objects.
• Developed ETL mappings to Load data from MarkLogic source system to MDM Landing Tables.
• Developed several IDQ complex mappings in Informatica a variety of Power Center, transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center.
• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Inf ormatica Data Quality (IDQ) Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address Validation, Key Generator, Lookup, Decision etc. Transformations and performed the unit testing for accuracy of data.
• Performed database modeling, functional requirements, technical design, system development,
• User, interviews, testing, and implementation.
• Using Provisioning tool created the Business Entity Services to provide the services to SOA team.
• Worked with MPD/PDM/FSR/PCDW team to understand the current provider data.
• Involved in data model Architecture and performed database modeling with ER studio.
• Experience in ActiveVOS workflow design, creation of Human task Extensive experience in MDM 10.2 with IDQ and ActiveVOS 9. 2.
• System integration and Informatica workflow Manager.
• Developed ACT workflows to capture the delta and derive the Credential and FSR flags at Provider and Service Location level.
• Loaded the data from Landing table to staging and then to Base Object tables.
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-prod and prod environment.
• Worked with Oracle SQL statements for storing, retrieving, and manipulating data in relational database.
• Created MDM mapping by using cleanse functions, IDQ cleanse functions to standardize Address data.
• Configured SIF APIs for performing tasks using SOAP UI with Wsdl.
• Worked with QA team for defect fixes across UAT and PROD environments.
• Mentored other ETL engineers to progress the project scope and resolve any issues.
• Used SQL tools like TOAD, Sql developer to run SQL queries and validate the data.
• Performed tuning of queries, targets, sources, mappings, and sessions.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads, and process flow of the mappings
• Developed Test Plans and written Test Cases to cover overall quality assurance testing.

Environment: /Tools: Informatica MDM 10.2, Informatica Power Center, PL/SQL, TOAD, Oracle Developer 11g/12c, Java Eclipse, IDD, Provisioning Tool, Java, SOAP UI, ER Studio, Tidal, Mark Logic

Confidential, CA

Sr. Informatica MDM/IDQ Developer/Analyst

Responsibilities:

• Create and configure Base Objects, associated staging tables, mappings and transformations as per business requirements.
• Configure mapping with cleanse functions including Address Doctor before running the stage job.
• Install and Configure Informatica MDM Hub Server, Cleanse Server, Resource Kit, Cleanse adapter, IDD.
• Work with ETL Developers in creating External Batches to execute mappings to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Designed, documented and configured the Informatica MDM Hub to support loading, cleansing of data.
• Use Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Created Landing, Staging, Base object, Match rules, Merged, Created golden records in Informatica Master Data Management (MDM).
• Applied Exact and fuzzy match logics in Informatica IDQ to get duplicate records to understand for business and provided multiple reports to business.
• Identified and communicated potential quality issues in the way data is collected, stored, process or used.
• In order to get golden records, Extensively Worked on Matching and Merging process in Informatica MDM.
• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) 10.1.1 Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address Validation, Key Generator, Lookup, Decision etc Transformations and performed the unit testing for accuracy of data.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, and Aggregator Transformation.
• Exported the IDQ Mapplets to Informatica Powercenter and executed in all the environments.
• Developed Source to Target Mappings using Informatica Power Center Designer to load data from various source systems like Oracle and Flat files to target database, implementing the business rules.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads, and process flow of the mappings
• Created, Deployed & Scheduled jobs in Tidal scheduler for integration, User acceptance testing and Production region.

Environment: /Tools: Informatica MDM 10, Informatica Power Center 10.1.1, IDQ, SOAP UI, SQL, User Exits, TOAD, Oracle Database 11g, Java Eclipse, IDD, ER Studio, Tableau, Unix, Autosys

Confidential, CA

Sr. MDM/IDQ/ETL Consultant

Responsibilities:

• Developed several IDQ complex mappings in Informatica a variety of Power Center, transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center.
• Developed OLTP & OLAP logical data models based on client approved conceptual data models.
• Designed, documented and configured the Informatica MDM Hub to support loading, cleansing of data
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems
• Created ETL SQL Scripts that pulled data from MarkLogic tables to migrate data into MDM Landing tables.
• Performed database modeling, functional requirements, technical design, system development,
• User, interviews, testing, and implementation.
• Collaborated and partnered with the users to develop functional and Technical documentation.
• Integrated with other projects to support a program approach.
• Involved in data model Architecture and performed database modeling with ER studio.
• Created mapping document to map the SPF (Standardized Provider Format) data sent by multiple PPGs from Mark Logic to MDM Base Objects.
• Developed multiple IDD User interface utilizing IDD Best Practice s Standards for Provider, Member , Competitor, Partner screens with complex business requirements on data validations - Cleanse Functions, User Exits, and Queries.
• Developed ACT workflows to capture the delta and derive the Credential and FSR flags at Provider and Service Location level.
• Configure foreign-key relationships, lookups, query groups, queries/custom queries and packages in MDM.
• Configure hierarchy system tables and user defined tables and configured entity types and relationship types.
• Configure match paths, match columns, match rule sets and match rules according to the requirement.
• Loaded the data from Landing table to staging and then to Base Object tables.
• Worked with Oracle SQL statements for storing, retrieving, and manipulating data in relational database.
• Created MDM mapping by using cleanse functions, IDQ cleanse functions to standardize Address data.
• Configured SIF APIs for performing tasks using SOAP UI with Wsdl.
• Worked with QA team for defect fixes across UAT and PROD environments.
• Using Provisioning tool created the Business Entity Services to provide the services to SOA team.
• Mentored other ETL engineers to progress the project scope and resolve any issues.
• Worked with Informatica Support for MDM issues and upgrades
• Used SQL tools like TOAD, Sql developer to run SQL queries and validate the data.
• Performed tuning of queries, targets, sources, mappings, and sessions.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads, and process flow of the mappings

Environment: /Tools: Informatica MDM 10.2, Informatica Power Center, PL/SQL, TOAD, Oracle Developer 11g/12c, Java Eclipse, IDD, Provisioning Tool, Java, SOAP UI, ER Studio, IDQ, Mark Logic, Tidal

Confidential, CA

Sr. MDM/IDQ Developer/Analyst

Responsibilities:

• Created various Profile reports through Informatica Analyst Tool (IDE) to know weakness and strengths of source data and generated Scorecards with applied metrics on top of profile results.
• Involved in Configuring JMS setting in Informatica MDM and integrating the external applications using SIF.
• Used the Informatica Service Integrated Framework (SIF) to develop the web service for MDM Process.
• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) 9.5.1 Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address Validation, Key Generator, Lookup, Decision etc Transformations and performed the unit testing for accuracy of data.
• Designed and maintained the data extraction and loading from source systems (PARIS, ACTS, SAP CRM, RIO, WOREC) to target EPS system.
• Configured the Automation process for Land, Stage and Load Process (Batch Process)
• Used Debugger in Informatica Power Center Designer to check the errors in mapping.
• Created Various Informatica MDM Match rule sets for the base objects by defining the Match Path components, Match columns and rules; fine tuning the match rules for optimum output and performance.
• Designed, documented and configured the Informatica MDM Hub to support loading, cleansing of data
• Created various Mapplets, tables, Profiles, Score cards for Product and Location data in Informatica data quality and analyst tools.
• Worked on Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-Production and Production environments.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching.
• Implemented the approval process by enabling and disabling the buttons for subject areas in IDD, according to business rules and requirements
• Involved in redesigning the data model by doing the necessary changes by enhancing the scope of the project.
• Extensively applied all the business rules in IDQ/IDE to minimize the task to Informatica MDM for matching and Hierarchy features implanting.
• Cleansed, standardized, labeled and fix the data gaps in IDQ where it checks with tables to fix major business issues.
• Publishing Data using Message Queues to notify external applications on data change in MDM Hub Base Objects

Environment: /Tools: Informatica Multidomain MDM 10, Informatica Data Quality (IDQ/IDE) 9.6, InformaticaPowercenter 9.6, Informatica data director, Informatica Metadata Manger, Jboss 5.1.0, SQL Server 2012, Toad 9.0.1, Tidal

Confidential, Bellevue, WA

MDM/IDQ/ETL Developer

Responsibilities:

• Review the business requirement, functional requirement document for various modules so as to have good understanding of the application.
• Design and Develop the technical specification based on business requirements/functional document.
• Manage and Lead the technical team in building the application and assisting them by providing the solutions.
• Developed Batch ETL tables to store history box and daily box run stats.
• Developed ETL process control table to store audit information of ETL job run.
• Worked with UAT team for defect fixes across UAT and PROD environments.
• Performed ETL Unit Testing to validate the data after loading.
• Designed, documented and configured the Informatica MDM Hub to support loading, cleansing of data.
• Perform component integration testing and system integration testing and report the bugs found during testing in the Quality Center.
• Involved in extensive performance tuning by determining bottlenecks at various points like sources, targets, mappings and sessions.
• Analyzing the session logs for troubleshooting the workflows/sessions failures and for the long running sessions.
• Developed shell scripts to create parameter file and to kick off informatica jobs.
• Track, review and analyze defects using Quality Center
• Perform the test lead job for certain duration for patch mini release where he have to make sure that all the system test scripts are running successfully and the defects are closed in Quality Center.
• Interact with QA team member, Developer, Business Analyst in project meetings throughout the course of the project.
• Utilized of Informatica IDQ to complete initial data profiling and matching/removing duplicate data
• Provided technical leadership and support for Master Data Management (MDM) platform, including solution architecture, inbound/outbound data integration (ETL), Data Quality (DQ) and Data Director (DD) development, maintenance/tuning of match rules and exceptions.
• Communicate report and update team about the daily defect and execution statuses.
• Extracted data from the source views by writing the procedures to load the data into staging tables.
• Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
• Created the tables and sequences by writing DDL statements for the experimental data load capture.
• Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from staging tables to the target schema.
• Exclusively involved in writing the wrapper scripts and SQL scripts in ETL Loading process.
• Responsible for writing the functional and technical design specification documents (TDS) and maintaining the documentation.

Environment: Oracle 9i/10g/11.2, PL/SQL, Informatica MDM 10.1, Informatica Power Center 9.6, SQL*Plus, PL/SQL Developer 6.0, Toad 9.1, UNIX, Informatica power center tool 8.1.1, QC 10.0.

Confidential, Peapack, NJ

Sr. Informatica developer / Analyst

Responsibilities:

• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Came up with the low level detailed design to re-create the objects to Oracle database
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping
• Designed/ customized data models for Data warehouse supporting data from multiple sources in real time.
• Implemented and fine tuned the detailed design to fit into the migration process
• Created Informatica mappings, sessions, workflows , etc., for loading fact and dimension tables for data mart presentation layer
• Created the technical document based on the Functional document provided
• Created and managed primary data base objects such as Tables, Views, Indexes, Sequences, and Synonyms according to corresponding Data types
• Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager
• Developed PL/SQL code to implement business rules through cursors , refcursors , procedures , functions, and packages
• Have implemented SCD (Slowly Changing Dimensions) Type I and II for data load.
• Resolved Inconsistent and Duplicate Data to Support Strategic Goals with Multidomain MDM.
• Involved in performance tuning of SQL queries to decrease the execution time
• Used Analytical Functions like Rank, Row Number, Dense Rank, Listagg, First, Las t to compute an aggregate value based on a group of rows.
• Migrated the reports according to the requirement using Oracle Reports 10g
• Responsible for writing the technical documents and maintaining the documentation
• Used UNIX scripting to automate the process by using CRONTAB.

Environment: Informatica Power center, IDQ, Oracle 10g, SQL and PL/SQL,, TOAD, Reports 10g, UNIX

Confidential, NJ

Oracle PL/SQL Developer/Analyst

Responsibilities:

• Involved in analysis, design, coding, and implementation
• As a part of Data Mining team provided the data from the database to the Testing teams
• Written the SQL Queries to Data Retrieval Tool
• Upon the Requirement updated and modified the queries in the query tool
• In the process of converting the Accounts from NFS system to BOA system loaded the data from the flat files
• Have written the wrapper scripts and SQL scripts in ETL Loading process.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer, JAWS, SERVICE DESK, Autosys
• Need to develop the reports everyday from the database to check the accounts migration
• Extensively used inbuilt Oracle PL/SQL packages like UTL FILE, DBMS PIPE, DBMS SQL, DBMS STATS in application development
• Developed control files for SQL * Loader and PL/SQL scripts for Data Extraction/Transformation/Loading and Mapping, loading data into interface tables from different Legacy systems and validating the data.
• Developed Oracle PL/SQL programs for backend processing and exception handling
• Developed PL/SQL packages, procedures, functions, materialized views, SQL Scripts and triggers to populate the historic data in the tables applying business logic
• Extensively involved in writing SQL sub-queries with join conditions and PL/SQL scripts
• Involved in performance tuning of SQL queries and Created indexes on tables and optimizing Stored procedure queries
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Created Database Objects such as Partitioned Tables, Views, Synonyms, DB-Links to provide data access to subscribing parties.
• Modified the queries by applying the oracle hints and using BULK COLLECT, FOR ALL and NOCOPY to reduce the time for performance of the query run time.
• Created the DB-Links pointing to the remote database to access the source materialized views.
• Loading the Data into tables using External tables and extracting the files using Package UTL FILE
• Developed triggers for automatic updating of the tables and views
• Created group, tabular, and form reports
• Created tables to capture errors and data that failed Validation Checks and used CASE, DECODE and Analytical functions in data transformations.
• Used UNIX scripting to automate the process by using CRONTAB.

Environment: Oracle 9i/10g, SQL*PLUS, TOAD, SQL*LOADER, Forms 6i, Reports 6i, PL/SQL