Resume

Sign in

Sr MSBI Developer Lead

Location:
Marietta, Georgia, United States
Posted:
February 23, 2018

Contact this candidate

Resume:

BHAVESH KAPADIA

Mobile: 1-862-***-****

E-mail: ac4kx1@r.postjobfree.com

SUMMARY:

I am an experienced IT consultant. Specific areas of expertise including system requirements collection, architecture, analysis, design, implementation, testing, maintenance and enhancements in varied platforms with special emphasis on DW and ERP using MSBI, Data Visualizations Tools and Microsoft Dynamics AX Technologies.

SME in Microsoft SQL Server 2016/2014/2012R2/2008R2/2008/2005 suite of products including SSIS, SSAS and SSRS.

Actively involved in analysis, design, development and implementation of large-scale applications, resolving the defects and coordinating the requirements with team.

Worked directly with Business users to understand the requirements to create new system requirements and technical specification documents using Microsoft Visio 2008/2010 for new projects.

SME in developing SSIS Packages to ETL/ELT data into the data warehouse from heterogeneous databases such as Oracle DB, MS Access, Netezza, Excel, Flat files etc.

SME in designing, creating, processing of cubes using SSAS and creating different types of reports and dashboards using SSRS from OLAP cubes using MDX, DAX and T-SQL.

Profound knowledge about the Relational Database concepts and experienced in designing and deploying relational database.

SME in data visualization tools - Power BI and Tableau.

Expert in using Voltage APIs in SSIS to encrypt and SSRS to decrypt PII and PCI data.

Extensive experience in creating database objects like stored procedures, user defined functions, tables, views and triggers

Expert in Performance Tuning, Handling Indexes, and Query Optimization.

Worked on development/staging/production environments and used Team foundation server/visual source safe for version controls and communication’s well as defining Actions, translations and perspectives.

Good knowledge of DQS, CDC, R Service, DDM, RLS, Stretch Database, Temporal data, JSON, azure and data mining algorithms.

Excellent communication, interpersonal, analytical skills, extremely reliable, quick learner and have strong ability to work independently as well as a part of a team.

TECHNICAL SKILLS:

Operating System

Win 7, Windows Server 2003/2008/2012R2

Languages

T-SQL, PL/SQL, MDX, DAX, C#

Databases

MS SQL Server, Netezza, Oracle, MS Access, My SQL

Utilities and Tools

SQL Server Management Studio, Visual studio, SQL server Data Tool Power BI, Sharepoint, Tableau, Qlikview, SAP Crystal report, Tortoise SVN, TFS, Secure Assist, App Dynamics, Soap UI, Toad, Microsoft Dynamic AX, Voltage, ProClarity

EDUCATION:

Master of Science Degree in Mechanical Engineering, 2007

New Jersey Institute of Technology, Newark, New Jersey

Bachelor of Science Degree in Mechanical Engineering, 2005

Shri Sa'd Vidya Mandal Institute of Technology, Bharuch, India

CERTIFICATION:

MCP: 70-431 SQL Server 2005-Implementation and maintenance

70-448 Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

C, C++, Java

WORK EXPERIENCE:

Client: Randstad, Marietta, GA July 2017 – Current

Role: Sr BI Consultant

This project is about migrating Randstad legacy back-office applications from FL platform to ATL platform and mainly deals with designing ETL processes, reporting and dashboards to support that migration from different Randstad legacy back-office applications to ATL system.

Responsibilities:

Worked with business team and stake holders during this assignment to enhance business and IT collaboration by providing over 2,000 employees with self-service data access. Now, the entire company shares a common set of goals, metrics and KPIs for reporting.

To enhance the user experience, created and implemented automation ETL-ELT processes and enhanced existing reporting and automation processes using SSIS and Pentaho (PDI), SSRS.

Improved operational efficiency as processing time for nightly refreshes decreased from 8 hours to 2 hours, facilitating hourly intraday metric reporting.

Added new reporting features to the Randstad Internal reporting website, which allowed users to pull reports, analyse business processes and critical operational data. Enhanced the user experience from static PDF/text reports to meaningful charts on a dashboard with drilldown capabilities.

Created different types of reports such as parameterized reports, drilldown reports, drill-thru reports, and sub-reports in different formats such as Tabular, Matrix and Charts etc. for business users and created report subscriptions so that business users will receive reports via E-mails or on shared drive using Windows File Sharing in different formats such as PDF, Excel and Word etc.

