Summary
Overview
Work History
Education
Skills
Software
Certification
Work Availability
Quote
Timeline
Projects
Professional sites
Projects
Generic
Vishal Sharma

Vishal Sharma

Business Intelligence And Data SME
New Delhi

Summary

With over 16 years of experience in the BI and data domain, I am a passionate and result-driven technocrat with a proven track record of success in designing, developing, and implementing scalable and reliable data solutions. I have a strong expertise in Azure data environment, Python programming language, and Power BI business intelligence platform.

I have a deep understanding of the entire data lifecycle, from data ingestion and processing to data warehousing and analytics. I am proficient in using Azure data services such as Azure Data Factory, Azure Databricks, Azure SQL Database, and Azure Synapse Analytics to build and manage data pipelines, data lakes, and data warehouses. I am also skilled in using Python to develop custom data processing scripts and machine learning models.

I am also an experienced Power BI developer and have used Power BI to create and deliver interactive dashboards and reports to business users. I am proficient in using Power BI features such as DAX, M language to analyze and visualize data.

I am a highly motivated and results-oriented individual with a strong work ethic. I am also a team player and have excellent communication and interpersonal skills. I am confident that I have the skills and experience necessary to be a valuable asset to your team.

Overview

16
16
years of professional experience
1
1
Certificate
2
2
Languages
6
6
years of post-secondary education

Work History

Associate Director

ValueLabs
Hyderabad
08.2022 - 07.2023
  • Working in capacity of County Manager for Data as a Service(DAAS).
  • Enabling Client to optimize business process and deliverable.
  • Increase client India team size to 71.
  • Optimized MS SQL procedures and reduce time of delivery from 12Hr. to 8 Hr..
  • Designed a software solution that will reduce procedure dependency and create a cockpit where all data preprocessing can be done on a single window. Tools recommended for the same was Django(Python) and React as frontend and MS SQL and Mongo DB as backend. Enabling more data security, role base access to data and data governance.
  • Developed and design a software solution using Snowflakes DB that with AWS Glue and creating lambda function to give access to data using API. This help in JIT data solution to all client not waiting for report to be sent to client.

Associate Director

ValueLabs
Remote
04.2021 - 08.2022
  • Working with as Digital Partner (Pre-Sales Lead) that help sales team to understand and decode customer requirement and bridge gap between Sales and delivery.
  • Worked with sales team to generate revenue of $5 Million.
  • Taking part in submitting proposal for RFP/RFI.
  • Work Individual contributor to work as following Power BI Architect to design/Develop and deploy solution to Power BO cloud service. Also help them to embed the Solution in client website with enabling multi user access on the embedded report.
  • Used Azure IoT Hub to ingest data from client IoT devices and used Azure Stream Analytics to process the data and generate real-time alerts. The data from the stream was also saved into text files (partitioned by date) and made available as a data warehouse in Azure Synapse Analytics using Azure Data Lake Gen 2 as the underlying data storage.

Business Intelligence Manager

Grant Thornton Bharat LLP
Gurugram
09.2018 - 04.2021
  • Work as presales team member for enablement of dedicated BI and Analytics solution selling.
  • Generated revenue of $.5 Million for year 2019-2020 by upselling to clients.
  • Work as SPOC for RFP and RFI for BI and Related solutions.
  • Design and Develop Proof of value in Azure data factory, Azure SQL managed instance and Power BI.
  • Migrate client data from Conda on-premises to IFS data files using Azure Managed SQL instance and Azure Data Factory. Replicate the report in Power BI using the data in Azure Managed SQL instance. Use a SQL profiling tool to create a data mapping schema for Conda to IFS ERP system.
  • Manage projects as program manager using Agile methodology (SCRUM Master) in BI and Data analytics.
  • Working closely with Vendor and internal team to deliver projects
  • Identifying sales opportunities within and outside organization.
  • Working on closing with senior leadership and assisting them with opportunities identified opportunity that comes . Thus enabling revenue generation.

Senior Manager-BI

