Sql Server Plant

Divya Gutta

Email:**********@*****.***

Tel: 682-***-****

Summary

• 2 years of experience as Database developer using SQL Server 2005\2008\2008 R2.

• Experience in MS SQL Server with Business Intelligence in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).

• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005/2008.

• Experience in Stored Procedure, TSQL coding, Performance Tuning and Query Optimization.

• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional expression (MDX) to access them.

• Created reports using SSRS 2008.

• Created SSIS packages to accomplish ETL/Migration tasks

• Ability and willingness learn new technologies and processes.

• Ability to work independently as well as in a team oriented environment.

Tools & Technologies:

MS SQL Server 2005/2008/2008 R2, SSAS, SSRS, SSIS, T-SQL, MS SQL Query Analyzer, BIDS.

Work Experience

SQL\BI Developer

Metric-X - Perrysburg, OH (July 2010 to May 2012)

• Configured SQL Server Reporting Services (SQL SERVER 2008\2008 R2) on the development server.

• Generated various types of reports (Graphical Reports, Tabular Reports, Parameterized Reports) using SQL Server Business Intelligence development studio, Dundas charts and SSRS.

• Involved in gathering the report specifications by interacting with the business users.

• Identified the database tables and stored procedures for defining the queries for the reports.

• Created SQL scripts for ad hoc reports.

• Created Views, User defined functions and Triggers using T-SQL.

• Created stored procedures encapsulating the business logic at the database level using T- SQL.

• Created stored procedures to create reports.

• Created SSIS packages to load data from various formats of files into SQL Server database.

I was involved in the following applications.

TOCIS (Theory of Constraints Information system).

This application was created for better visualization of the status of the manufacturing plant. This application shows a high level picture of the plant floor with some key performance indicators like throughput, scrap and efficiency.

CIC (Coater information console).

This application was created for the production floor supervisors. This application shows a near real time view of how the coaters and ovens are running in the plant. This tool helped them a lot to improve the performance of the plant.

Plant View.

This is a web portal created for the O& M team. This application shows a near real time view of solar power plants and their performance. This application shows the amount of power generated by the power plants, status of the inverters and transducers.

All the applications used SQL server 2008\2008R2 as the database server.

EDUCATION

Cleveland State University, Cleveland, Ohio May 2009

Master of Science in Computer and Information Sciences

Avinashilingam University, India May 2005

Bachelor of Technology in Information Technology

Contact this candidate