PROFILE SUMMARY:

• Data Warehouse Analyst with 11+years of Informatica Powercenter ETL, Informatica MDM and Informatica Data Quality (IDQ) experience in Health care, Banking, Financial, Insurance, Retail, and Telecom domains.
• Experience in providing technical leadership on Informatica Powercenter, Informatica MDM (Siperian), Informatica Data Director(IDD), Informatica Data Quality(IDQ), Address Doctor and Identity Matching
• Successfully played role as Architect, Technical, Development Lead on MDM, IDQ and Informatica Powercenter
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for OLTP/Data warehousing environments, Slowly Changing Dimensions - Type I & II
• Expertise in Master Data Management/ Data Governance
• Expertise with Informatica Data Quality(IDQ) toolkit,data cleansing, data matching, data conversion, data profiling, exception management, reporting and monitoring functions
• Proficient in implementing Slowly Changing Dimensions - Type I & II using Informatica Power Center
• Performed business request analysis, creating business request response, source system analysis, Trust/Match strategy design, MDM performance/load count monitoring, User Acceptance Testing, 3rd party issue resolution, SIF API implementation.
• Strong Exposure in Data Warehouse concepts like Star and Snow-flake schema
• In depth knowledge on various phases of IT projects - planning and designing, gathering business requirements, analysis, development, testing, and implementation encompassing both Waterfall and Agile software development methodologies.
• Knowledge of on Big data and Hadoop eco systems, Data Profiling guidelines and best practices.
• Hands on experience on handling huge volume of data and performance tuning
• Successfully worked in global delivery models working with offshore & onsite teams
• Strong analytical, technical and mathematical computational skills combined with excellent problem solving capabilities.
• Highly motivated, customer oriented and successful working in both team/self-directed settings
• Initiative to learn, ready to adapt and master new business scenarios and technologies
• Organized, attentive to detail with proven record of accomplishing goals and demonstrated time management skills
• Possess excellent communication skills and handles multiple tasks simultaneously

TECHNICAL SKILLS:

Databases: Oracle 11g,DB2, IMS DB

ETL Tools: Informatica PowerCenter 8.x/9.x IDQ 9.5, MDM 9.7.1MDM 10.1, Informatica Data Director(IDD)

Languages: SQL, PL/SQL, UNIX, COBOL, Core Java

Operating System: Windows server 2012/2008 R2, Win-7/XP.

Tools: SQL Developer, MS-Visio, Control-M,ERWIN,TOAD

Other Skills: Mainframe(COBOL,JCL)

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Senior Data Analyst/Tech Lead (IDQ,MDM)

Responsibilities:

