Jiahui Lu Email & Phone Number

Texas, United States

San Francisco, California, Us

San Francisco, California, Us

Dallas, Tx, Us

• Maintain IT SOX security, hierarchies, business process rules, validation rules, and custom reports in Workday and other financial systems• Work on IT/system projects related to financial accounting and shared services• Develop/maintain SQL queries for automation and ad-hoc reports/analysis• Create custom reports and formulate financial systems to parallel overall business strategies• Assist with integrations between systems• Support Trintech's Cadendy product with Match, Certification, and Monthly Close

Frisco, Tx, Us

• Reconcile transactions by comparing and correcting data between systems• Provide initial Sage Intacct training for company users in Finance, Operations, Project Managers, and Sales• Configure Sage Intacct to meet business needs after rollout, including fields, invoice layouts, page layouts, workflows, approvals, smart events, dashboards and statistical financial reports• Enhance existing functionality and improve processes• Develop, test, deploy customizations, custom objects, and new system functionality based on evolving business needs• Design and execute special data queries, commission reports, system reconciliations, and financial analysis via SQL• Developed and documented solutions for business products and systems

Frisco, Tx, Us

• Implemented Sage Intacct and ensured accurate migration of data from Quickbooks and FinancialForce• Assisting General Ledger data integration from ADP Workforce Now to Sage Intacct• Prepare financial statements, accruals and journal entries, inter-company entries, maintaining reconciliations for all balance sheet accounts in accordance with generally accepted accounting principles• Perform periodic accounting and financial reporting• Responsible for monthly utilization reports along with resource allocation and analysis• Providing system, accounting, process, and controls support and oversight to the project management team during all aspects of a project’s life cycle• Preparation of project related monthly forecasts, budgets and financial reports• Providing analysis of financial results (trends, performance metrics, benchmarks)

Dallas, Texas, Us

• Developed business rules and designed SDLC charts for new ERP system implementation• Streamlined data migration process for new ERP system (Sage Intacct) by manipulating MS Excel data import templates• Reconciled reports across systems to make sure data consistency and troubleshot contract module• Performed monthly billing and resolved billing issues by optimizing SQL queries• Analyzed sales contracts to ensure revenue is recorded in compliance with US GAAP, specifically ASC 606

Dallas, Tx, Us

• Worked with project team to identify, collate, document and communicate the data migration requirements• Performed source system data analysis to manage source to target data mapping using MS Excel• Performed migration and testing of static data and transaction data from one core system to another• Performed data migration audit, reconciliation and exception reporting

Plano, Texas, Us

• Retrieved and processed bank statement for customer database and performed bank reconciliation• Communicated data issues with customers, team leaders and bank representatives• Solved out of balance account issues and invalid data mappings

Master'S Degree, Computer Science (Omscs)

Master'S Degree, Information Technology Management

Master'S Degree, Accounting