John Rupert J. Trajano

* ****** **, *** *******, Almanza, Las Pinas City, Philippines

+639**-***-**-**

632-***-**-**

admy1k@r.postjobfree.com

Business Analysis, IT Project Management, Sales & Marketing More than a decade of solid experience as an IT Professional, this gives the edge in efficiently performing technical and analytical solutions to different obstacles that may arise in dealing with everyday clients. Hardworking, aggressive, resourceful and quick to adapt to the fundamentals of Sales and Marketing. Has an open eye for new techniques and strategies that will help in the fast pace world of promoting and marketing a brand, product and services. Capable of managing small to large and complex scale projects from the designing of the concept to the implementation and completion of the task with remarkable results and deadline sensitivity. Compatible and well- rounded team player that can easily adapt with the vibes and atmosphere of the surrounding. Well versed with the design and execution of effective Enterprise Resource Planning (ERP) System for Trucking, Hauling, Logistics and Public Transport.

Programming Language:

Major: Microsoft Visual Basic 6.0

Minor: ASP.net/2008, Microsoft C# 2008 and JavaScript. Platforms: Microsoft Operating System NT/95/98/2000/ME/XP/Vista/7/8/10 SalesForce (Marketing Cloud, Social Studio, Sales Cloud and Service Cloud), Ramco ERP

RDBMS: Microsoft SQL Server 2000/2005/2008/2012, MySQL and Microsoft Access Reports: Crystal Report 8.5/10/10.5/11, SQL Server Reporting Services (SSRS) and Active Reports 2.0

Internet Standards: XML/JSON, HTTP/SSL, HTML/CSS and SMTP Analysis: UML Design & Modeling, MS Office, Microsoft Visio and Microsoft Project Tools: .Net Framework 2.0/3.0/3.5,Linq, Lambda, Kendo UI, Dojo Toolkit, JMango, Obout Suite, JQuery, Mootools framework, Joomla 1.5/1.6, SQL Server Integration Services

(SSIS), Adobe Photoshop, RealWorld Photos and Icon Editor Project Standard

& Implementation: Project Management Body of Knowledge (PMBOK) Waterfall, Agile (Scrum, Kanban, Scrumban)

Project Management Tools: Trello, JIRA

Trainings: Project Management Professional Training for PMP Certification by Apex Global Technical Proficiencies

Senior Project Manager August 2019 – Present

Third Pillar Business Solutions

Managed End to End Project Implementation for SalesForce Projects Part of Standard Review Board (SRB) to ensure that projects are planned and implemented as standard practice Primary contact for all the Client’s engagement under the contract Created project timeline and Work Breakdown Structure (WBS) for the project which defined responsibilities for each member of the team

Coordinates with clients for all tasks and artifacts needed for the project Review materials to be submitted to the client for milestone completion and handled client’s sign-offs furnishing Makes day-to-day decision for issues & concerns related to project and make necessary escalations if needed Assisted in billing and collection

Projects Handled for SalesForce Projects:

1. PayMaya Business Manager (PBM) Project – a web-based application implementation which integrates the native web-based application of PayMaya to the previously implemented Sales Cloud. The project involves third party software, MuleSoft to handle integration points.

2. MaxiCare ServiceDesk Project – a web-based CRM application that supports the company on handling their members’ concerns from inquiries, complaints, hospital booking up to billing and check-out. The system is also integrated to their native web-based application, PayorLink thru APIs 3. RCBC Social Studio to Service Cloud Project – a web-based CRM application that manages all the Social Media platforms of RCBC. All posts, messages, sentiments, client and competitors listening are handled thru the app. This will then be connected to the SalesForce Service Cloud so that items will be created in to case and be managed accordingly.

4. Vista Land Social Studio to Sales Cloud Project – a web-based CRM application that manages all the Social Media platforms of Vista Land. All posts, messages, sentiments, client and competitors listening are handled thru the app. This will then be connected to the SalesForce Sales Cloud so that prospect clients will be created in to Leads and be handled throughout the process until it becomes an opportunity and agents closes out on the deal. 5. Metrobank Social Studio Project – a web-based CRM application that manages all the Social Media platforms of Metrobank. All posts, messages, sentiments, client and competitors listening are handled thru the app. 6. Center for International Trade Expositions and Missions(CITEM) Social Studio and Marketing Cloud Project

