SUMMARY

• 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008/2008R2/2012 across health care, Banking, medical consumer goods and Transportation domains.
• Expertise inSQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS).
• Expertise in writing T - SQL Queries using joins, Sub queries and Cursors in MS SQL Server 2008/2012.
• 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 Monitoring and Tuning MS SQL Server databases with tools like Index Tuning Wizard, SQL Pro filer, and Windows Performance Monitor for optimal Performance.
• 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.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in managing and automating control flow, data flow, events and logging for SSIS packages.
• Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques.
• Experience and understanding ofSSAS, OLAP cube and Architecture.
• Understanding OLAP process in SSAS for changing and maintaining the Warehouse, Optimizing Dimensions,Hierarchies and adding the Aggregations to the Cube.
• Extensive experience in developing reports and deploying reports in SSRS using Report Wizard, Report Builder and Report Manager.
• Experience in designing stylish report layouts including Tabular forms, Matrix (Cross /tab Report) form, ad-hoc, Conditional, Drill down, parameter, cascading parameters, Charts and Sub Reports.
• Experience in enhancing and deploying the SSRS Packages.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Experience includes Creating Reports from Web Services and using MDX on Cubes in SSAS to create reports in SSRS.
• Support Experience in Microsoft Team Foundation Server (TFS) to allow for a secure code, SSIS Packages and Reports and use as a repository in order to compare modified and unmodified code.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Strong leadership, interpersonal, communication, and project management skills.
• Strong troubleshooting and problem solving experience in a complex environment.
• Proven ability to work in both independent and team environments.

TECHNICAL SKILLS

Database Tools: SQL Enterprises Manager, SQL Pro filer, Query Analyzer SQL Server setupSecurity Manager, Service Manager, SQL Server Analysis Services (SSAS).

ETL Tools: Data Transformation Services (DTS), SQL Server 2008/2008R2/2012Integration Services (SSIS), Import export data, Bulk insert, BCP

Data Modeling Tools: ERWIN 7.3, Power Designer 12.5, ER Studio 8.0.1, MS Visio 6.0

Programming Language: T-SQL, PL/SQL, C, HTML, and XML

Reporting Tools: SQL Server Reporting Services (SSRS), SSAS

Databases: MS SQL Server 2012/2008/2005 , Oracle 10g/9i/8i, MS Access

Operating Systems: Windows, UNIX Solaris

PROFESSIONAL EXPERIENCE

Confidential - Jacksonville, FL

Sr. T-SQL/SSRS/SSIS Developer

Responsibilities:

• Designed and Developed SSIS Packages to import data from Oracle database in the form of flat files transform and load data intoSQLServer database.
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split and many more.
• Worked on Transformation of Data intoSQLServer database by development of views, Staging tables and loading data into tables using Stored Procedures.
• Upgraded SSIS packages for an entire Application from using Project wizard and successfully deployed packages.
• Managed the complete migration ofSQLServer 2008R2 toSQLServer 2012.
• Used SQL Server Agent Jobs for Automating dailySQLjobs and for execution of packages automatically.
• Developed Package labels for test and production environments and execution of SSIS packages automatically.
• Provided organizational reporting and timely reports utilizing SSRS (SQLServer Reporting Services)
• Used SSRS for development of reports for Business users
• Developed different types of reports - Parameterized reports, Drill down reports, Ad- hoc reports, Snapshot reports and Sub reports.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and enabled capability to send excel file as an email attachment
• Developed several database structures, complexSQLqueries, stored procedures, views, triggers and user-defined functions.
• Worked as Support team member for Microsoft Team Foundation Server (TFS) to allow for a secure code, SSIS Packages and Reports and use as a repository in order to compare modified and unmodified code.
• Updated Package Configurations of entire database from XML Configurations toSQLServer Configurations so as to assist in execution of packages in development, test and production environments.
• Created and scheduled SSIS Jobs usingSQLScheduler,SQLServer Agent for daily, weekly and monthly loads.
• Participated in daily Crum meetings. Discussed with Architect’s regarding the Designs and frame works.

Environment: MS SQL Server 2008/2012, SSIS, OLAP, SSRS, MS Visual Studio 2005, Windows, SOLARIS UNIX OS.

Confidential, St Louis, MO

Sr. BI Developer

Responsibilities:

