SUMMARY

• 10 Years of IT experience in Master Data Management MDM , Data Warehousing BI Reporting in all phases including design, development and implementation along with in-depth knowledge on operational and reporting environments.
• Master Data Management MDM using Informatica formerly Siperian MDM v9.5/9.1/9.0.1, Master Reference Manager MRM XT SP2, IBM Initiate 9.2 and IBM Infosphere MDM Server v11.1 AE/8.5/8.0.
• Developed Data warehouse and data marts on different database platforms including Oracle 11g/10g/9i/8i/7.x, Teradata V2R6/V2R5/V2R4, DB2 UDB v9.7/9.1, MS SQL SERVER 2008/2005to integrate heterogeneous source systems.
• Involved in designing BI Reporting Universe, generating and optimizing ad hoc canned reports using SAP Business Objects XI R3/R2/R1/6.5, Web Intelligence 6.5.
• Proven experience in ETL and Change Data Capture CDC using InformaticaPowerCenter, PowerExchange9.1 Grid/9.0/8.6.1/8.1.1 SP3/7.1.4 and Data Stage v8.0.
• Experience in interacting with Business Users to analyze the business process and requirements, writing Business Requirement Documents and Technical Specifications.
• Data Modeling and drawing up the Process Flow Charts, DFDs, and ERDs using MS Visio Erwin r7.3/4.2.
• Involved in functional and technical Systems Analysis Design, Systems architectural design, Presentation, process data flow design system impact analysis, star schema, snowflake, changing dimension, Gap analysis and documentation.
• Extensively worked on creating performance tuning mappings, transformations, sessions and workflows to extract data from multipledatabases like Oracle, Teradata,MS SQL Server, DB2, UDB, IMS to load into target data-warehouses.
• Proficient in PL/SQL queries, stored procedures, triggers, packages while working on tools like TOAD, Rapid SQL, BTEQ and PL/SQL developer.
• Well versed with Data Profiling, Data Cleansing and Meta Data Management issues using Trillium, Informatica Data Quality,IBMQuality Stage.
• Proficient in all phases of the systems Development Lifecycle SDLC - Analysis, Design and Modeling, System Implementation, System Testing, Acceptance and Maintenance.
• Experience in Agile development methodologies with sprints as frequent as 3 weeks to 2 months on MDM, Data warehouse and Operational / BI Reporting.
• Extensive experience in application design and implementation of Operational Data reports for Financial, Healthcare, Insurance, Retail, Utilitiesand Manufacturingbusiness areas as well as industry.

ROLES

• Solutions Architect MDM, Data Warehouse, CRM BI Reporting
• Master Data Management Specialist Data Analyst
• Data Governance Quality Specialist Project Manager

TECHNICAL SKILLS

• MDM IBM InfoSphere MDM Server 11.1 AE /10.1 SE /8.5/8.0, InformaticaMDM formerly Siperian 9.5/9.1/9.0.1/MRM XT SP2, Informatica Data Director IDD , IBM Initiate MDS Engine 9.5/9.2, IBM Initiate Workbench 9.5, IBM Initiate Inspector 9.2
• ETL InformaticaPowerCenter/PowerExchange9.1 Grid/9.0/8.6.1/8.1.1/7.1.4/6.2/5.x, Data Stage 8.0
• Database Oracle PL/SQL 11g/10g/9i/8i, DB2 UDB 9.3/9.1 FP3, Teradata V2R6/V2R5/V2R4, MS SQL Server 2008/2005
• BI Reporting SAP Business Objects XIR3/R2/6.5, Crystal Reports, IBM Cognos8 BI/7 Impromptu
• Data Modeling ERwin r7.3/r4.2, MS Visio, MS Access 2010/2003, WMQ Client v6.0.2.2
• Data Quality Trillium Data Director 12, Informatica Data Quality, IBM Quality Stage 8.5/8.0, HP ALM Formerly Mercury / HP Quality Center 10
• PL SQL Tools Toad 9.1, SQL Developer, Teradata SQL Assistant, BTEQ 7.1

Professional Experience

Confidential

MDM Solutions Architect

