Sql Server Oracle
Resume:
Meiwen Wang
Email: *********@********.***
Address: ***** ******* **
City: Austin
State: TX
Zip: 78726
Country: USA
Phone: 512-***-****
Skill Level: Experienced
Salary Range: $65,000
Primary Skills/Experience:
See Resume
Educational Background:
See Resume
Job History / Details:
MEIWEN WANG
11101 Calavar Dr.
Austin, TX 78726
*********@********.***
OBJECTIVE Sr. Revenue and Reporting Analyst
SKILLS SUMMARY
Equally effective working in self-managed projects or as a team member
Ability to adapt quickly to challenges and changing environment
Ability to improvement AR/Fixed Asset modules in ERP system
Excellent interpersonal and organization skills
Strong work ethic with high degree of accuracy and attention to detail
TECHNICAL COMPETENCIES
Applications and Software's: Oracle Financials, Hyperion Essbase, Hyperion BI, Oracle Discoverer, Monarch, ADI, TOAD, Excel, PowerPoint, Word, Access, SQL Server BI with SSIS/SSRS package
EXPERIENCE
03/08 - Present Revenue Analyst, Level (3) Telecommunication
* Prepare revenue, deferred revenue, amortization of prepares, reserve, ect.. journal entries during the month end
* Perform month over month revenue, reserve and collectability variance analysis
* Reconcile account receivable and reserve accounts monthly and prepare audit schedules in support of the quarterly auditing
* Perform reserve adequacy test monthly using Excel financial modeling
* Presentation revenue actives monthly by PowerPoint with graphs and charts
* Perform reserve rates on quarterly basis by collectability with certain assumptions through SQL server SSIS BI package
* Analyze discrepancies on line items in revenue data and worked closely with functional managers to determine solutions and assist with budget and forecast reserve
* Provide ad hoc reports through Hyperion Essbase as needed
* Organize data with pivot tables, charts and dashboards, macros, capture and validation
* Develop Access application with SQL server back end for ICC revenue reporting, customer query information and reserves, net AR balance, etc. all in one place
* Analyze, create or run various SQL scripts through TOAD to assist in revenue issues and questions for auditor or internal request
05/06 - 03/08 Senior Accountant, Rainmaker System in Austin
* Implemented fixed asset module in Oracle, so all data kept in excel sheets for fixed asset, prepaid and intangible stored in Oracle system and reduced human errors
* Created and maintain consolidated financial reports from Oracle GL
* Prepare various journal entries during the monthly close
* Balanced & reconciled inter-company accounts
* Monthly operating bank and credit card accounts reconciliation and historical research of outstanding checks and credit card dispute
* Managed fixed assets, prepaid and intangible accounts maintenance and amortization from sub- ledger to the general ledger and performed reconciliation for them monthly
* Assist in capital budgets and project depreciation
* Prepare schedule for quarterly and annual audit
* Researched and resolved discrepancies when needed
* Created and maintain consolidated financial reports from Oracle GL
04/01 - 05/06 Accountant, Xerox at Austin Division, TX
* Responsible for assigned month-end journal entries
* Responsible for reconciliation inventory accounts
* Responsible for all bank account and credit card online reconciliation
* Balancing inter-company accounts during monthly close
* Responsible for documentation of accounting procedure
* Responsible for reconciliation of inventory accounts in Oracle GL with sub-ledger
* Analyze and research variances of standard and actual cost in inventory module
* Analyze for expenses charged from headquarter and intercompanies
* Developed Access application: USGLExpenses Charge system
* Created and modify financial report's structure in Oracle
* Certified for Lean Six Sigma
* Team member of Sarbanes-Oxley Compliance
03/00 - 03/01 Financial Analyst, Presbyterian Hospital of Plano, TX
* Reconcile and analyze for TSI monthly and annual processes (volumes, GL, payroll)
* Responsible for resolving volume and GL/payroll rejects
* Responsible for statistical analysis reports
* Responsible for budgeting and forecasting expenses modeling process
* Analyze MoM actual expenses and MoM actual vs. budget/forecast
* Prepare of annual budget and forecast by gather, model, analyze, and summarize information
* Analyze missing encounter information by setting up qualifications report
* Assist in budgeting revenue and expenses modeling process
* Developed crystal report of Var-310 Job Code & Mdl-510 Format reports
* Use SQL to maintain and improve Access database of doctors' block time
11/98 - 03/00 Staff Accountant, Waugh Enterprises, Inc. Dallas, TX
* Prepare various month-end entries
* Prepare and edit financial statements
* Analyze and reconcile GL accounts, bank accounts and credit card activities
* Responsible for monthly and year-end audit with external auditor
* Reconcile fixed asset and inter-company accounts
* Developed Access application : Labor/Merchandise transfer system
* Developed VB application : Tracking outstanding checks
* Developed Access application : Tracking employee's vacation time
06/95 - 11/98 Accountant, McCue & Lee, Law Firm, Dallas, TX
* Post client's receipts & monthly billing
* Responsible for monthly and annual close
* Prepare financial statements and reconcile bank statements and client accounts
* Responsible for time and billing analysis reports
* Assist in the annual budgeting process
EDUCATION Oklahoma State University, Stillwater, OK. 01/94 - 05/95 GPA 3.53
Shanghai University of Finance and Economics, Shanghai, P.R.C., BS degree in
Accounting, GPA 3.4, 07/86
Contact this candidate