Sql Server Manager

DEEPESH DHAKE

*** **********, ***# ****, *******, Texas 77058

Phone no: 732-***-****; Email: ************@*****.***

SUMMARY

• Solid understanding in Database Programming (SQL, PL/SQL), Data Analysis in Oracle, & MS Access. Thorough experience in extracting data from Oracle.

• Good knowledge of RDMS concepts and strong technical skills in logical/physical database design and performance tuning.

• Strong knowledge in Normalizing and De-normalizing the tables.

• Proficiency with SQL Server in creating databases, tables and PL/SQL in writing complex queries and store procedures, relational database models, data dictionaries, and data integrity.

• Oracle certified programmer.

• Good knowledge of performance tuning using Hints and Index.

• Knowledge of taking and backups and recovery of the database.

• Good knowledge of Microsoft Business Intelligence tools.

• Understanding with all phases of SDLC including Collection of Data from Raw data files such as Excel spreadsheets and External RDBMS tables, Modifying and Analysis, Coding Statistical Models, Summarizing and Presenting Results.

• Profound knowledge in developing Web applications, Client-Server technology using C# .NET, ASP.NET, VB.NET, .Net Framework with strong software engineering practices.

• Ability to rapidly learn new concepts together with excellent interpersonal skills.

EDUCATION:

Master of Science in Management Information Systems May 2012 GPA 3.553

University of Houston, TX

Bachelors of Engineering in Information Technology May 2009

Fr. Conceicao Rodrigues College of Engineering – Mumbai, India

Bachelor of Science and Masters of Science course work includes: HTML, Structured Query Language, PL/SQL, Object Oriented Programming, Data Structures, C#.net, Data Warehouse and Data Mining concepts, C, C++, Advanced Database concepts (procedures, functions, triggers,managing users), OLAP servers, Oracle DBA concepts(architecture of an Oracle database, installing Oracle database management system, creating a database, creating and managing database users and roles, database backup and recovery, database performance tuning and database administration)

CERTIFICATIONS:

• (MCTS):Microsoft .Net Framework 3.5 – Windows Based Client Development. (C#.Net)

• OCA: Oracle PL/SQL Developer Certified Associate.(SQL, PL/SQL)

COMPUTER SKILLS:

• Programming Languages: C/C++, C#.net, VB.net, Visual Basic

• Databases: ORACLE 9i, Oracle 10g, Oracle 11g, SQL Server 2008

• Database Technologies: Oracle SQL, Oracle PL/SQL, SQL Server 2008 Integration Services, Reporting Services, Analysis Services, Transact SQL

• Software: SQL Server Management Studio, Microsoft Visio, Microsoft Office, SQL Server Business Intelligence Studio

• Web Technologies: HTML, CSS, ASP.net

• Methodologies: SDLC, Software Engineering, Object- Oriented Design & Programming

• Operating Systems: Microsoft Windows 7/98/2000/XP/Vista

WORK EXPERIENCE:

Teaching Assistant in ‘Oracle Database Administration’ at University of Houston Clear Lake(August 2010-May 2012).

Responsibilities included explaining architecture of an Oracle database, installing Oracle database management system, creating a database, creating and managing database users and roles, database backup and recovery, database performance tuning and database administration. My role in the job includes helping professor and other students for performing the above tasks.

TECHNICAL PROJECT:

Project Title : Banking Products(August 2011-December 2011)

RDBMS : SQL Server 2008

Technologies : SQL Server Analysis Services

• This data warehouse helps manager to find out the details about the customer, products and branches of the bank.

• This data warehouse keeps all the details of the transaction made by the customers so that manager can make decision on providing loan and insurance to the customer.

• This data warehouse also keeps track of the saving accounts and checking accounts of each customer.

• For this, OLAP cube is created to display information according to the manager. Some of the findings are:

Top 100 customers depending upon the profit.

Most profitable customer, branch and product.

Top 10 customers in specific branch.

• We used SQL Server Business Intelligence Studio to develop the cubes.

Project Title : Gulf Coast Fitness Centers(January 2012-May 2012)

RDBMS : SQL Server 2008

Technologies : C#.net, UML, Visual Studio 2010, .Net Framework 4.0, SQL Server Reporting Services, Transact SQL

This system includes four modules: payroll application, training application, employees application and invoice application.

Roles and responsibilities:

• Involved in Database Design.

• Communicating with other database team members to build the database.

• Involved in writing stored procedures to get data from database.

• Involved in generating reports using SQL Server Reporting Services.

• Implemented error handling with exceptions.

• Involved in Unit testing, module testing.

References available upon request

Contact this candidate