Andrew Banecker

**** ***** ******* ****** ************, PA 19148 215-***-****

adg3y9@r.postjobfree.com

Education

La Salle University, Philadelphia, PA May 2020

Bachelor of Science in Business Administration GPA: 3.80/4.00 Majors: Finance & Business Systems and Analytics

Scholarships & Achievements

Beta Gamma Sigma Honors Society Business Scholars Co-op Program University Honors Program Alpha Epsilon Honors Society Professional Work Experience

Pennsylvania Burial Co. & Baldi Funeral Home, Philadelphia, PA July 2020- Present Assistant Bookkeeper & Operations Manager

• Record daily payments and expenses in Quickbooks

• Review account payable invoices to purchase orders and prepare checks for payment of invoices

• Process death certificates and burial permits in accordance with state and local government regulations

• Manage the coordination with an established bank, the payment of pre-planned funeral expenses into savings accounts and certificates of deposits on behalf of clients

• Coordinate funeral operations and purchases of certified copies of death certificates Johnson & Johnson, New Brunswick, NJ January 2019- July 2019 Financial Planning & Analysis Training Intern

• Developed training materials per Adobe Captivate to support the Financial Planning & Analysis Team

• Analyzed financial reporting databases to create effective training materials and financial reports

• Reviewed, updated, edited and coordinated training materials into digestible focused videos focused on IBM TM1 and Tableau for the New Brunswick site

• Extracted historical data financials from data warehouses to support business cycle reporting processes

• Trained new hires and fellow interns on financial reporting processes of IBM TM1 Department of Revenue-City of Philadelphia, Philadelphia, PA April 2018- August 2018 Research Analyst Intern

• Assessed and applied proper sector identification codes for T-5 Tax Forms into databases

• Prepared Daily, Weekly, and Monthly reports related to city tax revenues and real estate transactions

• Evaluated database records by researching accurate addresses, real estate grantees, and property values

• Reported changes in financial data while using SQL Server to query and extract data

• Reviewed submitted tax documentation thoroughly to ensure materials met government guidelines and regulations

Leadership & Activities

Templeton Business Ethics Case Competition February 2020 Pheed Philadelphia Volunteer (Face to Face) September 2019- December 2019 La Salle University Investment Club September 2019- May 2020 CFA Stock Valuation Research Challenge September 2019- February 2020 La Salle Ambassadors Club February 2018- May 2020

Enactus (CFO - AY 18-19) September 2017- May 2020

Certifications/Technical Skills

Advanced in Microsoft Excel; Proficient in Microsoft Office, R, Tableau, JMP Pro, MySQL Server; Bloomberg Market Concepts Certification

Contact this candidate