– a web-based CRM application that manages all the Social Media platforms of CITEM. All posts, messages, sentiments, client and competitors listening are handled thru the app. It also handles all campaigns that will be sent thru email and SMS and creates journeys for the end-to-end experience of handling their clients. Project Manager January 2019 – August 2020

Ramco System, Inc.

Managed End to End Project Implementation for ERP System Primary point of contact for the Client’s management obligation under the contract Defined responsibilities for each user team for tasks identified in the project schedule and ensure Client’s participation to tasks and completion of activities

Coordinates with user teams in the respective business functions during the project and filtering issues raised then enabling feedback to be communicated to Offshore team

Review and sign-off deliverables submitted by the team for milestone completion and managed obtaining sign-offs of appropriate members of the client

Aided periodic reviews and audit for monitoring and control of project progress Ensure adherence to time schedules by various user teams as planned and availability of information and resources on time for smooth progress of the project

Makes decisions on day-to-day issues related to project and escalates to Steering Committee if required Projects Handled for Logistikus ERP System Project: 1. Transport Management System (TMS) – a web-based application that covers all the stages of the transport and logistics arm of the company. The system spans to all vital process from Booking, Planning, Execution up to Rating & Billing. Customizations were added to the product to match the client’s requirements 2. Finance Management System (FIN) – a web-based application that organizes, oversee and govern the use of its income, expenses and assets with the objectives of maximizing the profits and ensuring sustainability of the company 3. Fleet Management System (FMS) – a web-based application that gives sight and control to the logistic/operations team by removing/minimizing the risks associated with vehicle investment, improving efficiency, productivity and reducing the over-all transportation and staff costs Professional Experience

4. Supply Chain Management System (SCM) – a web-based application that manages and oversees the flow of goods, data and finances as a product moves from point of origin to its final destination or lifespan 5. Warehouse Management System (WMS) – a web-based application that gives control and administer warehouse operations from the time goods or materials enter a warehouse with all movements and processes completely monitored until they move out for dispatch

Project Manager II November 2016 – October 2018

Electronic Science Corporation

Established quality policies to ensure achievement of various objectives for different departments Facilitated data gathering to all entities involve Initiated Project Kick-offs to ensure alignment of requirements and system Acted as head for project implementations

Performed thorough presentation and led actual demo of the system Provides efficient timeline and costing to current system and special projects Monitored critical activities such as daily calls concerns, data seeding and report generations Created QA test scripts, case scenarios and proper documentations Handles Support team’s escalated issues and concerns Detailed project requirements, timelines and effective process flow to Development Team Heads Conducted trainings and seminars to users

Projects Handled:

1. PocketWISE Sales Force Effectiveness (SFE) Application – an extensive mobile application that aides Medical Representatives in fulfilling their daily tasks from planning and executing of calls to Doctors. It is patterned from the manual Daily Coverage Report with some added features such as reports, messaging, GPS capability and other attributes that gives support to the efficiency of the Medical Representative. 2. PocketWISE District Manager (DM) Application – a mobile application that provides District/Area Managers the ability to efficiently manage their team while planning and recording their own activities in the process and digitally sending it to the head office on a real-time basis. 3. PocketWISE Webtool – a web facility for the support of the SFE and DM Application. This system provides the maintenance files of device users, doctors, institutions and the likes. It can also generate reports and other intelligent supporting documents for efficient monitoring of user and entity performances. 4. PocketWISE for Sales and Merchandisers (PSM) Application - a Handheld Application for transmission of trade activity data wirelessly. Without investing in expensive phones, the customer can monitor their daily inventories, stocks, sales, share-of-shelf, off-take, expiring goods, and other important data available on stores/outlets where their products are being sold thru this application. This app is widely embraced by FMCG Companies with over 5,000 daily active users.

5. SMART Communications Dealer Management System (DMS) – an automated system that tracks the movements of SMART’s merchandise from the point of sales to the release from Inventory and delivery to Dealers, Sub-Dealers, Retailers and other complex hierarchal vendors. This is also integrated to a Service Desk System, which is imbedded in a customized Zendesk Platform for better customer support, ticketing and resolving issues and concerns. 6. Samsung Knox Admin – a security feature for mobile devices that enables Work and Personal content to function on the same handset. It can manage restriction of applications and websites, use of device features like wi-fi and data transfer.

