Profile of Assignments

Technology

PowerBuilder Application Development & Support 

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

OCS are currently working on application support of a shop-based management system for an international high street retailer, which is being used in over 350 stores globally.  Environment:  PowerBuilder 2017/R3 / PFC.

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.

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.

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.

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.

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.


OCS Consulting Limited
OCS Consulting Limited
30 Years of making IT Happen