Jing Wang Email & Phone Number

Pasadena, California

Greater Los Angeles Area

Edmondson Park, New South Wales, Australia

• Designed all the templates for the documentation, including contracts, employee and customer portfolios, invoices, pay slips, driving logs, etc.• Prepared contract, collected critical hiring information, and built up portfolios for both customers and employees• Provided invoices to customers and pay slips to employees at right time• Processed payments to employees and receivables from customers as scheduled, sending notifications to verify all payments• Collected daily truck delivery records and necessary documents for each delivery from each driver• Analyzed and reported business performance weekly, monthly, quarterly and yearly with recommendations• Identified suspicious tolling charges caused by the wrong data saved in the truck tolling chips, contacted tolling agency to correct the information and claimed back the mis-charges• Listed out the to-do tasks by priorities for the director to make decisions• Kept updated about government policies and new releases and found more benefits for the business, such as Fuel Tax Credit can get some tax return or reduced on truck fuel expenses

Parramatta, New South Wales, Australia

• Found and reported several data entry errors, and then contacted the data owner to correct the information from user end• Used Microsoft SQL Server with SQL queries to extract data from source systems, create tables and views for reporting and transforming, map the legacy data to the target structure, and perform back up or recovery before and after the testing depending on the purpose of the test• Designed and executed Extract, Transform and Load (ETL) processes with Microsoft SQL Server Integration Services (SSIS), and prepare the files for loading• Made copy of the database before loading, loaded the processed data into the database and ran the tests to validate the new load in SAP, providing analysis reports after each load• Met stakeholders to get business and technical requirements, and completed other authorized tasks if required• Increased the data quality and integrated data from over 5 different source systems and at least 10 sub-departments

Previous At Pyrmont, New South Wales, Australia

The project was to build up an online platform EDWY for students aiming to study in Australia, institutes attracting foreign applicants, and agencies.• Collected 300~1000+ images per day and edited with Photoshop to desirable visual effects, depending on the processing requirements• Extracted information about institutes, agencies, accommodations and jobs from internet, accurately entering the collected data in correct format to ensure the data quality in database• Reviewed and cleaned the data collected from different sources in Excel, preparing file for loading• Determined Key Performance Indicators (KPIs) and produced analysis reports according to the available cleansed data• Conducted User Testing and provided advices from both customer and administration perspectives• Cleansed the data from 8 different sources which contains over 4000 records

Sydney, New South Wales, Australia

• Delivered weekly and monthly sales and inventory reports, determining the promotional products and placing orders according to the analysis• Wrote and examined daily reports regarding total received (Cash and EFT POS) and payments to suppliers• Answered phone calls from customers, suppliers or other branches; helped customers to find preferred products• Produced training materials, trained new hires and scheduled shifts every week• Ensured the adequacy of merchandise; developed a number of loyal customers

Sydney, New South Wales, Australia

• Introduced a new POS system to reduce paperwork, redesigned the sales and inventory management processes, and customized sales reporting and restock strategies• Practiced and learned the operations on the POS system; determined key attributes for products, orders, invoices, customers and vendors; collected all necessary information from products and paperwork; created tables and entered data for loading files in Excel• Configured the application and tested the data after loading, performing technical support as needed• Created user manuals and training programs for understanding the products, sales techniques and new POS system• Transformed paperwork to digital tracking records for key customers and each vendor• Maintained customer relationships by meetings, phones and emails• Designed templates for daily, weekly, monthly, quarterly and yearly sales analysis reports which involve sales margin, sales comparison, sales analysis and stock summary

Master Of Information Technology, Business Information System, Average Distinction

Activities and Societies: MIDEA 2013 End of Year Show.

Graduate Diploma Of Information Technology, Computer Software Engineering, Gpa 7.0/7.0

OUTSTANDING academic performance in Semester 2, 2014 in the program: Master of Information Technology EXCELLENT result in Semester 2, 2014.

Master Of Interaction Design And Electronic Arts, Average Above Credit

Activities and Societies: Team member of interaction installation Compress|Decompress in Cyber Studio Exhibition. Team member.

Bachelor Of Information Engineering, Average Above Distinction

Activities and Societies: Vice President of Radio Fans Association (2009 - 2010) Planner, organizer & emcee of several competitions.