SUMMARY

• Around 7+ years of strong IT experience as a MS SQL Server 2005/2008 R 2/2012/2014/2016 Developer and BI tools SSIS, and SSRS
• Extensive experience in developing and implementing Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS).
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Hands on experience in transformation of heterogeneous data sources into a variety of SSIS transformations like Aggregate, Derived Column, Data Conversion, Conditional Split, Multicast, Fuzzy Lookup, Union All, Merge Join, Lookup, Slowly Changing Dimension, and Pivot applying ETL concepts.
• Experienced in the complete life cycle of DTS/SQL Server Integration services (SSIS) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL jobs across different servers.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server.
• Experience in developing reports using Report Builder and used Metadata to define Fact & Dimension tables.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS) generated drill down reports, drill through reports, parameterized reports, Cascaded reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.
• Working experience of designing Ad - hoc reports for higher managers using report model, providing them flexibility to create reports using drag and drop functionality.
• An Excellent Team Player with good inter-personal skills, commitment, result-oriented and hard-working attitude with a quest and zeal to learn new technologies.

TECHNICAL SKILLS

Databases: MS SQL Server 2017/2016/2014/2012/2008- R2/2008/2005 Microsoft Access, Oracle 10g/11i, IBM DB2, Teradata

Programming Languages: C, T-SQL, PL/SQL, .Net.

Version tools: Microsoft Visual Studio, Team Foundation Server, Jira, Git-Hub.

Data modeling: ERWIN, BP Win, Microsoft Visio 2013/2010/2007/2005

ETL Tools: SQL Server Integration Services (SSIS) 2015/2012/2008- R2/2008/2005, Data Transformation Services (DTS)

OLAP/ Reporting Tools: SQL Server Reporting Services (SSRS) 2015/2012\2008-R2\2008\2005, SQL Server Analysis Services (SSAS), Power Pivot and Business Objects, BIRST, Power BI.

Management Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SQL Profiler, DB Artisan, Rapid SQL, TOAD

Configuration Management Tools: Team Foundation Server (TFS) 2012/2010/2008/2005

Operating Systems: Windows Server 2003, Windows 2000 advanced server/ Professional, Windows 10/7/ Vista/ XP/ 2000/ 95/ NT

PROFESSIONAL EXPERIENCE

Confidential, New Hampshire

MS SQL SERVER/SSIS/SSRS DEVELOPER

Responsibilities:

• Worked on new reporting tool BIRST for creating templates and Subscriptions for different customers based on the requirements from the customer.
• ETL implementation using SQL Server Integration Services SSIS, Reporting Services SSRS.
• Created user variables, property expressions, script task in SSIS.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Maintained the ALM (Application life cycle management) tool for business level requirements before starting the development.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.
• Created Unit test and regression test scripts to validate the results and created the test cases.
• Wrote complex store procedures and functions
• Worked on TDD (Test Driven Development) for complex scenarios to do the testing in more efficient way.
• Monitoring, Job Scheduling, Troubleshooting, Back Up, recovery and system upgrading through Autosys.
• Experienced in enhancing and deploying the SSIS Packages from development server to production server.
• Created the SSRS reports based on the customer specifications (Standard /Custom reports)
• Worked on Performance tuning for the procedure which run for a longer time.
• Played an active role in Customer support and Production Support.

TOOLS: & TECHNOLOGIES: MS SQL Server 2014/2016, VS 2015, SQL Server Integration Services (SSIS 2019/2015/2013 ), SQL Server Reporting Services (SSRS 2019/2015/2013 ), Power BI, T-SQL, BIRST, ALM, MS Excel, MS Visio, Team Foundation Server (TFS).

Confidential, BLOOMINGTON, MINNESOTA

MS SQL SERVER/SSIS /SSRS DEVELOPER

Responsibilities:

