This Real Estate Company which is also a Master developer, had developed Malls which were rented out to boutique outfits. With time the shop owners started facing maintenance issues which were reported to the Developer. The Developer then felt the need to develop a system which will manage all customer concerns thereby improving customer (shopper) satisfaction.

Arowana was called on to conduct a study, and develop a tracking system that will help the developer in effectively addressing all reported issues in a time bound manner. The Developers appointed staff would pose as shoppers (mystery shoppers) who would look out for possible issues with a view to rectify the situation in its nascent stage. They also would log in issues and see to it that the issues were getting rectified. This also helped the shoppers experience an ambience that would make them return to the mall repeatedly.

These shopping malls were truly world class, where even celebrities come to shop. The outlets were unique, globally well known brands which needed to maintain a certain class and reputation when it came to customer experience.

The Solution termed as “Mystery Shopper Management” system provided a mechanism for organizing, maintaining, and tracking the resolution of issues that cannot be resolved at the individual level at the retailers level. The approach consists of issue control mechanisms and a well-defined process that helps in identifying, addressing, and prioritizing issues in centralized and secure manner.

• Online Shopper Registration and profile management.
• Create/ Amend Observations (Issues)
• Facility for Admin to moderate submitted observations
• Workflow functionality to channelize the observation between Agent (Shopper), Moderators and Department (Resolution owner)
• Resolution Tracking and Reporting.

• Reduce noise so and focus on the real issues
• Observations being scrutinized and classified as Noise or Passed.
• Focus on real issues and reduce the number of issues.
• Track progress toward remediation.
• Track progress made toward fixing issues by evaluating each open issue and classifying it as fixed, in progress, noise, or passed
• Show positive results
• Classifying issues also helps in demonstrating commitment and showing positive results

• Microsoft ASP.NET 4.0 Framework
• Telerik Web Control Toolkit 2011
• Sql server 2008
• C#.Net
• Microsoft Enterprise Practices Library 4.0

• Fully automated tendering process without paper work and with full transparency.
• Simplifies and speed up the existing tendering process.
• Quick document sharing between end user and suppliers.
• Notification between suppliers and end users.
• Online document verification of supplier’s.
• Online letter generation and dispatch process.
• Ease of use and data consistency
• The system will also provide operational features for seamless but controlled access across functionality, loading of data from various systems, access control and audit trail.

• Microsoft .Net Framework 4.0, ASP.Net, C#,
• Microsoft Enterprise Practices Library 5.0
• SQL Server 2008 R2
• Telerik Control Toolkit, Symantec antivirus scanner toolkit

The Tickets were being sold separately at the venue by the Company and the customers had to procure tickets from each facility. Thus the customers could not be classified and given discounts based on Category and usage. Besides, idle inventory could not be promoted and it remained unsold and unutilized.

Arowana’s Solution was a web based interface, which could be accessed by the customer online or through their mobile. The system provided a single source of information on all facilities with availability. The booking system could reserve time slots and provide value packages which were built around optimizing the Company’s overall offerings with a view to maximize the earnings and also provide ‘best in class’ amenities to the customer.

• A web based solution with various modules to manage and book entertainments tickets or package deals for different entertainment offerings of a Entertainment Conglomerate
• A solution flexible enough to handle multiple categories – Individuals, Corporate, Partners, Schools etc. for mass bookings
• Well-defined section where Admin (Sales & Marketing team) can create, define and publish different packages etc.
• Finance/ Management team can review and make approval/ changes to the designed packages
• Well-versed solution that enables the core work flows and approval work flows in between Business Leads and Finance team
• System manages the entire capacity of all attractions. Provision to enter capacity for particular day, slot.
• Online tickets have BAR code or QR code that gives unique identity to the booked tickets

Web based front end with the Portal/ Booking engine as the back-end, with an admin module that can devise value packages, route the packages for approval and publish them for end user to consume. The Admin module also could create Special Value deals based on holidays and also promote ‘deal of the day’ to the customers.

The system interfaces with individual software/web services running each of the facility to enable optimal usage of inventory and also interface with POS / Barcode reader machines, payment gateways. The system also had comprehensive Social Media Integration and customers could log in through various social media sites and post their comments and pictures.

The System enabled the conglomerate to maximize their earnings and provide a unique experience for their customers. There was also better utilization of capacity and the ability to predict the footfalls enabled better management and service of customers.

The Stock exchange had outsourced the development to a firm and the application faced numerous issues with Compatibility, acceptability and capabilities. There was growing frustration and the number of complaints steadily grew. The exchange scrapped it's initiative and approached Arowana to come up with a proper solution that will be capable/ acceptable and compatible. After a proper business study, Arowana proposed a solution to overcome the following pain areas:

• Reviews from customers are not satisfactory.
• UX experience are not up to the standards
• Features existing in the application did not display Real Time Data
• Hint Feature (portrait to landscape) was not present
• Localization (English to Arabic and vice versa ) was not supported
• Graphs present in the application did not give co-ordinate values

