SUMMARY:

• Multifaceted Data Integration Architect with over 19 years of diversified, enterprise level experience aligning and translating business and technical requirements into technical specifications - data integration, data models etc.
• Implement and support large scale backend enterprise level operational business/Business Intelligence systems, data warehousing, MDM, database analysis, functional/design specifications, coding, system testing, implementation and post implementation data support.
• Over 19 years of extensive experience in Data Analysis, Data Modeling, System Analysis, Data Architecture and Development, Testing and Deployment of business applications
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Defining and implementing standards, conventions and best practices
• Solid expertise in Data Extraction, Data Migration, Data Transformation and Data Loading using ETL process in Informatica Power Center
• Developing strategic and tactical plan for business need.
• Evaluation, recommendation and selection of new technologies and tools.
• Leading and managing multiple projects and teams - onshore and offshore
• Creating Roadmaps, Project Plans, and SLA’s
• Ensuring completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements.
• Particpacted and sucessfully completed Operation Resiliancy and Disaster Recovery exericise
• Solid expertise in upgrading Informatica and MDM
• Automated many regular task to intragate with SNOW (Task Management Automation)

TECHNICAL SKILLS:

MDM: Informatica Siperian MDM 9.7/10.2

ETL Tools: Informatica 10.2,10.1.1, 9.1, 8.1/7.2.7.1/6.2.2/5.1/4.7 (Power Center Informatica Profiler, Informatica Data Quality8.5,9.1,9.6.1), DataStage, BO Data Integrator

Databases: Oracle 12c,11i/9i/8.x, DB2, UDB, SQL Server 2005/7.0/6.5 , MS Access 7.0/2000

Middleware: BEA Web logic Server 7.1/6.x,Jboss EAP 6 and 7

BI: TabBusiness Objects 5.x, 6.x, Cognos, Cognos Impromptu, Framework Manager and Powerplay,Crystal Reports 8.0,9.0, ERWIN, Siebel Analytics(OBIEE), DAC, Business Object Data Integrator 11.7

Industry: Finance, Insurance, Healthcare, Manufacturing, Media, Government Agencies

EMPLOYMENT HISTORY:

Confidential, NY

AVP - INFORMATICA/MDM/IDQ

Responsibilities:

• Performed Requirement Analysis and Effort Estimations
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems
• Creation of ETL framework and review of high level design document
• Creation of Logical Data Model and Physical Data Model
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Strong expetise in upgrading Informatica from 9.6.1 to 10.1.1 and Informatica MDM from 9.7 to 10.2
• Installed, configured and managed Informatica MDM core components such as Hub Server, Hub Store, Hub Cleanse, Hub Console, Cleanse Adapters, Hub Resource Kit.
• Involved in defining and configuring landing tables, staging tables, base objects, lookups, query groups.
• Participated in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Developed workflows to data domains for performing data extraction, data validation, data cleansing, data match, data load and required data related activities to support Customer’s MDM requirements.
• Used IDQ’s standardized plans for addresses and names clean ups.
• Worked on IDQ file configuration at user’s machines and resolved the issues.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in Transformations.
• Created User Defined Functions (UDFs) and reusable Mapplets and Transformations to simplify maintenance process and improve productivity.

Confidential, NY

Tech Lead - MDM / INFORMATICA

Responsibilities:

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Created logical and physical data model for claims data from the conceptual model using Erwin based on requirements analysis and validated the model with response to questionnaire from business analyst and its conversion into the physical data base design.
• Responsible for re-architecting and redesigning ETL for data loads to EWD.
• Claim data was extracted from different payers such as CIGNA, OHP, UHC, AETNA, AETNA MEDICARE, EMPIRE BLUE CROSS and loaded in to EDW and MDM.
• Documented Data stage job process and prepared technical design/specifications for data Extraction from Data stage to Informatica.
• Migrated Data stage job to Informatica
• Gathered requirement of business for each component
• Estimate the scope of work effort and assess the timeline
• Designed and architected overall ETL process
• Design the ETL based on the project requirements and client guidelines.
• Created reusable components, developed Error handling.
• Automated the workflow process by using audit table
• Used Informatica IDQ for profiling and Data cleansing.
• Extract data from various source system to MDM Base Table

Confidential, MA

Principal INFORMATICA/ MDM Architect

Responsibilities:

• Analyzed claims data from different applications for ICD10 conversion
• Met with business to understand application, data impact and remediation
• Worked with MDM Architect to create roadmap for Customer MDM
• Integrated Provider Management (IPM) refers to the tools, applications, methodology and strategy used to re-architect how the corporation stores, utilizes, accesses and maintains provider information, leveraging McKesson’s Portico platform.
• Gathered business requirements, working closely with business users, project leaders. Analyzed the business requirements and designed conceptual, logical and physical data models
• Estimated the scope of work effort and assess the timeline, resource and cost of the project.
• Designed and architected overall ETL process
• Used Informatica IDQ for Data cleansing.
• Migrated Network Pro data and loaded to McKesson’s Protico platform
• Documented functional, technical and business requirement

Confidential, NY

ETL Lead

Responsibilities:

• Provided a comprehensive inventory and understanding of inbound data across Risk and Finance that sets the basis for rationalization with supplier system and organizations.
• Set up IDE lab
• Analyze data and profile data for overlap and duplication

Confidential, NY

Enterprise ETL Lead

Responsibilities:

• Extracted data from various application such as SFDC, TALEO, MDR, TFANET, OIM, Red Wood and Workday data.
• Loaded data to MDM Base tables
• Used power exchange and Web services to extract data from Workday and SFDC data.
• Developed and maintained complex Informatica mappings.
• Used Informatica Data Masking transformation to mask the data
• Design the ETL based on the project requirements and client guidelines.
• Created reusable components, developed Error handling.
• Created complex work flow run nightly and daily jobs
• Migrated Sales Logic and Raiser's edge data to Sales Force using Power Exchange for Sales Force
• Worked with business SMEs on developing the business rules for cleansing.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Used Match and Marge functionality before uploading data back to SFDC
• Integrated IDQ with Informatica mapping.
• Presented Data Cleansing Results and IDQ plans results to the SMEs.
• Documented Cleansing Rules discovered from data cleansing and profiling