SUMMARY:

• I have more than 10+ years of experience in ETL, Data Warehousing, Master Data Management (MDM) implementation using Informatica (Siperian) MDM, MDM Cloud, Informatica Power Center and Oracle. I have extensive experience in entire lifecycle of MDM implementation, including Analysis, Design and
• Development. As part of MDM implementation I have been involved directly or indirectly in Data Modeling, Source System Analysis, Data Profiling, Data Quality and Data Standardization, Designing and developing Match and Merge Strategy and Outbound consumption using
• Web Services, SIF APIs and batch consumption. And have expert level competency in UNIX and Oracle. During my career span I have worked across various functional domain including Banking, Healthcare, Pharmaceutical and Finance.

TECHNICAL SKILLS:

Software/Tools: Informatica MDM 9.1/9.5, Informatica Power Center, SSRS

Databases: DB2 9.5, Oracle 10g, Oracle 9i (SQL/PLSQL), Oracle 11g

PROFESSIONAL EXPERIENCE:

MDM Solution Architect and Lead Developer

Confidential

Responsibilities:

• Planned and lead MDM requirement analysis sessions with business users.
• Involved in designing and developing of Member & Provider data model.
• Coordinate MDM program activities for the Member and Provider data domains
• Conduct source system analysis, and data profiling for lifecycle management.
• Define measurable metrics and the minimal required attributes for each domain or subject area to support a robust and successful deployment of a MDM platform
• Define requirements for data matching and merging rules, survivorship criteria and data stewardship workflows that can be deployed in the endorsed MDM tool
• Thorough understanding of deterministic and probabilistic matching methodologies and master data hierarchy management
• Collaborate with the Enterprise Architecture teams (data integration, data architecture, business intelligence) to develop and deliver MDM solutions.
• Work with Architecture Review Board and Change Approval Board for technical reviews and approvals through the system development life cycle.
• Lead the service module starting from requirement gathering, design, development using Service Integration framework.
• Played a lead role of developing Reference Data Management.
• Use the Schema tool to configure a consolidated data model, including relationships.
• Configure landing and staging tables.
• Configure Trust Rules
• Configure/Run LOAD jobs
• Define match columns for fuzzy and exact match/Define match rules/Configure merge settings.
• Identify user exits for the Stage, Load, Match, Merge and Unmerge processes as well as other user exits.
• Use cleanse functions, constants and conditional execution components to build mappings and re - usable cleanse components.
• Test mappings and run staging jobs.
• Configure delta detection and audit trail settings.
• Provided Assistance to QA and Testing team for testing.

MDM Developer

Confidential

Responsibilities:

• Created various Landing Tables, Staging Tables, Base Objects, Mappings, and Cleanse Rules as per business requirements.
• Prepared test data for unit testing.
• Involved in Siperian Configuration changes.
• Involved in a POC on Informatica PowerCenter to build up one data load process
• Code review and maintain code base in VSS.

Informatica Administrator

Confidential

Responsibilities:

• Product SME: Have and maintain deep understanding of Informatica PowerCenter (from both Designer and Administration sides) and a good overall knowledge of the complete Informatica Product Stack to guide existing & prospective projects;
• Shared Service Management: Manage the global Informatica Shared Service; Oversee all architectural changes to the shared platform; Manage the relationship with the operations support team.
• Involved in Informatica issue resolution, folder migration and administration and served as the second line of support internally for any Informatica issues escalated by project teams.
• Involved in Software upgrades plan and manage Informatica software patching and upgrades.
• Involved in Informatica 9.5.1 installation/Upgrade from 8.6.1
• Involved in folders, user and group management and assigning permissions and privileges
• Involved in any POC to explore more feature provided by Informatica.
• Involved in Resource management. Monitor and manage resources associated with the Informatica environment
• Involved to build a process to purge repository process for leaner repository with better performance.
• Interface with the support team for enterprise scheduler in order to schedule and monitor Informatica production jobs
• Provided solutions to problems or challenges quickly and efficiently both in Informatica and Composite.
• Published KPIs (ETL plant data volume processing, Project that uses Informatica the most, Project that has more number of Workflows/Sessions/Mappings) using SSRS
• Knowledge Coordination: Created or updated documentation or webcasts for Best Practices, How-Tos, Security guidelines, and Getting Started; Manage process and ownership for Shared Objects/Code stored on shared platform; Established and managed automated standards enforcement. Created sample mappings; create framework to promote re-usability across teams.
• Manage a SharePoint site as a central point of communication and knowledge sharing across the teams

