Senior Oracle Developer Resume
Orlando, FL
Skillset
Operating Systems: Microsoft Windows 3.1, 95, 98, NT 4 Workstation, 2000 Professional, Microsoft Windows NT Server 4, Hp-Unix, Solaris, AIX, Digital Unix, VMS, XP Professional
Languages: PowerBuilder 6.0, Oracle Forms/Reports 6i, Java, Informix, PL/SQL, SQL*Plus, C++, Discoverer, Pro*C, Progress 4GL, Cobol, Ingress, Pascal, Ansi C
RDBMS: Oracle DBMS, Access, Sybase System10, DB2, Informix 7x, Progress
Development Tools: Oracle Developer (Forms 6i, Reports 6i, Designer, Discoverer), Erwin, Jdeveloper, Micro Strategy 7i, Borland C++
Application Servers: Micro Strategy, Oracle Financials, Oracle Ebusiness Delivery Return Modules, Source Modules, Finance Modules, IMail Server, Crystal Reports 8, Retek Merchandising, Retek Data Warehouse, Retek forecasting, Retek Distribution
Web Servers: Internet Information Server 6, Apache Web server
Internet Technologies: Active Server Pages / ASP.NET, JavaScript, JSP, MTS, COM+, COM, ADO, ADSI, OLDEB, ODBC
Scripting Languages: Java Script, Shell Scripting, Windows Scripting
Versioning Tools: Continuous, PVCS, Dimensions, ClearCase, ClearQuest
Server Mgmt Tools: IpMonitor, SecureCopy, SecurityExplorer, WebTrends, IIS Export Utility
Protocols: TCP/IP, SNMP, SMTP, FTP, X.25, PPP, WWW
Qualification Summary:
Extensive experience with ERP and RICE development
Several years experience with Governmental and DOD programs
Extensive experience with Oracle Financial Applications
Experienced with Oracle 11i implementation, Oracle 12i Implementation
Experienced with Oracle AIM Methodology
Education-
BS Computer Science
Technical Diploma, Computer Science
Minor Computer Science
Security Clearance: Active Secret Clearance
Experience:
Confidential, March 2012 - Present
Senior Oracle Developer/Analyst/Lead: Thorough knowledge of the system development life cycle and train others on
SDLC concepts. Provide attention to detail, time management, work prioritization, multi-tasking, estimate tasks,
on-time deliverables and task delegation & follow up.
- Ability to assimilate the holistic view as well the detailed dissection of the business processes.
- Collaborate with business to define requirements and recommend optimized solutions.
- Interface with the end users to define and document requirements for data, reports, analysis, metadata, training, service levels, data quality, performance and troubleshooting.
- Perform system impact analysis including upstream and downstream impacts, propose solutions and buld functional specifications.
- Collaborate with data architects and BI developers to translate requirements into technical specifications.
- Determine and validate potential data sources, build validation plan, assisting with or building scripts executing the scripts, and communicating results in non-production environment.
- Plan, facilitate and participate in working sessions with cross-functional resources.
- Conduct peer reviews to solicit feedback on materials created
Confidential, March 2008 - Sept 2011
Senior Oracle 12i Oracle Technical Analyst/Project Mgr: Experience and Technical knowledge of Oracle Development tools including
- ERP Project Leader/Team member for RICE design/development.
- Experience with the Oracle technology stack (Oracle RDBMS, Oracle Developer, Oracle JDeveloper, PL/SQL development, Oracle Forms, Oracle Reports)
- Experience working with application design principles and product configurations
- Experience with a multi-vendor, best-of-breed application solution
- Excellent written and verbal communication skills.
- Experience and Technical knowledge of Oracle Development tools including
- Oracle Developer
- Oracle Forms
- Oracle Discover
- Oracle Workflow
- Oracle BPEL-PM
- Oracle BPEL-PM
- Experience with establishing and adhering to technical development standards
- Good analytical, prioritizing, forecasting and problem solving skills.
- Experience and knowledgeable of Oracle AIM documentation - specifically CV.40,CV.60, MD.050, MD.070
- Excellent interpersonal skills to interact harmoniously with client customers and team members.
- Experience working with appropriate programming languages, operating systems, hardware and software
- Ability to work in a team environment
Principal Duties and Essential Functions:
- Design and development of RICE standards
- Developing and documenting technical procedures for installing and executing RICE objects
- Participates in business process solution development workshops to gain understanding of solution requirements
- Analysis of ECSS requirements to establish RICE development requirements
- Designing the technical RICE specification to meet the business process requirements of the ECSS solution
- Developing RICE objects to meet the business process requirements of the ECSS solution
- Unit testing RICE objects to meet the business process requirements of the ECSS solution
- Support and participation in Solution Design/Development Labs as necessary
- Coordination and support of program testing requirements
- Developing and documenting technical specifications (MD.070)
May 2007-March 2008
Sr Oracle Consultant/Lead: U.S. Census Bureau: As Sr. Oracle BPEL SOA Developer defined requirements and developed documentation and training materials for in-house bpel developers. Assisted, trained and provided support to in-house developers on BPEL related issues and development. Results include: Setup for Database Alerts; defining Data Architecture for Data Loads and updates; developing BPEL interfaces using oracle BPEL Adapters such as Oracle advance queues, FTP file Adapter, Database Adapter and File Adapter; Setup and configured Client Link and Partner links; defined BPEL Activities, such as Assign, Reply, Invoke, Receive, Sequences, Switch, Otherwise and Fault handlers; used Oracle BPEL console and Process Manager for monitoring processes. Modified; and also troubleshot BPEL XML to meet business requirements for BPEL processes.
Confidential,Mar 2007-May 2007
Sr Oracle 12i Ebusiness Consultant: Oracle Corp: project GCSS-MC for U.S Marine Corps in Quantico. Functioned as Sr. Oracle (11i) Applications Developer (Interfaces, Extensions Team), defining requirements for developing extensions to enhance the functionality and meet GCSS-MC requirements. Defined/Mapped requirements for development of Interface extensions from Legacy System to Oracle Applications. Toad, PL/SQL, Oracle Aim Methodology, Oracle Work Flow, Oracle Warehouse Builder
Confidential, Nov 2006-Mar 2007
Sr Oracle 11i Ebusiness Consultant: U.S Air Force: Functioned as Sr. Oracle Financials Developer. Developed financial reports in Oracle; Developed Stored Procedures, Functions, Operating Statements, Balance Sheet, GL Detail Report, and Prepaid Report: and developed Extensions; Used TOAD; and worked with end user defining requirements. Designed custom responsibilities and menus, and partnered with DBA to set up web server for self-service applications.
Confidential, Mar 2005- Nov 2006
Oracle 11i Ebusiness Consultant/Lead - Zachry Construction Corp. Functioned as a SR oracle developer/lead, Production Support in an Oracle Applications environment. This role encompassed full life-cycle development including CMMI Level II, requirements gathering, development, and migration to production. This role also encompasses training other developers in PL/SQL, Forms, and Reports, working with Keane offshore in India in coordinating projects, projects requirements and testing. Also provided support for some Data Base Administration Functions. Oracle application development consisted of (Forms/Reports 6i) for 11i applications and Inventory Management. Also conducted Oracle Workflow customization, workflow builder. Toad, SqlPlus, Enterprise Manager, SQL*Loader. Held weekly meetings with Keane India to discuss project requirements, project status and completion and coordination of on-shore testing.
Software Development and application support modules consisted of Manufacturing (WIP, BOM, Inventory, MRP), Procurement (PO, ICX), Finance (AP, GL, AR), Quality (QA) and Project Control (PJM, PA). Discreet Manufacturing and Kintana source control. Support also consisted of multiple 3rd party applications.
Confidential, (Las Vegas, Nevada) Nov 2003- Mar 2005
Sr. Oracle Ebusiness Consultant/Lead: This project involved Developing Software Systems, Supporting Oracle Financials 11i, Stored Procedures, Forms Customization, Reports Customization, Triggers, End User Support, IntegrationTesting Technology: Oracle 9i DBMs, Maximo, Oracle Financials 11i, MicroStrategy, PL/SQL, Discoverer and Oracle forms/Reports 9i & 6i.
Responsibilities:
- Involved in managing, architecting, testing, deployment, and monitoring of the software projects
- Managed and Developed Oracle Reports, Stored Procedures, Oracle PL/SQL, Oracle forms/reports, Visual Basic, Access, and Micro Strategy Reports
- Designed Oracle Financials 11i reports for Accounts Payables and Receivables
- Developed Process Flow Diagrams and Data Flow Diagrams using Oracle Designer
- Created Database tables, Logical/Physical model, ERD Diagrams
- Developed Monthly and Yearly accounting reports using MicroStrategy and Discoverer
- Responsible for the management and training of developers
- Managed Development of new Systems using Oracle forms/reports 9i, Discoverer
- Lead Architect and Developer implementing Oracle Financials 11i
- Capability Maturity Model Integration
- Developed Equipment Maintenance reports using Maximo's Actuate language
Confidential, (Naval Exchange Service Command) May 2001-Dec 2003
Sr. Project Manager/Data Warehouse/Oracle Retail:
This project involved building and managing a data warehouse. The data warehouse will provide a means of inventory movement, inventory replenishment, vendor performance, and inventory visibility in the warehouses. All programs were fully documented and Oracle Designer was used as a data dictionary.
Technology: Oracle Forms 6i, Oracle Reports 6i, Erwin, SQL*Loader, PL/SQL, Shell Scripting, Enterprise Manager, HP-UX, Micro Strategy.
Responsibilities:
- Was responsible for managing the development in a Data Warehouse environment.
- Managed Developers, DBAs, System Administrators and Network Administrators
- Was responsible for the departmental yearly budget
- Attended Upper Management meetings
- Was responsible for Hiring of departmental personnel
- Designed Logical and Physical model for Data Warehouse
- Designed federated Data Marts for performance enhancement
- Used Oracle Designer as Information Repository
- Developed MicroStrategy and Oracle reports
- Developed PL/SQL data load programs for cleansing and loading data from Legacy Systems
- Developed Shell Scripts for execution of nightly batch processes
- Used Oracle Explain Plan for tuning SQL Statements
- Was responsible for developing coding standards and interface standards for all systems
- Was responsible for overseeing all database changes and architectural changes for all Enterprise Systems
Confidential, (Newport News, VA) Nov 1999-May 2001
Sr. Oracle Consultant/Lead Oracle/C++ Developer: This project involved developing a Data Mart used for decision support to monitor and track shipping of equipment, and the time it takes to deliver equipment to it's destination to determine where improvements need to be made. Developed a transactional system used for data entry of equipment, input equipment dimensions, and inventory tracking. Oracle Replication was used to replicate data to a remote data warehouse. Approximately 30 oracle forms were developed, approximately 20 oracle reports were developed, and 40 C++ programs. Erwin was used for Data Modeling. Weekly meetings, with upper level management personnel attending, were conducted to discuss progress of project, and to review methodologies. Met weekly with users to review functionality issues.
Technology: Oracle Forms 6i, Oracle Reports 6i, Apache Web Server, Erwin, Oracle Enterprise Manager, PL/SQL, Borland C++, SQL*Plus, Windows NT Job Scheduling, Microsoft Project
Responsibilities:
- Responsible for architecting, testing, deploying of equipment tracking system and data mart
- Developed Oracle forms/Reports, Stored Procedures, Functions, Triggers and PL/SQL Programs
- Developed Data Model and ERD Diagrams using Erwin
- Developed Fact Tables, Dimension Tables, Staging tables, C++ programs, and Stored Procedures for data mart
- Developed Oracle Forms/Reports 6i, and data model for transaction system
- Developed ETL process using C++
- Created staging tables for data cleansing
- Created tables, table spaces, indexes, primary keys and foreign keys
- Installed and configured Oracle Replication Manager
- Provided documentation and training to users
- Solved all database issues and hardware issues
- Authored the methodology and development process for the Data Mart and transactional system
- Was sole developer on this project and provided training, development, data modeling, oracle database administration, project tracking, configuration and documentation for both the data mart and the transactional system
Other Projects
Sr. Oracle Ebusiness Developer/Project Lead, Confidential, Newport News, Va. (10/98 to 1/2000
Sr. Developer/Lead Computer, Confidential, VA Beach, VA. (06/98 to 10/98)
Sr. Software Eng/Lead, PowerBuilder 6.0 Oracle DBMS, Confidential, Phoenix, AZ (07/97 to06/98)
Sr. Systems Engineer, PowerBuilder 3.0 & 4.0 SybaseDBMS, Confidential, Whittman, AZ, Contract work, (10/96 - 07/97)
Sr. Software Engineer/Project lead, C#,Informix 4Gl, Informix DBMS,Confidential,Phoenix, AZ,Contract work ( 09/95 - 09/96)
Sr. Programmer /Analyst, Confidential, McLean, VA, Contract work, (07/87 - 09/95)
Programmer Analyst, Confidential, Phoenix, AZ,(06/86 - 06/87)
Sr. Network Specialist, Confidential, Phoenix, AZ, (05/84 - 06/86)