SUMMARY

• Highly motivated Business Intelligence professional with Seven (7) years of experience in design, development & analysis of SQL Server 2008/2005/2000 and SQL Server Business Intelligence tools (BIDS) - SSIS, SSAS, SSRS.
• Profound knowledge and ability to write stored procedures, views, indexes, triggers as required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Experience in data migration from Oracle/Access/Excel Sheets/Flat Files to SQL Server databases.
• Have migration experience with DTS to SSIS 2005.
• Well-versed in usage of SSIS Control Flow items(For Loop, Execute package/SQL tasks, Script task, Send mail task, For loop container, For each loop container, Sequence container) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Merge, Multi cast, Derived column, Character map, Union all, Sort, Row count, OLEDB command).
• Experience in Data Extraction, Transforming and Loading using various tools such as SSIS, DTS, Bulk Insert and BCP.
• Experience in writing VB.Net and C# for Script task.
• Experience in enhancing and deploying SSIS Packages from development server to production server.
• Experience in designing and developing reports using SSRS with Report Builder.
• Expertise in developing parameterized, drill down, click through, chart, matrix, Ad-Hoc, sub reports using SSRS from OLAP or OLTP.
• Experience in using variables, expressions, functions for the reports and in handling parameterized reports in SSRS.
• Created stored procedure for generating reports using SSRS.
• Assisted in creating the MDX queries to access cube and dimensions SSAS.
• Excellent knowledge in Data Warehousing Concepts, Normalization, Dimensional Data modelling, Star Schema/Snowflake Schema, Fact and Dimension tables.
• Hands on experience in performance tuning, query optimization, and database optimization.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server.
• Experienced using T-SQL in SQL Server platform.
• Experience in creating and updating clustered and non-clustered indexes to keep up the SQL Server Performance.
• Hands on experience in performance tuning, query optimization, and database optimization.

TECHNICAL SKILLS

Languages: T-SQL, C++, C#, PL/SQL, XML, HTML, VB .NET, Visual Basic 6.0

Database: MS SQL Server 2008/2005/2000 , Oracle, MS-Access 2003

ETL Tools: SQL Server Integration Services(SSIS), Data Transformation Services(DTS)

OLAP/ Reporting Tools: SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS), Report Builder, Crystal Report

Operating System: Windows Server 2003, Windows XP/ 2000/ NT, Linux, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

SQL SSRS/SSIS Developer

Responsibilities:

• Creating complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2008.
• Coordinating with business users in gathering business requirements and translating them to technical specifications.
• Creating SSIS packages with control flow tasks like for loop, for each loop and sequence container, execute task, mail task, and data flow task like derive column, row count, data conversion, conditional split and aggregate.
• Creating SSIS packages for file transfer from one location to the other using FTP task and designing SSIS packages to extract data from flat files, Excel spreadsheets, and Access.
• Configuring SSIS packages using package configuration wizard to allow Packages run on different environments.
• Scheduling the SSIS packages using SQL Server Agent Services.
• Creating datasets inT-SQL, stored procedures forSSRS.
• Creating multiple parameterized stored procedures which are used by the reports to get the data.
• Designing and developing parameterized reports, linked reports, interactive sorting reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Generated reports using SQL Server Reporting Services (SSRS) with Report Builder 3.0 as well as with Crystal Report 8.0.
• Scheduling the subscription reports using subscription report wizard.
• Preparing reports for the day-to-day as well as weekly/monthly purposes.
• Creating complex SSAS cubes with multiple fact measures groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Involved in designing and developing data models using multidimensional data cube OLAP.
• Creating jobs performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Creating usage based aggregations in cube to minimize time for query retrieval.
• Working on performance tuning to test the Query Execution.

Environment: Microsoft SQL Server 2005/2008, Visual Studio 2010/2008, Windows Server 2003, T-SQL,Visio, MS Word, Excel, BIDS SSIS/SSAS/SSRS, Report Builder 3.0, Crystal Report 8.0

Confidential, Lake Zurich, IL

SQL Server BI Developer

Responsibilities:

• Involved in creating functional and technical specification documents after gathering requirements from business users.
• Created database objects like tables, views, stored procedures, functions, joins, indexes and triggers in T-SQL based upon the functional specifications.
• Designed and developed data models (physical/logical data models) based on the given specs.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code and optimized.
• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules.
• Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Designed and Developed Reports using Report Builder to easily generate reports by the user.
• Involved in data integration by identifying the information needs within and across functional areas worked various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task, For each loop container.
• Deployed SSIS package on the server and scheduled the packages using SQL Server Agent Services.
• Worked in end to end testing of the packages and validated the data after each load.
• Designed, developed and deployed different reports like Matrix and Tabular reports with Top N, Cascaded, Parameterized, and pie chart reports using SSRS with Report Builder.
• Generated multiple reports from SQL Server Database (OLTP) and multidimensional data model OLAP.
• Involved in Designing, Building the Dimensions, cubes with star schema using SSAS for analyzing purpose.

