SUDHAKARA N (:

acgvpo@r.postjobfree.com

(: +91-906*******

PROFILE SUMMARY

Having 3+ years of Professional experience in IT industry, Involved in MSBI

projects with extensive usage of ETL & Reporting tools like SQL Server

Integration Services (SSIS), SQL Server Reporting Service (SSRS) and SQL

Server.

> Have worked in multiple projects as BI Developer in Designing ETL

Packages and reports in development and implementation stages of the

Project according to client requirements.

> Extensive experience in joins, indexes, views, stored procedures,

functions and sub queries.

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

Sequential Container, Execute SQL Task, FTP Task and Data Flow Task in

Designing packages.

> Proven proficiency at Data Transformations like Lookup, Derived Column,

Conditional Split, sort, data Conversion, Union All, Merge Join, SCD and

OLEDB Command to load data into SQL Server destination.

> Experience in providing Error Logging and Error handling for SSIS

Packages.

> Having extensive experience in deploying SSIS Packages and scheduling

them.

> Designed different reports like Matrix, Drill Down, Drill Through and Sub

reports.

> Creating the reports as per client's requirements in the form of table,

matrix and Chart.

> Experience on Report Design, Development and Deployment using SSRS.

> Scheduling the Reports Weekly and Monthly basis as per the Client

Requirements.

> Extensive knowledge on SQL Server 2008.

> Knowledge on Dynamic SQL evaluated in stored procedures.

> Good knowledge on data warehousing concepts.

> Good communication, inter-personnel skills and good team player.

TECHNICAL SKILLS

> Technologies : Microsoft Business Intelligence Tools (MSBI)

> Operating Systems : Windows 2007 / XP, Windows Server 2008

> Databases : SQL Server 2008 R2

> ETL Tools : SQL Server 2008 Integration Services

> Reporting Tools : SQL Server 2008 Reporting

Services

> Utilities : SQL Server Management

Studio(SSMS)

PROFESSIONAL EXPERIENCE

> Currently Working as a Software Engineer with NTT DATA Global Delivery

Services Limited in Bangalore from Aug 2013 - Till date.

> Worked as Software Engineer with Manhattan Associates Development centre

Pvt. Ltd. in Bangalore from May 2011 - July 2013.

EDUCATIONAL PROFILE

> Bachelor of Technology from Jawaharlal Nehru Technological University,

Anantapur.

PROJECT EXPERIENCE

Project #1

Title : Retail Sales Analysis Systems

Client : Tiger Direct, USA

Role : SSRS, SSIS Developer, T-SQL, SQL

Environment : SSIS, SSRS, SQL Server 2008

Duration : Aug 2013 - Till date

Description:

Tiger Direct is a direct online and catalog retailer of computers and

consumer electronics .The core aim of this project was to support the

broader set of analytic needs. This data Warehouse design process includes

data extracted periodically from the applications that support business

processes and validated, reformatted, reorganized, summarized, restructured

and finally loaded into Data warehouse systems. The resulting data

warehouse is the main source of information for report generation,

analysis, and presentation through ad hoc reports and dashboards.

Responsibilities:

> Extracting data from multiple sources like flat files, oracle, and SQL

server and transforming, cleansing, validating data and loading into

final Destination.

> Designing packages Using Control Flow Tasks like For Loop Container,

For Each Loop Container, Sequential Container, Execute SQL Task and

Data Flow Task.

> Extracting data from sources and transforming the data using different

transformations like data conversion, derived columns, look up,

Conditional Split, Aggregate, Union all, merge join and multi cast

transformations.

> Creating Event Handlers for the Packages Using Event Handler Tab for

Error Handling.

> Creating Configurations to change the package properties dynamically.

> Maintaining log information in SQL table to tracking Errors and

recording package execution status.

> Building and Deploying packages to SQL server and Scheduling Packages

for Intra Day and End of Day execution.

> As per requirements developing the reports in the form of Matrix,

Table and Chart using SQL Server 2008 Reporting Services.

> Designing Different Types of reports like Drill Down, Drill Through,

Sub Reports and Parameterized Reports.

> Development of reports using different SSRS Functionalities like sort

prompts and cascading parameters, Multi Value Parameters.

> Good knowledge in using report manager and giving security according

to roles hierarchy.

> Developing Report Models and Ad Hoc Reports using Report Builder.

> Scheduling Reports Weekly and Monthly basis as per the Client

Requirements.

Project #2

Title : Business Financial Services

Client : Weatherbys Bank Ltd, UK

Role : ETL Developer

Technology : SSIS, SSRS, SQL Server 2008

Duration : July 2012 to July 2013.

Description:

Weatherbys Bank Limited is a member of the Financial

Services Compensation Scheme.

The genuinely personal service we offer every one of our clients helps set

us apart from many of our competitors. The data ware house maintenance the

client information like customer profile, credit grade, banking location

and the details about which programs the client has been enrolled.

Performing regular data loads and data validation, production support and

monitoring the load activities. Resolving the defect tickets and designing

data marts for business. So the Bank wanted a Single Window Business

Intelligence Application for Bank's operational Efficiency. This project is

to provide different reports for making intelligent decision on data

available in various branches across the worldwide connected over a period

of time.

Responsibilities:

> Involved and understanding the requirements at KT sessions.

> Involved in developing ETL for loading data into Database.

> Created Packages on SSIS by using different data Transformations like

Derived Column, Conditional Split, Pivot, Multicast, Sort and Execute

SQL Task to load data into data warehouse.

> Identified and tracked the slowly changing dimensions.

> Involved in performance tuning.

> Generated the Drilldown Reports.

> Generated the Drill through reports.

> As per the requirements developed the reports in the form of Matrix,

Table and Chart Using SQL Server 2008 Reporting Services.

> Generated the Reports weekly, monthly, Quarterly and yearly basis as

per the client requirements.

Project #3:

Title : Health Care

Client : Sun Pharma, Mumbai

Role : ETL Developer

Environment : SSIS, SSRS, SQL Server 2008

Duration : May 2011- June 2012

Description: The sixth healthcare company in the top 10 list is Sun Pharma.

The core business of the company is Pharmaceuticals and making drugs. This

project is to automate the transactions of the Hospital Management System.

This project contains Patient care administration, Patient care services,

financial management system and Administrative service. Patient care

administration is the main module. In patient care administration, by

physician order, the patient is registered and further process is done. In

patient care service by physician order, we can give the clinical services

to the patient. In the financial management module contains patient bill

preparation payroll and vendor payments. Administrative Service module

contains scheduling of doctors, nurse, wards, and Inventory system.

Responsibilities:

> Involved in understanding the requirements and KT sessions.

> Created Packages on SSIS by using different data Transformations like

Derived Column, Conditional Split, Pivot, Multicast, Sort and Execute

SQL Task to load data into data warehouse.

> Developed of SSIS packages, which retrieve data from various sources

and used data transformations

> Created transformations and mappings using data flow tasks.

> Identified and tracked the slowly changing dimensions.

> Loaded data into fact and dimension tables by creating SSIS packages.

> Scheduled Jobs to execute SSIS packages.

> Generated the Drilldown Reports.

> Generated the Drill through reports.

> As per client requirements generate the reports in the form of Matrix,

Charts.

> Unit tested the packages.

Contact this candidate