SUMMARY:

• Around 8 years of work experience in IT Industry, expertise in Developing DW/BI applications and Master Data Management applications, Data Governance Applications and Data Quality.
• Experience in Base Object, Match Path, and Match columns, Match Rule, logic of Fuzzy match and exact match and Creating and enhancing Trust Rules
• Experience in create an Operational Store (ORS) and configure in MDM Hub Master Database.
• Experience in Installing and Configuring of Informatica MDM Hub Console and Data Director
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules,
• Merge properties and Batch Group creation.
• 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.
• Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
• Designed, Installed, Configured core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server.
• Experience in SQL, PL/SQL and Oracle 12c/11g/10g, SQL Server 2012/2008/2000 Triggers, Views, Indexes and query optimization.
• 2+ years of Professional experience in the space of Informatica AXON and EDC
• Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, COBAL/VSAM Files, JSON,XML(Files), JMS and MSMQ to load into Data Warehouse/Data mart targets
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Extensive experience in Extraction, Transformation and Loading of Data into Enterprise Data Warehouse using Informatica Power Center 10.1,9.x,8.x,7.x versions.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets and reusable transformations
• Defining Data Governance strategy, formulating Data Governance council, Data Quality Assessments, providing assistance in identifying. Evaluating designing systems, procedures to meet strategic data transformational and business requirements.
• Publishing the data using BES to downstream systems and using out of data model and customizing according to business requirements.
• Experience in Data Extraction, Data Profiling, Data Cleansing, Data Standardization, Data De-Duplication using Informatica mappings.
• Experience in creating Data Quality dashboards for Data Quality monitoring
• Expertisein Data Quality validation, Data Profiling and Data analysis in Enterprise Data Warehouse environment.
• Experience in Profiling the Data from the current Source systems and identify Data Quality rules for cleansing and standardization.
• Experience in working SIF framework, REST API protocols using SOAP/POST MAN.
• Having Sound Knowledge of concepts of Data Quality and Information Management and Informatica Active VOS, Root Installation.
• Experience in supporting the business and IT to deliver the ongoing data quality and data governance activities.
• Experience in communicating all the levels within organization to support Data Quality Projects.
• Work exceptionally well in a team or in an individual environment (self-starter) and Ability to learn new technologies and tools quickly.

TECHNICAL SKILLS:

MDM Packages: Informatica MDM Multi Domain Edition 10.x Informatica Data Director (IDD), JBoss Server

Data Governance: Informatica AXON (7.x), EDC (10.x)

ETL Tools: Informatica Power Center 10.1/9.6.1/9.5.1/8.6.1 Informatica MDM

IDQ Packages: Informatica Developer 10.1 and Informatica Analyst

Databases: Oracle 9i/10g, 11g/12c SQL Server 2014, 2012, 2008, 2005

Tools: and Utilities:TOAD 10.1, Text pad, Word Pad, SQL Developer 4.0.3

Environment: Windows 7/XP/2000, UNIX, Windows Server 2003, 2008/Linux

Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word), Visual Studio, Java Eclipse

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT, Dimensions, Relational Modeling, Physical, Logical Data Modeling, and ER Diagram

PROFESSIONAL EXPERIENCE:

Confidential, Pennsylvania

Senior EDC/Axon/DQ/MDM Developer

Responsibilities:

• Worked with business people and explain them about Data Governance Framework
• Worked with different sources such as SQL, TD, MSQL, Flat files and XML sources, XSD, Cobol, YAML files on EDC.
• Involved in business and Architecture discussions and explained them how to write glossaries, data sets, system definitions.
• Involved in installation and configuration of SAP Business Objects Data Services 4.0. on EDC
• Architecting and implementing enterprise BI solutions. Created number of work flows for change request management policies.
• Integrated EDC with AXON to capture the key business terms under each application in AXON and to capture the impact analysis on the applications on any data change and to understand the data quality across systems
• Populated Metadata content and associated business terms to the Business Glossary using Informatica Enterprise Data Catalog and AXON
• Created and Enforced Policies and Regulations in AXON
• Integrated AXON with IDQ to identify the critical data elements and evaluate the data quality health of each system
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Used Metadata manager for validating, promoting, importing and exporting repositories from different environment to EDC
• Configure operating models to orchestrate the collaboration between business Metadata and technical Metadata.
• Worked across lines of business to ensure their domain's data is managed and understood.
• Used address validator for validating the address of the client in IDQ Mapping.
• Establish and ensure adherence to an enterprise data governance framework for data policies, standards and practices, both at the department and Business and Functional areas level, to achieve the required level of consistency, quality and protection to meet overall business needs
• Serve as a liaison between Business and Functional areas and technology to ensure that data related business requirements for protecting sensitive data are clearly defined, communicated and well understood and considered as part of operational prioritization and planning.
• Created Business Glossary, Data sets, systems, Attributes, Roles, Organization workflows in Axon
• Identified Golden Record for Customer Data by analyzing the data and duplicate records coming from different source systems.
• Define roles and responsibilities related to data governance and ensure clear accountability for stewardship of the company’s principal information assets.

