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 troubleshooting and testing using ETL testing tools.
• Experience working on Informatica MDM. Design, develop, test and review & optimize Informatica MDM (Siperian).
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation and Informatica Data Director (IDD).
• Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
• Experience in real time integration with different external application by using Inbound (SIF) and Outbound (message queue).
• Experience in Avos designer to create the workflows by using BPMN/BPEL methodology.
• Developed User Exits for implementing custom business rules.
• Hands on experience on designing IDD Application and experience in customizing IDD application through IDD config files.
• Hands on experience in MDM advanced options like entity 360, Smart Search, Composite base objects, Platform Staging, Provisioning Tool and Elastic search
• Experience in migrating the code from one environment to another environment using repository manager workbench.
• Work on Informatica ANALAYST to profile data from source and provided drill-down results using score-card in INFORMATICA DATA QUALITY to gather information from different systems and unify them to one global identifier using INFORMATICA MASTER DATA MANAGEMENT.
• Working on INFORMATICA DATA QUALITY, ANALYST TOOL to profile data, Cleanse data.
• Experience on using ADDRESS DOCTOR to produce LATITUDE and LONGITUDE values for reporting purposes.
• Experience in configuring the MRS, CMS, AST and DIS services on INFORMATICA DATA QUALITY.
• Experience in scheduling batch jobs for IDQ workflows and mappings.
• Experience in Cleansing, Standardizing data Geo-coding the data on Informatica DQ and MDM tools.
• Experience in applying RULES in IDQ for Profiling, Match and Merge process.
• Profiling and analysis data using the ANALYST tool in Data Quality.
• Experience in monitoring and scheduling jobs in Informatica Data Quality using batch scripts and windows task scheduler.
• Experience on working with CYGWIN to bridge UNIX and Windows environment.
• Worked on installing and configuring SVN versioning repositories for IDQ and Cognos.
• Proficient in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon's (SCD's), Change Data Capture (CDC), Customer Data Integration (CDI).
• Experience in the SIF framework and Application Program Interface (API) development.

TECHNICAL SKILLS

ETL Tool: Informatica Power Center10.1,9.6, 9.1, 8.6 and 8.1 (Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager); Informatica MDM (9.7 - 10.3HF2)

Languages: SQL, UNIX Shell Scripting and UNIX

Database: Oracle 10g, 11g, 12c; MS-SQL Server 2008, MS-SQL Server 2005

Application Server and Other Tools: JBOSS, WebSphere, SOAP, POSTMAN, CYGWIN, JIRA, WinSCP, Migration tool, Service Now, SharePoint

Techniques: Data Warehousing, Business Intelligence and Agile Methodology

PROFESSIONAL EXPERIENCE

Sr. MDM Admin/Developer

Confidential, Minneapolis, MN

Responsibilities:

• Worked on Informatica MDM as Administrator and Developer.
• Interacted with Business Analysts to understand, propose Data conversion approaches.
• Participated in meetings and provided Infrastructure specifications for building new environments
• Installed and configured Informatica MDM 10.3HF2
• Configured the PROVISIONING TOOL and ELASTIC SEARCH on different clusters.
• Created Business entities, Reference entities, Applications and Start up from scratch on the PROVISIONING TOOL to replicate the IDD Subject areas application.
• Performed POC’s to analyse conversion approaches and provided best possible solutions.
• Created Indexes on Business Entities and improved response time in Web SERVICES.
• Developed new applications on PROVISIONING TOOL and IDD to verify, compare the BES responses on E360 and SOAP/REST services.
• Created new applications page and e360 homepage, Layout view and to view on e360.
• Configured Smart search to retrieve data using BES.
• Created batch groups, Custom Match rulesets.
• Installed and Configured Resource Toolkit to automate Batch group jobs.
• Worked on improving the performance via the Batch loads.
• Performed POC on LoadByRowid and BulkImport to fit the requirements to load data for Updating and Inserting Source Systems.
• Fixed issues related to the Batch loads, Process server configurations, Tokenization errors, Provisioning tool and BES service calls.
• Ran POSINTALL scripts for Hub server/Cleanse server to fix IDD related issues.
• Configured AVOS Central to facilitate the BE workflows for data stewardship activities.
• Worked with WADL and WSDL to implement data retrieval for WebServices and Fixed Ors invalid states due to Hierarchy related issues and Business entities.
• 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.
• Generated reference tables & content files out of profile results. Created mapping and mapplets and rules in IDQ to address clean and transform data.

