Pranav – 7+ Years – Oracle Apex Developer


PROFILE


Around 7 years of experience in Application Development using Oracle SQL, PL/SQL and
Oracle Application Express (APEX).
Proficiency in analysis, design, development, testing, implementation and maintenance of
applications in Oracle Application Express (APEX) and client/server configurations.
Excellent conceptual knowledge of Oracle 10g/11g/12c, PL/SQL and SQL.
Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions,
packages, triggers, cursors, apex_collections, Dynamic SQL.
Good knowledge in using PL/SQL Wrappers to protect the PL/SQL procedures and packages.
Use of exception handling methods along with Pragma Exception_init in order to associate our
own created exception names.
Experience in using several built-in database packages such as DBMS_JOB, DBMS_OUTPUT, and
APEX_MAIL to name a few.
Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained
performance.
Experience in developing forms based on views, tables and procedures in tabular and form
layouts.
Experience in developing both web layout and paper lay out reports in various styles based on the
user requirements.
Extensively worked with third party database tools like TOAD & PL/SQL Developer.
Good in creating users and maintaining their roles and responsibilities.
Experience in writing technical design documents and developing unit test documents.
Hands-on experience with Oracle APEX 5.0+ (Oracle Application Express).
Strong interpersonal skills, ability to interact with people at all levels. Good communication and
presentation skills.

TECHNICAL SKILLS

Databases: Oracle 10g/11g/12c, SQL Server, Index DB
Scripting: SQL, JavaScript
Languages: PLSQL, HTML
Others: jQuery, Ajax, Json, CSS Tools: SQL
Developer, TOAD, AOP
Applications: Oracle APEX 5.0+, MS Office and MS Visio


EDUCATION

Diploma in Information Technology (May- 2011)
Bachelor in information technology (June- 2014).


EXPERIENCE SUMMARY

Devops Engineer
Nine Hertz August-2019 – Present

Sr. Oracle Apex Developer March-2015 – August-2019
Confidential


Nine Hertz
Product (August 2019 – Present)
Implementation on AOP in multiple workspaces to ease the printing functionality and scheduling, while
implementing was in constant touch with the plugin creator to enhance the plugin functionality as per the
requirements.
Enhance page experience, modify components, add security and much more to the latest version of apex.
Started exploring Oracle Analytics for reporting purpose for huge volume of data.
Concise page items to handle large volumes of data (for example shuttles).

Compliment
Client USA (2018 – August 2019)
Oracle APEX (Oracle Exadata) 18.2/DB 12c/ORDS 3.17
Providing vital solution for warehouses and stores to keep an eye on every shipment which is
coming from different places (mainly diffn ports). Created an application to track the package
until it’s been delivered to thedestination using scheduler.
Store tracking is a product used by 1000+ active users, who do their daily activity such as keeping
track of how many shipments are coming distinguished by stores and location. Each location will
have different sets of credentials and authorization. Manage inventories and mark them as
missing, received or damaged.

Responsibilities:
Draft logic to handle files coming from various destination which comes in XML bundle and parse
records accordingly.
Create reports for each requirement such as shipments to come, pending shipments, received
shipments and so on. Using FedEx and UPS API track location of each shipment which needs to
be delivered to destination. Created scheduler to check the status after every periodic interval.
Handle different environments such as development, test and production and make sure all of them
are inclined. Periodically perform migrationprocess.
Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL. Developed data
model, SQL Queries and Schemas.
Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with
master tables in database.
Involved in updating procedures, functions, triggers, and packages for validation and loading of
data into target table based on the current requirement.
Designed and developed various custom packages triggers and forms.
Formulated SQL queries, functions and processes as per customization requirement for APEX.
Contributed with database designs and assisted in increasing response time for APEX reports.
Designed application framework and developed Oracle APEX Application.
Provided APEX guidance and support to technical staff on application maintenance and SDLC
process.

Confidential
Client Australia (2018 - 2019)
Oracle APEX 18.1/DB 11g
For the client based in Australia, created an application from scratch to handle day to day sale
purchase process.
The idea is to create a relation between manufacturer and reseller. When reseller places any
order for clothing it will go to the manufacturer and if he approves it will be displayed on resellers
screen if not than modification will be suggested accordingly to the reseller by the manufacturer
based on the availability of the goods.
Create connection between manufacturer and reseller so they can see all the information
internally. Created POS pages for both the parties with different stages of process.

Responsibilities:
Created dynamic reports to display catalog as per user/supplier/owner search.
Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL. Developed data
model, SQL Queries and Schemas.
Design business logic as per customer requirement and deliver fully customer driven application.
Provided APEX guidance and support to technical staff on application maintenance and SDLC
process.


Confidential

Product (2015 – present)
A product which is built for most retail businesses, a true Enterprise Resource Planning
application which is built on APEX platform. Fuzion ERP helps vendors for keeping track of their
Sales, Customers, Purchases, Invoices, Products, Inventory Control, Employees, Expenses,
Finances.
Fully customizable, Multiple locations and multiple user support.
Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL. Developed data
model, SQL Queries and Schemas.
Provided Jasper reporting, Periodic mails and Periodic SMS notifications. Support customers on
every level to rectify the problem and give proper solution.
Oracle APEX 5.0 to 20.1, jasper for reporting, third party integration for SMS.

Confidential

Misc. (2015 - Present)
Other Projects such as developing reports based on altova , xsl-fo, Sql code modification and so
on as per the client requirements.