Professional Synopsis

• Dynamic Professional with 7 years of experience in Project Design, Analysis, Development & Management using Microsoft SQL 2000 and 2005

• Experience in Installing, Upgrading, Migrating and, Configuring of Microsoft SQL Server 2000/2005/2008
• Proficient in designing Relational Database Model and implementing as per business requirement
• Have Extensive Experience in creating Tables, Stored Procedures (dynamic and static) using SQL, T-SQL( DDL, DML, DCL)
• Excellent Experience in creating Views, User Defined Functions, and Triggers to facilitate efficient data manipulation and data consistency
• Excellent in creating Indexes and Indexed Views for Database Optimization and Performance

• Experience in Data Migration from MS SQL Server 2000 to MS SQL Server 2005
• Hands on experience on Extraction Transformation and Loading (ETL) processes using tools like SSIS, DTS, BCP between different homogeneous/heterogeneous systems and SQL Server and implemented Incremental load in SSIS packages
• Expert in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.
• Experienced in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports, and for the end user requirement Ad Hoc Reports using SQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS).
• Have Good Experience in Developing Parameterized reports, Drill-down reports, Drill-through reports
• Having good knowledge in developing OLAP Cubes using SQL server Analysis services (SSAS) through MDX queries
• Involved in Maintaining Database with Backup, Restore Strategies and Scheduling those backups using SSIS packages as a Developer.
• Expert in Scheduling Jobs and Alerts using SQL Server Integration Services
• Knowledge in SQL Server Clustering, Replication, Data Mirroring, Space Management, Linked Servers and Log Shipping
• Involved in Query Optimization and Performance Tuning Using SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor and Database Consistency Checks using DBCC.
• Experience in logical, physical, and dimensional Data Modeling, data mapping, and data Normalization, well verse in ERWIN
• Involved in creating Logins, Roles, Managed security and permissions on different databases
• Good Knowledge of SQL Server 2008
• Involved in Visual Studio.NET 2005, .NET 2.0, C#, ASP.NET, ADO.NET, XML, Designing Web Pages, and Web Services

Certifications

• MCTS: Earned Microsoft Certified Professional Certification on “Microsoft - SQL Server 2005-Implementation and Maintenance”

Technical skill Sets

RDBMS

MS SQL Server 2000/2005/2008, MS-Access1997/2000, Oracle

MICROSOFT Technologies

SSIS, SSRS, DTS, SSAS, SQL Enterprise Manager, SQL Management Studio, SQL Server Business Intelligence Tools, .net

Programming Language

SQL,T-SQL,PL-SQL, C, C++, C#, Java, j2ee, Oracle9i

Operating Systems

Win 9x/NT/2000/XP/Vista ,MS-DOS, UNIX, Windows 2003 server

Scripting Language

VB Script, Java Script

Web Technologies

ASP.NET, VB.NET, ASP , HTML, DHTML, XML, XHTML, CSS

PROFESSIONAL EXPERIENCE

Confidential,Houston, TX Apr 07 - Present
Role : MS SQL Server Developer/DBA

Project Description:
Spectra Energy is one of North America’s leading providers of natural gas infrastructure, the company connects growing markets with supply, customers with solutions and communities with a caring, responsible corporate owing partner.

Monitoring and Analysis
The Project was for internal use to monitor how the employees are going through training. Their usages were monitored for employees to analyze project’s goals and evaluate possible solutions to improve business to succeed.

Responsibilities:

• Actively participated in Gathering User Requirement and Functional Specification
• Created SQL server objects like Indexes, Indexed Views, Stored Procedures (dynamic and static), effective Functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency
• Created Joins, Sub-Queries, Views and User Defined Functions for complex queries involving multiple tables and developed User Defined Functions
• Migrated DTS Packages of SQL Server 2000 to SQL Server 2005 and as well SQL Server 2008 as per Business requirements

• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data to data warehouse databases and involved in Data cleansing in the data transfer
• Implemented Data Cleaning, Incremental Data Loading, Event Handling and Error Handling
• Developed Query for generating Drill Down and Drill Through reports in SSRS 2005/2008

• Generated Tabular, Sub reports and Parameterized reports for the Business users
• Involved in Analyzing, designing, building &, testing of OLAP Cubes using SQL server Analysis services (SSAS) through MDX queries
• Involved in Performance Tuning to improve response time of Stored Procedures
• Maintained Database Backups and Scheduled Jobs and Alerts involving with Administrator

• Managed Logins, Roles, security and permission on different database objects with help of Database Administrator
• Involved with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases
• Developed the ASP .NET Web Controls to support the Front-end of the application and implemented business logic using Code behind files in C#
• Implemented input validation using the ASP.NET Validation Controls
• Used AJAX to trade data with a web server, without reloading the page

Environment: MS SQL Server 2005/2000/7.0, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server BIDS, MS- Visual Studio 2005, Asp.net, C#.net, ADO.net, XML, Oracle 10g

Confidential,Albuquerque, NM Jan 06 – Mar 07
Role : MS SQL Server Developer/DBA

Project Description:
State of New Mexico Department of Health provides health policy, prevent disease and disability, improve health services systems and assure that essential public health functions and safety net services are available for people.

Responsibilities:

• Actively Discussed Requirements from Business Analyst and Developed documents based on functional specification.
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
• Created appropriate Triggers to assist efficient data manipulation and data consistency
• Migrated DTS Packages of SQL Server 2000 to SQL Server 2005 as per business requirement
• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS) worked with users
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading
• Implemented Error Logging using Event Handlers and also implemented batch logging
• Created dynamic Package Configuration
• Developed Query for generating Drill Down and Drill Through Reports in SSRS 2005
• Generated and formatted Reports using Parameters and Expressions for the Reports. Designed and Implemented stylish report layouts
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 Identified and defined Fact relationships in SSAS
• Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases

• Involved in Optimization and Performance of queries and Used DBCC command to free SQL cache memory
• Managed Logins, Roles, security and permission on different database objects with help of Database Administrator
• Involved with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases

Environment: SQL Server 2005, MS Server Integration services, SSRS (MS server Reporting Services),Oracle9i/10g, Window XP/2003 Server, Crystal Reports, VB.net.

Confidential,Houston, TX Sep 04 – Dec 05
Role: MS SQL Server Developer

Project Description:
Finance Online Service is a web-based management application used by Stanford advisers in supporting the clients and their financial needs. An adviser uses this tool to access the client’s data and analyze their holdings and use the results to engage in a dialogue with the client about their wealth. Clients access their account information, analyze their wealth, download research reports, and read informative articles all at their convenience. Both advisers and clients view the account data simultaneously, run various analytical scenarios and view the results together online, and correspond via a secure e-mail system.

Responsibilities:

• Participated in Gathering Business Requirements and System Specification from users.
• Successfully implemented physical database on MS SQL Server 2000. Supported complex relationship using Triggers
• Facilitated simplified access of database for end users using Denormalized views and created Triggers on them to maintain to database integrity
• Used T-SQL to create queries and Stored Procedures to produce reports for end-users
• Developed User Defined Functions and created Views

• Implemented Exception Handling using @@Error
• Migrated DTS Packages of SQL Server 2000 to SQL Server 2005

• Import/Export using MS Access, Excel and Text file to/from SQL Server
• Developed a few reports using SQL Reporting Services (SSRS)
• Created Ad-Hoc reports for business users using SSRS

• Involved in creating multiply level Cascading Prompt for both static and dynamic parameter
• Troubleshoot SQL Server performance issues for internal and external customers
• Monitored and Tuned Databases, Indexes, Stored Procedures and Server Performance using Performance monitoring tools for MS SQL Server 2000 with the help of Administrator
• Participated in the Design, Creation and Maintenance of SQL Server database
• Involved in implementation, maintenance, and monitoring Database Back-ups, Database Space Management, Error Log monitoring, patch application, etc
• Involved in Optimization and Performance of queries and Used DBCC command to free SQL cache memory

