Oracle Database Developer Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

David  Li

309 98^th Street, Apt #5P

Woodhaven, NY 11001

Tel: (646) 339-1230

Email: david@hotmail.com

OBJECTIVE: Oracle PL/SQL Developer / Application Developer / Production Support

SUMMARY

• Certificate of Oracle Apex 3.0: Developing Web Application
• Certificate of AS Portal 10g R2: Building Corporate Portals Ed 1
• Certificate of AS Portal 10g R2: Building Portlets with PL/SQL Ed 1
• Sun Certified Programmer for the Java 2 Platform 1.4
• Working experience in full phase development of Software Development Life Cycle (SDLC) including analysis, design, coding, testing, documenting and deployment
• Strong experiences in Oracle PL/SQL Stored Procedures and functions, Oracle Web Applications, Java Web Applications, maintain, support and troubleshooting existing applications
• Working experience in Data Modeling and Database Design
• Working experience in Oracle Portal, Oracle APEX, Oracle Portlet with PL/SQL, Oracle Form, Oracle Report
• Apply software changes to enhance performance, and execute a full range of testing plans including unit tests, integration tests, regression tests, system tests.
• 3-Tier Production Support experience on Java Web Apps and Oracle Web Apps
• Highly motivated and quick self starter personality
• Willing to work independently and cooperatively as a team player in a group
• Good communication in speaking, reading and writing English
• Strong desire to learn new knowledge and skills in the field of IT

TECHNICAL SKILLS

Languages:                   SQL, PL/SQL, Oracle PL/SQL Web Toolkit, Java, JSP, PHP, Javascript, HTML, XML, CSS, UNIX Shell Scripting

Operating System:                      Windows 2003 / XP / 7, Linux Solaris OS                        

Web Development:                      HTML, CSS, XML, JavaScript, Ajax 

Application Servers:        Oracle Application Server, Tomcat, Web logic

Databases:                                 Oracle 10gR2, MySQL, SQL Server

Framework:                               Struts 1.2, Hibernate 3.1, JSF 1.2, Ajax

Development Tools:       SQL Developer, Toad, JDeveloper, Eclipse, MyEclipse, Dreamweaver, Oracle Apex 4.0, Oracle Portal, Oracle Form, Oracle Report, UML. ClearCase, ClearQuest, CVS, Subversion, Putty, WinSCP

EDUCATION / CERTIFICATIONS

• Certificate of Oracle Apex 3.0: Developing Web Application (2010)
• Certificate of AS Portal 10g R2: Building Corporate Portals (2009)
• Certificate of AS Portal 10g R2: Building Portlets with PL/SQL (2009)

• Sun Certified Programmer for Java 2 Platform (SCJP) (2008)

• M.S. -Information & Library Science, CUNY-Queens College (2007)
• Microsoft Certified Systems Engineer (MCSE) (1998)       
• B.S. Computer Science, Lanzhou University (P. R. China) (1985)

WORK AUTHORIZATION

• US Citizen

PROFESSIONAL EXPERIENCE

Graphnet Inc.  New York, New York

Duration: 03/2011- 08/2011

Role: Oracle Database Developer / Production Support

Project: Unicom

Description:

Unicom is a typical Java Web Application; it provides a comprehensive e-solution for corporation to integrated messaging. Providing email, fax and SMS broadcast, as well as point-to-point services, meanwhile it provides corporate users with an efficient method to reach thousands of recipients simultaneously through a simple web browser!

Unicom is comprised of Apache Server, Tomcat Server and Oracle Database Server running on Linux Solaris OS.

Responsibilities:

• Debug existing PL/SQL procedures and functions to fix bugs
• Develop new PL/SQL stored procedures and functions
• Develop new XML parser to produce online reports 
• Develop daily, weekly, monthly reports using shell scripting and crontabs
• Provide Oracle Java Web Apps and Database Production Support
• Fix and troubleshoot all kinds of production issues on a daily basis
• Update database contents upon Apps Engineer’s request
• Perform PL/SQL tuning and database tuning under the direction of DBA
• Create new Tables, Views, Indexes, Types, Triggers, Packages, Procedures, and Functions for new functions.
• Participate in peer-to-peer code review and new apps evaluation.

