SUMMARY

• Over 7 years of work experience in Database Design and Development on SQL server 2000/2005/2008 in OLTP/OLAP environment.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Developed Reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Good Experience in using ETL Toolssuch asData Transformation Services (DTS) / SQL Server Integration Services (SSIS).
• In - depth Knowledge of Transact SQL (DDL, DML).
• Excellent knowledge in RDBMS concepts and constructs along with Objects creation such as Tables, Table Normalization, User Defined Data Types, Indexes, Stored Procedures, Cursors and Triggers.
• Good knowledge in Oracle, My Sql, Sybase, DB2 UDB and Access databases.
• Extensive experience in MS SQL Server 2005/2008 with Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) of 2005/2008.
• Proficient in extracting and transforming data using tools like DTS Packages, Import Export data, Bulk Insert, and BCP.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Comprehensively use tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Highly skilled in implementing various types of Replication models (Snapshot, Merge and Transactional) along with Backup/Restore of a database.
• Expertise in generating reports using XML, Crystal Reports, SQL Server Reporting Services and Excel spreadsheet.
• Experience in web technologies like ASP.NET, ADO.NET, VB.NET, C#. NET, XML, ASP, ADO.
• Good experience with OLAP tools, building complex cubes for business analysis using SQL Server Analysis Services (SSAS).
• Good knowledge on Data Modeling Tool like Erwin and MS-Visio.
• Strong inclination for finishing job before project deadline.

TECHNICAL SKILLS

Relational Databases: SQL Server 2000/2005/2008 , Oracle 8i/9i, My Sql, MS Access.

Database Tools: SQL Enterprise Manager, SQL Server Management Studio, Query Analyzer, SQL Profiler, Query Analyzer, RMAN, Sybase, DB2.

Languages: C, C++, .Net, C#, VB, VB.Net, Java.

ETL Tools: Data Transformation Services (DTS), Sql Server Integration Services, Import Export Data, Bulk Insert, BCP, ODBC.

Reporting Tools: Crystal Reports, SQL Server Reporting Services, XML, MS Excel.

Methodologies: Object-Oriented programming, Optimization, Client/server Distributed systems, Project management.

Web Technologies: XML, HTML, DHTML, CSS, ASP, WSDL, SOAP, UDDI, Java, javascript, Web Services.

Design Tools: UML,ERWIN, Object Oriented Analysis and Design, JEE Design and EJB design patterns.

Operating Systems: Windows 95/98/2000/2003/2008/ NT/XP, MS-DOS, UNIX, Linux.

Application Servers: IIS, Web Sphere, Web logic, JBoss.

Source Control: TFS, VSS, PVCS, Clear case.

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL Developer

Responsibilities:

• Created and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Involved in writing stored procedures, triggers in TSQL.
• Involved in database partioning - Partitioning of the tables depends on the partition range.
• Converted various SQL Statements into stored procedures thereby reducing the number of database accesses.
• Creating Sub-Queries and Joins for complex queries involving multiple tables.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Develop/deploy and manage several detail and summary according to business requirements using SQL Server Reporting Services (SSRS) and report manager.
• Used SQL Server profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Performed Database Unit Testing for Stored Procedures, Triggers, Views, and Functions.
• Created functions for calculation purposes. creating, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS).
• Scheduled Jobs and Alerts using SQL Server Agent.
• Involved in performance tuning reporting services - Move the Reporting Services and databases to a different server.
• Extract, Transform, and Load data from MS Access, MS Excel data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.

Environment: SQL SERVER 2005/2008, QC, Team Foundation Server (TFS),Windows 2000, MS Access, MS Excel, T-SQL, ERWIN.

Confidential, CA

SQL Developer

Responsibilities:

• Developed ER diagrams (Physical and Logical using ERWIN) and mapping the data into database objects.
• Create Databases Objects such as Tables, Indexes, Views, Triggers and Stored Procedures.
• Developed stored procedures to convert data logically as per the business requirement.
• Involved in writing the SQL queries, stored procedures using T-SQL to optimize the performance of databases.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures.
• Migration of SQL Server 2000 databases to SQL Server 2005 using Migration Wizard.
• Developed SQL Packages, Procedures, Functions, SQL Scripts, and Database Triggers to populate the historic data in the tables applying business logic.
• SQL Tuned queries by creation of Indexes, Rebuilding Indexes.
• Created Constraints and Triggers to implement Business Logics.
• Designed and deployed various reports using SQL Server Reporting Services (SSRS).
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created and scheduled SSIS packages which monitors the jobs and sends the notification when the job fails.
• Involved in backup and recovery database procedures.
• Created Jobs SQL Mail Agent Alerts and Schedule SSIS Packages.
• Created database with multiple file systems.
• Backing up databases and restoring them when necessary.

