SUMMARY

• Over 14 + years of IT experience which includes Master Data Management, Data integration, Data Migration, Data Quality, Data warehousing and Business Intelligence area in domains such as Financial, Pharmaceutical, Banking, Healthcare, Insurance, Telecom.
• Progressive experience in System Analysis & Design, Development, Testing, Integration, and Production Support using MDM (Informatica Siperian, Oracle) and Data Integration products for ETL and DWH applications.
• Extensive experience in Data warehousing, Data Architecture & Extraction, Transformation and Loading data load from various sources into Data Warehouse and Data Marts using Informatica Power Center and other ETL Tools.
• Worked on all facets of MDM implementations including Data Profiling, metadata acquisition, data migration, validation and reject processing and pre landing processing.
• Worked on requirement gathering, analysis, design, development& testing, implementation, support and maintenance phases of both MDM and Data Integration Projects.
• Worked on Master Data Management MDM Data Integration concepts in large scale implementation environments.
• Expertise in design and configuration of landing, staging and base object tables, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages as per the data model and source systems configured.
• Developed mappings using various cleanse functions and Address doctor functions to move data into Stage tables and defined Trust Score and Validation rules, Match Path, Match columns and Match rules and Merge properties settings.
• Expertise in creating batch groups jobs, batch viewer, auto command batch execution and scheduling.
• Expertise in provisioning tool/IDD and Business Entity Creation and Customization queries, packages and relationships etc.
• Expertise in SIF service implementing and testing in SOAP UI
• Expertise in BES both SOAP/REST services with JSON and XML coding for BES composite service like WAD/WSDL in Soap UI and creating documentation.
• Configuring Informatica Data Director (IDD), provisioning UI, entity 360 and customer 360 to meet data governance objectives in many project life cycles
• Closely worked with other IT team member’s, business partners, data stewards, stakeholders steering committee members, and executive sponsors for all MDM and data governance related activities
• Worked on Real Time Integration between MDM Hub and External applications using Power Center and SIF API for JMS and Kafka Publisher and consumer services.
• Worked extensively on creating new Direct Customer onboarding (DCO) process with new configuration on External matching Rules and processing the customer data before loading into MDM
• Experienced in creating workshops with data stewards and business owners on match rules tuning IDD configurations and Trust scores and validations
• Deployed MET (Change.xml) between different environments and supported ETL, Middleware, Open shift and F5 teams during deployments.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, Fact and dimension tables, Confirmed Dimensions, Base & Derived Facts, Aggregation Navigation, Pivot Tables, modeling of data at all the three levels: Conceptual, Logical & Physical
• Vast experience in Databases (SQL, PL/SQL, Packages/Procedures/Functions, Performance Tuning (Explain Plan, Analysis of Trace Files), Partitions, Triggers and Packages, Index design and tuning, Database security design and implementation)
• Strong experience in UNIX working environment, using the VI editor, AWK, SED, writing shell scripts, PERL Scripts etc.
• Strong Team Leadership Skills, Strict Adherence to Quality & Standards, Detail-Oriented, Vast experience in fast-paced, high-pressure environments with Excellent Multi-Tasking Abilities.

TECHNICAL SKILLS

ETL/DQ/DG: Informatica (PC, PWX), IDQ (Informatica Data Quality), Informatica Power Center 10.1/9.6/9.5/9.1/8.1 , Informatica MDM 10.X, Informatica PIM (Heiler) V-7/8 MSBI (SSAS, SSIS, SSRS), Siperian 4.X, Oracle PIM/MDM, ODI, OBIEE, Lavastrom

Middle Tier: IBM MQ Series, Web Services (SOAP, REST), Web Logic 7.0/8.1, Web Sphere 5.1, JBOSS EAP 7.0

Databases: Oracle, SQL Server, Teradata, Cassandra, Mongo DB

Reporting & Data Visualization Tools: Cognos, Business Objects, Tableau, Denodo, Crystal Reports

Scripting languages: Unix-Shell Scripting, Python, java Script

Operating Systems: Windows NT/2000/XP, OS/400(V4R4), UNIX, Linux, IBM AIX

Application Servers: Web Logic 7.0/8.1, Web Sphere 5.1

Tools: UML, Rational Rose, Eclipse, XML Spy, BODI, Dreamweaver, ERWin Data Model, Rational Rose, Toad, Visio, Rally, Jira, AutoSys, Control-M, SOS Job Scheduler, OEM, DAC, SolarWinds, APP Dynamics, SOAP-UI, Postman, GitHub, OpenShift 3.11, Address Doctor, Google API, Melisa address validator, Splunk Rundeck

PROFESSIONAL EXPERIENCE

Confidential, Embarcadero, CA

Informatica MDM Consultant

Responsibilities:

