MARY BURKE

** ********** *****

Manalapan, NJ ***26

908-***-****

acei4k@r.postjobfree.com

Mary Burke, MBA LinkedIn

Analyst with billing/finance experience in the pharmaceutical and

telecommunications industry. Strong data mining abilities and analysis

using huge customer databases containing a wide range of variables.

SUMMARY OF SKILLS

Pharmaceutical industry experience:

. Developed Access databases to extract data from QAD reports that can

be queried and used in Excel reports.

. Created & became the point of contact for a process to track headcount

transfers among business units.

. Assisted HR department by writing queries and retrieving data for

transition to Peoplesoft.

. Worked with business unit personnel to correct intra-company account

balance discrepancies.

. Reduced repetitive manual entry to populate and verify management

reports by creating excel formulas and pivot tables, and manipulating

basic SQL to drill down or aggregate financial data using BI

Publisher.

. Created Oracle Data warehouse, Peoplesoft queries to verify GL account

activity in connection with headcount, operating margins, bonus

calculations, and backlog.

Telecommunications (billing/finance) industry experience:

. Strong data mining abilities and analysis with large customer

databases containing a wide range of variables.

COMPUTER KNOWLEDGE

Excel, Access, Word, PowerPoint, Oracle data warehouse (BI

Publisher/OBIEE), Peoplesoft, AS400, Lawson, Hyperion, Outlook, Monarch,

Pentaho, SQL, QAD, SAP

PROFESSIONAL EXPERIENCE

ABBOTT LABS (POC) (Contract) August,

2013-Present

Financial Analyst II

. Handle month end close, create journal entries and update management

reports.

. Apply cash receipts payments received from vendors into QAD.

. Create Excel formulas, Access queries to reduce manual data

manipulation and increase turnaround time.

. Prepare account reconciliations.

. Assist in audits concerning Sales & Use Tax, and Signoff Authorities.

AIG March, 2013-June,

2013

Financial Analyst - Global Claims FP&A

. Calculate claims pricing to underwriting units utilizing and enhancing

Excel models.

. Create a database using Access to track expenses based on

predetermined insurance rates.

COVANCE, INC. March, 2011-

February 2013

Finance Analyst

. Perform month end close/consolidation, working with finance personnel

at each business unit to verify headcount and revenue highlights.

. Created the Backlog report to track Contracted v. CMV (minimum volume

commitment).

. Generate timely & accurate monthly/quarterly reports (P&L) for senior

management.

. Update, verify reports using Peoplesoft, Excel, Oracle data warehouse

reporting tools, basic SQL.

. Assist with review of 10Q & 10K SEC schedules from Operating Units to

verify Balance Sheet & P/L account activity.

. Maintain & update the Chart of Accounts.

. Performed document reviews and walkthroughs for SOX testing.

CENTENNIAL COMMUNICATIONS (Division of AT&T), Wall, NJ

1999-2010

Senior Analyst (2008 - 2010)

. Lead contact between billing vendor, Billing, Puerto Rico, and US

Wireless Finance Departments to further automate the sales journal

ultimately removing all manual processes except for verification.

Project provided easy access to over 30 reports, reducing daily

workload for three departments.

. Worked with billing vendor to revise reports to provide account level

detail supporting all revenue streams.

. Created store level P&L for Puerto Rico operations.

. Fulfilled the monthly revenue close process, journal entries, and

revenue-related analysis.

. Investigated variances in revenue, usage, churn, migration, etc.

. Created ad-hoc reports and meaningful financial analysis including

ARPU, rate plan, usage, and credit class analyses to provide support

to executive/management team.

. Handled special projects as assigned

Financial Systems Analyst (2007)

. Provided end-user support (including data queries) for Lawson and

Hyperion applications.

. Maintained and administered Hyperion Enterprise system, Retrieve

Reports and Lawson financials.

Corporate Accountant (2006)

. Introduced a streamlined process to the Commissions report reducing

the preparation time by approximately 65%.

. Prepared monthly board package.

. Maintained monthly Revenue Reports for Accounting Department.

. Handled journal entries to Lawson General Ledger.

Early Positions (06/99-12/05): Revenue Associate, Senior Wireless Billing

Analyst, Bill Approval Associate

PREVIOUS WORK HISTORY:

PRUDENTIAL INSURANCE COMPANY, Cranbury, NJ

1998

Customer Service Representative - Health Insurance

Handle subscriber questions regarding eligibility, co-insurance, and

coordination of benefits.

CENTRASTATES MEDICAL CENTER, Freehold, NJ 1994

- 1997

Medical Laboratory Technician, Microbiology Lab

Prepared specimens to ID microbial pathogens and provide antibiotic

sensitivities.

AMERICAN INTERNATIONAL GROUP, New York, NY 1977

- 1987

Insurance Underwriter for Directors and Officers/Pension Trust Liability

Solicit new/renewal submissions from brokers, determine terms and

conditions, bind coverage.

EDUCATION

Cousre work:

Database Concepts (Relational database design, implementation, and

administration. Design concepts include entity relationship modeling and

normalization.)

Degrees:

MBA-Accounting

Monmouth University, Long Branch, NJ (May, 2010) GPA 3.54

Bachelor of Science, Finance, Minor in IT,

Monmouth University, Long Branch, NJ GPA 3.56, cum laude

Associates, Medical Lab Technology

Brookdale Community College, Lincroft, NJ

Contact this candidate