Manager Project Management

Ayoade O. Ojikutu

*** ******* ***** • Coatesville, PA 19320

********@*****.*** • C: 781-***-**** • H: 610-***-****

Business Intelligence/Data Analyst

Highly skilled and experienced Business Intelligence/Data Management Analyst with a record of accomplishment streamlining processes and improving results in data management enterprises. Exceptional leadership skills leveraged in commercial and military environments. Intuitive problem solver with the demonstrated ability to dramatically improve operational and organizational performance. Quick study with advanced technical expertise and proven success rapidly assimilating new skills. Delivers efficient and productive improvements to managing multiple data sources as well as combining these data sources to achieve complete data visibility and awareness. Knowledgeable in some ETL process for data scrubbing and transform using SSIS. Proficient in various SQL programming, report development, Microsoft VBA for Excel and Access.

Highlights of expertise:

SQL Programmer • Microsoft VBA • Data Analyst • Business Intelligence Analysis • Database Management • Report Designing • Business Analysis • Project Management • Change Management • Team Building • Process & Workflow Improvement • Design Engineering • Strategic Planning • Organizational Development • Client Relationship Management • RFPs • SOWs • SOP Development

Professional Experience

Wavsys LLC., Remote 11/2013 – 01/2016

Project Controls Manager

Lead the reporting and data analysis function and activities across multiple projects in multiple markets nationwide. Create, build, and distribute many key reports used both internal and external to the organization. Additionally, design and build custom/ad-hoc reports per request. Worked in a mostly independent capacity in the performance of these duties.

Key Contributions:

•Helped in the transference, and integration of an Excel based report into an online SharePoint, front-end, war room database, for reporting/tracking system outages and repair scheduling.

•Retrieved data daily from the Oracle financial data warehouse using SQL and further processing the data using advance Excel and VBA skills.

•Maintain PO and invoice report/ financial trackers daily. Tracked millions of dollars from various war room related activities, using data from multiple sources.

•Provided daily reports and dashboard to the company’s VP of operations, for his daily and weekly progress reports and meetings.

•Supported the VP of Operations by providing daily management reports on actuals vs. forecast expenditures, variance analysis on multiple projects.

•Incorporated data from multiple sources and multiple formats, on a daily basis, into creating a single data report and/or dashboard using my advanced Excel programming skills.

•Tracked and reported on financial activities of over 1000 projects in excess of $9 million a year.

AT&T, King of Prussia PA 03/2012 – 10/2013

Financial Analyst (contractor)

As part of the eastern PA market finance team, I designed, build, and distribute key reports and presentation using SQL and Microsoft VBA. Produced and distributed quarterly forecasts for approximately 3,000 projects, monthly variance analysis and annual Unit Cost Analysis reports. Created and distributed daily reports showing financial status of on-going projects. Built senior management reports and ad hoc reports; worked with civil vendor to manage invoicing/PO issues; acted as a liaison between PMs and vendors; refined and improved quarterly forecast submission.

Key Contributions:

•Worked to improve work flow by streamlining processes and procedures using available software tools which dramatically reduced required worktime for various reporting tasks and functions.

•Help in preparing and updating quarterly forecast and projections multiple projects and also provided summary and detailed level reporting of actuals and forecasted project expenditures.

•Provide summary and detailed level reporting of actuals and forecast for headcount and dollars.

•Help build a tool used to facilitate seamless upload of bulk data into the AT&T PO database.

•Retrieved data daily from the Oracle financial data warehouse using SQL and further processing the data using advance Excel and VBA skills.

•Perform coordination of budget tracking along with internal business/project managers.

•Incorporated data from multiple sources and multiple formats into creating a single data report and/or dashboard using my advanced Excel programming skills.

•Collaborated extensively with project managers and vendor point of contacts to resolve issues and ensure projects are being managed in-line with all budget, and milestone, constraints.

Tracked and reported on financial activities of over 3000 projects in excess of $30 million a year.

T-Mobile, Parsippany NJ 03/2009 – 11/2011

Project Controls Manager (contractor)

Lead reporting function as a member of the national reporting team using SQL and Microsoft VBA. Used Microsoft ETL tool, SSIS, to load/update data into in the development database. Create, build, and distribute key reports and presentation materials used at all levels of the organization, from executives to regional directors to project managers and on through to field technicians. Additionally build custom reports as requested for specialized needs of various departments or regions.

Key Contributions:

•Greatly streamlined processes and reduced workload, creating tools and procedures that dramatically reduced time required for various reporting tasks from a full day to minutes.

•Promptly promoted from position supporting NE region Project Control Manager to the national PMO/EDO (Project Management Organization/Engineering Development Organization) Project Control Management team as a result of exceptional job performance.