• Developing the High-Level design/Architecture indicating the Source System Extract Strategy, Load Strategy, Dependency Flows, History Maintenance, Storage needs, Error Strategy/Recovery, Performance Specifications, Metadata Management & Scheduling details
• Provisioned data into MDM using both Informatica Power center and SSIS ETL tools and performed data cleansing and standardization until landing tables.
• Implement Informatica MDM workflow including data profiling, configuration, specification and coding match rules.
• Build out best practices regarding data staging, data cleansing and data transformation routines within the Informatica MDM solution
• Created Base tables, Stages tables based on the data model and number of new source systems (Safe box, Former clients (Legacy systems))
• Performed analysis, design, development and maintenance activities associated with the database and data in support of multiple applications including following standards &procedures to achieve integration of systems through database design.
• Collaborated with source systems data stewards, system owners and technical personnel for data governance and resolved any data quality or technical issues related to data ingestion.
• Developed Informatica MDM design, configuration and implementation for Real-time Integration components using Provisioning
• Created Custom UI's using Informatica Data Director
• Design & Develop of the Cleanse functions & Match rules for various business entities in IDQ/MDM
• Designing & Develop Informatica MDM User Exits, Match rules etc
• Created Batch groups and tested Real-time SOAP/Rest service calls using mule gateway and apigee gateway services.
• Performance Tuning of Match rules and existing processes
• Created data Validation document, Unit Test case document, technical design document, MDM mapping design document, Informatica Migration Request Document, Release Change management document and Knowledge transfer documents related to Applications.
• Configured Informatica components and assists infrastructure team on installation upgrades and hotfix patches from 10.1 to 10.3 HF1.
• Coordinated, plans and executes activities related to platform maintenance, disaster recovery and software release management
• Performed capacity and stability monitoring using rundeck and appdynamics
• Assisted with application health and server metrics collection and reporting with integration of MDM real-time call with Enterprise Service Bus (ESB) Web services.
• Configured MDM High Availability multi-nodes architecture (process and cleanse server threads) with middleware engineering team for failover and recovery functionality.
• Conducted performance tuning on MDM application servers and configurations for optimal performance using batch loads and Rest ad Soap Service call volume.
• Installed and configured the Informatica MDM EBF -16531
• Raised cases with Informatica vendor for software product or functionality issues.
• Performed MDM code migrations/deployments and cutovers during releases and go-lives.
• On a daily basis, created user accounts, ETL integrations/implementations/migrations, schedules and monitors jobs, performs root cause analysis for job failures and missed/catch up data loads, and provided server and database support for performance tuning.

Environment: Informatica MDM 10.3(HUB, IDD, Provisioning, Activevos), Informatica 10.1, PC/IDQ, Address doctor, Melisa address verification software, Microsoft SSIS, CRM, Legacy systems, SQL Server 2011 SP4, ODA X7,Oracle 11i/12C, SOAP UI, Postman, Python, Kaka Publisher, Brokers, F5 load balancer, Solar winds, Splunk, Jboss EAP 7.0, Open shift Deployment. App dynamics, Control-M, OEM, UNIX (IBM - AIX), and Windows XP.

Confidential, Columbia, MD

Informatica MDM Consultant

Responsibilities:

• Developing the High-Level design/Architecture indicating the Source System Extract Strategy, Load Strategy, Dependency Flows, History Maintenance, Storage needs, Error Strategy/Recovery, Performance Specifications, Metadata Management & Scheduling details
• Implement Informatica MDM workflow including data profiling, configuration, specification and coding match rules.
• Build out best practices regarding data staging, data cleansing and data transformation routines within the Informatica MDM solution
• Created Base tables, Stages tables based on the data model and number of source systems.
• Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
• Worked with Business users in understanding Match and Merge setup and incorporated their requirements and ideas.
• Collaborated with users in defining Match Rules and conducted workshops to discuss over and under matching.
• Defined the security such that schema will be secured with access only granted for specific downstream integration uses using users created for those specific integrations.
• Develop and maintain the master and translation entities in the MDM Hub and published the data into SFDC s and ERP s for supporting the ongoing business support.
• Created Customer onboarding process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store and define automation process for staging loading match and merge.
• 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.
• Created and Developed IDD application by creating Subject Area Groups, Subjects Areas and Entity relationships.
• Performed analysis, design, development and maintenance activities associated with the database and data in support of multiple applications including following standards &procedures to achieve integration of systems through database design.
• Created Data Validation document, Unit Test Case Document, Technical Design Document Informatica Migration Request Document and Knowledge Transfer Documents related to Applications.

Confidential, CA

Sr. MDM Developer

Responsibilities:

