SUMMARY

• Over 8+ years of extensive experience in database design, development, and administration with MS SQL Server versions using SSIS, SSAS, SSRS in Financial, Retail, Healthcare, Insurance, and Banking industries.
• Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Strong experience in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
• Extensive experience in MS SQL Server, Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
• Experienced in installing, configuring, managing, monitoring, and troubleshooting SQL Server
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
• Experienced in designing high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of SSIS.
• Strong experience in designing and developing large number of reports in SSRS/Business Objects using the data from ETL Loads, MS SSAS Cubes and various heterogeneous data sources.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Expert in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS)
• Experienced in using XMLA protocol for SQL Server Analysis Services for interaction between client application and instances of Analysis Services.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS 2005.
• Efficient in up gradation and migration from SQL Server 2000 to SQL Server
• Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability.Willing to relocate: Anywhere
• Authorized to work in the US for any employer

PROFESSIONAL EXPERIENCE

Confidential, Mount Laurel, NJ

MS SQL Developer/SSIS/SSAS/SSRS

Responsibilities:

• Involved in Planning, Defining and Designing database using Erwin 8.0 on business requirements and provided documentations.
• Designed MS SSIS Packages to extract data from various OLTP sources, Text Files, XML (Extensible Markup Language) Files, MS SQL Server 2000, Excel and MS Access 2000 to OLAP system like SQL Server.
• Wrote T-SQL queries with the help of Stored Procedures, Functions, Triggers, Cursors, Views, and Indexes.
• Created various SSIS packages using data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column.
• Wrote T-SQL queries, Store Procedures and used them to build packages and maintain the history of the data.
• Involved in Design and Developed OLAP cubes for the end user analysis purpose using MS SSAS 2005. Identified fact and dimension tables in the Cube.
• Developed reports in MS SQL Server environment using MS SSRS-2005 in Business Intelligence Development Studio (BIDS).
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using MS SSRS for the end user requirements.
• Worked with the front end developers to deploy the reports.
• Involved in the design and development of web forms for the application using ASP.Net to take care the cosmetic works of the reports deployed on the server.
• Performed daily tasks including backup and restore by using MS SQL Server 2005 tools like MS SQL Server Management Studio, MS SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in development of MDX expressions for cube calculation and KPIs(Key Performance Indicators)
• Used MS SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.

Confidential,Sunnyvale, CA

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Engaged in gathering data and documenting it for further reference.
• Involved in installation and configuration of MS SQL Server 2008.
• Expert in designing database using ERWIN.v7.2
• Upgraded the server from MS SQL Server 2005 to MS SQL Server 2008.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, and etc.
• Created SSIS packages for data Importing, Cleansing, and Parsing.
• Developed Unit Test Plans for SSIS packages.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• Designed, developed, and deployed reports in MS SQL Server environment using SSRS 2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Generated various reports using SSRS 2008.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for monitoring and tuning report performance.
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Provided documentation for all kinds of reports, Stored Procedures and SSIS packages.

Confidential, Durham, NC

MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of data source and data flows.
• Installed and configured MS SQL Server 2008R2 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin 7.1 to design new database after discussion with technical team and application.
• Analyzed data quality, by working in conjunction with the data warehouse architect on the development of logical data models.
• Designed and developed SSIS packages to move data from production environment to different environments within the organization.
• Designed and implemented complex SSIS packages to migrate data from multiple data sources for data analyzing, deploying, and dynamic configuring of SSIS packages.
• Migrated database from MS SQL Server 2000 to MS SQL Server 2005 using SSIS packages.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP sources like MS SQL Server 2000, Oracle, Text Files, Excel and Access to OLAP with the help of MS SSIS.
• Used SSIS to manually transfer DTS packages 2000 to SSIS packages 2005 using MS SSIS 2005
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions, and Functions using SSRS 2005.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Created parameterized, drill down, and aggregated reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.

Confidential, Woodland Hills, CA

MS SQL Developer/SSIS/SSAS/SSRS Developer

Responsibilities:

• Gathered user requirements, analyzed, and designed software solution and database.
• Designed an OLAP with the help of Erwin 7.1.0 to visualize data structure.
• Created complex Stored Procedures, SSIS (Data Transformation Service) packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Developed T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements using dynamically generated SQL.
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS) 2005.
• Modified cube partitions to optimize the query performance of the cubes
• Created MS SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using MS SSAS 2005.
• Defined Referenced relationships with the measure groups and fact tables.
• Improved query performance by cube partitioning.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using MS SSAS 2005.
• Developed MDX expressions for cube calculations and KPIs.
• Implemented the calculations to aggregate physical measures using management studio.
• Generated daily, weekly, monthly, quarterly, and annual reports using MS SSRS 2005.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.

Confidential, NY

MS SQL Server Developer

Responsibilities:

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model using ERwin Data Modeler.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Worked Extensively with MS SQL Server Integration Services (SSIS) to import, export and transform the data between the linked servers.
• Created packages using MS SQL Server Integration Services (SSIS) for data extraction from Flat Files, Excel files, OLEDB source to data warehouse.
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SQL Server Reporting Services 2005.
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Used BCP utility and Bulk Insert to load data from different data sources to SQL Server.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.

Confidential, Jacksonville, FL

MS SQL SSIS/SSAS/ SSRS Developer

Responsibilities:

• Involved in module testing and development. Defined testing cycle documents.
• Created various tables, views, indexes and Sequences.
• Developed database triggers.
• Development of forward port, Creation of test Scripts and Execution of White box testing and integration testing.
• Created many packages, procedures and functions for reports. Data was populated in the reports using these routines.
• Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.
• Involved in module design
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Creation of complex business scenarios
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SQL Server Reporting Services 2005.
• Performed daily tasks including backup and restore by using MS SQL Server 2005 tools like MS SQL Server Management Studio, MS SQL Server Agent, and Database Engine Tuning Advisor.
• Used MS SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Involved in language compatibility of application for Russian language.