Michael Angelo G. Arceo

I’m looking for a position where I could showcase my analytical skills and problem-solving abilities. TECHNICAL SKILLS • • • • • • • Data Warehousing Data Mining Business Process Analysis MS Office 365 (Excel, Word, Power Point) Advanced Excel (Power Query, Lookups, Pivot, VBA, Macro, Charts) Business Intelligence (Power BI, DAX) Database Manipulation (SQL, MySQL, Microsoft SQL Server) PROFESSIONAL EXPERIENCE Reports Analyst, MVP Asia Pacific Inc. Philexcel Business Park, Clark Freeport Zone, Angeles Pampanga February 2020 – Present Responsibilities • • • • • Assist the client on all spreadsheet related request. Create automated reports in excel using VBA, Power Query, Google AppScript or Python. Create Ad Hoc reports. Clean and analyze data Give foresight and opinion based on the trends of data Reports Analyst, Shearwater Global Healthcare Solutions Bonifacio Global City, Taguig May 2018 – January 1, 2020 Responsibilities • • • • • • • • • Generate Daily KPI’s and Ad hoc reports for all LOB Manage the attendance and capacity of our account Create Dashboards for Weekly and Monthly Volume of each LOB Assign Task to employees. Develop reports automation. Give insights to our OM and PM regarding our data. Create Invoice and revenue report. Create Scorecards and QA reports. Manage the tracker for all LOB Reports Analyst/Business Analyst Hewlett-Packard Inc. (HP Inc.) Ayala Avenue, Makati January 2018 – May 2018 Responsibilities • Create KPI reports • Update Inventory of Online Stores (Lazada, Ingram Micro) • Manage Online Store Promotions • Schedule Automated Reports • Manage Product Trends • Monthly and weekly reports for all online stores in Asia pacific region • Revenue reports of call center sales of outsourced agents (Teletech, SellbyTell) • AHT and Abandon rate report for CSR department • Create Backorders Report • Create Inventory fulfillment report Corporate Risk and Broking Analyst, Willis Towers Watsons Bonifacio Global City, Taguig April 2017- December 2017 Responsibilities • Create a tracker tool in EXCEL VBA for all the associates in different teams • Generate Reports for SLA, Task Scores, Targets • Troubleshoot Program Errors or User Errors • Train Associates, QC and QA on how to use the system • Issue insurance certificates Experience Gained • Learned how to Create Complex Reports in Excel • Learned How to use Developer mode and VBA in EXCEL • Gained more knowledge in Business Analysis • Created a lot of Flow Charts • Learned Insurance Process Certification/Awards • Certified Insurance Service Representatives (CISR) • Certificate of Recognition IT Staff Holy Family Academy Angeles City, Pampanga May 2015-October 2016 Responsibilities • Maintain the Computer Section in the Library • Implement and maintain a new open source library system (Koha Library System) • Maintain a free hosted website I created in WordPress hfagslibrary.wordpress.com Experience gained • Developed a website in WordPress • Implemented a LAN based connection using N-computing • Made a lot of SQL reports in Koha • Learned how web integration works • Created Day Time Monitoring system • Learned a lot in PHP, MySQL and JavaScript EDUCATIONAL BACKGROUND Tertiary Education Don Honorio Ventura State University B.S. Information Technology- Bacolor, Pampanga Secondary Education Pampanga High School- San Fernando, Pampanga PERSONAL INFORMATION Civil Status: Birth Date: Single April 17, 1995 Sex: Male All the above representation on this data sheets are to the best of my knowledge and I have not knowingly omitted any related information of an adverse matter. MICHAEL ANGELO G. ARCEO