LiquidHub Analytics
Gurugram
07.2017 - 09.2018
  • Accountably suggesting technology-based solutions for mitigating as well as discerning and managing risks involved in projects, planning for eventualities
  • Supervising project delivery process including project schedule, quality management, communications management, people management, cost management, change management & risk management
  • Implementing project management methodologies to manage projects through to completion, within budget, on time and with superior quality
  • Part of presales team to create POC and reply to RFP/RFI for Business Intelligence Domain
  • Worked as transition manager to migrate QlikView solution (200 reports and Qlik deployment) from client as Managed service to Liquidhub for NBFC
  • Managed and work as Technology architect project to create 150+ new reports in span of 9 month using agile methodology with team of 20 developers.
  • Work as a data architect and support multiple project in Azure Stream Analytics, Azure SQL Data Warehouse, Azure Data Factory.

ManagerBusiness Intelligence

LiquidHub Analytics
Gurugram
07.2016 - 07.2017
  • Worked as project manager for BI solution delivery
  • Facilitated as solution architect for Qlik and Power BI projects
  • Produce detailed functional design document to match customer requirements
  • Instrumental to work as technical architect to produce technical specification for custom development and systems integration requirements.
  • Work as a solution Designer to Connect IoT devices to Azure IoT Hub, analyze the data with Azure Stream Analytics, store the data in Azure Data Lake Store, and visualize the data with Azure Power BI.

Lead Solution Architect

LiquidHub Analytics
Gurugram
05.2015 - 07.2016
  • Understand complex dashboard reports for designing BI Layer to support downstream reporting
  • Adroitly developed process to document requirements, design, testing for data warehouse application also describing automated testing of data loads across all data loading into data warehouse
  • Facilitated end-to-end support for applications from inception & requirement specs with significant success in leading geographically diversified project teams at multiple locations
  • Conducted root cause analysis and troubleshot to avoid further escalation while identifying & analyzing defects, questionable, functions, errors, inconsistencies in data or report
  • Accountably worked to create and provide proof of Value for forthcoming clients as part of pre-sales activity
  • Created detailed functional design document to match customer requirement and implemented those design process flow analysis and process redesign.
  • Developed an MSBI solution to extract, transform, and load (ETL) HR data from Oracle ERP system into an MSSQL data warehouse, and used SSRS to create reports and dashboards for HR analytics.
  • Compared Power BI and Qlik Sense for data visualization and dashboarding, and selected Power BI for its ease of use, scalability, and integration with other Microsoft products.

Associate Manager

Fidelity Investments
Bangalore
09.2014 - 05.2015
  • Managing team of SAP BO and Hyperion developer for migration project
  • Reviewed deliverables and providing technical guidance to team
  • Involved in preparing estimates, weekly project status reports and kept management informed of project status and related issues
  • Set and enforced performance and service standards to keep consistent, high-quality environment devoted to customer satisfaction.
  • Create plan for migrate 200 report to SAP BO from Hyperion 11.
  • Did Quality check on all the reports that have been migrated to make sure accuracy of the report.

Assistant Manager

Metlife Global Operation Support Center India Ltd
Noida
04.2014 - 08.2014
  • Managed highly diversified team of Software and Data developer for project delivery
  • Making sure of project is delivered in required timelines and Cost allocated
  • Worked on individual capacity for delivery of projects in Qlik and Power BI
  • Worked as ETL/ELT expert for import data from different data sources to consolidate and publish single view report of all ITSM projects.

Team Leader

Metlife Global Operation Support Center India Ltd
Noida
07.2012 - 03.2014
  • Worked on automation of process for ITSM project tracking using Qlikview with multiple ITSM systems as backend
  • Managed team of diverse team of Software, report and database developers
  • Responsible for managing and confirming delivery of project without failure
  • Provided training to Individual in BI and Analytics space
  • Improved automation efficiency by 150% of the process to generate and consolidate quality team audit tracking & reporting.

Sr. Executive

MIS, HCL Infosystems Ltd
Noida
10.2010 - 07.2012
  • Single point for contact for PAN India reporting and data requirement
  • Organized daily as well as monthly sales, ageing and current inventory reports and was owner of about 200 report.
  • Instrumentally executed internal audits for MIS reporting
  • Coordinated with business analyst to develop and deploy reporting requirement in SAP business object and analyzed operational reporting requirements and designed reports accordingly

