RAJU KAUDAGANI

E-mail: acpwdy@r.postjobfree.com

# 818-***-****

SUMMARY

> 3.6 years of experience in MSBI and rest of the experience in SQL

Server.

> Experience with tools like SSMS and SQL Server 2008, SSIS and SSRS.

> Proficient in Relational Database Management Systems (RDBMS).

> Excellent backend skills in creating SQL objects like Tables,

Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user

defined data types and functions.

> Good experience in creating Drill down, Drill through, Matrix,

Tabular, Dash board and Sub reports.

> Designed SSIS Packages to extract, load data into database, archive

data file from different legacy systems using SSMS on 2008

environment

> Knowledge in tuning at various levels like Source, Destination and

Transformations.

> Good Experience in Implementing Checkpoint, Transactions, and

logging for packages

> Having knowledge in Dimensional Data Modeling, Cube development and

manipulations in SQL Server Analysis Services (SSAS).

> Work involvement in performance monitoring of Memory, Processor,

Disk I/O and fine tuning.

> Developed, deployed and monitored SSIS Packages for new ETL

Processes and upgraded the existing DTS packages to SSIS for the on-

going ETL Processes.

> Monitored Full/Incremental/Daily Loads and support all scheduled

ETL jobs for batch processing.

> Experience in deploying SSRS reports on the portal for user

accessibility.

> Proficient in Tuning T-SQL queries to improve the database

performance and availability.

SKILL SET

ETL Tools : SSIS

Analysis Service : SSAS

Reporting Tools : SSRS

RDBMS : MS SQL Server 2008

Programming Languages : SQL

Operating System : Windows 7, Win XP.

EDUCATIONAL QUALIFICATION:

> Bachelor of Science (M.p.c) from Kakatiya University (May 2007).

PROFESSIONAL EXPERIENCE:

Working as Software Engineer in DATABOT SYSTEMS PVT LTD from Jan

2012 to till date.

TECHNICAL PROFILE:

Project #2 : Reinsurance Claims Database (RCD)

Client : Word and Brown- Orange, California

Role : Software Engineer

Duration : June 2013 to till date

Environment : WinXP, SQL server 2008R2, SSIS, SSRS and share point.

Description:

RCD application is used to perform invoicing adjustment for

Zurich customers, which participate in their Retrospective Rating program.

This project is separated into several work streams. They include Account

Management, Account Setup, Loss Information, Adjustment Calculation,

Invoice Distribution, Revision and Void, Reporting, and Data Conversion.

Each of these work streams define an area of the application.

Responsibilities:

> Creating packages using SQL Server Integration Services.

> Generating reports using SSRS from SQL Server Database OLTP and OLAP.

> Deployed and generated reports on to the server using the Reporting

Services Manager.

> Developed fully customizable and personalizable BI web application

based SSRS, SSIS to be used by all levels of management to monitor

and reports and company related information including.

> Design and drill-through and drill-down enterprise reports.

> Designed and Developed interactive executive dashboards.

> Indexes, views, stored procedures; triggers are used using the SQL

Server.

Project #1 : Production Scheduler (PS)

Client : Zurich, North America

Role : Software Developer

Duration : Jan 2012 to May 2013.

Environment : Win XP, SQL server 2008, SSIS

Description:

Production Scheduler is designed to provide optimization-based scheduling,

shop-floor synchronization, reactive re-scheduling, and complete reporting

and analytics. Production Scheduler is a configurable scheduling

application that produces detailed schedules for multi-stage manufacturing

processes.

Responsibilities:

> Enhancements to the PS client and Server components, and also Customer

issue fixes.

> Designed and Developed real-time enterprise dashboards for business

performance monitor.

> Indexes, views, stored procedures; triggers are used using the SQL

Server.

> Done Unit, integration testing and functional testing.

> Involved in the maintenance and support operations.

> Used to write Stored Procedures, Functions, Triggers, Indexes, joins

and Views by using T- SQL to improve Performance.

> Migrate data from SQL server to text file using SSIS.

Contact this candidate