John O’Connor
** ********** ****** **********, ** 18424 570-***-**** **************@*****.***
Experienced Financial Analyst
Work Experience
Financial Analyst – Prudential Financial (Jan. 2019 – Mar. 2019) (Moosic, PA)
Reconciled reports with banking statements for year-end audit
Performed quality control procedures for annual reporting
Created reports for year end results
Financial Analyst – Shearman & Sterling (Jul. 2018 – Aug. 2018) (New York, NY)
Created reports related to the month end close process using SQL reports and analyzed results
Performed quality control procedures for monthly operating statements
Created and uploaded monthly financial results for a firm wide database
Financial Analyst – Hachette Book Group (Dec. 2015 – Mar. 2018) (New York, NY)
Worked as Analyst assisting finance directors for flagship company brand
Assisted in creation of annual budget and annual reforecast along with related presentation materials
Submitted various reporting deliverables for month end financial process to senior directors
Integrated new business acquisitions into financial reporting deliverables
Created new KPIs on an ad-hoc basis and used them to evaluate financial results
Created, updated and manipulated financial models in Microsoft Excel for budgeting and forecasting
Created and reviewed P&Ls for month end close
Served as liaison between financial department and other business units
Assisted FP&A team by representing financial results and requirements of certain brands
Revised financial reporting to account for recently divested business interests
Accounts Receivable Analyst – UPS Global Business Services (Oct. 2014 –Dec. 2015) (Throop, PA)
Maintained a portfolio of 25 strategically important businesses including several fortune 500 companies
Resolved billing issues by reviewing invoices and processing billing corrections
Analyzed reports to isolate and resolve recurring operational and billing issues preventing further occurrence
Developed project management skills by prioritizing certain issues across a wide portfolio of clients streamlining the billing and receivables process
Skills Summary
Software:
Windows, Mac OS, Microsoft Word, Excel, Access, PowerPoint, Outlook, Publisher,
Oracle, Cognos, SQL, Other Enterprise Financial Software
Education
York College of Pennsylvania, Graham School of Business York, Pennsylvania
Bachelor of Science- Economics May 2014
Recipient – Dean’s Academic Merit Scholarship
Bloomberg Aptitude Test – 82nd Percentile Nationwide
ETS Major Field Test for Degrees in Business – 90th Percentile National