accountant

OBJECTIVE

Software and database engineer with accounting skills and advanced degrees in technical and business disciplines seeks accountant, financial analyst, IT auditor, or internal auditor position with a stable, growing company.

BACKGROUND

Professional with years experience as a software and application developer with proficiency in software design and development with C/MS-DOS, C/C++/Unix, Oracle, XML, SQL Server, Visual Basic, C#, ASP, Microsoft .NET, Java, Develop 2000, Financial 11i, Shell Script, JavaScript and JDBC.

Oracle Certified Professional Developer and Oracle Certified Professional Administrator. Completed training on all Oracle Financials modules.

About year of hands-on work experience with accounts receivables and payables, journal entries, general ledger account analysis, accounts payable management, and financial statement preparation. Preparing to take the CPA exam.

PROFESSIONAL EXPERIENCE

Telecheck Inc., Houston Sep. 2004 – Current

• As a team member participating on the Telecheck paper and electronic check payment settlement project migration, identified areas for improvement and subsequently tuned the Oracle database and application performance and created Oracle reports.

• Designed and developed TCK-TASQ server application to generate, receive and process xml files between Telecheck and TASQ companies.

• While participating in the Wal-Mart new collect project, designed and created Check_Repair_Report, Wal-Mart_Account_Report, Writeoff_List_Report and File_To_Wal-Mart using Oracle report and Oracle Reports Services.

• Participating in analysis, design and development of the Telecheck TRS billing system. Meeting business requirements and application performance, using Informatica, Oracle 10g application (Oracle Form and Report), java, and Pro C.

• Participating in analysis, design and development of Taxware and Telecheck interface application using Oracle Form and Oracle PL/SQL.

• Designed and developed loading Telecheck database data through Application Interfaces into Oracle Financial (OIC system) using Oracle PL/SQL and Form.

• Developed and enhanced Telecheck merchant system using Oracle PL/SQL, Form and Report.

Universal IT Consulting (Bankrupt), Houston Feb. 2004 – Jul. 2004

Designed and developed a Web based billing system using SQL Server, ASP.NET, and Crystal Reports. Designed and developed internal resume tracking system using ASP.NET and SQL Server 2000. Created, developed and debugged tables, views, indexes, stored procedures, functions and triggers for the application. Setup and maintained database system (including performance tuning, backup/recovery and physical and logical database design).

Handled all phases of accounting, A/R, A/P, Bank reconciliation, accruals, journal entries; sales invoices; monthly sales reports; monthly financial statements; profit and lost report. Reconciled and analyzed general ledger accounts using PeachTree accounting software.

Mary K Chiang & Company, CPA, Houston Jun. 2002 – Sep. 2002

Performed the daily duties of a tax accountant under the supervision of a CPA; prepared personal tax returns for clients of the firm using Lacerte Tax software; assisted in the daily operations of a CPA, with respect to client development. Other responsibilities included bookkeeping for the firm.

Silver Express, Houston Apr. 2002 – Jun. 2002

Responsible for designing and programming financial reports using Crystal Reports. Created database and form for inventory control and analyze system using VB and SQL Server 2000. Created and debugged stored procedures, functions and triggers for the application.

Cap Gemini Ernst & Young, Houston Oct. 2000 – Dec. 2001

• Analyzed and documented for Risk Management System (Form, Report, C and Pro*C).

• In charge of analyzing Enron Phoenix database disaster. Responsibility for database recovery. Established the escalation procedures and troubleshooting guide.

• Migration and conversion Report 1.1, 2.5 and Form 3.0/4.5 to Oracle v6i under both NT/Unix environment for Enron’s TAGG/ERMS system and database performance turning.

• In charge of creating reports for Enron Global Evaluation System. Based on business requirements, Wrote and debugged PL/SQL stored procedures, functions and packages. Used Asp and Xml posting the reports in the Web.

• Ordinary database maintenance, performance tuning, backup and recovery.

• Created new database in Sun Solaris environment following OFA principal.

• Configured listener.ora, tnsname.ora and sqlnet.ora file of the network.

• Performed recovery and hot backup by using Oracle RMAN utility.

• Refreshed test database periodically by using RMAN duplicate database feature.

• Database backup and recovery by using Oracle Export and Import utility.

• Loaded data to oracle database by using Oracle SQL*Loader.

• Created Partitioned tables and indexes.

Nucleus Corporation, Houston Sep. 1999 – Oct. 2000

• Developing and updating Nucleus energy trading system using Oracle and Visual Basic.

• Made modifications to the database structure according to user’s requirements and business concepts.

• Wrote and debugged PL/SQL stored procedures, packages and triggers; designed and developed client/server application user interface using Develop 2000 and VB.

• Prepared business reports using Oracle Reports.

• Responsible for designing and programming financial Account/Payable and Account/Receivable forms, reports and database triggers and packages in new release.

• Provided technical supports in program enhancement in all energy trading system modules (data management, power trading, gas trading, oil trading, accounting, derivative trading, and risk management).

• Refined program criteria, coding, testing and debugging programs. Generated various client-required reports.

EDUCATION

MBA with a concentrating on Finance and Accounting, University of Houston, Victoria, Texas

Finished accounting courses which required for CPA exam in HCC

MS in Electrical Engineering, Beijing Institute of Technology

BS in Optics Engineering, Beijing Institute of Technology

Trained in the use of Oracle Financial Management Release11 (General Ledger and Fixed Asset).

Trained in the use of Oracle Financial Applied Technology, Procurement (Purchase, A/P) and Order Fulfillment (Order, A/R, CM).

CERTIFICATIONS

Oracle Certified Professional of Developer;

Oracle Certified Professional of Administrator

Contact this candidate