Resume

Sign in

Sales Project

Location:
Santa Rosa, Laguna, Philippines
Posted:
September 05, 2018

Contact this candidate

Resume:

Ma. Teresa T. Marcelo

B* L** Phase * San Lorenzo South Sta. Rosa Laguna

Mobile No. (632) 917-***-****

Objective

To utilize my technical and management skills for achieving the business objective and contributing business value by developing and executing strategic long term vision.

Functional Skills

Project Management, Vendor Management, Contract Management, People Management, Budget and Control, Business Planning, Production and Sales Operation Planning, HR, Finance, Supply Chain, Sales and Commercial Business Process oriented, ISO Planning Auditor, SOX Auditor

Core Qualifications

Admirable experience overseeing business processes in a variety of work environments

Solid understanding of the accumulation and processing of often complex financial data

Strong ability to plan execute, monitor and complete projects in a timely manner

Ability to identify potential problems and seek speedy cost-effective resolutions

Solid communications abilities with proficiency in both written and oral forms

Ability to motivate employees and improve productivity

Ability to coordinate with other key personnel as needed

Good organizational skills

Techinical Skills

Sharepoint Designer/Administration, Lotus Notes Designer/Administation, MS Project, PowerBI, OLAP, Microsoft Flow, Visual Studio Team Suite, Six Sigma, ITIL, MSSQL, J2EE, Omnidocs/OmniFlow, .Net, Microsoft Office (Excel, Powerpoint, Word, Publisher, Infopath), Powershell, HPSM

Experience

April 2018 to Present – (Global Strategic Solution)

IT Senior Application Support

●Manage Sharepoint Training

●3rd level support for all workflow application

Jan 2009 to May 2017 – (Coca Cola FEMSA)

IT Application Development Executive

●Applied knowledge of ITIL/SOX principles to meet quality assurance standards

●Organized financial data and prepared related projections and budgets

●Confirmed accuracy of data by performing quarterly internal audits

●Manage business processes related to HR, Finance, Commercial, Sales and Supply Chain and coordinated with management on all on going and special projects

●Manage IT resources, software and hardware to support business solutions

April 2008 to Dec 2008 (SLI - Coca Cola Bottlers Philippines)

Lotus Notes Consultant

●Develop/Administer workflow applications

●Supported Finance business process in a timely manner while ensuring quality

●Ensured compliance with business standards and industry regulations

●Analyzed the efficiency of current projects related to Finance and made recommendations when necessary

September 2007 to April 2008 (SLI - Accenture Philippines)

Lotus Notes Consultant

●In charge on the enhancement and maintenance of AMEX Lotus Notes databases

●Develop/Administer workflow applications

●Supported Finance business process in a timely manner while ensuring quality

●Ensured compliance with business standards and industry regulations

●Analyzed the efficiency of current projects related to Commecial and made recommendations when necessary

January 2007 to September 2007 (Goodyear Philippines)

Application Specialist

●Develop/Administer workflow applications related to HR, Finance and Sales business process

●Project Administrator

oVendor Management Inventory

oPayroll Solution

oDocument Management

●SAP & Other Application Administrator

oSAP User Admin and Time & Attendance Solution Admin

●SAP Business Warehouse Designer

oDevelop template for Sales Department as part of business process improvement

●Others

oWomen In Leadership Vice President

oSix Sigma Yellow Belt

oSOX IT Auditor

October 2006 to December 2006 (ANR / Goodyear Philippines)

IT Consultant

●Lotus Notes Developer / Lotus Notes Database Admin

March 2006 to September 2006 (Primover / Goodyear Philippines)

IT Consultant

●Lotus Notes Developer / Lotus Notes Database Admin

December 2003 to February 2006 (Panasonic Mobile Communication Corp. of the Philippines)

Software Developer Specialist

●Development Section In-Charge

oOversee the Software Development Section of the Information Systems Department

oPlan and manage group activities

oPolicy and Procedure

●Software Research and Development

