IT professional with extensive experience in Data Warehousing, Data

Analyst, Data Modeling, Design and Programming. Experienced with multiple

computing environments and a variety of project types and sizes (small to

large, multi-year efforts), from business requirements to post

implementation support and reviews, the complete system design life cycle

(SDLC). Also extensive experience of review techniques as well as a broad

knowledge of requirements definition, design, testing, and implementation

in the IT Development area.

OBJECTIVE:

Seeking a position to work as a Data Warehouse/Data Modeling/ETL/OLAP

Lead for a reputable organization and to be able to exercise my skills and

further enhance my career leading to greater accomplishments in the

implementation of high quality software using good project management,

quality processes and tools.

TECHNICAL EXPERIENCE:

Extensive experience in Architecting and Developing Data Warehousing

projects.

. Data Warehouse Design, Modeling, Analyst, ETL and Execution of data

warehousing projects

. Handle Data Warehouse Project End to End

. Design Database, table and implementation for data warehouse and related

ETL processes.

. Extensively worked on SQL server, Oracle, Teradata and HP Neoview

Database.

. Intense Knowledge in designing Fact & Dimension Tables, Physical &

Logical data models using ERWIN and Erwin methodologies like Forward &

Reverse Engineering.

. Extensively worked on the ETL mappings, analysis and documentation of

OLAP Cube requirements. Solid understanding of OLAP concepts and

challenges, especially with large data sets.

. Experience in performance tuning in large volume data and implementing

data partition.

. Extensively worked experience in SSIS,SSAS, SSRS, MDX and Optimization

and performance tuning of SQL Server

. Ensure the implementation of the quality standard and processes in

project deliverables.

. Expertise in tuning the performance of mappings and sessions in

Informatica and determining the performance bottlenecks.

. Expert in troubleshooting/debugging and improving performance at

different stages like database, workflows, mapping.

. Experience in Installation and configuration of Informatica server to

handle the Informatica administrator tasks like Creating repository and

backup, copying & moving mappings, workflows and creating folders etc.

. Ability to work independently as well as work with teams having varying

backgrounds on complex issues

. Knowledge in design and development of Business Intelligence reports

using BI tools Business Objects, Cognos and Microstrategy.

. Experience includes thorough domain knowledge of Manufacture, HRMS,

Financial system and Banking.

. Enthusiastic and goal-oriented team player possessing excellent

communication, interpersonal skills and leadership capabilities with high

level of adaptability.

. Very good knowledge in MDM, Big Data, NoSQL and Hadoop technology.

TECHNICAL ENVIRONMENT

Hardware/OS : Windows 9x/NT/2000/2003, MS DOS, UNIX

Database : Oracle 10g/11g, SQL Server 2008/2012,

Teradata v2r6, HP Neoview

ETL : Informatica PowerCenter 8.6.1/9.0, SQL Server

Integration Service (SSIS)

OLAP : SQL Server Analysis Services (SSAS), Business

Object,

Pentaho Mondrian, Crystal Analysis

Report : Crystal Report, SSRS

Data Modeling : Erwin, Visio 2000,S Designer

Languages & Script : PL/SQL, SQL, MDX, Visual Basic 6.0 &

Unix Shell

Others : MS Visual SourceSafe, TFS and Subversion

KEY PROJECTS:

Anexinet, Bluebell, PA

(Oct 2013 - Till Date)

Data Warehouse Design / ETL / OLAP Lead Developer

Description: DecisionSim enables healthcare providers, academic

institutions and professional societies to cost-effectively develop

decision-making. Simulations can be built to support individual learning,

interprofessional teams and large groups. With DecisionSim have full

control over the level and amount of branching, media, feedback, assessment

and other key components.

Responsibilities:,

. Worked with Business users to understand the Business Logics as per

the need.

. Designed the SSIS packages in order to extract data from SQL db, flat

files and loaded into SQL database.

. Performed Source system analysis to identify the source data that

needs to be moved into the target tables.

. Extensively used partition components to process huge volume of

records quickly.

. Design and Develop complex queries efficiently as per the given

business requirements.

. Implemented Event Handlers and Error Handling in SSIS packages.

. Designed Cube partitioning and incremental synchronization for SSAS

cubes.

. Involved in Staging Partitions and Usage Based Optimization for SSAS

OLAP databases.

. Worked on Table Partitioning to load current and historical data.

. Experience in query optimization & performance tuning using SQL

Profiler, Execution Plan and Performance Monitor.

. Designed MDX queries to retrieve data from SSAS cubes.

. Implemented indexes for performance tuning and unit testing.

. Conduct code walkthroughs and review peer code

Environment: SQL 2008R2/2012, SSIS, SSAS, SSRS, Erwin, and Windows 7

Independence Blue Cross, Philadelphia, PA

(Feb 2013 - Sep 2013)

Data Warehouse Design / ETL / OLAP Lead Developer

Description: Blue Insight is a comprehensive consultative reporting tool

that will provide customers the ability to utilize data in an analytic way

to inform business decisions. This includes a comprehensive dashboard with

at a glance data along with sophisticated drill down capabilities that

provide more granular analysis. Data includes medical and pharmacy cost and

utilization information along with program participation and gaps in care.

Responsibilities:,

. Extensively involved in functionality requirement analysis, understanding

source systems thoroughly by preparing the design process flow

documentation, Development & Implementation.

. Involved in designing Data model for various reporting based Data marts

using Erwin

. Assist project manager in scope estimation and work break down structure

to meet project milestone.

. Defined target load order plan and constraint based loading for loading

data correctly into different target tables.

. Designed and develop SSIS package, configuration files, stored procedures

and materialized view.

. Designed SSAS Cubes and building attribute relationships for optimal MDX

query performance of Hierarchies and Fact Dimensions.

. Writing technical specs and mapping documents from staging to data

mart, cubes and reporting needs

. Worked on source data analysis and identifying cleansing area

. Interacted with the users in understanding the enhancement need and

scope of existing reports and developed the reports to satisfy their

needs and requirements.

. Conduct code walkthroughs and review peer code

Environment: Teradata, SQL 2012, SSIS, SSAS, SSRS, Erwin, TFS and Windows

7

Ramco Systems, India/ Lawrenceville, NJ

(Mar 2009 - Jan 2013)

Data Warehouse Design / ETL / OLAP Lead Developer

Description: Ramco Banking Analytics is a next-generation analytics

solution that offers a one-stop solution to banks for all their Management

Information System (MIS), Decision Support System and Executive Support

System needs. The solution enables complete performance management for your

bank by giving you a 360-degree view of your core business areas. This

solution covered Customer wise Performance Analysis, Loan Analysis, Deposit

Analysis and generation of all the reports required within the bank. The

data warehouse solution provides business intelligence using KPIs, score

cards, cube reports and MIS reports

Responsibilities:,

. Involved in design and development of Business Requirements to business

users by identifying data sources

. Designed dimensional modeling using Erwin.

. Developing several complex mappings in Informatica a variety of

PowerCenter transformations, Mapping Parameters, Mapping Variables,

Mapplets & Parameter files in Mapping Designer using the Informatica

PowerCenter and data profiling on IDQ.

. Writing package and procedure using PL, SQL, SQL and Materialized view.

. Detected bottlenecks, trouble shooting and tuning of mappings,

implement partition on sessions for better performance and efficiency.

. Perform Unit tests, Performance and Load testing and validated results

with Functional lead and providing technical guidance to ETL team.

. Designing OLAP Cube in Pentaho Mondrian and SSAS for generating

multidimensional report and charts

. Technical mentoring of the ETL team

. Wrote UNIX shell scripts for Informatica ETL to run the Sessions.

Environment: HP Neoview, UNIX, SQL 2008, Oracle 11g, Informatica

PowerCenter 9.0.1/8.6.1, Informatica Data Quality, Pentaho Mondrian

OLAP, Erwin, SSIS, SSAS, SSRS and Windows 7

MJB Wood, Irving, TX (Dec 2008 -

Feb 2009)

Data Warehouse Design / ETL / OLAP Lead Developer

Description: The MJB Wood is most advanced wood products and supply chain

management company in the wood supply industry. MJB offers a variety of

wood products, both domestic and imported. Our product offerings include

panel products, cabinet, fixture and furniture components, door and window

components, and millwork and specialty products. Ramco Business Decisions

is being implemented to a automate data collection, balanced score card,

computation of key performance indicators by integrating with Ramco ERP

system.

Responsibilities:,ETL Design, Execution, Quality Assurance and support

. Analyzed application requirements and provided recommended design and

Studied the current system to understand the existing data structures

. Used Informatica Power Center 8.6.1 for extraction, transformation and

loading (ETL) of data in the Data Warehouse

. Performed ETL from oracle into SQL Server Data Warehouse using

Informatica Mappings including transformations Aggregator, Joiner, Lookup

(Connected & Un-conneted), Filter, Update Strategy, Stored Procedure,

Router, Expression, Sql and Sorter

. Write package and procedure using PL, SQL, SQL and Materialized view.

. Created workflows and tested mappings and workflows in development, test

and Production environment.

. Developed re-usable transformations, mappings and mapplets confirming to

