SUMMARY

• Over 7 years of IT Professional experience in Development, Database Design, Client Analysis and Presentation using SQL Server 2008/2005/2000 with expertise in SSRS (Reporting Services), SSIS (ETL) and SSAS (Analysis Services).
• Developed Drill through/down, Cross - Tab, Cascading parameterized reports using SQL Server Reporting Services (SSRS) and deploying them using web applications onto the web servers.
• Experienced in defining Query for generating Drill down Reports and handling Parameterized Reports in SSRS and sorting the data, defining subtotals for reports and designing report layout.
• Created various interactive Reports for Managers that accepts parameters to filter data and display information based on selected input.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate Functions, and effective Triggers to facilitate efficient data manipulation and data consistency.
• Work experience in various industrial sectors such as Financial, Banking, Medical and Insurance Services.
• Experienced in TSQL (DDL,DML), documenting, coding, programming, modifying and implementing Business Intelligence solutions using SQL Server 2000/2005/2008 .
• Experience in designing Database Models using Microsoft Visio and Erwin.
• Expert in using tools like SQL Profiler, Execution Plan, and Windows Performance for monitoring and tuning MS SQL Server performance.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS) and SQL Server Analysis Services (SSAS).
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, and BCP.
• Experience in loading a flat file, Excel file using Import-Export Wizard.
• Experience in Importing/Exporting Data from various data source like Excel. Oracle, DB2 and Flat file using SSIS.
• Expert in migrating of databases from older versions of SQL Server to SQL Server 2008.
• Experienced in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experienced with all the phases of Software Development Life Cycle (SDLC) and Quality procedures and standards while executing projects.
• Ability to efficiently perform in a team and individually without supervision.
• Multi-tasking analytical thinker with the ability to work on fast paced work Environment.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000/7.0
• Oracle 9i
• MS Access 97/2003
• DTS (Data Transformation Services)
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• Report Designer
• Crystal Reports 9
• MS Enterprise Manager
• SQL Profiler
• SQL Query Analyzer
• OLAP Services
• SQL Agents
• SQL Alerts
• SQL Jobs
• SQL Mail
• ER-Studio
• C
• C++
• MS Visio
• XML
• T-SQL
• PL/SQL
• XHTML
• CSS
• Visual Basics MS Office
• ASP
• ASP.Net
• Visual Studio
• Windows 9x//NT/2000/XP.

PROFESSIONAL EXPERIENCE

Confidential, Boston MA

Business Intelligence(SSIS/SSRS) Developer

Responsibilities:

• Participated in Software Development Life Cycle, involved in requirement gathering from the Business Analyst and preparing the Requirement Specification Document
• Created Tables, Indexes, Views, Stored procedures, Triggers and Functions using SQL Server 2008R2.
• Created SSIS packages for ETL purpose and Data Ware house build using proper Control Flow and Data Flow elements to achieve performance.
• Developed and implemented Error handling logics and Restart ability of the Package in order to handle bad data and avoid redundancy and package failures.
• Designed SSIS Packages to transfer data from various data sources like File system, Excel Access and other relational database management systems to SQL Server using Business Intelligence Development Studio.
• Involved in writing complex Stored Procedures and Fine tune complex SQL queries and Stored Procedures to increase performance.
• Worked on all types SSIS configuration, Check Points, Implemented Auditing within the ETL processes and deploying the Packages to file system and SQL Server.
• Designed, Developed and Deployed reports such asTabular Reports, Matrix Reports, Parameterized, Drill down, Adhoc and Sub-reportsusingReport DesignerandReport Builder3.0 and Generated Reports using Global Variables, Expressions and Functions using SQL Server Reporting Services of BIDS.
• Responsible for scheduling Reports using subscription services of SQL Server Reporting Services.
• Created T SQL Queries to fetch complex data from different tables in remote databases using joins, Views, Store Procedures for Data Source query in SSIS and SSRS.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Applied various data transformations like Merge Join, Look Up, Merge, Union All, Multicast, Data Conversion, Slowly Changing Dimensions, BDD, Aggregate, Sort, Derived column, Multicasting, Conditional Split.
• Merged data from multiple data sources into SQL Server 2008 by creating SSIS package in BIDS.
• Generated Reports with Grouping, Sorting and Formatting using Report items to display data in different formats and deploying them using Reporting Services Configuration Manager of Microsoft SQL Server 2008 R2.
• Managed the historical data (Type1 and Type2) in the data warehouse from various data sources.
• Improved Performance of SSIS package by choosing suitable control flow and Data flow Tasks for better performance.

Environment: MS SQL Server 2008 R2, Business Intelligence MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), visual studio 2008, MS Visio, Microsoft Visual Source Safe, Microsoft Office 2007, Visual Web Developer 2010.

Confidential, Chicago, IL

MS SQL SSIS/SSRS Developer

Responsibilities:

