PROFESSIONAL SUMMARY

• 7+ years of IT experience in Data Design and Development on Microsoft SQL Server 2008R2/2008/2005/2000, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
• Experience in using Business Intelligence tools (SSIS,SSAS,SSRS) in MS SQL Server 2008
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2008/2005/2000/7/6.5.
• Great ability to create and manage various database objects like tables, views.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Experienced in using ETL tools in (SSIS) MS SQL 2008,MS SQL 2005 and DTS in MS SQL 2000
• Hands on experience in using ProClarity to browse cubes, create views and books.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Experience with logical and physical data modeling and database design using Erwin.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in modifying MDX Cubes and Dimensions in SSAS.
• Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS

SQL Server Tools

Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server 2008,SQL Server 2005 Management Studio, DTS, SSIS, SSRS, iReports and SSAS

Database

MS SQL Server 2008R2,2008,2005, 2000, 7.0, MS-Access

Language

C , C++, T-SQL

Operating System

Windows XP/NT/2000, DOS, Windows Server 2003

Tools

Erwin, Microsoft Visual Studio 2008/2005,Share Point Server 2007, Microsoft Project Server 2007, ProClarity

Architecture

Relational DBMS, Client-Server Architecture, OLAP, OLTP

Reporting Tools

SSRS (SQL Server Reporting Services), Crystal Reports

ETL Tools

SSIS (SQL Server Integration Services), DTS

PROFESSIONSL EXPERIENCE

Confidential, Fort Lauderdale, FL Feb 11 – Till Date 
SQL Server (SSIS/ SSRS/ SSAS) Developer

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Implemented the logical and physical design of the data warehouse using Erwin.
• Created OLAP databases with Kimball Methodology and star/snow flake schemas.
• Created Complex queries, stored procedures using temporary tables, joins and sub queries.
• Implemented Error Handling in Stored Procedures using Try and Catch,@@error and Raiserror.
• Used Analytical functions, Merge and CTE’s in Sql Server 2008
• Created SSIS packages for loading of different formats of files (Excel, flat file) and databases (SQL server) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
• Created SSIS Packages to load data from Oracle to Sql Server Database
• Used Script task to write custom code using Vb.net
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
• Implemented Error Handing and Logging for packages using SSIS 2008
• Created SQL Jobs to schedule SSIS Packages
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Created SSIS packages to migrate data from Oracle to SQL Server 2008
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Written sql queries and used as source to generate SSRS reports
• Creating Reports as per user requirements using SSRS 2005/2008
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through,
• OLAP and Sub reports, and formatting them using both SSRS 2005/2008
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables
• Created data driven subscriptions for different users using SSRS Report Manager.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Environment: MS SQL Server2005/2008, Team Foundation Server, Microsoft SharePoint Server(MOSS 2007), Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2005, T-SQL,VB.Net

Confidential, Oakbrook terrace, IL Jun 09 - Jan11 
MS SQL Server/BI Developer (SSIS/SSRS/SSAS)

• Created mapping tables to find out the missing attributes for the ETL process.
• Used the row count transformation and event handlers control flow to populate the special
• Log tables with high level SSIS package execution results
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server Database.
• Developed Complex queries in sql that are used by front end applications
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Created SQL Jobs to schedule SSIS Packages
• Created Triggers, Views for Audit and security purposes.
• Created different types of User-defined functions.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
• Build efficient SSIS packages for processing fact and dimension tables with complex
• Transforms and type 1 and type 2 slowly changing dimensions.
• Hands on experience in using different transformations like fuzzy lookup, derived column
• Transformation etc. using SSIS.
• Integrated SQL Server 2008 reporting services with MOSS (Microsoft Office Share Point Server) to automatically deliver reports to the Share Point portal.
• Created report snapshots to improve the performance of SSRS.
• Improved the accuracy of the source data by implementing data validation on the source
• Data for reporting
• Created subscriptions in SSRS to deliver reports to a shared file.
• Implemented logical and physical modeling using ERWIN data modeler
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub
• Reports using SQL Server Reporting Services 2008
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Involved in migration of crystal reports to SSRS 2008.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Used Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping and created various dynamic reports using SSRS.
• Developed T-SQL queries and stored procedures with multiple parameters to created data
• Sets for reports
• Worked with MDX to query cube’s data.
• Created new cubes and modified existing cubes using SSAS 2008 to make data available
• For the decision makers
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Designed reports and tuned them for optimal performance when using multiple
• Parameters
• Used Report Manager to assign roles, permissions and to create report schedules.

Environment: SQL Server 2005/2008,Microsoft SharePoint Server (MOSS), T-SQL, SQL Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL, MDX, Erwin, SQL Profiler, MS Excel 2003, MS Visio, Visual Studio 2008-2005.

Confidential, Freehold, NJ Mar 08 – Jun 09
SQL Server (SSIS/SSAS) Developer

• Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2005.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
• Used Lookup Transformation to get the data from reference data sets
• Migrating SQL Server 2000 databases into SQL Server 2005.
• Created Cubes and used basic MDX to retrieve the result set for Calculations.
• Worked on advanced dimension Design and Cube design.
• Used MDX to define KPI’s, calculated members in the cubes.
• Created partitions of the Analysis Services cube to improve performance.
• Conducted Data Analysis and did Data Modeling and Created the ER diagrams using Logical Schema and Star Schema.
• Generated ad-hoc reports using MS-Excel and Crystal Reports.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.

Environment: SQL Server 2005/2008, SSIS, VBScript, XHTML, XML, MS SQL Query Analyzer, SQL Profiler, SQL Crystal Reports, MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), MS SQL Server Analysis Services(SSAS).

Confidential, New York, NY Nov 07 – Mar 08
SQL Server Developer

• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Worked with data extraction using SSIS and Data Warehouse staging, and loading.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing the calculations to aggregate physical measures.
• Developed reports that deliver data from cubes.
• Created and managed subscriptions for the reports.
• Defined specific read/process permissions for the users in SSAS instance.
• Implemented user based security in SSRS reports to limit the access of reports.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions and Responsible for defining calculated members
• Created SSIS packages to move data from oracle to SQL Server which involved using
• Various transformations, developing SQL queries

Environment: SQL Server 2005 / 2000(2003, 64 bit edition of SQL server 2000), SharePoint, DTS, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS

Confidential Feb 04 – Oct 07
SQL Developer

• Interacted with the users for understanding and gathering business requirements.
• Involved in the analysis, design, development, testing, deployment and user training of
• Analytical and transactional reporting system
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the
• Database and other applications in the most efficient manner and created stored
• Procedures for the business logic using T-SQL
• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such that they perform well.
• Used indexes to enhance the performance of individual queries and enhance the stored Procedures
• Managed all indexing, debugging, optimization and performance tuning using SQL Profiler and SQL Server Agent.
• Designed, developed, and tested stored procedures, views and complex queries for Reports distribution
• Developed database triggers and stored procedures using T-SQL cursors and tables
• Effectively used views to prevent unauthorized access
• Tuned SQL queries using execution plans for better performance.
• Created DTS packages for transforming data from various data sources.
• Used Query for ad hoc Reports and Users design Custom Queries.

Environment: MS SQL Server 7.0/2000, Windows 2000/NT/XP, DTS, Query Analyzer, SQL Profiler and Enterprise Manager