Anton Olson Email & Phone Number

Konstanz, De

• Enter client support issues within Mantis - Korber's main ticketing software - for visibility and tracking purposes• Participate in regression testing for new releases of STEPLogic Trace and Warehouse

Hiram, Ohio, Us

• Optimized and developed stored procedures in SQL Server Management Studio to enhance company operations. • Designed and innovated reports using SSRS to provide both graphical and text-based insights for organizational decision-making. • Oversaw migration of SQL server instances to SQL Safe Management Console to streamline backup and restore processes for improved data integrity.

Us

• Co-managed financial reconciliation software – TRECS to ensure accurate distribution lists, escrow amounts, and account validations, in addition to establishing new accounts.• Designed custom import definitions within TRECS's scheduling module by aligning client bank files with internal data mapping standards. • Applied Microsoft Query and Power Query to refine and update SQL queries for Client Banking associates. • Maintained and updated master database weekly by using Microsoft Access and Excel for managing program details and client status.• Designed and executed nine automated processes using PowerShell scripts, each ranging from 50 to 180 lines of code, invoking commands from SQL Server Management Studio to extract data, input data into Excel files, and automatically send emails with Excel attachments.• Originated eight SmartResolve procedures to expedite transaction adjustments in TRECS.

Reading, Pennsylvania, Us

• Aided in solution building and testing new functionality within Oracle Transportation Management (OTM) – this is a stand-alone module that ties in with their DCC product line• Enhanced existing agents within OTM to fix common errors• Modified screen sets to showcase data on customized dispatch boards for operations purposes

Reading, Pennsylvania, Us

• Managed and enhanced OTM and security processes by employing expertise in company systems and protocols. • Created Excel VBA macros to automate weekly telematics reporting by improving efficiency and simplifying knowledge transfer.• Authored Python scripts to facilitate issue resolution for team members lacking SQL proficiency.• Contributed to successful on-premises upgrade of OTM, while ensuring seamless transition between versions and minimizing system downtime.• Achieved 85% resolution rate for escalated IT issues by reducing downtime and improving user productivity

Wickliffe, Oh, Us

My onsite location was at Penske Logistics Technology office in Beachwood, OH• Worked with customized OTM and MercuryGate TMS modules to analyze and identify issues to provide first-level support to field operators• Ensured seamless coverage for off-shift and weekend hours for help desk/ticket investigation and additional resources for testing and quality assurance• Documented help desk processes and numerous procedures, along with creating knowledge-based testing questions, to aid in training customers• Resolved customer issues and completing required help ticket• Processed, packaged, and shipped phones and scanner orders to customers• Compiled Xata Turnpike data to collate phone reports for multiple customers for tracking any trucking violations

• Completed general journal entries, account reconciliation, payables, preparing and posting deposits, daily banking, updated school billing process and entered payroll using Sage Accounting Software to increase office flow during high volume times• Proofread marketing materials while utilizing MS Excel and MS Publisher• Entered payroll time cards for over 25 part time employees and processed payroll for over 30 contracted employees who are paid semi-monthly through local payroll company• Collated back-to-school information