SATEESH.K

Email:acob1y@r.postjobfree.com

BI Consultant

Mobile: +91-800*******

Summary:

Working as a BI consultant with over 5+ years of experience in

Information technology across verticals in the Darawharehouse

implementations with ETL Tools Pentaho Kettle & Informatica.Being a

consultant i have been Involved in Development,Test & Production

Environments.

Technical Skills:

Business Intelegence Tools(BI) : Pentaho BI

ETL Tools :

Pentaho (kettle),Informatica Power Center

Reporting Tools : Pentaho Report

Designer,Schema workbench

Dashboard Designer,Meta Data Editer,Instaview.

Data warehouse Model : Star Schema, Snowflake

Schema.

Databases : Ms sql server, Oracle,

Mysql, Postgres.

Testing : ETL

Testing.

Operating Systems : Windows, Linux.

Domain : Healthcare

Professional Summary:

Working as a Senior Technical Consultant for Ohum Healthcare Solutions Pvt

Ltd-Pune from November 2012 to till date.

Worked as a Software Associative for Gray Matter Software Services Pvt Ltd-

Bangalore from October 2011 to October 2012.

Worked as a Software Engineer for Vanetsys Technologies Pvt Ltd- Bangalore

from Feb 2009 to September 2011.

Education:

Bachelor of Technology in Electrical and Electronics Engineering From JNTU-

2006.

As a ETL Consultant My Roles:

Good Experience in Extraction, Transformation and Loading from Homogeneous

and Heterogeneous Sources.

Using the data Integration tool Pentaho for designing ETL jobs in the

process of building Data warehouses and Data Marts.

Participation in Performance tuning in database side, transformations, and

jobs level.

Good experience in design the jobs and transformations and load the data

sequentially & parallel for initial and incremental loads.

Good experience in using various PDI steps in cleansing and load the data

as per the business needs

Good experience in configuration of Data integration server to run the jobs

in local, remote server and cluster mode.

Good Experience in designing the advance reports, analysis reports and Dash

Boards as per the clients requirements.

Good Experience in creating cubes by using Pentaho Schema Workbench.

Installation and setup complete BI suite as per the clients requirements.

Understand the requirements for designing the BI Architecture and ETL

Architecture.

Interact with clients for change request understanding to enhance &

designing Reports, dash boards.

Projects:

1.Care-BI for Center for Sight:

Centre for Sight is a Multi-location ophthalmology healthcare institute.

The main objective of this project is build a complete BI Solution on top

of two different systems (HIS, Clinical), designing ETL scripts using PDI

to extract the data from two different systems to populate BI data mart,

and building cubes using

Pentaho schema workbench to design analysis and dashboards, and designing

interactive reports with

Pentaho report designer.

Environment:

Pentaho BI.5.0.1,Pentaho Report Designer,Pentaho schema

workbench,MYSQL,Linux.

Responsibilities:

Involved in creation of Data Mart as per the requirements.

Involved to identifying HIS flow to design the fact and dimensions tables.

Understanding the existing environment to start up ETL process from High

level documentation.

Involved in Developing the transformations and jobs by following the

prescribed BRD's, verified the Result sets according to the specifications.

Developed ETL process using Pentaho PDI to extract the data from HIS and

Vista, and populated it in to BI Data mart.

2.Care-BI for Max Healthcare Solutions:

Max Healthcare is a Multi-location healthcare institute based in New

Delhi, India. The main objective of this project is build a complete BI

Solution on top of two different systems (HIS, Vista), designing ETL

scripts using PDI to extract the data from two different systems to

populate BI data mart, and building cubes using Pentaho schema workbench to

design analysis and dashboards, and designing interactive reports with

Pentaho report designer.

Environment:

Pentaho BI.5.0.1,Pentaho Report Designer,Pentaho schema

workbench,MS SQL Server 2008,Windows.

Responsibilities:

Worked with onsite team to identifying their HIS flow and designed queries

to extract the data from the HIS system and to design the fact and

dimensions.

Understanding the existing environment to start up ETL process from High

level documentation.

Developing the transformations and jobs by following the prescribed BRD's,

verified the Result sets according to the specifications.

Developed ETL process using Pentaho PDI to extract the data from HIS and

Vista and populated it in to our BI Data mart.

3.CRM-BI for Max Healthcare Solutions:

Max Healthcare is a Multi-location healthcare institute based in New

Delhi, India. The main objective of this project is build a complete BI

Solution on top of two different systems (HIS, Vista), designing ETL

scripts using PDI to extract the data from two different systems to

populate BI data mart, and building cubes using Pentaho schema workbench to

design analysis and dashboards, and designing interactive reports with

Pentaho report designer.

Environment:

Pentaho BI.4.8,Pentaho kettle, MS SQL Server 2008,Windows

Responsibilities:

Worked with onsite team to identifying their HIS flow and designed queries

to extract the data from the HIS system and to design the tables

Understanding the existing environment to start up ETL process from High

level documentation.

Developing the transformations and jobs by following the prescribed BRD's,

verified the Result sets according to the specifications.

4.HP_Sitescope Monitoring System:

Set of applications for monitoring the performance of the

networks, servers etc. basically IT assets and also incident management

for visibility into the performance of their networks or the efficiency of

the incident/tickets handling process. In order to solve this, implement a

DW/BI solution on top of their transactional systems.

Environment:

Pentaho PDI 4.2.1,Oracle 10g, Pentaho Report Designer,Pentaho schema

workbench Windows.

Responsibilities :

Design the database objects as per the Data modeling Schema, according to

the Requirements.

Develop the jobs and transformations foe initial load and incremental load

in to staging and DW as per the BRD's.

Design the jobs and transformations sequential and parallel as per the

requirements.

Involved in the design of auditing tables for the job status for checking

the job status the incremental loading.

5.Stream Global Services:

Stream is a leading global BPO provider with a worldwide presence of 50

solution centers across 22 countries in North America, Europe, the

Philippines, India, Latin America, Middle East and Africa. Stream provides

its clients a broad, full-service offering of truly innovative and

comprehensive BPO services in sales and revenue generation, technical

support, customer care and back office offerings. These offerings span

multiple customer touch points and may encompass several product and

service lines. For this project we get the data from different sources by

applying some transformations and jobs the data is loaded in to data

warehouse.

Environment:

Pentaho PDI 4.2.1,Informatica Power center,MSSQL Server

2005,Windows.

Responsibilities :

Involved in the design of auditing tables for the job status for checking

the job status the incremental loading.

Developed ETL process using Pentaho PDI to extract the data from legacy

system.

Understanding the existing environment to start up ETL process from High

level documentation.

Developing the transformations and jobs by following the prescribed BRD's,

verified the Result sets according to the specifications.

Involved in Performance Tuning at sources, targets, Transformations side.

Tuning the jobs for better performance at transformations level, and

database level performed unit testing.

Contact this candidate