Banner Image

All Services

Business & Finance

Big Data Analytics

Passed Chartered Financial Analyst(CFA) Level II (2017) Supply Chain and Finance Manager for Caltex Belfast. Caltex Belfast is a retail gasoline station in a price war area. The challenge was to attract both public and private vehicles to the station while keeping margins high. I designed the information system with the use of Microsoft Access and VBA programming in order to have efficient, timely and accurate reports. With the use of this system, Caltex Belfast was able to tweak marketing efforts to maximize impact and minimize spending. All in all, the station was able to achieve a volume of 300,000 liters per month, way above the target volume of 160,000 Financial Systems Analyst of Ilaw at Iba pa. Ilaw at Iba pa is an electrical supply distribution company that experienced rapid expansion during the past 3 years. However, financial reporting and inventory control were not able to keep up with the rapid expansion and the ever-increasing need for accurate and timely top management reports. After doing a system audit, it became apparent that the warehouse system needs to be improved by introducing a better information system. Reporting accuracy increased by almost 10% after the stock management system was introduced. Systems Analyst of MaxFV Corporation. MaxFV Corporation is a lending company that pools money from investors or through loan lines and invest in small medium enterprises. I integrated the banking feeds to the accounting system in order to have timely and accurate report allowing the team to flag potential non-performing loans early on. Our team also established a system that would thoroughly filter potentially non-performing investment. Because of these, MaxFV Corporation has less than 10% of non-performing assets from its PHP 90 million asset base. Given this performance, the company was able to secure more loan lines, significantly reducing the cost of capital to just under 5% per annum. Systems Analyst of Nachobimby Pilipinas Corporation Warehouse. Nachobimby Pilipinas Corporation is a startup snacking company with a booming number of outlets. The challenge is to take advantage of the existing technologies to have a faster and more orderly procurement process. I led the team in making the Shopify platform and deeply integrating it with QuickBooks with the use of Microsoft Access open database connectivity tools. Backorders were significantly reduced because of better forecasting methods. Erroneous deliveries and miscommunication were also significantly reduced with the new system.

About

$15/hr Ongoing

Download Resume

Passed Chartered Financial Analyst(CFA) Level II (2017) Supply Chain and Finance Manager for Caltex Belfast. Caltex Belfast is a retail gasoline station in a price war area. The challenge was to attract both public and private vehicles to the station while keeping margins high. I designed the information system with the use of Microsoft Access and VBA programming in order to have efficient, timely and accurate reports. With the use of this system, Caltex Belfast was able to tweak marketing efforts to maximize impact and minimize spending. All in all, the station was able to achieve a volume of 300,000 liters per month, way above the target volume of 160,000 Financial Systems Analyst of Ilaw at Iba pa. Ilaw at Iba pa is an electrical supply distribution company that experienced rapid expansion during the past 3 years. However, financial reporting and inventory control were not able to keep up with the rapid expansion and the ever-increasing need for accurate and timely top management reports. After doing a system audit, it became apparent that the warehouse system needs to be improved by introducing a better information system. Reporting accuracy increased by almost 10% after the stock management system was introduced. Systems Analyst of MaxFV Corporation. MaxFV Corporation is a lending company that pools money from investors or through loan lines and invest in small medium enterprises. I integrated the banking feeds to the accounting system in order to have timely and accurate report allowing the team to flag potential non-performing loans early on. Our team also established a system that would thoroughly filter potentially non-performing investment. Because of these, MaxFV Corporation has less than 10% of non-performing assets from its PHP 90 million asset base. Given this performance, the company was able to secure more loan lines, significantly reducing the cost of capital to just under 5% per annum. Systems Analyst of Nachobimby Pilipinas Corporation Warehouse. Nachobimby Pilipinas Corporation is a startup snacking company with a booming number of outlets. The challenge is to take advantage of the existing technologies to have a faster and more orderly procurement process. I led the team in making the Shopify platform and deeply integrating it with QuickBooks with the use of Microsoft Access open database connectivity tools. Backorders were significantly reduced because of better forecasting methods. Erroneous deliveries and miscommunication were also significantly reduced with the new system.

Skills & Expertise

AccountingAnalyticsBig DataConsumer LendingData AnalysisData ManagementElectrical EngineeringFinancial AnalysisInventory ManagementInvestor ManagementLine ArtManagementMarketingMicrosoftMicrosoft AccessPHPProgrammingQuickBooksReport WritingReportsRetail SalesShopify DeveloperSystems EngineeringVBA

3 Reviews

  • Kirk 53 says,

    Kevin is very knowledgeable, responsive, and proficient. Highly recommended.

    for Accounting help on Apr 03, 2020

  • Kirk 53 says,

    Kevin is fantastic. Very good at what he does and reliable. Highly recommended.

    for Accounting help on Jan 25, 2020

  • Kirk 56 says,

    Kevin has proved a giant help in my bookkeeping efforts. He is knowledgeable, responsive, and efficient. Highly recommended.

    for Assistance bookkeeping on Oct 18, 2019