Environment: SQL Server 2000, T-SQL, VB 6.0, DTS, SSRS, XML, Visual Source Safe, MS Office, Windows 2000.

Confidential,Chicago, IL Mar 04 - Aug 04
Role: MS SQL Server Developer

Project Description:
Involved as a SQL Server 2000 database developer with significant responsibilities such as requirement are analysis, design, document, and development of the Amoco POS application. This application is a powerful, reliable point-of-sale application that helps streamline retail operations in an on demand world.

Responsibilities:

• Worked as a Developer on Databases like MS SQL Server 2000, MS Access (using DTS, T-SQL, scripts, stored procedures and views)
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project
• Managed requests that came from the client as well as the development teams
• Involved in Design and Developed the Logical and Physical Model of the database
• Worked as a Developer in creating Complex Stored Procedures, and other SQL Joins and statements for applications
• Developed complex T-SQL code for the application
• Developed User Defined Functions and created Views

• Created Triggers to maintained the referential integrity
• Implemented Exceptional Handling
• Generated reports using MS Reporting Services
• Generated various charts like Pie Charts and Line Charts for easy analysis of the reports

• Worked on Complex Data Loading (implemented the batch data cleansing and data loading)
• Creating and automating the regular Jobs

• Rebuilding Indexes and Tables as part of performance tuning exercise

• Managed the Backup and Recovery of the team

Environment: SQLServer2000/MSDE, MS Access, Query Analyzer, DTS, BCP, MS Access, Load Runner, QTP and Win Runner, SQL Profiler, Import & Export Data, Windows 2003 Server.

Confidential,Mechanicsville, VA Feb 03- Jan 04
Role : MS SQL Server Developer

Project Description:
Actively participated and worked as a developer on analysis, design, and development of Owens and Minor Warehouse Management System (WMS). Gain powerful, real-time control over inbound and inventory management processes with Owens and Minor WMS module. This module offers robust, flexible, real-time warehouse management functionality and provides complete control over all aspects of the inbound and materials management of side of warehouse operations. This includes location management, receiving, quality checking, put away operations and inventory control.

Responsibilities:

• As a part of 3-member team, was involved in design, development and testing and implementation of the Data Marts on the Owens and Minor data and Financials data
• Involved in Design, Development and Testing of the Database
• Developed SQL Server Stored Procedures
• Developed User Defined Functions and created Views

• Created Triggers to maintained the referential integrity
• Implemented Exceptional Handling
• Developed detailed reports using Microsoft SQL Server Reporting Service
• Active interaction with the clients to analyze the enhancements and changes required
• Used DTS to generate periodic reports in Microsoft Excel for the purpose of analysis and to keep as a record by the clients
• Creating and automating the regular jobs
• Worked on Complex Data Loading (implemented the batch data cleansing and data loading)

• Rebuilding Indexes and Tables as part of performance tuning exercise

• Managed the Backup and Recovery of the team

Environment: SQL Server 2000, Query Analyzer, MS DTS, MS SQL Server Agent, Index Tuning Wizard, Microsoft Analysis Services, BCP, Cognos Suite of tools, and Windows NT/2000

Confidential,Hyderabad, India Mar 02-Nov 02
Role : MS SQL Server Developer

Project Description:
This project was for the Automobile Finance division of a leading bank. The department in the company provides customers with loan solutions to pay for and manage the cost of automobile. Customer-centric data base was build to analyze transactions across finance, marketing, risk, collections, and consumer relations was developed.

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept
• Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes and Execution Plan)
• Developed User Defined Functions and created Views

• Created Triggers to maintained the Referential Integrity
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment: SQL Server 7.0/2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5,ASP/VB.NET

Qualification

• Bachelor of Engineering, Confidential,University, India