Sign in

Financial Analyst Microsoft Office

Machesney Park, Illinois, United States
August 23, 2018

Contact this candidate


Yinka Senior Financial Johnson Analyst

Rockford, IL 61107 - 224-***-****

Authorized to work in the US for any employer


Senior Financial Analyst

Abbvie Pharmaceuticals -

2007-10 - 2018-01

Leadership Highlights

* Participated in LERN modules compliance for PPD Pricing and Planning personnel to ensure 100% compliance each calendar quarter

* Participated in update of OEC procedures within the new Division, for inclusion in the Division database

* Partnered with IT to establish a standard module that drives Strategic Pricing on ad hoc bases to support internal and external audits

Roles & Responsibilities

* Administered monthly rebate paid analysis report from SAP, TM1, and Hyperion Essbase systems; reconciled RMR data for Manage care and Medicare Part-D with general ledger figures in a timely manner

* Maintained month-end close of consolidated Reserve schedules and designed new rebate schedules to support LBE & LRP expectations

* Coordinated update of Policies and Procedures of PPD Planning and Pricing: the narratives and templates that reflect process improvements in accordance with the approved SOX requirement

* Computed monthly consolidated product schedules of reserves vs. paid; articulated variances for forecast activities

* Prepared monthly rebate roll forward and proof of concept statement for Commercial and Medicaid programs

* Perform variance analysis of reserve vs paid with comments Pricing Analyst


2005-09 - 2007-09

Leadership Highlights

* Managed contractors supporting Ultane rebate payment solution for an extended period

* Collaborated with IT to identify, research, and reconcile data issues associated with electronic Ultane rebate system; communicated with Managers, Strategic Pricing, Sales Force on feedback status

Roles & Responsibilities

* Administered rebate payment in a timely and accurate manner, developed analytical tools for rebate payments with supporting documents

* Reviewed contracts, client's formulas and utilization data for Manage Care, Medicare -Part D, Ery and Ultane rebates, amongst others; with positive impact within the team in a timely manner

* Prepared analysis/graphs for rebate payments and back-up documents to ensure compliance with rebate contract; communicated variance to management, Strategic Pricing, and Field sales organization

Senior Financial Analyst

Allstate Insurance - Northbrook, IL -

2004-11 - 2005-06

* Performed daily reconciliation of fixed income accounts, accrued periodic balancing in line with forecast, reconciled daily overnight investment accounts and updated GL

* Performed month end balancing, MAL, posted correction entries into GL and performed accounts spot checks for SOX compliance

Business Analyst


2001-09 - 2004-11

* Audited compliance of telecommunication bills from vendors; generated benchmark saving and resolution reports monthly

* Managed inventories and deliverables, consolidated accounts and processed payments

* Decreased average processing time from six days to two days, with annual cost savings of

$100,000 for the department

* Awarded employee of the month in March 2004

Financial Consultant

Parsons Group Consulting - Chicago, IL -

1998-02 - 2001-08

* Provided strategic and functional consulting solutions for Fortune 500 organizations within finance and accounting

* Served multiple clients within the following industries: Insurance, Pharmaceuticals, Banking, Technology, and Construction

* Identified issues with GL discrepancies thereby promoting efficiency and effectiveness of investment department operations

* Reengineered and performed accounts payable benchmarks, processed and cut checks, handled vendor complaints; improved the functioning of Pharmaceutical accounts departments

* Performed international accounting with various foreign currencies, including initiation of intercompany summary adjustment reports and maintenance of all compliance reports for a technology organization.

General Manager

Tekon & Associates - Lagos, NG -

1988-09 - 1996-12

* Prepared credit requisition proposals and negotiated terms, waivers, and credit agreements; resulted in favorable credit lines and proper fund flow for bridging purposes

* Administered development and analysis of a $550,000 special project budget; worked to improve profitability of three business lines which generated $12,800,000 in revenue

* Approved trade credit limits for clients, prepared export and import compliance reports, and executed credit collection of 30-plus major accounts; ensured predetermined trade credit limits and reduced over-90-day receivables by more than 60 percent EDUCATION

B.Sc. in Accounting


2009 - 2012


1983 - 1984

Postgraduate Diploma in Management

Portsmouth Graduate Business School



1979 - 1983





* Windows 7/ Windows 10, JD Edward, Oracle Financials, SAP, Maximis, Affinity, Business Objects,

* Hyperion Essbase, Great Dynamics, QuickBooks and Microsoft Office 2003 & 2007 Professional

Contact this candidate