Oracle PLSQL &Application Express Developer Resume

PROFESSIONAL SUMMARY:

4.2 years of extensive experience as Oracle SQL/PL - SQL, Application Express (APEX) Developer.
Hands-on experience with Oracle APEX 3.2/4.0/4.1/4.2/5.0/5.1/18.1/19.1/20.1.
Involved in analysis, design, development, design, implementation & maintenance of applications in oracle APEX & Client Server Configuration.
Analyze the Existing code and do the impact analysis.
Experience in writing SQL queries, Stored Procedures, Functions, Records, Views and Packages using PL/SQL, Database Triggers, Cursors, Ref Cursors and Dynamic SQL.
Involved in modifying various existing packages, procedures, functions, triggers according to the new business needs.
Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.
Used well exception handling methods in applications along with pragma exception and own created exceptions.
Experience in DBMS SCHEDULER to run jobs in parallel to improve time-constraint performance.
Used SQL Loader, SQL Developer client & APEX s built-in utility to upload the information into the database and using UTL FILE packages write data to files.
Used Oracle supplied built-in packages like. DBMS SCHEDULER, DBMS OUTPUT, UTL SMTP, UTL HTTP, UTL FILE.
Used Oracle APEX s supplied packages in application like APEX UTIL, APEX ITEM, APEX MAIL, APEX CUSTOM AUTH.
APEX customized forms, login, report s templates with integrating material design UI templates.
Used command line interface for importing/exporting database s objects, schemas and APEX application to move from testing/ dev environment to production.
Responsible for APEX migration with user data. Helped in configuring APEX on client s server with APACHE - MOD server. Upgraded APEX environment from 4.1 to 5.1.3, 5.0 to 19.
Administration of Oracle Database, APEX applications.
Experience in REST Web Services. Developed apps with ORDS by integrating .Net, Java, python API.
Build reports using ORDS API & Web Source modules.
Basic knowledge on Oracle Forms Reports using Forms11i/10g and Reports11i/10g.
Effective team working skills. Able to work both as an individual and as a team member within multi-disciplinary team to meet the expected deadlines.
Strong interpersonal skills, ability to interact with people at all levels to work within team environment and independently when needed.

TECHNICAL SKILLS:

Operating Systems: Windows 7, 8, 10 Linux

Languages: PL/SQL, SQL, Python, Shell, HTML, JQuery, JavaScript.

Databases: Oracle 11g XE, SE, 12C.

Tools: Oracle SQL developer, Oracle APEX 4.0 - 20.1, 18c Oracle Reports, Oracle Apps EBS (10g, 11i and R12).

Web Servers: Apache 24, Apache Tomcat 8.

Version Control Tools: Git, GitHub, BitBucket

EMPLOYMENT HISTORY:

Confidential

Oracle PLSQL &Application Express Developer

Responsibilities:

Working as an APEX developer to support various web applications for clinical BI reports & data quality checks.
Responsible for developing & enhancing existing application s functionality to meet business user s requirements.
Coordinating with test team, business analyst, owners & users about any changes, bug fix & test cases.

Confidential

Associate Consultant

Responsibilities:

Working as an APEX developer to support various web applications for industrialization.
Developed APEX based applications to assist business users in daily processing. Enhance & applications with new required functionality & correct the bugs, errors in existing applications when required.
Worked on Oracle backend objects like: Stored Procedures, Functions, Records, Views and Packages using PL/SQL, Database Triggers.
Developed Reports (IR, Classic, IG), Master-Details, Tabular Forms as per business requirements.
Developed Reports with built-in APEX s charts as well as using custom Highcharts.JS.
Worked on web page designing using JavaScript, HTML, CSS, jQuery, Ajax.
Developed custom application for data upload for business users & configure email alerts using Oracle supplied packages and APEX Mail API.
Used custom authentication schemes, UI themes, plug-ins in APEX application.
Migrated APEX application on client s server with configuring custom SSO login.
Migrated Old legacy APEX (4.0) application to new version (5.1.3.0.00.5 ) & 18c.
Supporting ADMIN activities for developed applications including APEX s admin role and oracle backend.
Helped other engagement/project to get setup APEX with all required technical aspects.
Monitoring all kinds of jobs and backup activities related to oracle database.
Involving in migration process of forms & reports into APEX s forms & reports.
Part of automation team where automate daily task, monitoring jobs using Shell, BATCH & Python scripting.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship