Overview:

Zamtel is the leading telecom in Zambia. It provides a modern internet service through Zamtel On-line, founded in 1997, including digital subscriber line (DSL) and wireless access. Zamtel provides fixed line, mobile, internet and other value adding services for your business and personal needs, all designed to let you live life today.

Business Pain Areas

Zamtel wanted to upgrade its Oracle Application from 11i to R12 to streamline various business processes. The challenge here was to ensure minimum downtime, as all transactions were processed on the client's production system and even a day's delay would lead to huge financial losses.

• Dhanush InfoTech team identified the extent of customizations and interfaces required and provided solution to the Client in ensuring minimum cutover time for the final upgrade which was completed with minimal down time. The upgrade enabled the client to improve the service quality and reduce the total maintenance cost.
• The current application infrastructure failed to track & monitor numerous business process documents generated on a daily basis (Item Tracking, Fixed Asset Depreciation, Purchase Orders, Sales Orders, Invoices, and Bond Documents etc.)
• The current application infrastructure didn't facilitate report generation in custom formats.
• Enormous manual work leading to inconsistent and inaccurate information flow and deliverables.

Solution Overview

• Our team identified the extent of customizations and interfaces required and provided solution to the client in ensuring minimum cutover time for the final upgrade which was completed with minimal downtime. The upgrade enabled the client to improve service quality and reduce the total maintenance cost.
• The current application infrastructure failed to track & monitor numerous business process documents generated on a daily basis (Item Tracking, Fixed Asset Depreciation, Purchase Orders, Sales Orders, Invoices, and Bond Documents etc.)
• The current application infrastructure didn't facilitate report generation in custom formats.
• Enormous manual work leading to inconsistent and inaccurate information flow and deliverables.

Key Benefits

We upgraded the existing system and leveraged functionalities in the new version while extending the solution. The solution accelerated the firm's monthly financial close by two days while giving the company granular and actionable knowledge of gains and losses across business units, resulting in huge annual savings.

We worked with the Zamtel team to meet all deliverables & goals with minimal customizations to their Oracle Applications. Upon the conclusion of the upgrade phases and provided formal training sessions on new features for each module upgraded. In addition, our consultants acted as mentors to the Zamtel staff throughout the project, ensuring proper knowledge transfer to independently manage, and maintain the Oracle E-business Suite Applications and environment.

Overview

Easy Coach is a passenger transport and a courier service provider registered in The Republic of Kenya

Services offered by Easycoach

• Public road Transport
• Courier and Parcel Service
• Contract Hire
• Private Hire
• Sight-seeing Tours

Business Pain Areas

• Need for centralized booking system
• Data integrity issue in head office, branch office & agent offices
• No holistic control over the business
• No proper MIS reporting for the entire business
• Given the huge transaction volumes, transaction tracking and reconciliation was becoming an ever increasing challenge.

Solution Overview

CBRS – Centralize Bus Reservation System

Key Features

• Block/ Reserve bus tickets
• Cancel/ Discount/ Edit bus tickets
• Bulk Bookings
• Manage Courier/Parcel operations
• Supervise cancellation/discounting requests
• Generate/ Manage refund vouchers
• Generate various business reports
• SMS interface to manage bookings
• Bus Management (Fleet/ Route/ Schedule)
• Alerts and Notifications

Key Benefits

• Streamlined business operations at Easy Coach by implementing a Centralized Bus Reservation system (CBRS)
• Automated the business processes and manage the bus reservations as well as the courier/ parcel services across the branches and outlets
• Facilitated additional features like Search ticket, Block ticket, Printing the booked ticket, Ticket cancellation, Modifications, Corporate bookings, Voucher generation and management, Parcel tracking services, SMS/ Email notifications & MIS reports
• Fleet management and occupancy management derive optimum benefit from the transport business.
• The solution was integrated with payment gateway, Mpesa, weighing machines and barcode scanner devices
• Transaction tracking at all levels of the organization with multiple business users having varied privileges.

Overview

Airtel Africa is a subsidiary of Indian Telecommunications company. Airtel which is a leading global telecommunications company with operations in 17 countries across Africa, of which are in the Francophone and 9 in the Anglophone region. It provides mobile voice & data services, fixed line, high speed broadband, IPTV, DTH, turnkey telecom solutions for enterprises and also serves national and international long distance services to various carriers. In addition, it operates a GSM network in all countries, providing 2G and 3G depending upon country of operation. Airtel has over 200 million customers across its operations in various countries, including 50 million in Africa alone.