the business rules.

. Actively involved in Performance improvements of Mapping and Sessions and

fine tuned all transformations

Environment : SQL 2005, Oracle, Informatica 8.6.1, Analysis Services, SSAS,

SSIS, SSRS,ERWIN and Windows2003

Essex Crane, Illinois (Feb 2008 -

Nov 2008)

Data Warehouse Design / ETL / OLAP Lead Developer

Description: Essex Crane has grown steadily over 40 years into one of the

world's largest provider of lattice-boom crawler cranes and attachments.

With over 350 cranes and attachments in its fleet, Essex supplies cranes

for construction projects related to power generation, petro-chemical,

refineries, water treatment & purification, bridges, highways, hospitals,

shipbuilding, and commercial construction. Project involves creation of

performance metrics on dashboard for aggregated performance along with

analytical reports giving the consolidated view of the operations with

flexibility to view transactional details

Responsibilities:,ETL Design, Execution, Quality Assurance and support

. Studied the existing environment and accumulating the requirements by

querying the Clients on various aspects.

. Analysis of the requirements and translating it into Informatica

mappings.

. Extensively used ETL to load data using PowerCenter from source system

into staging tables and to load the data into the target database.

. Worked on Power Center Designer client tools like Source Analyzer,

Warehouse Designer, Mapping Designer, Mapplet Designer and

Transformations Developer.

. Testing Informatica Mappings for data accuracy.

. Improved performance by identifying the bottlenecks in Source, Target,

Mapping and Session levels.

. Creating / Updating and Running / scheduling Batches and Sessions.

. Tuned performance of Informatica session for large volumes of data by

increasing data cache size and target based commit interval.

Environment: SQL 2008, Oracle, Informatica 8.6.1, SSAS, SSIS, SSRS,OWC and

Windows2000/NT.

PHI Inc, Lafayette, Louisiana (Jan

2007 -- Jan 2008 )

Data Warehouse Design / ETL / OLAP Lead Developer

Description: Petroleum Helicopters Inc. (PHI), head quartered at Lafayette,

Louisiana, is one of the world's leading helicopter services companies.

Corporate Performance Management was implemented for the Safety,

Maintenance, Materials, People, Operations, Marketing and Finance

functional areas. A Comprehensive data warehouse talking to 5 different

systems was developed to support over 100 Key performance indicators and 30

OALP reports. A state of the art materials requirement planning was

implemented for optimal planning of material requirements for periodic

maintenance.

Responsibilities:,

. Source data analysis, table design using ErWin, improved cube designs

for ease of loading.

. Created and maintained Informatica PowerCenter mappings and Workflow

session as needed.

. Designing MOLAP Cube in MS Analysis Services

. Design and create database tables needed for application.

. Performance tuning in PowerCenter Mapping, and MS Sql Server

Database

. Tuning Informatica Mappings and Sessions for optimum performance.

. Used Informatica Workflow Manager to create, schedule, execute and

monitor sessions, worklets and workflows.

. Implemented various Performance Tuning techniques on Sources,

Targets, Mappings, Workflows and database tuning.

Environment: Erwin, SQL 2005, Informatica PowerCenter 8.6.1,, SSAS,

SSIS, SSRS, Ramco DecisionWorks, OWC, and Windows 2000

NBO - Data Migration, Dubai

(Oct 2006 - Dec 2006)

ETL Lead

Description: Nation Bank of OMAN is one of Omen's leading Banking which

currently serves over 5 million customers- end users on behalf of their

esteemed clients. The objective of the data migration activity is to

migrate the payroll data from the current Ramco 3x to the Ramco 4x Payroll

system and validate the same. Identify the data sources that must be

transported into the new system and also it involves getting acquainted

with the actual data that needs to be migrated. Loading the destination

tables with the cleansed source data using Informatica tool

Responsibilities: Requirements analysis, Project planning, Data mapping,

Coding, Execution and Quality Assurance.

. Extracted data from Oracle source and load to SQL Server

. Performed Data Cleansing and Data Profiling using several

transformations like Data Conversion and Derived Column

. Conduct code walkthroughs and review peer code and documentation

. Responsible for Unit testing and Integration testing of mappings and

workflows.

. Troubleshooting database, workflows, mappings, source, and target to

find out the bottlenecks and improved the performance.

Environment : Oracle 9, SQL Server, SSIS, and Windows 2000

Safe Air, New Zealand (Feb 2006 -

Sep 2006)

ETL / OLAP Lead Developer

Description: Safe Air Limited (SAL), headquartered at Blenheim, New Zealand

is aviation MRO (maintenance, repair and overhaul). SAL needed a business