Environment:          Windows 7, Solaris OS, Apache Server, Tomcat Server, Oracle database 9i/10g/11g, Toad, SQL Developer, SQL Plus, Eclipse, Java, PL/SQL, Unix Shell Scripting, Reports, CVS, Putty, Win SCP, Microsoft Office Suite, VPN

Barnard College, Columbia University.  New York, New York

Duration: 03/2009 – 02/2011

Role: Oracle Web Application Developer / Production Support

Project: eBear, Oracle Apex, Oracle Portal

Description:

eBear is an Intranet Portal owned by Barnard College which allows Barnard faculties/staffs, students, and administrators to access internal online resources not available to the general public. eBear is personalized to present each user with unique and relevant academic, administrative and support resources. eBear is comprised of HTTP Web Server, Oracle Application Server and Oracle Database Server and running on Linux Solaris OS.

Responsibilities:

• Develop new apps for eBear Portal Intranet System
• Develop new Apex apps for Customer’s Reports
• Develop new PL/SQL Portlets for Oracle Portal Apps
• Development From scratch to deployment including Requirements Analysis, Tech Spec Translation, Coding, Testing, Deployment and Documents.
• Develop Web-based Front-End and Back-End components using Oracle Web toolkit, PL/SQL, 
• L, Javascript and CSS for new apps
• Develop Data Modeling and Database Design for new apps
• Create Tables, Views, Indexes, Packages, Procedures, Functions, Types and Triggers for new apps.
• Perform PL/SQL tuning and database tuning under the direction of DBA
• Update web contents for existing apps upon request
• Install and configure ODBC to implement access to Oracle Database from Microsoft Office Suits
• Participate in peer-to-peer code review and new apps evaluation.
• Provide multi applications support in production environment including eBear Oracle Apps, legacy Java Apps and Access Apps

Environment:          Windows 2003/XP, Linux Solaris OS, HTTP Web Server, Oracle database 10gR2, Oracle Application Server 10g, Oracle 10g Portal, Oracle Apex 3.0, Toad, SQL Developer, SQL Plus, Oracle PL/SQL Web Toolkit, Java, Javascript, PL/SQL, Unix Scripting (C Shell), Dreamweaver, Subversion, Putty, Win SCP (FTP), Microsoft Office Suite, VPN

Vecna Technologies, Inc.  College Park, Maryland

Duration: 08/2008 - 11/2008

Role: Software Engineer / Production Support

Project: QC Pathfinder

Description:

QCPathfinder is a Healthcare project, developed by Vecna Technologies, Inc. It uses live data feeds from all kinds of hospitals, healthcare services facilities, microbiology lab, pharmacy, surgical, radiology, critical care to track patterns that suggest an outbreak or unusual occurrence of a particular organism before the outbreak occurs. QC PathFinder employs Health Level 7 (HL7) ANSI-accredited standards as its primary standards for electronically exchanging, defining and administrating clinical, pharmacy and lab data in the healthcare industry.

QCPathfinder is a web-based Java application, it employs MVC design pattern, using Java, Spring, Struts, Tiles and Hibernate framework and Database Access Objects like Hibernate, along with PostgreSQL and Oracle databases, deployed on Tomcat Application Server.

Responsibilities:

• Perform existing Data Transformation from PostgreSQL and Oracle
• Create new databases on Oracle
• Create PL/SQL scripts to transform data from PostgreSQL to Oracle 
• Rewrite and test stored procedures, views, triggers and indexes on Oracle database
• Deploy QC PathFinder application to Tomcat Application Server, create and configure PostgreSQL and Oracle 10g Database
• Develop, test and configure customized HL7 Data Transformation Parser into QCPathfinder using Java, Javascript, SQL and XML Mapper for each hospital/Health Care center.
• Upgrade the existing application to new released application and migrate databases as needed.
• Troubleshoot QC Pathfinder application and create enhancements.
• Participate in peer review and client’s sample data validation
• Provide production support

Environment:          Linux CentOS, Java, Javascript, JSF, Spring, Struts, Tiles, Hibernate, JSP, Servlets, XML, SQL, PostgreSQL 8.0, Subversion, Oracle 10g database, Tomcat, Eclipse, SQL Developer, Shell script, Subversion (SVN)

