Client : Kelusa Capital Funds, New York
Team Size : 3
Software : VBA, MS Access, SQL, Excel macros, Google Appscript
Role : Software Engineer, Project Management
Terminal : Bloomberg, Thomson Reuters
Involved in development of automating Variance, Equity derivatives calculation using MS ACCESS, VBA, SQL and Excel Macros
Creation of Various consensus estimates, Target Price Monitor , Liquidity Reporting, Alpha Analysis, Daily PNL and Trade charts
Involved in Project Management, development and enhancement of projects and support NewYork, HongKong and Singapore Clients to query database and provide data as per need and other Financial and Operations support
Analyzing compatibility for Reuters and Bloomberg terminal with relevant formula
Responsibilities
As Technology Manager:
• Involved in analyzing, designing and implementing the requirements from the users.
• Responsible for all projects lifecycle phases, from data modeling, system architecture, specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Ensure projects are completed on time and within budget, achieving 97% success rate.
• Extensively use Excel functions in development, focusing on read/write integration to databases.
• Reduce FTE work time by writing VBA code and using macros and formulas to speed processes and maximize accuracy
• Database maintenance and Support
As Operations Manager:
Carried out entire Payroll, recruitment and HR functions including Budget Reconciliation and Tax calculation, Management of Project, Project cost analysis

Client : Standard Chartered Bank, Singapore
Team Size : 7
Software : VBA, MS Access, SQL, Excel macros, Quantitative Finance
Role : Software Engineer, Project Management
Involved in development of automating Variance, Equity derivatives calculation using MS ACCESS, VBA, SQL and Excel Macros
Maintenance of Black Rock Solution reports and Risk operations
Involved in Project Management, development and enhancement of projects
Responsibilities
• Involved in analyzing, designing and implementing the requirements from the users.
• Responsible for all projects lifecycle phases, from data modeling, system architecture, specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Ensure projects are completed on time and within budget, achieving 97% success rate.
• Extensively use Excel functions in development, focusing on read/write integration to databases.
• Reduce FTE work time by writing VBA code and using macros and formulas to speed processes and maximize accuracy
• Database maintenance and Support

Client : Credit suisse, Singapore
Team Size : 5
Software : VBA, MS Access, SQL, Excel macros
Role : Subject Matter Expert, System Developer
Tools : MET, MARS
Involved in development of automating Variance, Equity derivatives calculation using MS ACCESS, VBA, SQL and Excel Macros
Involved in Regional reporting for SRM Team across APAC and support BAU activities to query database and provide data as per need
Responsibilities
• Involved in analyzing, designing and implementing the requirements from the users.
• Responsible for all projects lifecycle phases, from data modeling, system architecture, specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Ensure projects are completed on time and within budget, achieving 97% success rate.
• Extensively use Excel functions in development, focusing on read/write integration to databases.
• Reduce FTE work time by writing VBA code and using macros and formulas to speed processes and maximize accuracy
• Database maintenance and Support

Client : DBS Bank, Singapore
Team Size : 1
Software : VBA, MS Access, SQL, Excel macros, Qlikview
Role : Subject Matter Expert, System Developer
This Project focuses on the utility of the staff skills across entire consumer banking. This project serves as a golden source for all the data including staff details, staff skills, Skills required to perform entire banking operation and the work volume. When there is increase in work volume in a particular team, the staffs that possess same skill in other team are searched from the database and are made available for the required team manager.
Based on search criteria, an auto email is triggered from system and audit log is maintained. Various management reports are available to know the borrow/ loan status of staff, Staff Competency , staff who lack skills are subject to training and thereby ensuring 100% staff skill utilization is attained to achieve maximum efficiency.
Operational error made by staff and vendor are monitored and tagged to individual profile. Email is triggered to Risk team for various MAS Violation and verification and approval of errors are captured in the database.
Various Reports and MIS error reports and risk analysis reports and charts are available for all levels of Management to enhance Operational improvements.
Responsibilities
• Involved in analyzing, designing and implementing the requirements from the users.
• Involved in analysis of errors caused by staff from the database and send error report to Risk team and development of various charts for Vendor error, Staff error and Error Report for weekly basis, Monthly basis, Yearly basis
• Responsible for all projects lifecycle phases, from data modeling, system architecture, specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Ensure projects are completed on time and within budget, achieving 97% success rate.
• Extensively use Excel functions in development, focusing on read/write integration to databases.
• Exported information from report generated by accrual database to accrual upload in Qlikview for charts for Business analysis
• Reduce FTE work time by writing VBA code and using macros and formulas to speed processes and maximize accuracy
• Database maintenance and Support
• To ensure 100% volume of staff skills are utilized across entire Consumer Banking Operations by providing charts

Client : K2 Specialists
Team Size : 2
Software : VBA, MS Access, SQL Server
Role : System Developer
This Project deals with Payroll Computation. The HR and Finance has the access to compute the payroll for all Employees. The Main thing about project is to calculate Net pay depending upon their site allowance and the working hours and CPF calculation is automatically calculated depending upon their age and Residential Status. All reports can be exported for references. CPF List are then uploaded and filed to the website.
Role based access control is maintained and HR manager and Finance Manager can view and print the Employees Pay Slip.They can assign or update the resources for the projects. Employees can get mail on Monthly Pay Slip, Salary Split up.
Responsibilities
• Involved in analyzing , designing and implementing the requirement as project
• Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Ensure projects are completed on time and within budget, achieving 97% success rate.
• Extensively use Excel functions in development, focusing on read/write integration to databases.
• Exported information from report generated by accrual database to accrual upload in SAP.
• Assisted with automation of finance department’s manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy
• Database maintenance and Support