Analyst - Financials Analysis, FP&A, Managerial Reporting and Treasury

Darryl Frazier

*****************@*****.*** 832-***-****

Objective & Summary:

Experienced financial professional seeking Analyst and similar positions with a focus on financial planning and analysis.

I bring solid analytics and MS Office applications skills in support of data analysis, reporting and day-to-day and long-term finance, accounting and cash management operations. In addition, multiple ERP, Cash Management, spreadsheet development, banking and other financial related software and portal use combined with structured and ad-hoc reporting.

Core Concentrations

Financial & Data Analysis & Integrity Management

Treasury & Cash Management Operations

Spreadsheet Analysis & Reporting

Managerial & Financial Accounting

Professional Experience:

Global Compensation Analyst – Project Sept. 2017 thru Mar. 2018

Sutherland – Data Analyst

Provided spreadsheet creation, reporting and auditing assistance for HR Global Compensation team, including PowerPoint presentations development for U.S. and Global regions on Sr. Management compensation.

Gathered and analyzed global incentives (comm./bonus/VPP) paid in the FY18 Q1 & Q2 by Global regions and employee levels.

Spreadsheet creation and reporting: build and modify spreadsheets to calculate U.S. segments (Brazil, Canada, Colombia, Mexico, Jamaica and the U.S.) and other global region compensations metrics and as needed. Included FX conversions and calculations.

Audit and reporting (U.S. & FX): of global vs ERP data to sync and validate actual headcount, salary, denomination and any other possible scenarios.

Helped in Job architecture restructuring of positions and salary mapping to new titles structure, paygrade levels and min/max salary ranges.

Preform market research in state/national employee salary restructuring, including min wage and don't ask questions for presentation to HR management

Shared monitoring responsibilities for 3 Outlook email inboxes.

Responsible for handling highly sensitive and classified information in a highly ethical fiduciary capacity.

Rice University Glasscock School of Continuing Studies – Treasury CTP Program Feb. 2017 thru July 2017

Comprehensive instructor lead course coverage of the knowledge and skills required to perform competently in today’s complex treasury environment including skills required to effectively execute critical functions related to corporate liquidity, capital and risk management.

Cash Management Coordinator – Perm Sept. 2015 thru Feb. 2017

U.S. Physical Therapy - (USPH)

Validated daily cash pack activities (EFTs, cash, check & CCs) and performed heavy EOM bank to G/L and inter-company reconciliations for 60+ single and multi-clinic LLC/LPs, in MS Dynamic/Great Plains and Excel.

Liaised with banks, resolved check, credit card, and clinic financial discrepancies through extensive web-based bank portals use, merchant services, Great Plains, Excel and G/L reconciliations research.

Monitored bank balances and prepared, validated and executed wires and ACH balances for weekly disbursements.

Provided additional cash management support as needed for national affiliation of Physical Therapy offices. This is a very high volume, fast paced environment with multiple monthly deadlines.

Donations Processor (A/R) - Contract Feb. thru mid-June / 2015

National Multiple Sclerosis Society - (NMSS)

For Houston Chapter, processed lock box, cash and credit card donor donations for 15+ state chapter offices to G/L.

Bank Reconciliations Specialist - Contract Aug. thru Oct / 2014

U.S. Physical Therapy - (USPH)

Performed simple and complex (multiple entity), bank to G/L reconciliations in Great Plains and provide additional cash management support as needed for Houston headquarters for national affiliation of Physical Therapy offices.

Verified bank balances and prepared, validated and executed wires.

Extensive research, Excel, Great Plains, General Ledger and inter-company transactions experience required.

Investor Reporting Analyst – Project May thru July / 2014

Selene Finance

Brought in for daily and month-end reporting help for 3rd Party Investor reporting during GNMA on-boarding process.

Daily duties included, but not limited to: Reconciling and reporting bank; forecasted balances, pledge accounts and tranche payments; processing remittances to investors (wires); new investor setups; research and resolving Investor inquiries.

