Ma. Teresa T. Marcelo

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

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

eMail - adn2w2@r.postjobfree.com / adn2w2@r.postjobfree.com LinkedIn - Thess Marcelo LinkedIn

Objective

To utilize my technical and management skills for achieving the target and providing excellent tools in the field of IT and contributing business value by developing and executing strategic long term vision.

Functional Skills

Service Management, 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

• Open to change and new information; rapidly adapts to new information, changing conditions, or unexpected obstacles.

• Ability to motivate employees and improve productivity

• Ability to coordinate with other key personnel as needed

• Good organizational skills

• ITIL Certified and Six Sigma Yellow Belt’

Page 1/ 14

Technical Skills

Sharepoint Designer/Administration, Lotus Notes Designer/Administration, 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), Office365 (Sharepoint Online, Yammer, OneNote, Teams, Apps, Forms,Flow, etc.) Powershell, HPSM, SSP7

Experience

April 2018 to present (Gravitas Software and Service Solutions/ Continental Philippines)

IT Consultant

● Global Sharepoint Trainor (Germany, Romania, Japan, China, Mexico, Italy, France, India, etc,)

● Global Office365 Adoption Analyst / Dashboard creation using Powerbi Configure/setup powerbi service / report server environment, embedding powerbi dashboard in Sharepoint site, configuration of schedule refresh according to frequency, responsible for data refresh, responsible for report security/roles, publishing dashboard, configuration of gateways, maintaining the report on production server, creating report directly from SQL server

● Global 3 rd/ level support for workflow applications of Sharepoint

● Global 2nd level support of eSign (Online Approval and workflow process)

● User Access Control approver for all global locations related to workflow applications

● User Manual and FAQs reviewer

● Knowledge Based contributor

● Innovation contributor

Jan 2009 to present – May 2017

IT Application Development Executive

● Manage all workflow application created via Lotus Notes, Sharepoint and .net application and Powerbi

● Monitor Reports on Daily basis

● Creating schedule for report extraction

● Work with different departments to prepare the powerbi dashboard in the likes of HR, Legal and Sales

● Lead of workflow developers

● Evaluate Outsource application/Vendor Management

● Sharepoint Administrator and Designer

● SQL Database Administrator

● Lotus Notes Designer

● Omni Docs Administrator

● IT QA Team Lead

Page 2/ 14

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

● Develop/Administer workflow application

September 2007 to April 2008 (SLI - Accenture Philippines) Lotus Notes Consultant

● In charge on the enhancement and maintenance of AMEX Lotus Notes databases January 2007 to September 2007 (Goodyear Philippines) Application Specialist

● Lotus Notes Developer

o Focus on regional and local database development

● Project Administrator

o Vendor Management Inventory, Payroll Solution, Document Management

● SAP & Other Application Administrator

o SAP User Admin and Time & Attendance Solution Admin

● SAP Business Warehouse Designer

o Template for Sales Department

● Others

o Women In Leadership Vice President

o Six Sigma Yellow Belt

o SOX 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

o Oversee the Software Development Section of the Information Systems Department o Plan and manage group activities

Page 3/ 14

o Policy and Procedure

● Software Research and Development

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

● Software Administration

o Install, maintain and improve software tools and support technically development of systems and software

o Customized package software

o Test program and manage quality of application software

● Developer / Designer

o Lotus Notes, Visual Basic, Power OLAP Templates

● Others

o Internal Quality Auditor for Manufacturing Process on ISO / Quality Management System Compliance

o Quality Control Circle Leader for Service Group

o PQA 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

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 o Inventory, Packingl list, Delivery Receipts, Invoice, Certificate of Identification,, Bonds Cancellation, Sales Reports, Sales Trend and History Managed Applications from .Net

Project Name Business User Description

Page 4/ 14

Owner

Time Attendance Human

Resources

All Online Leaves Application, Overtime,

Attendance Authorization, Change of

Work Schedule with integration to

biometrics

Loans Application Human

Resources

All 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 To cater user travels 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

Service Desk Quality

Assurance

All Plant QA Online repository of quality related

concern

Customer Service Commercial Sales Escalation process of all reported customer complaints

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 Plant Finance Training Schedule, Training application Page 5/ 14

Finance 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

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

Page 6/ 14

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

Page 7/ 14

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

Page 8/ 14

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

Page 9/ 14

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 Created Templates from PowerBI

Template Name Business

Owner

User Description

Office365

Adoption

Global IT

Continental

Management Dashboard for the global users of

Continental for office365 adoption on

Teams, Sharepoint, Outlook, OneDrive,

etc.

Office 365

Licenses

Global IT

Continental

Network IT Dashboard for global licenses of

Office365 vs active directory

Service Desk Continental

Phils

Network IT Dashboard for all the network services of global users vs SLA

Sales Monitoring Gravitas Sales Management Monitoring of all Customer Accounts, Sales and Revenues

HR Dashboard Coca Cola HR HR Admin Employee demographics Legal Dashboard Coca Cola

Legal

Management Case Management

Page 10/ 14

Sales Dashboard Coca Cola Sales Sales

Managers

Monitoring of monthly Sales performance

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

Page 11/ 14

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 Agile 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

Page 12/ 14

● 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

● 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 – QQ0996804

Character Reference

Page 13/ 14

As per request

Page 14/ 14

Contact this candidate