Confidential, Quincy, MA

MDM/DQ/AXON/EDC Developer

Responsibilities:

• Worked with different sources such as SQL, TD, MSQL, Flat files and XML sources, XSD, Cobol, YAML files on EDC.
• Involved in business and Architecture discussions and explained them how to write glossaries, data sets, system definitions.
• Involved in installation and configuration of SAP Business Objects Data Services 4.0. on EDC
• Architecting and implementing enterprise BI solutions. Created number of work flows for change request management policies.
• Defining, designing, developing & optimizingETLprocesses for enterprise data warehouse.
• Established and oversight of data governance, data standards and release policies.
• Worked on Dimensional Data Modelling creating New Models and updates of existing models
• Created lineage between from source to target.
• Worked with BI team to remodel BI Portal where all the business objects report render data.
• Worked with Composite tool to provide different data services and web services to other development team.
• Performed Multiple scans on Oracle, MySql, Power Center, Teradata, SAP Bo, Azure Data Lake store, Daata bricks, Synapse, MSQL,
• Provided solution and recommendations on how to use DG tools
• Created end to end lineage starting from source to destinations
• Scanned XML, JSON, YAML, eSQL files and created custom resource and custom lineage between these files
• Given demo to Stake holders, Application owners, technical people and business people
• Created data domains document, Playbook document, BRD document, PPT etc.
• Worked on advanced scanners and scanned snowflake systems and Data stage using EDC scanner
• Worked on updating the business title in EDC using bulk uploads
• Explained each and every facet to Data steward people and help them in writing bulk upload spread sheets for different facets.
• Experience with project starting from scratch to prod deployment.
• Created workflows for the change request process to handle the data market place
• Created and implemented MDM Customer Data for Marketing purposes.
• Implemented onboarding data rules for technical metadata into Axon

Environment: Informatica MDM (SIF,E360,BES,Provisioning Tool), Active vos,DQ, AXON, EDC, XML, YAML, SQL Developer, TOAD, CA Work Automation, WebLogic 12C server, Oracle 10g, DB2, Windows 2000, Linux, and UNIX, Power Center 10.x, IDQ(Developer) 10.x, Informatica Analyst, Post Man, Soap UI.

Confidential, Jersey City, NJ

MDM/EDC Developer

Responsibilities:

• Designed and created ORS, User Creation, Informatica MDM Database Configuration
• Designed and created BO, staging tables, mappings, transformations as per business requirements.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Subject matter expert for critical data within various business domains.
• Work with a set of stakeholders to identify the data required to operate an area of the business.
• Accountable for defining and managing data governance standards for data quality and metadata
• Participated in identifying key data elements, governance over data lineage, technical metadata.
• Identify Trusted Source, Business owner & Operational owner for each of the KDE, Define business definition, Business rules.
• Configured the Base objects, Staging tables, foreign key relationships, lookups, queries, packages, query groups and custom functions.
• Used Hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Set up match/merge and run match rules to check the effectiveness of MDM process on data.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data for Organization, Individual and Products in IDD data tab.
• Implemented the approval process for subject areas in IDD, according to business rules and requirements
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Defined the security such that MDM ORS schema will be secured with access only granted for specific integration uses, using users created for those specific integrations.

Environment: Informatica MDM Multi Domain Edition 10.x SQL Developer, EDC, AXON,DQ,JBoss,SQL Developer, Netezza, BODI, PowerCenter 10.x.

InformaticaDeveloper/MDM

Confidential, Raleigh, NC

Responsibilities:

