Profile of Assignments

Technology

PowerBuilder Application Development & Support 

European Research Company

An European based animal food company with a state-of-the-art research facility in the Netherlands. Approached OCS Consulting’s specialist PowerBuilder Division for support with the migration of their PocketBuilder applications to Appeon 2017-Appeon PowerServer.  The Client needed the ability to run these applications on android devices as well as integrating with mobile barcode scanners. Sybase SQL Anywhere is currently being used as the backend of choice. During OCS’ time supporting the Client they also offered training to the Client’s internal resources.

Belgium Logistics Company

Migration of application from PowerBuilder 7 to PowerBuilder 2019R2, including replacement of database drivers and remediation of database issues due to the age of the application.

International Food Retailer

This international food retailer approached OCS to take on responsibility for support of a business critical PowerBuilder application, to free up internal resource for project work.  Having familiarised themselves with the application OCS took on primary responsibility for supporting this application, which is  used  across the retailer's estate.  OCS have been supporting these PowerBuilder applications since 2015, assisting with various migrations and enhancements, working with versions starting at Sybase PowerBuilder 12.5 through to Appeon 2019. OCS were also tasked with integrating restful webservices with this application.

UN Organisation

OCS worked with this UN Organisation to upgrade its pension system from PowerBuilder 12.5 to PowerBuilder 2017R3, including some enhancements to the systems functionality.

UN Organisation

OCS worked with this UN Organisation to undertake an Upgrade Impact Analysis for the migration of a PowerBuilder 9 /SQL Server 2008 application to current supported versions. We performed the upgrade by upgrading applications from PowerBuilder 9 to PowerBuilder 12.6 and SQL Server 2008 to SQL Server 2012 and supported all stages of the Project/SDLC.

International Telecoms Group

Development project to enhance a core subscriber management and billing system to enable the introduction of Pay Per View services to cable TV customers. Developed with PowerBuilder, Sybase ASE in a Windows environment.

Belgian Bank

OCS worked with a Belgian bank to upgrade large PowerBuilder systems from PowerBuilder 12.6 to PowerBuilder 2017R3.  The assignment, which included working on and off-site, included the re-development of a number of applications to resolve performance issues, and the adoption of GIT for source control.

International Car Manufacturer

OCS has had a relationship with this client spanning 25 years. Recent assignments include the implementation and migration of PowerBuilder 11.1 on their existing Sales Order Processing System. This system controls the sales process including; sales orders, purchase orders, full reporting, control of demo fleet and client facing letters. The system has been designed for international deployment encompassing database driven facilities for language selection and multiple currency capability. The Application is based on PFC.

OCS designed and implemented the technical solution using PowerBuilder 11.1 against SQL Server 2005, undertook Unit and System testing, and providing
Provide ad-hoc support and maintenance.

London Market Insurer

Assisted with change requests and bug fixing for the Market Entity system currently in PowerBuilder 11.5. This application is core to their business, controlling the relationships between all the different entities internally and this system then feeds all other systems within the clients business.

Global FMCG

OCS has been providing this global FMCG PowerBuilder 9 application development, maintenance and support since 2008.  This system controls the sales process including; sales orders, purchase orders, full reporting, forward contracts and forecasting. Based on this success and OCS’ strong knowledge of the domain, the client awarded OCS the contract to take over full support of the departmental applications as the client decided to move to a full global support model.

OCS was able to take on, not only the modern technology aspects of the applications, but also to take responsibility for all 3rd party software within the suite, providing the client with a one-stop-shop remote support service, linking directly into their international help-desk system.

PowerBuilder Application Development & Support 

Global Car Manufacturer

OCS has been working with this Global Car Manufacturer since 2012 undertaking:

  • PowerBuilder development, upgrades and testing. Multiple upgrades, versions 12.0, 12.5.1, 12.6, 2017R3 and 2019R3Microsoft SQL Server development (including SSRS and SSIS) and upgrades, versions 2008, 2012, and 2019.
  • Microsoft SQL Server development and upgrade, version 2008 to 2012
  • Maintenance and development of existing and new database processes as the requirements of the business have evolved
  • Handling live support issues raised by the business in a wide variety of areas. Including analysis of data and process to determine cause and scope of issues raised, proposal and implementation of data corrections, identification of system issues during normal operations and when there has been disruption to systems.
  • Liaised with the business to specify and implement enhancements to existing systems.
  • Liaised with 3rd parties from a technical standpoint, to ensure the transition from one major supplier to another was as smooth as possible.
  • Java and .NET analysis, support and development services. 


International Consultancy to Power Industry

Since 2002, OCS has been working with this consultancy and having responsibility for the development and maintenance of meter processing and invoicing systems for several power stations. Key activities have included:

  • Created real-time metering data processing via Windows Services, SQL stored procedures and linked MS SQL servers
  • Migrated PowerBuilder applications from version 9 to 11
  • Migrated MS SQL Server databases from SQL Server 2000 to 2005
  • Created and modified stored procedures in MS SQL Server 2000/2005 to evaluate complex formulae for the production of monthly invoices
  • Created data load macros in Excel using VBA
  • Modified front-end PowerBuilder application for the display and export of invoice details and to allow user modification of appropriate variables
  • Created new PowerBuilder applications to assist with error reporting and the acquisition and pre-processing of plant data.


30 Years of making IT Happen