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<...opment and End to End implementation of BI stack solution delivery using Data Visualization Technologies such as Tableau, Power BI, Looker, SQL and Analytical tools such as Alteryx.
- 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.
Skills
-
- 2 Years
Intermediate
-
- 1 Years
Beginner
-
- 2 Years
Intermediate
-
- 3 Years
Intermediate
-
- 1 Years
Beginner
-
- 12 Years
Advanced
-
- 8 Years
Advanced
-
- 2 Years
Intermediate
-
- 2 Years
Intermediate
-
- 1 Years
Beginner
-
- 2 Years
Intermediate
-
- 1 Years
Beginner
-
- 1 Years
Advanced
-
- 10 Years
Advanced
-
- 8 Years
Advanced
-
- 1 Years
Beginner
-
- 3 Years
Intermediate
Portfolio Projects
Description
Tools/Technologies: Tableau, Informatica, Oracle
Duration: 14months
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 coordinatedwith 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.
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 LessDescription
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