SUMMARY:

• Over 8+ years of MS SQL Server Development experience in Finance, Manufacturing & Distribution, Telecommunications and Health Insurance domains with expertise in MS SQL Server 2000/2005/2008/2012 and Microsoft’s suite of products like SSIS, SSAS, and SSRS.
• Experienced in Creating, Configuring and Fine - tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008 and MS SQL Server 2005 respectively.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• High expertise in creating Reports of all types in SSRS, like Ad-hoc Reports, Drill-Down Reports, Drill-Through Reports, parameterized Reports, Pivot and Tabular Reports based onclient requirement.
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008/2005.
• Expertise in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects.
• Adept in defining d relationships and calculated members in SSAS and used MDX queries.
• Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL coding, Performance Tuning and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
• Extensive knowledge in developing and implementing Disaster Recovery Model, and Replication Models.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS:

• MS SQL Server 2012/2008/2005/2000, MS Access, SQL
• Transact-SQL (T-SQL), PL/SQL, XML, MS
• SQL Server Integration Service (SSIS), MS SQL Server Analysis Services (SSAS)
• MS SQL Server Reporting Service (SSRS), SQL Profiler, SQL Query Analyzer
• MS SQL Server Index Tuning Wizard, Visual Studio 2005/2008/2010, SharePoint
• DTS SQL Developer, ERWIN, Microsoft Visio, Crystal Reports 8.5,Report Builder
• Adobe Photoshop 7.0/CS5/CS6, Adobe Flash
• Windows Server- 2003/NT/XP/2000, Surround SCM Client, Team Foundation Server (TFS).

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

MS SQL BI Developer/ ETL Developer

Responsibilities:

• Extensively involved in creating SSIS Packages to migrate data from various sources and loading them into SQL Server Database.
• Played major role on production support (operations) running and scheduling jobs, backups, cube refresh and so on.
• Handled day to day Service Requests (SR) and escalations (user requests) coming from end users/customers.
• Used C# scripts to map records between CRM and Legacy database.
• Involved in SSIS Package creation from package design documents to package build.
• Involved in Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated.
• Performance tuning of stored procedure, SSIS Packages and reports.
• Wrote complex Join queries using T-SQL.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Created Test packages to validate the SSIS packages build.
• Created and modified Stored Procedures, Functions, and Indexes.
• Experience in configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
• Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes.

Environment: MS SQL Server 2012, SQL server Reporting Services 2012, SQL Integration Services 2012, MSRA, MS Excel, T-SQL, TFS, Visual Studio 2010.

Confidential, Wayne, NJ

Business Intelligence, ETL/SSRS Developer

Responsibilities:

• Experience in configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
• Expertise in generating reports using MS Reporting Services 2008R 2/2008/2005.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Experience in writing VB scripts for user define functions in SSRS.
• Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Excellent command on subscriptions, report snapshot and report cache.
• DesignedSSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access; transform them and then load intoDimension and Fact tables in Data Warehouse using SSIS.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Developed SSIS packages using for each loop inControl Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
• Involved in dealing with off short team
• Created and modified Stored Procedures, Functions, and Indexes.
• Designed and developed SSIS packages, Stored Procedures, Configuration Files, Tables, Views, Functions, and implemented best practices to maintain optimal performance.
• Optimizing query performance with the help of Execution Plan and SQL Profiler.
• Created and scheduled Jobs using SQL Server Agent
• Used Event Handlers for Exception Handling in SSIS packages.
• Developed dependent, dynamic menu objects to allow end-users selection and data filtering capabilities.

Environment: MS SQL Server 2008 R2, Oracle 11g, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, Visual Studio 2005, Erwin, and SQL Profiler, Actuate Report, MS Visual Basic.

Confidential, Rockville, MD

MS SQL Server Developer/SSIS and SSRS

Responsibilities:

• Migrated reports that were built in Actuate Reporting System to SSRS using VB Scripts.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table.
• DesignedSSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access; transform them and then load intoDimension and Fact tables in Data Warehouse using SSIS.
• Developed SSIS packages using for each loop inControl Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports.
• Wrote complex SQL queries and stored procedure to create reports using SSRS 2008 from the relational database.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2008.
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports.
• Configured the report server and generated the report models for user interactions.
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, Microsoft Visual Studio, Microsoft Visual Basic, Oracle 11g, SQL Server Management Studio, MS Excel, T-SQL,ERWIN, Photoshop 7.0.

Confidential, Brisbane, CA

MS SQL Server Developer/SSRS/SSAS

Responsibilities:

• Worked closely with business unit(s) to understand key business drivers and then identify the individual business metrics and key measures that support them.
• Worked with management to develop strategies to support company needs.
• Resolved data conflicts and inappropriate use of data.
• Wrote complex SQL queries using joins, stored procedures, and user defined functions to verify the data from the database to generate reports based on the business requirement.
• Utilized SSRS reports from different source formats satisfying clients by representing reports and presentations.
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized report, ad-Hoc and parameterized reports using SQL server 2005 reporting Services.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Administrated and scheduled mailing subscriptions on SSRS reporting server.
• Structured conditional formatting logic to control components behavior and appearance.
• Produced parameter driven matrix, sub-reports and integrated report hyper-link functionality to access external applications.
• Customized SQL queries to create RDL Datasets and create SQL reports.
• Created Tabular and Matrix Reports with all aggregate functions and expressions.
• Created dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
• Created SSRS Data Model projects using Microsoft Visual Studio 2005 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users

Environment: SQL Server 2005, SSRS, SSAS, T-SQL, SSMS, BIDS, Visio, Excel 2003, SharePoint.

Confidential, Southfield, MI

BI Developer/SSRS Developer

Responsibilities:

• Gathered requirements about the project which was used to create the SSIS 2008 packages.
• Wide knowledge of ETL architecture, data schemas and SSIS packages
• Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).
• Orchestrated, developed and deployed the SSIS packages using SSIS 2008 as the ETL tool.
• Used Package configurations, Variables and Expressions while creating the SSIS packages.
• Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the data flow from one stage to other.
• Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2008.
• Used SQL server agent to automate the SSIS package execution.
• Responsible to create test cases and performed system testing for the SSIS packages using SSIS 2008.
• Made various report parameters and query parameters to create parameterized reports using SSRS 2008.
• Created reports having actions like URL and bookmarks which helped to easily navigate through the report using SSRS 2008.
• Implemented caching of reports and managed the report history in the Report Manager.
• Performed complex Expressions to create calculated fields and used Global Variables in SSRS 2008.
• Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Created stylish reports and implemented conditional formatting using SSRS 2008.
• Deployed and managed the reports in the Report Manager using SSRS 2008.
• Wrote complex stored procedure, views using T SQL in Management Studio.
• Optimized the queries for efficient data retrieval by implementing indexes on the tables.

Environment: SQL Server 2008 Enterprise Edition, SSIS, SSRS, T-SQL, Windows NT.