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.
Skills
Development Tools
Web Development
Programming Language
Database
Data & Analytics
Others
Operating System
Portfolio Projects
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 LessSkills
Data Visualization Looker SQLTools
TableauCompany
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.
Tools
TableauCompany
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 LessCompany
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 LessSkills
Business Intelligence and Reporting Tools - (BIRT) Java (All Versions) CSS .NET Core IBM DB2 Programming JavaScript OracleTools
Eclipse