Sql Server Engineer
Resume:
RAJU KAUDAGANI
E-mail: *******@*****.***
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