• Developing the High-Level design indicating the Source System Extract Strategy, Load Strategy, Dependency Flows and Scheduling details
• Created Base tables Stages tables based on the data model and number of source systems.
• Worked on the Enterprise Data warehouse methodologies (Landing, Staging, publishing and promoting the codes to Test regions)
• 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.
• Developed Mappings for loading MDM Hub. Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in creation of HLD and LLD document based on BR/FR and got those reviewed by customers along with detailed project time lines.
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Involved in analyzing different modules of facets system and EDI interfaces to understand the source system and source data.
• Develop workflows to data domains for performing extraction validation cleansing matching loading exception handling and other data related activities to support Customer s MDM requirements
• Used Metadata manager for validating promoting importing and exporting repositories from development environment to testing environment
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application
• Develop standards guidelines processes and expertise to consistently address strategic data issues such as data quality cleansing standards and integration by using Address Doctor cleanse adapter

Confidential, CA

Responsibilities:

• Successfully completed Customer and Product centric Master Data Management initiatives using Informatica Master data management product
• Developed comprehensive models for managing and communicating the relationships between Base Objects and Performed the ETL process for loading the data into hub
• Contributed to Data Migration and the Implementation of Roadmap defined by the business case
• Implemented batch process using automation and real time integration with Power Center for JMS interfacing with MDM HUB
• Analyzed the Business data and defined the Match and Merge rules and Trust Scores for INFA MDM Hub
• 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
• Designed and defined best implementation and deployment practices for Informatica Data director implementation within services organization
• Develop workflows to data domains for performing extraction validation cleansing matching loading exception handling and other data related activities to support Customer s MDM requirements
• Used Metadata manager for validating promoting importing and exporting repositories from development environment to testing environment
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application
• Develop standards guidelines processes and expertise to consistently address strategic data issues such as data quality cleansing standards and integration by using Address Doctor cleanse adapter
• Used metadata manager for importing exporting validating the data for transforming the schema from development environment to testing environment
• Identified Golden Record BVT for Customer Data by analyzing the data and duplicate records coming from different source systems
• Involved with Data Steward Team for designing documenting and configuring Informatica Data Director for supporting management of MDM data
• Worked extensively on Informatica client tools like Designer workflow Manger Workflow Monitor during different phase of project

Confidential, New York

Responsibilities:

• Ownership of the entire ETL process, being responsible for the end-to-end delivery of the application from requirements gathering till the Production Deployment
• Managing cross-functional teams which involved; People Management, Conflict Resolutions, Risk Management, Technical Guidance
• Developing the High-Level design/Architecture indicating the Source System Extract Strategy, Load Strategy, Dependency Flows, History Maintenance, Storage needs, Error Strategy/Recovery, Performance Specifications, Scheduling details
• Strict adherence to Quality and ensuring proper quality checking processes are being followed and rigorous Regression testing and Integration testing are done as necessary and the test results are thoroughly documented
• Defining the ETL Standards & Best Practices and assuring that ETL code is developed as per the standards and the detailed documentation is in place (Mapping Specifications, Source2Target Documents, Test Case Documents & Results, Requirements Traceability Matrices, Performance Results)
• Complete Production Support and handling of issues with Informatica server and Seibel reports, handling of issues raised by business users, monitoring ETL jobs, making sure entire ETL process and support processes are documented properly, handling security issues related to other teams and granting data access by creating appropriate user security views etc…
• Administration tasks such as creating users, roles, access in Repository Manager. Restarting the Informatica servers and services as necessary. Backing up of repositories and folders and re-importing them from backups.
• Overseeing Informatica migrations to the support team from the development teams. Defining standards for Support documentation, Knowledge Transfer, Stand-by Support

Confidential

Data Warehouse Developer

Responsibilities:

• Prepared mapping specifications as per the business requirements.
• Using Informatica Power Center 8.1.1 as an ETL tool to extract data from flat file and Oracle database.
• Developed number of mappings with complex transformations (connected and unconnected lookups, update strategy) to load fact tables and dimension tables.
• Developed type1 Dimension mapping to keep most recent values in Dimension table.
• Developed Rollback mapping using unconnected stored procedure transformation.
• Developed mapplet to reuse same business logic in multiple mappings.
• Prepared Unit test cases tested and executed test cases using Test Director.
• Prepared Work product review for developed mappings.
• Developed Reconciliation, Data Coverage and Data Quality reports using Data Analyzer.
• Single Point of contact with Hong Kong team.

Confidential

ETL Developer

Responsibilities:

• Developed number of mappings with complex transformations (connected and unconnected lookups, update strategy) to load fact tables and dimension tables.
• Developed type1 Dimension mapping to keep most recent values in (Xref) Dimension table.
• Developed Type 2 Dimension mapping to keep the keep most recent updated values in Dimension table (Junction Tables and Transaction Tables)
• Developed mapplet to reuse same business logic in multiple mappings.
• Prepared Unit test cases, Integration test cases tested and executed test
• Prepared Code product review for developed mappings.