SUMMARY:

• Around 7.5+ years of diversified information technology experience in the field of Software Development, Project Management, Data Warehousing, Data Integration, Informatica MDM, ETL and Application/Production Support.
• Experience has been focused in designing, development, implementation and deployment of various Entity Relationship and data warehouse Business intelligence projects with strong Technical skills, Analytical ability, and Functional skills.
• Expertise lies with most aspects of SDLC including requirements analysis, documentation, design, development, testing, implementation, and deployment. Led Master Data Management and data warehouse projects End to End by providing business intelligence, Data Quality, data integration and Reporting solution.
• Strong ETL experience of using Informatica Data Quality, Power Center, and Power Exchange & MDMHUB versions, Power Center Client tools, Informatica Developer, Informatica Analyst, Informatica MDM Hub Console, and Informatica Data Director.
• Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects
• Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation.
• Identifying the Entities, Attributes, and their relationships to create Logical Data Model, Converted the logical to Physical Data Model through Erwin Tool for MDM and Data warehouse Projects.
• Worked in Entity relation modelling for Mastering Product & Party MDM tables, design techniques and data Modelling using Star/Snowflake Schema Design, Fact and Dimensional tables.
• Expertise in installing, managing, and configuring Informatica MDM Hub Server, Informatica MDM Cleanse Server, Hub Resource Kit, ACTIVE VOS Console and IDD.
• Configured the Source Systems and Trust for each attribute in the ORS which helps in Match & Merge Rules (Exact and Fuzzy) for consolidation process.
• Created the Base objects, Staging tables and landing tables foreign key relationships, static lookups, dynamic lookups, Cleanse Lists, Cleanse Functions queries, packages, and query groups.
• Created Stage, Load, Match and Merge jobs to load the source system data into staging with help of mappings and to load Base Objects.
• Created IDD/ HM / SFI Queries, Packages (PUT & Display) and Search Queries (Custom Queries).
• Experienced in creating the UserExit on regular intervals of MDM Process like Pre - Stage, Post Stage, Post Load, and Post Match.
• Configured the ActiveVOS for Product MDM in IDD for One Step & Two Step Approval process.
• Extensively used the different types of SIF API's like Data Steward Services, Data Retrieval Services, Data & Data Update/Insert Services, Merge Workflow Services and Batch Group Services.
• Extensively used the SOP UI, SIF API's like getORS, get, Put, PutClean, BatchExecuteDelete.
• Proficient in creating Column and Rule Based Profiling with PDQ and LDO's for deep dive into Master Tables.
• Experienced in creating IDQ mappings using Consolidation, Key Generator, Match, Merge, Exceptional, Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Experienced in creating the Consolidation data with the help of Key Generate, Match and Consolidation Transformations.
• Experienced in creating Mapplet, RuleSet, Content Sets, Human Tasks, Workflow and Applications in IDQ.
• Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume, and monitor master data using IDD.

TECHNICAL SKILLS:

Environment: Windows XP/7/8, Linux, Sun Solaris, Windows Server

Languages: C, C++, SQL, PL/SQL, C, PERL, Shell Scripting

Web Technologies: HTML, Java, J2EE, JavaScript, JQuery

DWBI Tools: Informatica Power Center 9.5.1/9.0.1/8.6.0

Databases: Oracle10g / 11g, SQL Server / 2012, DB2, Netezza 7.0, Teradata BTEQ Scripting.

MDM Packages: Informatica MDM Multi Domain Edition 10.0, 9.7.1, 9.5, 9.1. Informatica Data Director (IDD) 10.0, 9.7, 9.5. Informatica Data Quality(IDQ) 10.0, 9.6, DDM 9.6, ACTIVE VOS (9.2.2)

Other tools: ERwin 7.2

Control: M & Autosys, SQL Developer, SQL Server Management Studio and TOAD, SQL*Plus, SQL*Loader, Teradata Load Utilities like Fast Load, Multi Load, Fast-Export, CA ERwin (Data Modeling)

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

Sr. Informatica MDM / IDQ Developer

Responsibilities:

