Tim Oliver
Reporting Team Supervisor at pep, LLC.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
pep, LLC.
-
United States
-
Advertising Services
-
200 - 300 Employee
-
Reporting Team Supervisor
-
Feb 2019 - Present
Cincinnati, Ohio -Supervise database administrators and report writers (quarterly reviews, annual reviews, time sheet and time off administration, coaching, goal setting, etc.) -Coordinate training of new hires and continuous training for team -Train on pep's business logic and how it relates to our database and existing reports -Review all incoming requests, build specifications, and prioritize, and allocate resources for each project as well as leading testing, roll out and initial team training for… Show more -Supervise database administrators and report writers (quarterly reviews, annual reviews, time sheet and time off administration, coaching, goal setting, etc.) -Coordinate training of new hires and continuous training for team -Train on pep's business logic and how it relates to our database and existing reports -Review all incoming requests, build specifications, and prioritize, and allocate resources for each project as well as leading testing, roll out and initial team training for end users -Research new analytics/data tools and implementation (Telerik reporting, MS Power BI, MS Flow, etc.) -Meet regularly with senior leadership to understand current needs
-
-
Operations Systems Project Lead
-
Jan 2015 - Feb 2019
Cincinnati Area Responsibilities: 1. Responsible for project managing all operations systems initiatives on-time, on-budget, and on-spec a. Scope out new features and fixes via detailed requirements b. Prioritize all system bugs and enhancements (both reports and interface) c. Maintain overall development timeline including due dates and stakeholders 2. Primary contact in the IT Department for key stakeholders within the company a. Main liaison between business owners and IT… Show more Responsibilities: 1. Responsible for project managing all operations systems initiatives on-time, on-budget, and on-spec a. Scope out new features and fixes via detailed requirements b. Prioritize all system bugs and enhancements (both reports and interface) c. Maintain overall development timeline including due dates and stakeholders 2. Primary contact in the IT Department for key stakeholders within the company a. Main liaison between business owners and IT Manager and internal and external development teams b. Attend Leadership Meetings bi-weekly c. Attend Senior Leadership Meetings monthly i. Create monthly IT Dashboard Report for Senior Leadership 3. Development of business intelligence tools including Power BI a.Meet with key leaders in the company to develop dashboards which highlight key performance indices b. Keep up to date on new technologies c. Manage business analysts to create useful and accurate business intelligence tools 4. Lead Testing and Quality Assurance (TQA) Committee a. Lead all system QA testing and approve production pushes b. Work with Training Committee and Training Lead to roll out major system updates / processes and communicate minor system updates / processes via PepSpace 5. Helpdesk ticket management a. Project manage the helpdesk ensuring all tickets are resolved in a timely manner. 6. Microsoft Suite Development and Training a. Train employees on Microsoft tools such as Excel, Outlook, PowerPoint b. Develop time saving reports in excel for Senior Leaders c. Develop VBA enabled tools in Outlook and Excel
-
-
Account Executive and IT Account Executive
-
Jun 2014 - Jan 2015
Cincinnati Area I currently have a dual role splitting my time between two Account Executive roles. One of the roles is in the client services portion of our business and the other focusses on advancing our internal technology needs. Client Services Responsibilities: •Manage marketing promotions from conception to completion for your assigned business unit. •Collaborate with client to assemble all necessary promotion specifications; communicate requirements to respective supplier… Show more I currently have a dual role splitting my time between two Account Executive roles. One of the roles is in the client services portion of our business and the other focusses on advancing our internal technology needs. Client Services Responsibilities: •Manage marketing promotions from conception to completion for your assigned business unit. •Collaborate with client to assemble all necessary promotion specifications; communicate requirements to respective supplier teams. •Effectively bid out work to suppliers. •Create and manage production timeline •Collaborate with client and suppliers to ensure that program requirements meet legal and policy guidelines/requirements. •In conjunction with supplier partners, provide client with recommendations for cost and/or time efficiencies. •Communicate with relevant suppliers to ensure that promotions are executed to completion and adequate proof of performance is provided. •Manage creation of all purchase orders and corresponding invoices. •Capture and track cost savings. •Maintain strong metrics. I am responsible for on-time file closure, on-time & on-budget and audit scores. •Conduct regular status meetings with clients, vendors and internal resources to ensure a flawless execution for each promotion. IT Responsibilities: o Testing - Approving/coordinating production pushes o Training (heavy) o Leading IT QA Committee o Specs/requirements - Helping to determine priorities and timing; Meetings o Weekly status meetings with IT/TRG o Email communication -Communicating timing to team -Rolling out new enhancements in PC o Help with HelpDesk tickets -General PepSpace, PepConnect, Outlook, and Microsoft questions (via email, IM, phone, meeting) o Developing Outlook processes (templates, macros, etc.) o Offline report building (team-specific Excel and PowerPoint requests) o Single touch point between IT/PepConnect, PepSpace Committee, Training Committee, IT/QA Committee, MyPurchases, and Client Services Team
-
-
Account Coordinator
-
Apr 2013 - Jun 2014
Cincinnati, Ohio I work on the In-Store and ASM team for the P&G team at Pep Promotions. My duties include: -Support an assigned team/business unit of Account Executives, Account Specialists, and Account Supervisors. -Compile vendor estimates and update cost elements in PEPConnect. -Generate program timelines. -Attend kick off / alignment meeting calls and provide recaps. -Assist team on large scale initiatives. -Act as a back up when the main contact for a program is out of the… Show more I work on the In-Store and ASM team for the P&G team at Pep Promotions. My duties include: -Support an assigned team/business unit of Account Executives, Account Specialists, and Account Supervisors. -Compile vendor estimates and update cost elements in PEPConnect. -Generate program timelines. -Attend kick off / alignment meeting calls and provide recaps. -Assist team on large scale initiatives. -Act as a back up when the main contact for a program is out of the office. -Assist with vendor POs and billing as needed. -Ensure all program information is up to date in PEPConnect. -Learn existing processes/procedures. -Assist in the establishment and development of new processes/procedures. -Communicate with clients and vendors, as directed.
-
-
-
-
Part Time Marketing Coordinator
-
Nov 2012 - Apr 2013
Marketing planning and execution for industry specific campaigns and general business development strategy consulting
-
-
-
BHDP Architecture
-
United States
-
Architecture and Planning
-
100 - 200 Employee
-
Marketing COOP
-
Mar 2012 - Aug 2012
Cincinnati, Ohio Marketing Document Creation -Created responses to requests for qualifications and proposals for potential jobs. Created both Form 330 Higher Education format and Standard format proposals. -Created presentations for potential clients. Research -Researched our current clients to determine different metrics that indicate trends in our revenue streams from clients in similar industries. -Self motivated projects where I created new processes and tools that increased… Show more Marketing Document Creation -Created responses to requests for qualifications and proposals for potential jobs. Created both Form 330 Higher Education format and Standard format proposals. -Created presentations for potential clients. Research -Researched our current clients to determine different metrics that indicate trends in our revenue streams from clients in similar industries. -Self motivated projects where I created new processes and tools that increased efficiency. -Researched information about potential projects and clients. Database Maintenance -Updated online databases for clients, projects, employees, pictures, etc. -Standardized marketing language on proposals, project sheets, and resumes. -Helped reorganize the marketing drive. Show less
-
-
-
G
-
United States
-
Accounting
-
1 - 100 Employee
-
Marketing Coop
-
Sep 2011 - Dec 2011
Cincinnati, Ohio Area Research: • Conduct research of small to mid-sized companies in order to generate qualified business leads across all lines of service. • Segment new and/or existing prospects by industry for utilization in future marketing campaigns. • Assist marketing department in compiling newspaper, magazine, and journal articles as well as any other relevant sources of information to be incorporated into company blog and newsletter. Outreach: • Prepare direct marketing campaigns… Show more Research: • Conduct research of small to mid-sized companies in order to generate qualified business leads across all lines of service. • Segment new and/or existing prospects by industry for utilization in future marketing campaigns. • Assist marketing department in compiling newspaper, magazine, and journal articles as well as any other relevant sources of information to be incorporated into company blog and newsletter. Outreach: • Prepare direct marketing campaigns targeting core client industries. • Conduct calls to core client industries verifying key data. • Began development of social media marketing campaign Data Entry: • Maintain company client relationship management database (Sugar CRM): verify that accurate business activity, contact, and mailing information is captured in company records. • Schedule tasks for Inside Sales Representatives in Sugar CRM. • Assist in the preparation of email marketing target lists with Sugar CRM. Show less
-
-
-
SHP
-
United States
-
Architecture and Planning
-
100 - 200 Employee
-
Finance Coop
-
Jun 2009 - Dec 2010
Norwood, Ohio - Answered phone calls and directed clients and consultants to appropriate project managers. - Led the research needed to determine whether our branch should purchase a fleet of company cars. - Helped with project planning and the tracking of costs related to contracts on buildings and other projects - Worked closely with the head of the finance department on a strengths finding mission that analyzed the fundamental strengths of the company’s employees. - Created an electronic… Show more - Answered phone calls and directed clients and consultants to appropriate project managers. - Led the research needed to determine whether our branch should purchase a fleet of company cars. - Helped with project planning and the tracking of costs related to contracts on buildings and other projects - Worked closely with the head of the finance department on a strengths finding mission that analyzed the fundamental strengths of the company’s employees. - Created an electronic tracking and storage system for the architectural and consultant contracts of over 35 years. Show less
-
-
-
City of Mason, Ohio
-
United States
-
Government Administration
-
100 - 200 Employee
-
Finance Department Intern
-
Apr 2007 - Sep 2007
Mason, Ohio - Provided basic support for the finance department; including filing financial documents, mailing items as needed, and making bank deposits for the city. - Spearheaded a change in the records retention program (process for tracking records) for the entire city including a renovating the outdated electronic tracking system and reorganizing the boxed paper documents - Worked closely with the heads of the finance department relaying information between them and providing support when needed
-
-
Education
-
University of Cincinnati
Marketing -
Mason High School
High School