SUMMARY:

With significant experience in accounting and finance, in both Federal consulting and corporate environments. Areas of expertise include Confidential, financial statement preparation, financial analysis, budget execution, financial system support, database development, SharePoint 2013 development and the analysis and application of technical accounting standards, including over 4 years’ experience performing Confidential at HHS and half year at Treasury Department. Has excellent analytical and financial modeling skills and experience in financial “due diligence processes” to improve all aspects of financial operations. Interested in finding SharePoint/Business Intelligence Analysis position/MIS accounting or financial software support.

TECHNICAL SKILLS:

SharePoint & SharePoint Designer: Fluent with creating site, webpage, wikis, web parts, custom lists, document libraries (documents check in/check out and versioning), content types, navigating SharePoint sites, using metadata to customize search, using workflows to automate task, managing work tasks and permissions.

Report Develop: Business Object, Proficient in many BO features such as Report Page Filter, Alerts, Drill, Ranking, Sections, and Break etc. Created user Prompts, Conditions and Query Filters. Used calculations, variables, able to merger dimensions from different universes.

ERP: SAP

Workday: Proficient in all the functionalities in SAP FI/CO modules GL/accounts receivable/AP/fixed assets/profit center accounting/cost center accounting/master data. Reviewed trial balances, revaluated open items, assessed currency issues.

MS Excel & Access: Power user, advanced knowledge of formula and function, proficient in all other advanced features, use VBA to create Macro to automate task in Excel and Access, able to create, modify, and refine tables, queries, forms, reports; use SQL to write queries to search and update tables; able to design and develop database.

Database/ Programming: SQL Server, PeopleSoft, Microsoft Access, Toad, SQL, PL/SQL, VB6, VBA, Java

PROFESSIONAL EXPERIENCE:

Supervisory Senior Accountant

Confidential, Washington, DC

Responsibilities:

• Developed ResumeDB SharePoint web application. Created lists to store employee resume information.
• Used lookup to populated data from other lists, and used calculated column to construct primary key, and used Designer to configure work flow to auto - populate data and create forms. Applied web user filters in web part so each employee only views and updates his/her own record while managers can view the whole list.
• Employees can update his/her resume from anywhere, and can easily navigate on the site.
• It has greatly helped CPA firm contract bidding and the talent matching process.
• Migrated all Confidential Company’s contracts in history from different folders to SharePoint Record Center document library.
• Added metadata to the document library.
• Defined and organized content types to customize contract search.

Confidential

Responsibilities:

• On the assignment to Treasury Department prepared the Quarterly Treasury Department Agency Financial Report (AFR) in accordance with OMB Circular A-136.
• Used Governmentwide Financial Report System (GFRS) to prepare Treasury Department year end closing package for GFRS financial statements.
• Used Treasury Information Executive Repository (TIER) and TIER Financial Statements (TFS) systems to prepare working paper.
• Reconciled AFR financial statements to Closing Package. Reviewed crosswalks from the TIER system for compliance with Treasury Financial Manual (TFM).
• Reviewed bureau stand-alone financial statements vs Treasury Consolidated financial statements. Used IBM Cognos Financial Statement Reporting Tool to prepare the AFR footnotes.
• Performed Federal Financial Accounting Standards (SFFAS) and Policy research.
• Assisted in review, assessment and evaluation of "Direct & Material Effect" and Affected Bureau of all published U.S. Laws and Regulations.
• On the assignment to Georgetown University, developed Access 2013 Web Apps PB (Position Budget) Database which connected to SQL Server/SQL Azure and is hosted by a SharePoint server. Database was developed for tracking the base and fiscal year position budget vs actual budget, and tracked position count, FTE, and cost allocation.
• Used data macros to auto-calculate the allocated salary and fringe benefits in list view based on parameter inputs.
• Applied filters in “On Load macro” so each school only sees their own related information in list and datasheet view.
• Used queries and Excel template to sort/group/validate position budget with financial budget.
• Resolved massive Position Budget data transfer issue, and merged huge files. Researched different Workday reports and consolidated cost allocation. Analyzed discrepancy between legacy system PeopleSoft vs Workday. Analyzed financial, HCM, and position budget data and reconcile the difference.
• Developed Operating Detail Report in Cognos, run and analyzed the results.

Financial Analyst IV

Confidential, Wyomissing, PA

Responsibilities:

• Developed and maintained various financial and management reports in Business Object. Gathered, assessed reporting requirements as provided by business line and other end users.
• Used queries, formulas to develop reports to support reporting requirements.
• Created complicated reports with technique of merger dimension from multiple universes.
• Worked on testing and validating reports to ensure accuracy of the reports.
• Reports developed included Balance Sheet, P & L, Revenue, Interest Income and Fee, Expense, Aggregated and Contract Level New Business and Runoff Reports, Time Deposits - New Volume, Promo CD Report, Multi Level Hierarchy New Business Report.

Confidential

System support

Responsibilities:

• Maintained organization/GL/CVG and other dimension structures.
• Maintained the product mappings and customization for the operational source data for any product changes or new products.
• Updated key dimensions to achieve a logical and consistent alignment among multiple dimensions.
• Reconciled and resolved data issue between BO and Legacy System. Documented the system maintenance procedures and dimension structure logic.

Supervisory Senior Accountant

Confidential, Washington, DC

Responsibilities:

• On the assignment to the Centers for Disease Control and Prevention (CDC) prepared interim and annual governmental financial statements.
• Prepared, analyzed, and reviewed comparative governmental financial statements including Balance Sheet, Statement of Changes in Net Position, Net Cost, Statement of Financing, and Statement of Budgetary Resources.
• Prepared footnotes and supplementary information, performed variance analysis, and monitored the account relationship between budgetary and proprietary accounts.
• Analyzed and researched the abnormal balances, proposed journal entries.
• Took the initiative to automate many existing manual reporting processes, such as automated the data transfer from SF-133 to SBR and used VBA to automate the FACTSII reporting month end upload process.
• Used SQL Server to pull financial data to support budgetary and proprietary abnormal accounts balance research.

Senior Accountant

Confidential, Atlanta

Responsibilities:

• In charged of whole cycle of accounting for one business unit which included General Ledger, maintaining and updating the fixed asset sub-ledger and monthly depreciation schedules, closing book at month end, reviewing trial balance, entering adjusting entry, creating financial and management reporting, account reconciliation, variance analysis, data validation, data analysis.
• Assisted accounting system conversion from SYSPRO to SAP, uploaded General Ledger beginning balances, mapped GL accounts, reconciled the two accounting systems, and resolved any failed Idoc issues. Worked extra hours to developed SRC financial and management reports internally for two business units. Functioned as SRC Administrator.