SUMMARY

• I am certified Informatica MDM consultant, Having 10+ years of IT experience as MDM/ETL/IDQ/IDD/SIF Developer Consultant.
• Solid experience in Informatica Siperian MDM 9.7.1, Informatica Power Center 9X, Data profiling using Informatica IDQ 9.6.1.
• Data Profiling/Data Quality: Extensive experience with Informatica IDQ, Address Doctor, Melissa Data API.
• 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.
• Designing, Configuring core Informatica MDM Hub components: Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD & Data Modeling
• MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager - Entity types, Relationship objects, Packages, customizing/configuring Informatica/Business Data Director.
• Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages developing multiple cleansing functions .
• Implementing Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies with the software lifecycle phases including design, development and implementation.
• Informatica MDM processes including batch based and real-time processing.
• Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Configuring Informatica Data Director (IDD) to meet Data Governance objectives in many project life cycles.
• Writing User Exits in MDM as well as IDD to support customized requirement, this is beyond the capability of the tool.
• 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 - serial/parallel batch processing, Real time ETL including CDC, Queue- MQ series, JMS, TBCO etc.
• System Integration: Point to point, Enterprise Architecture, Real Time Integrating of MDM to upstream/downstream system using JAVA SIF API Web Services, Queue and Batch Feed file.
• Data-related disciplines, and have worked in a variety of sectors including finance, Healthcare, Manufacturing, and Telecoms. My goals are to advance the practices of data governance and data management by thought leadership and practical implementations that solve difficult problems.
• 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.
• Extensive experience with Data Extraction, Transformation, and Loading using Information Power center from disparate Data sources like RDBMS, COBOL, XML into a common reporting and analytical Data Model - serial/parallel batch processing, Real time ETL including CDC using queue- MQ series, TIBCO etc.
• 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
• Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS

EIM Tools: Informatica MDM Multi-Domain 9.x, IDD, SIF.

Operating Systems: Windows9x/2000/NT/XP/Vista/7,UNIX.

Programming Skills: PL/SQL.

Application Servers: Jboss,Weblogic.

Scripting Languages: HTML,CSS,JavaScript,XML.

Data Warehousing Tools: Informatica Power center 8.x/7.x, Informatica Developer.

Databases: Oracle7.x/8.x/9.x,10g/11g.

Development Tools: Toad, SQL plus, Erwin, Tidal, Contol-M, PL/SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential

Informatica MDM Senior Developer

Responsibilities:

• Worked on defects and CR Perform the feasibility check & Impact analysis for Vendor and Customer Domain.
• As per the client architecture understand the customer/vendor/item (MDM) data model.
• Profile and understand the large amounts of source data to define to add new souce system INF.
• Design and develop ETL code to load and transform the source data from various formats into a SQL database.
• Conduct ETL performance tuning, troubleshooting, support, and capacity estimation.
• Conduct thorough testing of ETL code changes to ensure quality of data produced.
• Designed and implemented Post Landing and Post load User Exits.
• Define the match (Fuzzy/Exact and) & merge (Auto/Manual) strategy to remove duplicates and generate the best version of the golden record.
• Used Metadata Manager to Import/Export Metadata and promote Incremental changes between the DEV/QA/PRD environments
• Define the roles and access privileges for developer/administrator/data steward/requestor etc. on requirement basis.
• Developing Put and Display packages for both Hierarchy Manager and IDD Application.
• Deployed IDD Configuration by importing BDD Configuration files, Message bundles, Error code bundles and User Exits by clearing cache and redeploying the applications
• Create the test cases and Test plan for each scenario.
• Validate and get approval for the test cases from development /business heads and architect team.
• Performed sanity checks in Dev/SIT and UAT boxes as need basis for Vendor domain.
• Test the data in UI, Create and validate the workflows.
• Testing validation rules on hub console as well as on IDD, BDD UI application.
• Create the bugs in the ALM for tracking.
• Create the tasks that generate automated emails for each CRUD requests.
• Experience in load performance, query performance, archiving, etc.

Environment: Informatica MDM 9.7.1, Hierarchy Manager, Informatica Data Director, Informatica Power Center 9.1,Neetezza, Tidal, Informatica data quality, Java, JBOSS, Oracle 11g, batch scripts, Address Doctor5, SQL Developer, ALM, Quality Center.

Confidential

Informatica MDM Developer

Responsibilities:

• Creating BO, Stage and Landing tables, Setting up relationship, Match Path configuration as per data model, Creating load mapping, cleanse function, HM setup-creating entity types, relationship base objects, relationship types, profiles, put and display Queries.
• Hands on experience on developing IDQ Profiles.
• Performed data analysis and validation of the data received from upstream systems.
• Defined Trust and validation rules before loading the data into the base tables
• Create MDM mappings using IHA best practices to capture the errors and have a clean load using Informatica power center.
• Performed unit testing in all stages of MDM and ETL from where data releases.
• Coordinated with Business Leads in making them understand Match & Merge and incorporated their requirements and ideas.
• Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules.
• Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, export and import master data from flat file.
• Played a major role in Dev., Test and Prod deployment of Provider data in MDM Phase 1.
• Provide day-to-day support and mentoring to end users who are interacting with the data.
• Execute queries against MDM hub and other inbound/outbound databases as required.
• Collaborate with source systems data stewards and technical personnel for data governance and to resolve any data quality or technical issues related to data ingestion.
• Facilitating the establishment and implementation of standards, guidelines and best practices that guide the various MDM and Data Warehouse projects within the organization.

