SUMMARY

• Over 7+ years of IT experience in Software Development Life Cycle (SDLC) analysis, design, development, testing, maintenance and quality assurance with implementation of software applications in MDM.
• Over 4 years of experience working in Informatica Master Data Management (MDM) Developer/Admin.
• Experience in Master Data Management concepts, methodologies and ability to apply this knowledge in building MDM solutions.
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian).
• Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling.
• Experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign key relationships, lookups, query groups, queries/custom queries and packages.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation
• Helping business to understand the Match rules configuration and decide the trust factor and Configure match/merge rules
• Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects
• Rendering experience in Designing & developing multiple cleansing and standardization scenarios usingAddress Doctor
• Expertise in ImplementingHierarchy ManagerModule in addition to Match/Merge/Unmerge which aids in depicting various hierarchies
• Worked with SIF API to interact with real time applications
• Experience in designingmappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
• Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server
• Experience in Testing with ETL Tools - SSIS/SQL Server - BI and Reporting.
• Experience on ETL design, development and unit testing estimations based on business requirements
• Enabled Searchable columns as per the business need
• Good Exposure to development, testing, debugging, implementation, documentation and production support
• Responsible for unit testing of the work done.
• Used SQL*Plus to perform DML operations for small updates.
• 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

TECHNICAL SKILLS

EIM Tools: Informatica MDM 10.3/10.2/10.1 , IDD, IDQ, SIF

Languages: JavaScript, JSP, SQL, C#, C++, HTML, XML, and .Net

Testing Tools: JIRA, HP Quality Center, QTP, Bugzilla

Frameworks: AngularJS, J2EE

Databases: Oracle 11g/10g, MySQL, Database SQL command

OS: Windows (Windows NT/2000/XP Professional), Unix, Linux, Mac OSX

Servers: JBoss 6.4, JBoss EAP 7.1, WebSphere (WAS), Tomcat

PROFESSIONAL EXPERIENCE:

Confidential, IL

Informatica MDM Developer

Environment: Informatica MDM 10.3, JBoss EAP 7.1, SQL Server

Responsibilities:

• Worked as production support and monitored MDM daily runs and nightly processes. Below are the daily process involved in our project
• Create Linux/SQL scripts to do an MDM extract of data to a flat file and send it off to the Spruce team.
• Create Linux/SQL scripts to find e-mail/phone that need to be validate through the DaaS (Data as a service) system.
• Create a backup Linux/Sql script for all of the landing tables.
• Bounced Jboss/IDQ/Elastic Search index/Tidal from the linux machines. Ran jobs from both the Batch group/viewer for particular source system.
• Worked on elastic search indexes and performed elastic health checks.
• Checked the mappings on particular jobs for staging process.
• Queried the BO tables for customer information, address, e-mails, phone, salon, loyalty accounts, and spruce data.
• Worked on Tidal schedule system to help create jobs, force start jobs, and re-run jobs.
• Modified existing SQL jobs to correctly match conditions.
• Created Cherwell Tickets for database access and MDM Tidal jobs processes.
• Worked on unmerging the accounts with the Soap UI API that the business provided and retokenized through the MDM hub console for the accounts as well as merged the accounts by running the batch Match/Merge batch job through MDM Hub console.
• Experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign key relationships, lookups, query groups, queries/custom queries and packages.
• Helping business to understand the Match rules configuration and decide the trust factor and Configure match/merge rules.
• Worked on staging and loading process using the batch viewer for initial and adhoc loads.
• Created base objects, staging tables, landing tables and defined foreign key relationships among the base objects and Hierarchy setup for all the data.
• Loaded the data into the landing tables using SQL scripts and used the batch viewer to run the Stage and Load process.
• Performed Unit Testing, worked with Quality team on System Testing.
• Worked with data steward team for designing, documenting and supporting management of MDM data.
• Involved in implementing the land process of loading the customer data set into Informatica MDM from various source systems. Below are the source systems:
• Coordinated with Business Leads in making them understand Match & Merge and incorporated their requirements and ideas.
• Worked on soft deleting and hard deleting the records.
• Worked on California Consumer Privacy Act(CCPA) project in loading and retrieving the data.
• Worked on One Trust tool while developing CCPA project in accessing and deleting the customer information.
• Taking help from Informatica vender support as we needed.
• Worked on California Consumer Privacy Act(CCPA) project in loading and retrieving the data.
• Worked on One Trust tool while developing CCPA project in accessing and deleting the customer information and experience on CCPA project for deletion and access data requests from California customers.
• Taking help from Informatica vender support as we needed.
• Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor5 in Dev, QA, Pre-prod and Prod Environments.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool.
• 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 and 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 and 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.
• Experienced in Technical Training to provide accelerated impact to team’s initiatives
• Developed and tested all the work done in Informatica MDM from lower environments to higher environments.
• Worked with architects in developing H2 console for the replication of MDM tables to SQL tables.
• Worked with Data Steward In fixing the Match & merge Issues and assisted data steward in using the Informatica MDM.
• Worked with the ETL Team to create batches and schedule jobs and integrate data from Databases.
• Developed Hierarchical view of Informatica MDM to promote it to the business as per requirements.