Sales Director / Project Manager January 2015 – June 2016 Trackmate Business Solutions, Inc.

Formulated the most sophisticated and advanced Fleet Management System (FMS) in the country Look-up prospect clients and performed thorough presentation Aided clients and established upright rapport through added significant productivity and excellent service Lead each and every oculars and actual demonstrations to clients Handled after sales services and additional client requests Created Sales and Marketing Materials

Created profile, illustrations, reports and forecasts materials for board meetings Performed data gathering to devise plan of action, system design and execution Tailor-fitted systems depending on the requirements of clients Closely monitored each ongoing system progress and execution Commanded instructions to Operations Team on how to execute processes to fit the needs of clients Guided the IT Developers on critical points that will be the common ground for all entities Conducted through training to end users

Formulated initiatives that will promote good relationships to all entities involve Initiated a harmonious process flow for each departments for smooth transition and implementation Projects Handled:

1. Gapuzan Trucking FMS – a customized Fleet Management System for one of the most recognized and trusted truckers in the country. It handles all the bookings and monitoring of all the transactions and its details. 2. Great Sierra Development Corp FMS – a customized Fleet Management System for the largest Hauler of Holcim and La Farge – Republic, both the largest cement company in the country. It spans from the procurement of supplies from the plant, transferring to warehouse and delivery to bulk clients. 3. South Sea Development Corp FMS – a customized Fleet Management System for the largest Hauler of Holcim and La Farge – Republic, both the largest cement company in the country. It spans from the procurement of supplies from the plant, transferring to warehouse and delivery to sub-clients. 4. Non-Stop Logistics FMS – a customized Fleet Management System for logistic companies that manages their main operations from the procurement of client up to the delivery of cargoes. 5. House Research & Dev. FMS – a customized Fleet Management System for the biggest Importer and Exporter in the country. As for the movement of their close to 1,000 containers per day, we developed the system that will monitor all the advancement and scheduling of their boxes in and out of the port. 6. HM Transport – a customized Fleet Management System for one of the biggest Bus Company for public utility transport in Metro Manila. The system manages their fleet dispatch & monitoring up to their maintenance and inventory.

7. DOTC / LTFRB / DOST Project – assisted the government agencies in their project for a better traffic management through thorough monitoring with the use of Fleet Management System. We helped them with the GPS protocols, database set-up, guidelines & implementations and spearheaded the presentation to his Excellency President Benigno Aquino III.

IT & Marketing Manager January 2015 – December 2015 Cargo Integrity Checkpoint Inc.

Formulated the system that fueled the solution to the Port Congestion in Metro Manila Introduced new techniques and approaches that can be beneficial to their current system Collected data and processes to devise the plan of action, system design and execution Lead IT Developers on critical business rules

Created the common ground for the benefit of all entities Devised the company’s functional structure and determined each department’s role Supervised system implementation

Created Operation’s protocol and processes

Dealt with after sales services plus additional client appeal Created profile, illustrations, reports and forecasts materials for board meetings Created Sales and Marketing Materials

Did presentation to Shipping Line Directors and Board Members of Association of International Shipping Lines (AISL) Did presentation to Top Management of ICTSI

Initiated user trainings and seminars to clients and back office Direct support to clients to established good relationship upon providing utmost assistance Projects Handled:

1. ICTSI – HRD Pre-Advised Booking System – a system that organizes the booking and routes all information to client, brokers, truckers, shipping lines and the port for better coordination and faster processing. It closely monitors all activities, timing & queuing and process all data that are needed before the container arrives at the port for a seamless process. At the peak of the Manila Port Congestion, we manage to accelerate the turn-around time of the average waiting time of trucks from 12hrs to 3 days and trim it down to an average of 2hrs. HRD was given a plaque of appreciation by ICTSI’s Mr. Enrique Razon for the initiative and great outcome of the project. Systems Analyst / Ad Traffic Director January 2014 – December 2014 Inquirer Catalyst Media

Handle strategic placement of programming, content and advertising materials Developed segments that created business opportunities Produced templates of programs for user interface

Aligned content to current needs of audience

Controlled workflow of critical content and special executions Verified effectivity of overall work process of operations Responsible for timetables and schedules of implementations of materials Monitored stalled jobs and redundant process and ensure to move them forward Established realistic targets and goals for production and operations department Sales and Event Manager January 2014 – December 2014 Victorious One Advertising and Production Corp.