• Provide architectural design and create solutions for the customers to showcase the functionality of Informatica Master Data Management (MDM) and other products integrated with the MDM hub.
• Research, retrieve, design, troubleshoot, and deliver organized analytics on accounts receivable, utilization data, claims data and financial accounting data
• Deploying IDQ Mapping as Web Services.
• Oversee the design and implementation of data cleansing procedures.
• Identification and documentation of data quality requirements and related business rules
• Designs, develops, tests, documents and maintains database queries for ad hoc reporting used in complex conceptual analyses.
• Manages reporting and analysis elements on all business initiative projects.
• Provided Solutions for the Task Assignment as per the Business requirement
• Reviewed and provided the efficient methods in accordance with the Best practices
• Develops innovative approaches to achieve deliverables and increase efficiencies.
• Develop and publish global data standards, master data dictionary, data governance policies and processes required to effectively manage enterprise master data. Modify these standards, policies and processes as needed when business requirements and/or systems change
• Collaborate across both processes and data domains to ensure all needs are met with respect to the assigned data domain.Collaborate functionally across business process, data & system domains to ensure all needs are met with respect to master data
• Generates and records ideas for improvement (e.g. integrity checks, maintenance processes, metadata, services
• Work with Data Stewards on defining the terms in the Enterprise Glossary and Data dictionary
• Actively contributes to the results of a team and works towards achieving team goals and objectives
• Develop KPIs to monitor and measure actual data quality and process effectiveness that point to tangible business value
• Build profiling, cleansing and validation plans.
• Analyze profiling results and make recommendations for improvements.
• Gathers requirements for customized solutions and provides alternative solutions
• Monitor all functions on utilization of enterprise master data policies and procedures .
• Perform root cause analysis of process & system problems pre and post implementation and for existing production processes & systems, recommend solutions to prevent problem recurrence
• Creates documentation of business processes, training procedures, and standard operating procedures
• Responsible for data accuracy, performing and reporting on periodic audits and data integrity checks
• Supports the strategic vision for the business use and management of corporate data to achieve increased efficiency, effectiveness and profitability
• Support the development and implementation of capabilities to improve, monitor, and audit data quality within the reporting and analytics environment.
• Establish and maintain data management best practices and standards, and ensure consistent application of those practices across the organization.
• Analyze existing business processes and identify opportunities for improvement; Propose alternative business process solutions
• Validates and serves as point of escalation for change requests
• Assists in maintaining master data governance processes from definition through to execution and continuous improvement
• Analyzes data loads and exceptions to find patterns in data to enhance business rules
• Corrects data issues and ensures consistent standardization to align with master data policies
• Perform acceptance tests on delivered software components
• Manage risk by implementing effective scope management process
• Analyze all aspects of Enterprise Data Warehouse including: refreshes, programming, system functionality, troubleshoot data integration and providing support for quality improvement team.
• Collect, synthesize and research complex data and design work flows and procedures .
• Troubleshoot client inquiries for data reported while regularly updating on progress and documenting steps.
• Serve as Analytic contact/resource for external business partners to support ongoing data exchange, analysis, reporting and interpretation of performance results; establish and maintain effective ongoing client relationships

Confidential, FL

Tech Lead/Senior IDQ MDM Developer

Responsibilities:

• Implement the Data Governance framework that meets data objectives for the organization.
• Design complete IDQ application from Source extraction through mapping design and master workflows
• Design complex application in data handling by exception/human task and projecting data to analysis and cleanup
• Work in Exception Management Framework to capture the exceptions and implement human task out of the box functionality
• Involve in designing MDM data model and created base objects, mappings, defined trust setting for sources, customized user exists, customized IDD applications
• Work with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Normalize data models across source systems and successfully delivered projects within time lines.
• Create a Hybrid process in IDQ by combining both IDQ Developer and analyst version through Logical Design Objects
• Responsible for project managing tasks, deadlines for the ETL teams, Reporting, Testing, QA and deliver status updates to key stakeholders.
• Export the IDQ Mappings and Mapplets to power center and automated the scheduling process.

Confidential, CA

Technical Lead/Architect/ System Analyst

Responsibilities:

• Provide architectural design and create MDM solutions .
• Create MDM data models and IDD configuration for domains as per the customer requirements and data
• Design and configure MDM hub and IDD by creating Staging, Landing tables, Mappings and data flow to the Base object tables, Match& Merge, Trust settings, Complex hierarchies & workflow for Informatica MDM
• Data Profiling and Data Quality Analysis of the customer data for the efficiency of the Informatica Products
• Use Address Doctor for Address validation of Providers from different legacy Source Systems.
• Build reusable components on IDQ using Parsers, Standardizers and Reference tables to standardize
• Involve in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.
• Use Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles as subject areas in IDD.
• Work on performance tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse.
• Worked on real time implementation using SIF, hub customization and user exits.

Confidential

Project Lead

Responsibilities:

• Profile the Data from the current Source systems and identify Data Quality rules for cleansing and standardization
• Work on performance tuning of the complex transformations, mappings, sessions and queries to achieve faster data loads to the data warehouse
• Provide support as Onsite coordinator, acted as quality gate for the offshore deliverable
• Communicate with the client regarding project status, deliverables, and resolve issues

Confidential

Senior Developer/Team Lead

Responsibilities :

• Responsible for Business Analysis, Requirements Collection, Parse high-level design specification to simple ETL coding and mapping standards.
• Design and customize data models for Data warehouse supporting data from multiple sources on real time
• Involve in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Create mapplets and developed mappings to load into staging tables, Dimensions and Facts using ETL
• Work on different tasks in workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

Confidential

Developer

Responsibilities:

• Develop data models for capturing current /future state data elements and data flows using Erwin
• Covert data marts from logical to physical design, define data types, constraints, indexes, generate schema
• Review source system and propose data acquisition strategy
• Develop complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations
• Deploy reusable transformation objects such as mapplets to improve quality and efficiency
• Involve in performance tuning and issue resolution

Confidential

Developer

Responsibilities:

• Design and implement Informatica ETL mappings to extract and transform data from various sources creating environment for staging and loading areas
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems
• Utilize workflow manager for session management, database connection management and scheduling of jobs
• Create UNIX shell scripts for Informatica ETL tool to automate sessions.
• Support Mainframe tasks in both source and target side