• Creates extracts for Market and Credit Risk Management by enriching positions with Market data (Bloomberg, Fitch, S & P and Moody).
• Created various interactive Reports for Market and Credit Risk Managers that accepts parameters to filter data and display information based on selected input.
• Developed Drill through/down, Cross-Tab, Cascading parameterized reports using SQL Server Reporting Services (SSRS) and deploying them using web applications onto the web servers.
• Designed, Developed and Deployed reports such as Tabular Reports, Matrix Reports, Parameterized, Drill down, Ad hoc and Sub-reports using Report Designer and Report Builder 3.0 and Generated Reports using Global Variables, Expressions and Functions.
• Participated in Software Development Life Cycle, involved in discussion with business requirements and implement them using MS Visio 2007.
• Creating Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
• Created Report Models to assist Report Builder using Report Model Designer
• Responsible for scheduling Reports using subscription services of SQL Server Reporting Services
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder
• Developed Database Triggers to enforce Data Integrity and additional Referential Integrity.
• Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Designed SSIS Packages to transfer data from various data sources like File system, Excel and Access to SQL Server using Business Intelligence Development Studio.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Applied various data transformations like Slowly Changing Dimensions, Aggregate, Sort, Derived column, Multicasting, Conditional Split.
• Merged data from heterogeneous data sources into SQL Server 2008 by creating SSIS package in BIDS.
• Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
• Used SQL Server 2008 to design, implement and manage data warehousesOLAPcubes.
• Managed the historical data in the data warehouse from various data sources.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.

Environment: MS SQL Server 2005/2008, Business Intelligence MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), visual studio 2005, MS Visio, Share Point Server (MOSS) 2007.

Confidential, Little Rock, AR

Business Intelligence Developer

Responsibilities:

• Installed and configured SQL Server Reporting Services (SSRS) 2008.
• Created stored procedures and T-SQL Queries to create Tables, Views, and triggers and stored Procedures and tuned the existing Stored Procedures.
• Developed Drill through/down, Cross-Tab, Cascading parameterized reports using SQL Server Reporting Services (SSRS) and deploying them using web applications onto the web servers
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
• Created Report Models to assist Report Builder using Report Model Designer
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Designed and implementation of stored procedures and triggers for automating tasks.
• Developed SQL Server Stored procedures and DTS packages to extract data from database.
• Implemented constraints on tables.
• Generated queries to Drill Down Reports and handling Parameterized Reports in SSRS. Sorted the data, defining subtotals for reports and designing report layout.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment
• Responsible for scheduling Reports using subscription services of SQL Server Reporting Services to run daily and on weekly basis.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into Reports.
• Provided various security standards and subscriptions to report server
• Understanding the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experienced in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experienced in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Lookup, For Each Loop, Multi Cast, column conversion, Audit.

Confidential, New York, NY

MS SQL Server BI/SSIS Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, deployment and user training.
• Designed, developed and tested processes, which include the creation of SQL views, scripts, stored procedures and DTS packages.
• Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
• Developed Drill through/down, Cross-Tab, Cascading parameterized reports using SQL Server Reporting Services (SSRS)
• Responsible for defining Queries for generating Drill Down Reports and handling Parameterized Reports in SSRS and sorting the data, defining subtotals for reports and designing report layout.
• Created Report Models using Report Model Designer.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
• Extracted data using Query Analyzer and DTS packages.
• Tuned and optimized SQL statements, stored procedures and views.
• Wrote complex SQL queries and could quickly understand requirements for complex queries and procedures.
• Created DTS packages for transforming data from various data sources.
• Fine tune complex SQL queries and Stored Procedures to increase performance.
• Suggested creating Clustered and Non Clustered indexes on tables
• Used DTS for data population from different sources and create DTS packages for data conversions and load data from flat flies or excel files.

Environment: MS SQL Server 2000/2005/2008, ETL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) DTS, T-SQL, MS Office Components, Microsoft Visio Studio.

Confidential

SQL/.Net Developer

Responsibilities:

• Wrote SQL scripts to Insert/Update and Delete data in MS SQL database.
• Developed Web Forms using ASP.NET and C#.
• Implemented the project using n-tier architecture with presentation tier (ASP.NET),
• Business Tier (C#) and backend database tier (SQL Server).
• Configured the Web.Config file for Authentication, Session, and Trace.
• Used ADO.NET Connection, Command, Datasets, Data Adapter, Data Reader and XML to retrieve and store the data in SQL Server 2000.
• Created Web User Controls and Custom Controls.
• Created Stored Procedures and triggers for automated operations.
• Consumed Web Service Successfully.
• Created Tables, Views, Indexes and Relations using SQL Enterprise Manager.
• Used Visual Studio.NET debugger and ASP.NET trace functionality to debug the application.
• Used Visual Source Safe for version control and history during development.
• Involved in reporting using Crystal Reports.

Environment: MS SQL Server 2000, T-SQL, Microsoft Visual Studio 2003/2005, Oracle 9i, MS ExcelMS Access 2000, Windows NT.