Oracle Application Express (APEX) Developer Resume

SQL, PLSQL, Oracle Application Express (APEX) Resumes

PROFESSIONAL SUMMARY:

• Around 7 years of experience in Application Developmentusing Oracle SQL, PL/SQL, and Developer 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, PL/SQL and SQL.
• Experience in Database design using Normalization and E/R Diagrams.
• Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Good knowledge in using PL/SQL Wrappers to protect the PL/SQL procedures and packages.
• Extreme 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, UTL_FILE, and DBMS_SQL to name a few.
• Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Expertise in loading data from legacy systems using SQL*Loader.
• Good knowledge in front end development using oracle forms/reports6i/9i/10g.
• Experience in creating master detail forms and adding alerts.
• Experience in deploying forms and reports on the web.
• 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.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• 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 3.2/4.0/4.1 (Oracle Application Express).
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g, SQL Server, MS Access.
Scripting: SQL, UNIX Shell Scripting and JavaScript.
GUI : Oracle Forms 6i/9i/10g and Reports 6i/9i/10g
Languages: C, C++, PLSQL, HTML, CORE JAVA, UNIX Shell scripting.
Tools : SQL Developer, SQL Navigator, TOAD, SQL plus, PUTTY, WINSCP, TOAD
Applications : MS Office and MS Visio.
Operating Systems: Windows 7, Windows Vista, XP, UNIX, Linux.

EDUCATION AND CERTIFICAITON:

• Bachelors of Technology in Computer Science from JNT University, India.
• OCA – Oracle Certified Associate in PL/SQL

Confidential, Pittsburgh, PA Dec 2010 - Sep 2011
Role: Oracle Developer

Description: United States Steel Corporation, headquartered in Pittsburgh, Pa., is an integrated steel producer with major production operations in the United States, Canada and Central Europe. The system controls the manufacturing process of the company as per defined routes. It generates work orders and maintains its work status. It defines manufacturing plans, product routes and monitors the production for customer orders by generating work orders and shop orders. It provides for modification of existing work orders.

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• 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.
• Supported APEX applications and conducted performance tuning for PLSQL.
• 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.
• Reviewed peer codes and documented proof of concepts and database schemas.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Used Oracle APEX 4.0 for designing application structure.
• Formulated oracle process, data retrieval methods and SQL code blocks.
• Designed and evaluated applications, and provided architectural input apps.
• Coded, tested and troubleshot software applications.
• Conducted unit testing and maintained data extractions and object models.
• Supported QA activities, test plans and performance enhancement techniques.
• Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Created some oracle objects for OLAP.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

**References Provided Upon Request**

< Prev		Next >

Greens Technology Training Locations in Chennai

Greens Technology
15 First Street Padmanabha Nagar, Adyar, Chennai
Tel: +91- 89399 15577
      +91- 89399 25577
Email: contact@greenstechnologys.com

Greens Technology Training Reviews

Greens Technology Reviews given by our students already completed the training with us. Please give your feedback as well if you are a student.