Provided Corporate Business and IT stakeholders Business Intelligence (PowerBI) to support data-driven business cases and decision-making. * Worked with IT Product Development/Management for FP&A financial planning, analysis, consolidated reporting and M&A analysis, cost and price trending and forecasting. * Oversaw IT SDLC financial analysis and detailed modeling with comprehensive valuation by metrics, with risk/rewards, using algorithms, macros, VBA, and comp metrics. Worked with Oliver Wyman consulting staff for CCAR stress test modelings. * Advanced skills in Financial Planning and Analysis (FP&A) and complex multifactor & multidisciplinary analysis with pro forma data modeling across numerous platforms (expert level Excel, including DAX formulas in Power BI and VBA). * Performed FP&A scenario modeling for pro forma modeling of main drivers: QTY, Price, Cost, etc. * Conducted advanced top-down/macro, and bottom-up/micro accounting and forecasting with variance analysis (impact, root cause, potential resolution, etc.) and development of internal & external KPI, KRIs, dashboards, FP&A (in both corporate & capital market roles), Strat plan/budget modeling, variance, multivariate, trend and/or secular and cycling analysis and identification. * An accomplished, self-directed professional with excellent problem-solving, financial modeling, and analytical skills. * Familiar with Business Intelligence (BI) and Business Analysis Body of Knowledge (e.g. "BABOK" guide).
Description
