Oracle Pl/sql Developer Resume
Jacksonville, FL
SUMMARY:
- Senior Database Developer An experienced self - starter with strong analytical skills, I have been a software developer for 25 years, specializing in relational databases and languages especially Oracle PL/SQL and elaborate SQL reporting using COGNOS tools.
- Currently at Confidential on a short term contract as a PL/SQL developer.
- My most recent prior position at Blackberry was as a BI report developer on EDW (Oracle and Neoview databases) utilizing Cognos tools, SQL and PL/SQL.
- For prior thirteen years I was employed with Confidential as a senior PL/SQL developer involved in full-cycle development of new applications from feasibility studies, data mapping, data analysis, with involvement from business requirements to writing technical design specifications to code development, testing, loading and finding data using PL/SQL, and supporting application once in production.
HARDWARE/SOFTWARE EXPERIENCE:
Languages: PL/SQL, SQL, Cognos, ORACLE PRO-C, java, Unix shell DBMS HP Neoview, ORACLE (11g, 10g, 9i, 9, 8, 7), Ingres
Hardware: UNIX, VAX, Linux
PROFESSIONAL EXPERIENCE:
Confidential, Jacksonville, FL
Oracle PL/SQL Developer
Responsibilities:
- Responsible for report development and report migration from Cognos 8 to Cognos 10 and also from SQL using Neoview to SQL and PL/SQL in Exadata.
- Same position and company (different company name) as July 2010 to August 2012 but as contractor instead of as employee.
Environment: and tools: Exadata database. Used cognos BI tools and PL/SQL to generate new reports and migrate old reports from HP Neoview to Exadata.
Confidential, Virginia Beach, VA/ San Diego, CA
Senior Oracle Report Developer / Budget Analyst
Responsibilities:
- Report development and budget analyst with CNSP. Temporary contracting position working for the US Navy in Coronado, CA.
Confidential, Alpharetta, GA
Senior Oracle Report Developer
Responsibilities:
- Responsible for report development and all related documentation including feasibility documents and operations notes, utilizing PL/SQL procedures, packages, etc.
- Working with Business Analyst to design reports analyzing cellular usage, providing profiles of users for carriers, etc.
- Run and maintain pre-existing reports and when necessary confirm results.
- Environment and tools: Oracle 11G databases and HP Neoview.
- Used PL/SQL in Oracle Developer to schedule and generate reports in Oracle and cognos BI tools or DBVisualizer to generate reports from Neoview.
- Windows platform.
Confidential, Alpharetta, GA
Technical Project Lead and Senior Software Engineer
Responsibilities:
- Responsible for all documentation including project schedule, design / system documents and turnover notes.
- Working with the DBA to create new database tables and/or changes to existing tables.
- Creation of all database load programs, lookup programs, database utilities and forms; manage code versions, ticket creation, code labeling, et al.
- Develop many prescreen applications using Oracle PL/SQL and PL/SQL Developer (or Toad), Oracle Forms and Pro-C as the primary tools.
- Creating utility shell scripts to load reference code table values using SQL or SQL Loader.
- Maintain pre-existing prescreen applications.
Environment: and tools: Databases Oracle 8 to 11G, Tools: PL/SQL Developer, Oracle Forms, SQLPlus, SQLLoader, Java Loader. Hardware: Windows, UNIX, Linux
Confidential, Norcross, GA
On-Call Oracle Support and DBA
Responsibilities:
- Responsible for supporting all Oracle calls from engineers and clients of DG.
- Trained to use DBA tools to install and maintain Oracle DB and applications.
- Oracle classes in Database tuning and data recovery