Set up Healthcare, Life science, Technology and Engineering reporting applications on AWS and GCP instead of on premise databases to reduce the maintenance cost and improve performance and end users experience.

Optimized TSQL queries for reporting and data load processes.

Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2016 and Oracle 11g.

Adhere to department, organization and industry guidelines, standards, policies and procedures.

Promote the company culture by approaching each day with team-oriented and can-do attitude

Used TFS as a repository to store packages, reports.

Environment:

MS SQL Server 2016/2008R2/2008, MS SQL Server Reporting Services 2016, Oracle 11g, SSIS 2016/2008R2, Power Pivot, TFS, Pentaho, C# and .Net, Google Big Query, AWS, GCP, Domo

Client: First Data Corporation, Marietta, GA Jan 2013 – July 2017

Role: Microsoft SQL Server & BI Consultant

This project is to design and implement complete MSBI solution to support First Data conversion analytics and reporting for multiple first data clients.

Role & Responsibilities:

Responsible for the development and architecture of the BI environment, its design, documentation, performance, availability, and success, including ETL, data warehouse/data marts, and end user applications for conversion analytics and reporting.

Worked with business team, stake holders and offshore team during this assignment for reporting, ETL processes implementation and enhancement of existing processes.

Developed and successfully executed server migration plan to migrate FD internal CDAR web applications from SQL Server 2008 to SQL Server 2012 R2 including all the databases and BI components like SSIS, SSAS and SSRS.

Designed and implemented new processes for all the incoming and outgoing data feed and reporting as a part of migration project.

One of the first team in first data to successfully implement voltage encryption using SSIS and decryption using SSRS by using voltage APIs for SQL Server 2012 R2.

Designed and Implemented process to report PII and PCI data access statistics into Splunk using SSRS and SSIS.

Created and Implemented many automation processes and reporting using SSIS, SSAS, SSRS, C# and .Net which were done manually by users in past, to enhance user experience.

Added new features and tools to First data MDB-CDAR website, which allowed users to pull reports, analyze business processes and gives them an ability to load data files (excel files with dynamic columns and flat files) into sql databases.

Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL database.

Designed and implemented the data warehouse using star schema also created repeatable ETL processes to load dimension and fact tables based on the business requirements.

Designed and created aggregations, partitions, calculated members, named set, advanced KPI’S for SSAS cubes using MDX and DAX; used them to create dashboards and reports via SSRS, Power BI, Tableau and Excel.

Created many dashboards and reports such as parameterized reports, drilldown reports, drill-thru reports, and sub-reports in different formats such as Tabular, Matrix and Charts etc. for business users and created report subscriptions so that business users will receive reports via E-mails or on shared drive using Windows File Sharing in different formats such as PDF, Excel and word document etc.

Used Power Query, Power Pivot and Power view from power BI add-ins for excel and Power BI Desktop to create dashboards for end users.

Created and deployed rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau for one of the client partner to provide them Revenue Impact Analysis, Forecasting and Pricing Opportunity Analysis. Created Schedules and Extracted the data into Tableau Data Engine to support those dashboards.

Promote the company culture by approaching each day with team-oriented and can-do attitude

Optimized TSQL queries for reporting and data load processes.

Used Tortoise SVN as a repository to store packages, reports and database objects like Store procedures, functions etc.

Environment:

MS SQL Server 2012R2/2008R2/2008, MS SQL Server Reporting Services 2012R2/2008R2/2008, SSIS 2012R2/2008R2/2008/2005, SSAS 2012R2/2008R2/2008/2005, Power Pivot, Tableau, Tortoise SVN, C# and .Net, Netezza, Power BI, Splunk

Client: First Data Corporation, Hagerstown, MD June 2012 – Dec 2012

Role: Microsoft SQL Server & BI Consultant

This project was to design an OLAP data warehouse system to support enterprise level reporting, process enhancement and provide production for FD clients.

Role & Responsibilities:

Worked as team lead for offshore team during this assignment.

Designed and developed OLAP data warehouse system to support enterprise level reporting.

Created ETL processes using SSIS to load the data into OLAP data warehouse system.

Implemented advanced logging to support debugging and enhancement of ETL processes.

Created ETL processes to pick up data files for monthly and daily load from the shared folders, process them, validate data in those files before loading into SQL database tables and send an email to users with data load statistics.

