Samsung Market Intelligence (MI) Tool Project

Client:

Samsung SDS ME

Business Challenges:

Multiple reports needed by CRM team which had to be fetched from various sources to excel and tabulated leading to lot of time for validation and real time usage

What We Did:

The aim of this project was to build a web based system that

• Extract & Load raw sales data from two different sources (GFK & BI) into a SQL database.
• Provision to map current upload columns with previous month’s columns to provide a continuous link (varying column names)
• Generate intuitive text/graphical reports (sales summary, trend, geographic & market share).

Technologies Used:

• .NET Framework 3.5,
• C#
• ASP.NET
• ADO.NET
• Crystal Reports
• SQL Server 2008

Results:

Successfully launched on time being used extensively for various MI Reports across Samsung Management.