SUMMARY

• Senior Informatica MDM Developer with 8+years of IT experience and has portrayed skills in analysis, designing custom solutions, implementationand development of Data warehouses using Informatica and trouble - shooting and testing using ETL testing tools.
• Experience in integrating external application with Informatica MDM hub using message queries as a significant advantage.
• Experience working on Informatica MDM in design, develop, test and review & optimize Informatica MDM (Siperian) and IDD Applications.
• Strong proficiency in maintaining data warehousing applications using Informatica Power Centre.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Expertise on DataWarehousing Concepts like Dimension Tables, Fact tables, slowly changing dimensions, Datamarts and dimensional modeling schemas.
• Developed complex mappings in Informatica using different transformations Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Expression, Union, Stored Procedure transformation etc.
• Extensively worked with data warehousing, ETL methodologies, technologies, using Informatica Power Center.
• Excellent hands-on Data Exchange, MDM, IDQ, Data Transformation, SQL development.
• Good knowledge in Data warehousing concepts involving dimensional Star Schema, Snowflakes Schema and Galaxy Schema methodologies.
• Involved in OLAP data modeling for star and snowflake schemas.
• Experience in writing Indexes, PL/SQL procedures, Functions, Packages, Database Triggers.
• Experience in error handling, performance tuning and problem fixing in Informatica MDM.
• Experience on ETL testing tools and worked on QTP and QC.
• Expertise in writing the data clean up scripts using SQL queries and UNIX scripts.
• Proficient in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon's (SCD's), Change Data Capture (CDC), Customer Data Integration (CDI).
• Developed several test plans to find bugs and report errors.
• Experience in the SIF framework and Application Program Interface (API) development.
• Experience in resolving Defects, resolving requirement and observed design consistencies.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by layering Business Requirements and developing Test Scenarios to support quality deliverables.
• Competent to deliver results on multiple tasks by promptly managing time and priority constraints. Ability to address any ongoing or changing Business needs.
• Strong potential in managing multiple projects without effecting quality and delivering on discussed timelines.
• Experience with On-Site/Off-Shore Model of project delivery.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 8.6, 9.1, 9.5, 9.7, Informatica MDM, IDD, IDQ, SIF, ActiveVos

Reporting Tools: Tableau

Scripting Languages: UNIX Shell scripting, VBA Scripting

Databases: Oracle 8i/9i/10g/11g, Teradata, SQL server

Database Tools: TOAD

Loaders: SQL loader, Fastload, TPT, Multiload

Methodologies: Star schema, Snowflake schema

Testing tools: QTP, HP Quality center

Scheduling tools: Autosys, Tidal

Operating systems: UNIX, Windows

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Sr. MDM/ActiveVos Developer

Confidential, Houston, TX

Responsibilities:

• Associated with the business team to gain knowledge on the functional aspects.
• Conducted weekly sessions with the functional team to finalize the client requirements and the Datastewards team to understand the roles in their hierarchy.
• Configured source systems collaboratively and performed Batch group with Stage and Load jobs.
• Implemented Land Process for loading the customer Data Set into Informatica MDM from various sourcesystems.
• Design and develop MDM data model and defining logical relationships between the objects.
• Configure IDD and Hierarchy Manager. Configured Trust scores.
• Reviewed and designed the MDM/ActiveVOS setup and performed development and deployment.
• Configured integration between the Activevos 9.2.4.1 and MDM 10.0.1 for creating the custom workflow process and designingthe orchestration project.
• Designed Interfaces in connecting to External systems Salesforce/SAP using JMS messaging
• Performed a proof of concept in customizing the default MDM Task Workflow process.
• Developed BPEL files, deployed the .BPR files onto the ActiveVos server.
• Worked on the Activevos Console to monitor and report the processes, tasks and servers.
• Worked on Xpath, Xquery, and SOAPUi and WSDL files.
• Created workflows using Events, Gateways, Controlflows and generated forms by creating .avcconfig files.
• Generated .PDD files and exported them to the server and deployed the .BPR files into the server.
• Configured Human tasks in the workflow to assign roles to the Datastewards and configured Email/Messaging/Identity services
• Created forms in the Activevos designer and deployed them on the ActiveVos central to trigger workflows through form input.
• Involved in creating IDD tasks and assigning roles to the tasks in ActiveVos to trigger the workflows.
• Configured JMS on Activevos server to publish data to external applications/source systems.
• Installed ActiveVos sever on Windows with JBOSS.
• Configured and setup URN mappings on the Activevos Console.
• Implemented workflows based on Onestep, Twostep Approval processes and customized workflows to suffice business requirements.
• Collaborated with the offshore team and supervised on their build phase activity.

Environment: Informatica MDM 10.0.1, IDD, ActiveVos 9.2.4.1, Flat files,Java, SQL, UNIX Scripting, Putty, Visio, Tidal, Autosys.

Senior Informatica MDM Developer

Confidential, Atlanta, GA

