Sql Server Analyst

LISA NEWCOMER

**** ****** *****; Frederick, MD **701 * 240-***-**** *

************@*****.***

Job Objective: Financial Analyst

SUMMARY

. Over 20 years work experience in the Government contracting industry

. Ten years accounting experience in a biotech environment including

automated billing, bank reconciliations, GL account reconciliations, ad-

hoc financial reporting as required

. Ten years Government contract billing and administration experience in a

biotech environment on many types of contract vehicles including CPFF,

T&M, and FFP

. Experienced using MS Office applications, particularly Excel, Word and

Access, and able to learn new systems very quickly

RELEVANT EXPERIENCE AND ACCOMPLISHMENTS

Finance and Accounting

. Prepared all monthly project billing, including commercial projects as

well as all types of Federal contract vehicles.

. Considerably reduced time to prepare monthly billing process by taking

most off-line, hand-calculated invoicing into DELTEK billing environment.

. Analyzed and prepared monthly revenue accrual based on costs incurred but

not yet billed. Prepared reversing journal entry for revenue accrual.

. Analyzed monthly aging statement and performed regular collection

efforts.

. Reconciled monthly bank statements, including general ledger journal

entries for interest earned, accruals and adjustments as needed.

. Prepared financial documents including ad-hoc reports on various account

reconciliations, proposal pricing spreadsheets, project financial

reporting

. Assisted with Accounts Payable and Payroll tasks as needed, including

vendor invoice and timesheet processing and automated check runs, as well

as account reconciliations.

Computer Expertise

. Designed and developed database systems using SQL Server

. Prepared extensive data queries for ad-hoc reporting using SQL Server and

MS Access

. Used Microsoft Excel and Word to generate reports, spreadsheets and

business proposal data.

. Used Microsoft Access to generate custom application menus and report

screens.

. Hand-code static web pages using HTML and CSS, and dynamic web pages

using SQL Server and ColdFusion

EMPLOYMENT HISTORY

. 1998 - 2009 Systems Analyst II SRA International, Inc., Frederick,

MD

. 1998 Programmer/Analyst Tracor Systems, Wheaton, MD

. 1996 - 1997 Team Accountant DynCorp, Gaithersburg, MD

. 1989 - 1998 Billing/Contract Specialist Pathology Associates,

Frederick, MD

EDUCATION

. BS in Computer Science, University of Maryland University College

. AA with honors in Accounting Frederick Community College

HONORS, AWARDS, and MEMBERSHIPS

. Numerous Star and Constellation Awards, SRA International (as Constella

Group, LLC)

. Phi Theta Kappa - International Honor Society of the Two Year College

. HTML Writers Guild, Member, 1999 - Present

Contact this candidate