We provide IT Staff Augmentation Services!

Oracle Apex Architect/developer Resume

Chicago, IL

PROFESSIONAL SUMMARY:

  • Experience in developing B usiness I ntelligence (OBIEE) and Oracle Application Express (APEX) 4.x for 7+ years.
  • Over 13 years of experience in HealthCare and Public Sector Industries.
  • Strong Business Analysis experience in end - to-end Business Intelligence projects with excellent communication and organization skills.
  • Proficient in elicitation of requirements through workshops, interviews, etc.
  • Experience in modeling and analyzing business processes and requirements.
  • Experience in mock-ups and wireframes for reports, dashboards, scorecards etc. based on the requirements
  • Understanding of business benefits definition, tracking, and measurement.
  • Ability to perform analysis on data via ad-hoc reports or freehand queries to support the requirements process
  • Understanding of Business Intelligence and Data Warehousing fundamentals to gather complete requirements
  • Experience/knowledge of BI Products such as OBIEE 11g
  • Support BI tool experts and developers in development and ensure that the solution is built according to specifications
  • Expertise in Technical aspects of Oracle Applications 11i Financials which includes over four years of customization and development experience in Oracle Applications 11i
  • Experience in Oracle Applications E-Business Suite Modules: Oracle Financials (GL - General Ledger, AP - Account Payables, AR - Account Receivables, System Administration, AOL - Application Object Library)
  • Excellent technical expertise in Reports, Interfaces, Conversions and Extensions; Implementation and Production Support in Oracle Financials Modules
  • Profound Experience in development of Concurrent Programs, Customization of Forms and Reports, defining profile values in AOL and System Administration
  • Experience in registering Forms, reports, concurrent programs, value sets, flex fields in Oracle Application using AOL
  • Extensively worked on Stored Procedures, Functions, Packages, Database triggers and Performance Tuning and Optimization
  • Extensive experience in each part of Software Development Life Cycle (SDLC) including analysis, specification, development, maintenance, testing and documentation using Applications Implementation Methodology (AIM)
  • Good experience in using Automated Testing Tools such as Win Runner , developing test scripts using Test Director to manage the entire testing process
  • Highly Solutions-minded, versatile, time-sensitive with excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels
  • Excellent written and verbal communication skills

TECHNICAL SKILLS:

BI Tools: BI Publisher, OBIEE 10.1/11, Business Objects XI R3/R2/R1, Designer, Infoview

Reporting Tools: Reports 6i/8i, Oracle Discoverer, Web-Intelligence, APEX 3.x/4.x

Data Modelling Tools: ERWIN

Oracle Applications 11i: Modules General Ledger, Account Payables, System Administration, AOL and Alerts Versions 11.5.8/ 11.5.9/ 11.5.10

Testing Tools: Win Runner, Test Director, Load Runner

Operating Systems: Windows 7/XP/NT/2000, UNIX

Databases: Oracle 8i/9i/10g/11g, SQL SERVER 2000/2005/2008 , Ms-Access

Office Applications: MS-Office 2003/2007/2010

Front End Tools: Visual Basic 6.0, Forms 6i/9i

Utilities: SQL*Loader, SQL Developer, TOAD

Languages: SQL, PL/SQL

Web Tools: VB.NET, HTML, DHTML and MS-Front page

Application Servers: IIS 6.0

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle APEX Architect/Developer

