Edward Prior Email & Phone Number

Somerville, Nj, Us

Somerville, Nj, Us

Somerville, New Jersey, United States

Piscataway, Nj

Basking Ridge, Nj

• Created and updated predictive cost models for capital budget programs that collectively ranged between $1.0B and $2.0B annually. Based funding upon unit costs and target forecasts. Quantified year over year deltas. Justified regional differences. Answered extensive “what if” scenarios. Models were initially done with Excel and PowerPoint, later converted to Alteryx and Tableau.• Managed a cross functional team that developed a process to add Verizon Wireless network equipment in buildings owned by Verizon Wireline (a.k.a. landline). Designed a tracking system using Excel VBA and SQL Server. Created formal methods & procedures. Defined KPI’s.• Created an executive dashboard to track capital spend, landline circuits and other products provided to Verizon Wireless. Processed data with Alteryx and did data visualization with Tableau.• Programmed an ETL process in SQL Server for automated capital reporting.• Designed and maintained SQL Server databases for cost modeling and forecasting.• Forecasted products. Evaluated forecasts provided by peers. Developed reports to aid forecasters.• Shared data and insights with peers, known as a trusted data expert.

Marlboro, Ma

• Created a process to equitably share technicians during the dot-com bubble, when the workload increased dramatically but staffing levels were static. Queried engineering systems, received time charging feeds, and published daily results. IT programmed this process into an enterprise system.• Verified capital spend figures prior to reporting results to government regulators.• Created a process to track and measure vendor performance.• Developed and maintained capital budget reports.• Developed reports to aid engineers with project administration.• Developed reports to aid managers with doing evaluations for engineers.• Wrote project cost estimates, wrote detailed installation specifications and ordered equipment.• Fulfilled numerous requests to develop ad hoc reports.