S - MS Excel is being used as margin ruler and template label for continues-paper printing sheet by finance team way back 2012. Another challenge at the time is we are down with one employee who is our messenger which is vital as credit and collection.

T - As a new hire and fresh graduates, I introduce the features and capabilities of MS Office especially MS Excel

A - The time I spent in office exceeds the normal 8 hours since I am covering to our Messenger who leave without notice. For me to deliver both Messenger task and Clerk task - i programmed my routinary tasks such as encoding, analysis and reporting. I was tasked to conduct a 1 hour program (per week) to those who want to learn and improve their MS Office skills and thought them to use conditional formatting, formulas, drop-down and even proper paper and printing setting

R - After series of improvement, our daily cheque deposits, Collection Report, Cashier Report, Cashflow Report are now using same template monthly, quarterly and annually with proper presentation, accurate formulas (part of accounting standards and principles) and with built-in double checker or quality control.

S - The Manila's MIS Team (Mgt Info. System) handles 108 Reports across all Timezone (WHEM, EMEA and APAC).

T - Our Team decided to conduct multiple test, reassessments and collaboration in order to achieve our main goal which is to assess risk and criticality of the reports as well as it's total impact to the audience and receipients. System and tools involved such as Rumba, SAP, Bloomberg, TLM, User-Defined Type in SQL and R Programming, User Acceptance Testing, MS Access, MS Powerpoint, MS Excel and MS Word.

A - Placing internal controls, streamlining workflows, mapping process and integrating digitalization, machine learning and creation of process enhancement via visual basic and Macros. This include Straight Through Process, Match Rates, Sourcing Rates, Efficiency rate and System Health Checks. Repeatitive and redundant reports as well as non critical were eliminated or transformed into another major report that saves effort in the side of processor/MIS Analyst.

R - From 108 MIS Reports down to 30 Main Reports that saves 4 FTE (Full time employees) in terms of manual  effort. Received an Innovator Award 2x for two consecutive years because of the projects impact and improvement.

S - Managing of AR Report with 130+ Business Partners using  Gsheet and manual reconciliation weekly  for the Collect and Install (CnI) Process of Globe Telecom with external technicians and vendors (Deposits, Acknowledgement Receipts and Deductions)
T - Aside from liaising with multiple business partners and their accounting leads, my task is to complete the updating of their CnI Books in a weeks time that will start from Tuesday to incoming Monday cut-off. Once Gsheets were updated based on our OWFM (Operations Workforce Mgt System) weekly report for AR side, I also checked our Deposits Report coming from Banks, GCash and Cash receivables and reflect it in the CnI Books that leaves the oustanding balance as deductibles or Accounts Receivables.
A - Collaborating with our Dev Team and Tech Team to onboard external parties in a specific webtool account and the stakeholders will easily download their reports and how to automate the reports and enhance User experience and support. Create a roadshow where all vendors and partners onboarded knows how to use, read and navigate the webtool even troubleshooting. Technically this project eliminates the preparation and creation of report until the manual updating of each gsheets take 4 hours of our day that is also prone to risk due to human intervention as well as the regular external cadence due to ageing breaks.
R - Saves .5 FTE (daily basis) due to system enhancement and process improvement with additional improvement of maininting and coordinating with only 60 main Partners.

S - During my time working personally under our Head Butler Roy Ben Shlomo, I noticed his system and his operations specially on scheduling, inventory, accounting and book keeping. I proactively offer my assistance and talent to personally help the business for smoother and systematized operations.
T -Using my background on MIS (Management Information System) and Accounting, I initiated to study, analyze and change the accounting of the Executive Butlers and created one customized master file for the accounting for the day to day business that presents the whole picture of the company in accounting language.
A - I created and presented an Investment Report of the Company for Investors in Israel and for opening a new branch of Executive Butler in United States after studying and analyzing the business. We have closed the deal for both projects and expanded the horizon of the company not just in Israel and London that now in United States as well. 

R - The additional Investment which is the Asset was received and used as well as additional investor came to make A new Branch of Urban Butlers which is now operating in Colorado as of Oct. 2019. The Investment Report includes templates of operations, inventory, cashflows, payroll, Financial Services and Company's Bible. I was awarded of a large sum of money on top of the tips I received from Butlership.

S - Dr. Ed Malagapo with his connection to 7 universities inside the Philippines provide Graduate School services in the Middle East. The CEO needed coordinator or executive assistant that can accompany him with background in IT due to challenges in technology and the actual coordination overseas. 

T - Dr. Ed and his wife as our Controller - Accountant together with other member of his board does not really part or heavily involved in day to day business as usual of the CEO. From Booking of flight in and out of the philippines, booking of hotel room for lodging and booking of hotel's conference rooms for conducting the examinations, consultations and classes are manually done almost every month to various places since there are several students part of the graduate programs in the Middle East that he needs to meet and teach. Also, proposed to standardized our operations for clear coordination and structures like list of documentations, requirements, breakdown of payments and services etc. I also created a webtool account that can be used by the professors and students where all modules, schedules, books, reviewers and examinations are saved and used. 

A - Established Procedures on how to 1.) Maintain, troubleshoot and edit our Business Web and Software; 2.) Is the daily, monthly and our activities per event for example during Schools Admission, Examinations, Graduations, and the likes. It comes with detailed SOPs, Templates on Cashflows, BookKeeping and Financial Accounting. I also introduce and suggested the use of conferences call like Microsoft Teams, Google Meets and Zoom Meetings in order conduct classes, examinations and consultations to lessen the opex under Travels. 

R - During Pandemic, our system and operations became ready for the lock down and quarantine since we already started using Zoom Meetings with our students from other places like UAE, Qatar, Kuwait, KSA, Bahrain, Oman and Philippines. We had a resilient operations with no disruption during Pandemic. We have a large amount of savings due to digitalization and conferences using zoom meetings. 

S - The Globe Telecom Inc. and TowerCos such as MIDC, Philtower Inc., Frontier Philippines and Unity Infrastructure Inc. agreed to join for the Sales and Leaseback Project or Project Universe which is 90 Billion Pesos Project were Globe owned Cell Sites (Nationwide) and it's Passive Assets are to be awarded and leased to TowerCompanies in 3 years time. The challenge here is the 8-man team became 1-man team which I am the only member of the original Project Team. 

T - While working under Revenue Accounting for 1.5 year, our CAO and other leaders personally handpicked me to be part of the Project Universe. It's an 8-man team which I've become part on the latter part. I am responsible on derecognizing all Project Related Assets as well as providing report to our leaders specially under Financial Control Division.

A - Since all numbers are established and reported, at first I proposed to gain access and profile on Business Intelligence such as Microsoft - Power Bi but due to fixed budget, metrics and analytics are asked from me manually. In order for me to deliver these various reports I have to create analysis and digitalization through the use of SAP S4 Hana, BSQL, Python. By Dec. 2025, the Project Universe is concluded and is now sunset at 93% completion since the remaining 7% or a total of 4 Billion Pesos remained unsold. These 7% percent is now absorbed by another project with the target to be sold in a couple of years. 

R - Being the sole survivor on the project and was tasked to deliver multiple reports from different perspective from Cell Site's Type, Age, Average net book value, Location, Region, recognizable gain and etc., I replicated Business Intelligence reports using the limited tools I can use and provide these reports without disrupting the BAU since I have to collaborate with multiple teams such as Payments Team, Business Analysts, Lease Team and specially the Fixed Assets Accounting Team which I am part as a sub-team.