Dhwani Mandavia

Data Analyst – SQL Server MSBI (SSIS, SSAS, SSRS) Developer

Summary

7+ years of Data Modeling, Database Design, Programming, Development and Implementation of Database & BI intelligence systems using MS SQL 2005/2008R2/2012 and Master’s Degree in Computer Science.

Strong experience in designing and developing large number of enterprise reports (SSRS) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.

Extensive database programming Experience in writing T-SQL Stored procedures, User Defined Data Types, Triggers, Constraints and Indexes using various DDL and DML commands.

Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, and Check, Unique etc.) and Generating Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.

Hands on experience with performing various SSIS data transformations & data flow tasks like Look-ups, Merge, Merge Join, Sort, Derived Column, Union-All, Conditional Splits and Event Handlers, For Each Loop containers, Control Flow Task, Execute SQL Task, Script Task, Send Mail Task, File System Task etc.

Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, and Check, Unique etc.) and Generating Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.

Expertise in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.

Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.

Working with Normalization and De-Normalization techniques

Tuning the performance of Stored Procedures and large T-SQL Queries using Clustered Indexes.

Performing SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects and client expectations.

Extensive experience in analysis, design. Experience in database Backup & Recovery.

Gained very good experience in project delivery management.

Experience in performing data migration

Strong understanding of SDLC and agile methodology

Technical Skills

Languages

SQL, PL/SQL, TSQL, Java.

Scripting

HTML, XML, Perl, JavaScript.

RDBMS/Databases

Oracle9i, Oracle 11g and SQL Server 2005/2008/2012/2014

Tools

Idera SQL Diagnostic Manager, SQL Doctor, Zabbix, Spotlight, Jenkins, SQL, Profiler, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Visio, Eclipse 2.1/3.1, SQL Developer, TOAD, Oracle, JIRA

ETL/Reporting

Informatica Power Center, Tableau, Clover ETL, SSIS, SSRS, MS Power BI

Testing

Unit, Functional, Integration, Black Box, White Box, Load, Performance

Professional Experience

Nexon America - El Segundo, CA

BI Engineer (Data Warehouse) Mar’16- Jan’ 19

Description: My major responsibilities at my job will be setting up a communication channels between the Business Users and Developers. These channels cater to both technical and non-technical audience. It includes gathering and understanding requirements, checking whether the data exist in Data warehouse if not develop SSIS Package to gather data and then developing reports in Tableau/SSRS2016 accordingly.

Roles and Responsibilities:

Developer ETL Packages using SSIS to pull data from multiple data sources into DW database.

Develop Reports using SQL Server Reporting Services (SSRS).

Maintaining the Integrity of KPI Data.

Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.

Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.

Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2012

Work closely with internal customers analyzing problems and to create and maintain reports, maintaining SSRS Reports and ad-hoc SQL scripts.

Provide 24/7 availability of data, and solve end-user reporting and accessibility problems.

Successfully Interpreted data to draw conclusions for managerial actions and strategy.

Data Migration of Services (games) from another Country.

Deploying and debugging DB Patch for LIVE Game Operations.

Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.

Deployed and configured the reports in the Report Server.

Delivery Game Backlogs Items under the Agile methodology with focus on continues delivery and Improvements.

SQL Server Administration and Data Warehouse Operations

Environment: SQL Server 2008/2008 R2/2012, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, Tableau, MS Excel, MongoDb 3.6.

Confie Seguros - Los Angeles, CA

Database Developer/ Administrator June 2015 - February 2016

Description: As a team member, responsible for Analysis, design, development, testing and implementation of project specific applications and providing solutions for new implementations to the team. Responsible for assigning production tickets to team and assigning projects as per schema expertise and technology expertise wise.

Roles and Responsibilities:

Installed SQL Server 2014/2012/2008 R2 on Windows Clustered and standalone environments with latest service packs.

Design and develop store procedures, tables, views, and functions; implement best practices to maintain optimal performance.

Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.

Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS

Optimized data collections procedure and generated reports on weekly, monthly, and quarterly basis.

Working with managing leadership to prioritize business and information requirements.

Monitoring and Performance Tuning Physical Server Level, Database level (Database settings and options) and query tuning.

Generated and formatted reports using global variables, expressions and functions.

Involved in developing parameterized reports using single values, multi values and cascading parameters.

Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views in SSRS 2005/2008.

Troubleshoot and fixed issues of server performance using SQL Profiler.

Planned and Implemented Backup Recovery and Point in Time Recovery Strategies.

Environment: SQL server 2000/2005/2008, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle 9i, Enterprise Manager, ERWIN Data Modeler, SSIS, SSRS, SSAS, Windows Server 2003/2008, OLTP, OLAP, DTS, HTML, XML, C#, .Net, Visual Studio 2008, ETL, MS Access

California Lutheran University - Thousand Oaks, CA

Business Intelligence Intern March2014– Nov 2014

Roles and Responsibilities:

Production support with Deployment of the SSIS Packages and schedule SSIS packages Involved in all phases of SDLC

Designing and creating the database in MS SQL Server 2012.

Worked with project teams for upgrading SQL Server 2008 to SQL Server 2012

Created Jobs, Alerts using SQL Server Agent, and scheduled SSIS Packages.

Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.

Development of the module, testing and implementation.

Coordinating with business team for analyzing project requirements.

Involved in the analysis of functional specification

Documentation of requirement till preparation of SRS (System Requirement specification).

Preparing the QA Plan and Software Test Plan and review test case document

Environment: SQL server 2008/2012, Oracle 9i, Tableau, Enterprise Manager, SSIS, SSRS, OLTP, OLAP, DTS, HTML, XML, C#, Visual Studio 2008, MS Access

IT Guru, Mumbai

SQL Developer Dec 2010-May 2013

Description: This project involves the purpose of the proposed web site is to function as a hub for families to learn and share ideas on how to be of service in their communities.

Projects

Data Warehouse Project

-Create a warehouse of sample data according to Professors requirement. Performing various ETL Operation on it and reporting data in graphical form.

Technology: Oracle, Informatica Power Center, Tableau.

Parallel Apriori Algorithm for frequent Itemset Mining

-In this project we presented an algorithm of mining hybrid dimension association rules which satisfies the definite condition on the basis of multidimensional transaction database. Boolean Matrix based approach was used to generate frequent item sets in multidimensional transaction databases. It adopts Boolean relational calculus to discover frequent predicate sets.

Technology- Java, MY SQL

Cellular Automata

-Implemented Conway’s Game of Life. I was Involved in all phases of this project with respect to Software development Life Cycle (SDLC) including Analysis, Design, Development, Testing, Implementation and Documentation.

Technology: C#

Roles and Responsibilities:

Dealing with Relational Database Management Systems including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.

Generated reports as per business requirement using SSRS.

Developing SQL scripts to facilitate the functionality for various modules

Writing Stored procedures and DB Scripts to create and update database tables.

Responsible for Production Release and support.

Carrying out database tuning activities to ensure optimal performance.

Handling all the responsibility of Database Administrator.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Server Management Studio, MS Excel-SQL, ERWIN

Education

California Lutheran University Aug 2013- May 2015

Master's Computer Science. GPA-3.77

Mumbai University Sep 2009 - Jul 2012

Bachelor’s in computer engineering, GPA- 63%

Contact this candidate