According to the company's audited consolidated International Financial Reporting Standards (IFRS), results for the fourth quarter and year ended March 31, 2012; the total revenues stand at $14.937 billion, up by 20 percent year-on-year (YOY).

Business Pain Areas

• Statutory and Management Reporting
  Assessment of current data structure, identification of data sources and reporting requirements. Legal reporting management was a challenge as it required a combination of data from 49 different entities.
  
  
• Financial Consolidation from 17 Operating Companies
  Financial data from 17 different Operating Companies (OpCos) and 32 JVs (Joint Ventures) was to be consolidated every month and reports were to be generated for IFRS and Management Reporting. There were several challenges in connectivity and the accuracy of Chart of Account (COA) mapping for each location to the group reporting.
  
  
• Metadata Management
  Entity hierarchy was changing due to different holding patterns and new acquisitions. Similarly account hierarchy was also changing due to the addition and reclassification of accounts. Account mapping from local ERPs to Hyperion Chart of Accounts (COA) was a consistent challenge.

Dhanush’s Solution

With the business pain area assessment and IT infrastructure landscape as an impetus Dhanush’s consulting team outlined an integrated system and process framework for Financial Consolidation and Legal/Management Reporting.

Solution footprint highlights:

• Implementation of Oracle Hyperion Financial Management, Oracle Hyperion Financial Data Quality Management, Oracle Hyperion Smart View, and Oracle Hyperion Financial Reporting Studio.
• Account Mapping done between local ERPs to Hyperion COA at a single location using FDQM.
• Account Hierarchy was developed as per IFRS reporting standards to simplify report generation for Legal Reporting.
• A process flow was developed for managing the financial close in a more controlled manner.
• Minority interest calculations were automated by writing rules in the backend as per business requirement.
• Intercompany transaction reports were generated to give crisp and clear information to the business on the Intercompany Partner (ICP) transactions.
• Reports were created using HFR instead of excel ensuring a good level of security for each user.

Key Benefits:

• Unified insights into financial results and close process status.
• Outcome based Modelling provided in-process reviews (with comparisons across the enterprise), insights into bottlenecks and the ability to do a deeper root-cause analysis.
• Ensured Lowest Total Cost of Ownership (TCO) and highest Return on Investment (ROI).
• Financial efficiency through effort reduction and resource collaboration across the enterprise.

Overview

Airtel Africa is a subsidiary of Indian Telecommunications company, Airtel which is a leading global telecommunications company with operations in 17 countries across Africa, of which 8 are in the Francophone and 9 in the Anglophone region. It provides mobile voice & data services, fixed line, high speed broadband, IPTV, DTH, turnkey telecom solutions for enterprises and also serves national and international long distance services to various carriers. In addition, it operates a GSM network in all countries, providing 2G and 3G depending upon country of operation. Airtel has over 200 million customers across its operations in various countries, including 50 million in Africa alone.

According to the company's audited, consolidated International Financial Reporting Standards (IFRS), results for the fourth quarter and year ended March 31, 2012; the total revenues stand at $14.937 billion, up by 20 percent year-on-year (YOY).

Airtel Africa is headquartered in Nairobi, Kenya. Keeping in view the growing business needs, Airtel Africa Group felt the need for having a Unified Enterprise Solution across Africa.

Business Pain Areas

• No-Unified Solution for effective tracking of day-to-day business transactions with multi-lingual options
• Huge challenge in terms of Month-End period closing in each Operating Company to meet the Audit Compliance Requirements
• Change Management – Business users adapting to the new business application
• Non availability of business processes which were streamlined and aligned to the group's business objectives
• Huge challenge in network connectivity and bandwidth
• Lack of transparency and control in the business operations off each OPCO

Key Benefits

After a thorough analysis of the existing scenario, Dhanush had recommended and subsequently rolled-out Oracle eBusiness Suite (covering several modules including as Finance, SCM and HCM )

