SUMMARY:

• Over 8+ years of IT experience with special emphasis on System Analysis, Design, Development and Testing as an MDM hub, Data Quality and ETL specialist
• Designing, Installing, configuring core Informatica MDM Hub components such as Informatica Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter Address Doctor
• Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
• Designed & developed multiple cleansing and standardization scenarios using Address Doctor
• Helping business to understand the Match rules configuration and decide the trust factor and Configure match/merge rules
• Addressing issues of master data definition, metadata acquisition and data migration including data profiling, validation, clean-up and remediation, and source to target mapping
• Performed cleansing and mapped business requirements to available features in IDD
• Implementing IDD applications to maintain/manage data, access relationship hierarchies and configured task management to route tasks to the Data stewards
• Implementing SIF API’s on Real-time to update, insert and delete data in the MDM Hub
• Configuring charts on the dashboard according to business requirements in IDD and user exits in IDD for selective validation alert pop ups
• Configured Informatica Hierarchy Manager and its components entity types, hierarchical, relationships types, packages and profiles
• Extensive experience in creation of ETL Mappings and Transformations using Informatica Power Center to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, ERP Source Qualifiers, Aggregators, Filters, Joiners
• Excellent with PL/SQL Stored Procedures, Packages, Database Triggers and SQL * Loader
• Highly proficient in creating transformations and mappings, processing tasks, scheduling sessions, importing/exporting repositories, managing users, groups, associated privileges and folders.
• Experience with Relational and Non-Relational databases i.e. Oracle 11g/11i/10g/9i, SQL Server, DB2, and flat files
• Proficient with Informatica Data Quality (IDQ) for cleanup and massaging at staging area
• Experienced Data Management Analyst self-driven to quickly deep dive, learn, develop, commit and extend support to the delivery of project and organization goals.
• Excellent communication and interpersonal skills and an attitude to learn the new cutting-edge technologies.
• Ability to quickly analyze and come-up with an efficient industry standard solution for a given problem
• Responsible for developing Mappings, Mapplets and Rules using different types of transformations like Parser, Address Validator, Key Gen, Match etc. transformations, created PDOs and LDOs
• Analyzed Data Profiling Results and Performed Various Transformations
• Experienced in developing scorecards by using the rules developed.
• Experienced in web technologies like HTML, CSS, OO JavaScript, Bootstrap, JQuery, JS Frameworks (Angular & React) and CMS tools (WordPress, Joomla, Opencart)

TECHNICAL SKILLS:

EIM Tools: Informatica MDM Multi-Domain Edition 10.x/9.x, Siperian Master Reference Management XU, IDD, SIF

Cleanse Adapters: Address Doctor

Databases: Oracle 8.x/9.x/10g/11g, DB2, MySQL, MS-Access. Editors (SQL Navigator, Toad), Teradata, MongoDB

Database Client Tools: TOAD, SQL*PLUS, SQL*Loader SQL Navigator Export/Import

ETL Tools: Informatica Power Center 9.X/10.X

Data Modeling: ERWIN 4.0, MS Visio 2000

Programming Skills: C, C++, JAVA, SQL, HTML, UNIX Scripting, JavaScript, CSS, JQuery

Application Servers: Web Logic 10.x, JBoss 6.x, WebSphere 8.x

Package: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word), Visual Studio

Environment: Windows SERVER 2012/2008, Sun Solaris, Unix, RHEL

PROFESSIONAL EXPERIENCE:

Confidential, PA

Informatica MDM Consultant

Responsibilities:

• Configuration and creation of landing and staging tables for newly added sources.
• Added new sources to the existing MDM implementation.
• Create mappings to load data in to the staging tables.
• Build the cleanse functions based on the requirements for the mappings.
• Defined the Foreign Key relationships and provided lookup information for the columns in the staging tables.
• Tested already existing match rules and performed match tuning by determining over and under matches.
• Modified few match rules based on performance.
• Created mapping documents, functions speciation's document and technical specification documents.
• Defined Trust and Validation rules and Configured Match Set Rules for getting the matches in order to eliminate the duplicate records.
• Migration of Siperian objects from Dev to QA and to Production environments.
• Configured Informatica MDM hub on WebLogic application server.
• Loaded the data into the landing tables using SQL scripts and used the batch viewer to run the Stage and Load process.
• Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume and monitor master data using IDD. (Informatica Data Director).
• Configured the Hierarchies using Hierarchy Manager to identify hierarchical relationships.

Environment: Informatica Multidomain MDM 10.1, Informatica Power Center 9.6/, UNIX HP-UX, LINUX, Oracle 11g, SQL Developer, Salesforce.com JBoss 6.4.0

Informatica MDM Developer

Responsibilities:

• Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor5 in Dev, QA, Pre-prod and Prod Environments.
• Led effort for gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Created and documented the secure resources, roles, users for roles, and assigned privileges to roles using Security Access Manager in Dev, QA, Pre-prod and Prod environment.
• Involved in developing and configuring the Hierarchies using Hierarchy Manager to identify hierarchical relationships.
• Configure Informatica Data Director (IDD), created IDD Applications, Subject Area Groups, Subject Areas, Child Subject Areas and Grand Child Subject Areas.
• As per the Business, customizes the IDD screens, design IDD search queries with advanced search options.
• Created and implemented different validations within IDD screens using the cleanse functions and User Exits.

Environment: Informatica Multidomain MDM 10.1.0, Informatica Power Center 9.6.0, JBoss 6.4, Oracle 11g, SQL Developer, Address Doctor, IDD, SIF, Toad, SQL*Loader, Windows Server 2012

Informatica MDM Consultant

Responsibilities:

• Configured Informatica Data Director (IDD) in reference to the Data Governance of users, IT Managers & Data Stewards.
• Created Base objects, staging tables, landing tables and defined foreign key relationships among the base objects and Hierarchy setup for all the Well data.
• Defined the MDM Development Methodology and performed Match and Merge Rules after a detailed analysis of different source data.
• Created Match Paths, Match Columns for Match and Merge Process.
• Defined Search Strategy and Rules using Match Rule Sets for Match and Merge Process for complex scenarios.
• Performed Data Steward Activities like manual Merge/Unmerge and updating data.
• Created subject area groups, subject areas, subject area child, IDD display packages and search queries.
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments.
• Involved in performance tuning of the existing SQL queries.
• Provided status reporting to the Higher Management and partnered with Testing, Business Information and Configuration Management/Support teams to ensure quality implementations and the rollout of standardized and supportable code.

Environment: Informatica Multi Domain MDM 9.7, Informatica Data Director (IDD) Oracle 11g, TOAD, JBoss 6.2, AddressDoctor 5, Informatica 8.6, Informatica Data Quality 9.0.

ETL Developer

Responsibilities:

• Responsible for design and development of Sales Data Warehouse.
• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Extracted data from heterogeneous sources like Oracle, SQL Server.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Conducted a series of discussions with team members to convert Business rules into Informatica mappings.
• Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Mapplets and used them in different Mappings.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Monitoring the Data Quality, generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
• Worked with SAP and Oracle sources to process the data.
• Worked on SAP for data migration Human Resources and Finance and converted various objects on Organizational Structure, Addresses, Time, Basic Pay, Bank Details, Recurring Payments, Tax assignment, Insurance Plans, Payroll etc., to generate report from SAP BI system.
• Worked with Pre-and Post-Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Implemented pipeline partitioning concepts like Round-Robin, Key-Range and Pass Through techniques in mapping transformations.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Worked on the data masking activities for cloning the GDW for several buyers.

Environment: Informatica Power Center 9.1, Oracle11g, SQL Developer, Linux

Java Developer

Responsibilities:

• Developed application using Java Spring Framework and used Eclipse Integrated Development Environment (IDE), SVN and Ant.
• Developed the UI layer using struts, CSS, JSP, JavaScript, JSTL, XML and XPath.
• Developed the presentation layer using struts MVC.
• Developed various SOAP based Web Services using apache axis2 implementation.
• Developed various service codes to provision the lines and configured them with iBatis and REST web services.
• Used spring framework for wining and managing business objects.
• Developed PL/SQL programming on Oracle Database using Oracle SQL Developer and Java JDBC technologies.
• Involved in creating various Data Access Objects for Addition, modification and deletion of records using various specification files.
• Managed service dependencies using spring dependency injection.
• Written Junit test cases for unit testing and load testing for various service codes.
• Monitored the error logs using Log4j.
• Used SVN for version and source control.

Environment: Java/J2EE, Spring 3.0, SOAP Web Services, RESTful Web Services, JMS, IBATIS 2.0, Oracle, WebLogic, Junit 3.0, Ant, SVN, Apache axis2 and CXF, Log4j, SQLite

SQL Developer

Responsibilities:

• Designed, created and maintained the database.
• Used tools like SQL *Loader to load the data into the database tables from flat files and excel sheets.
• Created control files for fixed length data, variable length data and for data that has to be inserted in multiple tables within a database at a time.
• Used SQL*Plus to perform DML operations for small updates.
• Created number of database Triggers using PL/SQL.
• Created indexes for faster retrieval and improved query performance.
• Customized different modules of reports after upgrade process using MS Access.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Involved in programming, debugging, and unit and system integration testing of modules.

Environment: Oracle 9i, SQL*Plus, SQL*Loader, MS Word, MS Excel, MS SQL Server 8.0, Erwin, MS Visio, MS Access.