SUMMARY

• Over 8 years of extensive experience in database design, development, and administration with MS SQL Server versions 2012/2008R 2/2008/2005/2000/7.0 using SSIS, SSRS in Financial, Healthcare, Insurance, and Manufacturing 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 2008/2005, Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
• Experienced in installing, configuring, managing, monitoring, and troubleshooting SQL Server 2008/2005.
• 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).
• 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 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 2008/2005.
• Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Maintained Positive Communications and working relationships at all business levels.
• Excellent intern personal skills and communication skills and to take challenges with proven ability.
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.
• Worked in collaborative team environment with other developers, business analysts and project management team.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R 2/2008/2005/2000/7.0
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• MS SQL Server 2008/2005 Analysis Services (SSAS)
• Microsoft Access 2000
• Erwin 8.0/7.3/4.2/4.1/4.0
• Microsoft Visio 11.0/10.0
• T-SQL
• PL/SQL
• ASP.NET 3.5
• C#
• DHTML
• HTML
• XML
• XSLT
• JavaScript
• AJAX V 3.0
• Oracle 10g/9i
• Crystal Reports 11/10/9/8.5
• Visual source safe 2005
• MS office 2007/2003
• Windows 2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation
• Oracle D2K

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

MS SQL Developer/SSIS /SSRS Developer

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 2008, Excel and MS Access 2007 to EDW system (SQL Server 2012).
• Wrote T-SQL queries with the help of Stored Procedures, Functions, Triggers, Cursors, Views, and Indexes.
• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference.
• Designed Database using Erwin data modeler.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.
• Used SSIS Variables for storing the values which are used in various components of Data Flow Task.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• 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.
• Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS 2012.
• Generated parameterized reports, sub reports, tabular reports using SSRS-2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• 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.
• Provided documentation for all kinds of reports and SSIS packages.

Confidential, Addison, TX

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Developed various T-SQL stored procedures, functions and packages.
• Migrated data from Heterogeneous Data Sources and legacy system (Oracle, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Designed SSRS reports like Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Used Database engine tuning advisor, SQL Profiler for Performance Tuning.

Confidential

MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Development of packages according to the ETL specifications for the staging area & Warehouse data.
• Used SSIS packages to roll our data to Live Tables and to Processing Database
• Generating drill-down, drill-through and parameterized reports.
• Worked on all types of reports like tables, matrix, charts, sub reports etc
• Development of T-SQL Stored procedures, User Defined Data Types Triggers, Constraints and Indexes using various DDL and DML commands.
• Schedule Package using SQL Server Job for weekly/monthly basis.
• Create Joins to Improve the Database and execution speed.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.

Confidential

MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Processed data by using BCP commands.
• Generating drill-down, drill-through and parameterized reports.
• Development of T-SQL Stored procedures, User Defined Data Types Triggers, Constraints and Indexes using various DDL and DML commands.
• Used transformations like Derived Column, Conditional Split, Lookup's and sort and execute SQL Task to load data into Data Warehouse.
• Worked with Parameterized and action reports.
• Hands on Debugging, Error Handling and Deploying the SSIS packages.
• Implemented indexes for performance tuning.

Confidential

MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Processed data by using BCP commands.
• Created stored procedures to retrieve the data from database
• Wrote Stored Procedures and triggers to capture inserted, deleted and updated data.
• Used table variable, recursion concepts while creating the stored procedures.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Created parameterized, drill down, and aggregated reports in MS SQL environment using SSRS.
• Designed SSRS reports like Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.