• Responsible for creating Product ORS, Users, Groups, and their required access.
• Responsible for creating the Product data model in Erwin and importing into Informatica MDM HUB Console.
• Created multiple landings and Business Objects and created source systems to create staging tables and defined relationship between the Base Object's for Product.
• Configured Audit Trails and Delta Detection in Mapping Settings to load RAW and PRL tables.
• Configured Lookup in staging tables based on foreign key relationships.
• Created complex mappings by using cleanse functions and configured stage process.
• Created match rules like fuzzy match for finding the probabilistic match of the records and exact match for finding the exact match of the records in Base Objects.
• Configured queries and packages to view data in Base Object's and PUT Packages for manual Merge Process.
• Configured Cleans match server for Cleanse functionality and other third-party servers for scheduling and secure authentication.
• Importing schema from both Hub console built in Databases and external Databases.
• Configured Batch Jobs to execute Stage, load, Match and Merge processes and analyzed Load Jobs in Batch Viewer for resolving Bugs/errors.
• Worked on server logs for troubleshooting information for support purpose.
• Used user exists for constraints-based loading and for other Business requirements.
• Created the customized IDD design for Product and IDMP Model.
• Have configured the Smart Search and Entity 360 in IDD for Product MDM.
• Experienced in creating the UserExit on regular intervals of MDM Process like Pre-Stage, Post Stage, Post Load, Post Match.
• Proficient in creating Column and Rule Based Profiling with PDQ and LDO'sfor deep dive into Master Tables.
• Experienced in creating Scorecard to Project the different checks like Consistency, Completeness, Accuracy and Conformity.
• Experienced in creating IDQ mappings using Consolidation, Key Generator, Match, Merge, Exceptional, Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Experienced in cleansing, Standardizing the data through Labeler, Parser and Standardizer transformations.
• Experienced in creating the Consolidation data with the help of Key Generate, Match and Consolidation Transformations.
• Created packages for entity BO and Relation BO which used to view the hierarchy.
• Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume, and monitor master data using IDD.
• Responsible for creating the Materialized views in providing the data to Downstream for Analytical purpose.
• Responsible to create L1/L2/L3 Materialized Views to the downstream after mastering the Master Data for Product and their child dimension tables.
• Have created IDD for Product and IDMP tables to provision Data Stewart to Monitor, Manage and Data Governance the Product data.

Environment: Oracle 11g R2 Client, Teradata 15.0, Informatica 9.6.1, Informatica MDM HUB 10.2, Informatica Data Quality 9.6.1, ACTIVE VOS (9.2.2). CA Software Change Manager, HP ALM, UNIX, Sql Server Management Studio, Vena System, WinSCP, Endeavor- CA7.

Confidential, North Brunswick, NJ

SIF Developer/ActiveVOS Developer

Responsibilities:

• Develop the web services in getting the data loaded into the Hub from the external applications, Using the Java SIF put, and cleanse put APIs.
• Develop the web services to search data from Hub using Java SIF search APIs.
• IDD configuration using subject area group, subject area, subject area child/grandchild, sibling reference.
• IDD Customization for Data View using IDD User Exit.
• Hub User Exits: PostLoad, PostMerge to perform business operations.
• Develop External Applications (File Upload, User Management) using SIF APIs and integrated in IDD.
• ActiveVOS integration with IDD and Hub.
• Develop ActiveVOS custom workflow for Customer/Vendor domain.
• Worked on ActiveVOS human task for IDD approval process.

Environment: Informatica MDM 9.7.1/10.2 Informatica Data Director, ActiveVOS 9.2.4.2, Informatica Power Center 9.6, JBOSS, Oracle 11g, PL/SQL, TOAD, Address Doctor Cloud.

Confidential, South Portland, ME

ETL Informatica IDQ / MDM Developer

Responsibilities:

