Kae Lee Pei Yi Email & Phone Number

Singapore

Singapore

Worked on a project under Land Transport Authority (LTA)- Used Extract, Transform and Load extensively to transfer and extract transactional and trip data from flat files and load the data into target database - Wrote shell scripts that automated computationally intensive data extraction requests by users and reduced manual intervention by 80% - Monitoring and troubleshooting of batches and sessions for daily and monthly loading from data sources into target database- Data analysis using SQL and developing a conclusion for end users with queries on the data- Communication with different data stakeholders to ensure data quality and minimize missing data

-Assisted Professor Alan Megargel in course administrative matters-Helped students with troubleshooting during labs

Singapore

- Support in the development of system automation test scripts- Liaise with functional team on open issues according to the business process diagrams- Support the Test Lead in other test related activities for the project- Participated in the project management process through the different phases of deployment

Singapore

-Daily Tracking of inbound shipments via routed carriers (Expeditors, Flexport, Fedex) escalate when predefined issues come up (late shipments, damages, shortages). Prepare daily update for team- Cargo Permit Process export - coordinate with customer's freight forwarder and Cargo Clearance Process. Monitor all orders are picked up on time by customers forwarder. - Coordinate Processing of Imports - screen imports coming in with Fedex, Expeditors and third party forwarders. Pass along the standard instructions on clearance procedures for each type of entry. - Outside Warehouse support - coordinating with routed carrier making sure the correct Cargo Clearance is done by Expeditors or Fedex.- End User Verification Process - Process end user verification, log and upload to sales order- Monitor emails & cell phone for ad hoc requests during scheduled hours. Communicate and coordinate coverage when absences occur with the team

Singapore

- Worked with full-time developers to develop a website which host a variety of educational and recreational online programmes using PHP CodeIgniter Framework - Assisted in application development for an Online Shopping Mall App with the use of React Native Framework and Android Studio. - Participated in code reviews and testing for website and application

Singapore

- Creation of contents for company's mobile application YouPredict, mainly focusing on contents related to PUBG Mobile.

Singapore

- Worked with more than 5 F&B clients by helping them to add value to their operations using cloud based technology and automation to transform data into insights so that clients can make informed decisions. - Managed the books of the organisation's clients and made use of revenue, accounts receivable and expense categorisation entries to analyse data on the performance of the client's F&B business.- Involved in Human Resource works for F&B clients which includes running payroll for all employees, submission of claims and leaves as well as drafting employment contracts.- Made use of content marketing to drive traffic to the company's social media so as to generate more leads.

Singapore

- Provided administrative support such as preparing materials for internal workshops and coordinating with facility and food vendors. - Spearheaded the process of video editing for a Singtel corporate video to be shown during the Annual Summit. - Managing the company's online system and purchase orders.

Singapore

- Assisted in broadcast, audio and video setups in various halls like OCBC Arena ,The National Stadium and Singapore Indoor Stadium during major sports events or concerts like ASEAN Basketball League, WTA Finals and The Big Bang Concert.- Content creation on the giant LED screens across the venues of Singapore Sports Hub.- In charged of leasing equipments to external event hirers and also briefing them on the usage.

Singapore

- Performed data entry into the organisation's internal system and updating SPH's website.- Sending out invites and making phone calls to notify SPH's clients about SPH's events.

Singapore

- Assisted the director in updating customer's policy information into the system.-Filing and printing of documents needed by the director.-Telemarketing to promote company's financial policy and generate leads.

Bachelor Of Information Systems, Information Systems

Activities and Societies: SMU BIA Member

Diploma In Audio Visual Technology, Electrical And Electronics Engineering

Activities and Societies: Korean Cultural Club member