Candidates About

 

Gautham InformaticaMDM

 SUMMARY

·       Senior Informatica MDM Developer with 8 years of IT experience and has portrayed skills in analysis, designing custom solutions, implementation and 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 Data Warehousing 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,10.1.0, Informatica MDM 9.7,10, 10.2  IDD, IDQ, 9.7, 10.1.1 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

 

 

 

 

EXPERIENCE

 

Sr. MDM/IDQ Admin/Developer                                                 

State of New Jersey, Trenton, NJ                                                                                      Feb 2017 – Present

Optum has been delivering health and human services BDW services since 1994- transforming data into knowledge and providing business intelligence functionality that supports Medicaid programs in designing, managing, evaluating and monitoring Healthcare operations and initiatives. Health PAS-BDW (BUSINESS DATA WAREHOUSE) focusses to consolidate data into a single repository from disparate sources, allowing business end users access to analytically ready data for extraction in their desired format, and provide the functionality to provide near to real-time and real-time data assist management with decisions.

 The BDW module must provide for all report creation and is the repository for all reports of the REPLACEMENT MIS. BDW shall be the single repository and tool to present visual analytics for the Replacement MMIS.

Responsibilities:

·         Analyzed the business requirements from the client and propose solutions and best practices related to Informatica based on the organizations RFP.

·         Involved in State meetings to report status and deliverables achieved in the Informatica Domain.

·         Worked as a Informatica Administrator and Developer.

·         Worked on different tools in Informatica (Power Center, Data Quality, Master Data Management and Metadata Management.) obtained by the state to deliver the business requirements.

·         Installed and configured Power Center, Data Quality, MDM and Metadata Manager on virtual servers and maintained them.

·         Involved in cleansing, standardizing and geocoding the MEDICAID data from the state and publishing it to other downstream systems (MARS, FADS, SUR).

·         Worked on creating SCD and CDC concepts to load, record and manipulate data to achieve HPAS History tables.

·         Participated in meetings with the network team to discuss about security checks, SSL certificates on the VM servers where Informatica tool(s) were installed.

·         Monitor data feeds from the source systems and perform data loads on a weekly/monthly basis.

·         Profiled data using the Analyst tool and created Scorecards to provide reports.

·         Created mapping documents using mapping specification in Informatica Analyst to avoid standard excel documentation.

·         Installed and configured Power Center to create L1, L2 Historical data store (HPAS) mappings to develop a Business Data Warehouse. Worked in data transitions from SDW(Legacy) to BDW.

·         Developed ETL to create an Enterprise Data Store as L3. Implemented SCD type 2.

·         Installed and configured Informatica Data Quality to standardize, Cleanse and Geocode the address from different source systems and develop profiling reports.

·          Installed and configured MDM to create a single repository for all the incoming DFD sources.

·         Worked to consolidate data from different source systems and implemented a Third Normalized form to achieve BCI MASTER (Single Repository).

·         Helped in viewing records and explained manual merge/unmerge process in IDD to data stewards.

·         Installed and configured Metadata Manager to create lineage between Informatica, Cognos, Erwin and Oracle.

·         Worked as an Administrator in creating users and setting profiles to users and assigning roles to those profiles.

·         Upgraded Power Center and Data Quality from 10 to 10.1.1.

·         Participate in daily meetings to discuss about the Data Modelling, ETL loads with respect to Healthcare domain.

·         Worked on installing and configuring SVN versioning repositories for IDQ and Cognos.

·         Monitor Informatica applications on a daily basis, check the performance of the tool and create profiles to users as an Administrator.

Environment: Informatica MDM 10.2, IDD, Informatica Data Quality 10.1.1, Power Center 10.1.1, Metadata Manager 10.1.1, SQL Developer, Putty, Visio, Windows task scheduler, Cygwin, SVN

 

Sr. MDM/ActiveVos Developer                                                                             

Motiva, Houston, TX                                                                                                       Jul 2016 – Jan 2017

Motiva Enterprise is a leading refiner, distributor and marketer of fuels. As a joint venture, Motiva is owned equally by subsidiaries of Saudi Aramco a Shell Oil Company.

Aramco is bifurcating from Shell and in the process, implementing MDM/IDD/ActiveVOS to create an orchestration project to mimic the database from Salesforce and publishing to outbound/downstream systems like MSAP, RightAngle and Ariba through BizTalk as a Middleware.

Motiva has to maintain many levels of custom Business Approvals that involves multiple external systems at Customer/Product/Location/Vendor/Material domain level.

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 source systems.

·         Designed and developed 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 designing the 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                     

Cox Automotive, Atlanta, GA                                                                                         Jan 2016 – Jun 2016

Cox Automotive is a leader in vehicle remarketing services and digital marketing and software solutions for automotive dealers, manufacturers and consumers. It is a subsidiary of Atlanta based Cox Enterprises, includes Manheim, Autotrader.com, Kelly Blue Book, and a host of other global business and brands. Customer Master creates a holistic 360 degree view of their children. (Phase 1 includes Manheim and Autotrader.com) thus providing a read-only for business.

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 Informatica MDM 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 of concepts 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 groups and ran audit trail for Incremental loads.

Environment: Informatica MDM, IDD, IDQ 9.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

Information Control Company, Columbus, OH                                                               Jul 2014 – Dec 2015

Information Control Company (ICC) is an enterprise technology leader that offers business, digital and technology solutions to help organizations get better return on their investment while improving their own process and relationships with their customers and suppliers.

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 Informatica MDM from various source systems.

·         Collaborated with the data modelers to perform mappings and organize the data using the Erwin tool for data modeling.

·         Experienced in creating and maintaining the entity objects, hierarchies, entity types, relationship objects and relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation and Informatica Data Director (IDD).

·         Participated in the development and implementation of the MDM decommissioning project using InformaticaPowerCenter that reduced the cost and time of implementation and development.

·         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.

·         <span style="font-size:10.5pt;font-fami