Saurabh

Email: ac9bvn@r.postjobfree.com

Phone: 210-***-****

SUMMARY:

Around 6+ years of professional experience in development, implementation and administration of database systems using MS-SQL Server 2014/2008R2/2008 for Data Warehousing Systems applications.

Involved in all the phases of SDLC including Requirements collection, Design and Analysis, Development, and Customization of the application.

Proficient in OLTP, OLAP and Data warehousing Design concepts.

Strong Knowledge of Normalization/De-Normalization and Data Modeling.

Expert in Database Normalization, Optimization, Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.

Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.

Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.

Creating SSIS solutions for ETL and Business Intelligence process for Data Integration and Migration Services.

Experience in High Level Design of ETL - DTS Packages & SSIS Packages - for integrating data from heterogeneous sources (Excel, CSV, flat file, Text Format Data) and using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER-Studio.

Expertise in designing, developing, and deploying several kinds of reports and dashboards usingSSRS using relational and multidimensional data.

Experience in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2016/2012/2008.

Experience in advanced reporting skills using SQL Server reporting services

Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.

Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis.

Proven Power BI development experience with desktop and Pro versions. Familiarity with Direct Query functionality within Power BI.

Knowledge of developing cubes in SSAS and Analyzing Dimensions and Measures.

Skilled at using SSAS extensively for configuring and managing data sources, data source views, dimensions, cubes and mining structures.

Responsible for taking information from all new clients and starting new client files.

Ability to work in environments with fluctuating priorities and deadlines, foresight to handle upcoming issues and dedication to solve complex problems with experience and research.

Organized professional with excellent oral and written communication skills, excellent presentation and interpersonal skills, problem solving skills, and a fast learner who also adapts quickly to new technologies with the ability to take new roles in minimum time with little training.

Technical Summary

Databases Tools

SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Analysis Services (SSAS)

ETL Tools

Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools

SQL Server Reporting Services (2014/2012/2008), Power BI, Tableau

Database

MS SQL Server 2014/2012/2008/2005, MS Access, Oracle, MySQL, EFT File Server

Programming

T-SQL, PL-SQL

Web Technologies

HTML, DHTML

Other Tools

MS Office Suite (Microsoft Word, Power Point, MS Visio), Illustrator, Abode Flash, Mac Office Suite, Rational Rose

Professional Experience:

EARLY WARNING, Arizona, USA Aug 2018 – Present

Role: SQL/MSBI/POWER BI Developer

Organized meetings and JAD sessions to properly communicate business requirements to all the stakeholders involved.

Removed duplicate data utilizing ranking functions and CTE’s in SQL.

Created stored procedures for index maintenance and reporting applications in SQL.

Automated SQL scripts and SSIS package execution utilizing SQL Server Job Agent.

Optimized stored procedures by checking execution plans, indexes, partitions and statistics in SQL.

Created SISS packages to extract, transform, and load data from OLTP servers to newly populated data mart.

Designed packages to cleanse data with fuzzy lookups/groupings, derived columns, and condition splits.

Incorporated master-child package models to improve the performance of the complex ETL strategy.

Implemented CDC incremental load technique to load data on daily basis in Data Mart.

Built Patient Analysis multi-dimensional cube utilizing multiple dimensions, calculations and KPI’s in SSAS.

Created usage-based optimization aggregations and hierarchies to optimize slowly running cube.

Successfully designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Generated different reports such as lab turnaround time, average patient wait time, billing summary in SSRS.

Deployed SSRS reports utilizing SharePoint Integrated mode front- end application for easy access.

Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis.

Proven Power BI development experience with desktop and Pro versions. Familiarity with Direct Query functionality within Power BI.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Environments: SQL Server 2014/2012, T-SQL, Windows 7, SSRS, SSAS, SSIS, Jira, Power BI, MS Visio

Cummins Sales and Service, Indianapolis, USA May 2017 – July 2018

Role: SQL/MSBI Developer

Gathered business requirements and developed detailed BRD (Business Requirement Document) and functional requirements.

Conceptualized the technical specifications document for ETL processing of data into data mart and strategized the integration test plan and implementation.

Formulated SQL scripts for analyzing historical data and extracting required data to support management decisions.

Successfully optimized SQL queries with execution plans to improve reporting performance.

Created ETL strategies utilizing various source adapters, transformations to load data from various sources.

Restarted SSIS packages from point of failure by configuring checkpoints.

Handled run time errors in SSIS utilizing event handlers, precedence constraints and row redirects.

Customized calculations, KPI’s and hierarchies by adding new columns utilizing DAX in SSAS tabular models.

Created row- level security to hide confidential data from group of users utilizing DAX in tabular models.

Assisted in the creation of drill-down, drill-through, cascaded, sub, and parameterized reports in SSRS.

Optimized reports by modifying embedded queries, caching and snapshot in SSRS.

Scheduled on-demand reports for business analysis and management decisions utilizing subscriptions in SSRS.

Deployed Power BI to design interactive data visualization utilizing on-premises/azure data sources.

Shared reports and dashboards to different users/groups utilizing email, apps, content packs in Power BI services.

Implemented key metrices such as un-billed days, net income ratio and client grown in Power BI dashboards.

