SUMMARY

• Over 7 years of extensive experience in database design, development and administration with MS SQL Server versions 2008/2005/2000/7.0 using SSIS, SSAS, SSRS inFinance, Retail and Healthcare industries.
• Conversant with all phase of Software Development Life Cycle (SDLC)involving Systems Analysis, Design, Development and Implementation.
• Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS) of MS SQL server 2005/2008.
• Experienced inLogical and Physical Database designand development, Normalization and Data modeling using Erwin and MS SQL Server Enterprise manager.
• Experienced in ETL processes,Data warehousing methodologies and concepts including star schemas, snowflake schemas, dimensional modeling andreporting tools,Operations Data Store concepts,Data Mart and OLAP technologies.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL work flow designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Expert in using Bulk Copy Program(BCP),Data Transformation Services(DTS) packages and SSIS (integration services)with MS SQL Server 2000/2005/2008.
• Highly proficient in the use of T - SQL for developing complexstored procedures, triggers, tables, user functions, user profiles, relational database modelsanddata integrity, SQL joinsandquery writing.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Efficient in up gradation and migration fromMS SQL Server 2000toMS SQL Server 2005/2008.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Extensively worked with third party tools like SQL LiteSpeed, Spotlight, SQL Watch, Red-Gate, Erwin, Toad, and DBArtesian.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Databases: SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access, ORACLE 10g/11g, MySQL

Database Tools: Business Intelligence Development Studio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service, SQL Server Management Studio

ETL Tools: SQL Server Integration Service (SSIS), DTS

Languages: SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access, MySQL, C/C++, HTML,P.H.P, JavaScript

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Report

Office Tools: MS WORD, MS EXCEL, MS VISIO, MS Power Point

Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows 2008, Windows 7, Windows 8

PROFESSIONAL EXPERIENCE

Confidential, Mainland, PA

SQL / BI Developer

Responsibilities:

• Designed and created SSIS packages to extract, transform and load data from Excel and Text to SQL Server destination using various complicated transformations like conditional split, look up, derived column, data conversion and slowly changing dimensions.
• Worked with T-SQL to create tables, stored procedures, triggers and user defined functions for complex business logic.
• Used SQL Server Profiler and Database Tuning Wizard for Performance tuning and query optimization.
• Created indexes on selective columns for the fast retrieval of data in SQL Server Management Studio.
• Used Event handlers to capture the run time error messages by using send mail tasks in the background upon success or failure of a package in SSIS, carried out scheduling and administering of SSIS packages.
• Involved in error handling, creating package configuration and log details using SSIS logging.
• Generated and consolidated monthly reports to drive forecast production plan with SQL report services (SSRS).
• Designed, developed and deployed Summarized, Matrix and Tabular reports with drill down and drill through features using SSRS in Business Intelligence Development Studio BIDS) as per the client requirements.
• Scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports.
• Involved in analyzing, designing, building and testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Created and maintained databases, tables, views, user logins, indexes, check constraints and business rules using T-SQL.

Environment: MS SQL Integration Services 2008, MS SQL Server 2008, MS SQL Server 2005, Crystal Reports, VB.Net, Window XP, MS Word 2010, Visual Studio 2008, MS Excel 2010, HTML, Java Script

Confidential, Tyler, TX

SQL / BI Developer

Responsibilities:

• Created T-SQL queries, stored procedures, user defined function and views, for faster retrieval of data by using T-SQL queries and to display specific information.
• Scripted Transact SQL (T-SQL) queries and used SQL Server Constraint (Primary Key, Foreign Key, Default, Checks and Unique).
• Designed ETL packages for integrating data from heterogeneous sources like Excel, CSV, Flat file and Text Format data and applied various data transformation like conditional split, look up, derived column, slowly changing dimensions.
• Used check point, Break point and Logging in SSIS to debug and optimize package while developing them.
• Monitored and kept track of error logs from logging providers in SSIS.
• Used Event Handlers to run the Send mail task in the background upon failure of SSIS package.
• Loaded packages from the staging table to standardized table in SQL Server 2008.
• Developed, designed and deployed Matrix and Tabular reports with drill down and drill through features using SSRS in Business Intelligence Development Studio (BIDS) as per client requirements.
• Generated daily, weekly, monthly report for analysis purpose when the end user wants to see the reports on fly using SSRS.
• Designed and developed cubes using Star Schema with SQL Server Analysis Services.
• Worked with OLTP, OLAP, Data Warehouse application, star schema dimensions.
• Evaluated database performance and maintenance duties such as Backup, Restoration are performed by scheduling jobs using SQL Server Job Agent.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.

