Provided Store management and their leadership teams with standardized performance analysis reports

Decision boards were developed to provide visibility of store performance across Sales, Units, Traffic, Conversion, New Customers, Returns & Discounts

They were hosted on a centralized platform with end-to-end automation for daily data refresh with user specific data filtering

Smart visual indicators were introduced based on business guardrails and action oriented narratives were provided for key KPIs

To provide a one stop analytical product to determine performances of Sales, Distribution, Pricing, Franchise, Production, Channel Partners, Outlets, Quality and Consumer Complaints. Further leverage these to senior most management like CMO (Chief Marketing Officer), CFO (Chief Sales Officer)CFO (Chief Financial Officer)and CEO(Chief ExecutiveOfficer) based on their areas of interest.

Leading Canadian food retailer derived value from an Enterprise wide Tableau implementation

Identified business KPI’s at an overall, region, banner, customer type and periodic week ending combination & model level.

Leveraged client’s internal databases to create a single source of truth and remove redundancy and disparity in input data.

Developed an intuitive, customizable set of reports through the use of Tableau that could be used as a decision support system by regional heads and representatives across organization

Deployed the solution to enable accessibility of reports via browsers.

To provide an analysis of Sell-through percentage, Sales Velocity analysis and Absolute Sell-out by category

Developed a tableau dashboard based on category and what’s selling and within a category what styles do they need more
Solution helped the clients to visualize how fast a specific product sells overtime
Brainstormed with company’s senior management to establish new methods of increasing sales revenue, decreasing cost of operations and minimizing error (inventory/delivery/accounting)
Provides business recommendations to decision-makers on how to increase sales revenue, retain and attract more customers and strengthen online presence

Summarize support critical functions such as sales, marketing and medical activities, providing improved performance of Sales Rep. Replicate the existing manual presentation to an automated report and enable user cased login to filter data based on their regions with export functionality

Developed report on Tibco Spotfire which detailed marketing and medical activities of sales representatives

Provide an end to end solution to deepdive clinical trials recruitment and volunteer analysis for set of diseases

Set of dashboards and scorecards to leverage clinical trials recruitment information obtained from multiple data sources

Data was extracted from multiple data sources and a cube was created as a source for reporting

Integrated live feeds about clinical trials in the dashboard as a Value-Added Service

Integrate Office, Pharmacy, Hospital, Cross channel summary and provide an analytical solution for quick decision making

Enhance pre-approved delivery format for each specific report which and improve the existing Qlik dashboard based on new specifications

Understand Business requirements, analysis and translate into Application and operational requirements

Gathered business logic and requirements for design of data modeling, fetched data from QVD’s

Worked on the Html extension objects

Build and deploy an SSAS cube with multiple measures groups and defined dimensions and their respective hierarchies. Identify KPIs and create custom measures using MDX scripts

Developed Analysis Services Project. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions

Defined attribute properties in a Parent Child Dimensions. Responsible for hiding and disabling attributes hierarchies. Sorting attributes members based on a secondary attribute

Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries

Cubeware BI reporting tool is a German native BI tool. Audi and IMS Health being their major clients.
Cubeware BI reporting solution is a marketing and sales management information system having data from various sources and structures linked together to provide regional and national market analytical ability. QuintlesIMS Switzerland Business Unit provided Cubeware Reporting solutions for more than 450 pharmaceutical clients all over Switzerland