Responsibilities:

• Interacted in business meetings to analyze the business requirements and developed a design plan.
• Coordinated with business analysts to analyze the business requirements and designed and reviewed the implementation plan.
• Worked in an Agile Software Development life cycle to successfully accommodate change in requirements.
• Worked with ETL tool Informatica Power center for performing custom cleansing when the data is loaded to the landing tables in the MDM.
• Performed a proof of concept in ETL to categorize junk records before data is pushed to landing, mocking the same functionality of post landing user exits.
• Normalized data schema across four different source systems and successfully delivered projects within budget.
• Configured source systems collaboratively and performed Batch group with Stage and Load jobs.
• Implemented Land Process for loading the customer Data Set into InformaticaMDM 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
• Configured custom landing tables and performed proof of concept integrating hub state indicator as required by the business requirements.
• Worked in a proactive manner with testers to identify and close defects before UAT.
• Peformed rule based Profiling on the client business data in understanding the depth of accuracy and duplicates which are needed for MDM implementation.
• Created draft technical design documents based on the functional design documents.
• Resolve functional as well as technical queries by taking help of functional SME or client users.
• Interacted with business users in configuring Match setup and tool proposition for Data quality Address doctor.
• Involved in designing MDM data model and created base objects, mappings, defined trust setting for sources, customized user exists, customized IDD applications.
• Reviewed and designed the MDM/ActiveVOS setup and performed development and Unit testing and deployment.
• Performed and implemented proof ofconcepts when needed to client for solution propositions.
• Worked through all the phases of SDLC including maintenance.
• Worked on the CA hub Master Data management to align four different source systems performing fine tuning to the match/merge rules.
• Initiated API calls using SOAP UI/tools to perform cleansing for Base Objects, HREF, HXREF.
• Integrated with the ETL team and developed a new approach for Initial Data loads.
• Implemented Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
• Altered Trust scores and set up Validation rules as per the business requirements.
• Created Batch deployment groupsand ran audit trail for Incremental loads.

Environment: Informatica MDM, IDD, IDQ9.7,Informatica 9.7, 9.6.0 & 9.5.1, (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat files, SQL, UNIX Scripting, Putty, Visio, Tidal, Autosys.

Senior Informatica MDM Developer

Confidential, Columbus, OH

Responsibilities:

• Teamed with business analysts to deduce the business requirements to produce effective technology solutions.
• Worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
• Involved in implementing the Land Process of loading the customer Data Set into InformaticaMDM from various source systems.
• Collaborated with the data modelers to perform mappings and organize the data using the Erwin tool for data modeling.
• Worked on data cleansing using the cleanse functions in Informatica MDM.
• Used Informatica ETL Power Center 9.6 for migrating data from various OLTP databases to the data mart.
• Worked with different sources like Oracle, flat files, XML files, DB2, MS SQL Server
• Extracted data from Sales department to flat files and load the data to the target database
• Developed complex mappings using Informatica to load Dimension & Fact tables as per STAR schema techniques.
• Extracted data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target Data mart.
• Data Quality and Data integration in real-time using SIF API's.
• Defined Trust and validation rules before loading the data into the base tables
• Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
• Performed in creating tasks in the workflow manager and exported IDQ mappings and executed them using the scheduling tools.
• Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.
• Worked on Tidal and Autosysscheduling tools depending on client’spreference to schedule tasks
• Involved in preparing required Tech Specification Documents from the Business requirements following Organization standard.
• Publishing Data using Message Queues to notify external applications on data change in MDM Hub Base Objects.
• Constructed reusable objects like Mapplets and worklet transformations combined withuser-defined functions to use across multiple mappings.
• Executed jobs using ETL frameworkby setting up scripts and configuration files.
• Created deployment groups forproduction migration (mappings, workflows, parameter files and UNIX scripts) and supportedpostproduction support during warranty.
• Practiced soft proofing on JDF enabled products to communicate between each other by exchanging JDF files through hot folders.
• Worked on UNIX platform in creating a shell script to perform functions for updating the parmfiles, sending mails and FTP files.
• Used scheduling tools to create new jobs and job dependencies are setup with different Autosys cycles.
• Experienced in writing SQL queries for retrieving information from the database based on the requirement.
• Experienced in partition creations and dimension additions.
• Involved in the UAT testing of the Items Data Mart price files tool automation project.
• Performed testing on connections, scripts, workflows, mappings and other scheduled activities.
• Responsible for handling Supply Chain Management Data Warehouse and related database and online solutions.
• Worked with the offshore team and supervised on their development activity.
• Reviewed code and confirmed it was compatible to standard programming practice.
• Conducted Knowledge transfer sessions about the project to the team and managed the project by providing reviews on it.

Environment: Informatica MDM, SIF, IDQ9.7, Informatica 9.6.0 & 9.5.1, (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Erwin, Flat files, SQL, UNIX Scripting, Putty, Visio, Tidal, Autosys.