• Played an active role during the requirements gathering, analyzing and designing of the system.
• Worked with Data architect and business users to understand business processes, document project requirements and translate them into functional specifications for BI reports and applications.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the application.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Knowledge of monitoring, logging and cost management tools that integrate with AWS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Highly responsible for development and management of SSRS projects like creating drill through reports through Linked reports.
• Installation, creation of users, Permissions, access and Security Control for various users, migration of all Production reports.
• Deployed SSRS reports into Report manager and managed reports subscriptions, delivery, generation, rendering formats.
• Created individual SSIS packages to load dimensions, fact tables then created ETL Master package to load data in Data mart
• Created SSIS Packages to load each dimensions, Fact tables, Then Configuring packages using XML, SQL Server, Parent package variable methods.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast, Derived column, Data conversions, Merge, OLEDB Command, script task components
• Created scripts and Scheduled SQL jobs to facilitate data processing, monitoring and alerting.
• Automated few of the daily routine tasks, thereby reduced few man hours of effort.
• Involved in the preparation of the unit test case documents and unit testing of the enhanced macro codes, T-SQL queries.
• Prepared detailed document of the know issues for future reference.

TOOLS: & TECHNOLOGIES: MS SQL Server 2014/2016, VS 2015, SQL Server Reporting Services (SSRS 2015/2013), SQL Server Integration Services (SSIS 2015/2013), T-SQL, MS Excel, MS Visio, Team Foundation Server (TFS), AWS.

Confidential, ROCHESTER, MINNESOTA

MS SQL SERVER/SSIS /SSRS/SSAS DEVELOPER

Responsibilities:

• 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 requirements.
• Involved in designing of the data bases and altering schemas of the existing data bases.
• Created the Dynamic ETL’s to Load different Source systems like Excel, Flat file, and Oracle data bases using SSIS.
• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into destination databases for further Data Analysis and Reporting.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on SDLC Servers.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created SSIS Packages to perform filtering operations and to import data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.
• Utilized SSRS reports from different source formats and satisfying clients by representing reports and presentations.
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports and multi parameterized reports.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Produced parameter driven, matrix, sub-reports and integrated report hyper-link functionality to access external applications.
• 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 report server.
• Administrated and scheduled mailing subscriptions on SSRS reporting server.
• Developed functional and technical documentation to assist in the design, development and maintenance environments.
• Created SSRS Data Model projects using Microsoft Visual Studio2013 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users.
• Worked on Integration of Reports into Dashboards, SharePoint Portal
• Created Share Point solution to host SSRS Reports for business members access through web interface
• Created Share Point solution to host BI Monitoring dashboards to indicate job success\failures
• Provided technical support for the clients and Documented changes and Manual that is accessible to end users

TOOLS: & TECHNOLOGIES: MS SQL Server 2012/2008R2/2005, Business Intelligence Development Studio, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Visual Studio 2013, T-SQL, VB.Net Scripting, .Net Framework 4.5

Confidential

MS SQL SERVER/SSIS/SSRS DEVELOPER

Responsibilities:

• Designed SSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access, DB2 and transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.
• Developed SSIS packages using for each loop in Control 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.
• Interact with the Enterprise Data Warehouse team to facilitate and document the data mapping to the Reporting SQL Server environment.
• Involved in Developing, Monitoring and Deploying SSIS packages that included variables, expressions and multiple complex conditional tasks.
• Designed DTS/SSIS Packages to transfer data between servers.
• Used Event Handlers for Exception Handling in SSIS packages.
• 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.
• Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports.
• Provided design, implementation and maintenance for custom reports 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.
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports.
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.

TOOLS: & TECHNOLOGIES: MS SQL Server 2008, MS SQL Server Integration Services (SSIS), MS SQL Server reporting Services (SSRS), SQL Server Business Intelligence Development Studio (BIDS), T-SQL, Visual Studio 2008.

Confidential

MS SQL SERVER DEVELOPER

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Used SQL Server to create stored procedures, views and calling through the application.

TOOLS: & TECHNOLOGIES: MS SQL Server 2008, SQL Server 2000/2005, Visual Studio 2000/2005