Environment: SQL Server 2000/2005, Windows 2000, MS Access 2003, MS Visual, XML, T-SQL, Rational Clear Quest/Clear Case.

Confidential, KY

SQL Developer

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement.
• Create Databases Objects such as Tables, Indexes, Views, Triggers and Stored Procedures.
• Developed and tested complex Transact SQL on MS SQL Server.
• Created database objects such as tables, indexes, stored procedures, functions, and triggers.
• Designed, developed, and tested stored procedures, views and complex queries.
• Developed database triggers and stored procedures using SQL cursors and tables.
• Managed all indexing, debugging, optimization and performance tuning using Profiler and SQL Server Agent.
• Designed and developed Data Transformation Process.
• Created user defined functions for calculation purposes.
• Use Bulk Insert to copy databases from one development server to another server with minimal log space and time.
• Created Constraints and Triggers to implement Business Logics.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by DTS Packages.
• Worked with BCP and DTS to load text files to SQL Server as well as maintained the database backups and restoration, backup strategies, scheduling backups.
• Configured SQL mail agent for sending automatic emails when a DTS process is failed or succeed.
• Developed several Complex Reports (daily, weekly, monthly, quarterly and yearly) using Crystal Report 8.0.

Environment: MS SQL 2000, ASP, VB, XML, DTS, MS Analysis Services, Crystal Reports 8.0.

Confidential, NY

SQL Developer

Responsibilities:

• Installed and Configured SQL Server 2000 successfully.
• Create Databases Objects such as Tables, Indexes, Views, Triggers and Stored Procedures.
• Involved in ER diagrams (logical design) and mapping the data into database objects.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Use Bulk Insert to copy databases from one development server to another server with minimal log space and time.
• Created Constraints and Triggers to implement Business Logics.
• Created and populated summary tables based on the existing data in the reference tables from different databasesaccording to the client requirements.
• Extensively worked on stored procedures to select the data from different databases for each and every summary table to be populated, perform calculations for the numeric fields and to extract the values based on theclient requirement.
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Worked closely on database tuning, performance planning, backup planning and database administration.
• Capacity planning in estimating and sizing of tables.
• Configured Merge Replication using Snapshot agent and Merge Agent (Created Distribution Databases, updated Publishers, created and managed Publications, managed Replication monitors).
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used Crystal Reports and MS Access to write complex formulas and to query the database to generate different types of ad-hoc reports.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Enterprise manager, VBS, Crystal Reports, MS- Office & Windows 2000.

Confidential, CO

SQL Server Developer

Responsibilities:

• Actively involved in gathering User Requirement and Online System Specification.
• Developed ER diagrams and mapping the data into database objects as well as scheduled jobs for backup, and created alert for error reporting.
• Taking backup of the database on a periodic basis and checking the validity of the backup by restoring on a separate PC.
• Checking database performance on a regular interval, which includes checking various log files.
• Addition of users, objects etc as and when required and granting proper privileges for Database access.
• Developed sql scripts for backend processes.
• Importing of dumps using impdp/expdp utilities.
• Loading bulk data from flat files using sql*loader.
• Participated in different testing and debugging of the system.
• RMAN backup. Before RMAN, it was done by export/import.
• Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.

Environment: Oracle, sql*plus, sql*loader, RMAN, VBS, MS Office & Windows 2000.

Confidential

Software Developer

Responsibilities:

• Designed and Developed Web based UI using ASP.NET
• Designed & Developed ASP.NET User Controls
• Used Data Grids for displaying and editing data
• Used ADO.NET for SQL server interactions using SQL Data Adapters, Data Readers and Datasets
• Designing and developing of ASPX pages using Visual Studio. NET, C#, VB.NET, JavaScript and HTML, DHTML.
• Involved in writing SQL stored procedures and queries for obtaining results
• Used web.config for storing database connection string
• Involved in page-level and application-level tracing.
• Worked extensively with Web Forms, Server (Web/HTML) and Data Binding controls
• Used C# in creating classes for this application.
• Integrated Crystal Reports with ASP.NET and C#
• The client application is written in C# and uses .NET remoting to interact with the server application
• Developed COM Components to reuse in different modules in C#
• Was responsible for writing a number of sophisticated Data Transformation Services (DTS) in SQL and VBScript in SQL Server
• Successfully integrated data from data sources using ADO.Net and Remoting.

Environment: ASP.NET, C#, SQL Server 2000, .NET Framework, HTML, COM, Crystal Reports, XML, ADO. Net, .Net Remoting.