RICO GUTIERREZ SACEDOR
Unit *** Belgium Bldg. Kassel Residences,
Brgy. Moonwalk, Parañaque City, Philippines, 1709
acw629@r.postjobfree.com
SKILLS
Proficient in Excel Spreadsheet (Functions or formulas like Vlookup, Concatenate, Pivot, logical functions, macro operation and VBA macro scripting, etc.)
Strong presentation, analytical and reporting skills and conveys information clearly and effectively both written and verbal
Advanced skills in Microsoft Office 2007 (Access, Outlook, Powerpoint, Word, Visio)
Excellent Keyboarding skills and shortcut keys
Lotus Notes Applications and Basic Computer Troubleshooting
SAP (Systems Applications and Products) Power User – MM Module
Excellent team player and selflessly shares best practices that are significant to the business
WORK EXPERIENCE
KForce Global Solutions Inc. August 2013 – Present
Makati
Reports Specialist
Prepare accurate reports (daily, weekly, monthly) in a timely manner by generating data BI tool and transform it to a more presentable and easy to understand summary.
Create, design and enhance Excel reporting templates based on the given requirements.
Create process document of every report that serves as a guide by future reporting backup and ensure accuracy and easy-to-follow steps to complete a certain report.
Perform report validation when needed and participate in process improvement to develop effective business solutions.
SELECTED KEY ACCOMPLISHMENTS
Designed and implemented a reporting engine that expedited reports generation time by 67% from 1.5 hours to 30 minutes.
Established a raw data header checker using VBA that resulted to a reduction of OTC reports generation time by 10%.
Trimmed COE processing time of HR Department by 30% through designing and automating a certificate generator.
Reduced invoice auditing process by 5% through creating an automated biller selector using VBA.
Infosys BPO Limited April 2013 – August 2013
Muntinlupa
Reports Specialist
Create and design reports template in excel based on the given criteria or conditions. This includes creation of reports engine.
Coordinate appropriate staffing allocation and availability of call center staff in order to achieve service level objectives. This includes preparation of weekly schedule of agents based on call demand and call volume trend.
Take the role of a Real Time Analyst and responsible for real-time management of resources to ensure there is sufficient number of agents in their seats to answer incoming calls at the desired service level.
Access Worldwide September 2012 – April 2013
Makati
Reports Specialist
Design and enhance reports template in excel based on the given criteria or conditions by creating reports engine.
Prepare sales report based on exported data from the system (hourly, EOD, weekly and monthly)
USAutoParts Network Philippines March 2007 – September 2012
Mandaluyong
Product Applications Manager
Create material code or sku in internal system and perform updates such as sku_status, comment and other product fields
Oversee Front Liners in data gathering and file deployment and supervise Team Leaders in monitoring team member performance and in meeting catalog files deadline
Resolve issues escalated by TL in data processing and data quality check and makes sure they were properly disseminated to their analyst. This includes reviewing of process used in data analysis.
SELECTED KEY ACCOMPLISHMENTS
Led the 250% increase of skus with updated applications per month by instituting a systemized raw data gathering process.
Developed a Fitment Table template that speed up catalog processing time by 20%.
Maintained a one-month lead time for catalog file processing that resulted to a 10% increase of team’s productivity.
Team Leader
Distribute catalog files to junior data analysts and monitor the progress to make sure deadlines are met. This includes spot checking of team member’s output to make sure that process updates are applied to the files they are working.
Provide training to newly hired, disseminate process update, entertain queries when needed and monitor team member performance in a weekly basis.
Perform testing of tables and macros to be used in processing of catalogs. This includes simulation of instruction, documentation and gathering of information as useful tool to speed up the process.
SELECTED KEY ACCOMPLISHMENTS
Enhanced validation formulas of catalog processing from 3 sets to 35 that resulted to 95% accuracy from its original 85% rate.
Established a centralized catalog file tracker with summary provided for easy monitoring of different teams.
Designed a shared query tracker which trimmed down consumed time of process update dissemination.
First to established and documented catalog process that contributed a significant role to team expansion.
UBIX Corporation January 2004 – March 2007
Muntinlupa
Transport & Warehouse Assistant (August 2004 – March 2007)
Prepare Delivery Receipt, Sale Invoice, Trip Summary Report, Receiving Report of copying machine for Metro Manila accounts.
Ensure that all machine deliveries to client arrive on time and all delivery documents are properly received by the client.
Responsible in handling files and records related to machine deliveries and ensure completeness of accounted forms series. This includes checking of data entry in SAP, analyzing history of machine installation/pull out, and generating reports as requested.
SELECTED KEY ACCOMPLISHMENTS
Investigated annual inventory discrepancy (copier machine, spare parts and consumables) that led to a zero variance.
Designed SAP reports variants that trimmed down data scrubbing by 5%.
Provided SAP Training (MM and SD Module) for newly hired employee and prepared training hand-outs or manuals per transaction.
Monitored and provided proper solutions on inventory posting error by performing inventory adjustment in SAP based on physical count.
Data Entry Specialist (January 2004 – August 2004)
Investigate system errors and issues in SAP Materials Management module
Coordinate system issues with SAP consultant
Ensure 100% accuracy of data entry in SAP with corresponding documents such as Delivery Receipt, Receiving Report, Sales Invoice, Purchase Order, etc.
EDUCATIONAL BACKGROUND
Tertiary Computer Engineering Technology 2003
Technological University of the Philippines - Taguig
DOST (Philippine Government) Scholar
SELECTED SEMINARS AND TRAININGS
Cultural Diversity in the Workplace Infosys BPO Limited (May 2013)
Communication Skills
Advanced People Handling Skills USAutoParts Network Philippines (March 2011)
Conducted by GuthrieJensen Consultants to Management
ISO 9001:2000 - QMS UBIX Corporation (June 24, 2006)
HAE Consultancy & Training Services
SAP Training UBIX Corporation (Sep.19-Oct 8, 2005)
Conducted by Magnus Philippines. Inc