PROFESSIONAL SUMMARY:

• An accomplished, self - directed professional with excellent problem-solving, financial modeling, and analytical skills providing C-Suite business leaders Business Intelligence (PowerBI, etc.) to support data-driven business cases and decision-making in JIRA & Agile work environments.
• Advanced skills in Financial Planning and Analysis (FP&A in both corporate & capital market roles) and complex multifactor & multidisciplinary analysis with pro forma data modeling across numerous platforms (expert level Excel, including DAX formulas in PowerBI, PowerPivot, PowerQuery and VBA). Calculating and tracking the Cash Conversion Cycle (CCC = DIO + DSO - DPO). G/L monthly financial close, journal entries, monthly/annual forecasting, budgeting, and strat plan.
• Team lead FP&A scenario and risk modeling of pro forma modeling of all fixed and variable drivers. (E.g. M&A, Acquisition modeling, consolidation, tariff scenarios, 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, modeling, variance, multivariate, trend &/or secular and cycle analysis and identification.
• Oversaw SDLC financial analysis and detailed modeling with comprehensive valuation by every metric, with risk/rewards, using algorithms, macros, VBA, and comp metrics. Worked with Oliver Wyman consulting staff for CCAR (FP&A) stress test modelings.
• 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 (workbook breakdown structuring) modeling, variance, multivariate, trend &/or secular and cycling analysis and identification.
• Familiar with Business Intelligence (BI) and Business Analysis Body of Knowledge (e.g. “BABOK” guide).

TECHNICAL SKILLS:

Skills: Proficient in MS Office Suite, Advanced Excel (E.g. Range Arrays with Offset functions, Nested Logic Functions, VLOOKUP s/Index-Match, PowerPivot Tables, DAX Formulas, PowerBI, PowerQuery, MDX & VBA formulas). Advanced Financial, Econometric and credit modeling. ACCESS, Advanced ALM (FISERV/Sendero - Pricing Data Warehouses) SUNGARD + derivatives, Matlab, Factset, Oracle/Essbase, Peoplesoft, Thompson, Capital IQ, Bloomberg Pro. Multi-factor worldwide modeling with back-testing, Intex ABS, intermediate quantitative analysis (R, earlier SASS) and expert level FP&A and forecasting CPMS, PROC & SQL/SSRS, JIRA and Agile & Agile Pods. Skilled in Advanced Accounting Functions (in MPA program and Minored in Accounting in MBA). Familiar with and used/calculated Basel, 2 & 3 (statistics, leverage. VaR, & credit) CCAR & DFAST (Dodd Frank), PPNR & R (statistical) Sensitivity Analysis and Stress testing, US GAAP and IFRS. Development and modeling of (data extraction from SQL/SSRS) for internal & external KPI s, KRI s for Company and CCAR Early Warning Indicators .

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Florida, & Riverside, CA

Sr Financial, FP&A, and Sr Business Analyst

Responsibilities:

• Currently Sr. Finance & Business Consultant performing custom DAX financial statement modeling in PowerPivot, PowerBI - Excel modeling & consulting for a Top-11 U.S. municipality. Support Business, IT financial, quantitative, advanced data modeling, analytics, ERP (Oracle, PeopleSoft) and reporting.
• Fortress Industries Tariff(s) Optimization & Strategy formation, and FP&A and stress test pro forma modeling. Data partitioning involved PowerBI online data analysis (“OLAP”) into divisional roll-ups, which could be drilled down, or up (some via PowerPivot). The design has a significant forecasting ability along all major rev & cost drivers. The modeling period has monthly close roll-up monthly for all major divisions and included in a newly developed timeseries data warehouse master roll-up report.
• Worked with IT to set up data warehouse to map source data for new FP&A monthly modeling, roll-up, variance analysis and forecasting. Identified errors and data quality issues.
• Journaling interest, currency swaps, & journaling various FASB accounting reports. Hyperion Essbase template. G/L monthly financial close, journal entries, and monthly forecasting.
• Sampling, and modeling adjustments for strat plan, FP&A development and implementation, and smoothing forecast techniques: Detrending data, seasonality, reducing spurious (false) correlations.
• Price & demand elasticity, and advanced dashboard developments.
• Internally generated (SQL & data warehouse) FP&A, Variance Analysis, KPI & KRI with PowerBI reporting.
• Autonomous, regional, & consolidated global operational modelings, and optimizing forecasting and variance scenarios to desired periodicity & stress parameters.
• Modeling, & Excel coding international FX credits. Modeling Money Market & AR verifications.
• Identify & resolve discrepancies b/n cash flows generated by TMCC's system of recording and cash flows from external parties.

Confidential, Dallas, TX

Senior Business & Finance Analyst

Responsibilities:

• Identified (August 6 & 20th, 2015) major ($232 million ) Balance Sheet risk months in advanced of major Santander losses. Merrill’s intuition was entirely without getting “discontinued operations” pool performance data (N/A for CCAR) - where the $232 Million Mark-to-Market year end charge off came from.
• Capital & Risk (VaR & Basel II & III) Modeling Strategic Analysis & monthly Capital Committee Risk reporting of Accounting, Budget/Forecasting, Financial, Credit, ALM, & Treasury Analysis.
• FP&A, ERP, and advanced VBA/Excel/DB/SQL/SSRS modeling of historical & forecast KPI’s, KRI’s & EWIs.
• Worked on CCAR & DFAST & other (FP&A type) stress test modelings, (NIM, PPNR, Warehouse lines/funding) and Fed filings. (Issuer of over $60 billion in Off-Balance Sheet auto-finance ABS/CDO’s.)

Confidential

FP&A - Finance & Business Analyst

Responsibilities:

• Lead the proforma modeling (very much with ROI & NPV model calculations), and buildout of COOP solar installation sites in Ontario. Project capitalization spend rates Vs budget tracking. The COOP solar project modelings (templates & variance parameter modeling) has now rolled out across the Province.
• Advanced FP&A - Analysis, Modeling, and Forecasting with all comprehensive valuation metrics, Including rev & cost-drivers, stress testing & sensitivity analysis, KPIs, KRIs, numerous valuations & related metrics. (Feed in tariffs, grid data, degradation, sensitivity by drivers, etc. integrated into the modeling.) Significant project management experience.
• Great Plains & Excel G/L and journaling work, monthly closing, forecasting, credit analysis, tariff factoring and price arbitrage modeling and planning.

Confidential

F inancial & Business Analyst

Responsibilities:

• Global Business & Financial analysis and advanced VBA and Excel modeling of companies, projects, and econometrics in several industries. (Including XBRL linking.)
• Modeled companies/industries by all evaluation metric (ROI, DCF, FCF etc.).
• All with KPI’s, & KRI’s Sensitivity Analysis by both Costs and Rev drivers, etc. (Including XBRL linking.)
• Performed Database reporting, modeling & analysis from various data sources. (Excel, PowerQuery, APIs, MSFT SQL/SSRS data modeling).
• Modeled wind, hydroelectric, thermal, nuclear, & solar installations and electric companies and industries.

Confidential

Senior Financial Business Analyst

Responsibilities:

• “Special Projects Lead Manager” of 4 and Agile pod project group of 4 . Research Dept. for #1 Ranked Research firm in Canada. (Dealt with significant end-user scope creep when they saw what I could do.)
• Oversaw SDLC financial analysis & detailed modeling of global diversified companies with comprehensive valuation by every metric, with risk/reward user-friendly GUI available algorithms/macros/VBA, & comp metrics. Built and monitored competitor & industry group comp’s (comparisons) dashboards.
• Worldwide Research, Business, & Financial analysis with advanced VBA and Excel modeling of companies & projects: FP&A, Pro Formas, variance KPI & KRI modeling.

Confidential, Overland Park, KS

Financial & Business Analyst

Responsibilities:

• Financial and business analysis in diverse research, consulting and advanced financial modeling of international and domestic business (including REITs, real estate) and multi-sector equity and fixed income (MBA/ABS structuring and stress-tests) opportunities by every valuation metric (ROI, DCF, NAV, FCF, Debt-service coverage, etc.), with KPIs, Sensitivity Analysis and forecasting by all Cost & Rev drivers.
• Researched, analyzed, modeled and provided macro (econometric), trends & variance analysis.

Confidential, Kansas City, MO

Director Financial Services Group

Responsibilities:

• Modeled, analyzed the largest proprietary U.S. banking industry stress test ALM as keynote address at 3 State (OK, KS, CO) Independent Banker Assoc. Annual Investment Conferences. Merrill’s proprietary research was/is the largest ALM security-specific derived analysis of the U.S. banking industry (~ 630+ banks).
• Merrill modeled & programed Bank Stress-Testing back to 7 yr.’s of Pre-CCAR Fed stress-testing and analysis, the “Supervisory Capital Assessment Program” (“SCAP”) FP&A forecasting.
• Modeled and conducted firm-wide data analysis on PPNR, and loss estimations (from pre-SR 11-07 components loss estimation models). Credit and CRE forecasting, budgeting, and variance with root cause analysis.
• Merrill was promoted from Senior Financial Analyst (external FPA w/ proforma modeling) to Portfolio Manager of ~ $1.2 Billion in 3 SEC Registered funds.
• Promoted to Trust Investments Dept. due to my “exceptional accounting, analytical and consultancy skills and abilities” (Dept. Supervisor Pat Thompson).
• Bank consulting with RE & Mortgage lending processes value chain.