SUMMARY

• 7 years of experience in MS SQL Server Database Developer, Administration, Design, Development and 2 years of experience in Business Intelligence.
• Experience in installation, upgrade and configuration of Microsoft SQL Server 2005/2008 and databases.
• Extensive knowledge of star schema, snowflake schema, type - 1 and type-2 Data warehouses (EDW).
• Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Extensive experience in creating stored procedure using dynamic SQL, functions.
• Expert in extracting, transforming and loading of data using ETL tools such as SSIS, DTS.
• Extensive experience in data massaging and data cleansing using SSIS transformations such as fuzzy grouping, lookup, derived column, row sampling, auditing.
• Experience in designing SSIS modules for loading type-1 and type-2 changes in DW.
• Extensive knowledge in error logging with both table based logging and file based logging for SSIS.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, Database Objects authorization, DTS,ETL using DTS(SSIS), Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures.
• Experience in implementing different types of Replication Models such as Snapshot, Merge and Transactional.
• Experience in Microsoft SQL Server Database Administration including planning, backup, and recovery strategies.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting query performance and MS SQL server bottle necks including Network Traffic, Hardware usage and Blocking.
• Experience in scheduling of reports in SSRS.
• Experience in different team projects with extensive project implementation experience, team skills, troubleshooting, presentation abilities and issue resolution capabilities.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2005, 2000 & 7.0, MS Access

Database Technologies/Tools: SQL Server Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Client Configuration Utility, Data Transformation Services (DTS), Integration Service (SSIS), Analysis Service (SSAS), Reporting Service(SSRS), ODBC, ADO, Data warehouse

Operating Systems: Windows VISTA, XP, 2003, 2000, NT, 98, 95, MS DOS

Programming Languages: T-SQL, Visual Basic, C/C++, Visual Studio

Office/Business tools: Acrobat, MS Word, Excel, PowerPoint, Outlook

PROFESSIONAL EXPERIENCE

Confidential, Horsham, PA

BI developer/DBA

Responsibilities:

• Working with business owner team to get the end to end requirement of the Enterprise Data Warehouse (EDW).
• Identified the data sources and system and created mapping in order to load the data in the EDW.
• Designed and created staging, validation tables for landing the source data coming from source system using SSIS.
• Designed several SSIS package modules for extracting the data from different sources such as excel spreadsheets, csv files, flat delimited text files, DB2 to the SQL Server database tables.
• Designed SSIS modules for loading type-1 and type-2 changes in EDW.
• Worked in data massaging, scrubbing and cleansing of data in order to handle NULL, invalid data using derived column in the staging area.
• Designed and implemented several functions called through the stored procedure from SSIS execute SQL task in order to handle invalid record.
• Designed and created SSIS package using transformations such as sort, merge, lookup and merge join etc. to load the data into fact and dim table using lookup/script tasks.
• Designed and implemented packages for creating rollup tables based on several business rules.
• Worked on dynamic SQL and calling it with stored procedures.
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Performance tuning, and optimization of procedures and queries.
• Running Index tuning wizard and rebuilding indexes for faster query response.

Environment: SQL Server 2005 (Query Analyzer, Management Studio, SSIS Designer, Database Engine Tuning Advisor), IIS, MS Excel, VB 6.0, .NET.

Confidential, Houston, Texas

BI Developer

Responsibilities:

• Worked with Business Analysts and Users to Gather Specifications.
• Migrated objects from SQL Server 2000 to SQL Server 2005 such as tables, views, stored procedures and functions.
• Created views for generating end user ad-hoc reporting in SSRS.
• Generated parameterized reports and linked reports in SSRS.
• Generated type I reports such as basic, Table, Chart, and drill down reports using Reporting Services (SSRS).
• Worked on type II reports that utilize the concept of sub-report and created master-child reports.
• Worked on report scheduling and subscription processing for reports in SSRS.
• Worked on report delivery mechanisms such as pull delivery, push delivery and local delivery.
• Designed indexed view for the reporting services in order to bring down the retrieval time, also worked on index tuning for several user ad-hoc queries and reports.
• Designed stored procedures that accepted variables from reports and generated reports.
• Experience in forecasting reports and analytics reports for the data warehouse.
• Develop and deliver dynamic reporting solutions using SSRS.
• Architect faux data mart solutions to improve performance of SQL Server 2005 Reporting Services (SSRS).
• Designed Stored Procedures, for roll up tables and staging.
• Documented all database objects for future enhancement and maintenance.

