Yan Li
Boyds, MD *****
*********@*****.*** 301-***-****
Senior Accountant
Accounting Lead to Improve Work Processes
Dedicated and driven professional with demonstrated results of contributing to business successes and financial solvency by proactively improving efficiency and accuracy of accounting processes. Present essential financial information to Executive team to ensure all transactions are accurately recorded and filed. Consistently identify opportunities to enhance processes and reduce monthly close time by 40% by implementing new consolidation procedures, developing Sage 300 (Timberline) reports, Hyperion reports, creating complex business rules, and calculation scripts. Known for analytical, perceptive, and organizational skills.
Expertise in:
Full-Cycle Accounting Oracle Administration Hyperion / OBIEE Reporting
Payroll Process Budget Analysis Account Reconciliation
Technical Skills
Excel (Pivot table & Vlookup) MS Word / PowerPoint
Sage 300 (Timberline) Deltek ADP / ReportSmith Concur
Professional Experience
Pleasants Construction, Clarksburg, MD 2018 – Present
Senior GL Accountant
Maintain and reconcile general ledger account balances for 10+ real estate companies, prepare balance sheets, profit and loss statements, cash flow statements and job cost reports to summarize current and projected company financial position on a monthly basis.
Compile and analyze financial information to prepare journal entries and document business transactions. Specifically, the recording of land sale transactions utilizing HUD-1s and related legal documents, allocating development costs appropriately to cost of goods sold. Improve the whole process and save 20% time by simplifying the work papers.
Prepare and submit monthly development loan draw packages to enable proper cash flow.
Maintain and reconcile monthly job cost schedules for these companies.
Ensure compliance with tax requirements. Complete all entity tax returns by working directly with CPA.
Ensure the comprehensive accounting records are maintained in an organized manner
UNITED STATES PHARMACOPEIA (USP), Rockville, MD 2008 – 2018
Senior Staff Accountant, GL and Reporting
Served as Oracle and Hyperion administrator in charge of CoA, secondary ledger set-up, mass allocation, and Hyperion dimension/reports setting.
Spearheaded implementation of Hyperion, OBIEE, and Concur systems, enhancing and creating new reports in Hyperion based on reporting requirements, increasing productivity by 40%.
Completed month-end close process, benefits allocation, revaluation, and inter-company accounts elimination, consolidating US book with 8 subsidiaries.
Supported management inquiries regarding mapping, presentation, and business purposes, verifying internal and external financial reports / notes were prepared with quality, accuracy, and precision.
Simplified comprehensive external income statement, cash flow statement, and statement of functional expenses, collaborating extensively with auditors during mid-term and year-end audit processes.
Reengineered Canadian Income Tax Return process, correcting procedure errors and eliminating gaps.
Reduced reconciliation time for investment accounts 60% by creating complex spreadsheet linked with investments statement.
Streamlined accounting process by fully documenting all process and procedures regarding monthly close, audit work-papers, and journal entry development.
Guided and mentored less experienced accountants, providing cross-training on disciplines related to Hyperion and OBIEE system maintenance and reporting for greater productivity and understanding.
The Arora Group, Gaithersburg, MD 2004 – 2008
Accountant – GL & Payroll
Performed day-to-day functions of corporate accounting department, including, but not limited to, payroll, government contract billing, journal entries, accruals, cost projection, and revenue projection.
Complied with and provided interpretations on various contracts and modifications, coordinating with project managers as well as COR (Contracting Officer Representative) to achieve 35% improvement over profit plan.
Maintained contract information and labor category, task orders / CLINs, billing rate, and billing type, generating and reviewing invoices, auditing subcontractor invoices, recording / posting transactions of sales, and recognizing revenue per project.
Reviewed and posted journal entries, payroll journal entries, inter-company transactions, fixed assets depreciation, accruals, and all other adjusted / corrected entries, ensuring all transactions were recoded accurately and provided management with vital financial information.
Validated 800 employees timesheets and processed bi-weekly payroll using ADP PC / payroll for windows and eTime software, decreasing errors by 30% and cutting entry input time by 25%.
Maintained and updated employee information in ADP system, managing successful multistate payroll with staff at various jurisdictions.
Implemented ADP-GL interface program, lowering time to record payroll from 9 to 3 hours.
Performed balance sheet account reconciliation, including bank, payroll, A/P, A/R, revenue, prepaid expenses, depreciation, and inter-company accounts, improving data accuracy and reducing errors by 5%.