• Led proof of concept effort to help identify a suitable MDM application for next-gen data-mastering and customer 360 view for the enterprise.
• Conducted GAP analysis for upgrade from current IBM Initiate 9.2 platform to IBM Infosphere 11.1 AE Hybrid.
• Designed 3-year strategy and roadmap for MDM implementation and presented to EDG executive decision group for budget, resourcing and planning approval.
• Developed integration architecture for Initiate MDS with CRM SFDC cloud at partner clubs both for real-time service calls and ETL batch jobs.
• Worked with data-stewards to set guidelines and benchmarks for resolving linkage and duplicate tasks in Initiate hub.
• Helped business partners to develop process data standards for newly set up data governance organization.
• Designed Party Domain data model for InfoSphere v11 MDM to socialize with IBM CSAA data model teams.
• Developed additional future domains for Claimants, Agents and Prospects data from across the organization and merge with the organization's overall Big Data strategy.
• Designed process and architecture to integrate future MDM with 3rd party systems like Merkle and LexisNexis and perform data-enrichment in the hub.
• Designed and developed error framework to be implemented within the Initiate InfoSphere applications.

Confidential

Enterprise Solutions Architect MDM, Data Warehouse, CRM

• Coordinated across teams to complete development, testing and deployment of Provider hub into production.
• Designed outbound integration architecture for MDM Provider Hub to down-stream systems like EPIC and SFDC as well as Flat File extracts for MIDAS.
• Led Project Discovery for real-time integration between MDM and EPIC eHR system.
• Conducted GAP Analysis and integration options, including a hybrid approach to integrate with EDW as well as MDM using eGATE interface.
• Budgeted for project implementation costs, including expected number of project hours and resources needed both for technical as well as business IS teams.
• Participated in Proof of Concept for ICD 9 to ICD 10 crosswalk solutions and presented recommendation to purchase and implement the Informatica-Highpoint Solutions crosswalk product.
• Supported data modeling effort for i4 i5 releases on the data-warehouse project and maintained release management in conjunction with MDM releases.
• Designed architecture and strategy roadmap to implement Informatica MDM as enterprise solution for People Place Hubs, as well as timeline for migrating Patient Provider Hubs from IBM Initiate to Informatica MDM.
• Presented Data Quality Data Governance guidelines and recommendations to the newly established Data Governance committee.

Confidential

EnterpriseArchitect / Technical Lead MDM Data Warehouse

• Responsible for GAP Analysis to help identify current and proposed structure of MDM system.
• Managed MDM Technical and Data Governance teams along with activities for integrating data while managing and enhancing quality on Informatica MDM platform.
• Socialized with Senior Leadership team SLT on project activities ranging from task resource planning, to major milestones, and project financials.
• Led design, development and production support activities for 5 Hubs in production, and 2 new Hubs under development.
• Performed impact analysis for integrating opportunity-to-order customer data from SalesForce.com SFDC and order-to-cash customer data from Siebel into the new Hub.
• Deployed new MDM Hub for WM SITEs in conjunction with user interface on Informatica BDD application.
• Implemented design to integrate email validation processes from ExactTarget.
• Performed data-enrichment in MDM Customer Hub with bi-weekly updates from Dun BradStreet
• Modeled and implemented data warehouse and multiple data marts IBM Netezza appliance.
• Worked with business team to design Trust and Validation framework to ensure the best quality for the golden copy of customer data.
• Co-ordinated with database, unix and websphere teams along with application architects to purchase implement infrastructure for Disaster Recovery and POD.
• Migrated from Sharepoint 2007 to 2010 and used for document versioning, project tracking and milestones.
• Mediated the conversations between in-house technical team and Informatica support for escalating bug-fixes and implementing hot-fixes.

Confidential

Enterprise Architect MDM Data Warehouse

• Responsible for GAP Analysis to help identify current and proposed structure of customer data integration using IBM Infosphereserver's customer domain.
• Led meetings with business clients to identify expectations for the customer data integration effort.
• Delivered presentations to distributor services marketing division of businesses in effort to promote advantages of customer data integration and business impacts.
• Performed task, resource systems analysis to aide re-planning and re-organization efforts within the Business Information Systems BIS group.
• Analyzed existing business systems reports and helped create new reports focusing on customer penetration and product catalogue to aide business in decision making.
• Performed data analysis to help design data conversion procedure for moving data from SAP MDM to Teradata MDM application and subsequently re-design to IBM Infosphere MDM Server.
• Designed the model for Customer, Product Billing domains in addition to operational data warehouse.
• Co-ordinated with design team, business users, as well as off-shore technical development team to establish user-interface designs and set data-standards.
• Worked on Sharepoint 2007 to post documents, and track project milestones.
• Participated in platform re-assessment effort under the new senior leadership team to prepare and present cost-benefit analysis for the client.