Executive Process Audit

ISMS, Dish
Noida
02.2007 - 12.2009
  • That cover all reporting requirement of Dish TV from Sales, Customer care, Inbound and Retention reporting Initiated comprehensive account assessments to check viability, stability, and profitability of business operations
  • Analyzed final billing data for outsource partners and adjust billing for last 2 years
  • Established online system for floor knowledge test and providing report of test Question wise and maintain historic data for Appraisal and feedback purposes.

Education

MBA - International Marketing

Guru Gobind Singh Indraprastha University
New Delhi, India
07.2004 - 06.2006

Bachelor's degree - Softwares

Guru Gobind Singh Indraprastha University
New Delhi, India
07.2000 - 06.2004

Skills

    Strategic leadership

undefined

Software

Cloud

Azure Synapse

Azure Data factory

Azure Databrics

Azure IOT Hub

Azure SQL database

Databases

MS SQL

Postgres

MySQL

MongoDB

ETL/ELT

SSIS

ODI

Talend Community

Visualization

Power BI

Qlik Tech (QlikView, QlikSense)

Looker

Quicksite

Programming Language

Python

Data Storage

Azure Databricks

Azure Data Lakes Gen 2

Azure Blob

Azure Snoflakes

Certification

Certified Scrum Master

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

Far and away the best prize that life offers is the chance to work hard at work worth doing.
Theodore Roosevelt

Timeline

Certified Scrum Master

01-2023

Associate Director

ValueLabs
08.2022 - 07.2023

Associate Director

ValueLabs
04.2021 - 08.2022

Business Intelligence Manager

Grant Thornton Bharat LLP
09.2018 - 04.2021

Senior Manager-BI

LiquidHub Analytics
07.2017 - 09.2018

ManagerBusiness Intelligence

LiquidHub Analytics
07.2016 - 07.2017

Lead Solution Architect

LiquidHub Analytics
05.2015 - 07.2016

Associate Manager

Fidelity Investments
09.2014 - 05.2015

Assistant Manager

Metlife Global Operation Support Center India Ltd
04.2014 - 08.2014

Team Leader

Metlife Global Operation Support Center India Ltd
07.2012 - 03.2014

Sr. Executive

MIS, HCL Infosystems Ltd
10.2010 - 07.2012

Executive Process Audit

ISMS, Dish
02.2007 - 12.2009

MBA - International Marketing

Guru Gobind Singh Indraprastha University
07.2004 - 06.2006

Bachelor's degree - Softwares

Guru Gobind Singh Indraprastha University
07.2000 - 06.2004

Projects

 

ODC Extension and Setup (Aug 2022 - Present) with ValueLabs

- Oversaw optimization and business process improvements for a US-based client's India entity.

- Studied and found automation opportunities.

- Managed India's business operations including P&L, HR, and policies.

Data Feed Reporting from IoT devices (Dec 2021 - Aug 2022)

- Set up a Synapse Database in Azure to handle IoT data.

- Designed a report model for data analysis.

Data Migration from Legacy ERP to IFS (Jan 2020 - Apr 2021) with Grant Thornton Bharat LLP

- Migrated data from multiple legacy systems to IFS system, despite limited documentation.

- Discovered data mappings, built migration packages, and captured user inputs before migration.

- Reduction of operational costs and improved efficiency.

Data Warehouse Creation for Auto Manufacturer (Nov 2019 - Jan 2020) with Grant Thornton Bharat LLP

- Assisted in consolidating data from 18 plants.

- Identified data not being captured, defined KPIs, built a data pipeline using Azure Data Factory, and designed dashboards in Power BI.

- Resulted in a 70% cost-saving in reporting.

Survey Analytics and Dashboarding (Sep 2018 - May 2019) with Grant Thornton Bharat LLP

- Transformed manual survey reporting into an automated system.

- Allow global access to survey results based on access levels.

