Angelo Schmidt Email & Phone Number

Torrance, Ca

Analyzed and enhanced processes in Cash Posting department for ambulance service provider, which posted $320,000,000 annually.• Programmed advanced Excel macros used nation-wide, reducing time spent on daily deposit reporting by 50%.• Developed Workflow Diagrams for electronic cash posting processes, used as a guideline for cash posting team.• Exported refund files bi-weekly to accounting department, generating 600+ insurance/patient refund checks per week. • Assigned up to $300K workload per Cash Poster daily, consisting of electronic/manual posting.• Generated advanced Excel workbook for Reconciliation Specialist, which reduced month-end balancing time by 50%.• Created Pivot Tables in Excel, improving the process of updating daily/monthly cash reports by linking results to other accounting reporting spreadsheets. • Processed remote bank deposits, which eliminated the need for deposits to be picked up by FedEx couriers.• Researched requests from all departments regarding the location of any checks that were not posted, and resolved any cash posting issues. • Provided cash posting assistance to cash posting team when needed, enabling the department to hit cash posting goals.

Torrance, Ca

Provided training to team of 7 Cash Posters, guiding them through 3 different system migrations. Introduced new processes, reducing time spent on posting.• Trained Cash Posters on the electronic and manual cash posting process, and resolved all questions.• Processed bank deposits, and distributed batches to cash posting staff.• Created cash reconciliation workbook in Excel, allowing posters to balance daily work posted more effectively.• Developed Medicare Allowable Calculation spreadsheet in Excel, increasing cash posting productivity by reducing time spent on Allowable calculations by 75%.• Audited work done by Cash Posters, giving constructive feedback on errors committed.

Torrance, Ca

• Managed Excel worksheets to assist in daily/monthly balancing of all cash posted for the department.• Manually posted $250K insurance/patient payments daily by following SOP guidelines, while balancing work daily for verification of posting total accuracy.• Printed daily reports to ensure accuracy of posting dates and amounts, and corrected any posting errors.

Torrance, Ca

• Created a daily revenue/labor report for hotel General Manager.• Managed Excel worksheets to maintain employee benefits database.• Researched credit card retrieval and charge back requests, and collected money when applicable.

Civil Engineering

Professional Practice and Ethics, Applied Mathematics, and analytical engineering upper division coursework.

Education record

Calculus, Physics, Microbiology, and certificate in lower division general education course work.