Shubham Bansal

Objective: To obtain a position that will enable me to use my strong technical skills, educational background in a highly professional and well established organization that will lead to a rise of my carrier and of organization as well. Accurate Senior Analyst with exceptional teamwork, leadership and communication skills. Over 5 years of experience working on large-scale projects as well handling daily operational requests. Exceptional technical understanding with the ability to meet project deadlines.

Brand Launch Dashboard in QlikView

● Objective of the project

o To track the initial sales, interactions made by the field in the market

o Performance of a newly launched drug in the market

● Gathered client requirements and various data sources to be used in the dashboard creation

● Created entirely new dashboard design based on the uses cases and requirements. Some of the features of the dashboard involved

o The dashboard was made iPad compatible

o Incentive compensation plan and its corresponding metrics

o Reach in the market using different sources – calls, speaker events and mails.

o Top divisions, sales reps and their contribution

● Developed the dashboard on QlikView tool based on the final design.

● Applied section access on the dashboard for different territory users to access their aligned territory only while viewing the dashboard.

Brand Mart Data Modelling Using SQL

● Extracted data from various sources – Oracle database, QVDs, QVWs, Text and Excel files

● Incorporated different data sources for sales, interactions, claims, affiliations, alignments, goals, etc. into single data model based on Star Schema data modelling using SQL Scripting

● Computed number of metrics and flags like True value sales, territory breadth and depth, benchmark metrics, time period flags, etc. in the data mart using SQL scripting based on the business rules shared by client.

Executive Dashboard in Qlik Sense

● Objective of the project

o Create dashboard for Senior Management to get insights on overall performance of the drug on nation level.

● Used Qlik Sense over QlikView for this project as Qlik Sense is self-analysing tool using which executives would have access to even create new views/analysis in additional to the already developed visualizations by the ZS team

● Created dashboard design based on the frequent use cases and requirements. Some of the features of the dashboards were

o Field performance based on PTP

o Top performing divisions and territories

o Budget spent and its utilization

● Created number of dimensions and measures in the tool library to help users create visualizations on the fly by simply drag and drop feature of Qlik Sense

Forecasting Dashboard in QlikView

● Objective of the project

o Create reports on QlikView to monitor the actual sales in comparison to the forecast

o Provide insights on the deviation of actuals from forecast and on what parameters

● Created dashboard design based on the frequent use cases and requirements. Some of the features of the dashboards were

o Comparison of Actual sales with various forecasts – T0, T3, MY0

o Deviation from forecast

o Various variance drivers and their contribution

● Used some of the interesting features of the QlikView in the processing like

o Waterfall chart to view the deviation in actual sales and forecast

o Qlik Maps to view the performance of the field in the geography

Sales Leadership Dashboard – Operations and Maintenance

● Objective of the project

o Run regular operations and maintenance of 54 dashboards

● Make regular updates/enhancements to automate the existing operations of the dashboard. Some of the processes which were automated are

o Format validations of various user files

o Automated QC checklist for various metrics on the dashboards

o Created automated alarm system in QlikView in case of any error or issues in the dashboard.

● Coordinate with various teams to gather required user files weekly, monthly and quarterly

● Integrate various new brand funded enhancements in the existing structure.