SUMMARY

• Over 7 years of extensive experience in database design, development and administration with MS SQL Server versions 2008/2005/2000 using SSIS, SSAS and SSRS in Finance, Banking, 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.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles.
• Installed and configured database software, associated database tools and performance monitoring software.
• Experienced in ETL processes, Data warehousing methodologies and concepts including star schemas, snowflake schemas, dimensional modeling and reporting tools, Operations Data Store concepts, Data Marts and OLAP technologies.
• Experienced in Extraction, Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP, Bulk Insert utilities.
• Experienced in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Expert in generating reports using Crystal Reports and MS Excel. Also have expertise in generating drill down reports, parameterized reports, linked reports, sub reports, Ad - hoc reports, data driven subscription reports, matrix dynamics and filters, charts using SQL Server Reporting Services (SSRS 2000/2005/2008 ).
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000/7.0
• MS SQL Server 2005/2008 Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• Business Intelligence Development Studio (BIDS)
• BCP
• SQL Server Management studio
• Microsoft Access 2000
• T-SQL
• HTML
• XML
• Oracle 10g
• Visual source safe 2005
• Borland’s Star team
• Rational Clear Case
• Rational Clear Quest
• HP Quality Center (Test Director)
• MS office 2003/2007
• Windows 2000/2003 Server/Professional
• Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

Sr. SQL Developer/BI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development and deployment and also involved in developing Technical design.
• Experienced in optimizing t-sql queries using clustered and non clustered indexes.
• Optimized t-sql queries using SQL Profiler and data tuning advisor.
• Optimized SSIS packages using stored procedure and avoiding blocking transformation such as sort and aggregate transformation.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports using SSRS.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Implemented Table Partitioning and Data Compression, Cache Connection for performance improvement.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Involved in the deployment of SSIS packages on to the MSDB database.
• Involved in developing test cases for Unit Testing.
• Involved in preparation of Release Notes/Build steps for Operation Team.

Environment: MS SQL Server 2008, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), Windows 2003, Microsoft Visio.

Confidential, Cincinnati, OH

Sr. SQL Server Developer

Responsibilities:

• Involved in Business Analysis & Requirement collection.
• Designed Data Warehouse and Database for the system using Star Schema which includes Tables, Stored Procedure and Indexes in SQL Server Management Studio.
• Implemented ETL to Extract and Transform data from Flat File or CSV, SQL Server 2005 instances and to load into Staging Database. Use Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Created and updated complex Stored Procedures, Triggers and User Defined Functions for logical T-SQL implementation.
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Created crystal reports using Business Objects.
• Managed Report Security by using SSMS. Connect to Reporting Server and set different roles and different security level to different users.
• Use SQL Server Profiler for tuning report queries and improve performance in SQL Server.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documenting the development work.

Environment: MS SQL Server 2008/2005 Enterprise Edition, Windows Server 2003, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), Crystal Reports, Microsoft Visual Studio 2005.

Confidential, Cleveland, Ohio

MS SQL Developer

Responsibilities:

• Actively designed the database to fasten certain daily jobs and some stored procedure.
• Optimized query performance by creating indexes.
• Involved in performance tuning of T-SQL queries.
• Created store procedures, functions, triggers, joins, sub queries to meet client requirement.
• Configured and deployed ssis packages using different methodology and run a sql server agent job.
• Loaded data from different sources such as sql file, excel sheet, flat file, csv file to staging data base and performed various transformations to meet client requirement.
• Worked with Data modeling team to design physical model of the database
• Involved in Data migration from EXCEL, MS Access to SQL Server
• Responsible for working with co-developers in designing packages in SSIS/ETL
• Created the SSIS packages to pull the data from two sources (OutlookSoft, text) and publish them into Database
• Assisted fellow developers with OLAP and Doing ETL in transformation of cubes
• Created tabular, matrix, drill down, drill through report using different sources to meet client requirement.

Environment: MS SQL Server 2005, T-SQL, Visual Studio, ERWIN, crystal reports 11, ETL, OLAP

Confidential, Newark, NJ

MS SQL Server / SSRS /SSIS Developer

Responsibilities:

• Designed the database with tables, mapped the column from the corresponding tables.
• Migrated Database objects from the existing SQL Server 2000 to SQL Server 2005 using SSIS, SSMS, BIDS and SQL Server Manager.
• Migrated data from the different source including flat files. MS Access, Oracle 8i/9i to SQL Server 2005 using SSIS.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Responsible for creating different types of reports based on the complex T-SQL queries from the scratch like matrix report and charts, parametric report and tabular reports with different types of calculation and formatting options and grouping options.
• Prepared end user documentation, Technical documentation, dimension map, Contact list and published into the Production.
• Responsible for the weekly and monthly back up by SQL Server 2005 and restore these databases in different server.

Environment: MS SQL Server 2005/2000, Business Intelligence Studio (BIDS), MS SQL Server Reporting Services 2005, Crystal Reports, SSIS, Windows XP / NT / 2000, MS Office 2003, Excel 2003, SSMS (SQL Management Studio), Visual Studio

Confidential, Oaks, PA

MS SQL Developer

Responsibilities:

• Responsible for requirements gathering, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Designed and developed SSIS packages to migrate data from multiple data sources for data analyzing, deploying and dynamic configuration of SSIS packages.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
• Migrated database from SQL server 2000 to SQL server 2005 using SSIS packages.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensively used SSIS for transferring data manually from DTS packages to SSIS packages using SSIS 2005.
• Developed and maintained a combined data store for reporting purposes.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports, created aggregation reports and also generated reports using Global Variables, Expressions and Functions using SSRS 2005
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Established backup and recovery of SQL server 2005.
• Used Visual Source Safe (VSS) for version control

Environment: MS SQL Server 2005 Enterprise Edition, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005DTS, T-SQL, VB Script, Windows Server 2003, Erwin 4.0