• Tracking Day-to-Day Operations: The solution was a huge success as Airtel operating companies were able to successfully perform & track day-to-day business transactions with is in a multilingual setting.
• Month end period closing activities were achieved within their base timeline prescribed by Airtel group. Thereby ensuring Audit compliance.
• Change Management: Dhanush further facilitated user adaptation of the Oracle ERP system. Intensive training was given to the business users at every Airtel OPCO.
• Airtel Africa’s business processes were effectively streamlined and aligned to the proposed group business objectives.
• The solution as a whole could handle the Network Connectivity & Bandwidth.
• Transparency and perfect control in Business Operations in each of Airtel’s OPCOs
• Onshore/Offshore models: In addition to providing support and maintenance,Dhanush helped Airtel OPCOs to resolve and reduce the number of open support requests by having Onsite, Near shore and Offshore support teams.

Overview

Boeing is the world’s leading aerospace company and the largest manufacturer of commercial jetliners and military aircraft combined. Additionally, Boeing designs and manufactures rotorcraft, electronic and defence systems, missiles, satellites, launch vehicles and advanced information and communication systems.

With more than 3,100 employees at 27 sites, Boeing is an integral part of the aerospace and defence industry in Australia, with long term relationships based on trust and performance. Over the past three years, strong operating results have helped drive revenues from Australian customers totalling some US$8.7 billion, with around US$12.5 billion in orders from both commercial and defence customers. Boeing Defence also leverages the talents of hundreds of thousands more skilled people working for Boeing suppliers worldwide.

Customer Requirements

• Application support during business hours
• 24x7 on call technical services support
• Onsite-offshore support model with 85% offshore leverage
• Standardizing support processes
• Reduction in support costs with improved service levels

Modules Implemented & Solution Overview:

Aviation Maintenance
Aviation Maintenance – Complex Maintenance Repair Overhaul – cMRO

Finance (BT)
Accounts Payable, Receivables, Cash Management, Fixed Assets, General Ledger, Time Collection (OTL)

Supply Chain Management
Supply Chain, Enterprise Asset Management, Contingent Worker

Project Management & Execution

Human Resources
Human Resource Management, Maintain Employee Position Data, Learning Management, Workflow Management