• Collaborated closely with Business Analyst to understand the business data flow and in gathering requirements
• Configured and installed Informatica MDM Hub server, cleanse server, and Address Doctor5 in Development, QA, Pre-prod and Prod Environments.
• Worked closely with ETL data architect for performing land batch process to populate data from external source system to landing tables in hub.
• Configured the Base objects, Staging tables, foreign key relationships, lookups, queries, packages, query groups and custom functions.
• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Worked with different sources such as SQL, Flat files and XML sources.
• Monitoring Smart Flash Cache Activity on Oracle Exadata.
• Involved in business and Architecture discussions.
• Created and Imported/Exported various Sources, Targets, and Transformations usingInformaticaPower Center 10.1 Designer.
• Architecting and implementing enterprise BI solutions.
• Defining, designing, developing & optimizingETLprocesses for enterprise data warehouse.
• Established and oversight of data governance, data standards and release policies.
• Worked on Dimensional Data Modeling creating New Models and updates of existing models
• Involved in Analysis by querying to tweak performance of code and output
• Involved in design of double mile stoning of the data in all data marts, which help bank users to provide the data in different snapshots.
• Worked with BI team to remodel BI Portal where all the business objects report render data.
• Worked with Composite tool to provide different data services and web services to other development team.
• Worked onETLworkflows to update the new data marts with data from old data marts.
• Defined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities. created JILL scripts for scheduling the jobs run on daily basis and weekly basis. used slack for communication and JIRA for tracking of Ticket status.
• Done UAT testing before moving the code to production
• Developed Framework Manager models (Layers Architecture, security, IQDS - Sources of Transformer, Packages.
• Runned different kinds of depended jobs in Autosys.

Environment: Informatica MDM 9.x InformaticaPower Center 9.6.1/8.1.1, Power Exchange, Oracle 10g, DB2, Flat Files, XML, Mainframe, PL/SQL, SQL*PLUS, Erwin 7.2, OBIEE, Unix Scripting, Windows NT, TOAD, Autosys, CVS.

Informatica Developer/MDM

Confidential -Chicago, IL

Responsibilities:

• Involved in Requirement analysis in support of Data Warehousing efforts.
• Reviewing the data model andETLflow with Modelers & Architects.
• Providing the time estimation of various tasks involved in development phase.
• Understanding of client requirements during team discussions.
• Development ofInformaticaMappings as per the requirement in STM to load data into the Data warehouse.
• Writing SQL Scripts based on the requirement.
• Scheduling ofInformaticasessions for testing automation of loads.
• Performance tuning of long running jobs inInformatica.
• Updating ofETLSpecification, Test Case and Reporting Metadata Documents after testing in various environments (Development, QA and Production)
• Creating the functions and few rules for having a good data quality.
• Extracted the data from the Flat Files, Oracle and My Sql into staging area and populated in to data warehouse which is DB2.
• Developed and documented data Mappings/Transformations andInformaticasessions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• UsedInformaticaPower Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in Migration & Testing of mappings, sessions, worklets and workflows fromInformatica8.6 toInformatica8.6.1 and make sure all the environment is upgraded properly.
• Done UAT testing before moving the code to production
• Developed Framework Manager models (Layers Architecture, security, IQDS - Sources of Transformer, Packages.
• Runned different kinds of depended jobs in Autosys.
• Involved in gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Involved in implementing the Land Process of loading the customer/product Data Set intoInformatica MDM
• Worked on data cleansing and standardization using the cleanse functions in

Environment: InformaticaPower Center 9.x (IOD, B2B, IDQ, IDA (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and TransformationDeveloper),Informatica MDM 9.x, SQL, Autosys, XML, MS SQL, Oracle 10g, DB2, Windows 2000, Linux, and AIX UNIX

Jr.ETLDeveloper

Confidential

Responsibilities:

• Involved in Project Analysis and documenting the dev requirements.
• Worked withETLArchitects, Data Modelers & Business Analysts.
• Designed and developed database views and stored procedures, Packages and Functions.
• Used SQL to extract the data from the database and also using views on the tables.
• Worked with Development Life Cycle in performing the Data Movement.
• Wrote stored procedures, functions &Packages.
• Involved in the creation of Mapping for various requirements usingInformaticaand usedInformaticaWorkflow Manager for configuring mappings also validated schedule run and monitor jobs using Workflow Monitor.
• Involved in the preparation of documentation forETLusingInformaticastandards, procedures and naming conventions.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated.
• Developed SQL Applications for extracting the data from the Oracle tables.
• Created detailed system design specifications to serve as a guide for system and the program development.
• Wrote triggers and packages by using PL/SQL for giving security privileges.