Environment: MS SQL Server 2005/2008, Business Intelligence Development Studio (BIDS), SSAS, SSRS, Report Builder 2.0 MS Access, EXCEL, SQL Server Profiler, Windows Server 2003

Confidential, Saddle River, NJ

SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Created Stored Procedures, Triggers, Cursors, Indexes, functions, views.
• Designed SSIS Package for extracting data from heterogeneous source systems, transform and finally load into the data marts.
• Performed data cleansing techniques using look ups and conditional splits.
• Used various transformations such as Multicast, Merge Join, Lookup, Aggregate, Derived Column, Slowly Changing Dimension, Fuzzy Lookup, and Data Conversion transformations.
• Created packages with several Transformations in each Package making sure that the data is cleaned and confirmed before being sent to the Staging Area.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, guided team for the transformations.
• Created event handlers on every executable in an SSIS package.
• Performed Index tuning for tables and used scan and seeks for performance tuning.
• Updated existing and created new reports using SQL Server Reporting Services.
• Built SSRS project to generate reports with desired formats (Word, PDF, Excel and etc.) to present statistics information according to business requirement.
• Involved in full life cycle development of data mart and supported the existing BI platform for populating the data warehouse.
• Designed OLAP model based on Dimension and Fact tables for efficient loads of data which were based on Star Schema structure on levels of reports.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on SSAS.
• Created perspectives, partitions, drill through actions and KPIs to enhance Cube’s utilization.

Environment: MS SQL Server 2005/2008, SQL Server Business Intelligence Studio SSIS/SSRS/SSAS, MS Access, Excel, VisioWindows NT, Windows XP/2003,SQL Profiler, SQL Query Analyzer, T-SQL, MS Office.

Confidential, New Jersey

SQL ETL Developer

Responsibilities:

• Created various Table and Views, Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for application.
• Transformed the complex business logic and calculations into coding.
• Created and updated clustered and non-clustered indexes to keep up the SQL Server performance.
• Transformed data from various data sources like MS Access, MS Excel, and Oracle using OLE DB connection by creating various ETL packages.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Created a logical design and physical design of the data warehouse using star schema.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Experienced with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Designed and developed data source view, Ad-hoc reports and other reports using SSRS with Report Builder.
• Created List reports, Standardized Reports, On-Demand Reports, Cross tabs Reports, Drill-down Reports, Ad hoc Reports, Charts, Functions and Formulas.

Environment: SQL Server 2008/2005, Enterprise Edition, SSAS, SSIS, SSRS, T-SQL, MS Office 2003/2007, T-SQL, Report Builder 3.0

Confidential

MS SQL Server Developer

Responsibilities:

• Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity.
• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
• Migrated DTS packages of SQL Server 2000 to SQL Server 2005 to make them reused in new environment.
• Optimized SQL queries for efficiency and assisted the front end developer with their queries and procedures.
• Performed performance tuning by studying execution plan, analyzing indexes and using SQL Profiler.
• Established joins and created indexes to assimilate client information from multiple tables.
• Involved in resolving Dead Lock issues and Performance Issues.
• Involved in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services, DTS, Bulk Insert and Bulk Copy Program utility.
• Transforming and validating data using SSIS transformations for unstructured and redundant data.
• Proficiently created Reports based on the requirements using SSRS.
• Created stored procedures and queries to extract data from relational data base by using data models.
• Identified the database tables for defining the queries for the Reports.
• Defined parameters for parameterized Reports.
• Created reports with the Subscription Report wizard using SSAS.
• Excelled in deployment and generation of Reports.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.

Environment: Windows server 2003, MS SQL Server 2005, SSIS, SSRS, DTS, VBScript, Erwin, Crystal Report 8.0

Confidential

MS SQL Server Developer

Responsibilities:

• Worked as a developer on databases MS SQL Server 2000, MS Access.
• Used DTS, T-SQL, scripts, stored procedures and views to run routine reports.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Maintained a good client relationship by communicating daily status and weekly status of the project.
• Writing stored procedures and triggers extensively and working very closely with developers, business users.
• Designed and developed the databases.
• Created a logical design and physical design of the data warehouse using star schema.
• Configured the DTS packages to run in periodic intervals.
• Extensively worked with DTS to load the data from source systems.
• Managed requests that came from the client as well as the development teams.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, and Indexes.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Managed and monitored system utilization.
• Created Logins and Roles with appropriate permissions.
• Designed stored procedures and triggers for automating tasks.

Environment: MS SQL Server 2000, MS Access, Excel, T-SQL, Query Analyzer, DTS, BCP, SQL Profiler