Responsibilities:

  • Manage Alderman / Ward information, Work Types and funding information
  • Set up and manage the programs
  • Manage Allocation and Allocation funding
  • Create and manage aldermanic requests and update Engineering estimate / units
  • Primary a request into a project based on fund availability
  • Generate reports on ward level summary for programs, projects, funds.
  • Manage employees or staff, Crews, assignments, makeups and schedules
  • Manage Materials and Rates, Equipment and Rates, Titles, Activities, Units of Measure
  • Manage Programs, Projects, Permits
  • Create and manage front end schedules
  • Capture Crew worksheet data from the source (through web forms)
  • Manage Vendor information and build Reports
  • Project Primary Interface and Non-Menu Funding Interfaces
  • Address Validation against ELS service
  • CSR/311 Data load screen to upload data to PDS from CSR Business Object report
  • Developed application using Oracle APEX to validate the addresses based on the address type. Used ELS web service calls to implement the validations. Created PL/SQL procedures to call from Oracle APEX using On-Demand application process.
  • Created a Queue Management screen to enable an Administrator to add, modify or delete user queues / stake holder queues for request management
  • The screen would enable authorized users to add new queues, and should capture Crew Name, and generate a unique queue id for each new queue.
  • The screen would also enable users to modify existing queues. The modified by and modified date details would be captured in this case and enable users to delete existing queues
  • Provided a Queue Inbox / Queue Summary interface, which displays all requests in a selected queue and would enable users to select the queue to be viewed
  • It would list all requests assigned to the specific queue. It would enable the user to view in detail a specific request in the queue. The interface would enable the user to route / assign the request to a different queue.
  • Developed around 20 significant reports using BI Publisher
  • Analyzed data model and done GAP analysis.
  • Analyzed existing reports and did report assessment.
  • Created technical design document and S2T mapping documents.
  • Perfective support for Project Data Systems (PDS) to develop partial application using Oracle APEX as the VB application was producing issues. This part of the application was developed to create projects and enter the costs of the projects classified under various program names. Implemented code to get the Ward Balance for each ward. Used collections to implement the Data Manipulation.
  • Architecture, Design and Development of web based application using Oracle APEX. Implemented Google maps to display the addresses based on the requests entered by the alderman. Used web services to validate the various address types like Point, Intersection and Range.
  • Developed application using Oracle APEX to validate the addresses based on the address type. Used web service calls to implement the validations. Created PL/SQL procedures to call from Oracle APEX using On-Demand application process.
  • Created Application Processes and application items to navigate between pages. Implemented Upload and Download functionalities where alderman can upload any type of documents into the Aldermanic Portal application.
  • Implemented validations on the buttons based on the conditions. Created LOVs, item, page level validations, Templates etc. based on the user requirements.
  • Modified the Google Map plug-in to display the markers in order to identify the location of the requests made.
  • Used Dynamic Actions to display messages based on a condition.
  • Implemented the Email functionality to send emails by alderman to process the request.
  • Debugged the VB code to re-write the OUC application into Oracle APEX.
  • Developed database objects like tables, views, indexes, and sequences.
  • Worked in the Reports team to develop reports using OBIEE 11g
  • Creation of reports, dashboards, scorecards etc.
  • Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL
  • Involved in migration of discoverer reports from development, testing and production release using Oracle Discoverer Administrator tool

Environment: Oracle 10g/11g, PL/SQL, SQL, Oracle APEX 3.2/4.1/4.2, Java script, Oracle Discoverer, Business Objects, OBIEE 11g, BI Publisher, Visual Basic 6.0, MS-Access.

Confidential, Boston, MA

Systems Programmer

Responsibilities:

  • Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 10g.
  • Created PL/SQL stand-alone procedures to automatically link all riders to the Product code in the Rider Product Table.
  • Implemented validations to the Rider type and Boc code in order to check if there are any corresponding Plan-Ids
  • Implemented code in order to insert the correct Rider type and Boc with corresponding Plan-Ids into the Details tables and update the header tables.
  • Developed database objects like tables, views, indexes, and sequences.
  • Used built in functions of PL/SQL such as SQLCODE, SQLERRM for error reporting, conversion.
  • Used Raise APPLICATION ERROR, PRAGMA EXCEPTION INIT to capture error messages.
  • Corrected program errors, prepared operating instructions, compiled documentation of program development, and analyzed system capabilities to resolve questions of program intent, output requirements, input data acquisition, programming techniques, and controls.

Environment: PL/SQL, PL/SQL Developer, Oracle 10g, APEX 4.0.1 , BI Publisher, MS-Office

Confidential, Dallas, TX

Systems Programmer

