Seng Tuan Teo

Excel VBA SQL Pivot Table SAP

Talent

Singapore0Member since November 10, 2022

Hire this person

Send a job offer directly to this candidate

About

I have knowledge & skills in SAP, Excel VBA, SQL script & database , Pivot Table, Report writing. Accounting trained and good at programming (Data). Past 7 years in Supply Chain Customer Service. Prepare KPI Report for Management Review ( Mainly for Inventory Management Review, Scrap, DIOH, Expiry Analysis, Sales Trend, etc).

Familiar with Midrange ERP system, Especially in Dynamics GP. (Purchasing Order Processing, Sales Order Processing, Inventory Control, General Ledger, Receivables Management and Payables Management modules. Collect and analyze user requirements, design & software testing). Nowadays, they called Dynamics 365.

Experience

Order processing, manage consignment inventory, working with internal customers sales representative and management, as well as external stakeholders’ hospitals & 3rd party logistic to ensure timely delivery of products.
Tracking back orders & handling product complaints & recall.
Produce daily/monthly reporting in excel VBA/Pivot table for management review for the purpose of cycle count, tracking expiry product and scrap.

a. Cycle count project: Writing excel macro for sales rep to semi auto the reconciliation process for the consignment inventory at hospital.

b. ASEAN KPI Report: DIOH/Turn Report, Near Expiry report, Scrap Report, Consignment Aging report, Etc.

c. BAPI: SAP R/3 screen automation with Excel VBA to automate data entry. Involved with hospital RPA project for semi auto data entry for consignment billing.

d. Daily Inventory open order report, in transit, open order with STO information.

Assisting sales representative to produce analysis data for ALPS, SingHealth & NHG for tender as well as yearly consumption report.
Working together with finance monthly on Accounts receivables review on outstanding invoices.
Knowledge and skills in SAP R3 /SAP-by-D, Excel VBA, pivot table, SQL database query & scripting.

Maintain and Support Microsoft Dynamics GP in Boston Scientific SEA Region. Assist with operational and financial month end closing; Perform reconciliation; on sub ledger such as inventory stocks and receivables to GL; Aging reports; excel pivoting tables.

SKILL & EXPERIENCE

Familiar with medium size ERP system (especially Dynamics GP): Purchasing Order Processing, Sales Order Processing, Inventory Control, General Ledger, Receivables Management and Payables Management modules.

Good in data management especially producing adhoc report

Excel VBA / MSSQL scripting query, collect and analyze user requirements, design & software testing.