Doug Sherlock

Doug Sherlock Email and Phone Number

Accounting Manager @ Medica Health Plans
Minneapolis, MN, US
Doug Sherlock's Location
Minneapolis, Minnesota, United States, United States
Doug Sherlock's Contact Details

Doug Sherlock work email

Doug Sherlock personal email

n/a
About Doug Sherlock

Doug Sherlock is a Accounting Manager at Medica Health Plans. He possess expertise in insurance, financial reporting, accounting, health insurance, employee benefits and 3 more skills.

Doug Sherlock's Current Company Details
Medica Health Plans

Medica Health Plans

View
Accounting Manager
Minneapolis, MN, US
Employees:
17
Doug Sherlock Work Experience Details
  • Medica Health Plans
    Accounting Manager
    Medica Health Plans
    Minneapolis, Mn, Us
  • Medica Health Plans
    Accounting Manager
    Medica Health Plans Aug 2009 - Present
    Manage the Accounting area for a major health insurance provider. Responsible for the accuracy of the $300 million Administrative budget. • Reconcile new and non-routine transactions related to healthcare reform • Manage financial audits of Medica including the financial regulatory reporting• Coordinate journal entries through United Health Group • Perform ad hoc analysis and analysis related to capital planning• Analyze, reconcile, compile and present month end and year end statements to Senior Management• Develop audit schedules and meet with auditors and respond to their question• Supervise and mentor Accounting Department staff
  • Medica Health Plans
    Accounting Supervisor
    Medica Health Plans Jul 2005 - Aug 2009
    • Coordinated monthly administrative expense close process• Prepared and presented expense variance analysis schedules to management• Reviewed account reconciliations• Provided work direction to expense accountants• Interpreted financial results for cost center managers• Prepared special reports for all levels of management and Board of Directors• Calculated accruals and prepared journal entries and entered them into Lawson G/L system• Created financial models to accurately forecast financial results• Prepared regulatory filing schedules and assist in the completion of audits
  • Medica Health Plans
    Senior Accountant
    Medica Health Plans Dec 2001 - Jul 2005
    Minnetonka Mn
    • Calculated accruals and prepared journal entries and entered them into Lawson G/L system• Prepared reconciliations of balance sheet and bank accounts, analyzed and corrected discrepancies• Analyzed monthly budget variances and presented findings to management• Compared Lawson and PeopleSoft account balances and resolved discrepancies• Uploaded payroll interface and reconciled to printed payroll reports and cash disbursements• Performed all accounting functions for the Medica Foundation• Calculated and insured timely payment of UGH administrative fees that exceeded $70 Million annually• Created and modified general ledger reports using Lawson Report Writer
  • Allina Hospitals & Clinics
    Intermediate Accountant
    Allina Hospitals & Clinics Aug 1997 - Dec 2001
    Minnetonka Mn
    • Calculated accruals and prepared journal entries for entry into Lawson G/L system• Prepared reconciliations of balance sheet and bank accounts, analyzed and corrected discrepancies• Created PeopleSoft journal entries to transfer administrative expense by product to the PeopleSoft ledger at UHG• Worked with HRIS to ensure accurate, updated payroll interface tables• Assisted in the completion of annual external audits and regulatory audits• Interpreted Payroll and Benefit accounting results for Human Resources staff• Prepared PeopleSoft financial statement for Monthly Report
  • Dayton-Hudson
    Accountant
    Dayton-Hudson 1986 - 1997
    Minneapolis Mn
    • Recorded and paid all property taxes and prepared related journal entries and account reconciliations• Prepared and paid Sales and Use tax returns and related journal entries and account reconciliations• Maintained detailed records of archived material in a database• Balanced all internal reports for the financial system• Prepared weekly and monthly financial reports and related journal entries and account reconciliations• Assisted in the preparation of monthly, quarterly and annual close statements• Conducted monthly audits of selected account reconciliations

Doug Sherlock Skills

Insurance Financial Reporting Accounting Health Insurance Employee Benefits Medicare Access Strategic Financial Planning

Doug Sherlock Education Details

Frequently Asked Questions about Doug Sherlock

What company does Doug Sherlock work for?

Doug Sherlock works for Medica Health Plans

What is Doug Sherlock's role at the current company?

Doug Sherlock's current role is Accounting Manager.

What is Doug Sherlock's email address?

Doug Sherlock's email address is do****@****ica.com

What schools did Doug Sherlock attend?

Doug Sherlock attended Anoka Ramsey Community College.

What are some of Doug Sherlock's interests?

Doug Sherlock has interest in Football, Fishing.

What skills is Doug Sherlock known for?

Doug Sherlock has skills like Insurance, Financial Reporting, Accounting, Health Insurance, Employee Benefits, Medicare, Access, Strategic Financial Planning.

Who are Doug Sherlock's colleagues?

Doug Sherlock's colleagues are Letuzia Gomes, Aline Damasceno, Higor Augusto, Sheila Cristina Campos De Almeida, Jéssica Pires, Beatriz Alves.

Not the Doug Sherlock you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.