Business Analyst, Project Manager
Verizon
Hunt Valley, Md
Proven track record of successfully conducting quantitative and qualitative analyses on key performance indicators (KPI’s) and creating custom dashboards, scorecards, statistical models, Business Intelligence (BI) tools and high-level presentations to executives.Received Verizon “Spotlight Award” for developing and delivering a budget forecasting system that allowed Engineers to track actuals as well as forecast their monthly expenditures, improving accuracy by 20%. (utilized VBA, VB.net, Excel, MS Access, PeopleSoft, SAP, and SQL Server)Project managed a $4M web-based milestone forecasting system for executives as part of a workstream process improvement initiative for Verizon’s Center of Excellence; including inception, requirements gathering, technical design, development, testing, and delivery utilizing Agile Software Development Life Cycle (SDLC).Programmed a batch tool that Extracted Transformed & Loaded (ETL) over 5 million customer records each night applied a predesigned Excel template with established Key Performance Indicator (KPI) models, and emailed professional PowerPoint and Excel scorecards to departmental Subject Matter Experts (SME) to aid in developing new short-term and long-term marketing strategies. (utilized VBA, SQL, MS Access and Excel)Held weekly presentations with Directors and Managers detailing project performance, milestones, and budgets; designed professional KPI reports and scorecards for district review using Excel Pivot tables and PowerPoint charting features.Developed a series of automated monitoring tools to ETL data from multiple systems each day that emailed Managers summary information on project quality assurance/control, delays, overdue invoices, and scheduling conflicts, providing management with immediate improvement opportunities. (utilized MS SQL Server, MySQL, MS Access, Outlook, and Excel)