Arowana's Mobile application development team developed a state of the art "iPhone & iPad" Application for the Stock Exchange, providing rich content & unique functionalities in an elegant and user-friendly way.

For the Organization

• Maintain Standards – Centralized Controls on Quality, vendors and distribution
• Maintain records of Uniform distribution to all users as per their eligibility and nature of their roles.
• Quality MIS can be provided to Management.
• Improved efficiencies and cost reductions.

For the Users

• Web and smart phone enabled access for logging requests
• As the store will maintain all measurements, multiple visits will not be needed.
• Distribute uniform to all uniform users when mass change applies to uniform sets.
• Facilitate the uniform user to avail additional uniforms.
• Purchase additional uniform with salary deduction
• Replace uniforms which got damaged on duty
• Replace uniforms which got damaged by Laundry Service
• Facilitates Uniform store to raise one time uniform sets to employees (on special events)
• Bring approval process to control additional/ special uniform requests.
• Control uniform distribution within defined budget
• Auto inventory control on uniform issuance and returns
• Complete uniform inventory report from day one for any uniform employee.

The application is developed to work seamlessly and is platform independent. It can integrate with multiple applications like ERP systems. Popular versions are built in Oracle Application Framework. The OAF stack is comprised of underlying technologies like UIX and BC4J that respectively form the core of the view and model layers. It includes Application Object Library (AOL) that provides common E-BS artifacts such as menus, functions, messages, profiles, flex fields and attachments, etc. We also have a version in ASP Dot Net.

The Airline’s Corporate Security was managing and maintaining every employee’s access request to various classified zones, issuance on ID card, CAR Stickers, Airport pass and even Apartment keys in Excel sheets. They wanted to automate this process and create a fool proof and failsafe method to automate the procedure in order to manage their security access with HR system integration. This was required to satisfy key audit concerns and to manage access controls which are related to roles, responsibilities and grades.

Arowana was called in to study and develop a web based automated system which will meet the needs of the Airline. iSecurity was expected to deliver superior control and compliance with security regulations to maintain and organize security related access and protocols of all employees in an efficient way.

The key business needs can be categorized as

• Building key maintenance module that integrates with facility management system for master information.
• Facilitate corporate employees/ contractors to submit Car parking sticker requests; through Oracle EBS suite self service.
• Automate ID card request generation for new employees once recruitment process completed.
• Facilitate corporate employee to submit ID card request on behalf of new contractors; through Oracle EBIS suite self service.
• Facilitate corporate employees/ contractors to submit Airport pass request sticker requests; through Oracle EBIS suite self service.

• A web based paperless system which will minimize manual process
• Compliant with security and audit requirements
• Up to date real time online reports for management to review
• Better control on access provided to users
• Sending alerts to employee as well as the security department administrator on expiry of ID cards/passes/car park stickers, notification to the employees/occupant to vacate the company provided premises within the stipulated time based on event such as end of service/termination.
• Helps audit and maintain staff access to multiple Internal/External facilities
• Facility Key Inventory management
• Role based application access eligibility and Restrictions

The Development is done in OAF (Oracle Application Framework) platform. The OAF stack comprises of underlying technologies like UIX and BC4J that respectively form the core of the view and model layers.

The Drivers of the trucks carrying the soft drinks also worked as sales and delivery personnel. They had hand held devices into which the sales orders and corresponding deliveries were entered. The Sales order would be sent to the warehouses, where the inventory is reserved and then pushed into trucks for delivery. Depending on the credit worthiness of the buyer, cash or credit facilities were extended.

Oracle E Business suite needed to be customized to be able to interface with handhelds, reserve inventories against orders, and also to accommodate highly complex but extremely routine transactions like, switching of loads between trucks during breakdowns, damage returns and unpacking at warehouses due to failed deliveries.

Arowana developed a detailed solution that addressed the complex requirements of the order managements (bottling plant). The solution, which was built around the SCM, also interfaced with various accounting modules within the E-Business suite, facilitating the updating of accounts, with respect to auto accounting based on business rules and accounting of discounted and free order line items.

• Reservation of inventory of the order by Priority based on Customer/ need and distance from warehouse.
• Order packing (packing notes) facility based on Customers requirements.
• Batch Process for ‘Pick-Release’ of inventory/ sub inventory.
• Transacting the Sales order as Batch.
• Hand held device integration.
• Un-packing of goods’ for returned Goods
• Updating records when transferring goods between trucks.
• Automatic creation of invoice by Driver/ Sales or delivery personal for any damages.
• Invoice creation for discount and free lines along with user defined values.
• Dashboard to display for order process.
• Handling of fully undelivered orders in case the Customer is not available for accepting delivery.

The Bottling plant could increase its delivery several folds. The turnover and profits went up and they went on to acquire several more territories and other order managements (bottling plant). The overall operational efficiency with respect to sales and delivery went up and the stocks were churned nicely.

The solution now suits all discrete manufacturing industries, which deliver large quantities of goods to retailers like Pharmaceuticals and Large wholesalers/ C&F agents, using Oracle ERP systems.