Financial Modeling Analyst
Resume:
MICHAEL ALLAN A. CO
** ****** **., ****** ***********
Ampid, San Mateo, Rizal
EDUCATION
UNIVERSITY OF THE PHILIPPINES, Diliman, Quezon City
Bachelor of Science in Business Administration & Accountancy, 1998
College Scholar (4 semesters)
2010
INSTITUTE OF FINANCIAL CONSULTANTS PHILIPPINES
Certificate in Financial Modeling, January 2010
2010
INSTITUTE OF CERTIFIED MANAGEMENT ACCOUNTANTS
Strategic Business Analysis & Strategic Cost Management, July 2010
2012
CHARTERED FINANCIAL ANALYST SOCIETY PHILIPPINES
Certificate in Advanced Financial Modeling, March 2012
RELATED EXPERIENCE
Mar 2012 - Present
SKY CABLE INC.
Manager, Corporate Planning & Budget
Finance & Accounting Department
Financial Modeling requirements in the areas of:
oAnalysis of the Sales Teams project proposals
oAnalysis of the Marketing Teams planned product offerings
oAnalysis of the financial aspects of contemplated new products
Acts as consultant to others divisions for their individual planning and analysis requirements
Reviews regular reports and presentations for use of Management in Business Reviews and Board Meetings.
Acts as trainor to other Division on finance-related topics
Nov 2008 – Mar 2012
B. BRAUN MEDICAL SUPPLIES INC.
Business Controller
Finance & Accounting Department
Design, deliver and monitor enterprise-wide Key Performance Indicators such as sales, variable costs and general & administrative expenses
Lead the annual Sales & Expense Budget Setting Activity and quarterly Budget Reviews
Review, revise and endorse supply contracts of the Sales Divisions against set criteria in sales growth, profitability and cash flows
Lead projects in the area of Controlling, Planning and Analysis
Participate in the projects of various groups such as General Ledger Team, Credit Management and Supply Chain Division.
Liaise and communicate with the Asia-Pacific Regional Controllers for all regional reports and requirements
June 2006 – October 2008
ZUELLIG PHARMA CORPORATION
Senior Sales Planning Analyst
Sales & Collection Division
Design, deliver and monitor major performance metrics, historical reports and planning models to ensure accurate reporting and analysis of the Division’s Key Result Areas such as sales performance, brand sales trends and sales personnel coverage.
Standardize and propose improvements on various reports and analysis templates for use in regular Coordination Meetings and Business Reviews.
Consolidate various sales force updates such as sales gap analysis, customer inventory reports, issues & concerns and action plans.
Perform regular audits of nationwide trade customers and sales force rewards programs
Coordinate with various departments to acquire the needed information.
Contribute to other projects as requested by management
Train or advise various staff and management personnel in other departments on their MS Excel and PowerPoint reporting requirements.
Sept. 2005 – June 2006
ZUELLIG PHARMA CORPORATION
Office Bidding Coordinator / Sales Planning Analyst
Sales Administration & Planning Group
Oversee the efforts of peers and subordinates serving as liaison between various departments and organizations to ensure timely and effective planning, preparation and participation in all public bidding-related activities.
Prepare official communications to various government institutions and principals with respect to the company’s stand on pressing legal issues on current procurement policies.
Conduct regular reviews to ascertain accuracy in the legal, technical and financial requirements of bid proposals and contracts.
Improve work processes of subordinates with creative uses of existing technology reducing lead times and increasing accuracy.
Manage risk by recommending vital action plans.
April 2001 -
Sept. 2005
ZUELLIG PHARMA CORPORATION
Senior Account Manager, Sales & Collection Division
Direct the efforts of co-workers to achieve the department’s various operational goals.
Participate in the formulation, revision and implementation of policies that will facilitate the operations of the department.
Coordinate with superiors and other departments to obtain support for peers and co-workers.
Disseminate and implement the directives of top management to members of the department.
April 2000 –
April 2001
ZUELLIG PHARMA CORPORATION
Management Trainee, Sales & Collection Division
Manage sales and facilitated collections of customers.
Evaluate creditworthiness of customers and negotiated business terms beneficial to the company and its principals.
Assist in the preparation of documents required by various government entities in public bidding conferences.
Coordinate with peers and principals to acquire the necessary documents required by government entities.
Learn to resolve conflicts and deal with difficult people effectively and maturely.
Jan. 1999 –
Feb. 2000
PUNONGBAYAN & ARAULLO
Junior Auditor, Audit Group A
Perform preliminary evaluation of client’s internal accounting structure in order to identify weaknesses, areas for improvement and management considerations.
Perform and delegate fieldwork and assignment of detailed audit work to other staff auditors.
Take part in preparation of auditor’s report, audited financial statements and income tax returns required by various government and regulatory bodies.
Contact this candidate