Medical Representative Event Manager
Resume:
John Rupert J. Trajano
* ****** **, *** *******, Almanza, Las Pinas City, Philippines
***********@*****.***
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