PROFESSIONAL SUMMARY:

• DWBI professional having around 12 years of demonstrated IT experience in design, development and implementation of Data warehouse solutions with strong analytical/ problem solving/interpersonal skills.
• Proficient in client facing role as a Senior Solution Consultant / Data Architect / Data Analyst / Tech Lead / Senior ETL Developer / System Analyst / Support Analyst in leading SEI CMMi Level 5 Organizations
• Has substantial domain knowledge in Healthcare, Manufacturing, Insurance, Technology Products industry.
• Strong knowledge in Data Warehousing BI&ETL concepts, expertise in Relational and Dimensional Modeling
• Proficient in Solution Analysis, ETL Design, Development and Implementation of a data warehouse solution
• Experience in managing business processes and immense ability to maintain relationship with both IT and business departments.
• Strong experience in ETL tools Informatica PowerCenter 7x/8x/9x and OWB (Oracle Warehouse Builder) 10g R2, Informatica TDM 9.7.0, Relational Databases Oracle 9i/10g, MS SQL Server 2008 and DB2, Programming languages Oracle PL/SQL and Unix Shell scripting.
• Knowledge on Big Data / Hadoop fundamentals, IBM InfoSphere BigInsights and Informatica MDM
• Experience in data visualization tool ‘Tableau Desktop 9.1’
• Extensively worked on Extraction, Transformation and Loading of data using Informatica from heterogeneous sources (Relational database and Flat Files).
• Experienced in Performance Tuning of sources, targets, transformations and sessions
• Has experience in SDLC process to gather functional requirements, Data Analysis, Technical design and Coding, Unit Testing, System Integration Testing, Defect Tracking, deployment activities, version management, and production deployment planning etc.,
• Limited knowledge in reporting tools OBIEE / Cognos 10.1 / BOXI R2.
• Experience in developing UNIX Shell scripts for file processing, file/data validations, FTP/SCP process handling, Job executions, Data Archival and Purge processes
• Exceptional ability to meet all goals working in a team environment.
• Excellent communication skills in both oral and written forms.
• Tendency to thrive in a fluid and dynamic environment. Motivated self - starter with strong work ethic and consistently maintained impeccable standards.

TECHNICAL SUMMARY:

ETL/Data Management Tools: Informatica PowerCenter 7x/8x/9x and OWB 10g R2 (Oracle Warehouse Builder), Informatica TDM 9.7.0

BI Reporting / Data Visualization Tool: Tableau Desktop 9.1, Cognos 10.1, OBIEE and BOXI R2

Big Data Tools: IBM InfoSphere BigInsights & Hadoop Framework

Database: Oracle9i/10g, SQL Sever2000/2008 and DB2

Programming Languages: Oracle PL/SQL and Unix Shell Scripting

Other Tools: TOAD, Oracle SQL Developer, Visio, MS SQL Server 2008 Management Studio and Autosys (scheduler)

Operating System: Windows9x/2000/NT/XP, Unix SUN SOLARIS and Linux

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

ETL Solution Consultant

Responsibilities:

• Responsible for source data analysis, analyze the source data, quality of the data and data format.
• Worked closely with the application SME’s, stake holders to understand the requirements.
• Analysis of source systems and data to check the feasibility from the design perspective.
• Preparing the high level architecture / process flow, Logical solution design document, Physical Solution approach document, ETL framework to fulfill the requirement
• Responsible ETL Design, Development and Unit test
• Validation / Review from the stakeholders to get the approval of the ETL design process
• Effort estimation
• Applied Industry standard best practices, performance tuning approaches to build a better code
• Providing technical guidance to the development team, consolidating the issues/clarifications from the team and resolving the same.
• Responsible for providing ongoing status on progress to the stakeholders
• Created the project artifacts and contribution of maintaining the lessons learnt document

Confidential

Solution Consultant

Responsibilities:

