Near Gurukul Tower
Gurukul, Ahmedabad - 380052
A U.S.-based company with a revenue of over $1 billion, manufacturing and selling products from 10+ global locations.
The company was looking to control profit margin shifts across manufacturing units in different regions of Asia, Europe and the U.S.
Historically margin comparisons and analysis was a 6-monthly process.
The requirement was a visibility and analytics solution that helps to perform margin comparison and analysis on an on-demand basis.
Currency fluctuations, regional differences in financial reporting methods and absence of any centralized financial reporting systems made integrating data on business unit performance, types of fixed and variable costs, customer billings and product volume, etc. quite challenging.
Varied internal reporting metrics, reporting methods and formats used by 50+ financial managers and heads across locations made it difficult to consolidate data, as a lot of differences were present across parameter names, values, units, etc.
Difficulties in data accessibility rose from issues such as sharing of periodic updates on revenue and profit metrics only with stakeholders physically present during meetings.
Creating a new database structure to overcome data consolidation, integration and standardizations issues. This included
Identifying the right KPIs for
Developing a dashboard to generate real-time, historical and trend-based analytical reports and insights to improve performance per unit, per customer and product. And allow users to
Developed a business analytical tool that allows