Summary
Work history
Skills
Education
LANGUAGES
References
Certification
Generic

Erwin Esplana

London,United Kingdom

Summary

Experienced professional in the tobacco industry and confectionary since 2008, with a focus on data management, including data entry, invoicing, and accounts receivable reconciliation, Pricing Maintenance. Demonstrated success in ensuring data quality and compliance through collaboration with business partners. Knowledgeable in SAP Customer Master Processes and dedicated to business process optimization. Quick to adapt and learn new methodologies for improved overall performance. Passionate with experience in data accuracy and management. Independent problem-solver focused on customer service and works well under tight deadlines.

Work history

Data Maintenance Analyst

Upskill MNL
Manila, Philippines
2023.08 - 2025.12
  • Supported database administration and maintenance for teams across functions.
  • Assisted in maintaining accuracy and timeliness of system information updates.
  • Helped compile information from various platforms for product innovations and changes.
  • Coordinated necessary updates to customer pricing to align with global strategies.
  • Verified consistency of SAP export pricing with external customer files.
  • Provided updates on customer gross sales in internal pricing files.
  • Leveraged Excel functions for streamlined data evaluation and presentation,.

Data Integrity Analyst - Customer

Philip Morris International Business Solution
Makati City, Philippines
2021.02 - 2022.08
  • Established customer master database in accordance with PMI processes and policies.
  • Assisted in developing process improvements through participation in cross-functional projects.
  • Performed ad hoc analytics and generated comprehensive reports.
  • Checked data accuracy and completeness by providing feedback to business stakeholders.
  • Coordinated with business stakeholders to resolve issues related to CMD processes.
  • Supported data lifecycle operations, including quality audits and data cleansing.
  • Managed data operations for APAC region while acting as backup for Europe region.
  • Participated in developmental and career training initiatives.
  • Conducted UAT testing in SAP QA environment.
  • Executed mass creation and update tasks using Winshuttle.
  • Collaborated with local SAP development team for data exports and imports.

Business Support - Customer Master Data Analyst

Philip Morris Fortune Tobacco Corporation Inc.
Marikina City, Philippines
2020.08 - 2021.01
  • Oversaw daily, weekly, and monthly tasks and reporting duties.
  • Assisted with adherence to all SAP and ISMS processes for data creation and maintenance.
  • Supported the creation and editing of master data in line with established policies and desktop instructions (SAP).
  • Consolidated maintenance requests in a central location for improved efficiency.
  • Resolved requests and offered excellent customer service guidance and standard support.
  • Conducted UAT testing to verify system functionality.
  • Managed SKU and barcode creation in ISMS database.
  • Performed mass creation tasks using Winshuttle.
  • Collaborated with affiliates to enhance operational workflows.

Finance Services Analyst - Bank Reconciliation

Philip Morris Fortune Tobacco Corporation Inc.
Marikina City, Philippines
2015.09 - 2020.07
  • Performed monthly bank account reconciliations against General Ledger.
  • Handled reconciliations of checks and deposits, ensuring accuracy.
  • Investigated and resolved discrepancies with methodical research.
  • Prepared journal entries for adjustments and corrections in SAP.
  • Processed check copy requests and managed other check matters efficiently.
  • Maintained constant communication with affiliate team to address concerns promptly.
  • Provided customer support for escalated store issues as well as bank procedures and policies.
  • Executed SAP clearing transactions to ensure data integrity.

Area Planning Assistant

Philip Morris Fortune Tobacco Corporation Inc.
Pasig City, Philippines
2015.03 - 2015.08
  • Assisted with compliance in ISMS process including FG reconciliation, stock reconciliation, route planning maintenance, journey generation, and iPad rotation support.
  • Provided information and analysis on sales volume objectives and brand performance.
  • Audited client master data alongside field sales force and supervisors to ensure accuracy and completeness of customer information.

Sales Finance Assistant

Philip Morris Fortune Tobacco Corporation Inc.
Pasig City, Philippines
2012.08 - 2015.02
  • Encoded invoices from SAS/ISMS with accuracy and efficiency.
  • Validated and analysed DSAR for correctness and relevance.
  • Assisted in generating reports to provide insightful data for decision-making.
  • Supported data analytics efforts as required by operational needs.
  • Maintained up-to-date knowledge of changes in data entry procedures.
  • Ensured compliance with all company policies and procedures.

Data Clerk

Fortune Tobacco Corporation
Pasig City, Philippines
2008.03 - 2012.07
  • Assisted in manual data entry into databases and spreadsheets after transcribing recordings.
  • Reviewed data for accuracy and made necessary adjustments through error identification and correction.
  • Collaborated with various organisational units to support accurate data processing.
  • Created reports to fulfil business requirements.
  • Provided training to new employees on data entry procedures to aid team efficiency.
  • Conducted regular data backups to prevent potential loss.
  • Followed established data entry procedures and protocols.

Skills

  • Database management and maintenance
  • Pricing and file oversight
  • SAP ERP and S/4 expertise
  • Master data management
  • Data cleansing and entry
  • User acceptance testing
  • Winshuttle proficiency
  • Bank reconciliation and journal entries
  • Reporting and data analysis
  • Collaboration and communication skills
  • Customer service excellence
  • Problem solving strategies
  • SQL
  • Excel VLOOKUPs and pivot tables

Education

Secondary -

Rizal High School
Pasig City, Philippines
2000.06 - 2004.03

BS - Computer Engineering

Rizal Technological University
Mandaluyong City, Philippines
2004.03 - 2009.04

LANGUAGES

English (Fluent)
Filipino (Native)

References

  • Maria Cristine Sarmiento - Elisan, Data Integrity Analyst, Philip Morris International Business Solution PH, 0920-6447569
  • Mark Anthony Racelis, Data Integrity Senior Analyst, Philip Morris International Business Solution PH, 0905-5992487
  • Thomas George, Business Mgr. World Travel Retail, Hershey's, TGeorge1@hersheys.com, +91 99004 41233
  • Ysaline Lannoy, Manager Marketing-World Travel Retail EU/MEA, Hershey's, ylannoy@hersheys.com, +447741084105

Certification

* Introduction to MS Excel

Certificate code : 9687669

* Introduction to SQL

Certificate code :9690036

Similar Profiles

Create profile
Erwin Esplana