Qi Li, Cpa, Cia, Cgfm, Cdfm-A Email & Phone Number

• Review Oracle posting logic and transactions to identify and correct issues• Initiate system change requests and perform and document scenario testing results• Analyze transactions to identify and address system issues (AP, AR, Purchasing, Travel) • Review and resolve funds control issues• Design Oracle Business Intelligence (OBIEE) reports and dashboards to present data and identify issues/opportunities for process improvements. Devise workarounds to overcome data restrictions and reporting challenges• Perform tie-point analysis and enter journal entries to make reporting adjustment• Provide training to FMO contractors and staff on agency data, system processing, and analysis techniques• Led financial system migration workflows by defining and translating data requirements for functional areas within the FMO. Write SQL queries to extract data from Oracle tables and transform extracts to meet migration specifications. Identify and resolve data validation errors. Successfully handled system migration for the agency under a condensed schedule • Planed tasks to meet deadlines for system migration. Analyze project requirements and document decisions. Document system and business risks and controls and identify process improvements. Work with functional and technical teams at both the agency and shared services provider to coordinate project actions and deliverables• Designed processes and databases to automate data transformation and cleanup. Significantly improved data quality and reduced time for conversion• Provided system setup/configurations requirements for the agency’s core Oracle financial management system (flex field codes, cross validation rules, funds control templates, fixed assets) and feeder systems (PRISM, IPP)• Designed IDEA and Access databases to evaluate conversion data errors and group/identify patterns to resolve system and transaction issues• Developed database and automation tools to analyze data and reconcile transactions

• Provide consulting services for the agency’s annual budget authority comprising 19 active Treasury Appropriation Fund Symbols (TAFS). • Review provisions of the public law, TFM, and OMB guidance to perform rescission/ other return of appropriation, reprogramming, and realignment actions. Perform balance analysis to identify and correct erroneous transactions in Oracle • Prepare reports and analyses of budgetary resources to include reconciliation of the SF 133 report and Monthly Budget Execution Report (MER)• Analyze and summarize data to assist with funds control and respond to questions from the budget office, program offices, and auditors• Review prior year recovery entries and various Business Intelligence (BI) reports to monitor resource usage and identify issues for correction• Draft updates to procedural documents and edit memos for the Funds Control & Program Support (FCPS) branch• Review Treasury Information Executive Repository (TIER) data for financial reporting to detect issues and recommend corrective actions. Draft TIER adjustments and project adjusted results • Analyze accounting relationships for reimbursable agreements• Draft explanation to fluctuation and trend analyses• Provide analysis and compile Prepared-By-Client (PBC) files, perform walkthroughs, and respond to auditors’ questions • Developed a tool to validate accounting adjustments, identify budgetary transactions impacting the MER, and incorporate those adjustments into the report – saving over 95% of time spent previously• Developed a tool to automate the SF 133 reconciliation process. The tool captures updates and shifts to TAFS and populates their reporting values into a DHS template – saving over 90% of time spent previously• Developed tool to proactively review trial balance and identify potential issues before period end TIER data is provided• Developed tool to allocate and compile trial balance values to determine the amount of apportionment to request from OMB

•Provided system implementation support for the Department’s Global Financial Management System (Momentum)•Analyzed trial balance to identify erroneous transactions. Evaluated transaction definitions impacting accounting postings, determined appropriateness of treatment, and made recommendations for corrective actions•Created new general ledger accounts and transaction definitions. Identified and resolved posting model discrepancies•Evaluated financial information for compliance with GTAS, Reports on Budget Execution and Budgetary Resources (SF 133), and TFM requirements•Evaluated and interpreted requirements of the DATA Act for system implementation•Contributed to the annual-close process. Performed various year-end reviews for accuracy•Analyzed accounting relationships for reimbursable agreements and appropriateness of treatment•Researched and responded to financial reporting questions from the Deputy CFO office •Performed complex analysis of budgetary authority and financial operations. Identified budgetary accounting issues and entered adjustments to make corrections•Reviewed design and scope documents and testing results for financial system release updates•Provided guidance to staff members on various budget authorities and applicable requirements•Redesigned and implemented significant process improvements to produce key quarterly PBC files - reduced the time required from almost 2 weeks down to about 20 minutes of manual work•Developed a report that extracts trial balance with detailed attribute information. This allows for more accurate analysis and correction of issues•Developed a tool to validate accounting adjustments and produce trial balance reports showing the impact of draft adjustments•Developed time-saving tool to review results of annual close processes for accuracy•Developed a tool for the system security team to produce reports based off of various source data – saving over 90% of time spent on generating these reports

