Gorgon Project

 

Senior Analyst/Developer, Database Administrator

In charge of:

  • Timesheet system: SQL Server database/MS Access/ASP.NET

  • HR and Billing system: SQL Server database/MS Access/ASP.NET

  • Weekly timesheet data loads from Offices and Sites which did not use KJVG timesheet system

  • Regular and ad hoc Internal (Finance, HR, Project Controls, Commercial), Partner and Client reporting

  • Business Intelligence reporting, regular and ad hoc

  • Audit data preparation and queries resolution

  • Functional and Technical Support

  • Finance database team

Project-Specific Work

Improved current systems

  • Cleansed and deduplicated data

  • Added data validation to improve data integrity and business rules management, as well as better data consistency between the two systems and overall project data

  • Developed procedures and tools for data propagation between the systems

  • Wrote user guides

Improved data delivery to Partners

  • Developed mappings and overseeing execution of weekly timesheet exports for Partners Payroll systems (SAP, Oracle Payroll).

  • Developed procedures, mappings and reporting to ensure better data delivery to Partners

Automated timesheet lifesycle management - Full SDLC

Developed extension to timesheet portal application featuring:

  • Enforcing timely timesheet entry, based on business rules, through automated reminder emails

  • Timesheet checks, approval, finalisation and archiving

  • Automated reporting to all levels of management

Reconciled historical and improved current billing data

Proposed, managed, developed and executed and the project involving:

  • ETL of historical monthly billing spreadsheets (hundreds) into a staging database

  • Reconciled the collected data against Man-hours system and Financial System invoices

  • Created data mart, cubes and aggregations

  • Prepared reports for KJV Management, Partners and Client review

  • Developed workflows to apply the same processing and reporting for regular monthly billings

Outcome: A 99.5% successful validation rate on first-time invoiced billings

Recovered unbilled hours for billing

  • ETL of partners data sources into a temp data store

  • Reconciled and consolidated hours in Partners and KJV timesheet and identified unbilled hours

  • Bulk loaded missing hours and generated reports for Partners and Management review and Client review and approval for billing

Outcome: Unbilled man hours reduced by 95%

Set up overtime hours billing including historical unbilled hours

  • ETL of Partners overtime hours into a temp data store

  • Reconciled and consolidated against the KJV timesheet system

  • Applied business rules (different for each of 8 sites/countries) to calculate amounts and generated reports for KJV Management, Partners and Client review and approval for billing

  • Set up extension to the system for subsequent monthly overtime billings

Outcome: Close to 30K overtime hours recovered and billed and subsequent regular overtime billing

Expat tax Equalisation

Proposed solution, developed, managed and executed:

  • ETL of Partners’ source files into a staging database

  • Reconciled collected data against KJV databases and invoices

  • Applied business rules and developed historical, and then updated monthly, a Benchmark Data marts and generated reports to assist Partners investigate their systems for unbilled taxes

  • Developed and executed reports of unbilled taxes for Partners’ and KJV management review and Client review billing approval

  • Set up workflows and processing for subsequent monthly tax billings

  • Developed forecast for the final bulk billing, required before Tax Equalization close-up

Outcome: Substantial costs recovered

Retention Bonus System

  • Advised on business rules for the Retention Bonus application development

  • Developed and executed bulk data loads for Retention bonus processing

Client Resource Planning System

  • Advised on business rules and database design