Developed events and execution for targeted market Ensured client calls and presentation

Executed on-ground events

Did TV appearance and promotions

Projects Handled:

1. Trail Bike Challenge 2014 – the most exciting trail ride cycling event in Filinvest Alabang. Created new trails designed to challenge the technical skills of every rider. With customized and strategic execution for every client and advertisers.

2. Nuvali Dirt Weekend 2014 – the holy grail of events for cycling enthusiast nationwide as it has competitions sanctioned by Union Cycliste Internationale (UCI), the world governing body for sports cycling and oversees international competitive cycling events. It is a three-day event that gathers top-ranked mountain bike athletes around the country.

Account Manager July 2013 - December 2013

Inquirer Catalyst Media

Accosted prospect clients and performed thorough presentation Created customized executions depending on the client needs Assisted clients and created good relationship through value added output and quality service Created Sales and Marketing Materials

Assisted the Production Team on the needed outcome of ad materials for clients Gave directives to Operations Team on how to execute processes to fit the needs of bus partners, clients and passengers Guided the IT Department on critical upgrades that will benefit bus partners, clients and passengers Formulated initiatives that will promote good relationships to bus partners, clients and passengers Spearheaded each and every oculars and actual demonstrations to clients Initiated a harmonious process flow for each departments for smooth transition and implementation Created profile, illustrations, reports and forecasts materials for upper management use Systems Analyst January 2013 - June 2013

Inquirer Catalyst Media

Created new business opportunities and models which maximizes current resources Designed new IT solutions to improve business efficiency and productivity Monitored and analyzed the transition of IT processes to new environment Produced the outlined designs of new systems

Worked closely with clients to identify major business processes and eliminate redundant and inefficient steps Created systems development life cycle for the process of the company Remodeled links between departments to produce efficient outcome Accompanied sales personnel to clients and do presentation regarding the system Conducted training to personnel regarding features and upgrades of the system Performed and closed transactions with third party/bus partners IT Manager October 2011 - 2012

Catalyst Media Incorporated

Took part in the planning, development and implementation of an in-transit audio-visual Passenger Information System, a first of its kind in Asia.

Planned, organized and directed the operations of information systems Developed and implemented policies and procedures for electronic data processing and computer systems operations and development

Organized with each and every department their routines and effective process flow Controlled the computer systems budget and expenditures Ensured that technology is accessible and equipped with current hardware and software Projects Handled:

1. Passenger Information System - an in-transit audio-visual system that displays infotainment contents and Global Positioning System (GPS) capabilities to entertain and give service to daily public transport passengers. It is a first in Asia and proudly a Filipino innovation.

Frontend: Asp.net, C#

Backend: Microsoft SQL Server 2008

Reporting Tool: SQL Server Reporting Services

2. Fleet Management System - a customized system that efficiently organize data, information, jobs and functions of each and every member of a fleet by accurately monitoring its each and every details, procedures and activities. Frontend: Asp.net, C#

Backend: Microsoft SQL Server 2008

Reporting Tool: SQL Server Reporting Services

Operations and IT Consultant October 2011 - 2012

Trackmate Business Solutions, Inc.

Designed the company structure

Created business rules and operations standards

Directed process flow of every department and its connection to other units Handled the IT Department's budget and expenditures Spearheaded projects for clients

Projects Handled:

1. Fleet Management System - a customized system that efficiently organize data, information, jobs and functions of each and every member of a fleet by accurately monitoring its each and every details, procedures and activities. 2. Jam Liner, Inc. - Headed the project and created turnkey software that modernized the major business process and departments such as IT, Operations, Maintenance and Inventory. 3. Archipelago Philippine Ferries Corporation - Took the lead in planning and implementing the infrastructure and system that showcased an integrated infotainment marketing and passenger information system. Senior Programmer January 2009 - October 2011

Focus Global Incorporated

Acts as analyst/programmer

Recognized as a resourceful contributor and acknowledged with increased developing responsibilities Provides technical advice and assistance to management and technical staff in matters relating to application design and coding activities

Designs and implements new applications and system integration to meet users' needs Supervises other developers; assigns, monitors, and manages the work of staff Designs and creates reports based on user’s requirements using Crystal Reports 11 for window type systems and SSRS for web based applications

Designs various web pages and modules based on user’s specification Designs and creates relational database using SQL Server 2005 Trains user