Confidential

MDM Architect/ Data-Warehouse Lead

• Responsible for GAP Analysis to help identify current and purpose and structure of MDM system.
• Led effort for gathering business requirements for the MDM, data-warehouse as well as business-intelligence reports to be used by the senior management.
• Conducted data-profiling on 3rd party data to identify match-merge scenarios validation rules and also differentiate to flag customers from prospects.
• Participated in designing the star schema for Business Objects reporting and iDashboard off MDM, ODS the Data-warehouse systems.
• Designed services and business objects in the XMLs to extract data from legacy systems and direct them to appropriate MDM tables within IBM Infosphere MDM server.
• Planned and designed the work-breakdown structure as well as schedule/milestones for ETL development and testing teams
• Led 4 member ETL team towards designing and development of extraction mappings for Inbound source to MDM and then Outbound MDM to consuming systems using DataStage 7.5.2 8.0 in parallel.
• Led ETL team toconvert ETL jobs from DataStage 8.0 to InformaticaPowerCenter 8.6.1.
• Designed customized existing as well as new ETL jobs using transformations like SQL Transformation, Source Qualifier, Aggregator, Lookup, Joiner and Update Strategy in InformaticaPowerCenter.
• Developed reusable maplets and implemented best Informatica practices involving using Global Parameters files for flexible implementation.
• Led 3 member BI Team to develop business objects reports to fulfill the reporting requirements for Marketing Intelligence, along with Personal, Commercial Life lines of business.
• Participated in Business Objects upgrade from XIR2 to XIR3 and validation of universes, user profiles as well as existing reports objects.
• Posted design documents and tracked versions using Sharepoint 2007, along with milestone publishing.
• Customized Quality Center for the QA team and helped set up roles and security in the tool.

Confidential

MDM Technical Lead

• Responsible for implementing MDM Core App environment with DB2 and UDB database configuration on IBM Infosphere MDM using the customer domain.
• Led 8-member test team for SQL Scripting and Test Automation, along with IBM/Perficient development team for Data Stage mappings and Metadata Management.
• Created Test Plan and Test Strategy documents for the Testing Team, assigning resources and timelines to the tasks and identifying testing approach as well as key milestones for the MDM SIP project.
• Helped design UAT Plan for 4-member team to go ahead with User Acceptance Testing UAT .
• Involved with Data Modeling and Mapping as part of project re-design phase, using ER Studio.
• Validated MDM Code Tables loaded by development team through Data Stewardship screen.
• Wrote SQL Scripts to Systems Integration Testing SIT on 2 modules on the project.
• Validated XMLs for Data Stage mapping output and Inbound feed to MDM Database
• Responsible for testing data flowing outbound from MDM database into Consuming Systems.

Confidential

MDM / Data Warehouse Lead

• Responsible for Confidential Master Reference Manager MRM XT SP2 solutions delivery and Oracle database environment configuration.
• Led 4-member offshore team in development of Informatica mappings.
• Identified redesign opportunities for existing Informatica mappings and worked with Business Analysts to define/change rules for efficient and optimum performance.
• Worked with QA to propagate design changes in design documentation.
• Created, redesigned and maintained data models in ERwin.
• Presented data models conceptually, logically and physically.
• Practiced Siperian design principles including deep versus wide, match requirements drive the model, etc.
• Developed, Debugged and deployed maps using designer, debugger, Code Generator and deployment manager for Change Data Capture CDC through InformaticaPowerCenter PowerExchange and involved in data migration between Teradata, Oracle IMS.
• Involved with data profiling and parsing/cleansing in SQL Trillium to provide better confidence for Initial Data Loads to Siperian Hub.
• Configured Oracle maps by setting Mapping configuration to use external DB links, Run time parameters, Max allowed runtime errors, and Mapping load types.
• Used Repository Manager to migrate workflows, mappings and shared objects between Development, Test and Production Support environments.
• Performed configuration changes for Initial Data Load and Daily Load processes.
• Created Tables, triggers, indexes, views and granted roles.
• Involved in creating test plans for QA testing at various levels, unit, performance and Integration.
• Worked with log files to identify and rectify coding errors in process data-flow.
• Provided production support.