• Supported production of quarterly and annual financial reports and related footnotes, SF 133, and other required submissions (DOJ Provider Listings, GTAS, FACTS I, FACTS II, IRAS)• Analyzed fluctuations in the results of operations and in proprietary and budgetary accounting relationships (USSGL Tie Points) to identify and correct issues• Performed period end closing processes, including recording fiduciary journal entries and entering adjusting and correcting transactions in the Unified Financial Management System (UFMS)• Reconciled SF-133 to SF-132, identified issues, and performed corrective actions• Researched root causes to issues in UFMS (Momentum 7.0.4). Reviewed flexible definitions, transaction definitions, posting logic, and various transaction dimensions to determine impact of existing issues• Produced PBC files and supporting analyses, including reconciliation of operating and benefits expenses and explaining treatment of leases, capitalized expenses, accounting for Property Plant and Equipment (PPE) transactions to external auditors • Coached team members on federal accounting practices and standards, analysis techniques, financial management system functions, and review deliverables• Reviewed accounting treatments and financial impacts that result from reimbursable agreement transactions (Economy Act and with the public). Evaluated existing reimbursable agreement management process to identify improvements that support the accuracy of financial reporting and minimize control risks• Developed reports in the Business Intelligence system to support financial and budgetary reporting and substantiate responses to auditors’ questions. These reports enabled business continuity during the 2-week maintenance of the financial management system• Improved the MS Excel tools supporting the preparation process for financial statements and reports on budget execution and budgetary resources by automating analyses and validations

Washington D.C. Metro Area

Supported client personnel and leadership with analyzing undelivered orders as well as researching and resolving business issues. Collaborated with clients to design and implement innovative, high-impact solutions to help maintain effective internal controls, improve financial integrity, and conform to provisions of applicable laws and regulations. Highlights• Designed and implemented key reports to present information to senior executives• Developed a process and tool to analyze financial information based on established thresholds and calculated variances from expected results of operations. The tool and new process resulted in significant time savings in researching open obligations; reduced manual workload from potentially weeks of research, documentation, and analysis down to less than 30 minutes of high-level review• Developed report sets in the Oracle Unified Financial Management System that reduced the time required for client personnel to run recurring reports by 92% • Devised a solution that allowed client staff to automate corrections for more than 1,000 lines of travel transactions, resulting in significant time savings. The solution was implemented to 5 other client centers• Led the effort that contributed to the client's receiving an award for exceptional achievement for making significant strides in business process improvements

Assisted NRECA in providing budget forecast and financial analysis for the engineering division, while working closely with the division’s vice president to establish financial goals. Developed financial operating plans using zero-based budgeting techniques, interpreted and applied budgetary guidelines, and analyzed the association’s financial and strategic objectives to ensure the establishment of appropriate funding. Contributed to internal controls transformation efforts through reviewing the risks and controls governing the procurement process and identifying opportunities for improvement.Highlights• Developed financial plans for the Engineering division; prepared budget justifications and recommendations for Board meetings and analysis on operating results• Forecast depreciation expenses based on existing fixed asset balances and anticipated purchases while considering impacts of various expected in-service dates• Managed all PPE/capital projects accounting for the association (averaging more than $100 million) including addition, depreciation, disposition, and adjustments. Determined proper accounting treatments and identified and corrected existing issues• Significantly improved the policy governing assets. Drafted a new capitalization policy that incorporates guidance of the Financial Accounting Standards Board (FASB 13, 17, 34, and SOP 98-1)• Created an Access file to combine Oracle reports and generate queries that improve the overall efficiency of the fixed asset reconciliation process• Contributed to internal controls transformation for the fixed assets and petty cash processes

Served as an advisor to the NRECA’s members on retirement plan amendments, prepared legal documents to amend retirement plans, and explained provisions of retirement plans to executives and staff of electric cooperatives. Designed and managed various analysis tools, using MS Access and Excel, to interpret and report financial and operational information to senior NRECA executives. Highlights•Drafted Employee Retirement Income Security Act (ERISA) §204(h) Notices to explain benefit reductions; created an automated tool using macros, field codes, and quick parts in MS Word, that significantly reduced the time required to prepare the notices•Calculated benefit projections and adjustments to pension plan billings•Served as a subject matter resource during a 10-month implementation process for a retirement plan administration system•Supported execution of plan conversions and implementations. Composed responses to Requests for Proposal and drafted defined benefit plan proposals

Assisted the senior principal of retirement plans with plan conversions and implementations. Composed responses to Requests for Proposal, drafted defined benefit plan proposal packages, and calculated benefits projections.

Bachelor Of Business Administration (Bba), Accounting

Activities and Societies: Tax preparer - U.S. residents and foreign students and scholars - Volunteer Income Tax Assistance Volunteer.

Accounting

GPA: 4.0