SUMMARY:

• 7+ years of experience in software development, maintenance, testing and troubleshooting on Master Data Management (MDM), data quality, data integration and Oracle database environment in various Verticals such as Pharmaceutical, Health Care Insurance, Retail and Banking industries.
• Experience in Mater Data Management (MDM) Multi Domain Edition HUB Console Configurations, Informatica Data Director (IDD) Application creations.
• Extensive experience in Master Data Management (MDM) HUB Console Configurations such as Staging Process Configurations, Landing Process Configurations, Match and Merge Process, Cleansing Functions, User Exits.
• Experience in creating queries, packages, custom cleansing functions and reusable functions
• Implemented MDM configurations for Party, Vendor, Product and Customer.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases.
• Experience in installation and configuration of MDM Hub Console.
• Exposure in configuration of Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter.
• Participated in requirement gathering and preparation of High level and Low - level Designs Throughout the Software Development Life Cycle
• Experience working with ORACLE, SQL Server, My SQL databases & writing complex queries.
• Experience in development, configuration and management of Informatica objects and working on design reviews and code reviews.
• Extensive ETL experience using Informatica Power center client tools (Designer, workflow manager, workflow monitor and server manager).
• Worked in Data Warehouse and Business Intelligence Projects along with the team of Informatica, Talend (ETL).
• Experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries and packages.
• Experience in configuring Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional modeling.
• Experienced in Data Integration from multiple sources like Relational tables, flat files, MS Excel & XML files.
• Experience in integrating external application with Informatica MDM hub using message queries as a significant advantage.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Extensive functional and technical exposure. Experience working on high-visibility projects.
• Assign work and provide technical oversight to onshore and offshore developers.

TECHNICAL SKILLS:

MDM Tool: Mata Data Management Multi Domain Edition 10.1, Informatica Data Director (IDD), Stibo Systems, STEP Tools, STEP Trailblazer 8.3

Informatica MDM Multi: Domain, IDD, STEP

Star: Schema Modeling, Snowflakes Modeling, Fact and dimension tables, Erwin, Toad, SQL Navigator, Clear case, Control-M, Maestro, Microsoft Visio. STEP Trailblazer 8.3

StarSchema Modeling, Snowflake: Schema Modeling, Fact and Dimension tables, Pivot Tables, Erwin

Business Intelligence Tools: SQL Server Management Studio, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Tableau.

ETL Tools: SQL Server Integration Services

Operating Systems: Windows 2008, 2000, XP, 2010

Databases: Oracle10g, Oracle 11g, SQL Server 2012, MS Access 2007, Putty, Win SCP

Microsoft Office: MS. word, MS. Excel, MS. PowerPoint, MS. Access, MS. Outlook

PROFESSIONAL EXPERIENCE:

Senior MDM Developer (Stibo Systems)

Confidential, Dublin, CA

Responsibilities:

• Design and Implementation of Master Data Management Solutions to address Business needs. Rolling out Master Data Management for Supplier, Product, Location.
• Designing and configuring MDM WEB UI Workflows (create and maintenance workflow) preferably in retail domain.
• Designed the Data Model, Web UI, Workbench in all the Environments Development, Testing, Staging, Production.
• Developed attributes in WEB UI of the DEV Environment.
• Creating and Updating Suppliers through WEB UI and taking it to approval in both create and maintenance workflows.
• Generating the Reports through Excel Macros, Knowledge of Excel Macro Coding and mapping of attributes.
• Developing and reviewing configuration documentation and design documentations, well as analyzing functional specifications and user requirement documents.
• Created Mapplets and used them in complex mappings to maintain the reference data from different sources
• Creating Outbound Integration Endpoints in all the environments and invoking them to generate the reports.
• Working with workflows, creating supplier profile category, supplier maintenance profile category in DEV Workbench.
• Exporting Supplier data from workbench and generating the Full Reconciliation Reports through Unix Server.
• Designed, Installed, Configure core Stibo Master Data Management Hub Components such as WEB UI and Workbench, Oracle Test Manager, Enterprise Data Management
• Good Understanding of the attributes, Objects, Workflows, Integrations, List of values and Data Model.
• Handled Master Data and Transactional Data and did the reporting of transactional data which is required by the Business Decision Support People
• Experience in integration of various data sources like Oracle, XML, SQL server and MS access.
• Experience in DocuSign that provides electronic signature authentication which helps to send the templates to a bulk of suppliers at a time.
• Involved in Deployment Code Plan before GO Live, validating all the Integration Endpoints, DSR/Recon Reports by creating supplier and generating the reports through Excel Macros.
• Experienced in Starting/Stopping the Application Server for any of the code deployment and conversion plan through Unix Server.
• Creating supplier in the TEST Environment based on the scenarios given to test the defects.
• Knowledge of the Business Rules and understanding of the business rule codes.
• Help in mentoring team member on various aspects of project, software processes and methodology.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.

