Gary Fee Email & Phone Number

Alpharetta, Georgia, Us

Atlanta, Georgia, Us

EAS (Enterprise Accounting Solutions Shared Services) • Oversee General Accounting Group with 3 direct reports and 3 indirect reports – Premium, commissions, claims accounting & reporting by product & segment, Reinsurance results, Statutory Reserve breakout, non- admitted assets, IBNR, OSLR, DAC and retro calculations• Prepare, oversee and approve journal entry preparation for month/quarterly/annual close process for multiple business segments• Reconciliations policy assessment – Measurement criteria, responsibility framework, financial exposure guidelines, support criteria, action plan & follow up• Reviewed and automated amortization schedules for reinsurance agreements• Managed SOX program for EAS – Created test plans, sample size rationale, testing steps & guidance for team and automated SOX control reconciliation documents• Quarterly review of existing accounting and financial reporting processes to identify scope for automations and increasing productivity• Relationship management with our outsourcing partner and drive transformation opportunities• Prepare PWC year end payroll related audit requests including 401K match, executive compensation and other ad hoc audit requestsKey Achievements:o Automated Payroll Accounting department processes end to end from corporate billing, chargebacks to internal entities, payments to tax vendors and reconciling with actual payroll. Also, Automated payroll conversion from Lawson Payroll System to Smart Stream (automated JE’s)o Built test scripts and performed all ADP pay/deduction code mapping to Smartstream general ledger entities, accounts, cost centers, primaries and type codes. Built test scripts and performed all ADP mappings for annual STIP (bonus) monthly accruals.Please see attached Resume for further Details

New York, Ny, Us

OBIEE (Oracle Business Intelligence Enterprise Edition) Reporting Tool • Build management earnings reports and ROC model (Return on Capital model) for multiple operating units in OBI utilizing Essbase, OBI SQL, Nested Filters, JavaScript programming (in many instances one report template works for multiple operating units).• Design and implement drill to detail reports.• Cube maintenance, design and advanced Essbase formulas utilizing DRM.• Design and implement automated OBI dashboards driven by presentation variables (built with custom SQL).• OBIEE (Oracle Business Intelligence Enterprise Edition) Reporting Tool.• Build statutory financial reports for multiple business units in OBI utilizing data warehouse ledger data, OBI SQL, Nested Filters, JavaScript programming.• Design and implement drill to detail reports.• Design and implement automated OBI dashboards driven by presentation variables (built with custom SQL).Key Achievement:o Automate monthly, quarterly focus filings and year end audited financial statements (creating significant company savings) with PeopleSoft nVision, query (unions, complex SQL Expressions) and advanced Excel techniques and formulas.

Amsterdam Zuidoost, Nl

Key Achievements:o Automate monthly, quarterly focus filings and year end audited financial statements (creating significant company savings) with PeopleSoft nVision, query (unions, complex SQL Expressions) and advanced Excel techniques and formulas.o Develop and maintain automated separate account annual financial statement footnotes utilizing Visual Basic for Excel, Hyperion Essbase and PeopleSoft (advanced nVision and SQL) for twenty-nine business units.o End to End Quarterly/annual Bluebook Automation - Automated Exhibit 1 Pt 1 & 2, NY Supplement, Schedule B, Schedule T, Schedule H, Schedule D, Schedule A, exhibit 12 – Non-admit, Exhibit 5 & 6 – G& A and TLF.o Consolidations – Programmed and maintain automated consolidation file including reconciliation template and journal upload directly to PeopleSoft in accordance with US and IFRS reporting requirements.o Create and maintain automated financial statement reports built with complex Visual Basic and SQL utilizing PeopleSoft nVision and complex queries (unions, multiple joins and complex SQL expressions).

Us

Revenue analytics• Calculate month, year-to-date and quarterly base revenue analysis; explain actual to budget and actual to prior year variances by category, including detailed written analysis for Board of Directors and COO functional area budget review meetingsExpense analytics• Prepare month, year-to-date and quarterly income statement variance analysis for all utility operations including revenues, gas costs, operations & maintenance (including thirty-seven service centers), depreciation, and other income/expense itemsDeregulation• Participated in first deregulation to marketers involving the natural gas industry in the U.S. (Atlanta Gas Light Company – 1.4 Million customers, represents the largest natural gas industry in the southeast)Key Achievement:o Learned PeopleSoft and became expert level Excel user and Visual Basic Programmer

Assistant Controller (09/1996 – 02/1999)Month end close• Calculate and post close entries.• Review trial balance with controller; investigate significant budget to actual variances, “go between” between senior managers and department heads.• Reconcile B/S and significant I/S balances.• Prepare and distribute financial statement packages.• General Ledger software implementation.• Assisted in implementing AS400 based JBA software system (including building the general ledger structure and chart of accounts).Internal Auditor (09/1995 – 09/1996)• Designed and implemented Internal Audit Department as company transitioned to commission based distribution process.• Documented and flow charted internal audit processes and procedures including physical inventory and operations audits.

Inventory and Operational audits• Perform inventory management and operational (compliance and fraud) audits at stores and distribution centers across the Southeast United States.• Draft detailed and extensive audit reports to upper management including but not limited to the CFO and Treasurer.• Review and approve physical inventory reconciliation packages for all southern region locations.

Tax preparer• Prepare individual, corporation, S-corporation, non-profit, and sales tax returns.Auditing• Independent audits including analytical procedures, substantive testing, confirmations, client representation letters, and reports.Bookkeeping