SUMMARY

• Over eight years of work experience in all the phases of the SQL Server development life cycle involving requirements gathering from end users/business, design, development, analysis and testing of the Data warehouse using ETL, Data Modeling, Online Analytical Processing (OLAP) and reporting tools.
• Extensive experience in all phases of Software Development Life Cycle, Problem analysis and resolution, Requirement gathering and analysis, Client interaction, end user documentation with extensive coding standards and state of the art technology.
• Expert in Setting up, Configuring, Creating and Scheduling SQL Server Reporting Service (SSRS) reports and hands on experience in creating OLAP cubes using SQL ServerAnalysis Services (SSAS) and expertise on SQL Server Integration Services (SSIS).
• Experience in enhancing and deploying theSQL Server (SSIS)Packages from developmentserverto productionserver.
• Addressed performance issues associated with stored procedures, fixed them and has re - written TSQL statements for the new schema including implementation of the useful indexes.
• Experience in implementation of Business Intelligence tools, ETL Process with DTS/SSIS, Data Cleansing, SQL Databases, Analysis Services SSAS (Star Schema, Snow-flake schema, OLAP cubes, Partitioning and Aggregations), Reporting Services (SSRS) and Notification Services (SSNS).
• Extensive exposure in creating database T-SQL scripts, stored procedures, triggers, views, tables, indexes and constraints, user defined functions and security using SQL SERVER 2008/2005/2000.
• Expert in Implementing ETL Packages using DTS and SSIS 2005/2008 and implementing all transformations available on the SSIS toolbox. Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems (Excel, Oracle, DB2, Files) using SQL tools (SSIS, DTS, Bulk Insert, BCP, XML).
• Proficient in data warehousing concepts like Star Schema, Snow Flake Schema, Dimension, Fact tables and usage of surrogate key and experienced in Relational Databases (RDBMS) like Oracle, SQL Server with Access and Development experience in SQL, PL/SQL.
• Experience in creating Master and Child Packages, Package Configurations and Logging. Sound knowledge of using Variables and Expressions in Packages.
• Has fair knowledge on .Net Framework methodology for understanding the front-end applications and services.
• Experience working with MDX queries for ad-hoc Reporting.
• Has demonstrated outstanding leadership, creative problem solving and analytical skills in the areas of developing Business Intelligence (BI) functionality incorporating assorted tools and worked with several groups across multiple platforms.

TECHNICAL SKILLS

Operating Systems: Windows NT, Windows 95-98, Windows XP, Windows 2000, 2003, MSDOS, UNIX

Database/Database Tools: Microsoft SQL Server 2000/2005/2008 , MS Access 97/2000/2003/2007 , Oracle 8.0/10g, ADO, ADO.Net, OLEDB, ODBC

Languages: SQL Programming, Visual Basic 6.0, Visual Basic .Net ( ), VBA for Excel, ASP.Net, ASP, HTML, XML, C, C++,TSQL, PL/SQL, WMI Programming

ETL/Data Warehouse: DTS (Data Transformation Services), SSIS (SQL Server Integration Services)

OLAP: SSAS (SQL Server Analysis Services)

Reporting: SSRS (SQL Server Reporting Services), Crystal Reports, Business Objects

Scripting: VBScript, Java Script

SQL Backup Tools: SQL Litespeed, Red Gate

Event Management Tools: Remedy, Big Brother (Windows)

Miscellaneous: MS Visual Source Safe, Windows API

PROFESSIONAL EXPERIENCE

SQL Server Developer

Confidential, VA

Responsibilities:

• Performed technical activities dat supported the creation of analysis, from data intake through analysis to the creation of final reports.
• Worked extensively inT-SQL for various needs of the transformations while loading the data into SQL Server RDBMS (relational database).
• Developed SSIS Packages to load the client’s data from Flat files, Excel, SQL Database Sources to SQL Database.
• Used different transformations in SSIS for data cleansing and to implement the business logic.
• Developed scripts to implement schema changes introduced as a part of Enterprise data warehousing to the databases not part of EDW.
• Modified the existing SSRS reports to in corporate the new schema changes came in as part of EDW.
• Developed Stored Procedures for the existing inline queries.
• Analyzed the execution plan and re-factored the existing procedures for better performance.
• Increased query performance, necessary for statistical reporting by more than 60% after performing monitoring, tuning, and optimizing Indexes using Performance Monitor, Profiler, and Database Engine Tuning Advisor.
• Wrote T-SQL Cursors and Stored Procedures to perform database analysis and verify if the production data bases are in sync with the template database.
• Involved in Unit, Integration and Regression Testing.
• Participating in the compatibility testing of existing application with Microsoft SQL Server 2008.
• Created the Technical Specification documentation covering the changes made on the data base side to meet the requirements as per the BRD.
• Worked on Agile Software Development methodology based on iterative and incremental development.
• Maintained the table performance by following the tuning tips like Normalization and Creating Indexes.
• Worked with SQL DB Control for maintaining versions of code.
• Designed, Developed and Deployed reports in MS SQL Server 2008 environment using SSRS.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.

Environment: SQL Server 2005/2008, SSIS, SSRS, Share Point 2010,SQLDBControl 2.0, Microsoft Office, T-SQL,BIDS,XML, MS Visual Studio, Windows XP, Windows Server 2008

Confidential, TX

