Hari Vignesh Shiva
Microsoft BI Developer with experience working in Data Warehousing (OLAP), Reporting, ETL, and Analytics across various SDLC environments using SQL Server, MSBI (SSAS, SSIS, and SSRS) and Power BI.
SQL Server (2008,2012,2014,2016), Teradata, IBM DB2
Database or BI Tools/Languages
C#, T-SQL, PL/SQL, XML, XMLA, JSON, SSRS, SSIS, SSAS, DTS, Business Intelligence Studio (BIDS), SQL Management Studio, Query Analyzer, SQL Assistant
Windows (XP/7/8,10), Windows Server 2012/2008
Data Modeling tools
SSAS (SQL Server Analysis Services), MS-Visio
Reporting Services (SSRS 2014/2012/2008R2), Power BI, Tableau
Microsoft Integration Services (SSIS 2014/2012/2008R2), DTS
Microsoft Visual Studio 2012/2013, Team Foundation Server, VSS
Domino’s Pizza (Ann Arbor, MI)
May 2018 – Till Date
Power BI / SSAS Developer
Architecting the SSAS Solution for the International Team for their Sales related reports.
Took the owner ship of Developing BI solution for the Team to build multiple reports using SSAS as a semantic Layer between the Data Warehouse and Power BI.
Implementing the Server Architecture for Process Layer and Query Layer of the SSAS Tabular Models.
Developing the SSIS Packages to Process the cubes.
Designing the Partitions, Full Process, Incremental, Semi Incremental Processing for the Tabular Models.
Designed the DR plan for the recovery of the Models (Taking Backups of the Models).
Semantic Layer setup for the self-service BI, building tabular cubes, for Power BI and implementing DAX expressions.
Implementing the Processing Architecture between the processing layer and query layer to have less downtime of the solution or the queries being queued up.
Expertise in writing calculated tables, calculated columns, and Measures in power bi desktop to show good data analysis.
Treehouse Foods (Oak Brook, IL)
Oct 2017 - May 2018
Power BI Developer
Supported Business Units (Logistics, Plant Finance, Packaging).
Hands on with Connecting, Transforming and shaping Data, Modeling Data and creating reports in Power BI.
Created Power BI dashboards with visual tiles from the reports, developed KPI’s, used DAX expressions to create calculated measures, calculated Columns and DAX Tables.
Working experience in scheduling the Data Refresh and gateways (On-premises / Personal), used custom visuals on reports to suite different business requirements.
Developed Cubes using SQL Server Analysis Services (SSAS).
Took ownership of iterative process of developing visuals and BI solutions by feeding the visuals from flat files / spreadsheets into a database and then moving to OLAP solutions.
Office Depot (Boca Raton, FL)
Nov 2016 – Sept 2017
BI (SSAS,SSIS), Power BI, SQL Developer
Took ownership of multiple projects within the Supply Chain and the Retail Analytics space at Office Depot o Optimized the current solutions available for supply chain management, this involved recreating and defining new cubes for the time series data available at office depot. As part of the ownership transfer I was given the task of overall data reduction while processing which was possible only by pruning the data and creating cubes only with incremental data
These solved issues involved with memory management and made the jobs run faster, also partitioned and aggregated the data for performance improvement.
Implemented Data Warehousing Concepts of SCD’s Type 1 and Type 2 on Dimensions.
Architected new ways to improve the current data migration regulations in place. o After multiple tries found that TPT Scripts and BCP the flat files are the best possible ways to move data from Tera Data to SQL server.
Involved in consuming data from external vendors like (Shopper trak) and integrated this knowledge with the rich customer data available at Office Depot.
oThis helped with better identification and profiling of the customers visiting the store.
oThis data helped with better analytics on live data on Black Friday
oPerformed SSAS Cube and Synchronizing.
oUsed COGNOS to visualize the data.
Selene Finance LP (Houston TX)
July 2014 – Oct 2016
SQL Developer MSBI (SSRS/SSIS/SSAS) Developer
Worked closely on regulatory implementations related to Dodd Frank reform act. • Knowledge of HAMP feeds
Responsible for gathering requirements from clients and implemented workflows for the same
Involved in identifying key aspects of the flow and potential reports which the client might be interested.
Provided data access to the respective clients.
Involved in FICO analysis.
Identified potential breaches in loan payments and helped clients with identifying potential cases of defaulting.
Developed KPI Reports to monitor the performance.
Implemented pipe line that can consume from flat files, Excel sheets and SQL Server from multiple upstream systems using SSIS
TransCanada Corporation (Westborough, MA)
March 2013 – June 2014
MSBI Developer/ SQL Developer
Involved in Code Reviews, Code Migration and Deployments across all environments.
Helping offshore team in developing BI Solutions based on business and functional requirements from the business.
Worked on Dimensional modeling, Defined relationships between Dimensions and Measure groups.
Created SSAS cubes and loaded dimensions and facts, Defined attribute properties in a Parent Child Dimensions.
Reviewed cubes changed the cubes and documentation according to the requirement based on evaluation and revenue opportunities using SSAS.
Designed ETL packages and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Amica Insurance (Providence, RI)
Jan 2012 – Feb 2013
SQL BI Developer
Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
Involved in Developing the BI Solutions and ETL for Data Movement.
UPMC (Pittsburgh, PA)
Sep 2010 – Dec 2011
SQL Server / MSBI Developer
Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
Worked on creating mapping document with business requirements, source to destination schema mapping along with the ETL logic and created design documents.
Monitored execution plans to enhance the performance of the queries.
Worked on Performance Monitoring with SQL Profiler and Windows System Monitor.