•Retrieved data daily from the MS SQL server, and Reporting services site, using SQL and further processing the data using advance Excel and VBA skills.

•Incorporated data from multiple sources and multiple formats into creating a single data report and/or dashboard using my advanced Excel programming skills.

•Participated in scheduling and facilitating a series of weekly status meetings with various cross-functional teams including agenda, minutes and slide deck preparation.

•Developed project PowerPoint slide decks for internal presentations

General Dynamics Wireless Service, Various Locations 07/2000 – 10/2008

Leading provider of turnkey wireless network solutions for commercial wireless carriers and public safety agencies. Advanced rapidly through increasingly complex positions, providing exceptional individual accomplishments and leadership in Systems Engineering, Optimization Engineering, and critical Project Management roles.

Database Manager, Scheduling Coordinator, Project Controls Lead, Passaic, NJ (2006 -08)

War Room Manager, Passaic, NJ (2007-08)

Improved project execution by redesigning overall market database (Database Manager). Senior advisor to Project Management team, providing exemplary project management in the areas of cost, resource scheduling, quality, risk management, contract administration, and HR management (Project Controls Manager). Directed the efforts of more than 30 construction supervisors, site technicians, and contractors engaged in construction of wireless towers at more than 287 sites in New Jersey and New York. Providing daily reporting to market manager and lead project manager on work progress (War Room Manager).

Key Contributions:

•Designed project management database that integrated all project aspects into manageable system.

•Designed and built an Microsoft Access database for the finance team that significantly improve the departs productivity. The team was able to create a report in 5 minutes that usually take them 2-3 days to compile.

•Drove prompt resolution of all RF Engineering related issues to maintain timely progress on multiple simultaneous projects.

•Collaborated extensively with construction managers, construction supervisors, field technicians, and site technicians to resolve issues and ensure completion of construction projects on time and on budget.

RF Systems Engineer / RF Optimization Engineer / RF Design Engineer (2000-06)

Serving in a series of positions located across the country, provided Design, Optimization, and Systems Engineering for construction of wireless sites comprising the backbone of the company’s wireless network.

Authored proposals and RFP responses as well as Statements of Work. Played a key role in preliminary field surveys that determined financial feasibility of various projects. Performed analyses and studies to facilitate deployment of wireless network sites. Provided zoning support and advice for site acquisition teams.

Provided engineering support for UMTS build outs while collaborating closely with project management teams and construction crews to develop on-schedule and per RF Design specifications. Relied upon for technical support expertise by local AT&T Wireless teams on network expansions, extensions, and maintenance. Assisted RF Engineering Manager with departmental responsibilities.

Key Contributions:

•Researched, developed, and wrote standard operating procedures and work processes for RF department and developed / designed forms.

•Improved productivity and efficiency by streamlining daily record keeping, tasks, and processes through the use of macros that greatly simplified these responsibilities.

•Developed reporting system that reduced task performance from days to minutes, which was adopted as the standard for use in three major markets across the country.

•Improved operational efficiency by developing data management system that centralized numerous data trackers into one data system utilized by lead project manager and many other department heads.

•Designed PCS wireless network for Devon Communications in Maine.

•Directed design and build out of BroadBand 2 Wireless Inc. network (BB2W) in 20 cities across the country.

•Planned and designed entire Capacity Sites network for Sprint PCS wireless network in Connecticut.

•Participated in AT&T GSM/UMTS Overlay and Growth projects in Sacramento, New York / New Jersey, and Philadelphia regions.

** ** ** Additional Experience ** ** **

Early career success as RF Design Engineer with Sprint PCS

Military Experience: Former US Marine with service in Kosovo and Iraq

Education and Training

Pennsylvania State University, Malvern, PA

MBA – New Ventures & Entrepreneurship

CERTIFICATES – Project Management, Database Design, Data Warehouse Design

Polytechnic University, Brooklyn, NY

MS – Systems Engineering

MS – Electrical Engineering

Hofstra University, Hempstead, NY

BE – Engineering Science (Biomedical Engineering)

Technical Skills

Desktop Application: Expert in Excel & Access, PowerPoint, SharePoint, Outlook, Visio and Project

Database Development Tools: Microsoft SQL Server, Oracle SQL Developer

Business Intelligence Tools: Business Objects, Crystal Reports, Reporting Services SSRS, Integration Services SSIS, Oracle Web Discoverer, Oracle BI Publisher

SQL Programming: Access SQL, Transact-SQL, Oracle SQL, Oracle PL/SQL

Application Programming: Java, JavaScript, C#, C++, Visual Basic (intermediate skills),VBA Macro,XML

Contact this candidate