Operations Support Analyst
DHL Supply Chain
مجموع سنوات الخبرة :23 years, 11 أشهر
Project Accomplishments
• As Programmer for DHL Supply Chain on Risk Assessment Fees from October 2013 - Present
Description: an automated system to log and monitor customer contracts that includes exposure to additional risks that exceed standard liability. The system is able to display RAF collection summary dashboard and system dashboard as well as ability for query reports.
Team Size: 3; Tools: VB.Net 2010 and MS Access
• As Programmer for Scepco and DHL Supply Chain on Journey Management from May 2013 -Present
Description: an online and offline system designed for Scpeco account in China to determine fleet workloads and utilization, fatigue management, cost allocation, and daily vehicle data. The system features monitoring of journey planning form by 30minutes interval, integration of HSE, web link to weather forecast and maps.
Team Size: 5; Tools: VB.Net and MS Access
• As Programmer for DHL Supply Chain on Claims Database from December 2012 - May 2013
Description: it is a centralized system used in 21 countries across APMEA to log customer's claims and tracks expected due for settlement. Reports are custom made tailored to management needs such as claims above or below deductible, top 10 claims for amount taken into P&L and gross claims.
Team Size: 3; Tools: VB.Net and MS Access
Job Description
• Administer and manages Global Performance Measurement system: create and close site; assign KPI applicability and event target value; grant and remove site owners; upload changes thru import functionality;
• Extracts data in Essbase for monthly electricity report. Prepares Executive Management Review Report every month. Collects data from Operations Excellence Lead and prepares Operations Excellence Plan report for VP quarterly review. Prepares Pallet Management for Asset Visibility report.
• Performs Regional Carbon Data Audit and assists the auditors to plan and perform for country audit. Prepares Audit Result of the Review Status Tracker for Go Green.
• Conducts business service requirements to develop client-server windows based application; Develops and maintains applications and databases by evaluating client needs: analyzing requirements; developing software systems; Confirms program operation by conducting tests; modifying program sequence and codes.
• Provides reference for use of prime and personal computers by writing and maintaining user documentation; maintaining a helpdesk.
Project Accomplishments
• As Programmer for Makino Asia Pte Ltd on Electronic Service Contract Interface from March 2012 - October 2012
Description: uploads details from service contract form to database, approval of content for the team leader and reporting functionality.
Team Size: 5; Tools: VB.net and MS SQL 2008
• As Programmer for Makino Asia Pte Ltd on Service Contract Form with Sign Pad from January 2012 - September 2013
Description: it is a paperless contract used by service engineers in performing task in the client's site. This is to impress their high-profile clients and other major companies.
Team Size: 5; Tools: Adobe Acrobat Professional
• Plan Visit - an interface for recording of sales visit activities for the salesmen.
Tools: Excel VBA, MS Access
Job Description
• Prepare weekly consolidated sales report such as Claims by Week, Purpose of Visit, and Total No of Activities, Pie Sector, Pie Industry, and Total No of Company Visit for each salesman.
• Extracts raw data from Jeeves and Syteline from Microsoft Query and ODBC to prepare weekly report for Customer Service such as open and close service calls, service engineers allocation according to problem category and skills, statistics of calls attended by each service engineers and issues, service engineers performance and utilization, service engineers OT allocation, parts used in the service report, report on spindle failures - accident and manufacturing defect, report on parts shipment - warranty and non-warranty.
• Perform cost roll-up procedure every end of the month in Syteline. Do crash recovery, pre cost rollup backup, backup preparation, shutting down the database, truncating BI files and starting the system database in UNIX.
• Worked with Customer Services department in upgrading their service contract report to a paperless interactive form with the ability for the client to sign the document using a signage pad. Scout vendor for the sign pad and designed an adobe interactive form.
• Develops an interface using excel for recording of sales visit activity (company visited against plan visit, identification of the industry and operation, recording of mileage and primary product as well as purpose of visit) and generate reports such as Ratio of Expected and Actual Visit, Coverage of Existing and New Customer, and Sales Visit by Industry.
Project Accomplishments
• Online Data Request -used to submit data requests online with approval routing flow. Improved speed in delivery of request through prioritization queue and identification of data owners.
• Transaction Monitoring - used to log all transactions received by the data management team. Data gathered is used for resource planning, assessing recurring issues and adherence to compliance.
• Data Audit - profiling data and assessing impact of poor quality data affecting payroll and reporting.
• Employee Action Report - document for employee’s job movement, promotion and salary increase.
Job Description
• Manages master data of HR Process in PeopleSoft such as Personal Information, Job Data, Bank Details, Biography, Education, Work Experience, Recruitment, Employee Self Service (Change of Name, Address and Contact Details), Manager Self Service (Promotion, Manager Change, Pay Increase). Operates a process of highly-reliable data entry around employee information, customer friendly resolution of user inquiries, questions, and problems.
• Cooperate and communicate with the HR Business Partners, Compensation and Benefits and Recruitment to support divisional area workforce analytics requirements.
• Performs data audit processes in a monthly basis to ensure data integrity and avoid errors before running of payroll, census, and headcount and attrition report. Responsible for providing support to user on applications-related issues. Analyze and identify the cause of the issue. Follow up on issues with users and development teams.
• Documentation of all procedures, specifications and process.
• Prepares monthly headcount and attrition analysis report for the CEO across Philippine site. Includes employee movement, expatriate coming in and going out, contractual converted to regular employee, regular and probationary.
• Creates a specific and customized report that displays the most current information in the format the requester specifies. Provides a complete query and analysis functions against metadata and predefined queries. Distributes the query to the users for a self-service extraction. Displays parameters prompts, making it easier for users to refine their reports and provides user self service that lets the business users extracts ad-hoc reports.
• Creates test case and performs user acceptance test during upgrade in all processes managed including query manager.
Project Accomplishments
• Automated Training Billable Hour -used for billing purposes in the format that is required by the client for submission. Improved speed in delivery of month end report to the client passing all audit stages. Tools: VB.net & MS Access
• Site Dashboard - displays snapshot of performance for the managers to monitor the contribution of the various departments of the organization. Helps the management gauge how well an organization is performing by capturing the report specific data points from each department within the organization. Tools: VB.net & MS Access
Job Description
• Prepares weekly and monthly report for training billable hours.
• Coordinate with the Training Delivery Manager for training courses, course length, participants involved and schedule.
• Escalate issues to Team Leader and Trainers for low and excess hours incurred by the agents and trainees affecting training courses such as Read Time, Applied Learning Lab & Product Specific Training.
• Communicate updates to Operations Managers on the initial audit run and final report outcome for the summary of billable hours and estimated loss.
• Modify approved time cards of all employees.
• Conducts training to Team Leaders and Offline Supervisors in using the Time Keeping System for approving holidays, creating time card and generating reports.
• Extracts time card of all Team Leaders and Offline Supervisors and prepares time efficiency report for the Senior Management.
• Conducts business system requirements analysis from Recruitment, Training and Production. Identifies and documents all business, technical, product and processes requirements. Works with the stakeholder to prioritize and rationalize the requirements. Prepare detailed flow charts and diagrams outlining system capabilities and act as a liaison between the software development team and the business team.
• Proposed improvement to business processes to allow efficiency and effectiveness of capturing insightful data in the format that is useful to the senior management team in their decision making without sacrificing the metrics maintained by the call specialist
• Confers with the process owners to identify problems and gather suggestions for improvements. Recommends establishment of new and modified reporting methods and procedures to improve report content and completeness of information.
• Collect agents’ scorecard by wave from Recruitment, Training and Production. Performs audit to identify missing information, cleanse data and upload to MS Access database.
• Prepares weekly and monthly performance report by wave.
• Delivers ad-hoc breakdown report of top and bottom performers.
• Assign document no to approved process and guideline documents.
• Post updated documents to SharePoint and archive old documents.
• Add approved user in SharePoint.
• Retrieve process and guideline documents to add signatories of new hire Team Leaders to include in their on-boarding process.
• Communicate expiring process and guideline documents. Follow-up on updated documents.
• Participate in monthly operations meeting to identify new process to be created, process owner and monitor the progress of the document up to approval.
Project Accomplishments
• Electronic Election System -used during student council election for recording of votes and electronic means of counting votes. Tools: VB & MS Access
Job Description
• Ensure that each student has an enjoyable, productive, challenging and meaningful experience.
• Provide appropriate, intellectually stimulating instruction in each class by taking into consideration the unique abilities of each student.
• Interacts with students, parents, and staff regarding the progress of students in my classes.
• Monitor the behavior of students and staff in the academic setting, monitor classroom operations in terms of absenteeism, tardiness, and discipline.
• Submit a final student performance review for each of the students prior to the closing ceremony.
Field of Study: Bachelor of Science in Computer Science Institute/ University: AMA Computer College Location: Cebu, Philippines Graduated: May 2000