CASE STUDIES

INFORMATION TECHNOLOGY CONSULTING

CASE STUDIES

Management Excellence through Business Intelligence

APPLICATION FOCUS

• Market size estimation & demand forecasting
• Sales forecasting
• Ad & Promotion effectiveness assessment
• Price setting & realisation
• Discount optimisation
• Customer segmentation
• Customer lifetime value
• Brand equity
• Customer churn/attrition prediction
• Customer satisfaction analysis

• Raw material price forecasting
• Safety stock & EOQ analysis under dynamic conditions
• Spare parts inventory management with Reliability analysis
• Determining customer service levels
• Determining factors for retail outlet selection
• Forecasting store level demand & optimising in-store availability

• Determine optimal levels of process parameters & predict result of changes in those levels
• Detect causes of product quality deterioration
• Predict breakdown of machines
• Reliability & Product lifetime analysis
• Quality Risk Management
• Reduction of rework & wastage
• Process mapping & Statistical Process Control (SPC)
• Implementation of Kaizen, Lean, MSA, CAPA, FMEA

• Customer segmentation based on credit/trading risk
• Product segmentation based on supply chain risk
• Risk based pricing
• Loss forecasting & Value at Risk (VAR)
• Project risk based on NPV, scenario analysis & Monte Carlo simulations

SECTOR / SEGMENT FOCUS

• Financial Services
• Health Care
• Industrial Products
• Plantations
• Consumer Goods

CASE STUDY – Flat Steel Price Forecast

Problem – The organisation is the leading engineering company in India having very high reputation across the globe. Project costing is a very vital process in project consulting as it takes 4-5 years to get a very big project operational. The price of steel products both long and flat is very critical and can create severe impact on the entire project due to cost overrun. Wanted to know how variation in macroeconomic factors influences the demand, supply and price of steel products. The client was interested to construct statistical models of demand, supply and price using the macroeconomic factors which can be used to forecast prices over a period of 5 years.

Solution – The data related to various macroeconomic factors along with Demand, Supply and Price data were collected from various authentic sources. Then we used Structured Simultaneous Equation Modelling and ARIMA. The analytical tool was packaged and implemented for regular usage by Client’s consulting teams.

CASE STUDY – Newsprint Safety Stock Analysis

Problem – The organisation procures large volume of newsprint from USA and Canada. The price of newsprint is a very critical factor for newspaper industry, as it has a direct impact on the bottom line. The client wanted forecast for newsprint prices for coming four quarters and the stock levels to be maintained. The stock levels were dependent on data consists of shipping lead time, total lead time (which is a sum of order lead time and shipping lead time), consumption of 140 cm newsprint, procurement of 140 cm newsprint and opening stock figures.

Solution – We determined the Service level, that is the probability of demand during lead time being less than or equal to the amount of stock you had left when you ordered. We found that the consumption (demand) of 140 cm imported newsprint follows Log Normal distribution while the Total Lead Time (Shipping lead time plus Order lead time) also follows Log Normal distribution. We implemented the solution as SSL Module and integrated the module with existing Stock Management System.

CASE STUDY – Statistical Tools for Process Review

A leading energy meter manufacturer approached us to identify and implement statistical tools in manufacturing and assembly processes for process control and quality improvement. After a detailed study we found that most of processes were not non-normal thereby invalidating standard methods of constructing control charts. Our consultants had to develop new control charting tools for controlling such processes. The developed tools were implemented as part of process control application for the client.

More case studies can be presented if required.

Making the Web Accessible: WAI – ARIA

Using “Rigel”, a specialized platform from, Team Grandeur provides Web Access solutions using WAI-ARIA [Web Accessibility Initiative – Accessible Rich Internet Applications] guidelines that define the specification for ontology of roles, states, and properties, Defines accessible user interface elements. This is used to improve the accessibility and interoperability of web content and applications. These semantics are designed to allow an author to properly convey user interface behaviors and structural information at document level.

Principles – The WAI at the W3C recommends that In order to be accessible, web content must be:

• Perceivable: output of web content available through multiple sensory modalities
• Operable: input methods of content functionally works with a wide range of input devices
• Understandable: content and interfaces that people can comprehend
• Robust: compatible with a broad range of user agents, including assistive technologies