oInvestigate, research the latest information technology related to systems construction and build architecture

●Software Administration

oInstall, maintain and improve software tools and support technically development of systems and software

oCustomized package software

oTest program and manage quality of application software

●Developer / Designer

oLotus Notes, Visual Basic, Power OLAP Templates

●Others

oInternal Quality Auditor for Manufacturing Process on ISO / Quality Management System Compliance

oQuality Control Circle Leader for Service Group

oPQA Secretariat – Category 4, Measurement Analysis and Knowledge Management

2002 to 2003 (Panasonic Mobile Comm. Corp. of the Philippines)

Planning Supervisor

●Total control of production and sales operation for 3 factory sites; Sta Rosa in-house factory (Phils), Dyna Farm-out Factory (Phils), ZQ China Factory, developed programs to completely check and monitor all areas

●Developed tools for planning personnel to simplify working activity

●Sales performance monitoring, sales analysis, market inventory analysis

●Organize and control total planning activity

●Conduct quarterly ISO audit compliance to all other departments concerning Production Control and Sales Operations

1987 to 2002 (Matsushita Communication Corp. of the Phils. / Panasonic Mobile Comm. Corp. of the Philippines)

Planning Staff

●Production operation controller from mainline to sub assemblies including farm-out operation, planning, forecasting, scheduling and monitoring

●Total Control of Finished Goods inventory

●Developed automated reports using macro programming

oInventory, Packingl list, Delivery Receipts, Invoice, Certificate of Identification,, Bonds Cancellation, Sales Reports, Sales Trend and History

Managed Applications from .Net

Project Name

Business Owner

User

Description

Time Attendance

Human Resources

All Employees

Online Leaves Application, Overtime, Attendance Authorization, Change of Work Schedule with integration to biometrics

Loans Application

Human Resources

All Employees

On Line Loan Application with approval and validation on entitlement

Clearance

Head Office Human Resources

Plant Human Resources

On Line Clearance application with approval of all function and execution through integration with SAP

Travel and Expense

Finance

All Employees

To cater user travel and expense with integration to SAP for reimbursement and cash advances. Enablement of Travel Agency to provide plane ticket, hotel, car rental proposal via online with validation to entitlement of employees based on job level

ELearning

Human Resources

All Employees

Online training workflow approval and schedule management

Service Desk

Quality Assurance

All Plant QA

Online repository of quality related concern

Customer Service

Commercial

Sales

Escalation process of all reported customer complaints

Coca Cola Foundation

Coca Cola Foundation

Public

Public Site for Coca Cola Foundation

Balance Sheet Tool

Finance

Finance

Workflow application for Balance Sheet reconciliation and consolidation

Journal Voucher

Tool

Finance

Finance

Workflow application for Journal Voucher entries

Strategic Intelligence Arena

Business Planning

Sales

Central repository of product portfolio and market strategy together with other competitors

Online Recon

Finance

Finance & Supply Chain

Workflow application for inventory reconciliation

Contract Management

Legal

All Function

Contract management with workflow and document management

COLD

Commercial

Commercial

Cooler and Dispenser monitoring with vendor management for services

Developed/Managed Applications from Sharepoint

Project Name

Business Owner

User

Description

Project Management System

IT

All Employees

Project Charter, Project Task, Change Request, KPI dashboard, Announcements, Reports

Training

Head Office Finance

Plant Finance

Training Schedule, Training application with approvals and reports

Request for Authorization

Finance

All function

Budget approval for all types of project, approvers including Mexico Main Office

ITCares

IT

All Employees

Incident handling, Service Request and Access Request with workflow

Talent Requisition

HR

All Function Manager/Exec

Workflow request for new employee requirement in every function

Scripta

Legal

Legal/Finance

On line monitoring of Legal Cases

M1

Procurement

All Function

Online Request for Procurement and Disposal

Asset Disposal

Finance

All Function

Online Request for Asset Disposal covering entire company assets with integration to M1

Order to Cash

Finance

Finance

