Sandeep M.

Sandeep M.

Lead BI Consultant with experience on Tableau, Looker, SQL and Alteryx

Middletown , United Kingdom

Experience: 14 Years

Sandeep

Middletown , United Kingdom

Lead BI Consultant with experience on Tableau, Looker, SQL and Alteryx

72000 USD / Year

  • Immediate: Available

14 Years

Now you can Instantly Chat with Sandeep!

About Me

Senior BI Consultant, with 14+ years of Software Solution delivery and Implementation experience in Design, Development and End to End implementation of BI stack solution delivery using Data Visualization<...

  • Have strong experience in analysis and development for various Data Visualization tools and technologies such as Tableau, Power BI, Looker, Actuate and BIRT reporting tools.
  • Have strong experience in Alteryx (a data blending and Analytics and Machine Learning tool)
  • Have hands on experience of data visualization using QlikView.
  • Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server

and Reports and Alteryx Work Flows.

  • Sound knowledge on all Tableau and Power BI scenarios like Calculations, LODs, RLS, Filters, Actions, Parameters, Groups, Sets, Graphs, Maps, Users, and Scheduling.
  • Knowledge on understanding data structures, data manipulation and statistical/predictive modelling and data visualization. Leads and codes data processing and analytic methods. 
  • Sound knowledge on producing weekly, monthly and quarterly reports, Score Cards, KPIs, reports for various domain and clients.
  • Builds a detailed understanding of the problem domain and related data assets. Ensures that the data used follows the compliance, access management and control policies of the company while meeting the data governance requirements of the organization. Works with technical groups to support the collection and testing of data sources. 
  • Mastered the ability to design and deploy rich Graphic data visualizations with Drill Down and Drop down menu option and Parameterized using Tableau and Power BI.
  • Ability to communicate with the business and technical issues to both business users and technical users and providing training to the end users.

Show More

Portfolio Projects

HomeAway

Company

HomeAway

Description

Tools/Technologies: Looker(Data Visualization), Snowflake(Database), SSRS

Duration: 5 months

     * Client is a payment solution for several businesses and provide end to end integrated payment solutions. There are four major mode of payment. I created multiple dashboards for homeaway and vacations units like Capacity and Planning, Staged Onboarding.

      * Also created monitoring dashboards to ensure all the dashboards have latest data and raise an alarm for data discrepancy, if any

Show More Show Less

Tools

Tableau

Hexa

Company

Hexa

Description

Tools/Technologies: Tableau, Informatica, Oracle

Duration: 14 months

Led a team of 7 technical resources(all Tableau Developers). Client was a leading pharma organization.

My team was responsible for –

  • Maintaining 300+ existing Tableau dashboards.
  • Create new dashboards.
  • Work on business specific enhancements/change requests.

As a team leader, my responsibility was to ensure quality of the work and delivery as per schedules. I was the POC from offshore and coordinated with all the stakeholders, including other technical team across different timezones.

Other responsibility/initiatives include - 

  • Create prototypes for new complex requirements.
  • Assist client/user during UATs.
  • Mentor other team members.

Show More Show Less

Skills

Oracle Tableau

Tools

Tableau

CMSO

Company

CMSO

Description

Tools/Technologies: Tableau, Informatica, Oracle, Qlikview, SharePoint

Duration: 18 months

Suport and development of Tableau dashboards.

Show More Show Less

Skills

Oracle Tableau

Tools

Tableau

Ticket Volume Forecast

Company

Ticket Volume Forecast

Description

Tools/Technologies: Tableau, Alteryx, MS Excel, Oracle, HTML, JavaScript, CSS, R

Duration: 2.5 Yrs.

 

Business Problem:

Inaccurate ticket/call volume predictions.

Efficient capacity management and resource planning.

Inability to run staffing simulations and perform sensitivity analysis using operation levers such as shifts, capacity constraints and service level objectives

Modules:

Volume Forecaster - improves the volume predictions accuracy by leveraging multiple statistical models(created by modeling team using R)

Capacity Planner - estimates the minimum number of required full-time equivalents (FTEs) for each client-defined time interval based on the incoming volume patterns. The incoming volumes for the future-defined periods are available as an output from the Volume Forecaster module. The minimum number of required FTEs are estimated based on the target SLAs and key performance indicators (KPIs) defined by the client. The capacity planner can be customized based on several parameters or constraints defined by the user.

Agent Allocation - automatically designs shifts based on the attendance tracker and contractual hours of FTEs. It compares required and available resources, and identifies areas of overutilization or underutilization. It also suggests shifts considering all the criteria as defined by the user. Some examples of user-defined criteria could be resource rotations and breaks.

Agent Scheduler - Volume v/s time for current and baseline period.

Headcount data for processes/Delivery location.

FTE cost for current and baseline period.

 

Solution (Outcome):

​Reduce operational costs by 15-20 percent.

Increase occupancy and utilization by 10-12 percent.

Improve service level agreement (SLA) compliance to increase customer satisfaction by 20-25 percent.

Show More Show Less

Skills

Oracle SQL Tableau

Other Projects

Company

Other Projects

Description

Previosly worked on other projects - 

  • Growth and Attrition
  • SoCo
  • Blue Diamond
  • RWorld

Tools/Technologies: Actuate, BIRT, Oracle DB, IBM DB2 Database, Java, Javascript, HTML, CSS

Show More Show Less

Tools

Eclipse
Share:

Verifications

  • Profile Verified

  • Phone Verified

Preferred Language

  • English - Conversational

Available Timezones

  • Eastern Daylight [UTC -4]

  • Central Daylight [UTC -5]

  • Mountain Daylight [UTC -6]

  • Pacific Daylight [UTC -7]

  • Greenwich Mean [UTC ±0]