Shawn M. Cerezo
235 Calhoun School Rd
New Bethlehem, PA
16242
--
CAREER SUMMARY
Experienced Business Analyst, Project Manager and Certified Internal Auditor with twenty-plus years of diversified
and increasingly responsible positions within the retail and service based industries. Background includes customer
service, budgeting, staff development, marketing, planning, training, business analytics and project management.
Excellent leadership abilities and technical knowledge. Proven record of accomplishment in strategic planning by
using critical thinking to create innovative new ideas while focusing on entity level goals.
PROFESSIONAL EXPERIENCE
Guardian Protection Services, Warrendale, Pennsylvania-
Guardian Protection Services is the world's largest privately held security company. Guardian sells, installs and
monitors residential and commercial security systems as well as sells and installs structured wiring and audio/video
solutions in new home construction applications.
INFORMATION TECHNOLOGY SYSTEMS ANALYST (Business Intelligence-
Primary responsibilities included acting as a liaison between IT Developers and Business Users (Executive Staff),
project management and technology solutions analysis.
Managed a multi-project portfolio spanning several business units and IT functional areas.
Routinely translated business requirements into basic code that developers could build upon to complete
projects.
Acted as key subject matter expert in the design and development of Guardian’s data warehouse.
Analyzed, documented and assessed several key operating procedures and initiated business process
changes that resulted in increased efficiency.
Managed all BI projects from start to finish, including the daily activities of the BI staff and the design and
development of all reporting and supporting ETL.
INTERNAL AUDITOR/OPERATIONS ANALYST-
Responsible for creating, implementing and operating the company’s new Internal Audit initiative from the ground up.
Also responsible for analyzing operations performance, developing new operational and accounting controls,
developing operational and financial reports, providing key training and coordinating major acquisition activities.
Developed self-scoring audit program and audit results analysis database.
Created systems to manage and analyze corporate purchasing cards, cell phones and expense reports.
Devised comprehensive payroll system to transition over 300 installers from manual timekeeping to an
automated process that integrated with the company’s job costing system, resulted in reduced labor costs,
and increased efficiency.
University of Phoenix, Phoenix, Arizona-
The University of Phoenix is the nation’s largest private, adult oriented college. UOP offers both traditional on-campus
classes and online classes. UOP offers degree programs in a variety of fields and awards Bachelor’s, Master’s and
Doctorate Degrees.
ONLINE FACULTY-
Responsible for instructing graduate level on-line classes for 10-20 students located virtually anywhere in the world.
Create course plans and develop materials in accordance with University prescribed parameters that ensure
compliance with accreditation requirements.
RENT-WAY INC., Erie, Pennsylvania-
One of the largest rental-purchase companies with nearly 800 locations specializing in the rental of durable
household goods including furniture, appliances and electronics. Annual revenues in excess of $500 million.
SUPERVISOR, FIELD AUDITS-
Responsible for managing the internal audit staff, assessing and modifying the field audit program as necessary and
reporting audit results and recommendations to senior management.
Shifted audit tracking, scheduling, budgeting and reporting process from a series of manually compiled
spreadsheets to an integrated database system, which increased both accuracy and productivity.
Assessed fleet department needs and developed an integrated database to maintain, report on, and track
fleet of 1,700 vehicles, as well as compute projections for vehicle needs resulting in fleet controls not
previously possible.
Educated field employees, from delivery drivers to Divisional Vice-Presidents, through individual training,
conference calls, training presentations and bi-monthly articles in the company newsletter.
Managed department payroll and operating expenses within annual budget of $550,000.
INTERNAL AUDITOR-
Responsible for conducting field audits and analysis of transactional level details of up to 1,050 retail locations.
Generated unprecedented levels of reporting through the creation of a data warehouse to compile, analyze
and report on transactional data from each business unit based on an assessment of needs and input from
senior management.
Developed and implemented pilot documentation program for Sarbanes-Oxley section 404 compliance that
became the model for the company’s enterprise-wide Sarbanes-Oxley compliance project.
Conducted study of asset life cycles that resulted in modified filing of personal property taxes in several
states with potential tax savings in excess of $200,000 annually.
STORE MANAGER-
Responsible for total operation of a retail rent-to-own outlet including marketing, sales, employee development,
budgeting, collections and customer relations.
Tripled computer sales at Bradenton/Sarasota locations by developing a combined sales/service/training
program to maximize employee involvement and customer interest.
Participated in development of enterprise-wide computer sales/service initiative based on
Bradenton/Sarasota model and appeared in training video.
EDUCATION
UNIVERSITY OF PITTSBURGH, Joseph M. Katz Graduate School of Business
Master of Business Analysis Certificate 3/2015
Master of Project Management Certificate 10/2014
UNIVERSITY OF PHOENIX, Pittsburgh, Pennsylvania / Tampa, Florida
Master of Business Administration, Conferred 12/2004
Bachelor of Science in Business Management , Conferred 9/2001
CALIFORNIA UNIVERSITY OF PENNSYLVANIA, California, Pennsylvania
Completed coursework in Computer Science curriculum-.
Computer Skills: SQL, Microsoft BI Solutions (SSRS, SSIS, SSAS, PowerPivot, Power View), Crystal Reports,
Cognos, Visual Studio, Microsoft Project, Visio, Planview, Oracle/JD Edwards, advanced proficiency in MS Office
Products and general computer hardware/software/networking.
MILITARY EXPERIENCE
UNITED STATES ARMY RESERVE
Personnel Administration Specialist E-4, Unit Retention NCO
PROFESSIONAL CERTIFICATIONS AND MEMBERSHIPS
Certified Internal Auditor (CIA)
Institute of Internal Auditors
-