Environment: Visual Studio 2005, SQL Server 2005, SQL Reporting Services, SQL Server Integration services, Windows server 2003.

Confidential, Minneapolis, Minnesota

SQL Server Developer/DBA

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Created/modified/altered functions, tables, views, stored procedures and complex queries on OLTP and OLAP environments.
• Reviewed stored procedures created by the developers and provided recommendations for the code modifications for production.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc).
• Written Complex T-SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved for managing security using SQL logins, roles and security modes for other users.
• Configured and deployed SSIS packages and database objects from test to production environment.
• Worked on tuning of the databases, servers and query tuning.
• Monitored transactional replication and trouble shooting of errors.
• Created the backup and restore strategy for production and development environment.
• Involved in tuning the database and server performance. Worked with Profiler to trace and tune the database.

Environment: MS SQL Server 2008/2005/2000, SSIS, SSRS, performance monitor, DTS, crystal reports, XML, web services.

Confidential, Westerville, Ohio

SQL Server Developer

Responsibilities:

• Ensured project requirement and delivery with active interactions with end user.
• Design/build ETL procedures in SQL Server 2005 to import/export data feeds to/from data warehouse.
• Extensive experience in writing and debugging stored procedures, inner joins and outer joins, views and functions.
• Filtered bad data using complex T-SQL statements, UDFs and implemented various constraint and triggers for data consistency.
• Coordinated with front end developer to put in the business rules. Wrote stored procedure to check some of the rules at the backend at the time of entering data.
• Created stored procedures, triggers, views, added/modified tables for data load transformation, extraction and manipulation.
• Created indexes on the columns recommended by the query optimizer to improve the performance of the slow running queries and stored procedures.
• Involved in designing, developing and testing of the ETL strategy to populate the insurance data from various source system feeds using SSIS.
• Migrated DTS packages to SSIS packages.
• Created new SSIS packages according to the business rules.
• Created SSIS packages for data extraction from flat files, excel files, OLE DB etc.
• Used SSRS to create customized reports, on-demand reports, and ad-hoc reports for analyzing multi-dimensional reports.
• Created various ad-hoc SQL queries for customer reports, executive management reports and other types of reports such as tables, matrix, sub reports etc.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.

Environment: SQL Server 2005/2000, SSIS, SSRS, DTS, T-SQL, XML, windows 2003

Confidential

SQL Server Developer

Responsibilities:

• Active member of team in gathering requirements and designing the data model.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Gathered functional requirements and written the technical specifications.
• Converted various SQL statements into stored procedures thereby reducing the number of database accesses (since Stored Procedures passes the whole block at one time).
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Created and managed schema objects such as tables, views, indexes and stored procedures and maintained referential integrity.
• Rebuilt the indexes for better performance.
• Wrote T-SQLstatements to ensure data consistency by filtering corrupt data and implemented variousconstraintsandtriggersto preserve data integrity.
• Developed effectivestoredprocedures, functionsto implement business logic.
• UsedBCPto move in or out data from different sources.
• UsedBulk Inserttocopy large amount of data into database.
• Developed SQL queries to fetch data from different tables in remote databases using joins, and database links.
• Fine-tuned the logic in stored procedures and functions for optimum performance.
• Optimized query performance by removing unnecessary columns, eliminating redundant and inconsistent data and normalizing tables.
• Involved in data integration by identifying the information needs within and across functional area of an enterprise database.
• Create and maintain mail and database account with client user support.

Environment: SQL Server 2000, windows, T-SQL, Erwin