Master Excel

Intermediate to Advance Excel Use for Finance practitioners.

Alejandro "Allan" Palacio is a seasoned data analytics professional using Excel, Tableu, ACL and IDEA. He has worked on various high profile projects requiring the use of data analytics and accelerated reporting process to include:
• Php 40 million project involving the cleansing of SAP database for a certain multinational Company
• Php 20 million project involving the investigation of a massive bank fraud totaling Php14 billion.
• Php10 million project involving the validation of the attendance of over 15,000 personnel and reconstruction of payroll for a multinational Company involving 500 thousand data.
• Php 8 million project involving the validation of sources and uses of donor funds covering over 10 years of data
• Php 3 million project regarding the investigation of an alleged procurement fraud committed by a certain US federal service contractor involving over 12 million data spanning across 10 years of transactions
• Php 3 million project involving the reconstruction of insurance receivables of certain companies totaling over Php200 million His passion for teaching and developing seminar courses led to the conduct of best-selling seminars on various topics such as data analytics, risk based auditing, fraud audit, ERM and audit tools. Allan recently served as the Professional Development Manager of IIA Philippines. Prior to this, he was with Grant Thornton Vietnam as Senior Manager for Advisory Services where he established the firm’s Business Risk Services practice focusing on enterprise risk management, IT services, fraud and forensic, internal audit and consulting. He was also with Grant Thornton Philippines (Punongbayan and Araullo) as managing consultant. His diversified experience in delivering advisory services to various companies in different industries provided him with a unique perspective that he will share with the seminar participants. Allan is also a board topnotcher (6th place in the May 2003 CPA exams) and continues to keep in touch with the academe by being a CPA review lecturer at PSBA – Quezon City. He is a highly sought after speaker on data analytics and computerized audits by various organizations such as Information Systems Audit and Control Association (ISACA) Manila, Institute of Internal Auditors Philippines (IIAP), Center for Global Best Practices, Grant Thornton Vietnam and Cambodia, Association of Chartered Certified Accountants Vietnam, and International Data Group Cambodia. Sector experience Allan has diversified eleven (11) years of experience with the top professional firms specializing on risk management, IT, fraud, internal audit, consulting, and public accounting. His relevant industry experience include banking and finance, insurance, manufacturing, retail and distribution, non-profit, hotel and casino, services, technology, pharmaceuticals, power and utility, mining, transportation and entertainment.