performance system, which would help the company to

* Monitor and optimize process efficiencies and effectiveness.

* Identify business trends and hidden patterns.

* Have a unique and consistent view of the information.

The solution implemented encompasses various function areas of the business

like the Human resources, Business development, Business performance,

Operations and Finance. A Unique, consistent and comprehensive view over

the organization business available to users on their dashboards

Responsibilities: Requirements Analysis, Design, Execution, Quality

Assurance and Support

Environment: SQL 2005, RBI, Analysis Services, Erwin, Ramco Analytical

Report, DecisionWorks and OWC.

Sesagoa, India (July 2005-

Jan 2006)

ETL / OLAP Lead Developer

Description: Implementation of Corporate performance management application

with scorecards, Key performance metrics (KPI's) and analytical reports

with a long-term view of implementing Balance Scorecard. The solution

enables process management, sales and operation planning, cashflow

planning, drilling from high-level to detailed information, capturing

trends, performing statistical analysis, and extracting intelligence

Responsibilities: ETL Design, Executin, Quality Assurance and Onsite

implementation

Environment: SQL 2000, DTS,Analysis Services, DecisionWorks, Excel and OWC

eThekwini Municipality, South Africa

(Jan 2005 - Jun 2005)

Technical Consultant

Description: EThekwini, the municipality of Durban, one of the largest in

South Africa, prepares its capital and operating budget and plans its

sources of income well in advance to meet the expenditure. One of the main

sources of its operating budget is income from property tax. The new

budgeting system consolidates property information and other details from

various systems. Is supports multiple scenarios planning by varying the

controlling parameters and compare the budgets to arrive at the optimal

budget. Apart from the KPI developed to track the payments and

discrepancies, the system provides rates analysis report, budget vs. actual

and reconciliation reports. The reports which took months of manual

processing are available instantly.

Responsibilities: Design, Execution, Quality Assurance and onsite

implementation

Environment : SQL 2000, Analysis Services, RBI, DTS, DecisionWorks, Excel

and OWC

CIBA, Switzerland

(Sep 2004 -

Dec 2004)

ETL Developer

Description: CIBA specialty chemicals Switzerland has operations in more

than 60 locations in 23 countries employing about 20,000 people. Ciba's HR

Information Systems comprise of a very large number of diverse and often

non-integrated system clusters, with no single reliable source for HR data.

A global HR warehouse integrating data from 40 different systems and

providing unified and standardized HR information was developed. The

solution span encompasses KPI, score cards, cube reports and mis reports

with complex data security based on user's span of control facilitating

exception handling going to the level of employees.

Responsibilities: ETL Design, Execution, Quality Assurance and support

Environment : SQL 2000, Analysis Services, DTS, RBI, DecisionWorks, Excel

and OWC

Agency, SWRDA UK

(Feb 2003 - May 2003, Jan 2004 - Aug 2004)

ETL Developer

Description: South West Regional Development Agency is responsible for

economic development of nine counties in UK in the south west region. It

interacts with more than 7000 government and corporate bodies and manages

more than 1500 development programs. Siebel based contact and project

management system have been implemented. Agency needed to gain insightful

information to monitor their activities and to identify if they are

effectively and efficiently working towards their objectives. The warehouse

solution implemented encompasses development of Siebel connectors, data

warehouse comprehensively covering the major entities in the Siebel system.

Responsibilities: ETL, Execution, Quality Assurance and support

Environment: Siebel, SQL 2000, Analysis Services, RBI, DecisionWorks, Excel

and OWC

IPRings - India (Nov 2002 - Jan 2003)

ETL Developer

IPRings Ltd is a leading piston rings manufacturer. IPRings has a

structured performance management being implemented in their operations.

Currently manual computation is being done for key performance indicators.

Ramco Business Decisions is being implemented to a automate data

collection, balanced score card, computation of key performance indicators

by integrating with Ramco ERP system.

Responsibilities: ETL, Quality Assurance and support

Environment: SQL 2000, Analysis Services, DTS, RBI, DecisionWorks, Excel

and OWC

Pentasoft Technologies Limited, India February 1999 - August 2002

Designation : Assistant Consultant

Primary Responsibilities : Development of client based application based on

Visual Basic 6.0, Oracle 8.0 and Crystal Report 7.0 .

Education

. Master's Degree in Computer Applications, University of Madras (1995-98)

. Bachelor's Degree in Commerce, University of Madras (1991-1994)

Training

. Ramco - All SDLC processes laid down by Ramco Systems (CMMI L5 Company)

. Microsoft - Data warehousing using Analysis Services.

.

Contact this candidate