Confidential

MDM Developer / Data Warehouse Lead

• As part of SDLC team, performed Gap Analysis between current application and proposed application requirements and prepared ETL gap analysis, impact analysis and project estimations.
• Responsible for ETL application architecture.
• Involved in migration from Informatica 7.1 to 8.1 and integrating with mainframes for CDC.
• Responsible for complete data modeling design, ERDs DFDs using MS VISIO and ERwinto be utilized in ETL development using Teradata, Oracle and Informatica.
• Developed External PL/SQL packages, Procedures, and functions to fill gaps where ETL design is not supported by Oracle and Informatica.
• Developed, Debugged and deployed maps using designer, debugger, Code Generator and deployment manager.
• Configured Oracle maps by setting Mapping configuration to use external DB links, Oracle Optimizer hints, Run time parameters, Max allowed runtime errors, and Mapping load types etc.,
• Generated runtime and deployment reports using Oracle runtime Repository and runtime Audit Browser.
• Performance Tuned External, BO reports and Oracle generated PL/SQL packages by reading oracle explain plan and implementing fixes for identified throwaways.
• Loaded Flat files extracted from Hyperion into Application staging area using SQL Loader utility by coding for Par and control files.
• System Tested BO reports validating documented system test scenarios.
• Version maintenance using MVS 6.0.
• Designed Strategy for initial load of the application.
• Overseen promotion of application to production by reviewing promotion document, identifying missing components preparing production promotion checklist.
• Provided production support

Confidential

Data-WarehouseLead

• Designed ETL processes using Informatica to load data from Flat Files, and Excel files to target Oracle Data Warehouse database
• Responsible for data modeling using ERwin MS Visio.
• Performed data manipulations using various Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator, Stored Procedure etc
• Used SQL overrides in source Qualifier to meet business requirements
• Written pre session and post session scripts in mappings. Created sessions and workflows for designed mappings. Redesigned some of the existing mappings in the system to meet new functionality
• Created and used different tasks like command and email tasks for session status
• Used Workflow Manager to create Sessions and scheduled them to run at specified time with required frequency
• Monitored and configured the sessions that are running, scheduled, completed and failed
• Involved in writing UNIX shell scripts for Informatica ETL tool to fire off services and sessions
• Migrated mappings from Development to Test and from Test to Production environments

Confidential

Data-Warehouse Developer

• Interacted with Customer to gather requirements, analysis, scope and design technical document etc.
• Responsible for Data Model including tables, Synonyms, Sequences and other DB objects to support proposed POC.
• Responsible for ETL Design to implement POC using MS VISIO 5.0 and ERwin Data Modeler.
• Created project modules, DB links, runtime users including configuration of source, target and project modules.
• Performed Change Requests on Informatica mappings according to application enhancements.
• Used ERWIN for Data modeling to design logical and physical data structures to meet the requirements
• Responsible for Identifying and Fixing Performance Bottlenecks on Informatica Mappings.
• Responsible for documenting user manual for the end users.
• Created several data-entry forms for the business application using Oracle Forms. Forms were used to enter employee data, contractor information, projects that the contractors are working on etc.
• Extracted initial employee data using external interfaces built using PL/SQL procedures and SQL Loader into the application. Interfaces were built to sync employee data from external Payroll system to the in house application
• Built numerous reports using Oracle Reports for the application

Confidential

Data-Warehouse Developer

• Create the Source to Target Mapping Document, which also lists the transformation rules. Developed Informatica mappings and change detection procedures and also tuned mappings for improving performance.
• Responsible for developing extraction /transformation /load ETL software.
• Identification of heterogeneous data sources.
• Mapping design.
• Loading facts and dimensions from source to target datamart.
• Creation, configuring, scheduling and running of sessions and batches.
• Configuring Event Based scheduling using Indicator files.
• Testing and maintaining of Informatica mappings.