Resume

Sign in

Reporting Specialist

Location:
Parañaque, National Capital Region, Philippines
Salary:
50,000
Posted:
October 23, 2016

Contact this candidate

Resume:

RICO GUTIERREZ SACEDOR

Unit *** Belgium Bldg. Kassel Residences,

Brgy. Moonwalk, Parañaque City, Philippines, 1709

acw629@r.postjobfree.com

+63-925-***-****

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



Contact this candidate