SUMMARY

• Over 6 years of IT professional experience in Database Design, Development and maintenance of database applications using SQL Server 2005/2008/2008 R2/2012 in OLTP/BI environment.
• Expertise in Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Excellent client facing skills, requirements gathering through client interviews, and converting the requirements to technical specifications.
• Excellent T - SQL development skills to write complex queries involving multiple tables using sub queries and joins, great ability to develop and maintain complex stored procedures, triggers, user defined functions and views.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Performance Tuning and Query Optimization using SQL Profiler and Index Tuning Wizard.
• Expert in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.
• Strong experience in ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS)and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Strong knowledge in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS and Data Transformation Services (DTS).
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations.
• Expert in analyzing data warehousing by building cubes using SQL Server Analysis Services (SSAS).
• Excellent experience in developing stylish Drill Down, Cascading, Parametrized, Drill through, Report on SSAS cube using MDX, Matrix, Sub reports and Charts using Global variables, Expressions and Functions for the business users on SQL Server Reporting Services(SSRS).
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Languages: T-SQL, VB script 6.0, Active Scripting, C, C++, Java, C#

RDBMS: MS SQL Server 2005, 2000, 7.0, MS-Access.

Front End: MS Visual Basics 6.0

Web Technologies: HTML, CSS,XML and Java Script

Reporting Tools: Crystal Reports, SQL Server Reporting services (2000 and 2005,2008, 2008 R2)

Web Server Technologies: IIS 5.1/6.0

Data Modeling Tool: ERWIN 4.0, Visio 2002

Operating System: Windows 2000 Advanced Server, Windows 2000 data center, Windows NT, Windows 95/98/2000 XP

Other Tools: TOAD, QTP, QC, Test Manager

PROFESSIONAL EXPERIENCE

SQL BI Developer

Confidential, Chicago, IL

Responsibilities:

• Created database, tables and procedures to update and clean the old data.
• Created schemas, views, complex stored procedures, cursors, triggers, SQL Join statements, SSIS packages and user defined functions for data migration.
• Designed ER diagrams and mapped the data into database objects.
• Installed and migrated databases from Oracle database to MS SQL Server 2008.
• Migrated Data from Oracle database using SQL Server Migration Assistant (SSMA) and making the process more cost efficient and increasing productivity for the business.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Normalized the OLTP Database.
• Wrote SQL scripts to Insert/Update and Delete data in MS SQL database.
• Designed and created different ETL packages using SSIS from Oracle source to SQL server as destination.
• Created SSIS Packages to import and export data from Excel, XML and Text files.
• Designed and developed packages for data warehousing, extracted data from oracle, flat files, transformed and loaded into the target data warehouse.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008.
• Created table and index partitioning for performance and manageability. Used clustered and non-clustered indices.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Solved the issues for front-end application developers with their queries.
• Tuned SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
• Handled slowly changing dimension to maintain the history of the data and identified KPI's and Metrics for Business needs. Developed MDX expressions for cube calculations and KPIs.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance. Identified, tested and resolved database performance issues.
• Generated various reports cascading, drill down, drill through, parametrized, matrix, sub reports using SQL Server Reporting Services.

Environment: Microsoft SQL Server 2008, MS SQL Server Integration Services 2008 (SSIS), MS SQL Server Reporting Services 2008 (SSRS),Windows Server, MS Visio, Oracle 9i, MS Excel.

SQL BI Developer

Confidential, Scranton, PA

Responsibilities:

• Upgraded the production; tested and upgraded databases from SQL Server 2000 Enterprise version to SQL Server 2005 Enterprise version.
• Migrated the DTS packages into SSIS and create new SSIS packages to Extract, transform and load the data from old data warehouse to new data warehouse and OLTP to OLAP.
• Using Fuzzy Look up and Fuzzy Grouping transformations for improving the data quality of the existing data as well as new data that is being loaded into the database.
• Closely monitored all production SQL Servers across all data-centers and maintained the company backup strategy.
• Redirected the stored procedures to point to new databases and data warehouse.
• These Stored procedures are important in entire data migration and are used in Business Intelligence solutions such as SSIS and Reporting.
• Created various views to be used in various load procedures as pointed to new Database system while maintain the exact business functionality in the process of ERP implementation.
• Modified the procedures to point to new Data system and resolved the performance issues.
• Defined the Browsing Perspectives and Browsing Translations since most transactions were online
• Documented the development work and production release for future reference.
• Converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of reports.
• Created weekly, monthly and quarterly based financial reports using SQL Server 2005 Reporting services.

Environment: MS SQL Server 2005/2000, MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services(SSAS), MS Windows server 2003, Oracle 9i, Visual Studio 2005, IIS 7.0/6.0, DTS Exchange, Erwin.

MS SQL Server BI Developer (SSIS/SSRS)

Confidential, Wayne, NJ

Responsibilities:

• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
• Designed and developed SSIS packages to move data from production environment to different environments within the organization.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Developed and maintained a combined data store for reporting purposes.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Generated daily, weekly and monthly reports for the managers.
• Designed ETL architecture for data transfer from the OLTP to OLAP with the help of SSIS.
• Migrated database from SQL server 2000 to SQL server 2005 using SSIS packages.
• Designed and implemented SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed and implemented the database schema for data warehouses.
• Generated parameterized, drill down and drill through reports using Global Variables, Expressions and Functions using SSRS.

Environment: MS SQL Server 2000, MS SQL Server 2005, T-SQL, Visual studio 2005, DTS, Data Analyzer, MS Access, MS Excel, SQL Profiler, Windows XP, Erwin 4.2, VSS 2005, MS SQL Server 2005, SSAS, SSRS, SSIS.

MS SQL Server Developer

Confidential

Responsibilities:

• Developed database objects-stored procedures, functions, triggers, views.
• Created and Updated Indexes based on suggestions by SQL profiler and Index tuning advisor.
• Database upgrade from SQL server 2000 to SQL Server 2005.
• Perform back-ups, restores, scheduling, maintenance
• Created SSIS packages to ETL data into production system and to produce/schedule management control reports.
• Extensively worked on converting DTS packages to SSIS packages.
• Developed SSIS packages to load data from application database and flat files into destination database.
• Used derived column transformation to perform various calculations.
• Implemented package configurations in SSIS packages that allow transferring packages from one environment to other.
• Deployed SSIS packages to production, schedule them to run on routine basis and monitor the error log for any errors.
• Developed reports on top of OLTP database.

Environment: SSIS, MS SQL Server 2005, DTS, SQL Server 2000, Windows, C-Sharp, Erwin Data Modeler.

MS SQL Server Developer

Confidential

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts 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.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
• Performance tuning of SQL queries and stored procedures using SQL Profiler 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
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
• Active client interaction for requirement and enhancement gathering.

Environment: SQL Server 2005, T-SQL, PL/SQL, TOAD.