We provide IT Staff Augmentation Services!

Oracle Banner Programmer Analyst Resume

PROFILE:

  • A quality driven programmer analyst with proven expertise in Oracle Software Development.
  • Twenty years experience including software design and development and support using PL/SQL, SQL and Oracle 7.3.4, Oracle 8i, Oracle 9i, Oracle 10g, Oracle Applications 12.1.2, Oracle Process Manufacturing 11i, Discoverer 6i,10g, Developer 6I and 10g(Forms and Reports). Other skills used are C, PRO*C, Unix, Unix Shell Scripts, PL/SQL Developer, SQL Navigator, TOAD, RETEK SKUPLAN, Solaris, Harvest (version control), Microsoft Source Safe and Novell, Actuate, Brio, HTML, XML, Java, PERL, Manugistics, RETEK RMS, Business Objects, Banner/CIS.
  • Worked with a team to develop a home grown tracking system. This application allowed Confidential to track their apprenticeship requirements and to follow the progress of the apprentice’s . This was built using Java, JavaScript, Oracle Forms, Oracle Reports and PL/SQL
  • Worked on a project to develop an On Time Shipment Tracking workbench. This allowed Creation to track and account for their late shipments and provide better visibility. This was developed as an extension to Oracle Applications 11.5.10 using Oracle Forms, PLSQL and Discoverer
  • Participated on a project to upgrade the Oracle eBusiness Suite ERP system from 11. .1.2 Some of the modules involved were INV,AR,AP,GL,OM,OSO, Telesales, Install Base
  • Assisted on the Y2K upgrade project. This involved upgrading GEMMS, Schedulex, Manugistics and Retek Skuplan and their interfaces to their Y2K ready versions. Changing Unix Shell Scripts, PL/SQL code and Oracle tables as well as upgrading vendor software did this.

EMPLOYMENT HISTORY:

Confidential

Oracle Banner Programmer Analyst

Responsibilities:

  • Support and development of Confidential ’s Enterprise Resource Program(ERP) Ellucian Banner using Oracle Forms/Reports, PL/SQL, Oracle DB.
  • Support Administrative, Student, Finance, HR/Payroll and other departmental systems within an Banner environment.
  • Troubleshoot applications problems and worked with inside and outside resources as necessary to resolve them in support of the Ellucian Banner ERP system.
  • Coordinated production release activities such as code migrations between environments as necessary to support business requirements and schedules.

Confidential

Responsibilities:

  • Delivers legendary customer service to all customers by acting with a customer comes first attitude and connecting with the customer. Discovers and responds to customer needs.
  • Provides quality beverages, whole bean, and food products consistently for all customers by adhering to all recipe and presentation standards. Follows health, safety and sanitation guidelines for all products.
  • Follows Starbucks operational policies and procedures, including those for cash handling and safety and security, to ensure the safety of all partners during each shift.

Confidential, Sarasota, Florida

Oracle Developer

Responsibilities:

  • Developed applications according to technical design documentation in an Oracle EBS environment including custom PL/SQL, forms extensions and Oracle API’s with the OM, AR, AP, GL, inventory and Purchasing as well as other custom applications.
  • Designed applications according to technical design standards in an Oracle EBS environment including the creation of the technical design document.
  • Troubleshoot applications problems and worked with inside and outside resources as necessary to resolve them in support of the Oracle eBusiness R12(12.1.3) Suite ERP system.
  • Coordinated production release activities such as code migrations between environments as necessary to support business requirements and schedules.

Confidential, Seattle, Washington

Oracle Developer

