System integration based on Microsoft .Net and SQL Server

The client was looking to restructure their entire marketing database and also revamp their existing APIs. Their goals were to speed up data transfer through APIs and generate reports from the custom backend interface.

Understanding the existing system of the client
Getting timely response from client end to the queries from the team at WS

What we did

Analysed APIs from different third party data sources, including Salesforce, Google AdWords, MSN/Bing, Omniture - SiteCatalyst, and Simon & RDE.
Developed, scheduled processes for ETL of data from these third party systems to client’s marketing database.
Developed custom UI for gathering custom reports from the client’s marketing database.

Solution Highlights

The solution provided by WS included Microsoft .NET and Microsoft SQL Server based scheduled processes for Extraction, Transformation & Loading of data from external systems (Salesforce, Google AdWords, MSN/Bing, Omniture, Simon & RDE) and pulling into databases for the UI for Micros and showing report based on the extracted data, after an intermediate validation process through the UI.

What we achieved

Successful integration with third party data sources using respective APIs.
Achieved 100% data accuracy from the third party data sources, which include Salesforce, Google AdWords, MSN/Bing, Omniture - SiteCatalyst, and Simon & RDE.