SUMMARY:

• 7+ years of experience in software development, maintenance, testing and troubleshooting on Master Data Management (MDM), Metadata management, data quality, data integration and Oracle database environment in various Verticals such as Pharmaceutical, Health Care Insurance, Retail, Telecom, 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.
• Using Informatica Product Availability Matrix (PAM ) for identifying Proper software for MDM.
• 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.
• Exposure in HTML, XML and working in SOAP, REST Web services.
• Familiar with JBoss, Web Logic, Web Sphere application server.
• Experience in deploying and testing web services (JAR, EAR files) in WebSphere
• Good working experience with Agile Software Development Methodology.
• Extensive ETL experience using Informatica Power center client tools (Designer, workflow manager, workflow monitor and server manager).
• Developed OLAP applications using Cognos 8BI - (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, and Analysis Studio) and extracted data from the enterprise data warehouse to support the analytical and reporting for Corporate Business Units.
• Experienced in Data warehouse reporting with Cognos 10.1, 8.0, 8.2 series, Cognos.
• 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 (Star Schema, Snow Flake Schema, FACT & Dimension Tables) OLTP and OLAP.
• 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)

EIM Tools: Informatica MDM Multi-Domain, IDD, SIF

Design/Application Tools: Star-Schema Modeling, Snowflakes Modeling, Fact and dimension tables, Erwin, Toad, SQL Navigator, Clear case, Control-M, Maestro, Microsoft Visio.

Data Modeling: Star-Schema 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

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

PROFESSIONAL EXPERIENCE:

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.
• 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.
• 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.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, OLTP Data Modeling and Data warehousing concepts (Star Schema and Snow Flake Schema).
• 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.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets .

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 reusable transformations and 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, reusable transformations 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, metadata acquisition, 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, SIF, 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 various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• 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, TeraData, 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 8i/9i using PL/SQL Developer, TOAD, SQL developer, Crystal Report