• Oracle E-Business Suite functional consulting service across broad range of modules and architecture review aspects and knowledge transfer.
  
  
• E-Business System Administration, (Subject Matter Experts, Business) investigating issues/requests, develop understanding of system alerts and system roles & privilege, detail normal system admin activities (Refreshing in queue, help provide effective support to SMEs and key business users, streamline some of the standard support activities.
  
  
• Supply Chain Management and O & M – (Supply Chain, Enterprise Asset Management, and Contingent Worker process flows) develop knowledge transfer transition skills and attend training sessions (cMRO). Review implementation of cMRO project by following Oracle SR’s & testing. Provide the Boeing primary support person for HMS support Project Management process flow. Analyse systems and support for SC and O & M.
  
  
• Aviation Maintenance (cMRO process flow), Assist Boeing team to implement this module including CEMLIs (Customization, Extension, Modification, Localization, and Integration). Identify support requirements and knowledge transfer.
  
  
• Oracle Database Administration (DBA) work activities including application system administration and management (Oracle E-Business Suite application system administration and management), backfilling, trouble shooting, architecture review across a range of versions 7, 8, 9, 10 including RAC.
  
  
• Oracle E-Business development work, CEMLI's On-site and /or Off-site capabilities.

Key Benefits

• 24/7 system availability
• Stabilized production support process
• Improved knowledge management systems
• Reduced system maintenance and support cost
• Allowed customer to focus on strategic initiatives rather than managing legacy applications

Overview

Brand Energy is the leading provider of specialty multi-craft services to the North American downstream energy infrastructure market. Its extensive portfolio of service offerings includes work access, specialty coatings, abrasive blasting, insulation, refractory, corrosion protection, weatherproofing and other related crafts. Brand operates in four key energy sectors: Refining, Canadian Oil Sands, Petrochemical and Power Generation.

Services Provided by Dhanush

Dhanush has been providing Application Management Services to Brand Energy. Dhanush designed the 3P's framework for Brand for efficient support services which constituted of:

Partnerships

• Technology Partner
• Consulting & Service Providers
• Functional Expertise
• Assisting in Go-Live

Processes

• Knowledge Management
• Development Methodology
• Project Management
• Change Management
• Configuration Management
• Patching Management

People

• Industry Experience
• Intelligence and Creativity
• Integrity
• Learning Capability
• Adaptability

Key Benefits

• Consolidation of support and migration of applications to latest technologies resulting in huge productivity gains and reduction in billing leakages globally
• Reduced repeated issues with RCCA using user training and set-up changes
• Reduced number of redundant applications which were added as part of acquisitions
• Reduced data warehouse jobs and outage time of applications
• Standardization of processes and training the users ensuring reduction in errors
• Reduced TCO on infrastructure and maintenance costs
• Capacity management through deployment of better and improved design model

Overview

Crown Beverages Limited (CBL), a blue-chip Ugandan company, is a premium Carbonated Soft Drinks (CSD) Company in Uganda with an outstanding collection of strong healthy CSD brands and Water. It features a top notch distribution network across the country delivering quality products to all customers in Uganda and the neighboring countries.

The Company is focused on delighting customers and providing and excellent return to stakeholders through continuous improvement of beverages, systems and service delivery. CBL has received the several accolades, most recently being honored as the fastest growing PEPSI franchise in the EMEA region.

Business Pain Areas

• CBL wanted to automate their overall distribution process
• CBL wanted to replace an outdated financial management system with a modern automated system for efficiency and accuracy
• Support high transaction volume inherent in the beverage industry with large orders delivered several times per week to distributors
• CBL wanted to streamline the HR functions and reduce operations overheads associated with it

Key Benefits

• Reduced overhead costs associated with core HR processes, including workflow, payroll and performance appraisals
• Dhanush’s solution footprint minimized and automated the distribution and HR business processes
• Ensured lowest total cost of ownership (TCO) and highest Return on Investment (ROI)
• CBL gained financial efficiency through effort reduction and resource collaboration across the enterprise

Overview

Equity Bank is a financial services provider headquartered in Nairobi, Kenya. With over 6.3 million accounts, accounting for over 57% of all bank accounts in Kenya, Equity Bank is the largest bank in the region in terms of its customer base and operates in Uganda, South Sudan and Rwanda.

Business Pain Areas

• Personal costs accounted for a significant proportion of Equity Bank's gross expenditures, which could only be brought down by effectively controlling HR spending.
• Payroll processing was a tedious and time consuming task.
• Equity Bank wanted to automate purchasing and requisition process.
• The bank wanted to rationalize project management to prevent overspending.

Key Benefits

• Reduced overhead costs associated with core HR processes, including workflow, payroll and performance appraisals.
• Equity Bank gained greater control over staff to reduce manpower costs.
• Dhanush's solution footprint minimized manual (data entry) tasks related to data entry, reconciliation and financial reports.
• Dhanush's implemented footprint ensured lowest total cost of ownership (TCO) and highest Return on Investment (ROI).
• Equity Bank gained financial efficiency through effort reduction and resource collaboration across the enterprise.

Overview

Ezidebit is an Australian Financial Services Licensee and has service sponsorship agreements for the provision of direct debit and merchant payment services.

Dhanush Testing Services

Dhanush performed System and Performance testing for the modules encompassing, Fees and Billing functions of Ezidebit.

Testing Functions

• Period Close to Financial Reports
• Budget to Approval
• Supplier Invoice to Payment
• Sub ledger Journals to Post
• Oracle Account Receivables Gateway
• Oracle Account Payables Gateway
• Oracle General Ledger Gateway
• SOA Suite Integration testing

Testing Functions

• End-to-End business flow testing for process optimization
• Dhanush addressed business and IT risks at planned stages of testing life cycle ensuring that the system is "fit for user" for Ezidebit users
• Metrics based approach to assess and review process maturity ensured reduction in test case creation time by 30%.

Overview

Galana Oil Kenya Limited is a Kenya based oil company. Galana Oil Kenya Limited is committed to providing and distributing quality petroleum products to meet and exceed stakeholders' expectations through outstanding customer service delivered with great regard to the environment.

Business Pain Areas

• Customer wanted to streamline Bond Management Process (Open T810 & corresponding T812)
• The current application infrastructure failed to track & monitor numerous business process documents generated on a daily basis (Purchase Orders, Sales Orders, Invoices and Bond Documents etc.)
• The current application infrastructure didn't facilitate report generation in custom formats.
• Lack of insight on handling transit bonds and third party stocks.
• The existing IT infrastructure was integrated with Kenya Petroleum refineries limited for Crude refinement.
• Enormous manual work leading to inconsistent and inaccurate information flow and deliverables.

Key Benefits

• Customer's business processes were automated.
• The Bond Management Process was customized and integrated with Oracle EBS, enabling efficient and accurate information flow.
• Enablement of custom reports in alignment with the customer requirements.
• Automation of the key business functions like Crude Oil Procurement, Tracking Resource & Asset Performance resulted in better ROI for the customer.

Overview

Gulf Energy is one the market leaders in the energy sector in Kenya. Their portfolio includes:

• Oil Supply and Trading
• Oil Export and Transit
• Lubricant manufacturing

Business Pain Areas

• Customer wanted a centralized financial system
• Wanted to cut costs incurred in the procurement process
• OTS process was to be streamlined
• Collateral (Bonds) management process involving lots of financial transactions was inappropriate
• Sales order management wasn't standardized
• Inventory tracking, adjustment of stock entitlement was inappropriate

Key Benefits

• Substantial cost savings in procurement business function
• Customer achieved a more transparent view of daily operations
• Budget planning time reduced substantially
• Customers financial processes were standardized giving an end-to-end overview of cash flow in the organization
• Refinery process was automated

Overview

This is a Government of Kenya initiative to re-engineer and automate the Integrated Financial Management System (IFMIS). It is a subsidiary of the Ministry of Finance, is charged with the overall mandate of coordinating, implementation & overseeing the re-engineering and Automation of IFMIS.

Objectives of IFMIS are:

• Ensure effective integration of all financial management processes which include Budgeting, Procurement, Cash Management, Accounting, Audit & Reporting.
• Facilitate Electronic Funds Transfer (EFT) and integrate with the Pension, Public Debt Management & Payroll system.
• Enhance provision of timely, accurate & quality financial services for value based economic growth.

Business Pain Areas

• Need for an integrated Financial Management System.
• Need for tailor made professional courses for the IFMIS users to focus on overall professional growth.
• Broadening the IFMIS user's competency in terms of their skill set expansion based on their roles in the organization.
• Foster a learning culture, by providing frequent and regular professional training opportunities.

Key Benefits

• An integrated and automated Financial Management System, which facilitated effective public financial management for value based economic growth.
• The custom made DATAMEdu training programs ensured the overall growth of the IFMIS workforce, as the training programs emphasized not only on the role-based technical aspects but also soft skills improvement.
• DATAMEdu ensured future enablement of IFMIS in terms of training the workforce with the latest technologies in the market and also provided certification programs as and when necessary.
• DATAMEdu ensured that IFMIS Academy is self-sustainable in the coming years and emerges as the best academy within the Government of Kenya establishments.

Overview

Jamii Telecommunications Ltd is a Kenyan company incorporated in 2004. JTL's offerings include Carriers Network Services, Internet Backbone Services, International Data and Voice Services, Satellite Solutions (SCPC, DVB, and VSAT), Broadcast Signal Distribution and Public Data Network services.

Business Pain Areas

• JTL wanted to manage costs associated with its projects and issue invoices in a timely manner for its customers.
• Maintain support for the company's CRM applications to facilitate field service support to customers.
• Ensure consistent system performance and expand functionality to meet the needs of company's field technicians and call center staff.

Key Benefits

• Streamlined business processes with centralized access to financial, project, procurement and Customer Relationship Management (CRM) data.
• Consolidated call center operations, driving cost savings and streamlining customer service.
• JTL gained greater visibility into inventory, sales and marketing costs.
• Enhanced Project invoice accuracy by centralizing project information.

Overview

Nakumatt Holdings Ltd is East Africa's leading supermarket chain. As the largest retail market player in East Africa, Uganda and Rwanda, has 29 stores dealing in general retail merchandise. Nakumatt's store formats range from convenience stores, supermarkets to hypermarkets that showcase distinct world-class shopping floor layouts and amenities.

Business Pain Areas

• Provide up-to-date business information to improve administrative control and enable strategic decision-making.
• Replace a legacy financial application that required time-consuming manual data entry.
• Centralize and automate financial reporting across the chain and reduce the risk of accounting errors.
• Incoherent distribution processes across the chain
• Upgrade to R12 to leverage advanced functionality and eliminate redundant customization

Key Benefits

• Improved accuracy of data and invoices which shortened sales outstanding by 10 days and improved revenue and cash flow.
• Improved supplier payment turnaround and improved overall supplier satisfaction.
• Improved accuracy across Procure-to-Pay cycle.
• Provided better visibility and control of inventory, reducing cost of product returns by 50%.
• Successfully demonstrated Upgrade to R12 leveraging improved functionality for process optimization