• Responsible for source data analysis, data discovery and profiling to analyze the source data, quality of the data and data format.
• Worked closely with the application SME’s, stake holders to understand the requirements.
• Analysis of source systems and data to check the feasibility from the design perspective.
• Preparing the high level architecture / process flow, Logical solution design document, Physical Solution approach document, TDM framework to fulfill the requirement
• Responsible for Subset ETL Design, Development and Unit test
• Validation / Review from the stakeholders to get the approval of the subset process
• Effort estimation
• Applied Industry standard best practices, performance tuning approaches to build a better code
• Providing technical guidance to the development team, consolidating the issues/clarifications from the team and resolving the same.
• Responsible for providing ongoing status on progress to the relevant stakeholders to meet the project timeline and gaining the clients expectation to deliver the project on time
• Created the project artifacts and contribution of maintaining the lessons learnt document
• Responsible for interacting with Informatica Corp to get the Product specific guidance to achieve the solution for any problem faced in the development phase.
• Successfully mentored the TDM tool to the team

Confidential

Solution Consultant / Lead Data Analyst / Senior ETL developer

Responsibilities:

• Responsible for source data analysis
• Worked closely with the application SME to understand the requirement.
• Preparing the Mapping document to meet the requirement need
• Gathered user requirement as part of POC of this project to build a Dashboard
• Created the Dashboard using Tableau features to develop the preventive model to improve the claims loss ratio effectively compared to the existing BO reports
• Successfully presented the knowledge sharing session on the data visualization tool ‘Tableau 9.1’ to the team. As a Senior ETL developer
• Effort estimation based on the data mart(s) requirement and complexity of solution design.
• Preparing the solution design document to meet the requirement
• Performed the ETL design, development, Unit test and UAT support
• Applied Industry standard best practices, performance tuning approaches to build a better ETL code
• Responsible for providing weekly updates on every task status to meet the project timeline and gaining the clients expectation to deliver the project on time

Confidential

Lead Data Analyst / Senior ETL Developer

Responsibilities:

• Responsible for requirements analysis and preparing the ETL high level and low level design document
• Involved in effort estimation and project planning
• Applying the best approaches, Naming Conventions to Entities / Attributes.
• Development of the ETL code, Unit Test, QA and UAT support
• Implementing the Industry standard best practices in the ETL code
• Responsible for Migration of the code in QA/Prod environments and delivery of the project in specified timeline.
• Post production support activities

Confidential

Senior ETL Developer

Responsibilities:

• Responsible for requirements analysis and preparing the ETL high level and low level design document
• Involved in effort estimation and project planning
• Identifying the best approaches, Naming Conventions to Entities / Attributes / Relationship during the design analysis.
• Development of the ETL code, Unit Test, QA and UAT support
• Closely work with Solution Analyst to understand the requirements for better design to achieve the requirements
• Implemented the data masking of sensitive data to be used in development phase
• Implementing the Industry standard best practices in the ETL code
• Responsible for Migration of the code in QA/Prod environments and delivery of the project in specified timeline.

Confidential

ETL Lead

Responsibilities:

• Responsible for gathering the requirements, analysis and preparing the ETL requirements document
• Preparing the high level design document and identifying the best approaches in the design to fulfill the requirement
• Offshore co-ordination to explain the requirement, clarifying the team's queries, technical guidance, development support and solution approach discussion with the team
• Project Task plan and Effort Estimation
• Working with data architecture team and data governance team to apply the Data Modeling Best Practices, Modeling Standards, Naming Conventions to Entities / Attributes / Relationship
• Implementing the Industry standard best practices in the ETL code
• Responsible for Migration of the project deliverables and delivery of the project
• Version maintenance of the ETL objects through Subversion tool as part of standard process
• Weekly status report preparation

Confidential

Onshore Consultant

Responsibilities:

• Responsible for gathering the new / change requirements, analysis and preparing the ETL requirements document
• Preparing design document offshore co-ordination to explain the requirement, technical guidance, development and test support
• Weekly status report and effort estimate preparation
• As part of process improvements, proposed the SCM methodology to the client using the versioning tool Subversion.
• Responsible for the delivery of all enhancements and changes in the maintenance stream and post production activities.
• Involvement of all Production support activities