Incorporated TFS for version control and change management of BI solution for cross-functional communications.

Environment: SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, SSDT, SQL Profiler, Erwin, DTA, Power Map, Power BI

University of Texas at San Antonio Sept 2016 – May 2017

Role: MSBI Developer

Description: As a research assistant at my university I was involved in maintaining student record keeping system database where I have implemented various T-SQL concepts for maintaining database and created packages to perform ETL operations and created various reports using SSRS.

Responsibilities:

Maintained SQL scripts, indexes, complex queries for data analysis and extraction.

Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS.

Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

Imported data from different databases (oracle, MS access etc.), build and scheduled packages, and defined integration flow using SSIS (SQL server Integration Services).

Created ETL (Extract, Transform, and Load) packages to validate and load data.

Designed and implemented parameterized, drill-through, drill-down and tabular reports using SSRS.

Developed crossed reports, sub-reports and matrix in SSRS.

Created complex queries to build the dataset required for developing the SSRS reports.

Implemented/Developed multi parameterized reports using Report Builder and SSRS allowing users to make selections before executing the reports and making it more users friendly.

Environment: MS SQL Server 2012/2014/2016, SSIS, SSRS, SSAS, T-SQL, Windows Server 2008 R2, MS Office 2010, Power BI

Big Basket, Bangalore, India Aug 2015 – July 2016

Role: SQL Server Developer

Description: Big basket is online food and grocery store. My role was to maintaining and updating the various database of products and customers and to create packages to perform ETL operation using SSIS and to create reports using SSRS for better view of the business.

Responsibilities:

Actively involved in different stages of Project Life Cycle.

Actively participated in gathering of User Requirement and System Specification.

Created stored procedures, Triggers, Views, and User Defined Functions to facilitate the automation of data entry by a front-end application.

Optimized SSAS cubes utilizing MOLAP storage mode, hierarchies and aggregations

Created row- level security to hide confidential data from group of users utilizing DAX in tabular models.

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 SSIS/DTS.

Created many drill through, drill down, ad-hoc reports using SSRS.

Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs and deployed into Report server and SharePoint.

Involved in tuning of database by creating efficient stored procedures and T-SQL statements.

Provided assistance to development teams on Tuning Data, Indexes and Queries.

Created Clustered and Non-Clustered Indexes for improved performance.

Optimized the existing queries to improve performance with the use of SQL Profiler and Execution Plans.

Implemented Backup and Recovery of the databases.

Actively participated in User Acceptance Testing and Debugging of the system.

Environment: SQL Server 2012/2014, SQL Server Integration Services, SQL Server Analysis Services, Visual Studio 2008, Excel, Performance Point, Data Analyzer,

Sankhya Technologies, Hyderabad, India July 2014 – Aug 2015

Role: SQL Server / BI Developer

Description: Sankhya Technology deals with manufacturing and transporting aerospace and defense equipments. As a part of this effort I created the product data warehouse and various reports to help better view and understand their business process and implement changes to make it more effective

Responsibilities:

Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.

Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008.

Implemented CDC incremental load technique to load data on daily basis in Data Mart.

Built Patient Analysis multi-dimensional cube utilizing multiple dimensions, calculations and KPI’s in SSAS.

Created usage-based optimization aggregations and hierarchies to optimize slowly running cube.

Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency.

Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot and Un-pivot Transformation

Successfully migrated old data from legacy systems (FoxPro) and external system including excel and oracle into SQL Server 2008 using SSIS Packages

Developed interface stored procedure to upload Insurance Record from XML format to Customer Insurance System

Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end

Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Designed forms, templates & created Reports using SSRS 2008 reporting services.

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Performed Unit testing for the screens and code in SQL Server 2008

Environment: SQL Server 2008, Oracle 9i, T-SQL, Excel, Access, Report Builder 3.0, Windows Server 2003, Query Analyzer, SQL Server Profiler

Cipla Manufacturing Plant, Sikkim, India May 2013 – Apr 2014

Role: SQL Server Developer

Worked with the business users for gathering business requirements.

Enhanced pre-existing logical and physical database utilizing Erwin.

Normalized tables to remove redundancy and maintain system consistency.

Created database objects such as UDFs, indexed views, clustered, and non-clustered indexes.

Identified and resolved deadlocks from SQL profiler and DTA.

Generated various reports such as drilldown, drill through, chart, and freeform in SSRS.

Optimized reports with modifications to embedded queries or stored procedures.

Enhanced existing stored procedures and functions to add new logic as per the requirements.

Optimized stored procedures to perform database maintenance and resolve fragmentation issues.

Looped through multiple folders and extracted data utilizing Foreach loop container in SSIS.

Monitored runtime events for troubleshooting and debugging of SSIS packages utilizing loggings.

Migrated SSIS packages from development to production environments with package configurations.

Generated reports utilizing relational databases and OLAP cubes.

Environment: MS SQL Server 2008/2010/2012, SQL Server Integration Services (SSIS) 2010, SQL Server Reporting Services (SSRS) 2010, SQL Profiler, Database Engine Tuning Advisor, Tableau 7.0, MS Office, Windows 7.

Contact this candidate