Stephen Paul Mazziotta

acoztl@r.postjobfree.com

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

Andover, New Jersey 07821

Cell: 973-***-****

PROFESSIONAL SUMMARY:

Accomplished project manager and analyst with a proven ability to develop and implement advanced strategies

to support business initiatives. Have led key campaigns that dramatically improved quality and efficiency of data

collection by over 300%. Recognized as an expert in utilizing Microsoft Excel to assist in formulating

management decisions. Proactive, results driven, technically oriented professional with rich, progressive

experience in Microsoft Excel. Respected leader, able to build highly motivated teams focused on achieving

department goals.

CORE STRENGTHS AND SKILLS:

Pharmaceutical Knowledge Operations Analysis and Management

Market Research Human Resource Management

Oracle Business Intelligence Discoverer Query Development Process Integration/Development

Microsoft Office - Word/Excel/PowerPoint Technology Integration

Extensive experience with formulas and functions in Excel Process Analysis

Excel Trainer Client Focused Business Strategies

Intermediate VBA knowledge (Visual Basic for Applications) Direct Client Contact Support

EXPERIENCE:

Prudential Financial, Inc. Dec 2014 – Mar 2015

Vendor Governance Analyst

Developed an annual vendor governance planning utility, complete with a custom user control panel and

adjustable weighting system

Coordinated an Annual Risk assessment for all high risk Human Resources vendors

Resolved long term issues with the annual Risk Assessment Scorecard for Senior Management

Maintain accurate Inventory of current direct and sub-vendors

Review due diligence materials for completeness and quality

Store due diligence materials in central repository

Avis Budget Group July 2012 – April 2014

HR Analyst

Built ad hoc reporting tools with the use of Microsoft Excel and Oracle Disco Plus as required.

Designed an audit process for Talent Acquisitions vendor which garnered over $600,000 savings for the

company.

Developed a scorecard for L&D which calculated ROI and turnover for the ancillary sales training program

Constructed many databases in Excel which were systematically tied into numerous forecasts and

projections.

Mapped a North American organizational hierarchy for a new ATS (Applicant Tracking System) so that it

could be linked to three independent HR/Finance databases.

Streamlined many core HR functional reports, distributed to nearly two hundred folks across North

America on a weekly basis.

Automated several key HR processes to improve efficiency

Improved reporting process to encompass all business operations.

Formulated business strategies and advised on strategic decisions to improve business performance.

Assembled statistical driven reports in order to track project and training program progress.

Devised and utilized Pivot Tables and Charts to work with a wide array of rapidly changing information to

analyze quantitative market data.

Manipulated data with extreme scrutiny through the use of formulas and functions with Microsoft Excel.

TFT October 2011 – July 2012

Data Analyst

Created a streamlined database of all company contacts where queries can be easily run.

Prepared reports to define, design and display information needed for internal/external communications.

Developed variable sales projections for various events in order to influence management decisions.

Perform analytical tasks through Microsoft Excel and Access as required.

Maintenance of the global contact database.

Pinsonault Associates June 2008 – September 2011

Project Manager, Formulary

Supervisory experience coordinating the efforts of up to fifteen individuals.

Responsible for the day-to-day operational flow of the Formulary/Market Research Department.

Resolved potential issues through the use of ad hoc tools and analysis.

Designed and implemented business workflows for the Formulary Team.

Supported Customer Support and Sales by verifying data and translating results into a cohesive package

for direct contact with client.

Streamlined business process to yield a 300% increase in speed of data collection.

Trained 5+ employees to be “Power Users” of Microsoft Excel (VLOOKUP, IF, etc.).

Collected and analyzed complex pharmaceutical data in order to develop and maintain reporting tools.

Initiated Pinsonault’s first Quality Control system in an effort to monitor data accuracy.

Managed projects through close interaction and communications with Formulary Team to provide reports

and consultation to upper management.

Formed the framework and logic for Pinsonault’s interactive web application with the use of concentrated

analytical and statistical work through the use of Microsoft Excel.

Managed the hiring of new employees, focusing on candidates with strong Excel, VBA or general

programming skills.

Identified new product development opportunities based on the needs of the current and future client

base.

Adjusted corporate process according to competitive landscape and client requirements.

Generated a multitude of small VBA applications to automate essential tasks.

Franklin Pediatrics December 1999 – November 2006

Billing Coordinator

Served as the liaison between health insurance companies and clients for account reconciliation.

Analyzed collection reports and reported discrepancies.

Managed and prepared bills for a large number of patients.

Researched new medical procedures.

Consulted with insurance reps on procedures to satisfy claims.

Developed spreadsheet tools to automate AR processes.

Hitachi Medical Corporation Summer 2002

Marketing Intern

Created various customer databases for direct mail campaigns.

Edited and formatted web pages for corporate website.

Coordinated distribution of marketing materials.

EDUCATION:

Fairfield University Fairfield, Connecticut - May 2003

Bachelor of Science: Major in Corporate Finance

Contact this candidate