Sr. Oracle Developer

Ye Cheng

(US Citizen)

Address: Edison, NJ

Phone: 732-***-**** or 347-***-****

Email: ***********@*****.***

Summary:

* Sr. Oracle developer with over 12 years experience with Oracle, Oracle RAC database, SQL-Server, Client Server design and development of large database application.

* Areas of expertise include: Systems analysis, design and development, database schema design (data modeling), database programming (SQL and PL/SQL stored procedure, package, trigger), performance tuning (tune SQL queries) and capacity planning.

* Client/server implementation, network connectivity issues and Software evaluation.

* Full system life cycle development.

* Experienced in providing solutions for database application development and architecture.

Technical:

Languages: SQL, PL/SQL (stored procedure, package and trigger), TSQL, SQL*Plus, Visual Basic, Pro*C, C/C++, JAVA, HTML, XML and Unix Shell.

Databases: Oracle 11g/10g/9i/8i/7, Oracle RAC 10g/11g, SQL Server 2005/2000/7, MS Access and dBase.

O/S: Unix (Sun Solaris 10/11 ,HP-UX 11), Linux (Redhat Linux 4.5/5.2, Oracle Enterprise Linux 4.6/5.2), Windows (Windows 2003/XP/2000/NT), VMS (VAX/VMS/OpenVMS 7.1/8.1).

Software: Oracle Developer Suite, Oracle Designer, Oracle Forms, Oracle HTTP (Apache), Oracle BI, Oracle Discoverer, Oracle Reports, Crystal Report, XML Publisher, OBIEE and Power Builder.

Tools: Oracle Utilities(SQL*Loader, Supplied Packages, Import and Export), ERwin, TOAD, SQL Navigator, SQL Developer, SQL*Plus and Change management software SVN or CVS.

Others: Tuning skills (AWR, tune SQL Query and Trace/tkprof), ETL development and Data Warehouse.

Professional Experience:

01/2006-present Sr. Software Engineer, eResearch Technology Inc. NJ

Project: Cardiac Safety & Logistics

Responsibilities: Database SQL and PL/SQL programming (stored procedure, package and trigger). Design and develop reports, Writing/tuning SQL queries and views, Technical documentation. Software tools involved are PL/SQL, SQL*Plus, TOAD, SQL Navigator, Oracle Reports Builder, Oracle 10g/11g database, Application server, and version control SVN/CVS.

Project: Cardiac Portal

Responsibilities: Database SQL and PL/SQL programming (stored procedure, package and trigger). Design and develop reports, Writing/tuning SQL queries and views, Technical documentation. Software tools involved are PL/SQL, SQL*Plus, TOAD, SQL Navigator, BI Discoverer, Oracle 10g/11g database, Application server, and version control SVN/CVS.

10/1998-12/2005 Sr. Oracle Developer, Forum Personnel Inc. NY

Projects: - Air Traffic Statistic System (ATSS) for Port Authority of NY & NJ.

- Business Expense Accounting Management (BEAM) for Port Authority

- Airfield Driver Permit System (ADP) for Port Authority NY & NJ

- Breach of Report System (BOR) for Port Authority NY & NJ

- Tenant System (TENANT) for Port Authority NY & NJ

Responsibilities: Application development, enhancement, upgrade and maintenance. Database SQL and PL/SQL programming (stored procedure, package, and trigger). Tune SQL, SQL queries and PL/SQL code. Upgrade and maintenance the application to web version. Software tools involved are PL/SQL, SQL*Plus, SQL*Loader, Oracle Forms/Reports Builder, Oracle 9i/10g database, & Application server, Oracle Enterprise Manager (OEM).

Projects: - Hustler Enforcement Activity Tracking (HEAT) for Port Authority of NY & NJ Police

- Employee Shift Scheduling Program for Port Authority of NY & NJ

Responsibilities: Application design, development, enhancement, upgrade and maintenance. Database SQL and PL/SQL programming (stored procedure and package). Tune SQL, SQL queries and PL/SQL code. Using Oracle 9i database and Visual Basic, Crystal Report, Power Builder on Windows to upgrade and develop the application from dBase III and Clipper on DOS to Windows platform. Unix shell scripts for application jobs on database server.

9/1997- 9/1998 Oracle developer, American Technical Resources Inc. VA

Project: - US IRS Chief Counsel CASE-MIS application system (in L'enfant Plaza, Washington D.C.)

Responsibilities: Development, debug and enhance the application system and Year 2000 change for IRS by using Oracle 7.2/3, PL/SQL, SQL*Plus, SQL*Form, SQL*ReportWriter and Designer 2000 on Unix and Windows NT. Tune SQL, SQL queries and PL/SQL code.

5/1997-9/1997 Oracle developer, MiTech Inc. VA

Project: - US Patent & Trademark Office Classifications Data System (in Crystal City, VA)

Responsibilities: Develop and upgrade Oracle application for US Patent & Trademark Office by using PL/SQL, Developer 2000, SQL*Plus, SQL*Form 3.0, Oracle 7.x on WindowsNT and Unix. Tune SQL, SQL queries and PL/SQL code.

8/1996-4/1997 Oracle developer, SAIC, VA

Project: - EPA Certification and Fuel Economy Information System (CFEIS) (in SDC of EPA, VA)

Responsibilities: Develop Oracle database application for EPA application by using Oracle Developer/2000, SQL, PL/SQL, SQL*Plus, for Oracle 7.x on Xwindow/Unix. Tune SQL, SQL queries and PL/SQL code.

Education:

Masters of Science Degree in Computer Science (MS), 1996

New York Institute of Technology (NYIT), New York, USA

Bachelors of Science Degree in Electrical Engineering, 1983

The Qinghua University, Beijing, China

Contact this candidate