Sr SQL Server Consultant

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Designed the ETL process based on the schemas (snow flake and star schema) for extraction and transformation of data from the source data base and loading on to the target data base.
• Created Stored Procedures to transform the Data and worked extensively inT-SQL for various needs of the transformations while loading the data into SQL Server RDBMS (relational database).
• Also designed and developed PL/SQL scripts for loading data into the Relational Database (RDBMS).
• Worked on BIDS for improving the cube efficiency making it more programmable.
• Maintained the table performance by following the tuning tips like Normalization and Creating Indexes.
• Involved in creatingreport specificationby Tele-conferencing with end users
• Developing and extendingcomplex SSASwith around 35 dimensions, about 10 measures, and 25 calculated members, Design Dimensions and using the MDX expressions for the various Optimizations like Optimizing cube schema according to the OLAP reporting needs.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and stored procedures.
• Implemented SSAS to build cubes which were made available to business users who can browse the data using a variety of tools, making ad hoc analysis an interactive and analytical process rather than a development effort.
• Implemented PowerDesigner for analysis of the extracted data prior to loading of data into destination staging area.
• Tracked the deployments and proceedings of their status through MS SharePoint.
• Modified the existing SQL Server SSIS packages to meet the changes specified by the users.
• Scheduled jobs for executing the stored SQL Server SSIS packages which were developed to update the database on daily basis.
• Designed, Developed and Deployed reports in MS SQL Server 2008 environment using SSRS.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SQL Server SSRS.
• Created reports to retrieve data using Stored Procedures dat accept parameters.
• Generated various reports using SSRS 2005.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Fine tuned SQL Queries for maximum efficiency and performance.
• Generated necessary documentation through MS Word and Flow charts with MS Visio.
• Generated SQLfor views from query subjects in Framework model.
• Designed and implemented Stored Procedures for automating tasks.

Environment: MS SQL Server 2000/2005/2008 , MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), T-SQL, Visual Studio 2005, BIDS, Windows 2003/2008 Server

Confidential, Omaha, NE

SQL Server DBA/Admin

Responsibilities:

• Work closely with business stakeholders, business analyst, and production teams across functional units to identify business needs and discuss solution options.
• Developed Technical Design dat translates the client business requirements as a part of project planning and implementation throughout the project life cycle.
• Lead Developer and managed 2 people in migrating DTS Packages of MS-SQL Server 2000 into SQL Server Integration Services (SSIS) of MS-SQL Server 2005.
• Developed different SSIS packages using Business Intelligence Development Studio (BIDS) utilizing Advanced Data Flow tools (i.e. Aggregate, Derived Column, Conditional Split, etc)
• Designed and developed Complex Queries, T-SQL Stored Procedures, Triggers, Tables, Constraints, Views, and Functions in MS-SQL Server 2000/2005.
• Maintained the Source code repository in Visual SourceSafe and Team Foundation Server.
• Highly involved in maintaining changes through Software Configuration Management activities.
• Developed Unit/Integration/Acceptance Test specification and testing the software modules based on client business requirements.
• Provided technical support to internal developers and business clients.
• Responsible for designing and developing a Drill Down, Cross-tab, and Tabular Report using Report Server in SSRS to draw data from the Data Warehouse.
• Periodically developed a Report to be used by the Senior Management utilizing SSRS.
• Reviewed applications and database design for compliance with best practice standards.

Environment: T-SQL, MS-SQL Server 2000/2005, DTS Packages, SSIS, SSRS, MS-Access 2000, MS Visio, MS Visual SourceSafe, MS Project, Lotus Notes, SSIS, Windows 2003 Server.

Confidential, NJ

SQL Server Developer

Responsibilities:

• Interacted with business users and analysts and gatheird and documented the technical and business metadata.
• Designed Database, Tables and Views structure for the new data mart.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2000 using DTS Packages.
• Created complex Stored Procedures and Functions for integrity checks of transferred data.
• Performed Unit Testing and SQL Performance Tuning.
• Helped end users with the ability to access and utilize the data stored in the data mart.
• Generated Reports and Charts using Crystal Reports.
• Tuned SQL statements (e.g. - Using Indexes) and Stored Procedures.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assisted end users with development of complex Ad Hoc queries.
• Involved in Implementation and Maintenance of Disaster Recovery solutions such as Replication and Log Shipping.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, Index tuning wizard.

Environment: SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VB.Net, VSS, Windows 2000 Server, Enterprise Manger, Query Analyzer, SQL Profiler

Confidential

Responsibilities:

• Requirement gathering Solution design
• Involved in the migration.
• Actively involved in Normalization of database.
• Designed DDL and DML for MSSQLServer2000
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimize query performance by creating indexes.
• Involved in writingSQLbatch scripts.
• Write T-SQLstatements for retrieval of data and Involved in performance tuning of T-SQL Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Perform daily database backup & restoration and monitor the performance of Database Server.
• Create joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and ConfiguredSQLServer2000 on developmentserverfor designing and testing.

Environment: SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VB.Net, VSS, Windows 2000 Server, Enterprise Manger, Query Analyzer, SQL Profiler

Confidential

Responsibilities:

• Created new tables, written stored procedures for ApplicationDevelopersand some user defined functions.
• CreatedSQLscripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous
• Database (Oracle and Text format data) toSQLServer.
• Data migration (import & export BCP) from Text toSQLServer.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Performance tuning ofSQLqueries and stored procedures usingSQLProfiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights Creation/Deletion of LinkedServers.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).

Environment: SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VB.Net, VSS, Windows 2000 Server, Enterprise Manger, Query Analyzer, SQL Profiler