SUMMARY

• Over 11 years of combined technical and functional Solution Specialist experience involved in Analysis, Development and maintenance of and EDW (Enterprise Data Warehousing), MDM (Master Data Management) and CRM (Customer Relationship Management) Applications.
• Have extensive experience in understanding and analyzing the Business Requirements/Functional Specifications by interacting with Business Analysts and users, Project Planning, Design (Logical and Physical), Development, Testing, Implementation for Pharma and Hospitality Domains.
• Core Competency in Design, Development and maintenance of data interfaces for the applications using Informatica Powercenter ETL, SQL, PL/SQL, Windows and Unix Shell scripts.
• Strong experience in Application Production Support, Data Migration and maintenance using Informatica ETL and related database technologies like SQL, PL/SQL and MSSQL
• Involved in effective communication and co - ordination with in team and Product Managers and Business Owners.
• Planning and implementing projects and working in fast paced environment
• Designed the ETL modeling for multiple data marts like Supply Chain management and Formulary Data processing.
• Define scope and provide estimates on Data Warehouse change and maintenance requests.
• Writing the functional and technical specification documents for Pharma and Hospitality Domains.
• Dealt with heterogenous source systems like Flat file, XML files, CRM, MDM system for loading to data warehouse using ETL tools like Informatica
• Excellent experience in Data Modeling using Dimensional Data Modeling, Star/Snowflake schema modeling, FACT and Dimensional tables, Physical and logical data modeling using Visio
• Have exposure to Business Intelligence tools like Microsoft SSRS and MicroStrategy
• Excellent experience in Siebel CRM data model
• Expertise in doing the RCA (Root Cause Analysis) and resolving the production issues within stringent SLA’s (Service Level Agreement) for EDW, CRM and MDM applications
• Automation, scheduling and monitoring of production jobs using Tidal Enterprise Scheduler.

TECHNICAL SKILLS

ETL Tools: Informatica Powercenter 9.x/10.x

CRM Tools: Siebel 7.x/8.x/Open UI

Data Modeling and Design Tool: Microsoft Visio

Scheduling Tools: Tidal Enterprise Scheduler and Cron tab

Programming Languages: SQL, PL/SQL, Basics of Java, C and C++.

Operating Systems: Windows NT, Windows-XP, Windows Vista, Windows 7

Database: Oracle 9i, 10g and 12c, Microsoft SQL Server

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse Tech Lead and MDM Lead

Responsibilities:

• Work with Business Users and Product Managers to understand the business needs and design the data model to fulfill the business needs.
• Act as a Solution Architect for medium and complex EDW Business requirements by actively involving Business users and Product Managers
• Understand the Functional Requirements and break it down to technical components.
• Provide optimal ETL solution to extract and load data from different source system to Data Warehouse
• Involved in implementing ETL standards and best practices that needs to be followed by team members.
• Designing the High Level ETL Dataflow
• Create the Functional and Technical Design Specification Documents
• Design Source to Target mapping document.
• Define Scope and provide estimates for the change requests in Data Warehouse and MDM
• Testing and Setting up the peer reviews for each of the modules to minimize the development errors
• Creating Change Tickets to deploy the code into Production.
• Responsible to handle and fix the production issues in stringent SLA’s
• Provide daily operation support on Data warehouse and MDM daily jobs
• Involved in coordinating the communication between offshore team and client

Confidential

CRM and Datawarehouse Interfaces Lead

Responsibilities:

• Use DevOps tools like Jira for effective agile project management
• Design and Development of Informatica ETL jobs for Siebel EIM process
• Design and Development of SQL, PL/SQL scripts for data cleansing jobs using Siebel EIM process
• Strong experience in Optimizing the existing PL/SQL code using Oracle performance tuning techniques
• Writing the Functional specification documents based on the Business Requirement document
• Prepare the Project Plan, line up the resources and track the project status to completion.
• Validate if data model captures all the functionalities requested by Business users.
• Co-ordinating and communicating with Business Analyst and Product Owners
• Developing the ETL detail design documents for each target table (Fact and Dimension Tables)
• Designed and developed complex mapping for varied transformation logic like Expression, Filter, Aggregator, Router, Joiner, Connected and Unconnected Lookup
• Prepared System Test Scripts for System Integration Testing
• Investigating and fixing the bugs occurred in the production environment during stabilization period.

Confidential

Senior ETL and PL/SQL Developer

Responsibilities:

• Support and maintenance of MDM application used for mastering Health care Professionals data using Informatica, SQL and PL/SQL
• Involved in all the phases of the SDLC requirement gathering, design, development, unit testing, UAT, production deployment, enhancements and Production Support.
• Interacting with Product Managers and Business Analysts to understand the requirements.
• Design and Development of Siebel EIM jobs using Informatica ETL
• Used Informatica to develop processes for extracting, cleansing, transforming, integrating and loading data into MDM and CRM applications
• Involved in tuning the Informatica mappings for optimum performance
• Design and development of Unix Shell scripts, SQL and PL/SQL Procedures for complex data cleansing activities across MDM, CRM and EDW interfaces