SUMMARY

• Around 11+ Years of experience in software design, development, implementation and maintenance of applications with 6+ As a Lead using Oracle APEX,Application Express, Oracle E - business Suite, SQL, PL/SQL JAVA, HTML, JQuery, JSON, JavaScript, CSS and MySQL/Oracle.
• Proficient in analysis, design, development, testing, implementation, and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
• Experience in using Oracle Apex 19.2/18.1.0/5.1.2/5.0/4.2, Oracle discoverer 10g for developing end user screens and reports and also adept in using Oracle Tools like SQL* Plus, Toad, SQL Developer, SQL Loader, Data Loader, SQL navigator.
• Extensive knowledge of Oracle APEX (Application Express), SQL, PL/SQL, HTML languages.
• Knowledge in JSON, HTML, CSS, JavaScript, JQuery and AJAX.
• Worked with Oracle APEX Universal Theme, Interactive Report and Template customizations.
• Worked with Oracle APEX JavaScript APIs and Web based SOA call (Web services), BI Publisher, XML Parser, UTL HTTP and OWA UTIL packages.
• Expert in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, Dynamic SQL, Bulk Collect, exception handling, analytical functions, System Context etc.
• Experienced in query optimization, performance and tuning (PL/SQL) using Explain Plan, Indexing AND Hints and Data warehouse data loading.
• Experienced in evaluating business and technical requirements and create estimates for development efforts consistent with best practice project methodologies. Have strong knowledge in SDLC (Software Development Life Cycle) aspects and product as well as project metrics collection.
• Expertise in using HTML, CSS, Jquery, JavaScript and Ajax in APEX applications to have client side
• Experienced in developing authentication using Oracle SSO, LDAP, WEB AUTH and Shibboleth.
• Worked extensively with third party database tools like TOAD & PL/SQL Developer.
• Expertise in version control tools like PVCS, Kintana and SVN.
• Experience in Agile and SCRUM methodology.
• Possess strong leadership, interpersonal and excellent analytical & problem-solving skills.
• Experienced in production support and root-cause analysis for issues reported by users

TECHNICAL SKILLS

Programing Languages and Tools: SQL, PL/SQL, HTML5, CSS, jQuery, AJAX, Bootstrap.

Database Skills: Relational Database, MySQL, SQL Server and Oracle.

Software Tools: Oracle APEX (5.0.1, 5.0.2, 18.1, 19.1, 20.1), BI/ XML Publisher, SQL Developer, TOAD, Oracle Rest Data Services, TWS job Scheduling.

Defect Tracking Tools: Remedy, JIRA, Service Now, Confluence, Rally, SharePoint, and Sonar Qube.

Project management skills: Microsoft Project, SharePoint.

Source Code Control: Git, GitHub, Tortoise Subversion, VS Code, Serena PVCS, Kintana.

Data Visualization: Forms and Reports, Apex Standard Plug-ins, Report Layouts and Report Queries, Bi-Publisher.

Operating Systems: Windows, Linux, iOS and Android.

Other Skills: Visual Studio, MathLab, Visio, Microsoft Office, Excel and PowerPoint.

PROFESSIONAL EXPERIENCE

Lead Oracle Apex Developer

Confidential, Horsham, PA

Responsibilities:

• Working as a Project Lead for Multiple Applications, designer, and Senior developer along with other developers.
• Involved in Analyze, Design, develop, configure, test, implement and maintain various enterprise software applications:
• Worked on Upgrading Existing APEX Applications to Latest version and developed New Applications from Scratch.
• Based on approved Business Requirements document, I analyze how the tool (Oracle Apex) will address the concern/problem statement outlined in the document.
• Responsible for developing custom application using APEX. This involves developing APEX Reports and Forms, conversion of Oracle Reports into Oracle APEX Reports.
• After the analysis is completed, a design of the application is developed and configured that will fit with the business requirement using the following technologies: Oracle Application Express (APEX), PL/SQL, Data Warehouse, jQuery, Java Script, CSS and HTML.
• Implemented using SonarQube for code quality and security across all teams.
• Responsible for Planning, Execution & Quality maintenance for in-house systems:
• Preparing documents required from customer like Impact analysis document, User manuals, Traceability Matrix, Project Plan & review of Release Notes etc.
• Created page processes at several instances and computations in APEX.
• Review of Test cases with the client team and provide a sign-off.
• Provide production support, e.g., technical and root cause analysis, for issues identified by business users through bug tracking systems.
• Perform demo of the functional application on a scheduled (release) basis where business users can provide feedback.
• Used Rally, Service Now for bug tracking and code migration from multiple database environments for quality maintenance
• Mentor junior resources and new hires to better improve the competency and efficiency of all staff.
• Developed the user interface using the Oracle Apex form types depending on the requirements.
• Involved supporting in Performance Enhancement and Loading of high volume of data.
• Analyzing various data sources and generating Reports and Dashboards for senior management.
• Working on the enhancements of the existing applications as per the user request.
• As an onsite team member perform initial research on the production issues and coordinating with offshore team through the design, development, and implementation phases of such issues.
• Perform Walkthroughs on the projects done by other team members.
• Configure SSL for APEX over web logic server, HTTP server and others in Test and production environments.
• Working on the performance of the application and identifying bottlenecks in batch processes.
• Monitoring various scheduled jobs and proving first hand support for any issues in Production.
• Maintain SLA on time of all incidents.
• Involved in other capability activities like conducting SME Review for other projects, helping other teams in APEX tasks, conducting technical trainings sessions, and conducting internal as well as external technical interviews.