Environment: Informatica MDM 10.2 HF2 EBF1, MDM 10.3 IDD, Informatica Data Quality 10.2, SQL Developer, Putty/WinSCP, Visio, JBOSS, Jenkins, SOAP UI, Postman, Eclipse, Windows Task Schedular, Kibana and Elastic Search.

Sr. MDM Admin/Developer

Confidential, Lansing, MI

Responsibilities:

• Involved in cleansing and standardizing the Policy and Proposal data.
• Installed and configured 10.2 and 10.3 with Elastic Search.
• Upgraded from 10.2 HF1 to HF2 and installed EBF1.
• Interacted with the Data Architect to setup a Data process flow from DQ to MDM and promote the Smart search results to the Customer UI team on the Auto Owner’s portal.
• Worked as an MDM Administrator to install and maintain all MDM servers.
• Worked on Provisioning tool to configure the Solr and on Smart search functionality.
• Synchronized DQ tables with Model Repository Service via MDM using the Platform Staging.
• Worked on SOAP and REST (BES calls) to achieve a response time less than 2 secs for the Real time functionality.
• Implemented informatica MDM platform staging (Data Quality Rules/Mappings for cleansing/standardization) to directly loading source data to MDM staging tables by passing landing tables.
• Improved Match and Merge performance and Batch loads performance by configuring the HUB property files.
• Interacted with the Data Quality team to integrate the REAL TIME connectivity from MDM.
• Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Completed POC’s related to the REAL TIME functionality by using REST (JAXB,JAX-RS annotations)
• Configured Server and Cleanse properties and increased the Batch load performance while enabling the DMAT
• Generated and uploaded Certificates to enable the Elastic search functionality.
• Created automated scripts to back up the MDM ORS metadata using MET Command Utility and cache clearing scripts on the WebSphere Application Server.
• Helped in viewing records and explained manual merge/unmerge process in e360 to data stewards.
• Fixed issues related to the Batch loads, Process server configurations, Tokenization errors, Provisioning tool and BES service calls.
• Resolved issues related to Hotspot overmatching issues, Smart searches, Solr Index creations and disabling timeline features.
• Noticed and reported bugs in the latest 10.3 MDM with Elastic search.

Environment: Informatica MDM 10.2 HF2 EBF1, MDM 10.3 IDD, Informatica Data Quality 10.2, SQL Developer, Putty/WinSCP, Insomnia, Visio,, WebSphere, Jenkins, SOAP UI, Postman, Eclipse, Windows Task Schedular, Kibana and Elastic Search.

Sr. MDM/IDQ Admin/Developer

Confidential, Trenton, NJ

Responsibilities:

• Analysed 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 on different tools in Informatica (PowerCenter, Data Quality, Master Data Management and Metadata Management.) obtained by the state to deliver the business requirements.
• Installed and configured PowerCenter, 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).
• Participated in meetings with the network team to discuss about security checks, SSL certificates on the VM servers where Informatica tool(s) were installed.
• 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 PowerCenter 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.
• 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 PowerCenter and Data Quality from 10 to 10.1.1.
• 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, PowerCenter 10.1.1, Metadata Manager 10.1.1, SQL Developer, Putty, Visio, Windows task scheduler, Cygwin, SVN

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 Data stewards’ team to understand the roles in their hierarchy.
• Implemented Land Process for loading the customer Data Set into Informatica MDM from various source systems.
• 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 using WADL and REST services using WADL.
• Created workflows using Events, Gateways, Control flows 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 Data stewards 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.
• Configured and setup URN mappings on the ActiveVOS Console.
• Implemented workflows based on Onestep, Twostep Approval processes and customized workflows to suffice business requirements.

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 PowerCenter 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
• 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 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.
• 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

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 Informatica MDM from various source systems.
• 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 Informatica PowerCenter that reduced the cost and time of implementation and development.
• Worked on data cleansing using the cleanse functions in Informatica MDM.
• Worked with different sources like Oracle, flat files, XML files, DB2, MS SQL Server
• 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.

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

