Works

I am a doer, sincere & practical with good logic.

“Being scarce on resources should not be the norm. With us, you can generate good alternatives, explore options, evaluate plan where you can establish quick wins. Schedule a discover call with us, so we can help you gather all available information, analyzed the root causes, and facilitate a brainstorming session with you.”

Go back

Thank you for your inquiry! 🙂

Our regular service charge is $80/hour or fixed price by project.

Check out more here.

REMOTE SUPPORT- HAVE YOUR DESK# READY

  • Sage University Certification

    • Sage 100 General Ledge (100E)
    • Sage Crystal Report

  • ERP System

    • Convert mass data from an independent DOS system to Sage 300 ERP for system upgrade. Restructure AP, AR Terms, Rules. Perform data migration with Sage 300 Partner.
    • Install Sage 300 Desktops, Maintain Sage Server & 1st Tier trouble shooting & product update.
    • Sage 300 Server Admin.
    • Coordinate Upgrade with Sage 100 Reseller from MAS 90 2013 to Sage 100 2016.
    • Coordinate Upgrade with Sage Reseller from Sage 100 2016 to Sage100 V2020.
    • Sage 100 VI, Custom Office, User Defined Field & Script.
    • Sage 100 Paperless Office Setup & Troubleshooting.
    • Sage 100 1st Tier trouble shooting & training.
    • Sage knowledge of more than 10 years experience in Sage.

  • Ecommerce & Shipping Fulfillment Software

    • Install custom scripting, update & maintain Starship Shipping Server.
    • Lead & coordinate ShippingEasy integration with Sage ERP.
    • Lead & coordinate WMS Scanforce Multi bin Software integration with ERP.
    • Lead & coordinate various automation projects, included but not limited to 3PL fulfillment ERP, FEDEX ERP, AR credit card auotmation.
    • Design custom packing list, custom BOL, custom reporting, create shipping rules for both LTL & Small Parcel shipments.
    • Evaluating business processes, anticipating requirements, uncovering areas for improvement, developing, and implementing solutions. Proven scope of works from various automation projects.
    • Set Shopify RMA Management & Customer Group Pricing.
    • Amazon Seller Central data management & Amazon FBA inventory management.
    • Converting raw data of Amazon Payment from Flat File V2 to AR & AP data to be recorded back to accounting books

  • BI Reporting & Data Operation Management & Modeling

    • Build custom tax report for evaluation on retail tax filing on multi-channel ecommerce stores.
    • Build geographic data (by county | by segment | by product line | by year | using Crystal Report & Pivot Table for Sales & Marketing Team.
    • Designing data modeling & data architecture for WMS, such as auto storage calculation per cubic feet; total warehouse storage space evaluation in square feet; inbound outbound service charges; auto reporting; custom picking and packing sheet; inventory label with barcode, etc.
    • Write KPI Reporting (Key Performance Indicators), for Accounting, GL, Shipping, Receiving, Production, Inventory Control.
    • Knowledge of writing SQL Query
    • Writing Knowledge Sync Alert & Automation
    • DocLink Admin
    • Sage CRM Admin
    • BPD (Business Processing Design).
    • Write operation SOP | Streamline operation process flow.
    • Write Scope of Work for custom projects to developer for custom automation.
    • Lead, coordinate and assist with the design of process improvements and monitoring of data quality.
    • Create Webinar training to internal & external stakeholders.
    • Strong sense on operation streamline procedures.
    • Good sense of AR & GL.

  • Marketing: Video | Form Integration | Webpage | Logo |Custom QR Code

    • Online Wedding RSVP Page
    • Real Estate Landing Page
    • Company Video Intro
    • Event Webpage
    • Online Portfolio
    • Form Integration
    • Convert online form such as credit application, BOL to PDF & integrated to your system storage.
    • Company Logo Design
    • Custom QR Code

  • Microsoft Office 365

  • Adobe

  • Google Reviews

  • Public Notary Services State of California Licensed & Bonded

  • Highlight Skills

    • 8+ Years of data analyst experience.
    • 10+ Years ERP knowledge.
    • Strong logic/ problem solver/ doer.
    • Comprehensive knowledge of Microsoft Excel, Crystal Report.
    • Good knowledge of accounting AR, GL, Inventory Management, Bill of Material.
    • Good knowledge of SQL Query, mapping
    • Good knowledge of Office 365, Adobe Illustration, Adobe Photoshop, Video Proc, Formfilling, Shopping Cart.
    • Experience Amazon FBA & Payment processing.
    • Organized & detail orientated.
    • Strong work ethic & accountable.