QUALIFICATION SUMMARY

• 12 years of accounting, finance, business analysis and reporting experience, thoroughly understanding system/process flow and database concept, diagnosis financial data for accuracy reporting, strong technical skills to automate business process and assist process improvement.
• Excellent written and verbal communication skills.
• Financial, Business and System Analysis
• Cost/Benefit Analysis
• Sub Ledger/General Ledger Reconciliation
• Operation Research and Data Collection
• Process Automation
• Data Manipulation
• Budget Forecast/Planning
• General Accepted Accounting Principle
• Database Design
• Data Mapping
• Account Reconciliation

TECHNICAL SKILLS:

• MS VisioMS SQL
• MS AccessSoftware Development Life Cycle
• Cost/BenefitMS Office Suit (Advanced Excel
• PowerPoint
• Word etc.)
• MS Project
• MS SharePointVisual Basic
• SQLPeopleSoft
• Oracle Financial
• Hyperion EssbaseLPS
• Fiserv
• SBO2000

PROFESSIONAL EXPERIENCE:

Confidential, Irving, Texas

Sr. Financial, System and Reporting Analyst

Responsibilities:

• Work as a reporting function, create and automate reporting for various purpose: Investor Reporting, Trial Balance comparison reporting, Arm Loan Rate/Payment comparison reporting, liquidation reporting, and many ad hoc reporting using T - SQL. Improved efficiency and accuracy of investor reporting.
• Liaison between investor reporting group and IT group for data mapping between servicing system (Fiserv) and investor reporting system (SBO2000). Write query to map data from Fiserv to SBO, which is used to fixed and correct data in the destination (SBO2000) for accuracy reporting purpose.
• Work with investor/ corporate accounting group to identify and resolve financial issues, fix system set up that generate error, fix data error, which improved accuracy of financial data.
• Streamline the daily balancing process through exception research, analysis and correction, automate the process by utilizing system function, improved the efficiency by reducing 50% of the run time.
• Work with SBO vendor to fix data error and mapping error.
• System set up for new investor. Thorough understanding of database concept and the importance of accurate set up impacting financial reporting.
• Assist in audit request by pulling data from system.

Sr. Accountant

Responsibilities:

• General Ledger/Sub Ledger Reconciliation. Month end closing process. Account Analysis. Balance Sheet Review. Balance Flux Analysis and Explanation. Account Reconciliation, Journal Entry creation. Review staff‘s journal entry. General Ledger Maintenance, Upload data for intercompany transactions. Trial Balance Explanation. Ad hoc financial analysis/project as management needs.
• Supported Card Service category business tactical and strategic operation/growth by conducting business and financial analysis. Manage 70MM Card Service payable accounts.
• Led card service automation project, gather the business requirement, transfer business requirement to technical specification, and document the data mapping from source system to target system. Design and execute test case.
• Coordinated between business, operation and IT for any data, financial and system issues. System set up for new product to ensure smoothly data flow from source to target system and document the process/data flow.
• Led Subway QSR (Quick Service Restaurant) new business project, define business process, analyze and leverage operation and financial data, create financial reporting model, achieve timely, accurate, and efficient reporting through automation.
• Participate company project and work as the accounting subject expert to define accounting process flow.
• SOX compliance: documented the Card Service and Subway financial data internal control process that feed to the Oracle financial system.

Servicing Accounting Analyst

Responsibilities:

• In a profit improvement initiative, established new process by researching the existing process, created a financial model to recognize servicing other income revenue from cash base to accrual base, increase revenue by 200K monthly.
• Liaison between loan Servicing (Loss mitigation, default, escrow service, foreclosure, and investor reporting) and Finance to resolve financial questions/errors.
• Coordinated and provided support to Loan Servicing managers in completing annual budgets and monthly forecasts.
• Hosted meeting and clarified requirement to create Confidential Reporting for Loss mitigation.
• Worked with IT, providing data to LPS system to keep track of incentive income.
• Maintained Servicing metrics and master schedule financial model.

Analyst

Responsibilities:

• Conducted Accrued Interest exception research and interest income reporting. Obtained extensive mortgage knowledge while performing this function, which include extension interest, loan modification, foreclosure, REO, short sale, curtailment, late fee analysis and accrual. Responsible for interest method stratification reporting and discount amortization.
• Supported financial planning and collection by providing delinquency report, which categorized delinquency status into different bucket, achieved accuracy and efficiency.
• Supported IT department by providing file fix such as flow incentive, pending record, tested and validated the correctness of the files before they were hard coded into production system.
• Booking General Ledger rejects entry.