Lead Oracle Developer Resume
Saint Petersburg, FL
SUMMARY:
- 13+ years of experience as an Oracle - Certified Professional as Lead Developer, Batch Developer, OBIEE Developer, Forms Developer
- Former Oracle University Instructor Data architecture of both OLTP and OLAP environments Strong ETL and Batch Processing experience Oracle Development Expert familiar in many of latest Oracle features OBIEE architecture and development SQL expert with ability to write very complex queries against
- OLAP and OLTP Shell Scripting Expert in using latest Oracle features to encrypt data at rest using VPD policies and various encryption algos Extensive experience in Agile and SDLC Performance Tuning including on Exadata 11gR2 Golden Gate, Exadata, RAC, Oracle Data Integrator, Active Data Guard
- Diverse industry experience across insurance, government contracting (DOD), agriculture, financial, consulting, manufacturing, and construction materials
TECHNICAL SKILLS:
Operating Systems: Windows 95/98, Windows 2000/NT, Windows XP/XP Pro, and Linux/Unix
Languages: SQL, PL/SQL, Ruby, ActionScript, Shell, HTML, XML, Java, UML, SQR, html, PHP, Jave
Databases: Oracle 7.x/8.x/8i/9i/10g/10g/11g, MS-Access, MS SQL Server 7.0
Application Development: Forms 4.5/5.0/6.0/6 i/9i/10g, Reports 2.5/3.0/6.0/6 i/9i, Designer 2000, JDeveloper 10.1.3, Adobe Flex 3
Revision Control: SCCS, RCS, Subversion (Eclipse), TFS
Reporting: Oracle Reports 6.0/6i/9i, COGNOS Report Studio 1.1, Query Studio 1.1, Crystal Reports, OBIEE 10.1.3.4, BI APPS
Utilities: SQL*Loader, Oracle Data Integrator 11g, Oracle Golden Gate 11g, Active Data Guard, TOAD, Vi Editor, SQL Navigator, PL/SQL Developer, SQL Developer, Procedure Builder, Raptor, APPWORX Batch Scheduling, Eclipse, Informatica, Erwin, Control-M, Visual Studio
Application Servers: Oracle 9iAS/10g
PROFESSIONAL EXPERIENCE:
Confidential, Saint Petersburg, FL
Lead Oracle Developer
Responsibilities:
- Created and Responsible for ETL process replicating entire Financial OLTP system and all reporting via BI
- Utilize latest Oracle features to maintain data securitization per PCI standards
- Utilize indices, partitions, and tuning to optimize database performance
- Advanced PL/SQL development using many of the latest Oracle features
- Entire system development lifecycle from requirements gathering through development and testing
- Creation and implementation of best PL/SQL coding practices for the development team
- Code reviews for junior and senior developers
- Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool
- Ad hoc and advanced reporting using analytics
- Utilize many new database features such at Edition - based redefinition, bpd policies, virtual columns, etc.
- Implemented a sales tracking rules engine that enhanced gross sales volumes by over 5%
- Tuned queries for over 25 reports with average report runtime improvement of over 75%
- Developed and implemented new ETL process for all relevant data from our OLTP system of record
- Led database development of globalized database for a Globalized implementation
- Lead Data Architect on corporate wide initiative - Amex Wallet
Environment: Windows 7 Professional, LINUX, Autosys 11.3, Oracle Data Integrator, XML, Golden Gate 11g, Sun Solaris, Oracle 11g release 2 RAC, OBIEE 10.1.3.4, BI APPS 7.9.6, SQL Plus, PL/SQL, Vi Editor, TOAD, Erwin
Confidential, St. Petersburg, FL
Senior Reporting Developer
Responsibilities:
- Team member supporting the OBIEE environment used to report all Retek (RMS) data
- Led small and intermediate size projects
- Specific Responsibilities include:
- System maintenance and enhancements supporting business needs
- ETL process refinement utilizing PL/SQL, pro*C, and Shell Scripting
- Responsible for the entire system lifecycle: Requirements gathering through testing and maintenance
- Implemented integration of 10+ disparate data sources into our ETL process
- Received recognition for role in 10gR2 upgrade project which included many application enhancements
Environment: Windows XP Professional, LINUX, XML, OBIEE, Informatica, Data Warehouse, Oracle: Forms 10g, Reports 9i/, 10g Application Server, Database 10gR2, SQL Plus, PL/SQL, SQR, Vi Editor, Pro*C, TOAD, UML, PL/SQL Developer, pvcs, MQ Series
Confidential, Denver, CO
Lead Oracle Developer
Responsibilities:
- ETL process for all expense reporting and auditing data Ongoing maintenance of Data Warehouse containing all Financial Information
- System maintenance and enhancements supporting business needs
- Effective multi - tasking and management of maintenance requests and customer expectations
- UI Development utilizing: Oracle Forms/Reports 10g, html, Ruby on Rails, and Adobe Flex
- Database development utilizing PL/SQL, Ruby, SQR, and Shell Scripting
- Responsible for the entire system lifecycle: requirement gathering/Data-Modeling through testing and maintenance
- Responsible for preeminent customer service for both Technical Liaisons and users
- Responsible for co-workers and junior developers in Oracle Forms and Adobe Flex
- Technical Team lead on successful implementation of a redesigned/re - architected Underwriting System
- Received recognition for the implementation of a new automated auditing process
- Received recognition for developing a solution to download and process (EFT) all Pinnacol Expense reports
Environment: Windows XP Professional, LINUX, Oracle: Forms 9i/10g, Reports 9i/, 9i/10gApplication Server, Database 10g, SQL Plus, PL/SQL, SQR, Vi Editor, TOAD, UML, PL/SQL Developer, Adobe Flex, Eclipse, ETL
Confidential, Boulder, CO
Oracle Instructor (Part-time)
Responsibilities:
- As the primary instructor for the Oracle Developer Track (Oracle University), my responsibilities include: Adapting course lectures and content to maintain relevancy for students of varying learning aptitude
- Instruction of Oracle 10g SQL, Oracle 10g PL/SQL, and Oracle Forms/Reports Developer 10g
- Lecture Preparation
- Delivering course content to students in an understandable manner utilizing numerous real - world examples
- Evaluation of students in their progress throughout the course and providing individualized attention as needed
- 100% of my students that have attempted the various Oracle exams have passed on their first attempt
- Received on-going, positive student recognition
Confidential, Greeley, CO
Development DBA/Architect
Responsibilities:
- Responsible for the performance of the Database which included using OEM to monitor Database performance and tune as necessary Responsible for installing Oracle patches and rman backups
- Team lead for the development of custom Oracle - based application inclusive of the entire software development lifecycle including:
- Requirements gathering
- Data architecture
- Database development including: Stored Packages, Tables, Database Triggers, Indexes, Scripts, Views, and Materialized Views
- Oracle Forms 9i development
- Oracle Reports 9i development
- Ongoing maintenance and enhancement of both user interfaces, business intelligence tools, and data structures
- Responsible for maintaining Sarbanes-Oxley compliance
- Worked independently with customer base to provide alternative and acceptable solutions to other mission-critical Oracle applications
- Instrumental in successful completion of Sarbanes-Oxley internal audit
Environment: Windows XP Professional, LINUX, Oracle: Forms 9i/10g, Reports 9i/, 9i/10g Application Server, Procedure Builder, Database 9i, Designer 9i, SQL Plus, Discoverer, PL/SQL, TOAD, UML
Confidential, Morrison, CO
Oracle Programmer Analyst
Responsibilities:
- Application development in Oracle Forms 9i and Reports 9i inclusive of the entire software development lifecycle
- Created Procedures, Functions, and Packages using PL/SQL
- Wrote various scripts to create tables, functions, stored procedures, triggers, indexes, and views
- Sales and Customer support for Rosler hardware and proprietary WinDAT Pro software
- Developed customized software for customer utilization in preventative maintenance programs
- Utilized Rosler products and GIS technology to assist in automation of 50% of the 250 vehicle fleet at the Aleyska Pipeline
Environment: Windows XP Professional, UNIX Oracle: Form 9i, Reports 9i, Developer 9i, Project Builder, Database 9i, Designer 9i, SQL Plus, Discoverer, PL/SQL; Rosler WinDAT Pro 6.83, ESRI ArcGIS 9, ESRI Business Map, UML, Java, Microsoft Access, Microsoft Office
Confidential, Fairview Heights, IL
Programmer Analyst
Responsibilities:
- Application development encompassing the entire software development lifecycle Application maintenance in COBOL and Oracle Developer 5/6i
- Development and analysis of new requirements to be presented to DOD
- Oracle Forms 6i and PL/SQL trainer for new team members
- Creating tables, temporary tables, constraints, user - defined data types using Enterprise Manager, managing triggers, stored procedures & cursors
- As team leader, all facets of project management
- Primary contributor in developing new, robust, web-based forms for the Air Force Confidential ASIFICS financial system
- Developed and successfully integrated a regression test procedure for the new, web-based forms
- Developed and implemented new requirements in the ASIFICS systems to increase user efficiency
- Selected as a review board member for developing an improved documentation process
Environment: Windows 2000 and UNIX Oracle: Form Builder 5/6i, Report Builder 5/6i, Database 8/9i, Schema Builder, Query Builder, Procedure Builder, Project Builder, Microsoft Visio, PL/SQL, SQL*Plus; Microsoft Access, UNIX, UNIX Shell Scripting, Vi Editor, Microsoft Office
Confidential, Edwardsville, Illinois
Systems Analyst
Responsibilities:
- · Development of a customized, soil-sampling Microsoft Access application for the Department of Agriculture utilizing GIS technology
- Customized software development in Microsoft Access
- System design utilizing Oracle Designer 2000
- Web site development and maintenance
- NT network system administration
- Implemented a new, interactive website with integrated map serving capabilities
Environment: Windows NT 4.0 Oracle: Oracle Designer 2000, Oracle 7.3, Microsoft Access, Microsoft Visio, Macromedia DreamWeaver, Macromedia Flash, C++, ESRI ArcINFO 8, ESRI ArcIMS, UML
Confidential
Intern
Responsibilities:
- Gained exposure to logistics and Information Technology in an international manufacturing facility
- Monitored critical inventory levels