Informatica Administrator/Developer

Confidential

Responsibilities:

• Manage deliverables and project timelines for all 4 different environments.
• Involved in folders, user and group management and assigning permissions and privileges
• Involved in Informatica issue resolution, folder migration and administration and served as the second line of support internally for any Informatica issues escalated by project teams.
• Involved in Resource management. Monitor and manage resources associated with the Informatica environment
• Involved in Software upgrades plan and manage Informatica software patching and upgrades
• Involved in Security administration. Managed Informatica users and roles in order to enforce data security, while making sure all users have the necessary access to perform their tasks.
• Interface with the support team for enterprise scheduler in order to schedule and monitor Informatica production jobs
• Provided solutions to problems or challenges quickly and efficiently both in Informatica and Composite.
• Involved in Production Support of Informatica as well as Composite resolving issues and help maintain the entire environment.

Retail Sales Analytics (RSA) - Data Warehouse Developer

Confidential

Responsibilities:

• Identification and Analysis of data sources
• Imported and Created Source Definitions using Source Analyzer.
• Imported and Created Target Definitions using Warehouse Designer.
• Created Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Designed Informatica mapping to load flat file data into star schema based fact and dimension tables.
• Involved in developing Informatica mapping to migrate data from legacy systems
• Used SQL override on source qualifier to merge two datasets from separate tables that contain identical fields, to simplify the need of more complex or diverse mappings
• Implemented full and incremental (delta) logic in ETL.
• Created one time jobs to load historical data
• Installation and configuration of Informatica on Linux host, and client on Windows for development and QA environments.
• Used indirect source files through the same mapping (using list file)
• Involved in ongoing maintenance, resolving support tickets using team tack ticket management tool
• Monitoring of daily and weekly jobs.

Supply Chain management - Data Warehouse Developer

Confidential

Responsibilities:

• Designing and documenting the process flow.
• Designed the traceability matrix for data lineage as data moved from different sources to target systems in data warehouse and the data mart to trace back the source of the existing data.
• Created PL/SQL stored procedures for data transformation which had complex and reusable business logic.
• Tuned the mappings both at the designer and workflow manager by updating the different tunable parameters where ever applicable.
• Tuned the Oracle queries using indexes/hints/gathering statistics/tweaking init.ora parameters /Materialized Views/Bit Maps/Partitioning for better performance in the Very Large Database (VLDB) environment.
• Performed and documented unit/integration/system testing of the entire data flow.
• Developed scheduling mechanism using UNIX wrapper scripts for Autosys.
• Designed the validation techniques and criteria after the successful load.

Consumer Deduplication Testing - ETL Developer

Confidential

Responsibilities:

• Designing and documenting the process flow.
• Preparing the documents like Analysis and design Document, Unit tests Plan, Deployment Checklist etc.
• Designed the traceability matrix for data lineage as data moved from different sources to target systems in data warehouse and the data mart to trace back the source of the existing data.
• Performed and documented unit/integration/system testing of the entire data flow.

Data warehouse developer

Confidential

Responsibilities:

• Involved in requirement analysis and based on that designed data marts.
• Took part in the ETL design for both the Staging area as well as the dimensional area.
• Created the Transformations, Mappings and Sessions using Informatica Power Center 6..4.1
• Created the reusable Mapplet to in corporate the similar transformation logic.
• Customized the Source Qualifier and Lookup Transformations to override the SQL.
• Used Persistent Lookup Transformations to improve the session performance.
• Used Session Performance Statistics to identify the session bottlenecks and tuned the Informatica Session Parameters accordingly to improve the session performance.
• Partitioned the long running sessions based on the SQL override range.
• Performed SQL Query optimization for the long running queries.
• Devised the Indexing and Partitioning Scheme for the Data Warehouse.
• Changed Oracle Initialization parameters to improve the overall performance.

Data warehouse developer

Confidential

Responsibilities:

• Involved in requirement analysis and based on that designed data marts.
• Took part in the ETL design for both the Staging area as well as the dimensional area.
• Created the reusable Mapplet to in corporate the similar transformation logic.
• Customized the Source Qualifier and Lookup Transformations to override the SQL.
• Developed mappings to extract data from flat files and load to Staging area in Oracle database using Informatica 6.1
• Developed mappings to extract data from staging area and load to dimensional area using Informatica 6.1.
• Transformations used like Sequence generator, Lookup, joiner and Source qualifier transformations in Informatica Designer.
• Optimized session performance by eliminating performance bottlenecks (Mapping bottleneck).
• Documented UTC