AARON LYONS

Inserted customer and account data into the system by accurately inputting text and numerical information from source documents within specified time limits., Compiled, verified accuracy, and sorted information according to priorities to prepare source data for computer entry., Reviewed data for deficiencies or errors, correcting any incompatibilities as possible and checking output integrity., Researched and obtained further information for incomplete documents to ensure successful entries., Applied data program techniques and procedures effectively., Generated reports, stored completed work in designated locations, and performed backup operations as required., Scanned documents and printed files as needed to support operational requirements., Maintained confidentiality of information at all times., Responded to queries for information and accessed relevant files to assist internal and external stakeholders., Ensured compliance with data integrity and security policies throughout all operations., Used office equipment effectively, addressing malfunctions as necessary.

Managed freight orders for client David Jones, overseeing quoting and coordination processes., Gathered and analyzed local charges, pickup costs, port fees, and additional origin costs from global offices and agents., Updated autorating costs inside CargoWise monthly, based on rates provided by the sales team., Verified buy and sell rates against rate cards to ensure profitability, prevent cost overruns, and maintain alignment with client agreements., Provided accurate quotes for airfreight, LCL/FCL sea freight, refrigerated, and dangerous goods shipments., Obtained critical shipment details, including cargo ready dates, commercial documents, packing specifications, and transportation requirements from suppliers, ensuring smooth logistics planning., Communicated available sailing schedules, transit times, and routing options to David Jones, providing flexible solutions and guiding clients on optimal shipping methods., Coordinated sea and air freight bookings with origin offices and agents, ensuring alignment with required delivery timelines while optimizing space utilization and cost efficiency., Updated CargoWise with cargo details, tracking milestones, and voyage information., Maintained clear communication with clients, offices, and agents to facilitate smooth freight movement., Proactively resolved shipment issues, prioritizing urgent freight with alternative solutions when necessary., Contributed ideas and process improvements on effectively handling orders, tracking shipments, and monitoring goods.

Generated precise price estimates for clients, ensuring competitive quotes for freight shipping services., Gained experience in moving ISO tanks, including checking MSDS, compatibility for food and non-food grade commodities, and assisting with empty repositioning across various locations with coordination from agents., Developed relationships with ISO tank agents, facilitating potential reload opportunities., Conducted market research for new business opportunities related to ISO tanks, leveraging knowledge of popular Australian export commodities such as tallow, ethanol, used cooking oil, and various hazardous and non-hazardous chemicals, involving proactive outreach and quotations., Created a systematic mail-out routine using my IT skills to engage more ISO tank agents, resulting in the company repositioning four times the number of ISO tanks compared to the previous year when I started., Developed a system using real-time data to market the availability of ISO tanks at every depot across Australia, receiving positive feedback from potential customers., Obtained cleaning cost estimates for ISO tanks from depots, compiling costs to present to agents., Researched and secured up-to-date pricing and rate information from carriers and transport companies, supporting quoting processes., Coordinated transportation logistics across diverse modes, including road, sea, air, and rail, optimizing routes and ensuring timely delivery., Proficiently utilized CargoWise software for efficient logistics and supply chain operations management., Cultivated strong relationships with existing clients, providing exceptional customer service and proactively addressing their needs., Effectively communicated with clients to comprehend requirements and maintain satisfaction., Initiated cold calls to potential customers, identifying business opportunities., Developed and implemented tracking systems to monitor customer shipments, ensuring real-time visibility., Formulated strategies to target multiple shipping lines, cartage companies, and agents, personalizing outreach approaches to secure competitive rates., Designed engaging newsletters to keep clients informed about industry updates and available services, enhancing client engagement.

