Ganesh J

E-Mail: ac1wqp@r.postjobfree.com

Mobile: - +91-789-***-****

Address:Bangalore(INDIA)

Having 4.1 Years of IT Experience in Providing Business Intelligence Solutions in Data Warehousing Using MSBI Tools SSIS,SSRS, SQL SERVER,ORACLE 11G.

PROFILE SUMMARY

Experience in developing SSIS Packages and SSRS reports.

Created solutions, projects and packages and managing them.

Excellent skills in implementing ETL Packages using SSIS 2008 R2/ 2012.

Experience in Data Transformations like Derived Column, Conditional Split, Merge join, lookup, union all, Aggregate & Sort to load data into Data Warehouse.

Worked with logging and error handling in various projects.

Involved in performance tuning at different levels (Package, Source, Destination and Transformation).

Experience in working on creation of various Reports using SQL Server Reporting Services (SSRS).

Created Tabular, Matrix, Chart reports with parameters using SSRS.

Experience in creating Drill Down,Drill Through and Cascading parameters in SSRS.

Deploying the reports to the Report Server,Enabling Subscriptions.

Extensive knowledge on Trading,Retail & Sales domains.

Good understanding of RDBMS Concepts, Database Design techniques.

Experience in creating views, complex Stored Procedures, user defined functions, derived tables and Triggers to facilitate efficient data manipulation and data consistency.

Worked with Sub queries, Joins, Set operations, stored procedures extensively.

Having good knowledge on Data warehousing concepts and BI concepts.

TECHNICAL QUALIFICATION

ETL Tool

:

Microsoft SSIS

Reporting Tool

:

Microsoft SSRS,TABLEAU

OLAP

:

Microsoft SSAS

Database

:

Microsoft SQL SERVER 2008/2012,ORACLE 11G

Languages

:

PL/SQL

Operating Systems

:

Windows Family

SERVER

:

Windows SERVER 2008,2012

EDUCATION

Completed Bachelor of Engineering in Computer Science from ANNA UNIVERSITY(Chennai) - 2012.

WORK EXPERIENCE

Working as a Software Engineer in COGNIZANT Technologies, Bangalore from APRIL 2015 to Till Date.

Worked as an Associate Software Engineer in HCL Technologies, Bangalore from OCT 2012 to MARCH 2015.

PROJECT DETAILS

COGNIZANT Technologies, Bangalore APRIL 2015 - TILL DATE

Designation: Software Engineer(BI DEVELOPMENT)

Project # 1 APRIL 2015 to TILL DATE

Project Name

Customer

Role

Technologies /Skills Used

DATAMART -

SALES ANALYSIS

SAFEWAY INC

(USA)

ETL Developer

SQL SERVER 2012, SSIS (ETL)

ORCALE11 G

Description:

Safeway is America’s largest retailer with more than 1,800 stores throughout North

America serving more than 3.5 million customers every week. Safeway operates fully

serviced supermarkets with more than 3000 products throughout America. Today

Safeway is one of America’s leading food retailing and Sales lead information provides

the capturing and maintaining information capabilities on all sales. To achieve this it

was required to transform/modify/load the sales data collected and stored into SQL

Server Database where it can be analyzed.

The Enterprise Data warehouse was implemented to centralize database for decision

support and to improve the client services by preventing errors, providing real-time

data and updating records as transactions are completed. Through the Data Mart

reports have been generated and scheduled.

Responsibilities

Involved in the ETL phase of the project.

Understanding existing business model and customer requirements

Analysis of functional and technical specifications of the project.

Extracted data from DB’s, EXCEL, Flat-Files into staging area then cleaned the data using appropriate business rules and load the information into Target tables.

Involved in Design and development ETL packages using SSIS.

Extensively used various containers,Tasks and Transformations of SSIS.

Development of mappings according to the ETL specifications for the staging area data load & warehouse data load using Integration Services.

Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Send Email Task and Data Flow Task.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns Conditional Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Involved in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Scheduled the ETL Package Using SQL SERVER JOB AGENT..

Experience in Creating Logging,Checkpoints and Deploying the packages.

HCL Technologies, Bangalore

OCT 2012 - MAR 2015

Designation: Associate Software Engineer (Database Development/BI)

Project # 1 SEP 2013 to MAR 2015

Project Name

Customer

Role

Technologies /Skills Used

PHARMA 340 B

Trizetto

Developer

BI: SSIS, SSRS

Database: SQL SERVER 2012/Oracle 10g

Description:

Drug Discount Program is a U.S federal government program created in 1992 that requires drug manufacturers to provide outpatient drugs to eligible health care organizations/covered entities at significantly reduced prices. The intent of the program is to allow covered entities to stretch scarce federal resources as far as possible, reaching more eligible patients and providing more comprehensive services.

Analyzing and Understanding the business requirements.

Creating packages at SQL Server Integration Service platform.

Used Control Flow Tasks like For Loop Container, For Each Loop Container,

Sequential Container, Execute SQL Task, Send Email Task and Data Flow Task.

As per requirements developed the reports in the form of Matrix, Table Using

SQL Server 2008 Reporting Services(SSRS).

Developed parameterized reports including multi-parameters, Sub reports and

Cascading parameters.

Generated the Reports Weekly and Monthly basis as per the Client

Requirement.

Experience in creating Drill Down, Drill Through, CHART reports and

Cascading parameters in SSRS.

Deploying the reports to the Report Server,Enabling Subscriptions.

Scheduled the reports and delivered it to the intended customer via e-mail

using subscriptions.

Project # 2 OCT 2012 to SEP 2013

Project Name

Customer

Role

Technologies /Skills Used

MERCURY

GENERAL

INSURANCE

MERCURY

GENERAL

INSURANCE

Developer

SSIS,SQL Server 2008, SSRS

Description:

Mercury General (NYSE-MCY) is the leading independent broker and agency writer of

automobile insurance in California and has been one of the fastest growing automobile

insurers in the nation. It is ranked as the third largest private passenger automobile

insurer in California, with total assets over $3 billion. Mercury also writes automobile

insurance in Florida, Georgia, Texas, Illinois, Michigan, Nevada, Oklahoma,

Pennsylvania, New York, Virginia, New Jersey and Arizona. In addition to automobile

insurance,

Mercury writes other lines of insurance in various states, including mechanical breakdown and homeowners insurance.

The objective of implementing the data warehouse is they want to analyze the business

in 360 degree angles in the view of customer, claim and branch and seller and agent etc.

Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, user defined data types .

Analyzing and Understanding the business requirements.

Created and manipulated many Packages using SSIS.

Implemented ETL and business logic with various tasks and transformations.

Populating the Data from different source systems into DW using SSIS.

Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

Experience in creating Drill Down,Drill Through and Cascading parameters in SSRS.

Deploying reports to report server and providing user access to reports..

Created Unit test cases and Implemented unit test results.

PERSONAL SNIPPETS

Gender

:

Male

Nationality

:

Indian

Marital Status

:

Single

Languages

:

English, Hindi, Tamil

Address

:

#13,2nd Cross,Hemanth Nagar,Marathahalli,Bangalore. PIN-560037.

Passport

:

L6563889

Contact this candidate