Manager Ms

VINCENT CHENG

*** ********* ****, *********, ** *7450

Home: 201-***-**** E-Mail: **********@*******.***

TECHNICAL SKILLS

Database MS Access, Oracle 8i/9i/10g, SQL Server

Language Macros, VBA (Access Programming, Excel Programming and Power Point Programming), MS-DOS Command Batch Scripts, SQL and PL/SQL

Operating System Window 98/2000/XP/Vista/7/10 and UNIX

Other Partner Form Tool, eCAPs, eCAPs Local, MS Office 97/2000/XP/2003/2007, Netscape, Internet Explorer, Outlook, LOTUS Notes, SQL*Plus, SQL Navigator, Toad, Open Database Connectivity (ODBC), and Captiva.

EXPERIENCE

Ernst & Young U.S. LLP (EY), New York, NY

Manager, Tax Technology 5/14 to Present

Update and maintain Partnership K1 Suite: In-house developed MS Excel Base application.

Conduct UAT on Aggregate Module (Web-based application) and provide recommendation to the development team.

Lead and manage teams to develop/maintain projects on Captiva to increase the efficiency of reconciliation between PDF and GoSystem.

Create Folder Creation Tool and Multi Directory Watch tool for Captiva process.

Lead and manage teams to support multiple engagement teams: Review the deliverables and ensure the quality meet the highest standards.

Review engagement processes and provide recommendation to automate the process and increase efficiency and reduce error prone.

Build expenses tables/views on SQL server and analyze the data for Power BI reports.

KPMG LLP, Montvale, NJ

Manager, Tax Technology 12/07 to 4/14

Generated and maintained partners’ population for current tax year and performed UAT testing for tax affidavit application (Web-based).

Analyzed, prepared and allocated firm incomes and expenses to individual partner (utilize MS Excel vlookup, sumproduct, Pivot Table and VBA programming).

Developed and maintained MS Access database to collect, analyze and calculated tax data and prepared/created supplementary schedules (Reports) for composite tax returns.

Performed calculation and generation of Federal and twenty-four Jurisdictions’ K1s and supplementary schedules (utilizing MS Excel, MS Access and VBA programming).

Managed and helped ensure data integrity and consistency during electronic processing and calculation processes.

Established new process to increase efficiency and accuracy of current process. For instance, invented system collate pdf documents to replace manual process.

Performed documentation of current and future processes.

Served as a liaison between information (IT/MIS) partners and tax administration group for testing and production deployments.

J P Morgan Chase, Iselin, NJ

Operation Technology Supervisor 8/02 to 12/07

Analyzed and prepared internal financial reports (P&L) for management (utilizing MS Excel vlookup, macros and VBA programming).

Analyzed and prepared P&L budget and forecast statement through the use of MS Excel Chart (Water Fall Chart), Macros and VBA.

Analyzed and prepared loan officer commission statements through the use of MS Access tables, queries, forms, reports and VBA.

Analyzed and prepared fixed assets depreciation statements (utilizing MS Access tables, queries and forms and reports).

Designed, developed and maintained database application in MS Access including create tables, relationships, queries, Graphical User Interface (GUI), reports, macros and modules.

Provided data analysis and built SQL queries, stored procedures and reports (utilizing MS Access and Oracle).

Performed planning and managing database and application updates (update MS Access 97 to MS Access XP – DAO Jet Engine to ADO Jet Engine).

Provided daily operation support and performed trouble-shooting of MS Window XP and MS Office.

Provided continual support to accounting and operating team members for their needed of new database and automatic financial reconciliation process through the use of MS Access and MS Excel.

Served as a liaison between information (IT/MIS) partners and access administration group for testing and production deployments.

J P Morgan Chase, Iselin, NJ

Control Log Administrator 7/00 to 8/02

Maintained Oracle multi-companies’ database (Oracle 8i) for over 1200 Balance Sheet accounts (All departments).

Analyzed and prepared Balance Sheet accounts reconciliation statements and consolidation statements (utilizing MS Access database).

Analyzed accounts variance between corporate system and general ledger system through the use of MS Excel vlookup, pivot table, macros and functions.

Performed upload data to Oracle database via SQL loader.

Verified financial database integrity as well as performing UAT (User Access Testing) for system redesign and planned upgrades.

Resolved any audit exceptions with both internal and external auditors.

Bristol Myers Squibb, New Brunswick, NJ

Financial Analyst 9/99 to 6/00

Analyzed actual inventories on hand to budget and forecast as well as providing commentaries to senior management.

Performed monthly reconciliations for all balance sheet accounts between general ledger and sub-ledgers.

Assisted in the preparation and distribution of monthly internal financial statements.

Prepared journal entries for month-end close.

Reconciled inventories on hand in SAP system vs. inventories in mainframes system.

Foremost International Trading, East Hanover, NJ

Staff Accountant 8/98 to 4/99

Performed monthly on-hand inventory analysis and provided recommendations for inventory purchases.

Conducted year–end physical inventories as well as documentation of counting procedures and results.

Responsible for reviews of add-on cost to inventories by units, weight and cost.

Negotiated merchandises price and freight cost with vendors

Handled all insurance claims and filings for damaged inventories.

EDUCATION

Richard Stockton State College, Pomona, NJ

Bachelor of Science – Accounting, Aug 1997

LANGUAGE SKILLS

Fluent in reading, writing and speaking Chinese included both Cantonese and Mandarin (Putonghua).

Contact this candidate