Brian Coniker Email & Phone Number

Cary, North Carolina, United States

Managed monthly update and refresh for the Expense Summary for Application Development using Hyperion/GEM and Excel, ensuring analytic readiness for Power BI dashboard visualizations.Maintained headcount forecast tracker and then utilized Workforce planning to implement the monthly changes by grade level. Created PowerPoint presentations and recommendations for high level leadership teams of each LOB, providing in-depth analytics of YTD actuals versus current forecast, budget, and prior forecasts.

Analyzed and identified variances/inconsistencies in the billing reconciliation process, determined root cause of the billing issue and resolved by working with source data contacts. Ensured timely and accurate reporting of expenses, resulting in $2 million monthly updates.Delivered reporting and analytics support for +$500M AD portfolio, managing daily month-end reconciliation of project financials using Clarity vs operating expenses per General Ledger.

Research Triangle Park, Nc

Identified a 14 million dollars saving opportunity, delivered to Senior Vice President of Operations, for the purpose of identifying which contract workers to offshore from the San Jose office to India. Created a self service, business intelligence dashboard for 10 Customer Supplier Managers by analyzing data through MS Excel and R on this quarter’s Statements of Work and received an “Innovate Everywhere” award.Presented a Summer Showcase Project, redesigning Cisco’s “Shop Now” webpage for small/medium business customers, using Cost benefit Analysis, Hicks Law, Focal Point Hierarchy, and Social Influence.