Environment: Stibo STEP Trailblazer 8.3, STEP WEB UI and Workbench’s (DEV, TST, STG, PRD), OTM (Oracle Test Manager), Win SCP, Toad, Putty Configuration, Excel Macros, DocuSign, Enterprise Data Management, MS -Office.

Senior Informatica MDM Developer

Confidential, Atlanta, GA

Responsibilities:

• Designed, Installed, Configured core Informatica Master Data Management (MDM) Hub components such as Informatica Master Data Management (MDM) Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter & Data Modeling.
• Designed the Data Model, Landing Table, & Staging Tables.
• Configured Trust and Validation rules and match rules & enable Auto Match.
• Created Queries & Packages to view the data in IDD, Data Manager or Merge Manager.
• Configured batch jobs using batch group utility.
• Created the Master Data Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration.
• Implemented cleansing functions such as pre-defined functions (STRING Functions, Logic Functions, Math Functions, Data Conversion Functions) for effective consistent master data records.
• Developed Informatica Data Director (IDD) applications and queries used for Data Steward Analysis.
• Lookup tables were configured in the IDD applications.
• Handled Master Data and Transactional Data and did the reporting of transactional data which is required by the Business Decision Support People.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Good understanding in entity relationship and Data Models.
• Expertise in creating Mappings.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Experienced in all phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experienced in working with business analysts to understand requirements and translating them into ETL code in Requirement Analysis phase.
• Involved in creating High Level Design and Detailed Design documents in the Design phase.
• Experience in integration of various data sources like Oracle, XML, SQL server and MS access and non-relational sources like flat files into staging area.

Environment: Informatica MDM 10.1, IDD, SQL Server, Oracle, MS Access.

Senior Informatica MDM Developer

Confidential, Nashville, TN

Responsibilities:

• Integrated Customer data from different sources e.g. (IMS, SFDC, NCPDP ETC...) to create a Customer Master Data to get best version of truth as golden record
• Successfully completed the Hub configuration phase for the deployment of project.
• Defined standard interfaces, Data Profile, metadata acquisition, data migration, validation, pre-landing processing and Reference Entities.
• Analyzed customer/product data residing in various source systems and defined these source systems in Hub.
• Defined foreign-key relationships, lookups, query groups and queries
• Designed & developed multiple cleansing and standardization scenarios using source to target mappings in IDQ to get the data cleansed and standardized.
• Developing and reviewing configuration documentation and design documentations, well as analyzing functional specifications and user requirement documents.
• Created Mapplets and used them in complex mappings to maintain the reference data from different sources.
• Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to Data Model for new requirements.
• Involved with Master Data Management (MDM) for Customer Data Integration using Siperian tool.
• Handled Mater Data Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration, Hierarchy Manager Configuration.
• Involved with ETL developers, for developing complex mappings, Mapplets, using Informatica 8.6 designer to integrate data from different sources like Oracle, Teradata, Flat files, and SQL databases by following guidelines and loaded data successfully into target.
• Created Match and Merge Setups like Match path, Match columns, and Match rules and tuning of Match Rules.
• Analyzed the background tables for the Data analysis purpose. Tables included Stage tables (RAW table, REJ Table, PRL table), XREF table, MTCH Table, HIS table, STRP table.
• Created cleansing functions for effective result set of mapping results.
• Implemented cleanse list functions and pre-defined functions.
• Created reusable cleanse components using Graph Function, Regular Expression function, cleanse list.
• Created queries and packages in the MDM (Master Data Management) HUB Console.
• Created Applications in the IDD (Informatica Data Director) and performed Match and Merge operations.
• Assigned workflows to business users and managers to review the task.

Environment: Informatica Multidomain MDM 9.7.1, IDD, SQL Server.

Informatica MDM Developer

Confidential, San Francisco, CA

Responsibilities:

• Involved in complete life cycle of MDM implementations on Informatica MDM 9.7.1.
• Provided assistance to team members for gathering requirements, writing technical designs, build and unit test, coordination of testing and peer reviews
• Analyzing the need and fitment for MDM Hub in the typical enterprise application ecosystem of company.
• Integrated Customer data from different sources to create a Customer Master Data to get best version of truth as golden record.
• Responsible for GAP Analysis to help identify current and proposed structure of MDM system.
• Helped in ETL process to load data into landing tables of MDM Hub using Informatica 9.7.1
• Successfully completed the Hub configuration phase to deployment of the project.
• Defined standard interfaces, Data Profile, data migration, validation, match rules tuning, reject processing, pre-landing processing and Reference Entities.
• Analyzed customer/product data residing in various source systems such as (CRM, LEGACY and DNB) and defined these source systems in Hub.
• Defined the landing tables, staging tables, and configured base objects.
• Defined foreign-key relationships, lookups, query groups and queries.
• Designed & developed multiple cleansing and standardization scenarios using source to target mappings Address Doctor and configured decay characteristics for trust enabled columns and set validation rules accordingly.
• Implemented Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies within Customer’s (customer/Party) and Product entity.
• Involved in Batch job error debug and handling, Batch jobs design, Batch Group design, Release Management, schema exports and imports using metadata manager.
• Involved with data Steward Team for designing, documenting and configuring IDD.
• Implemented IDD for Customer and Product centric Hub schemas internally to validate functionality and performance for IDD.
• Help in mentoring team member on various aspects of project, software processes and methodology.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.

