John Mazzaglia

Phone: 678-***-**** **** Gadolinite Trail, Cumming, GA 30040 adn8la@r.postjobfree.com

Core Competencies

** *****’ experience in FP&A Revenue & Expense FP&A experience

Present Monthly Results with Finance and Sales VPs Team Leadership & Mentoring Sales & Account Management Contractual Negotiations

Have significant experience in Billing, Commissions, and IT Support Corporate & Financial Operations

PROFESSIONAL EXPERIENCE

ACCOMPLISHMENTS

At MarketSource, identified manual keying errors made which resulted in significantly overpaying on commissions

While at MCI / Verizon created my own revenue ($10B in annual rev) and expense budget/FC ($19B annually for all segs)/ model via XLS with over 55 products to include customer specific details.

After the MCI / Worldcom revenue fraud, was involved in researching to identify fraudulent entries by running numerous queries working with the IT Group; was able to identify over $1Billion in fraudulent entries

A key member of the AR2000 Implementation System, which was an in-house billing platform to bill other Wholesale customers. Worked closely with IT, Marketing, Legal, Sales VPs, and Finance VPs to bring this to fruition,

1 of 5 Finance employees at MCI who won the Presidents Club award; there were 118 Sales reps on this award trip

WORK HISTORY

After being laid off by MCI/Verizon, I did consulting work as it allowed me the flexibility of caring for my Mother for about 1 year time frame (in NY), who was sick during this time.

Kellen Company, Atlanta, GA. Senior Financial Analyst (4/6/2020 – 1/2021)

oFinancial Planning & Analysis, reporting directly to the Finance VP, handling all Revenue and Expense submissions

oDesign and develop Excel models, including the use of V-Lookups and pivot tables.

oDevelop and implement key performance indicators (KPI) and dashboard applications.

oReconcile Bank Statements to the Kellen numbers and describe reasons for any dislinks

Atlanta Casework Systems, Cumming, GA (May2019 – Mar2020)

MarketSource, Alpharetta, GA. Senior Financial Analyst, Consultant (May2018 to Jan2019; reference can be provided by the Finance Controller)

oDirect Report to the Finance Controller

oProject a result of numerous systems’ ability to communicate with each other while maintaining the correct Recruiter being paid correct commissions

oLed a project related to Commissions using Excel, PeopleSoft, and internal systems to validate Commissions paid back 125 weeks, or 2.2 million rows of Excel data in 54 columns. Work independently with little input from Management.

oFully understand and implement a new Commissions schedule and role that out to the field

oWork closely with and reporting directly to the Finance Controller and presented in Weekly Meetings

Envision Health Care - Started my own online business selling Health Products / Supplements - 2017

In NY taking care of my sick Mom per the above message Feb 2016 – Feb 2017)

Calero Software, Atlanta, GA. Financial Planning & Analysis, Consultant (Temp Nov 2015 – Dec 2015)

oProvided oversight of all revenue planning and analysis processes for Revenue and Expenses.

oAccountable for monthly financial forecasting to allow for informed decision making and accurate external revenue and expense budgetary guidance

oResponsible to complete all Ad-Hoc requests in a thorough and timely manner per Management request.

LexisNexis, Alpharetta, GA. Financial Planning & Analysis, Consultant (Temp Apr 2015 – Jun 2015)

oProvided oversight of all revenue planning and analysis processes. Accountable for monthly financial forecasting to allow for informed decision making and accurate external revenue and budgetary guidance

oFocus on Risk-Management Business Division

oComplete General Accounting tasks

MCI / VERIZON BUSINESS (Verizon acquired MCI in 2005) (1991 - 2014)

MCI / VERIZON BUSINESS (Verizon acquired MCI in 2005) (1991 - 2014)

MCI / Verizon Business – Alpharetta, GA

Financial Analyst 3, Headcount Reporting (2013 - 2014)

Partnered with HR to obtain weekly headcount report in order to classify employees by 45 categories.

Consulted with Product Sales Group to obtain Sales Revenue for a $19B organization.

Developed and completed reporting with focus on rep productivity by region and job type.

Developed my own model via Excel to complete weekly reporting

MCI / Verizon Business – Alpharetta, GA

Financial Analyst 3, Expense Planning & Analysis (2007 - 2013)

Developed expense reporting model to create annual budget of $17B.

Created personalized budgeting and forecasting models via Excel and SAP/CPM.

Prepared 55 SG&A budgets at the Director level and COSP by customer expectations.

Analyzed COSP linkage; worked closely with CapEx group; tracked CapEx detail and status.

Lead weekly meetings with the Sales Teams to discuss expense results and expectations.

MCI / Verizon Business – Alpharetta, GA

Financial Analyst 2, Revenue Planning & Analysis (2003 - 2007)

Collaborated with Sales group to obtain reporting data to create budget for a $10B organization.

Created personalized budgeting and forecasting models via Excel and SAP/CPM.

Conferred with VP’s, Sales, and Marketing to develop revenue explanations at product level.

Input all regions into the system via Hyperion, an impact of $19B annually.

Ran Essbase daily to monitor erroneous accounting entries and mitigate costly mishaps.

MCI WORLDCOM – Alpharetta, GA

Financial Restructuring Analyst, Clinton, MS (2002 - 2003)

Recruited to join WorldCom headquarters team after major WorldCom accounting fraud. Successfully identified $1.2B in incorrect accounting entries.

Partnered closely with temporary CFO, Finance VP, and Auditors to approve and post correcting entries.

Responsible for the performance and management of all talent acquisition initiatives - placing heavy emphasis on staff and employee training, recruitment, and leadership.

Worked on SAP to identify and clean up incorrect and fraudulent accounting entries.

Collaborated with Accounting Managers to obtain backup support and determine validity of accounting entries.

ADDITIONAL ROLES (1991 - 2002)

MCI WORLDCOM, Alpharetta, GA - Manager, Wholesale Billing & Pricing

MCI WORLDCOM, Atlanta, GA - Supervisor, Commissions Support

MCI TELECOM, Alpharetta, GA Supervisor - Billing Contract Administration, Commissions Support

MCI TELECOM, Rye Brook, NY - Entry Level to Manager, Accounts Receivable

EDUCATION

PACE UNIVERSITY – White Plains, NY

Bachelor of Science: Public Accounting

SKILLS

Microsoft Office (Word, Advanced Excel, Complex Financial Modeling, PowerPoint, Access)

NetSuite Products, SAP, Oracle, Hyperion, Essbase, ADP, PeopleSoft, SmartView, and CPM experience

Contact this candidate