Ethan Wallace Email & Phone Number

Allentown, Pennsylvania Area

• Developed MS SQL queries for generating reports, process testing, and ETL processes, automating key workflows and reducing manual data handling.• Designed and implemented automated processes using SQL Server Integration Services (SSIS). Managed automation tasks with SQL and Task Manager to ensure timely execution.• Collaborated with Admissions and the Controller’s Office to create reports, integration files, and queries that streamlined data management in Slate CRM.• Provided primary support for Transact, including card reader setup, meal plan integration, system upgrades, and troubleshooting, enhancing operational efficiency across multiple departments.• Administered the Transact eCommerce application, working closely with SODEXO to manage meal plans and visitor card programs, ensuring synchronization with InstantID.• Supported Campus Labs (Idea) by writing SQL queries to integrate SIS data for class and faculty reviews and resolving admin issues.• Managed the transition from IDWorks to InstantID, overseeing ID card production and resolving functionality issues.• Provided support for Pyramed and Maxient, creating and maintaining integration files and working with support teams to resolve user issues.Additional Training:•Diversity, Equity, and Inclusion in the Hiring Process•Surviving an Active Threat: Run. Hide. Fight. - taught by LSU NCBRT

Horsham, Pa

• Developed and maintained enterprise software using Visual Studio, SQL Server Management Studio, SSIS, and Microsoft Office.• Designed and produced reports for clients and for in-house using SQL Server and Qlik Sense.• Provided support to end users, performed trouble shooting, and fixed applications.

Allentown, Pennsylvania

• Developed, modified and ran various reports for multiple clients using Microsoft Office and Oracle Discoverer.• Developed billing engines, reporting applications and enrollment tools using MS Access and ODBC to create front end applications for multiple Oracle databases• Generated utility bills, enrolled new accounts and performed data updates. • Assisted in testing new applications and software before moving them to production.• Developed controls to verify that EDI was sent, received, and mapped correctly.

Ba, Communications - Film And Media

Associate Of Science (A.S.), Computer Information Technologies, Graduated With Honors (Gpa 3.98)

Activities and Societies: Member of Phi Theta Kappa National Honors Society