Gained experience in using the SAP database system, learning to raise orders, create invoices, process incoming and outgoing payments, and manage item transfers efficiently., Demonstrated capabilities in selling a variety of computer-related products, including hardware (CPUs, GPUs, RAM, motherboards), computers (laptops, PCs, NUCs, custom builds), software (antivirus, Windows 10, and Acronis), and other electronics (speakers, monitors, keyboards, mice, and game controllers)., Organized stock in allocated store locations and maintained cleanliness in the area, including rearranging items for neat presentation and ensuring up-to-date pricing, especially during sales events., Achieved sales targets by focusing on incentivized items and proactively seizing opportunities to sell products., Processed warranties using designated systems while striving to address customer issues promptly and effectively., Adhered strictly to company policies and procedures, consulting managers or experienced colleagues when necessary for assistance., Served customers efficiently at the front counter, managing invoice creation, refunds, user account access, and credit applications using the cash register., Handled store opening and closing responsibilities, including powering on/off computers and gadgets on display, securing premises, and conducting end-of-day financial settlements., Fostered effective communication with customers, addressing needs through product knowledge, establishing trust with regular customers, and offering competitive pricing where possible, ensuring proactive updates on order arrivals via phone or email., Utilized phones efficiently for customer communication, keeping them informed and transferring calls to relevant departments when required or assisting with diagnosing computer issues., Checked company emails and responded to requests from colleagues, facilitating support opportunities where possible., Participated in a training program provided by Brother, enhancing knowledge of printers and improving ability to meet customer needs.

Created and managed 30–40 customer orders monthly in CargoWise for various food product categories, ensuring precise data entry and adherence to all relevant specifications., Engaged with multiple suppliers to confirm cargo readiness and specifications while securing the necessary shipping documentation., Coordinated cargo pickups and shipping with appropriate carriers, ensuring compliance with client-approved tariffs and delivery schedules., Communicated proactively with customers about delays, schedule changes, ETDs/ETAs, and transshipment updates, offering transparent and timely information., Prepared and delivered weekly shipment status reports, providing detailed commentary on cargo progress and potential risks., Updated CargoWise with changes to purchase orders, shipment details, and other operational data as necessary., Ensured prompt collection of EDOs and Outturn Reports from shipping lines and co-loaders for LCL and Air Freight cargo., Booked delivery timeslots with clients and 3PL sites, securing instructions and synchronizing delivery schedules in advance., Coordinated container deliveries with transport vendors, issuing EDOs and providing precise delivery instructions to prevent demurrage charges., Managed empty container returns before the expiration of the last free day to avert detention fees., Updated CargoWise with PODs, estimated/actual delivery times, and dehire notifications for enhanced visibility and compliance., Arranged deliveries for LCL and Air Freight cargo, ensuring effective coordination between carriers, warehouses, and clients., Prepared monthly warehousing invoices for clients, verifying the accuracy of 3PL charges and tariff updates., Maintained and updated tariffs in response to new 3PL charges introduced., Utilized Excel tools, including lookup functions, to manage extensive data sets and automate rating processes., Delivered consistent results through strong operational discipline, proactive communication, and comprehensive knowledge of CargoWise and logistics workflows, achieving:, Reduced operational costs through effective demurrage/detention avoidance and precise rating., Increased customer satisfaction by providing timely updates, ensuring transparency, and delivering on time., Enhanced operational efficiency with accurate system updates and seamless coordination.

Employed SQL for data storage and reporting, particularly for updating EDI., Utilized stored procedures to execute reports for clients, updating information and performing data builds., Demonstrated capability in joining multiple tables and understanding various join types for comprehensive reporting., Leveraged scalar and table-based functions to extract key information from tables for query implementation, streamlining tasks., Optimized SQL performance through analysis of the .Sqlpan file, adjusting queries to enhance report speed and resource efficiency., Maintained a solid understanding of SQL functions to manipulate data effectively for client reporting., Utilized SSRS in Visual Studio to create live reports from SQL Server, adding parameters to capture specific user requirements and designing user-friendly pages., Utilized SSIS to capture and interpret data from flat files or CSV, converting and manipulating fields for SQL database integration, demonstrating considerable proficiency with SSIS toolbox tools., Generated XMLs from schemas using raw data in Altova Mapforce, employing all functionalities to modify string formats and dates as required., Configured FTP servers for clients to facilitate file transfers, ensuring efficient processing for our systems., Set up Power BI to display client-preferred graphs and charts, utilizing SQL Server data, capable of hosting reports online if multiple user licenses permit., Acquired experience with VMware, as all workstations at the company are virtualized, with capabilities in setting up new workstations and migrating applications and data., Possessed solid knowledge of CargoWise, navigating menus to set up shipments, declarations, purchase orders, and making user adjustments., Assisted staff with basic daily IT issues, demonstrating a willingness to help colleagues and resolve problems promptly., Managed multiple client projects that spanned several months, showcasing capabilities in collaboration and a commitment to gathering extensive information to fulfill client needs while demonstrating initiative in seeking clarification when necessary.