SUMMARY

• 8+ years of relevant experience in Analysis, Design, Development and Maintenance of various software applications emphasizing on Data warehousing, EBX5 Master Data Management, Informatica Master Data Management and Informatica Power Center
• Experience working in different versions of EBX5
• Created logical data models and translate into physical database structures that integrate with existing or proposed database structures.
• Experience in code Optimization and Performance Tuning of EBX5
• Experience in development and implementation of Match and Merge configuration
• Implemented configuration of process policy, matching policy, survivorship policy and trusted source in match and merge
• Implemented all facets of MDM including Data Profiling, metadata acquisition, data migration validation, reject processing and pre - landing processing
• Created run manuals for production codes, technical specifications for the new requirements, data steward working document, best practices document
• Implemented Multi-level Hierarchy in EBX5

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, Windows XP/2000/7.0

Databases: Oracle 11g/10g/12c, DB2 UDB, MS SQL Server, MS Access

MDM Tools: EBX5, Informatica MDM

ETL Tools: Informatica Power Center 9.1/8.6/8.0//7. x

Data modeling tools: SQL Power Designer

Methodologies: SDLC, Agile/Scrum

Configuration Management Tools: Puppet

Scheduling Tools: Autosys

Version Control: Bitbucket

Project Management Tools: JIRA, VersionOne, SharePoint, Confluence

Languages: C, SQL, PL/SQL, UNIX Shell Scripting, Java

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Technical lead

Responsibilities:

• Responsible for the EBX5 schema design, data profiling, and validation with different data standards.
• Implementing multi-level Hierarchy by establishing relationship
• Creation of a Golden source of customer data via matching and merging configuration
• Performance testing for both semantic and relational data spaces
• Developed Triggers, Validation, Value Functions, Schema Extension and Access Rules etc. using EBX5 API.
• Creation of Various screens for EBX5 to provide specific functionalities for user interaction.
• Responsible for managing security access based on users and/or roles
• Conducted periodic meetings with business Analysts/product owners and gathering the requirements for new request/enhancements in the current system.
• Analyzing the system for new enhancements/functionalities and perform Impact analysis of the application for implementing EBX5 changes.
• Implemented workflow solutions. Designed and developed workflow manger utilized to run data workflow.
• Creation of Services for enablement of user needs such as Validation Service, Report Generation Service etc using EBX5 API.

Confidential, Waltham, MA

Informatica MDM Developer

Responsibilities:

• Installed Informatica MDM 9 5 In Windows with the middleware JBOSS 5
• Configured cleanse server and address doctor
• Conducting Proof of Concept for reusable DQ rules, SIF integration and writing Java code within the MDM tool.
• Implement Informatica MDM workflow including data profiling configuration specification and coding match rules tuning migration
• Build out best practices regarding data staging data, cleansing and data transformation routines within the Informatica MDM solution
• Define and build best practices regarding creating business rules within the Informatica MDM solution
• Created Base Tables, Stages tables based on the data model and number of source systems
• Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
• Worked with Business users in understanding Match Merge setup and incorporated their requirements and ideas
• Collaborated with users in defining Match Rules and conducted workshops to discuss over and under matching
• High level review of SAM discussed use of Roles creation of users and assignment of user to Role
• Defined Roles and privileges for each environment according to the platform requirements
• Defined the security such that schema will be secured with access only granted for specific downstream integration uses using users created for those specific integrations
• Created Customer onboarding process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store and define automation process for staging loading match and merge
• Configured designed and delivered MDM hubs across multiple data domains Party Service/Product Prospect
• Created Data Validation Document Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document

Confidential, Minneapolis, MN

ETL Developer

Responsibilities:

• Worked extensively in translation of business requirements into data warehouse design and developed ETL logic based on the requirement using Informatica Power Center 8.6 .
• Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Developed complex mappings to populate and incrementally load the source data to the staging area using joiner, sorter, connected lookup, router, filter, update strategy, expression using Informatica designer taking into consideration of maximize performance.
• Developed ETL design using various transformations like Source Qualifier, Aggregator, Sorter, Joiner, Lookup, Stored Procedure, Router, Filter, Transaction Control, Sequence Generator, Expression, JAVA, and XML as per necessity for source-to-target data mappings and to load the target table.
• Worked on Data mining process including data auditing, aggregation, validation and reconciliation.
• Worked extensively with variables and parameters files in the mapping and in the session to pass the value and to control the environment and source, target information.
• Contributed in performance tuning of the existing project from source to target level and debugged invalid mappings using break points, testing the stored procedure, functions, sessions, and batches and checking the target data.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Used Shell Script to handle flat files in the source level.
• Worked with store procedure and packages in PL/SQL and Unix Shell Scripting for automated execution of the job in the production environment.
• Participated in code review sessions and worked closely with QA team to resolve QA issues.
• Documented ETL design document, ETL code and Unit testing .
• Involving in Functional Testing & Regression Testing
• Developing Test Scripts to perform Functional Testing, Performance Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing, Regression Testing and Volume testing of the application using LoadRunner

Confidential, Mclean, VA

Module Lead / Senior Developer

Responsibilities:

• Extensive data analysis and profiling to understand the upstream source system
• Conducting Proof of Concept for reusable DQ rules, SIF integration and writing Java code within the MDM tool
• Analyze complex legacy Oracle stored procedures to support new development as well as impact of change requests, defect fixes and production support
• Spearheaded the architecture of new Data quality framework and defining strategies for reuse of data quality mapplets, capturing data quality violations and reporting these violations to source system owners
• Developed new Informatica mappings/mapplets/reusable, DQ lookups/workflow and debugging existing workflows and complex SQL queries
• Played significant role in data validation and reconciliation on new Informatica MDM platform
• Reviewing data governance reports and providing inputs to handle data violations
• Hands on developing base objects, configuring trust matrix, validation and match rules, IDD and hierarchies on Informatica MDM tool
• Participate in reviews with enterprise architects and other architecture staff to ensure compliance with Enterprise Architectural standards and best practices
• Preparing data mapping documents and coordinating with data modelers to design database for staging tables and data marts
• Developed end-to-end ETL process to extract, transform and load data into the datamart and downstream feeds using Informatica tools

Confidential

ETL Developer

Responsibilities:

• Worked extensively in the study of the existing project Demand, Planning Data Mart and involved in all the phases of reengineering System Development Life Cycle (SDLC) from requirement, design, development, testing, training to production support.
• Collaborated with Business analysts for requirements gathering, analysis, ETL design and development for extracting data from the heterogeneous source systems like Oracle, flat files, XML files and loading into Staging.
• Involved in massive data cleansing prior to data staging.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets /mapping Parameters/Variables.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2, and Sybase
• Designed and developed the logic for handling slowly changing dimension table's load by flagging the record using update strategy for populating the desired.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data. Analysed the existing stored procedure written in PL/SQL and Shell Script and designed new stored procedure and Shell Script to handle the work flow and flat files in the source.