Marlito Crispino

Marlito Crispino

$8/hr
Excel Expert ( Formula/Functions / VBA Macro Programming / Automation) / Bookkeeping (Quickbooks)
Reply rate:
16.67%
Availability:
Part-time (20 hrs/wk)
Age:
34 years old
Location:
Pasay, NCR, Philippines
Experience:
6 years
Marlito M. Crispino 573-Q Ferrari St. Sto Niño De Culdesac, Sun Valley, Parañaque City-- WORK EXPERIENCE Freelancer – Consultant JOB DESCRIPTON      Data Entry Reports / Dashboard Preparation (Microsoft Excel) Automation / Process Optimization Data Analyst VBA Programming Publicis Manila (Publicis Groupe) 36th Floor, The Enterpise Centre Tower 1 Ayala cor Paseo De Roxas st. Makati City Philippines. Credit Portfolio Manager (February 2016 – Present) JOB DESCRIPTON        Handling full collection process (calling and sending emails to clients) Sending statement of account / answering queries. Reconcile accounts Payment Application / requesting to post payment against invoice. Monthly Reports (AR related reports) Handled several automation projects (mainly excel related) Facilitate Excel training (basic to advanced excel) Maersk Global Service Centres (Phils) Ltd. Levels 5-8, North Wing, Estancia Offices Capitol Commons Meralco Avenue, Barangay Oranbo, Pasig City 1600 Philippines Collections Analyst (December 2012 – December 2014) AR Analyst (December 2014 – February 2016) JOB DESCRIPTION: Collections Analyst (Brazil Cluster)     Responsible for handling certain customer accounts. (Small accounts) Entrusted to handle key clients of the Cluster (1 client that constitute 50% of that cluster’s business) Sending Statements of Accounts to the customers. Application of payments and reconciliation of accounts. AR Analyst (Latin America Region)     Preparation of weekly Accounts Receivable Report for Cluster Tops. Overdue, Aging, DSO, KPI’s, Targets VMS report for managers / supervisors (Accounts Status). Performance Evaluation Report of the collectors. (Calls, number of calls made for the week, average call time. Etc) Part of Finance Transformation (Migration of Task) Filstar Distributors Corporation 11 Brixton St. Brgy Kapitolyo, Pasig City. November 2011 – November 2012 Credit & Collection Assistant / AR Coordinator JOB DESCRIPTION: o Responsible for handling certain customer accounts. Any addition(sales) and/or deduction(payment and other adjustments) should be recorded through manual Subsidiary Ledger(excel file) and through system SL. o Preparation of Monthly reports for the said accounts, Sales report, Aging of Accounts Receivable, Past Due Accounts and related reports. o Processing Trade Financing for the company. (Selling Accounts Receivable to the Bank for cash in the cost of certain percentage of interest and service charge) Interships Accounting Staff (OJT / Internship) Lamoiyan Corporation (Mfg.) Km. 15 West Service Rd., South Superhighway, Sun Valley, Parañaque City June – September 2010 Post-dated Check Unit (PDC Unit) Staff (OJT / Internship) Citibank, N.A Citibank Square 1 Eastwood Avenue Eastwood City, Libis Quezon City. October 2010 – January 2011 EDUCATION Bachelor of Science in Accountancy Asia Pacific College # 3 Humabon Place, Magallanes Village, Makati City- ACADEMIC PROJECTS Fast Food Establishment Feasibility Study, January- April 2009 A project feasibility study establishing a fast food restaurant in Brgy. West Crame, San Juan City. As a proponent of the project, primarily responsible for the preparation of five year projected financial statements using the data and information obtained in the feasibility study. The subject course aims to equip the students on the technical know-how of the methodologies application. Microfix Computer System, January-March 2008 An evaluation for the improvement and recommendation for the improvement of the existing information system of Microfix. (Family owned business of our schoolmate). Logistics Management Research Paper, October –December 2009 A study of the logistic functions and the procurement system of the Naval Air Group located in Sangley Point, Cavite City. TRAININGS/SEMINARS Seminars Attended   Access 2010: Accounting Career Enrichment Seminar for Students, University of Santo Tomas Velayo-Sycip Multi-Purpose Hall, February 2010 From Small Time to BIG TIME, Asia Pacific College Auditorium, August 2009      PICPA South’s Financial Statement Presentation and Audit Seminar, Asia Pacific College MultiPurpose Hall, July 2009 BSA Can Do IT!, Asia Pacific College Auditorium Business Knows No Boundaries, Asia Pacific College Auditorium Gearing Up for the FLAT World, Asia Pacific College Auditorium, October 2007 Leadership Training Seminar for Standing Committee, Asia Pacific College Multi-Purpose Hall, June 2007 Trainings Attended  CPA Review, CRC ACE Review School, October 2011 batch. EXTRA-CURRICULAR ACTIVITIES   Junior Philippine Institute of Accountants, member, 2006-present Math Society, member,- PERSONAL BACKGROUND Born on October 16, 1989 in Mandaluyong City, Philippines. Interests include playing board games like chess, reading books, surfing the Internet for new ideas and information. Goal-oriented, hardworking and a God fearing person. Technical Skills Been using SAP – ERP for 3 years >Knowledgeable in Microsoft Applications o o o Word Powerpoint Excel (advanced, can pivots and macros) I hereby certify that the above information are true and correct to the best of my knowledge and belief. __________________________ Marlito M. Crispino
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.