John Kenneth Simon

PORTFOLIO

Process Automation | RPA Developer

A Little

About Me

02

With over 13 years in logistics, I specialize in process improvements, workflow ​optimization, and automation. My expertise includes SQL, advanced Excel ​(VBA, pivot tables), RPA with tools like Automation Anywhere and Power ​Automate, and project management using Smartsheet. I streamline workflows, ​automate tasks, and create impactful reports and dashboards to boost ​efficiency and productivity.

Work Experience

Full Time Work

Enable ag

  • integration & testing specialist ​(Apr 2024-sept 2024)


ceva logistics

  • freight forwarding specialist ​(apr 2022-apr 2024)


dhl global forwarding

  • REPORTING ANALYST

(JULY 2013-APRIL ​2​022)


CARGO DATA EXCHANGE C​ENTER

  • CUSTOMER SUPPORT

(J​ULY 20​11-JULY 2013)

Freelance Work

hexa business

  • Excel macro tester


Upwork

  • VBA developer
  • hr assistant

03

Skills & ​Expertise

Skills

  • Data Analysis
  • Database Administration
  • Process Improvement
  • SOP Creation
  • Process Flow
  • Apps Intergration (API)

Software

  • VBA, Python
  • SQL Server
  • Power Automate, Automation Anywhere
  • Smartsheet
  • Z​apier

04

My projects

05

Ac​tivity Log Dashboard

This dashboard gives insights into repo​rt usage, including who accessed the ​reports, made changes, or updated key ​information.

BC​P Dashboard

This dashboard tracks attendance and ​dependability, particularly for BCP ​situations. It shows who is online, in the ​office, and the percentage of sick or ​vacation leave. Powered by Microsoft ​Access and SQL Server.

Re​ports and Metrics

Track the number of tickets resolved by ​specific individuals over the past 13 ​weeks, with the flexibility to adjust ​based on customer requirements.

John Kenneth Simon

Work

with Me

Amaris Homes Molino, Bacoor Cavite

09398990024

simon_kenneth1991@rocketmail.com

08