Case Studies - Retail

 

POS solution development and maintenance for a leading retailer...

 

Our client is a leading, enterprise wide open software solutions provider. These solutions are designed to enable food retailers in supermarkets, convenience stores, and other retail market sectors to respond to competitive market requirements and changing consumer preferences. These software solutions cover a wide range of retail applications including easy-to-use, comprehensive point of sale (POS) and back-office store systems that may be combined with the corporate host system.
Business Requirements
 
  • To develop, enhance, and maintain various components of the client’s end-to-end retail POS solution.
  • To meet end-to-end testing needs for products.
Solution Highlights
 
  • Configuration and integration with peripherals: Cash register, card scanning, printers, check scanning, and weighing scales, among others.
  • Customization: In addition to traditional POS functions related to product and price, customization to enable customer loyalty card scanning and promotional pricing. among others
  • Integration with backend applications: Receive daily and hourly product and price updates and provide sales extracts for sales audit and analytics and triggers for inventory updates based on items sold, among others.
  • Retail mobile applications: This was a mobile version of the in-store applications that also included certain functions of POS. The key objective of this solution was to enable store personnel to capture the entire inventory updates and purchase order transactions in real time while they are on the floor.
  • End-to-end testing of products to meet quality assurance needs.
 
Technologies
 
VB6, MS SQL Server, MS .NET, SSRS, and MS Access.

 

Building and upgrading retail Customer Relationship Management (CRM) solutions for a global leader in business software.

 

Our client is a leading solution provider for the business needs of the Manufacturing, Distribution, Service, Retail, and Hospitality industries. With 20,000 customers in more than 150 countries, it provides enterprise software solutions enabling companies to drive increased efficiency and improve profitability.
Business Requirements
 
  • To bring technology competency to the retail CRM solutions by upgrading and migrating legacy systems to the latest Microsoft technology through reverse engineering.
  • To leverage the partner’s expertise in its business domain by providing quick scale-up options and absorbing the growing IT solution needs.
  • To meet end-to-end testing needs for products.
Solution Highlights
 
  • Implementing reverse engineering of the existing products.
  • Upgrading the products to cater to the latest technology needs.
  • Developing and integrating new and enhanced features.
  • Completing the UI revamp of the CRM system.
  • Building backend processes for customer data management, analytics, and integrated business workflows.
  • Ensuring end-to-end testing of products to meet quality assurance needs.
 
Technologies
 
.NET Framework 3.0, C#, MSSQL Server 2008, and SSRS 2008

 

Online retail with SaaS expertise for a leading enterprise e-commerce ISV

 

The client is an application service provider offering hosted solutions to manufacturers and their partners for savings of as much as 60% off the cost of supporting commerce and related IT infrastructure in-house. The client had two separate platforms that were built using different technologies, were designed or built separately, and had their own objectives to be met.
Business Requirements
 
  • To migrate the ASP platform into Java with Service-Oriented Architecture (SOA) orientation.
  • To execute loose coupling of the platform written in ASP for better efficiency because it had a large part of business logic written in the form of stored procedures and thus were tightly coupled.
  • To clearly distinguish the business logic layer from the presentation layer to make the code scalable and maintainable.
Solution Highlights
 
  • Creating services (SaaS model) wherever clear distinction between the business logic and the presentation layers exists.
  • Focusing on those areas that do not have clear distinction but need rework or refactoring to convert them to services.
  • Creating services such as infrastructure services, atomic services, and aggregate business services from scratch and deploying these in a cloud environment.
 
Technologies
 
Java/J2EE, .NET, Data integration Web services, SQL Server SSIS, and SOA

 

E-Procurement B2B solution using EDI for integrating with a trading partner

 

The client is a privately held company founded in 2000. The company’s mission is to ‘connect organizations into business-to-business (B2B) trading networks’. The solutions offered are culmination of decades of experience in business trading, and they serve a comprehensive array of trading organizations. Whether your organization is a major or an SME supplier, a manufacturer or a distributor, a retailer or a major purchaser, or even a consumer, its solution suite supports and rationalizes trading relationships and transactions.
Business Requirements
 
  • To execute dynamic B2B integration that can automate business processes encompassing a diverse range of packaged products
  • To develop a complete solution of the Web-hosted accessible system that offers self-service modules, shielded by a number of security layers, including firewalls, Lightweight Directory Access Protocol (LDAP)-based Single Sign On (SSO) and Secure Sockets Layer (SSL) as a service in the form of ‘software-as-a-service’
  • To leverage the partner’s expertise to its business domain by providing quick scale-up options and absorbing the growing IT solution needs
Solution Highlights
 
  • Integrating the client’s Web solutions and JD Edwards ERP System with buyer through Electronic Data Interchange (EDI) integration
  • Creating connectors for different buyers as per the standard specified
  • Maintaining the core framework of Web application and BizTalk integration
  • Performing end-to-end testing of products to meet quality assurance needs
 
Technologies
 
JNDI, Java Servlets, Java (J2EE), Java mail and JavaBean™, JDBC, JSP, XML, ASP™, and LDAP, Microsoft BizTalk 2006 and BizTalk Accelerators for RossetaNet

 

Enterprise Business Intelligence and reporting solution for a leading Internet retailer

 

Client is one of the most trusted Internet retailers online. Dedication, commitment to quality service, high level of professionalism, product dependability, and competitive prices are reasons that underline its success in the auto industry. Through the years of providing superior quality automotive parts and accessories nationwide, the client has been distinguished as one of the most established auto parts retailers online.
Business Requirements
 
  • To design and implement a comprehensive solution readiness approach and framework for various data sources.
  • To ensure that global solution deployment is managed in a centralized and consistent manner, providing a hub for the spokes of subsidiary.
  • To develop a reporting solution to provide scalability, comprehensive analyses to assess the impact, and ROI of the client’s operational performance.
Solution Highlights
 
  • Building a platform to bring all these different data sources on one platform and creating a robust data warehouse using Datamart and Cubes.
  • Reporting based on Online Analytical Processing (OLAP) using complex Media Data Extended (MDX) queries.
 
Technologies
 
.NET and ETL using SSIS 2008

 

End-to-end retail solution for an enterprise retailer

 

Client is one of the most trusted Internet retailers online. Dedication, commitment to quality service, high level of professionalism, product dependability, and competitive prices are reasons that underline its success in the auto industry. Through the years of providing superior quality automotive parts and accessories nationwide, the client has been distinguished as one of the most established auto parts retailers online.
Business Requirements
 
  • SOA ready platform for their legacy application
  • Re-factor the code to use object-oriented features of PHP 5 and My SQL 5
  • Enhance role based access security (One entry gateway for management and BPO needs)
  • Payment gateway to be centralized.
  • Enhancing eCommerce platform to design a common platform and convert their modules to services to cater to their large base of customers.
Solution Highlights
 
  • Implementation of Business Access Layer and Data Access layer for supporting service oriented architecture.
  • Creation of Central Payment Gateway – A separate WebService based CPG that will process request of all kind of payment processing such as Pre-Auth, Delay Capture, Charge, Void, and Credit from several processors.
  • Built an enterprise eCommerce platform comprising of services development, widget development and admin panel to support multi-tenant web stores.
 
Technologies
 
PHP 5, PEAR PHP_Unit, Javascript, SOAP, MySql 5.0, WebServices, .Net 3.5, WCF