Senior Oracle Apex Developer

Confidential, Palo Alto, CA

Responsibilities:

• Worked as a Team Lead, designer, and Senior developer along with other developers.
• Analyze, Design, develop, configure, test, implement and maintain various enterprise software applications.
• Supported APEX applications and conducted performance tuning for PLSQL.
• Involved in gathering requirements and performed initial analysis on the CRs from business users.
• After the analysis is completed, a design of the application is developed and configured that will fit with the business requirement using the following technologies: Oracle Application Express (APEX), PL/SQL, Oracle e-Business Suite, Data Warehouse, jQuery, Java Script, CSS and HTML.
• Worked on major changes related to Oracle PL/SQL and delivering the work product on a weekly based Sprint in an Agile Method.
• Configured Toonimo tool for digital visualization. This will provide a description to the users on what the pages can do, and explanation of the data being presented.
• Developed several pages in the APEX Application that is used for reporting and request from feeder.
• Used the Data load unload functionality in APEX to upload first time data into the database tables.
• Execute testing as code is developed based on test cases provided by business users.
• Responsible for Planning, Execution & Quality maintenance for in-house systems:
• Participate in meeting held on first day of each sprint involving Scrum Master, Product Owner, and Team, where Product Owner presents the set of features to be achieved in the sprint.
• Created Page level and item level validations and also page processes and computations using APEX.
• Used JIRA/Atlassian, Confluence, Service Now, PVCS, Kintana and SVN for bug tracking and code migration from multiple database environments for quality maintenance.
• Extensively used SQL Loader scripts to load flat file data into staging tables.
• Worked on the application performance by using many Exadata and 12c features like Index Storage, JSON in SQL, Real Time Materialized views, Invisible column, Identity column, Parallel Processing, query optimization etc.
• Used the data load unload functionality in APEX to upload first time data into the database tables.
• Worked with Oracle APEX JavaScript APIs and Web based SOA call (Web services), BI Publisher, XML Parser, UTL HTTP and OWA UTIL packages.
• Review applications to and perform functional and technical gap analysis:
• Perform demo of the functional application on a scheduled (release) basis where business users can provide feedback.
• Developed Basic APEX applications to generate reports for easy management.
• Perform technical gap analysis based on feedback from business users.
• Identify low performance jobs and rewrite/redesign to improve performance.
• Identify the underperforming queries and rewrite.
• Create appropriate indexes for the relevant columns of the tables in database.
• Architect system interactions and design custom solutions for development.
• Build an architecture design which outline the dependencies and interactions of the different systems, e.g., Oracle e-Business Suite, Data Warehouse and custom application.
• Since we are working on millions of data that needs to be analyzed and defined into categories, use Golden Gate to replicate the data from Data Warehouse to custom application for audit and verification prior to production deployment.
• Analyzing migration approaches between different type of databases using Oracle Golden Gate and SQL Developer.
• Preparing Proof of Concepts and Technical Design documents details the steps involved in both tools.
• Developing new APEX applications as per requirements and changing company trends.
• In addition to the functional and technical documents, workflow charts and diagrams are created to give a visualization of the application, .e.g. process flow for each function, etc.
• On a daily basis, monitoring of the Database System cron jobs, Oracle DBMS scheduler jobs and prepare the technical reports for review and performance.
• Provide Quality assurance, testing, production support and documentation:
• Review of Test cases with the client team and provide a sign-off.
• Execute testing as code is developed based on test cases provided by business users.
• Provide production support, e.g. technical and root cause analysis, for issues identified by business users through bug tracking systems.

Oracle Apex and ETL Developer

Confidential, Auburn, AL

Responsibilities:

• Create functional design documents and technical design documents:
• The functional design document describes the intended functions that a system or component must perform based on the input from business users; often derived from Business Requirements document.
• The technical design document describes all the Oracle database objects, e.g., tables, views, procedures, functions, packages, and DBMS scheduler jobs.
• Documentation of test cases and workflow instructions
• Designing Oracle APEX applications for daily reports and operations.
• Unit test of DataStage Jobs for extraction, transformation and loading of ETL data.
• These documents are shared with the project and business teams.
• Meeting Delivery Schedules with quality and limited time frame.
• Involved in review of other project development process.
• Part of the audit team for delivery and defect prevention process.