Senior Informatica MDM Developer

Confidential, Houston, TX

Responsibilities:

• Gathered and analyzed business requirements, established functional specifications and converted them to design specifications.
• Collaborated with Manager, Data Architects and Data Modelers to understand the business process and functional requirements.
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Collaborated with the data modelers using the Erwin tool for data modelling and performing mappings based on the models.
• Defined the Super-Sub entities using the Erwin tool to organize the Master detail.
• Designed and developed validation scripts based on business rules to check the Quality of data loaded into EBS.
• Worked in implementation of Profiling, Score Card, Classifier models, Probabilistic models, Human task and Exception record management as part of IDQ process.
• Performed land process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store.
• Used Informatica Designer to create and manipulate source and target definitions, mappings, transformations and re-usable transformations.
• Involved in designing MDM data model and created base objects, mappings, defined trust setting for sources, customized user exists, customized IDD applications.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Implemented cache optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Validated mappings using Informatica debugger to gain troubleshooting information about data and error issues.
• Designed and developed Informatica mappings for data loads.

Environment: Informatica MDM 9.7, SIF, Informatica PowerCenter 9.0.1 (Repository Manager, Repository Server Administration Console, PowerCenter Designer, Workflow Manager, Workflow Monitor), Erwin, Power Analyzer 4.1, Oracle 10g, PL/SQL, Autosys, Windows 2000, DB2, Windows NT 4.0.

Informatica Developer

Confidential, West Des Moines, IA

Responsibilities:

• Gathering business and Technical requirements that would best suit the needs of the technical architectural development process.
• Worked withInformaticaData Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, address standardization, exception handling, and reporting and monitoring capabilities.
• Designed the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation.
• Handled Production Support by performing normal loads, initial loads, daily loads and monthly loads.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting during the job failures.
• Created batch groups for automation.
• Create other ETL artifacts such as functional requirement document, data model, source-to-Client mapping, test case matrix, deployment document etc.
• Independently develop efficient Informatica mappings, sessions and workflows as per the design specifications.
• Design ETL data model and conduct Knowledge Transfer sessions to share knowledge with the team.
• Experienced hands on working knowledge in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Worked effectively on handling production defects and change requests.
• Analyzed source data for potential data quality issues and created the exception mappings/clean up scripts to clean up the bad data in data warehouse.
• Created Deployment groups for Informatica components for transferring the code from lower to higher region.
• Involved in maintenance of reporting tools and processes utilizing Data Warehouse data.
• Created Rules on profiled data and used the same to data quality mappings.
• Created shell scripting for running Informatica workflows and wrote SQL queries to retrieve data depending on requirements.
• Performance Tuned Informatica Targets, Sources, mappings and sessions for large data files by increasing data cache size, sequence buffer length and target-based commit interval
• Performed error handling for removing database exceptional errors

Environment: Informatica PowerCenter 8.6 (Repository Manger, MDM, Designer, Workflow Monitor, Workflow Manager), Flat files, Oracle10g

Informatica Developer

Confidential, Providence, RI

Responsibilities:

• Involved in the design, development and implementation of ETL process using Informatica.
• Generated workflows using reusable tasks, worklets and workflows containing sessions, commands, event raise/wait, decision and timers for flow control
• Involved in optimization of ETL programs and SQL queries (overriding SQL query) in order to increase performance
• Worked with relational sources and flat files
• Involved in rigorous testing of ETL mappings
• Extensively involved in monitoring the jobs in order to detect and fix unknown bugs and track performance
• Provided excellent Informatica production support
• Used Debugger to test the mappings and fix the bugs
• Automated scheduling of sessions at regular intervals using Informatica Scheduler
• Worked on identifying Mapping Bottlenecks in Source, Target and Mappings to Improve performance
• Implemented Informatica Data Quality 8.5 to do data cleansing, data matching, reporting and monitoring the XML files
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results

Environment: Windows XP, Informatica PowerCenter 8.1.x, DB2 8.1, WinSql 5.5, UNIX.