Responsibilities:

  • Developed custom interfaces to vendor software using PL/SQL packages and Oracle API’s on an Oracle database.
  • Customized Oracle Applications RICEW(Reports, Interfaces, Conversions, Extensions, Workflow using Oracle tools such as Oracle Reports/Forms, BI Publisher, Discoverer, XML, PLSQL, SQL etc in support of the Oracle eBusiness Suite ERP system.

Confidential, Seatac, Washington

Oracle Developer

Responsibilities:

  • Worked closely with Business Analysts and end users to translate functional requirements into technical solutions using Oracle AIM documentation such as MD070, etc.
  • Participated on a large team in implementing the Oracle eBusiness Suite ERP system R12 (12.1.3.) and interfacing it to the existing Legacy system.Some of the modules involved were AR,AP,GL,FA,Purchasing
  • Worked within an Agile development environment for the sdlc cycles.
  • Customized Oracle Applications RICEW(Reports, Interfaces, Conversions, Extensions, Workflow using Oracle tools such as Oracle Reports/Forms, BI Publisher, Discoverer, XML, PLSQL, SQL etc in support of the Oracle eBusiness Suite ERP system.

Confidential, Washington

Designer

Responsibilities:

  • Worked closely with Business Analysts and end users to translate functional requirements into technical solutions.
  • Participated on a large team in upgrading the Oracle eBusiness Suite ERP system from 11.5.9 to 11.5.10. Some of the modules involved were INV,AR,AP,GL,OM,OSO, Telesales, Install Base
  • Customized Oracle Applications using Oracle tools such as Oracle Reports/Forms, Discoverer, XML, PLSQL, SQL etc in support of the Oracle eBusiness Suite ERP system.
  • Worked on an application using Javascript to generate necessary reports

Confidential

Oracle Developer

Responsibilities:

  • Developed custom interfaces to vendor software using PL/SQL packages on an Oracle database.

Confidential

Systems Analyst

Responsibilities:

  • Customized Oracle Applications using Oracle tools such as Oracle Reports/Forms, Discoverer, XML, PLSQL, SQL etc in support of the Oracle eBusiness Suite ERP system.
  • Worked closely with Business Analysts and end users to translate functional requirements into technical solutions.
  • Documented technical designs
  • Conducted systems analysis activities and created application designs as required.

Confidential

Integration Lead

Responsibilities:

  • Worked on a new solution for their foreign exchange business problems. This involves implementing many of the modules of a new foreign exchange application and integrating it in with the existing modules.
  • Designed and developed interfaces, technical specifications, implementation and integration plan for their foreign exchange applications.

Confidential

Technical Lead

Responsibilities:

  • Worked with Confidential ’s clients to implement a new solution for their business problems. This involves implementing many of the modules of Oracle Applications E - Business Suite including Inventory, Purchasing, etc.
  • Designed interfaces, conversions and customizations for their E-Business Suite implementation of Inventory and Purchasing.

Confidential

Principal Consultant

Responsibilities:

  • This involves many of the modules of Oracle Applications E-Business Suite including Financials, Order Management, Manufacturing, Purchasing, etc.
  • Developed reports, interfaces, conversions and extensions using Oracle Reports 10g, Oracle Forms 10g, PL/SQL in a Oracle Applications 11.5.10 environment with an Oracle 10g database.
  • Attended various courses including Oracle Workflow, Java, J2EE.

Confidential

Senior Oracle Technical Analyst

Responsibilities:

  • Extracting data from the Banner/CIS Utility billing system using PL/SQL and Unix scripts in an Oracle environment using Oracle 8i, PL/SQL, and SQL Plus.
  • Formatting data into customer reports using PL/SQL and Excel spreadsheets and Oracle Reports.
  • Provided support in assisting with bug fixes for Banner

Confidential, Las Vegas, Nevada

Senior Oracle Reports Developer

Responsibilities:

  • Assisting the International Center with Oracle reports development in an Oracle environment using Oracle Reports 10g, Oracle 9i, PL/SQL, and SQL Plus.
  • Developed and maintained PL/SQL scripts used for populating summary tables and views in the reporting database using Toad.

Confidential, Beaverton, Oregon

Senior Oracle/Brio Developer

Responsibilities:

  • Assisting the B2C Product Developers with Oracle/Brio reports development in an Oracle environment using Brio reporting/data marts, Oracle 9i, PL/SQL, Pro*C and SQL Plus.
  • Generating code process reports for performance enhancement.
  • Developed and maintained PL/SQL scripts used for populating summary tables and views in the reporting database.
  • Interpreting and authoring technical and functional specification documents.

Confidential, TAMPA, FL

Senior Software Engineer

Responsibilities:

  • Worked with a team to build data extract programs to extract data from the RETEK RMS 9.0 database.
  • These programs were built using Unix Shell Scripts and PL/SQL code on a ORACLE 8.1.7.4 database. This data will be used to populate a new database.
  • Built interface programs to 3rd party applications using Unix Shell Scripts and PRO*C.
  • Analyze existing Forms and Reports using Oracle Forms 6i and Oracle Reports 6I.

Confidential, ROCHELLE PARK, NJ

Senior Software Engineer

Responsibilities:

  • Worked with a team to implement Oracle Process Manufacturing under the Oracle Applications 11.5.8 suite. This allows Premio to keep up with current versions and technology. OPM is on a Sun Solaris 5.8 platform utilizing an Oracle 9.2.0.4.0 database.
  • Maintained and supported existing Oracle Applications 11.5.8 modules such as Financials (AP, AR, GL), Purchasing, Oracle Inventory, Order Management.
  • Upgraded all customizations using Oracle Forms 6i and Oracle Reports 6I and Oracle Discoverer 4I as well as custom interfaces using PL/SQL.
  • Modified existing reports and building new reports as required using Oracle Reports 6i and Oracle Discoverer 4i

Confidential

Senior Software Engineer

Responsibilities:

  • Worked with a team to upgrade GEMMS 4.10.10 to Oracle Process Manufacturing under the Oracle Applications 11.5.9 suite. This allows Simmons to keep up with current versions and technology. OPM is on a Sun Solaris 5.8 platform utilizing an Oracle 8.1.7 database and using a Linux middle tier.
  • Upgraded Oracle Applications 10.7SC to Oracle Applications 11.5.9. Modules migrated were Financials (AP, AR, GL), Purchasing, Oracle Inventory, Order Fulfillment to Order Management.
  • Evaluated the existing customizations (forms, reports, and interfaces). Identified the table structure changes and updating the changes in custom development environment. Gathered requirements for all forms and reports.
  • Upgraded all customizations using Oracle Forms 6i and Oracle Reports 6I and Oracle Discoverer 4I as well as custom interface changes using PL/SQL.
  • Modified and supported existing reports and building new reports as required using Oracle Reports 6i
  • Worked with the functional team on configuration and testing of OPM Inventory, OPM System, OPM Costing, and OPM MAC and Order Management.

Confidential, BOISE, IDAHO

Senior Software Engineer

Responsibilities:

  • Developed the CRS Audit System to provide data for Audit reports for a large financial company using Unix Shell scripts, PL/SQL Scripts, Oracle 9i on an HP-UX platform with a large scale data mart and data processing application.
  • Participated on a team to develop the Audit Reports using BRIO.
  • Worked on a large PL-SQL based reporting application that needed to process millions of records per day in a large data warehouse environment.
  • Developed an ERD diagram for the CRS audit system using ERWIN.

Confidential, BELLEVUE, WASHINGTON

Senior Software Engineer

Responsibilities:

  • Supported the CEOS IP data mediation product for a large wireless company using Unix Shell scripts, PL/SQL Scripts, PERL Scripts, 'C', Oracle 8.1.7.4 on an Sun Solaris 5.8 platform.
  • Validated data from the CEOS package to make sure the XML output data matched the ascii input data.
  • Planned and Participated in improvements to the CEOS environment such as Push-To-Talk(PTT) by modifying GFOT files and CEOS configuration files.
  • Performed Data validation and analysis to insure data and products delivered from vendors is accurate. Provided input to technical requirements documents and vendor feature request documents. Wrote and executed Test Plan documents.

Confidential, SEATTLE, WASHINGTON

Senior Programmer/Analyst

Responsibilities:

  • Built and maintained interfaces between GEMMS, Manugistics, Schedulex, and WMS and JDA using Unix Shell scripts, PL/SQL, ‘C’,PRO*C, Oracle 7.3.4, Oracle Forms 4.5, Oracle Reports 2.5, SQLLDR(SQL Loader) and Oracle APIs on an HP UNIX platform.
  • Built some web pages using HTML and Front Page to keep the implementation team updated on developments
  • Provided 24 hour support and bug fixes for the active interfaces.
  • Participated in the design and development of more than 200 reports using Actuate and Brio
  • Mentored new team members on GEMMS interfaces. Trained in troubleshooting and timing of interfaces and UNIX environment.
  • Assisted with developing and implementation of the master data inventory interface for the Manugistics 6.0 demand planning project using UNIX shell scripts, PL/SQL packages and stored procedures, low-level and statement-level triggers, Oracle 8 database, on a Sun Solaris 5.8 platform.
  • Participated in upgrading GEMMS 4.10.07 to Oracle Process Manufacturing 11i within the Oracle Applications suite. Involved with rewriting interfaces to allow for Oracle table changes. Skills used are UNIX shell scripts, PL/SQL, PRO*C, C, Oracle 8.1.7 Database, Oracle Forms and Reports 6i, Oracle Inventory, Discover 4i on a SUN Solaris 5.8 platform.
  • Worked on a team to convert all reports to Oracle reports 6i

Hire Now