Project Manager Analyst
Resume:
Stephen Paul Mazziotta
**************@*****.***
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