Environment: MS SQL Server 2008 (SSMS), MS SQL Server 2005 (SSMS), MS SQL Integration Services 2008, VB.Net, Window XP, MS Word, Visual Studio 2008, MS Excel

Confidential

SQL Server Developer

Responsibilities:

• Managed and led an outsourced group of developers during SSAS cube development; conducting daily sync-up meetings, monitoring progress, work planning, ensuring deliverables within deadlines
• Involved in logical and physical database design using Erwin 3.5.2 and MS Visio 2003
• Designed and implemented comprehensive Backup plan and disaster recovery strategies to ensure high availability of data.
• Responsible for database backups, database replication, encryption and database security
• Maintaining high security to patient records by creating and managing new security accounts and restricting user activity on it.
• Involved in trouble shooting and tuning of databases for its performance and concurrency using Database Tuning Advisor.
• Export/ Import data from other data sources like flat files using Import/Export of Data Transformation Services (DTS)
• Analyzing performance elated queries and tune the same using SQL Query Analyzer to optimize application and performance.
• Wrote Stored Procedures / Transact-SQL scripts, Altered/Re-indexed tables as per the business need.
• Involved in creating database objects like Tables, Views, Triggers, User Defined Functions and User Defined Data types by coordinating with the development team
• Assisted the development team in writing complex SQL scripts and SQL Joins
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• Involved in index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Assisted in handling escalating billing issues and propagating bug fixes in production environment.

Environment: SQL Server 2000/7.0, Enterprise Manager, Windows Server 2003, SQL Profiler, DTS, T-SQL, BCP, MS Excel

Confidential

MS SQL Server Developer

Responsibilities:

• Carried out a developer’s role on MS SQL Server 2000, MS Access databases (using DTS, T-SQL, Scripts,Stored procedures and views).
• Logical and physical database development (using Erwin, normalization, dimension modeling and Enterprise manager).
• Looked at the reports and fixed bugs in stored procedures, tables and ETL process.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS.
• Created and automated regular jobs such as daily/weekly report generations.
• Managed and monitored system utilization.
• Developed complex T-SQL code for the application.
• Designed and implemented the stored procedures and triggers for automating tasks.
• Worked on BIDW architecture & solutions.

Environment: MS SQL Server 2000, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer

Confidential

MS SQL Server Developer

Responsibilities:

• Created T-SQL queries, stored procedures, user defined function and views, for faster retrieval of data by using T-SQL queries and to display specific information.
• Designed ETL packages for integrating data from heterogeneous sources like Excel, CSV, Flat file and Text Format data and applied various data transformation like conditional split, look up, derived column, slowly changing dimensions.
• Used check point, Break point and Logging in SSIS to debug and optimize package while developing them.
• Used Event Handlers to run the Send mail task in the background upon failure of SSIS package.
• Loaded packages from the staging table to standardized table in SQL Server 2008.
• Developed, designed and deployed Matrix and Tabular reports with drill down and drill through features using SSRS in Business Intelligence Development Studio (BIDS) as per client requirements.
• Generated daily, weekly, monthly report for analysis purpose when the end user wants to see the reports on fly using SSRS.
• Designed and developed cubes using Star Schema with SQL Server Analysis Services.
• Evaluated database performance and maintenance duties such as Backup, Restoration are performed by scheduling jobs using SQL Server Job Agent.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.

Environment: MS SQL Server 2008, SSRS, SSIS, SSAS, T-SQL, MS-Excel, XML, Windows 2000/2003/NT/XP/7/8/10