Qlikview Implementation for NBFC Client (Oct 2017 - Jun 2018) with LiquidHub Analytics

- Took over and managed a project previously handled by another vendor.

- Updated and designed revised requirements.

HR Analytics (Feb 2016 - Jul 2016)

- Provided insights for leadership on hiring, attrition, utilization, compensation, and survey results.

PMO Office Visualization and Data Integration (May 2015 - Feb 2016)

- Delivered insights on project cost analysis, ROI, and budget vs. allocation.   

Hyperion to BO Migration (Sep 2014 - May 2015) with Fidelity Business Services India Ltd

- Migrated finance reports from Hyperion 11.0 to SAP BO 4.0.

Software Asset Management Reconciliation (Jul 2012 - Aug 2014)

- Developed a software inventory monitoring solution, reducing procurement and redeployment costs.

Lotus Notes to Outlook Migration (Oct 2013 - Mar 2014)

- Addressed migration issues, developed an Access-based solution, and implemented CRM.

Storage Area Network Reporting (Mar 2013 - Jun 2013)

- Created a Qlikview-based environment for tracking storage network requests.

QA Automation (Sep 2012 - Dec 2012)

- Addressed data inconsistency through a QA automation system. Reduced reporting time using the Just In Time (JIT) framework.

Professional sites

LinkedIn:- https://www.linkedin.com/in/vishal1st/

GIT Hub:- https://github.com/vishalshell

Projects

 

ODC Extension and Setup (Aug 2022 - Present) with ValueLabs

- Oversaw optimization and business process improvements for a US-based client's India entity.

- Studied and found automation opportunities.

- Managed India's business operations including P&L, HR, and policies.

Data Feed Reporting from IoT devices (Dec 2021 - Aug 2022)

- Set up a Synapse Database in Azure to handle IoT data.

- Designed a report model for data analysis.

Data Migration from Legacy ERP to IFS (Jan 2020 - Apr 2021) with Grant Thornton Bharat LLP

- Migrated data from multiple legacy systems to IFS system, despite limited documentation.

- Discovered data mappings, built migration packages, and captured user inputs before migration.

- Reduction of operational costs and improved efficiency.

Data Warehouse Creation for Auto Manufacturer (Nov 2019 - Jan 2020) with Grant Thornton Bharat LLP

- Assisted in consolidating data from 18 plants.

- Identified data not being captured, defined KPIs, built a data pipeline using Azure Data Factory, and designed dashboards in Power BI.

- Resulted in a 70% cost-saving in reporting.

Survey Analytics and Dashboarding (Sep 2018 - May 2019) with Grant Thornton Bharat LLP

- Transformed manual survey reporting into an automated system.

- Allow global access to survey results based on access levels.

Qlikview Implementation for NBFC Client (Oct 2017 - Jun 2018) with LiquidHub Analytics

- Took over and managed a project previously handled by another vendor.

- Updated and designed revised requirements.

HR Analytics (Feb 2016 - Jul 2016)

- Provided insights for leadership on hiring, attrition, utilization, compensation, and survey results.

PMO Office Visualization and Data Integration (May 2015 - Feb 2016)

- Delivered insights on project cost analysis, ROI, and budget vs. allocation.   

Hyperion to BO Migration (Sep 2014 - May 2015) with Fidelity Business Services India Ltd

- Migrated finance reports from Hyperion 11.0 to SAP BO 4.0.

Software Asset Management Reconciliation (Jul 2012 - Aug 2014)

- Developed a software inventory monitoring solution, reducing procurement and redeployment costs.

Lotus Notes to Outlook Migration (Oct 2013 - Mar 2014)

- Addressed migration issues, developed an Access-based solution, and implemented CRM.

Storage Area Network Reporting (Mar 2013 - Jun 2013)

- Created a Qlikview-based environment for tracking storage network requests.

QA Automation (Sep 2012 - Dec 2012)

- Addressed data inconsistency through a QA automation system. Reduced reporting time using the Just In Time (JIT) framework.

Similar Profiles

CREATE PROFILE
Vishal SharmaBusiness Intelligence And Data SME