Confidential, Boston, MA

Informatica MDM Developer

Environment: Informatica MDM Multi-domain 9.7.1, JBoss EAP 6.1, Informatica Power center 9.1, SQL Server, Redwood Scheduler

Responsibilities:

• Designed, Installed, configured core InformaticaMaster Data Management (MDM) Hub components such as InformaticaMaster Data Management (MDM) Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter & Data Modeling.
• Installed, configured & Upgraded Master Data Management 9.7.1 (MDM) to 10.1 with latest Hot Fix on Web Logic Application Server on Linux and Windows environments.
• Informatica MDM Code Deployments and environment tuning.
• Experienced in Installing, Configuring, Upgrading and AdministeringWeb Logic & JBossapp servers.
• Performed dailyhealth checkson MDM / Web Logic / JBoss applications.
• Created database objects liketables, views, indexes and packages
• Designed the Data Model, Landing Table, & Staging Tables and configured base objects.
• Configured batch jobs using batch group utility.
• Created the Master Data Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined Trust and Validation rules and Configured Match Set Rules for getting the matches in order to eliminate the duplicate records.
• Expertise in creating Mappings.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDMHub implementation.
• 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.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Good understanding in entity relationship and Data Models.
• Implemented cleansing functions such as pre-defined functions (STRING Functions, Logic Functions, Math Functions, Data Conversion Functions) for effective consistent master data records.
• Developed InformaticaData Director (IDD) applications and queries used for Data Steward Analysis.
• Created Queries & Packages to view the data in IDD, Data Manager or Merge Manager.
• Preparing the test plan and test strategies for ETL application
• Exposure to Testing Life cycle and understand end-to-end data validation for ETL & BI systems
• Experience in SQL Database and ETL testing and working with Business Intelligence environment

Confidential, Houston, TX

Informatica MDM Developer

Environment: Informatica MDM Multi-domain 10.2, JBoss EAP 6.4, Oracle.

Responsibilities:

• Worked on staging and loading process using the batch viewer for initial and adhoc loads.
• Created base objects, staging tables, landing tables and defined foreign key relationships among the base objects and Hierarchy setup for all the data.
• Defined the Foreign Key relationships and provided lookup information for the columns in the staging tables.
• Configured Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match/Merge and cascading unmerge Process.
• Created Match Paths, Match Columns for Match and Merge Process.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• 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.
• Modified few match rules based on performance.
• 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).
• Developed IDD applications for different business teams with different requirements
• Configured hierarchies and relationships for Assets, Customers, Entities, Financial Entities and product domains
• Created subject area groups, subject areas, subject area child, IDD display packages and search queries.
• Performed Unit Testing, worked with Quality team on System Testing.
• Created MDM query’s and packages for IDD application.

Confidential

QA Tester

Environment: HP Quality center, JIRA, MySQL, Agile, .NET.

Responsibilities:

• Tested the Application using Black box Testing Techniques.
• Created, Updated and Reviewed of Test cases and Test Scenarios
• Participated in reviews and meetings.
• Created Initial test plan and developed test cases and test scripts manually.
• Interact with Developers and Business Analysts to perform various types of testing throughout Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC).
• Worked with the database administrator to migrate & maintain the applications.
• Evaluated and documented actual test results against expected results.
• Tested propriety web-based application for mobile and tablet device testing.
• Worked with business users to validate application meets their needs.
• Created Test Cases as per the business requirement and executed them.
• Help design and develop test cases / scenarios that accurately gauge product quality.
• Execute system testing to verify system feature implementation and data validity.
• Write SQL queries to connect to the database and use different types of SQL statements to verify test data.
• Participate in code reviews and bug fixes within an agile-driven development environment.
• Communicating status related to the investigation of customer found defects.
• Developing and executing Test Cases (automated is the preference, but manual when necessary).
• Working with Developers to analyze test results and debug problems found.
• Performed Manual tests in text format and Tested metadata files.

Confidential

Junior SQL Developer

Environment: SQL*Plus, SQL*Loader, MS Word, MS Excel, MS SQL Server 8.0, MS, MS Access.

Responsibilities:

• Strong SQLDevelopment Skills which includes creating Complex Business Stored Procedures, Tables, CTE's, Cursors, Views, Indexes, Triggers and Functions • Strong experience of DDL, DML, T-SQL, views, stored procedure.
• Identifying long running queries, packages etc., implementing appropriate tuning methods.
• Created permanent tables, temporary tables and table variables.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation • Used Joins to write queries that retrieve data from more than one table.
• Collect requirement from non-technical client and convert the requirement to the logical design.
• Responsible for data modelling designing EERD with inclusion of constraint like completeness, disjoint and referential integrity.
• Design and develop the relational database and implement it using SQL.
• Normalize the database to third normal form to remove dependency.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for cleansing the data, performing ETL using SSIS.
• Design the control flow and write query to execute between process when required to perform certain task or manage the data destination.
• Stage the data by cleansing and monitoring them.
• 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.