Environment: Informatica MDM 9.7.1, Hierarchy Manager, Informatica Data Director, Informatica Power Center 9.5.1, Tidal, JBOSS, Oracle 11g, PL/SQL, TOAD, Address Doctor5, SQL Developer.

Confidential

MDM Developer

Responsibilities:

• Interact with data analysts to understand the requirements, identify gaps and to turn them into technical documents and mapping specifications.
• Create MDM base objects, Landing and Staging tables to follow the comprehensive data model in MDM.
• Defined and configured landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Using sql loader loaded landing tables with direct and full load utilities.
• Created and loaded oracle Exadata database to for huge tables like Auth, Debit and Credit transection to resolve performance issues.
• Worked with business to design match rules, assign trust, and complete match tuning. Worked on IDD applications to allow creation of all entities (parties), relationships, edit lookup values and other relational Base Objects.
• Analyzed the Business data and defined the Match and Merge rules and Trust Scores for Siperian MDM Hub.
• Involved in ETL and data profiling in getting the data loaded into the landing tables.
• Calling MDM Jobs through Batch Files (with Java Code) for scheduling.
• IDD: Configuring IDD, hierarchy configuration, created subject area groups, subject areas, subject area child, and search queries.
• Develop the web services in getting the data loaded into the Hub from the external applications, Using the SIF put and cleanse put APIs.
• Worked for projects like process changes to the different associations like AMEX, VISA, Master Card and Discover.
• Application owner for develop multiple critical applications and interacting with clients/Business users for Project/Concept requirements.

Environment: Informatica MDM 9.5.1, Hierarchy Manager, Informatica Data Director, JBOSS, Oracle 11g, PL/SQL, TOAD, IDQ, SQL Developer.

Confidential, MI

Informatica MDM Developer

Responsibilities:

• Identify Strategy, timeline, data elements, data volume from upstream systems business rules, Entity hierarchy, match/merge criteria, data validation rules, Trust frame work for cell level survivorship.
• Gathered requirements from pilot hospital systems to integrate and fulfill their business need - Web Forms based campaign requirement, mass emailing for campaign.
• Used IDQ for Data profiling for various Consumer and provider source like Experian/Enclarity/CMS in addition to internal system like PBFS, Contact Center(Salesforce), Web Forms - Campaign and Manual Uploads - User Provided data sheets. Created mapplets using address doctor to use it in MDM Hub as well as Power center for data cleansing and standardization.
• Designed MDM feed to integrate downstream/upstream system data warehouse, sales force - connect center in order to syndicate data back and forth to source system vs. MDM. Salesforce based application integration with MDM using ETL merge transformation. JAVA SIF API Web services to integrate and real time integration to downstream and upstream system.
• Resolved ongoing business reported issue. Bug fixing with Informatica support team, good relationship to get support people to provide priority to issue and getting resolution on time.
• Provided weekly status to the clients for the progress of the project

Environment: Informatica MDM 9.1, Siperian XU, Hierarchy Manager, Informatica Power Center 9.5, Oracle 10g, Toad, JBoss 5.1.0, MS Visio, Trillium, Windows XP, Windows server 2003, Address Doctor 5,JAVA

Confidential

Lead

Responsibilities:

• Requirement gathering and understanding from Business Analysts.
• Designed ETL architecture for integration of new settlement system IMPACT- Staging Area, Interface Tables, dimension modeling.
• Designed and developed Instrument master, Account Mater, Customer Master, RR Master as confirmed dimension sourcing data from in house source-IMPACT, NTAPS, PDP and Third party market data provider- Bloomberg, Fitch, Moody etc.
• Design and development of Architecture surrounding column precedence/ Cell level survivorship for confirmed dimension.
• Getting hands on development work in Informatica MDM project. My role is to disintegrate Instrument master and Customer-Account from warehouse and push the logic to MDM - reference data as global golden source for reference data across Nomura.
• Contribute towards NCDI development/Enhancement, testing, UAT, roll outs/ upgrades. Meet deadlines as per project plan / JIRA estimates, take complete ownership of task deliverables.
• Follow proper SDLC process, strict adherence to Nomura standards, processes, best practices to deliver desired product.
• Document the new development and for changes.

Environment: Informatica 8.6/9.1, Informatica IDQ 9.5, SQL Server 8, Oracle11i, PL/SQL, UNIX, Autosys, ERWin, Business Object, JAVA

Confidential

Developer

Responsibilities:

• Involved in implementation of Mapping using Informatica Designer.
• Extensively Used Source Qualifier, Update Strategy, Aggregator, Joiner, Expression Lookup (connected & unconnected), Stored Procedure (connected & unconnected) Sequences are mostly used.
• Development of workflows and Session Tasks.
• Writing PL/SQL procedures for processing business logic in the data base, tuning sql queries for better performance.
• Generated reusable transformations, mapplet and using them extensively in many mappings.
• Involved in Performance Tuning .
• Troubleshoot development issues and maintain Issue log.
• Creation of database tables with proper storage managements.
• Creating users, roles, profiles and assigning roles, profiles to users.
• Creating table spaces, Data files, Log files and control files.
• Monitoring the database (space, memory) using Oracle Enterprise Manager.
• Taking physical backups using RMAN and Cold and Hot backup, logical backup using
• Export/import utilities.
• Resizing the SGA and table spaces, added data files as when necessary.
• Monitoring database performance and manage Database locks/processes etc.
• Checking the log files, trace files for errors and maintaining archive log files.
• Programming like Stored Procedures, Pl/Sql Blocks, Triggers, Functions .