Invoice monitoring with workflow process

Supply Chain

Supply Chain

Manufacturing

Online monitoring of daily operation output vs plan

Period End Book

Finance

Finance

Finance tool with workflow reminder of all Finance task and activities

Knowledge Base

Contact Center

Contact Center

Online tool with email integration as central repository of Contact Center technical process, policies and procedures

Mobile Phone

HR

All user

Monitoring of Mobile Phone consumption and excess bill, for approval and justification

Developed Applications from Lotus Notes (#migrated to Sharepoint/.Net)

Project Name

Business Owner

User

Description

Asset Management *#

Finance

Plant Asset Admin

Online monitoring of all assets acquisition, transfer and disposal with workflow approval

Journal Voucher *#

Head Office Finance

Plant Finance

Workflow approval of all journal entries, monitoring and reports

Balance Sheet Tool *#

Head Office Finance

Plant Finance

Workflow approval of all Balance Sheet request with Consolidation Reports

Customer Complain *#

Contact Center

Quality Assurance team and Contact Center Agents

Application is similar to Call Center function

Service Request System *#

Business Systems Directorate

All

This application is for requesting hardware, software, infrastructure needs of a user, with workflow approval and execution

Incident Management System *#

Business Systems Directorate

All

This application will be used to address all concern/issues of a user in hardware, software and services. Similar function for Help Desk

Application Access Request *#

Master Data Maintenance Directorate

All

All user that requires access in all application will secure online approval to all business owners of application

Gift Requisition System *#

Legal

All function

All function requesting for gifts as token to any external parties will secure online approval to ensure that there’s no violation for COBC

Contract Tracking Database *#

Legal

All function

All services and purchases that requires contract engagement will undergo online approval and with the facility for auto creation of contracts using all information from Project Owners. Reports and Library

Master Data Maintenance *

Master Data Maintenance Directorate

All function

All data related additional/updates/blocking for Price, Customer, Material Master, Cost Center, GL Account, Vendor and Profit Center secure online approval based on location and other parameters with mobile option for approval. Approved MDM request will be posted to SAP.

On Line Library

Information System Department

IT

CD, Books and Manuals of IT Department arrange according to categories with individual assigned code for filing and retrieval purposes

On Line Office Supplies *

General Affairs

All dept clerk

On Line request for office supplies with approval cycle consolidated to one central office supplies distributor for purchase and issuance control

Import Shipment Information System *

Logistics Service Department

LSD staff

On Line monitoring of import material shipment, documentation, Import permit application, PEZA application, billing information, consolidation and reports

Document Library

Information System Department

IT

On Line document posting and delegation of information with security access designed for each user

Manufacturing Overhead Expenses *

Manufacturing

All manufacturing dept

On Line monitoring of manufacturing expenses compared to business plan and working plan with approval process for expenses application

Training/Seminar Logs#

Information System Dept

IT

On Line posting of training and seminar for IT personnel

Software Evaluation Logs *

Information System Department

All dept

On Line Software evaluation for each user for performance rating purposes of developer and improvement points reference with mail notification for the creation and completion

Perishable Tools Control *

Production Engineering

All manufacturing dept

Simulation of perishable tools actual consumption and forecasting of 3 months consumption based on given production requirement and purchases, notification for tool life expiration

Telephone Billing System

Information System Dept

IT

Computation of telephone bill consumption

Employee Welfare and Benefits *#

Human Resource Dept

All employee

On Line employee welfare and benefits database, on line application of request for SSS, pag-ibig, sickness benefits, monitoring of gasoline allowance and all other benefits

Production Control System *

Production Control Dept

Production Staff

On Line monitoring of hourly production achievement per process compared to production schedule and sales requirement with agent notification for follow ups and reports

Quality Logs *

Market QC

Market QC staff

On line posting of market quality issue, monitoring of all open issues, on line delegation of task and unlimited delegation until issue will be closed.

Resource Reservation *

General Affairs

All employee

On line resource reservation; rooms. Audio cons, projector, customized resource reservation from original template of lotus notes

HR eService *

HRD

All employee

Consolidated database of the ff;

●HR Policy *

●Service Emblem

●On Line Bulletin board *

●Training database *

●Vehicle Database *

●eLibrary *

●WIL database *

●Employee db

Specs On Line *

Engineering

Manufacturing

Production specification publishing with approval process and document monitoring based on expiration

Stocklist On Line*

Material Control

Manufacturing

Material stocklisting request based on requirements with approval process

eStop Card *

Safety Dept

All employee

Safety observation compliance with workflow cycle for responding to non conformance on safety practices with log monitoring, basis for annual employee appraisal

Customer Care *#

Customer Sales Department

Customer Sales Department staff

Regional project, deals with all customer complain, request, etc. with workflow facility on all issues that requires solution, mail notification for follow ups and outstanding issues

Legal db *#

Executive Office

Legal Staff, secretaries, Top Mgmt

Regional project, repository of all legal issues with review and notification facility, follow ups on important dates

IT Config *#

MIS

MIS

Consolidated database for IT used only;

Hardware & Software inventory

Visitor’s Log, Purchases, Contracts, Minutes of meeting

Exception db *

Purchasing dept

All dept

Regional db, Purchases request outside normal process, with approval process based on category, department and amount involved

Master Data Maintenance *

Finance

All Dept

Online approval for Cost Center, Profit Center, Material Master, Price, Trading Terms, Vendor and Customer Request

Water Resource Compliance Survey#

Safety, Environment System

All Plant

Compliance of water usage conducted every month, computation of ratio and consumption with monitoring and follow ups

Service Request System *#

IT

All Dept

IT service request for Infra, Application, Software and Hardware with Service Evaluation Survey for every completion of request

On Line P3 *#

HR

All employee

Performance evaluation

* with workflow

Created Templates from Power Olap

Template Name

Business Owner

User

Description

API Analysis

Purchasing Dept

Purchaser

Simulation of material analysis from ERP system based on given production schedule and forecast, material inventory and requirement on a monthly basis

PSI Analysis

Production Control

Production Control Staff

Simulation of Production, Sales and Inventory analysis based on given scenario

Back Order Summary

Production Control

Production Control Staff

Consolidated report of all Sales back order

Sales Summary

Production Control

Production Control Staff

Consolidated report of all sales information based on invoice created in ERP system

Sales Commission

Finance

Finance team

Consolidated report of all sales and corresponding commission based on a given rate

Created Templates from SAP Business Warehouse

Template Name

Business Owner

User

Description

Sales Summary

Sales Department

Management

Creation of Sales Summary report per region, per location, per Vendor, per Sales man, per Model at any request period of coverage based on SAP System

Back Order Summary

Sales Department

Salesman

Consolidated report of all Sales back order

Project Administration

Project Name

Business Owner

User

Activity Taken

Payroll System

(Panasonic)

HRD

HR staff

Summarize Business Requirements

Manage & monitor Project Timeline

Fit and gap analysis

System testing and evaluation

Coordinate issues on customized modules

Set targets and goals

Support parallel runs and deployment

Document Management/

Imaging Solution

(Panasonic)

Corporate Quality Assurance Center

All department

Summarize Business Requirements

Manage & monitor Project Timeline

Vendor selection and evaluation

Benchmarking

Fit and gap analysis

System testing and evaluation

Vendor Management Inventory

(Goodyear)

Sales Department

Sales, Logistics Dept

Monitor Project timeline

Summarize Business Requirements

Fit and gap analysis

System testing and evaluation

Coordinate issues on all modules

Set targets and goals

SQP/ESNA db (AMEX/Accenture)

AMEX Mgmt

All

Project Management db, Enhancement and maintenance of database, modification on design and additional agents to automate processes and notification

PMDB

(AMEX/Accenture)

AMEX Mgmt

All

Enhancement and maintenance of database, modification on design and additional agents to automate processes and notification

Feedback db

(AMEX/Accenture)

Accenture/QA

Accenture QA and AMEX selected person

Feedback database of all Lotus Notes db for enhancement and maintenance of database, modification on design

CSMS

(Accenture)

Accenture/QA

QA

Status report monitoring, Enhancement and maintenance of database, modification on design

Education

1985 – 1987 Mapua Institute of Technology

●B.S. Civil Engineering

1987 Trace Computer School

●Basic Programming

●DBASE

●Lotus 123

1992 – 1994 International Correspondence School

●Complete Programming

Training

●VSTS Test Case Management – 9/6-8/2016

●VSTS Practices Planning – 9/1-5/2016

●ITIL Certified – 8/2016

●MS Sharepoint 2013, Site Administration – 4/20-4/24 2015

●10175 MS Sharepoint 2010, Application Development - 7/15/2011

●10174 Configuring and Administering MS Sharepoint 2010 - 5/20/2011

●7 Habits for Manager's Workshop - 4/28/2011

●Microsoft Outlook 2007 - 3/22/2011

●2784 Tuning and Optimizing Queries Using Microsoft SQL Server 2005 - 11/22/2010

●2779 Implementing a Microsoft SQL Server 2005 - 10/27/2010

●Financial Integrity and Fraud - 8/13/2010

●2310 Developing Web Applications Using Microsoft Visual Studio 2008 - 7/23/2010

●2007 Security and Privacy Awareness Training - 10/11/2007

●SAP Business Warehouse – Goodyear Philippines

●Six Sigma - Goodyear Philippines

●Java Programming Language (SL275) / January 9 – 13, 2006 / Sun Micro Systems

●Fundamentals of Sun Java Prog. Language (SL110) / Oct 24-28, 2005 / Sun Micro Systems

●Intro to VB.net, Programming with Microsoft.Net (2559) / Jan. 31 – Feb 4, 2005 / DB Wizards Inc.

●PowerOLAP Training / April 20 – 23, 2004 / Forecasting and Planning Technologies Inc.

●MSProject 2000 / March 27, 2004 / PMCP

●Designers and Fundamentals Security and Workflow Lotus Script in Domino R5 /

February 2 to 6, 2004 / Softweb Consulting Inc.

Seminar

●Nintex for sharepoint – Shangrila Makati

●Sharepoint Best Practices – Shangrila Makati

●Websphere Integration – Manila Peninsula

●Strategic Asset Management – New World Renaissance

●SME Solution Forum – Makati Shangrila

●Websphere Event – Manila Peninsula

●CIO Forum / eGovernance Seminar – Manila Peninsula

●eBusiness On Demand Software – Shangrila Hotel

●Production Control for IT Professional – Panasonic Singapore

●Basic Supervision – Panasonic Sta Rosa Laguna

●Basic Business Philosophy – Panasonic Sta Rosa Laguna

●ABC’s of LAN Seminar – Panasonic Sta Rosa Laguna

●FDD Technology – Panasonic Sta Rosa Laguna

●QCC Leadership – Panasonic Sta Rosa Laguna

●Basic Course on Environmental Protection – Sta Rosa Laguna

●5s – Panasonic Sta Rosa Laguna

●Leadership Training – Panasonic Taytay Rizal

Awards

●1st Place Computer Skills Competition

●2nd Place Lotus Skills Competition

●Most Outstanding Employee

●Managing Director’s Award

●3rd Prize Poster Making Contest

Business Trip

●Guandong China (2x) – shared best practices for Production Control and Sales

●Hongkong – Vendor Meeting

●Singapore – Production Control for IT Professional

Personal Information

●Birthday – February 25, 1968

●Birthplace – Jose Panganiban Camarines Norte

●Civil Status – Married

●SSS - 3-89624300-1

●PIN - 9-050179610-0

●TIN - 108-278-437

●Passport No – P3091313A

●Driver’s License No. – N2617018023

Character Reference

As per request



Contact this candidate