RK Consultancy Services (‘RKCS’) has in-house expertise to provide clients a range of innovative technology management and solutions from improving organisational business efficiency to design and implementation of IT based platforms and reporting tools. Our core products and services include:

Excel VBA Programming

Advanced Visual Basic for Applications (VBA) programs can be developed and deployed within MS-Excel workbooks to provide powerful automation functions which enhance user efficiency, interfaces with business applications, key performance reporting and modeling requirements

Excel Reporting Automation; KPI Dashboard outputs to Email, PowerPoint, Web, etc

Using MS-Excel for the development of powerful reporting and analysis dashboards which measure key performance indicators. A variety of distribution techniques can be deployed, which includes outputs to e-mail, MS-PowerPoint presentation or web pages.

Business Warehouse &/orCrystalReports Developments

Extremely powerful report writing toolsets can be deployed to extract business system data and present user reports in graphical or detail form using ODBC and OLAP data collection protocols.

Database / Business Application Design

Development of custom-built database applications to your business needs and requirements.

Issues Register with history log

Risk Modelling & Monte-Carlo simulations using Crystal Ball_®

Using MS-Excel as a data reporting container and MS-Access as a back-end database, this standard model has been developed to provide organisations with a user-friendly interface from which to manage project risks. Features include reports to external project managers which, upon return, can update the central database, issue history reports and a variety of distribution techniques. If Crystal Ball 2000 risk analysis software is licensed, then an inbuilt advanced programming interface (API) allows risk model simulations to be created for project outcomes at the click of a button.

Financial Modelling

RKCS has significant experience with development of detailed financial, risk and budgeting models using MS-Excel and other Microsoft family products that can be integrated with a variety of automation functions (such as output to e-mail, PowerPoint, web pages) as required.

Budget & Forecast Modelling

RKCS has significant experience with development of comprehensive budget and forecasting tools using MS-Excel and other Microsoft family products that can be integrated with a variety of automation functions (such as output to e-mail, PowerPoint, web pages) as required. Data can be collected using workflow techniques over a wide area network and resides in a central RDMS. Powerful reporting features can be designed to empower users at various levels to review forecast and budget inputs prior to upload into core business systems.

Process Improvements

RKCS can provide business process review services which deliver recommendations that offer office and operational efficiencies that will save time and cost. Initiatives focus on improving quality while reducing time, effort and cost, centralising disparate legacy data and adding value at every step.

Business Systems implementations

RKCS’s consultants have broad business systems experience covering a wide spectrum of small to medium business and government with enterprise-wide implementationsfor transport and supply chain solutions, inventory and warehouse management systems, sales and customer relationship management, timekeeping, business intelligence solutions and other custom developments.

For further details in relation to successful implementation of RKCS’s Technology Management experiences across various projects refer to our list of projects or contact our office directly.