Environment: Informatica Multidomain 9.7.1, Oracle 10g, SQL Developer, IDD, Toad.

Informatica MDM Developer

Confidential, Irving, TX

Responsibilities:

• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Timestamping in the Mapping Designer.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.
• Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.
• Designed, Installed, Configured core Informatica Master Data Management (MDM) Hub components such as Informatica Master Data Management (MDM) Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter & Data Modeling.
• Designed the Data Model, Landing Table, & Staging Tables.
• Configured Trust and Validation rules and match rules & enable Auto Match.
• Created Queries & Packages to view the data in IDD, Data Manager or Merge Manager.
• Configured batch jobs using batch group utility.
• Created the MaterData Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration.
• Done Match and Merge Setups like Match path, Match columns, and Match rules and tuning of Match Rules.
• Created cleansing functions for effective consistent master data records.
• Implemented cleansing functions such as pre-defined functions (STRING Functions, Logic Functions, Math Functions, Data Conversion Functions).
• Developed Informatica Data Director (IDD) applications and queries used for Data Steward Analysis.
• Lookup tables were configured in the IDD applications.
• Created Queries and performed the Manual match and Merge operations in IDD.
• SIF API was created to access Master Data Management (MDM) Hub from External Application.
• Handled Master Data and Transactional Data and did the reporting of transactional data which is required by the Business Decision Support People.

Environment: Informatica ETL, Informatica PowerCenter, Oracle, SQL Server, PL/SQL.

Informatica developer

Confidential

Responsibilities:

• Responsible for Business Analysis and Requirements Collection and translated requirements into business rules & made recommendations for innovative IT solution
• Analysis of star schema in dimensional modeling and Identifying suitable dimensions and facts for schema.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Developed, documented and executed unit test plans for the components
• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Extensively worked on the.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Scheduled batch and sessions within Informatica Designer, Repository Manager, Repository Server, Workflow Manager/Server Manager and Workflow Monitor Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Employed performance tuning to improve the performance of the entire system.
• Performed Pipeline partitioning to speed up mapping execution time.
• Creating the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Created test cases and run the cases using Quality Center.

Environment: Informatica Power Center 9.1/8.6, DB2, Oracle 10gR2, SQL, PL/SQL, Toad 9.1 SQL*LOADER

Informatica/Oracle Developer

Confidential

Responsibilities:

• Extensively used all Informatica Client tools and various transformations such as Lookup, Filter, Expression (reusable), Router, Rank, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator & Normalizer.
• Designed Informatica mapplets and worklets to utilize the reusability feature of Informatica.
• Used the update strategy to effectively load data from source to target.
• Tuned INFORMATICA mappings, sessions and SQL queries. Unit testing of mappings and sessions.
• Worked extensively with dynamic cache with the connected lookup Transformations.
• Designed and optimized the Mapping to load the data in slowly changing dimensions.
• Focused on fixed and de-limited flat files, also worked with direct and indirect flat files.
• Perform design and development by creating schema object such as functions, procedures, packages, veiw, matriealized view etc by using cursors, dynamic sql and exceptional handling etc as per the model designed.
• Design, code, and maintain the Oracle systems based on established standards.
• Understand project requirements and develop design specifications.
• Perform initial design reviews and recommend improvements.
• Write clear codes and prepare coding documentations.
• Provide technical assistance to other Developers as needed.
• Analyze and troubleshoot system issues in a timely manner.
• Modify existing codes to optimize Oracle applications.
• Create DB jobs and scheduled them for automation.
• Gathered Performance report (using explain plan, TKProof and stat pack) and scheduling proactive maintenance activities.
• Migrate ETL data load from one system to DW system by passing and filtering in different Layers like Staging, ODS and Data Mining.
• Perform all business checks like cleaning, triming, creating new dimensions and partitions etc.
• Developed monthly report as per business requirements and schedule them in crystal report.
• Perform DBA activities like increase the size of particular tables pace (Add datafiles) if running out of space and take back create partition tables before performing any major activities.
• Create Re-org script and perform as per data load.
• Assist in system integration and acceptance testing and perform bug fixes less experienced staffs on programming guidelines.
• Develop database schemas, tables, procedures and permissions.
• Develop shell scripts and data management scripts.
• Determine capacity analysis and perform database tuning to improve efficiency.
• Enforce best practices for optimal performance.

Environment: Informatica, Oracle, SQL Developer, TOAD, SQL developer, Crystal Report