Laws & Penalties –

• USA has laws relevant to web accessibility – American with Disabilities Act (ADA)
• The European Union has issued mandates and policies related to web accessibility
• Further UK Ireland, France, Germany, the Netherlands, and Italy has own rules
• Australia, New Zealand, Japan, India, and Hong Kong also has accessibility laws

On March 28, 2014, the Department of Justice, USA issued a Final Rule that adjusts for inflation the civil monetary penalties. For the ADA, the penalty has been revised up to $75,000 and for a subsequent violation the new maximum is $150,000

Our Solution
Our SMEs audit your entire website for accessibility violations using our accessibility tools. SMEs also verify audit reports and manually review each page to prepare a list of violations. Our Accessibility Experts reviews the violations and write smart overlays for each page. The overlay-packages are run locally on our test servers against your website and review the fix of each of the violations on all major browsers. In extremely rare cases, if there are defects/violations that cannot be fixed through overlays (colour combinations, hard-coded behaviour etc.), full information would be provided to you so that it can be fixed in your code. Once finalized, we deliver you a single file as your website’s common includes.

We do not need access to your application source code, database or any of your “top-secret files”. The entire development work is done in our environment. You also do not need to change anything on your website. We use our specialized platform ‘Rigel’ to write smart overlays in JavaScript. The overlay of around 200 kb overhead runs on top of your web pages to make them accessible. The smart overlays are self-contained objects which “know” when to run and do not interfere with any of the existing functionalities of your webpage.

Client Web Links can be presented if required.

Security & Access Management Solutions

Team Grandeur has already implemented a few Secured Access Management solutions based on its “eSSL – eTimeTracklite” package. Time recording management is mandatory implementation in every organization and implementation of eTimeTracklite software works in reducing the time required for managing employee time usage. eTimeTracklite ensures accuracy in the output with

• Records the start and end time of each task rather than just the total time
• Records that is important for the employee contract management
• Supporting the fact that professionals work at different efficiencies, so recording time against each task tends to normalize professional activities
• Time details split at admin and leave time that acts as record for leave entitlements.
• Multiple attendance data collection points but processed and reported centrally without the need for any additional effort / work
• Support for Local overtime laws that generate reports in few seconds
• A system that prevents buddy punching and fraudulent time keeping records.

ETIMETRACKLITE MASTERS SETUP – Monitor Setup | Database Settings, Login & Change Password | Setup Master Details, Company, Users, Departments | Setup Employee Categories | Define Shifts, Shift Groups, Shift Roaster, Holidays, Leave Types | Employee Master, Mail Set up

ETIMETRACKLITE MANAGE ATTENDANCE – Schedule Shift | Assign Leave Entries, OD Entries | View Log Records, Add Manual entries

ETIMETRACKLITE REGISTERS – Attendance | OT Register | Leave Register | Attendance Logs

ETIMETRACKLITE DEVICE MANAGEMENT – Download Logs | Device Details | Upload & Download Users | Schedule Downloader | Device Greetings, Manage Work codes

ETIMETRACKLITE UTILITIES – Import Export Employees | Import From eTimeTrack | Backup database, Backup & Clear Old Logs /Restore Old Data

ETIMETRACKLITE RE-CALCULATE ATTENDANCE ETIMETRACKLITE REPORTS – Daily Attendance | Monthly Attendance | Yearly Attendance | Leave Summary | Leave Entries, Out Door Duty Entries | Logs Records | Random IN/OUT Check | Continuous Abnormality Check | Generate Matrix | Generate Graph | Generate Memo | Employee Records | CSV Exports

The system operates with Card | Bio-Metric | Code Punch Access at all levels. This also works on remote devices like PDA or Tablets through open as well as secured networks. The application can easily be modified for Generic Access Management specific to situational needs / requirements.

Live demo with Masked Data can be arranged if necessary.

Mobile Application Development & Maintenance

A Develop Application Profile [RB Track] is attached for reference. The application has been implemented as a module of the existing SFA – SRM [Sales Force Administration] system in the client location. Please refer the attached PDF file for a walk thru.