Christina Carswell
Kennesaw,GA
Overview
18
18
years of professional experience
Work History
Senior Investment Accountant
Division of Investment Services
Atlanta
07.2018 - Current
- Reconciled cash and positions daily, working with the Operations team, Advisors, and our Custodian to resolve any differences promptly
- Analyzed Rate of Return daily to ensure all entries have been correctly posted for an accurate return
- This includes comparing to various indexes and trade reports to ensure expected returns
- Created a workbook to enhance this daily task by comparing all expected results, allowing more time to research discrepancies
- Daily this saves our team 30 – 45 minutes with increased accuracy
- Monthly reconciliation of trial balance and returns
- Created multiple workbooks to reduce the time and increase the accuracy of these reconciliations
- Using IF statements, VLOOKUP's, Pivot Tables, and various formulas to pull the information from csv reports for comparison
- Input and review of Private Equity transactions, as well as updating valuations based on quarterly financials
- Coordinating with the Operations team to ensure all funding wires are sent on time and all distributions are received appropriately
- Reviewing the quarterly report from the Private Equity team to ensure all the information presented is correct
- Quarterly fee computations and recording of receivables/payables to close out quarter
- Created workbook for calculation of advisor fees to make reporting standardized and easier
- Calendar year and Fiscal year-end reconciliations, transactions, and reporting
- Created multiple workbooks to reduce the time needed for these activities, as well as creating/updating procedures as needed.
Senior Staff Accountant/Partner Accounting
King & Spalding, LLP
Atlanta
08.2016 - 07.2018
- Allocated net income among partners, as well as accounted and budgeted for guaranteed payments in lieu of income allocation, fringe benefits, bonus payments, and other miscellaneous payments to partners and former partners
- Managed the firm’s capital contributions, including monthly deductions, capital loans, and refunds
- Corresponded with partners to ensure timely receipt of capital contributions
- Collaborated with IT and outside vendors developing a system to manage historical and current information related to equity partners and their earnings, deductions, and capital contributions more effectively
- Reconciled local currencies for fixed asset purchases, disposals, and depreciation entries from 2003 to present
- Adjusted accounting system to correct prior year disposals and depreciation entries for local currencies
- Created Access database to update the fixed asset program with the relevant information from the accounting system
- Reconciled asset program with accounting system on a quarterly basis in US and local currencies
- Budgeted and accrued for depreciation and gain/loss expenses based on firm wide purchases
- Created schedules and corresponded with various auditors regarding guaranteed pay for equity partners, fixed assets schedules for all offices (US and foreign), and various other accounts
- Created property tax schedules, made payments and corresponded with auditors, as needed, for all US offices.
Financial Reporting Supervisor
Florida Dept of Transportation
Tallahassee
08.2014 - 07.2016
- Created Access database to complete daily analysis of Department entries, looking for: atypical amounts, out of balance transactions, incorrect general ledger usage, and other DOT specific requirements
- Use of Access significantly reduced the time required to complete these reviews manually while increasing the accuracy of the reviews
- Used SharePoint to streamline reconciliation and notification process
- Created workflows in SharePoint that selected information from the reconciliation to provide the correct email response to the appropriate parties
- Reconciled FDOT’s Florida Accounting Information Resource (FLAIR) records to State Accounts for cash receipts and cash disbursements for over 400 account codes
- Coordinated corrective actions
- Coordinated the Comprehensive Annual Financial Report (CAFR) for the Department
- Created financial statements for the Everglades Parkway (net position $77.5 million), Transportation Disadvantaged (net position $14.4 million), and Sun Rail (net position $488.5 million)
- Within the first year the implemented process improvements reduced the section from a supervisor and three professional accountants to a supervisor and one professional accountant, at which point the supervisor classification became an analyst.
Property and Insurance Supervisor
Florida Dept of Transportation
10.2008 - 08.2014
- Reduced fiscal outlay for risk management premiums by more than 50% while obtaining more coverage
- Used SharePoint and construction cost estimating data to provide more accurate replacement values, reducing reported values by over $300 million.
Revenue Management Supervisor
Florida Dept of Transportation
04.2007 - 10.2008
- Balanced cash for various trust funds to ensure adequate funds for outstanding vouchers and compliance with statutory requirements
- Invested excess cash to maximize earnings potential
- Tracked bond eligible expenses for future Full Faith and Credit Right of Way bond sales.
Grant Accountant
Florida Dept of Transportation
09.2006 - 04.2007
- Created efficiencies for grant billing by using Excel formulas and standardizing spreadsheet formatting
- Billed for grants and SIB loans.
Timeline
Senior Investment Accountant
Division of Investment Services
07.2018 - Current
Senior Staff Accountant/Partner Accounting
King & Spalding, LLP
08.2016 - 07.2018
Financial Reporting Supervisor
Florida Dept of Transportation
08.2014 - 07.2016
Property and Insurance Supervisor
Florida Dept of Transportation
10.2008 - 08.2014
Revenue Management Supervisor
Florida Dept of Transportation
04.2007 - 10.2008
Grant Accountant
Florida Dept of Transportation
09.2006 - 04.2007
Similar Profiles
Elyes Rayane MelbouciElyes Rayane Melbouci
IT Support Specialist at CN Investment DivisionIT Support Specialist at CN Investment Division
LAILA TAHOONLAILA TAHOON
Facility manager at Ned Investment L.L.C (Division of Masafi L.L.C)Facility manager at Ned Investment L.L.C (Division of Masafi L.L.C)
Kathy JassemKathy Jassem
Senior Portfolio Manager at New Jersey Division of InvestmentSenior Portfolio Manager at New Jersey Division of Investment
Devin LintaultDevin Lintault
Elementary School Teacher/EIP Department Lead at Cobb County School SystemElementary School Teacher/EIP Department Lead at Cobb County School System
Maria CardenasMaria Cardenas
Delivery Driver at Various Platforms (Doordash, Shipt, Spark, Instacart)Delivery Driver at Various Platforms (Doordash, Shipt, Spark, Instacart)