• Understand the existing subject areas, source systems, target system, operational data, jobs, deployment processes and Production Support activities.
• Worked with business analysts for gathering requirements from high-end users and Performed Analysis on Business Data.
• Created the High Level and low-level Design Document for the DQ Services.
• Profile source data using IDQ tool, understand source system data representation, formats & data gaps Created Exception handling process and worked on the best practices and standards for exception handling routines.
• Build profiling, cleansing and validation plans.
• Analyse profiling results and make recommendations for improvements.
• Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ.
• Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.
• Worked on IDQ parsing, Standardization, matching, and web services.
• Imported the mappings developed in data quality (IDQ) to Informatica designer.
• Worked on Informatica Analyst Tool to get score cards report for data issues.
• Used Informatica data quality tool to cleanse and standardize the data while loading to staging tables.
• Worked closely with the Business in gathering the Match rules and created the Match rule document.
• Analysed the business data and defined the Match and Merge rules and Trust Scores for MDM Hub.
• Developing the Mappings to move the data loaded from Landing to Stage by using various cleanse functions.
• Developed the Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and Merge Process.
• Created Web services in IDQ developer tool and generated WSDL file for real time services.

Environment: Informatica Platform 9.6.1, Informatica PowerCenter 9.6, MDM Multi domain9.6.1, SQL Server 2012, SQL Scripting, Windows XP and Agile Methodology, HP Quality Center, SOAP UI.

Confidential

Informatica / MDM Developer

Responsibilities:

• Involved in landing the data from Seven Different source systems by running external batch process to load business data for creating customer master data. External batch process used was ETL process.
• Defined the Landing tables, Base objects, staging tables, foreign key relationships, lookup definitions, queries, packages, and query groups.
• Analysed the source systems for erroneous, duplicative, and integrity issues related to the data which is resided in various source systems such as ERP, LEGACY, CRM, DNB, SALES system, and defined those all source systems in systems and trust model workbench.
• Developed and managed relationships between data domains for the data models.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Analysed the business data and defined the Match and Merge rules and Trust Scores for MDM Hub.
• Involved in loading data from different sources to staging area by cleansing data to do this we are using Trillium services and Duns Numbers from Duns and Bradstreet (DNB). After getting data as per business requirement from DNB and Trillium we are loading data to the ware house
• Involved with ETL developers, for developing complex mappings, mapplets, reusable transformations using designer to integrate data from different sources like Oracle, Flat files, and SQL databases by following guidelines and loaded data successfully into target.
• Used Informatica components extensively Repository, Designer, Workflow Manager & Workflow Monitor.
• For loading business logic successfully to database used different transformations like Router, Expression, Source Qualifier, Aggregator, Filter and Sequence Generator transformations extensively.
• Created workflows and used various tasks like Email, Event-wait and raise, decision in workflow manager.
• Involved in interaction with DBA team for creation of primary and secondary indexes on data warehouse tables.
• Used debugger to test the mappings and fixed bugs accordingly.
• Created Session and Batches using server manager to execute mappings.

Environment : Informatica Multi Domain MDM 9.1, Informatica Data Director 9.1, Informatica Power Center 9.1, Oracle 11gR2, IBM DB2, Windows Server 2008, Teradata, SQL*Loader, Erwin.

Confidential

ETL Informatica Developer

Responsibilities:

• Responsible for design and implementation needed for loading and updating the warehouse.
• Responsible for loading data from source systems like sql server, Flat files into Oracle tables using various transformation - Expression, Lookup, Source Qualifier, Update Strategy etc.
• Applied business and application knowledge to design the data loads for consistency and integrity.
• Worked with production load standards and error handing.
• Assisted in performance tuning by running test sessions.
• Created and facilitated presentations and demonstrations for Informatica.
• Scheduled Informatica workflows using Shell Scripts. Created Tasks, Workflows and Worklets using Workflow Manager.
• Created the transformation routines to transform and load the data. Tuned Mappings and Workflows for better performance.
• Fine-tuned Transformations and mappings for better performance.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Created the transformation routines to transform and load the data. Developed processes for automation of loading data using parameter driven sessions for batch schedule processes, verification and re-conciliation of data stored in several different source systems.
• Experience with Teradata as the target, worked with BTEQ, FastLoad and MultiLoad
• Tuning and performance improvement of the jobs in Informatica. Translated business requirements to Informatica Mappings. Involved in Unit testing of mappings.
• Designed and documented validation rules, error handling routines and testing strategy for the mappings.

Environment: Informatica Power Center 9.0 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Oracle 10g, Teradata 13.0, UNIX Shell Scripting, Toad, SQL plus, PL/SQL.