Implemented data warehouse Partitioning in OLAP data warehouse system to provide manageability and performance benefits.

Implemented process using sliding window technique to maintain data in partitions.

Optimized TSQL queries for reporting and data load processes.

Created SQL Data dictionary to provide detail information about database objects using SSRS.

Created Report Catalog report using SSRS to provide detail information about all the SSRS reports in existing environment.

Created different types of reports such as parameterized reports, drilldown reports, drill through reports, sub-reports in different formats such as Tabular, Matrix and Charts etc. for end users using TSQL and MDX datasets.

Environment:

MS SQL Server 2008R2/2008, MS SQL Server Reporting Services 2008R2/2008, SSIS 2008R2/2008/2005, SSAS 2008R2/2008/2005, PowerPivot, TortoiseSVN

Client: Prommis Solutions LLC, Roswell, GA Mar 2009 – May2012

Role: Microsoft SQL Server & BI Consultant

This project was to implementation Microsoft Dynamics AX 2009; UIF (Universal Integration framework) using SSIS, design the enterprise level reports and production support for the end users and troubleshooting database issues.

Role & Responsibilities:

Closely interacted with end user to gather business requirements.

Designed interfaces for UIF which company’s internal application to transfer and transform data between DAX (Microsoft Dynamics AX 2009) AP, AR, GL modules and different legacy systems like CaseTrax, FMS, and BMS etc.

Responsible for Full Report Cycle including Authoring, Managing, Security and Generation of Reports.

Generated different types of Reports such as Tabular, Matrix, and Charts.

Experienced in defining Query for generating drill down reports in SSRS 2008/2005.

Created stored procedures and user-defined functions for different Reports.

Deployed and configured the reports in the Report Server.

Created Subscription of Reports in different formats such as PDF and Excel to be executed automatically on weekly or monthly basis.

Created complex correlated sub queries to generate reports.

Prepared documentation on the data mapping and relationships between tables.

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

Expert in Performance Tuning, Handling Indexes, and Query Optimization.

Tuned the database for optimum performance.

Created groups, roles, users and assigning access privileges to users.

Configured and Automated Maintenance plans.

Secured reports by creating Service Accounts and Security Groups and configuring in the Report Server.

Environment:

MS SQL Server 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL, SSIS 2005/2008, Visual SourceSafe, Microsoft Dynamics AX 2009

Client: Kaplan Higher Education, Alpharetta, GA Oct 2007 – Feb 2009

Role: Microsoft SQL Server & BI Consultant

Project was to optimize the performance of the KHE databases mainly on Warehouse side to improve the performance of the system and support the business users by creating cubes and solving DW issues.

Role & Responsibilities:

Moved all the objects from SQL 2000 to SQL 2005.As part of that i had converted the most critical DTS packages into SSIS packages.

Solved the bugs which assigned to me and push every code on the staging for the code review.

Code review with DBAs and made the necessary changes per the KU Standards. After approval deployed code in a production.

Created the SSIS packages for cubes which load the Dimension tables, Fact tables and process the cube.

Created SSIS packages to clean and load data to data warehouse.

Created package to transfer data between OLTP and OLAP databases.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Scheduled Cube Processing from Staging Database Tables using SQL Server Agent

Create store procedure to log all the events on the success and failure on flat file as well as in Error_Log table.

Used TFS once you put your project on TFS any of the member of the team can see your work. TFS provides a source control repository, called Team Foundation Version Control (TFVC).which relied on a file-based storage mechanism, Team Foundation source control stores all code, as well as a record of all changes and current check-outs in a SQL Server database.

Designed a cube per BRD. BRD were created by our BA team.

As a part of a cube design, created TRD and after approval of TRD, I had to start working on development of cube which has multiple fact measure groups, and multiple dimension hierarchies per BRD.

Created calculated fields with MDX cube to meet additional measures needs that are calculated from existing measures.

After finishing the development of the cube, put in a code review using TFS.

There Business users do the UAT and once they approved UAT, DBA deploy cube on Production.

On the frontend used ProClarity Desktop Professional 6.3 to browse the cube and to check the outcome of the cube.

Environment:

MS SQL Server 2005, T-SQL, SSIS 2005, SSAS 2005, Visual SourceSafe, Win2003 Advanced Server, ProClarity Desktop Professional 6.3, Team Foundation Server, MS Access



Contact this candidate