Performed advanced month-end Excel spreadsheet analysis to reflect 3rd Party Investor month-to-month portfolio changes.

In-depth systems use including Excel modeling: V-lookups, Pivots, formulas, etc.; Access, Outlook, 3270, MPS/LPS and Monarch.

CT - Securities Admin Services Analyst II - Contract Jan. thru Mar. / 2014

Wells Fargo Bank

Processed daily, routine to moderately complex security payments and reconcilements for Collateralized Loan Obligations.

Processed daily loan trade packets and validated trade directions, funding memos, deal restrictions and ensured cash sufficiency.

Reconciled and reported PD Cash Recons (Excel based CCRs) for CLO deals; including all interest and Collateral payments for multiple tranches, deal restructures, trade and Par activities and balances.

Performed bi-weekly formal recons of all portfolio assets, collateral and cash balances for investor reporting.

Financial Analyst – Project Oct. thru Dec. / 2013

Precision Drilling

Through heavy Excel & proprietary systems use, created macros, queries, pivots and lookups to pull, audit and recreate historical payroll metrics for all well-sites and related employees for both U.S and Canada projects for submission to the Dept. of Labor.

Transitioned through contract extension to reconcile multiple company G/Ls for current and prior years.

Query various G/L financials in SAP, State tax, SOD and custom Crystal Reports in ADP to research and reconcile G/L’s for audit.

Loss Mitigation Specialist (Mortgage Servicing) - Project Feb. thru Nov. / 2012

Stewart Title, Inc.

Reviewed submitted documents and financials, computed ratios and input into bank systems criteria to make loss mitigation determinations in accordance with government mandated mortgage modification programs and foreclosure determinations.

Created reports of borrower financials to establish levels in meeting loss mitigation criteria for DOJ, HAMP & Non-HAMP.

Assisted project supervisors and personnel daily with EOD spreadsheet account tracking errors and report compilations.

Financial Analyst – Project July thru Nov. / 2011

NPC - Vantiv

Through Oracle SQL interface, create queries, pull & audit historic & live financial data exports to weed out financial inconsistencies in the testing of parallel systems.

Used flowcharting and extensive Excel manipulations (imports (delimits), Pivots, lookups), database query skills (SQL & MPPS), calculations of mathematical derivatives, and analytical thinking to identify problematic patterns in data computations to resolve and re-calculate commissions, fees computations and other large volumes of complex data logically.

Financial Accountant (Investments) – Seasonal Feb. thru April / 2011

Weber & Associates, L.C. July thru Nov. / 2010

Initial set up of multiple Trust investment activities into PAM accounting system G/L and create sub accounts to record and link investment activities to their respective transaction types and taxable categories.

Audit Trusts account investments and tax statements, including OID &K1s, to validate and translate investment activities into PAM accounting system for tax and financial reporting to IRS and trustee.

Treasury Analyst - Contract Nov. / 2007 thru Sept. /2008

CITGO Petroleum Corporation, Houston, TX

Managed rolling corporate treasury forecast, establishing daily cash position and plan, schedule, and process cash funding, concentration activities, and special payments (Debt, dividends) for consolidated subsidiaries, affiliates, and Joint Ventures.

Produced PD bank balance & credit facility reporting, support daily wires and review invoices in SAP in the ACH pipeline.

Supported investment initiatives: (i.e. maintaining investment worksheets, Hedge reporting, funding, FX purchasing); and resolving issues with traders, banks, business units, accounting and others as needed.

Reconciled PD cash using XRT workstation to book in reconcile and release corporate cash to accounting for disbursement.

EDUCATION:

Member of Rice University Association for Certified Treasury Professionals program Houston, Texas

Member of Association for Financial Professionals - AFP is the preferred resource for financial professionals for continuing education, financial tools, publications, career development, certifications, research, and the development of industry standards.

BBA Finance, University of Houston, DT Houston, Texas

Contact this candidate