• Extensively worked on TSQL for creating stored procedures, indexes and functions
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008) which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix reports and other features of reporting service.
• Worked onSSRS2008 to generate about 30+ reports for various user groups and developer groups
• Deployed all the reports to reporting server, Excel & PDF.
• Developed Charts, Pie-Charts, Bar-graphs, series on SSRS
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML file) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for designing the SSIS packages to export data of flat file source to SQL Server Database
• Involved in enhancement of existing SSIS packages.
• Good knowledge in deploying SSIS packages to various environments.
• Implemented in unit testing and created unit test document
• Supported system testing and helped the testing team in execution of SSIS Jobs.
• Used various control flow tasks like FTP, Bulk insert task, Conditional Split, Multicast, Merge task and different data flow tasks.
• Provided many supporting documentation for the project.

Environment: MS-SQL Server 2008/R2 Management studio, T-SQL, MS Excel, Windows-7, SSIS, SSRS.

Confidential - Chicago, IL

BI Developer

Responsibilities:

• Analyzed the client requirements and translate them into technical requirements.
• Performed Installation and Configuration of SQL Server 2008 with latest Service Packs.
• Performance Tuning of SQL queries and stored procedures using SQL Profiler
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS)
• Worked onSSRS2008 to generate about 30+ reports for various user groups and developer groups
• Created stored procedures using T-SQL to use as the datasets for the Report Design.
• Worked with report parameters and performed Parameterized, drill down, drill through, Summary reports, and cascading parameterized reports usingSSRS.
• Created Reports from Web Services and used MDX on Cubes in SSAS to create reports in SSRS.
• Understanding OLAP process in SSAS for changing and maintaining the Warehouse, Optimizing Dimensions,Hierarchies and adding the Aggregations to the Cube
• 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 SQL Server Integration Services (SSIS).
• Designed and built DTS/SSIS packages and ran several scripts for implementing changes in the backend for applications.
• Created SSIS packages for different data loading operations for many applications.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Developed SSIS packages usingLookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columnswith Multiple Data Flow tasks.
• Used Different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing.

Environment: MS SQL Server 2008, MS SQL Server Management Studio, SSIS, SSRS, Report Builder, SSIS, Office, Excel.

Confidential - Columbus, OH

SQL BI /SSIS/SSRS Developer

Responsibilities:

• Involved in gathering of user requirements.
• Involved in physical and logical data modeling using Erwin along with the architects.
• Created stored procedures, triggers, Joins, functions and views.
• Created SQL server Reports using SSRS 2008.
• Identified the data source and built data source views.
• Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized and cascading parameterized reports using SSRS.
• Created Tabular reports, Cross Tab Reports and Sub Reports.
• Understanding complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Created Reports by using MDX on Cubes in SSAS to create reports in SSRS.
• Debugged reports and deployed them.
• Involved in SSRS report deployment and report server configuration.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Enhanced and converted the existing crystal reports across the company to a dynamic, flexible, user friendly parameterized reports using MSBI.
• Scheduled reports to run automatically.
• Generated ad-hoc reports using Report Builder and Created schedules and subscriptions.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.
• Deployed reports to Report Manager and performed Troubleshooting execution errors.
• Worked with Dynamic Management Views (DMV) for improving query performance.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
• Used SQL server agent for scheduling jobs and SQL profiler for database tuning.
• Created and used tables, views, indexes, stored procedures, triggers, used joins to retrieve data from tables
• Worked on Exception handling with @error and with Try/catch and resolving locking/deadlocks.
• Optimized table performance by following the tuning tips like normalization, creating indexes and collect statistics.

Environment: MS SQL Server 2008, SSIS, SSRS, DTS, SQL Management Studio, SQL Server Business Intelligence Tools, Windows 2005, SQL Server Query Analyzer, SQL Profiler.

Confidential - Jacksonville, FL 

SSQL BI/SSIS SSRS Developer

Responsibilities:

• Involved in Installation, Upgrade and Troubleshooting of MS SQL Server 2005.
• Created Complex Stored Procedure, Triggers, and Cursors, Tables, Views and other T-SQL JOIN techniques.
• Designed, Developed and maintained Relational databases.
• Extensively involved with Database Space Management, Performance optimization activities.
• Involved with tracing activities using SQL Profiler.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Moved data from text files to SQL Server using SSIS.
• Scheduled SSIS Packages daily and weekly Basis.
• Extensively involved in knowledge transfer for the documentation team for the development activities carried out by team.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS
• Extensively involved with the development team in carrying out the Unit testing of the applications and tuning of complex procedures.
• Involved in Planning, development, and testing of disaster recovery strategies and procedures to restore the production environment to a production state.

Environment: MS SQL Server 2005, SSIS, SSRS, DTS, SQL Management Studio, SQL Server Business Intelligence Tools, Windows 2003, SQL Server Query Analyzer, SQL Profiler