Installs and maintains new systems

Technical Support

System Administration

Systems Created:

1. Home Furnishings WEB MIS – a web-based system serves as the POINT OF SALES of the company for selling different products such Ethan Allen, Sub-Zero, Miele, Siematic Kitchens, Wolf and Tempur at different locations with a centralized inventory system.

Frontend: Asp.net, C#, Obout, Dojo, Jquery

Backend: Microsoft SQL Server 2005

Reporting Tool: SQL Server Reporting Services

2. Integrated HRIS, Evaluation and Payroll System – a combination of web and window based application used by the entire company. This system will capture all the human resources required information and then link it to Time Keeping and Payroll for Payroll Processing. Part of the system features are the Self Service Employee Portal which provides important HRIS details, Leave Management which is integrated to Time Keeping, Employee Performance Appraisal for compensation, Loans and HMO for benefits which are also integrated on payroll system and a Recruitment System for fast and easy tracking of new employees. Frontend: Asp.net, C#, Obout, Dojo, Jquery

Backend: Microsoft SQL Server 2005

Reporting Tool: SQL Server Reporting Service & Crystal Report 11 3. Integrated Distributor and Dealer Management System – a combination of web and window based system used by the company for selling Chana and FAW cars. Part of the system features are the Distributor and Dealer Relationship, Service Management for car service, Car history, Customer Relationship, Inventory Management for cars and spare parts, and Accounting system for payment and reports. Frontend: Asp.net, C#, Obout, Dojo, Jquery

Backend: Microsoft SQL Server 2005

Reporting Tool: SQL Server Reporting Service & Crystal Report 11 Programmer 2008 - 2009

Focus Global Incorporated

Acts as analyst/programmer

Designs/Creates database using SQL Server 2000

Designs forms based on the specification of the user Writes reports using Crystal Reports 11

Documents the system procedure

Trains user

Quality Control to new projects

Technical Support and attend to all request of users Systems migrated to new platform:

1. CG System

2. HF System

3. DMC System

Frontend: Visual Basic 6

Backend: Microsoft SQL Server 2000

Reporting Tool: Crystal Report 11

Systems Created:

1. Leave and Overtime Management System - a window based application through which the employee applies for time-off and overtime. The manager gets an email alert on the pending application. Frontend: Visual Basic 6

Backend: Microsoft SQL Server 2000

Reporting Tool: Crystal Report 11

2. Auto Logger – a window based application capable of storing encrypted company websites credentials. The system allows the employee to login/open selected website without knowing the usernames and passwords. Frontend: Visual Studio 2008 – C# .net 3.5

Junior Programmer/Developer 2006 - 2008

Focus Global Incorporated

Primary task was to maintain and enhance existing systems based on the specification of the users Acts as a Programmer

Created various interactive modules using visual basic 6 and integrated those modules into the system Designs and writes reports based on user’s specification using Active Reports 2.0 Trains User

Documents the system procedures and enhancement

Systems Handled:

These systems are semi-ERP applications comprise the Sales/Custom Order, Accounting and Inventory Management, Human Resource and Service Modules.

1. CG System - This system is being use for consumer brands such as Coleman, Oster, Camping Gaz, Thinner, EZ-Up and Kitchen Aid

2. HF System – This system is being use for home furnishings division such as Ethan Allen, Wolf, Sub-Zero, Siematic Kitchen, and Miele.

3. DMC System – This system is being use for needlecraft division such as threads, patterns and other needlecraft accessories.

4. HR System – This system was designed to address the needs of the HR department in regards to employee information, medical records, SSS and Pag-ibig contributions, training records, etc. 5. Daily Coverage Report – A system that tracks the Itinerary and Client Visits made by the Sales Personnel. Frontend: Visual Basic 6

Backend: Microsoft Access 2000

Reporting Tool: Active Reports Professional 2.0

2002 - 2005 De La Salle - College of Saint Benilde Taft Avenue, Metro Manila

Bachelor of Science in Business Administration - Major in Computer Application 1999 - 2002 De La Salle University

Taft Avenue, Metro Manila

General Studies

1995 - 1999 St. Francis of Assisi College

Admiral Village, Las Piñas City

High School Diploma, March 1995

1989 - 1995 St. Francis of Assisi College

Admiral Village, Las Piñas City

Educational Background

Elementary Diploma, March 1995

Contact this candidate