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 Reference 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
• Expertise in 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

Lead Informatica MDM/DQ/AXON/EDC Developer

Responsibilities:

• Created and implemented MDM Road Map Customer Data for Marketing purposes.
• Educating Business stakeholders on Principles of Data Governance & Framework, Metadata Management, establish Source to Target Data Lineage.
• Responsible to set up the foundational principles that ensures Confidentiality, integrity and availability of data throughout the Organization.
• As a Senior Data Governance Consultant to stakeholders I was part of the leadership team in setting up the Data Governance Framework, implement data governance guidelines for Metadata management, Data Quality Management, Workflow development, Lineage, Provisioning & Management and ensure guidelines are implemented from data creation to consumption.
• Involved in validating most of the Console functionalities including Aggregation, On-the-Fly, Survivorship, Trust Rule validation, Match and Merge.
• Worked with ETL Architects, Data Modelers & Business Analysts.
• Created/modified IDD or Entity360 application according to business needs using provisioning tool.
• Created a layout where business people can directly enter the data from outside.
• Experience with designing and deploying Business Entities and created relationships between these BE’s
• Experience in developing front end UI/UX screens via the E360 Provisioning Tool
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• 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.
• Implemented cleansing functions such as pre-defined functions (STRING Functions, Logic Functions, Math Functions, Data Conversion Functions).
• Lookup tables/ Reference tables were configured in the Provisioning tool in UI application.
• 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.
• 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.
• 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. Helped the testing team for data integrity and consistency.
• Defined and configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Involved in MDM admin activities like upgrading the version, applying patches and updating the EAR files to MDM.
• Experience in configuring/onboarding the AXON & EDC including Business glossaries, dashboards, search, Axon maps, policies, and databases.
• Interact with various business group within the organization to enable execution of data strategy, work with various groups to drive data quality / data management and metadata related projects.
• Assigning of Data Domains to Business models.
• Experiencing in building data pipelines for metadata extraction and storage, cataloging. populated Metadata content and associated business terms to the business glossary using Informatica Enterprise Data Catalog and Axon and Integrated Axon with IDQ,
• Integrated all the data quality components like AXON, IDQ and DB schemas and provide the lineage between them.

Environment: Informatica MDM (SIF,E360,BES,Provisioning Tool), Active vos,DQ, AXON, EDC 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

Sr. MDM Developer & Admin

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, JBoss,SQL Developer, Netezza, BODI, PowerCenter 10.x.

Confidential

MDM Developer

Responsibilities:

• 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.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries.
• Used latest version of Address Doctor cloud in the mappings and creating IDQ library cleanse functions and utilized DEV, QA, PROD Environments.
• Used ESP scheduler to monitor the jobs daily and helped ETL Support team on daily activities.
• Conducted Knowledge transfer sessions about the project to the team and managed the project by providing reviews on it.
• Architecting and implementing enterprise BI solutions.
• Defining, designing, developing & optimizing ETL processes 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.

Environment: Informatica MDM Multi Domain Edition 10.x Informatica Power Center 10.1, 9.x (IOD, B2B, IDQ, IDA (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation Developer),SQL, JBose server, Oracle 10g, DB2, Windows 2000, Linux, and UNIX.

Informatica Developer/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 using Informatica Power Center 10.1 Designer.
• Architecting and implementing enterprise BI solutions.
• Defining, designing, developing & optimizing ETL processes 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 on ETL workflows 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 Informatica Power 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.