Computer Science Corp.  Hanover, Maryland

Duration: 08/2007- 07/2008

Role: Java Programmer

Project: Coordinated Highways Action Response Team (CHART)         

Description:

CHART is a Maryland State Government Project, administered by the Maryland Department of Transportation, Maryland Transportation Authority and Maryland State Police. It intends to improve "real-time" operations of Maryland's highway system through teamwork and technology.

CHART project is a Web-based Java application using CORBA as its base architecture to distribute objects between different platforms and remote locations, along with other J2EE technologies like Servlet, XML parser and Web development technologies like Javascript and ASP to implement real-time data collecting, storing and broadcasting  across over Maryland State. It consists of a Public

an operational front-end web-based Java application and a back-end Java-based Window-Service application to provide all kinds of real-time traffic events, road condition information etc. to the public and administrator.

Responsibilities:

• Developed and maintained the existing Web-Based Java application including writing new back-end Java code, PL/SQL stored procedures, triggers scripts and revising existing back-end Java code and PL/SQL scripts to meet the new requirements, troubleshoot the runtime error and fix the bug.
• Participated in the analysis of user requirements, design details peer review and database peer review, translate user requirement into design details (User Cases, Class diagram and Sequence diagram) and the design of new tables, triggers and stored procedures for Oracle database and MS SQL database
• Developed the new back-end TrafficOpenEvent Module classes and corresponding PL/SQL stored procedures and triggers scripts in R3B2 Release
• Traced and fixed bug in existing release R3B1
• Create new tables, views, triggers, stored procedures and triggers for R3B2 Release
• Modified ANT Build Scripts for the new release deployment
• Generated and performed PL/SQL Unit Testing cases, Java Unit Testing cases, Integrating Test Plan and other Technical documentation upon User Requirements and Design Details
• Deployed and configured the overall application to Tomcat and Windows 2003 Server, migrate the database as needed
• Provide production support

Environment: Windows XP/2000/2003, Java, Javascript, JSF, ASP, Struts, Tiles, Hibernate, JSP, Servlets,

       XML, Corba, Oracle Database, MS SQL, Tomcat, Eclipse, ClearCase, ClearQuest, TAU, TOAD, SQL

       Developer

Readonweb LLC.,  Greenbelt, Maryland

Duration: 07/2006 - 07/2007

Role: Java Developer

Project: Readonweb

Description:

Readonweb is a Web-based toolbar application which will extract and display the main content of a web page with all of the extraneous information removed

Responsibilities:

·          Involved in the analysis of User Requirements, Design Details and the Database Design

·          Developed the Readonweb website using Java, Javascript, HTML, CSS, J2EE such as Struts 1.2, Servlet, Hibernate 3.1 framework and MySQL, including implementing new user registration process, user login validation, user profile preview, search engine and data access object to/from MySQL dartabase.

·          Created new databases scripts including tables, views, stored procedures and triggers.

·          Deployed and configured the overall application to Tomcat and MySQL

·          Provide production support

Environment: Java, Javascript, PHP, Struts, Tiles, Hibernate, JSP, Servlets, XML, MySQL, Tomcat, Eclipse, CVS, SQL Developer

Karman International Inc., Flushing, New York

Duration: 04/2002 - 04/2006

Role: Web Developer

Project: OnlinePhoneCard

Description:

OnlinePhoneCard is a B2C project, which provided customers many features like open an account, buy prepaid phone card, make payment via Paypal, check the balance of designated Pin #, and deliver the pin # via email etc..

Responsibilities:

·          Identified the architecture and technologies needed by B2C website for company’s online business with the functionality of Paypal online payment method and transaction of pin # instantly via email.

·          Implemented the project using HTML, CSS, ASP, Javascript, PHP and MySQL.

·          Monitored the performance of system and the traffic volume of incoming calls on the daily basis.

·          Performed the trouble-shooting and the test of call routing via remote IP upon the request.

·          Administrated the billing system, setup, close, and updated customer accounts

·          Provide production support

Environment: Windows XP, HTML, CSS, ASP, Javascript, PHP, Dreamweaver and MySQL

Download Resume Format