Software Engineer

• Apr 2021 - Present

Senior Software Developer/Engineer

• May 2019 - Apr 2021

Worked in KTP research project COSTA, which aims to convert excel financial planning spreadsheet into TM1 applications. Developed RESTful micro-service in java to convert multi-dimensional financial planning OLAP model representation in excel and json into TM1 applications in Planning Analytics Workspace (PAW) using TM1 rest api and micro-services. Developed a model builder which handled the TM1 object creation in PAW using different micro-services from json and excel definition. Apache POI was used to read the Tm1 model definition in excel. Developed a dashboard and widget template engine to create UI components in PAW. The service used the model builder and template engine to create TM1 objects and UI objects in PAW. To achieve this one require an in-depth knowledge about TM1 database and PAW.Worked on spreadsheet analyser engine to develop a TM1 rule generator in python, to convert excel expression and formulas into TM1 rules and functions. Developed a report generator in python using openpyxl to generate excel report. The report generator extract the report data from the spreadsheet analyser to provide an in-depth understanding about how the spreadsheet was converted to TM1 objects and application to the user.

Senior Software Engineer/Developer

• Apr 2018 - May 2019

Worked in Guided planning project, to develop a web application that offer guidances during OLAP application creation by combining dashboards from different TM1 databases for contribution workflow. Design and developed RESTful micro-service and UI service layer using OPEN-API specification in Java and Reactjs. The micro-service was responsible for validation and management of selected tm1 objects to be used in application. The application defined was persisted in apache Cassandra content store. The micro-service and web application were deployed in docker container. Worked on the UI to build React component to display application validation results and to integrate the custom dimension editor widget to micro-service. Worked with Planning Analyst Trial team on some UI enhancement and maintenance.

Software Engineer/Developer

• Jan 2010 - Apr 2018

Worked on Performance Modeller (PM) and Cognos Insight, java rich client interface to TM1 OLAP database to replace legacy TM1 architect. Developed several front and back end features in the product to reduce the complexity involved in modelling OLAP financial planning models. Improved the scalability, stability and performance of the products. Enhancement were introduced into the existing features based on customer requirement, fixed several issues raised by customers in features developed by other teams and developers for different release cycles following TDD/BDD across the entire stack. Please refer to accomplishment section for further details.

Software Engineer/Developer

• Mar 2008 - Dec 2009

Worked on Cognos planning OLAP engine called JCE to add time based statistical and maths functionality using language J. Developed a model reporting tool using JCE java api to provide insight into the OLAP model object's structure and their relationships, The model was built with help of UI interface and exported as XML. The reporting tool generated a html document using java template engine Velocity by deserialising the model XML into JCE as OLAP objects. JCE java api was utilised and improved to extract the information about model objects and their complexities.

Research Analyst

• Dec 2006 - Dec 2007

Worked as research analyst, to build financial forecasting and trading system that would enable high frequency trading (Algorithmic trading) and stock portfolio management. Design and developed tools that uses machine learning and optimisation algorithms. Built a CFD stock market simulator and genetic algorithm based optimiser in java using math and statistical libraries. The optimiser objective was to choose the right combination of technical rules and data modellers which maximised the profit over a given period. Other duties involved integration of the different component of the system which were developed in languages (Matlab, C++, java) using bash scripting.

Visting Lecturer

• Sep 2003 - May 2006

Provided lecturer for the module Program Development on object-oriented concepts and implementation details using JAVA at master level. Provided tutoring assistant during the workshop for module Digital System Development and Software Technologies for the Web at graduate level.Handled workshop in C language at graduate level. Responsibilities involved, guiding student in understanding programming concepts in C.

Research Associate

• Jul 2004 - Nov 2005

Worked as Research Associate on Dti / EPSRC Wide Area Distributed Problem Solving (DIPSO) project to build a grid-enabled distributed design problem solver that links two Artificial Intelligence modules for modeling and optimizing complex multi-variate design problems. Was responsible for building the AI modules which were exposed as SOAP webservices and deployed using Apache tomcat and axis2 engine. Developed several machine learning, optimization algorithms, using java numerical statistical libraries for the AI modules and tested them against real world design model provided by partner SEA Limited SEA Limited, Evotec. Worked on the development of a web application to interact with the AI modules.