Summary

• 7 years of Professional Experience in Development, Testing and Support of Microsoft SQL Server 2008/2005/2000 on various business domains like Financial, health care manufacturing.
• Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server 2008/2005/2000
• Experience using ETL Tools in (SSIS), MS SQL Server 2005 and DTS, MS SQL Server 2000.
• Hands on experience in database development using Stored Procedures, Cursors, Indexes, Views, Triggers (DDL, DML) and User-Defined Functions to facilitate efficient data manipulation and data consistency.
• Experience in BI Tools (Reporting Services, Integration Services and Analysis services)
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Ad Hoc Reports, OLAP, Sub reports and formatting them using both SSRS 2005/2008.
• Hands on experience in designing Crystal Reports.
• Experience with logical and physical DATA Modeling, Normalization and building Referential Integrity Constraints.
• Experience in Tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in Query Optimization and Performance Tuning.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Extensively worked on Data extraction using the Microsoft DTS and SSIS.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in migrating DTS packages, reports and analysis services projects from SQL server 2000 to SQL server 2005.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SQL Server Integration Services (SSIS), BCP and DTS utility. Extracting, Transforming and loading of data using SSIS and DTS.
• Experience in creating MDX Cubes and Dimensions in SSAS.
• Created stored procedures for generating reports using SQL Server Reporting Services (SSRS).
• Expert in creating Parameterized Reports, Drill Down and Matrix Reports.
• Good Knowledge on SQL LiteSpeed a Back Up and Restore solution for MS SQL Server.
• Good team player with strong analytical skills.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Expertise in using data modeling tools like SQL Diagrams, Erwin.
• Experience in creating Packages, Jobs, and Sending Alerts using SQL Mail.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

Technical skills:

• Web Technologies: ASP.NET 3.5, Windows Forms, ASP, HTML, DHTML, XML, XSL, XSLT, ADO, ADO.NET, CSS, .NET Framework.
• Languages: C, PHP, VB,T-SQL,PL/SQL
• Database: MS SQLServer 2008/2005/2000, MS Access 2007/2000, SSIS,SSRS,SSAS
• Web Page Editors: Visual Studio.NET, Dreamweaver, Adobe Photoshop.
• Reporting tools: MSSQL Server 2005 Reporting Services (SSRS), Crystal Reports 8.0, Excel 2007
• Operating Systems: Windows 98/NT 4.0/2000/XP/, Windows server2003,Windows 7
• Web Servers: IIS 5.0, IIS 6.0, MS Share Point Portal
• ETL tools: Data Transformation Services(DTS), SQL Server Integration Services(SSIS)
• Third Party Tools: SQL LiteSpeed, Erwin,Redgate,Visual Source safe

Education:

Certifications:

• Microsoft Certified SQL Server 2008 Business Intelligence - Implementation & Maintenance.

Professional Experience:

Confidential, Fremont CA June'10 - Till Date
ROLE: Sr.SQL Server BI Developer (SSIS, SSAS)

Responsibilities:

• Installation and configuration of SQL Server (SSRS, SSIS, SSAS) 2005/2008.
• Worked in new interface to import the data from Oracle source with number of transformations.
• Involved in PL/SQL to Migrate the Data by using Oracle10.g.
• Designed, the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Involved in developing cubes with various Perspectives and deployed those cubes in development, integration, validation and production servers of SSAS.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Wrote complex MDX queries for calculated members and measure groups.
• Involved in building Reports on Analysis Services cubes.
• Involved in Data Migration from SQL Server 2005 to SQL Server 2008.
• Scheduled a daily job to move data from hold tables to base tables of AWT 3.0 database on development server.
• Schedule and Monitor SQL server Agent Jobs to migrate the data daily basis.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Involved in creating complex SSIS packages using proper control and data flow elements with error handling.
• Involved in moving the data from heterogeneous data sources like oracle, xml, etc to SQL Server using SSIS.
• Used various data transformations like fuzzy lookup, derived column transformation etc while creating SSIS packages.
• Enhanced and deployed the SSIS Packages from development server to production server.
• Played a major role in the production support of SSAS cubes and SSIS jobs.
• Involved in migrating SSIS packages from SQL 2005 to SQL 2008.

Environment:
SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, XML, DTS,MS PowerPoint, MS Project, DB2, MS Access 2003 & Windows Server 2003.

