Robert G. Campbell, AU, CPCU

614-***-**** adgg7s@r.postjobfree.com Columbus, OH LinkedIn www.linkedin.com/in/robert-campbell-picktown

Director / Senior Program Manager

Versatile, strategic Director with 20+ years of achievement aligning technology innovation with business needs to lead high-value initiatives, projects, and programs. Expert abilities span multiple functions including data warehousing, application development, business intelligence, and vendor management. Natural, collaborative leader able to build and develop talented teams, overcome complex obstacles, and implement solutions to real-world problems. Key skills:

Analytics CRM Process Improvements Program & Project Management Software Development Lifecycles

Data Modeling Requirements Analysis Governance Cross-Functional Team Leadership Coaching/Mentoring

Financial Acumen Strategic Partnerships Capability/Capacity Planning Forecasting Prioritization Training

SDLC Vendor Management

Recent Impact

Implementation of processes for project management, business and issue analysis and quality assurance testing.

Reduction of production issues enabling transition to project and enhancement work

Created and distributed a comprehensive SWOT analysis that determined current state and future needs, pain points, and industry trends and helped reveal opportunities for future investments.

Created and distributed a comprehensive SWOT analysis that determined current state and future needs, pain points, and industry trends and helped reveal opportunities for future investments.

Spearheaded Information Management and Analytics annual planning by teaming with partners, developing business cases, and evaluating 100+ requests to ultimately submit 68 requests totaling $27M.

Completed or closed 80% of existing and new work and slashed the work request lead time from 104 to 29 days after securing funding for a dedicated IT line providing development and support for Google Analytics tagging activities.

Generated $2.6M in savings by transitioning marketing prospecting and third-party data services to a new vendor, implementing processes with the vendor, and adding demographic data sources.

Professional Experience

SafeAuto Insurance Company

Data & Finance IT Run Manager - 2020

Managed team of 10 developers, business and quality analysts maintaining production support for the data warehouse and finance applications as well as development of enhancements and projects.

Assumed leadership of team while replacing senior members and crafted high performing team.

oCross trained team to eliminate single points of failure.

oDesigned and implemented individual training plains to enable broader coverage of owned assets.

Significantly reduced production issues to transition team to more project work.

Implemented team and project management processes increasing productivity and quality of work.

Successfully transitioned team from office to work from home environment due to pandemic

Single point of contact for Finance/Accounting to IT department

Apex Systems / Express

Program Manager / Contractor - 2019

Managed large programs to transform marketing technology assets to drive sales and revenue. Developed and implemented project and communication plans providing clarity for teams and transparency for stakeholders. Implemented overall project documentation practices for reporting, requirements and plans.

Crafted detailed plans for projects totaling $4M encompassing movement of data stores to the cloud and development of technology assets to support marketing and data science partners.

oProjects supporting marketing entailed approximately 60 new development and enhancement efforts.

oMajor project involved movement of customer marketing database to the cloud.

Managed internal and offshore resources and implemented processes to utilize time zone differences for increased efficiency and productivity.

Led regular cadence of daily and weekly team meetings as well as weekly stakeholder meetings.

Nationwide Mutual Insurance Company

Director/Senior Consultant, Customer Insights & Analytics 2006-2019

Managed and mentored a talented team of business analysts ensuring strong performance and accuracy of work products. Developed processes and documentation used by business analysts in requirements gathering phases and interfaced between business and IT teams. Designed and implemented project requirements documentation templates encompassing scope, requirements, process flows, and testing criteria.

Won Nationwide’s Outstanding Contributor Award for Technology Projects by spearheading development and execution of business and technical processes to promote the delivery of marketing campaigns to the agent website portal.

Led an intake process project to streamline the prioritization and assignment of work for business analysts.

Created a new process to improve project management by enabling status tracking and cataloging of products including requirements, context diagrams, and process flows.

Directed a $5M, multi-year initiative to design and build a customer data warehouse across multiple business units and operational data systems.

oMatured the customer data warehouse by developing new processes, implementing 100 enhancements per year, leading data integrations, and ensuring the training of 100+ associates.

oDirected data sourcing, mapping and ETL processes for data warehouse integration across business divisions.

Project Manager/Consultant, Customer Insights & Analytics 2001-2006

Quarterbacked creation of the first customer-centric database/data warehouse and Teradata CRM application.

Delivered $2M+ in annual revenue after marketing campaigns adopted the database and applications.

Established best practices and processes for requirements gathering, database enhancements, and QA.

Saved $250K/year by delivering application support and new user training.

Additional: Marketing/Business Strategy Consultant and Business Process & Support Project Manager at Nationwide.

Education & Training

BS in Business Administration, The Ohio State University

Chartered Property Casualty Underwriting (CPCU), American Institute for Property & Casualty Underwriters

Contact this candidate