We provide IT Staff Augmentation Services!

Oracle Apex Architect/developer Resume

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

Oracle APEX Architect/Developer

Responsibilities:

  • Re placed the current Project Data System (PDS) application with a fully redesigned and re-architected Web Application CCM that can meet the current requirements and future enhancement for CDOT. This project was built using Oracle APEX, a robust and scalable system that can handle the Construction Project Data in the existing PDS application and manage the workflow and processes electronically. The solution was designed so that it can easily adapt to changing business needs and eliminate need for duplication in data entry and multiple data handling points by enabling data entry at the source.
  • 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.
  • Developed around 20 significant reports using BI Publisher
  • 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

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.
  • Developed a complete system for Medtronic, Kinetic Concepts Inc and Boston Scientific Corp using VB 6.0, this system provides the functionality of scanning various Models of finished goods.
  • 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.

Hire Now