Confidential, Mountain view, CA Aug'09 - Apr'10
ROLE: Sr. SQL Developer/DBA

Responsibilities:

• Analyzed the requirements and selected the appropriate fact tables/created fact tables
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
• Created the storage type (ROLAP), Created cubes for Business Intelligence.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Experience in building and maintaining Data marts. Created roles for using the cubes.
• Wrote DTS packages to transfer data from heterogeneous database(Oracle,DB2,Access) & different files format (Text File, Spread Sheet, XML file) to SQL Server.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages.
• Transferring data between XML document and SQL server
• Performed activities such as database creation, database tuning, performance planning, backup planning and database administration.
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise.

Environment:
SQL Server 2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, ERwin, XML, VB.NET, SharePoint Server 2007, MS PowerPoint, MS Project, MS Access 2000 & Windows Server 2003.

Confidential Minneapolis, MN Jun'08-Jul'09
Role: Sr. SQL Server developer

Responsibilities:

• Actively involved in the complete software development life cycle for a design of database for new Financial Accounting System.
• Converted logical database design into Physical Schema using either 2nd or 3rd Normalization to obtain highest performance.
• Successfully implemented the physical design of the new designed database into MSSQL Server 2005.
• Implemented Database Maintenance Plans, Reports and Monitoring.
• Resolved database performance issues (IO saturation, disk bottleneck, network bottleneck, etc...), database capacity issues, replication, and other distributed data issues.
• Create and implement best backup and recovery strategies (Full Backup Model with 4 hours period transaction LOGS backup.)
• Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping.
• Implemented the recovery process to restore lost data caused by users or system failure.
• Evaluate back-up and recovery hardware and software and make recommendations to management to automate and implement on-going improvements.
• Efficient Stored Procedures and effective functions were written in T-SQL to handle major business crucial calculations.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries and Stored Procedures.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Managed the historical data in the data warehouse from various data sources.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Created various reports using SQL Server 2005 Reporting Services for Inventory analysis.
• Defined Check constraints, rules, indexes and views based on the business requirements.
• Documented all the procedures involved in the database for future reference.

Environment: MS SQL SERVER 2005, BIDS, VB, Visual Studio 3.5, VSS, Windows Server 2003, MS Office.

Confidential, Portland, OR Jan'07 - May'07
Role: SQL Developer/jr.DBA

Responsibilities:

• Actively involved in analyzing the old database system and mapping tables, relationships, columns to SQL Server 2005.
• Efficiently worked in installation, configuration, design, implementation of staging database for data migration and data entry.
• Developed SQL scripts to Insert, Update and Delete data in MSSQL database tables in OLTP environment.
• Created DTS packages to extract data from Oracle Data source.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS, BCP in staging database from MS Access, Sybase, excel.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
• Improved data load performance by analyzing database design and query plans.
• Performed Changes in the Schema of the proposed database as required and informed those changes to the application development team.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into Staging Area.
• Documented different Stages of data transformation, procedures and T-SQL scripts.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Created Reports using SQL Server Reporting Services (SSRS) using BIDS.

Environment: MS SQL Server 2005/2000, BIDS, VSS3.0, Windows server 2003,Visual Studio 3.0, MS Office 2003.

Confidential, IndiaFeb'05-Oct'06
Project: Financial Accounting System
Role: SQL Developer/DBA

Responsibilities:

• Actively involved with the front end .net developers as a part of a team for gathering and analyzing the needs of User Requirement.
• Modified existing database to fit new business requirement by adding tables and relationships to support Customer Information System.
• Created DTS packages to extract data from various data sources like Excel, Access and flat files.
• Created efficient Stored Procedure and functions which implement necessary business logic to support the front end application using T-SQL.
• Created indexed view to optimize query performance by facilitating easy user interface implementation.
• Created instead of trigger on indexed view to facilitate consistent data entry into the database Used SQL reporting services.
• Optimized the query performance by removing unnecessary columns, redundant and inconsistent data. Query performance was improved by normalizing tables, establishing necessary joins and creating useful indexes wherever necessary.
• Worked on Client/Server tools such as SQL Server 2000 Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance planner for the performance of SQL Server, which includes Database Integrity Checks, Update Database Statistics and Re-index the fragmented indexes.
• Created DTS packages to migrate data from various sources to the SQL Server 2000.
• Optimized database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Created Reports using SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003.

Environment: MSSQL Server 2000(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), VB.Net.