OBJECTIVE

• A position in Database Development requiring proven analysis, creative and planning skills to ensure the safety and recoverability of corporate data and applications.

SUMMARY

• 20+ years of experience as an Oracle Developer experience involved in Analysis, Design, Coding, Testing, Implementation, Maintenance, and Production support
• Experience with Oracle 7, 8i, 9i, 10g, 11g, working as Oracle Developer and Oracle Consultant, developing back - end modules, such as packages, functions, procedures, triggers, object types, views, snapshots for multitier business applications in SQL and PL/SQL
• Good experience in documenting, testing, training and technical abstracting
• Extensively used PL/SQL, built-in Oracle Packages, stored procedures, functions, triggers, SQL Reports and UNIX shell scripts for processing data, enforcing referential integrity and needed business rules.
• Experience in Designer/2000, Developer 2000 with Forms 12c/10G/6i/6.0/5.0/4.5, Reports 10G/6i/6.0/3.0/2.5 and Oracle discoverer 3.0/3i/4i/10G.
• Experience in Business Analysis, gathering of business requirements, functional and technical specification writing.

TECHNICAL SKILLS

Databases: Oracle 7, 8i, 9i, 10g, 11g; HTMLDB, Oracle9i Application Server, Access 97, 2000.

Languages: SQL, PL/SQL, Oracle Forms 4.5,6.i, 9i, 10g, 12c Oracle Reports 3.0, 6i, 9i, 10g, ORACLE Designer/2000 (6.0, 6i), Oracle Portal 3.0, WEBDB 2.2, 2.1, Oracle WEB Toolkit, HTML, DHTML, XML, Java Script, Visual Basic, VB Script, UNIX, Shell Script.

Development Environments and Applications: SQL* PLUS, Developer 2000, TOAD, SQL Navigator, Reflection for Unix.

Operating Systems: UNIX SUN (E450, E4500, E10K, Sun Fire 480R, Sun Fire V890), AIX, and HP-UX11i, Linux, Windows XP, NT, 2000, 2003 and DOS.

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

Sr. Oracle Software Engineer

Responsibilities:

• Developed several stored procedures and functions to improve performance.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Created Financial and Statistical reports in Excel. Utilized Microsoft Excel to categorize previous financial reports into a detailed pivot table to develop an improved company financial strategy.
• Optimized existing business and code logic within SQL and PLSQL to achieve superior performance and reusability.
• Migration DB 11g from windows server to Linux
• Installed, configured Oracle 11g DB on Linux server.
• Worked in JIRA environment with Agile/scrum methodology.
• Developed the integration and data conversion processed for EBS.
• I nterviewed users to analyze their business requirements and recommend and design technological improvements to their business processes and operational procedures.
• Created project plans in accordance with project management framework standards and procedures. Identified ongoing issues and gaps within project plans, in order to eliminate implementation issues.
• Planned, facilitated and reported on quality assurance testing efforts.
• Was heavily involved in business process analysis of current business processes and provided recommendations for improvement

Confidential, Yardley, PA

Oracle Programmer/Analyst

Responsibilities:

• Designed the advance Oracle and PL, SQL queries, procedure, cursor, triggers and scripts.
• Created, enhanced and modified Oracle and SQL code in a high volume enterprise environment for Security Processes.
• Designed, coded and tested applications using Oracle Forms and Reports (version 10g).
• Enhanced and modified existing Oracle applications using the Oracle Developer tool set, including Forms, Reports and other applications.
• Interacted with various levels of the organization to gather requirements, develop system requirement definitions and produce system documentation.
• Develop Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions, Packages, Materialized Views, and Dynamic SQL.
• Participate in design reviews and code reviews, ensure unit testing and integration testing
• Perform performance tuning services for PL/SQL applications.

Confidential, Burlington, NJ

Oracle Programmer/Analyst

Responsibilities:

• Compiled existing user interface using Oracle Developer Forms 10g, participated in all phases of DB migration to 10g.
• Created user interactive reports using Oracle's Discoverer 4i in order for users to manipulate data and display information over the intranet.
• Analyze processes, procedures and practices, develop and implement system solutions to meet business needs and customer requirements, including project design, tuning, testing, auditing and documentation.
• Create new and enhance existing user interface using Oracle Developer/2000 Forms 6I, modify and design procedures and functions including Stored Subprograms and Database triggers using PL/SQL, SQL and SQL*Plus programming languages, support systems conversions and upgrades.
• Create new and modify existing Database procedures, functions, packages and triggers using PL/SQL, SQL*Plus, SQL Navigator, TOAD and UNIX.
• Participated in code reviews, develop Test Plans, quality assurance and audit trails for new and existing projects. Responsible for various Oracle Central Distribution Database changes (creating and altering tables, creating new indexes to speedup retrieving of information from Database by Forms and Reports; creating new Roles to implement menu security. Developed and maintained Front Ends for Central Distribution center using Forms 4.5 and 6I. Create custom application for user using Java, Java Script, and PL/SQL.