Responsibilities:

  • Developed about nearly 55 reports using Oracle APEX for applications involving General Ledger, Accounts Receivables and Accounts Payables under Finance and Work Orders, Inventory, Issues to WO, Cycle Counts By Branch-plant, planning etc under Manufacturing and Production streams.
  • Worked extensively on tuning the SQL statements to handle performance issues.
  • Involved in the Tuning of APEX reports (includes PL/SQL, SQL scripts) using Explain Plan & TKPROF.
  • Worked on Agile Report Writer which consists of nearly 250 reports, and also includes creation of several views and to check for performance issues and analyzing of tables required to get accurate statistics. Basically all the reports are created using APEX.
  • Used built in functions of PL/SQL such as SQLCODE, SQLERRM for error reporting, conversion.
  • Used Raise APPLICATION ERROR, PRAGMA EXCEPTION INIT to capture error messages.
  • Coded PL/SQL sub-programs and modified the existing PL/SQL program units.
  • Developed, modified SQL scripts, PL/SQL scripts, Views, Stored Procedures & Functions as per the Business Requirements.
  • WEBI Reports were created and deployed through Info View.
  • Used aggregate awareness in universes and Involved in full life cycle of Business Objects reporting Application.
  • Worked on Device History Records (DHR), using VBA this application provides the functionality of creating box labels for archiving DHR records and also to develop a solution to accommodate database performance issues and modify searching capabilities

Environment: PL/SQL, SQL*Loader, Discoverer, Oracle 10g, APEX 3.1/3.2/4.0, MS-Office, Business Objects XI, WEBI, VB 6.0, VBA, SQL Server 2005/2008.

Confidential, San Jose, CA

Programmer/Analyst

Responsibilities:

  • Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle.
  • Create and maintain tables, views, procedures, functions, and packages, and update, delete, and insert statements and compile them.
  • Involved in analysis, design and coding of data extraction, Transformation package in PL/SQL for loading data from online websites
  • Analyzed the existing code and used SQL Trace and Explain Plan to fine-tune the code
  • Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
  • Coded PL/SQL sub-programs and modified the existing PL/SQL program units.
  • Designed, developed and enhanced custom Oracle Reports according to the functional specification.
  • Constant monitoring and performance tuning of Oracle database, checking the most expensive queries.
  • Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
  • Oracle Application Express Developer; Generated financial web reports using HTML, and SQL; designed and deployed web applications in Application Express (APEX)
  • Written Database Triggers for automatic validations at the backend level.
  • Detected and corrected bugs during system integration and user acceptance testing.
  • Designed and developed forms and reports for easy data updating, that increased data entry efficiency over the existing system
  • Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.

Environment: PL/SQL, Oracle 10g, SQL*Loader, APEX 3.0/3.1.

Confidential, Naperville, IL

Oracle Applications Consultant

Responsibilities:

  • Wrote SQL*Loader scripts to migrate the data from the text files and populated the intermediate tables like GL INTERFACE and GL BUDGET INTERFACE.
  • Designed and developed interface to import Purchase Orders from legacy system to Oracle Purchasing.
  • Developed and Tested the Vendor conversion program to import Vendor Information from Legacy system into Oracle base tables.
  • Developed custom alerts as per business requirements.
  • Customized Payables Account Analysis Report in Account Payables (AP).
  • Involved in the Tuning of 11i Applications (includes PL/SQL, SQL scripts) using Explain Plan & TKPROF. Customized Expected Receipts Report, Contract Status Report and Purchase Order Detail Report in PO module.
  • Worked on Order Import Interface
  • Used FTP and UTL FILE package extensively
  • Developed, modified SQL scripts, PL/SQL scripts, Views, Stored Procedures & Functions as per the Business Requirements.
  • Registered the SQL PLUS reports as the concurrent programs and being executed from the Oracle Financials environment.
  • Developed reports using Discoverer for applications involving General Ledger, Accounts Receivables and Accounts Payables.
  • Worked with Discoverer to aid end-users to generate ad-hoc reports.
  • Customized Seeded Application Forms and Reports to meet the specific business needs.
  • Registration of Reports and Concurrent Programs.
  • Prepared the MD 070 documents for Development work done

Environment: Oracle Applications 11.5.7 - GL, AP, PO, FA, Alerts, Oracle 9i, Forms6i, Reports6i, SQL Navigator, Discoverer, PL/SQL, SQL*Loader, UNIX.

Hire Now