SUMMARY:

• Over 8 years of software development experience using Oracle technologies including Four years of experience in Developing Applications Using Application Express Framework.
• Involved in complete SDLC including architecture, analysis, design, development, testing, implementation & maintenance of application software in the Client/Server and web - based environments.
• Extensively used PL/SQL to build Oracle Packages, stored procedures, functions, triggers, cursors, ref cursors, views for processing data, enforcing referential integrity and needed business rules.
• Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Compound triggers, Materialized Views.
• Knowledgeable in client-server technology, GUI design, and Relational Database Management.
• Experienced in Database Administration of 9i, 10g & 11g.
• Responsible for Oracle9i/10g/11g logical and physical databases design implementation and maintenance on LINUX/UNIX/Windows platform.
• Experienced in Tuning SQL and PL/SQL code for better performance with large volume of data.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX Scripting, SQL, PL/SQL and SQL Loader.
• Experience in using Oracle APEX 4.2/4.0/3.2/3.1/3.0 Forms 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, JDeveloper.
• Expertise in using APEX 4.2/4.0/3.2/3/1/3.0 application builder tool to build database driven applications such as developed Interactive Reports and Hyper Text Linked Reports.
• Experience in developing validations of the page and page items using Ajax calls and also PL/SQL packages.
• Hands on experience on error handling in operator and ODI issues.
• Hands on experience with security manager in ODI. Created criteria to provide permissions on datastore level to developers.
• Experience in developing interfaces to interact with multiple schemas for data loads and refresh.
• Expertise in using HTML, CSS, JQuery, JavaScript and Ajax in APEX applications to have client side
• Programming and validations.
• Experience in implementing Authentication, Authorization on Embedded PL/SQL gateway, Oracle HTTP Server and Web logic server.
• Expertise in writing Packages, Stored procedures, functions, Triggers Creating tables, views, Indexes, Constraints, partitions etc. Expertise in using cursors, collections, records, Dynamic SQL, Object Types, bulk operations, exception handling, analytical functions, DBMS packages, XML-DB and HTML-DB etc.
• Experience in developing SQL*Loader control programs and PL/SQL validation scripts for validating data to load data from staging tables to production tables.
• Proficient in writing UNIX KORN/BASH Shell Scripts.
• Experience in Design programming patterns and network architecture.
• Understand data modeling concepts and application programming principles
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Developed Test Strategy, Test Plan, Test Cases (Functional and Non-Functional), Test Scenarios from System Requirement Specifications and Business requirements.

TECHNICAL SKILLS:

Databases: Oracle 8i, 9i, 10g, 11g, 12c, MS-SQL Server, MS-Access.

Operating Systems: UNIX, Sun Solaris, Linux, Windows NT/2000/XP/7/10

DB Utilities: Oracle APEX 5.0/4.2/4.0/3.2/3.0/2.8 , SQL, PL/SQL.

GUI Tools: SQL*PLUS, SQL Developer, TOAD, SQL*Loader, SQL Navigator, Load runner, Win runner, Crystal Reports, Microsoft Visio, Rational Rose.

Languages: SQL, PL/SQL, C, C++, Java, JavaScript

Scripting Languages: Perl, Bash, Korn

Web Technologies: HTML, CSS, DHTML, XML

Subversion: Tortoise SVN, GitHub

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Sr. Oracle Technical Consultant (PL/SQL and APEX)

Responsibilities:

• Worked with end users and business team to understand the functionality of the applications in Oracle APEX 4.2/5.0
• Developed the applications from scratch using the approved BRD (Business Required Document).
• Responsible for monitoring Database and application server performance.
• Responsible for monitoring web services logs.
• Responsible for writing Linux/UNIX shell & perl scripts for data processing.
• Written complex SQL queries and PL/SQL packages, procedures and functions to extract data from various source tables.
• Designed and built the parsing database schemas for all the application suites.
• Worked and successfully completed creating Pages, Regions, Items etc. in Oracle APEX 4.2 and 5.0 including tackling with the respective differences in Oracle APEX 3.2
• Responsible for developing custom application using APEX. This involves developing APEX Reports and Forms.
• Built appropriate GUI screens for each page in the applications. Worked with HTML5/CSS3 to develop/upgrade the GUI of the applications.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Added the JavaScript Functionality in the respective regions and items of the applications. Enhancing/Fixing the existing legacy code to latest styles such as HTML5 Flowcharts and FLASH plugins.
• Enhanced the JavaScript functionality by using ExtJS and ReactJS in required areas.
• Analyzed business requirements and technical specifications of application in development and produced test cases for functional testing, integration testing and regression testing.
• Involved in the meetings continuously with users and modifying the test cases accordingly to test the new features developed in the application as per the user requirements as part of UAT.
• Developed PLSQL scripts to fetch the data from the old VLS Databases and migrate to new MSP Databases.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing & Implementation.
• Created page processes at several instances and computations in APEX.
• Followed standardized patterns to prevent SQL injections and URL tampering from APEX applications.
• Configured SSL for APEX over web logic server, HTTP server and others in Test and production environments.
• Created ODI agent and monitored the daily update loads.
• Developed the PLSQL Scripts to analyze other DB objects like Procedures, Packages, Triggers and Sequences etc in the VLS-MSP migration applications.
• Wrote the Control-M Jobs to schedule the batch files. Written batch files to execute the backend PL/SQL Programs, and Oracle APEX Reports
• Performed the static and dynamic scans of the applications along with ALM tests by using the Jenkins software

Environment: Oracle 11g/12c, Oracle APEX 5.0/4.2/4.1, Control-M, SQL, PL/SQL, TOAD, SQL Developer, SQL *Plus, Windows NT, Linux/UNIX

Confidential, Dallas, TX

Sr. Oracle Technical Consultant (PL/SQL and APEX)

Responsibilities:

• Gathered requirements and review functional requirements, business flows including application security
• Involved in full development cycle of planning Analysis, Design, Development, Testing & Implementation.
• Written complex SQL queries and PL/SQL packages, procedures and functions to extract data from various source tables.
• Responsible for creating Linux/UNIX shell scripts and PL/SQL coding for extraction, transformation & loading (ETL Process) of data from legacy system to SAP
• Working closely with SAP & POS (Point of sales) teams for loading of master and transactional data into SAP & POS systems.
• Developed validations using Ajax calls with JavaScript and PL/SQL packages.
• Experienced in using Application processes and items for code reusability across the application.
• Experienced in building classic reports, interactive reports and dynamic PL/SQL reports to enhance the performance.
• Created procedure and inline view in ODI to divide the data which was as whole tag in the source.
• Followed standardized patterns to prevent SQL injections and URL tampering from APEX applications.
• Experienced in working with several types of pages, items, regions, page processes and branching.
• Experienced in conditional processing of code and display regions based on several conditions.
• Designed the look and feel of the APEX forms (User Interface) along with the users.
• Developed the user interface using the Oracle APEX form types depending on the requirements.
• Developed phase, APEX application and Develop PL/SQL API's for business logic (business Logic is not to be developed in APEX)
• Experienced in using JavaScript, HTML, and CSS and also built standard templates to meet the corporate themes for the application.
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling
• Extensive experience with various test efforts like data validation, integrity testing and Unit testing.
• Used Oracle Designer/Microsoft Visio to produce the ER diagrams, Dataflow, Function Hierarchy and Data Architecture.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Responsible for performance tuning, debugging of ODI objects.
• Created and modified SQL*Loader scripts for migrating flat file data into target DB tables.
• Wrote Shell Scripting programs to execute PL/SQL and SQL Files. Wrote the Corn Jobs to schedule the batch files. Written batch files to execute the backend PL/SQL Programs, and Oracle Reports.
• Created New and modified Database procedures, functions, triggers and other database objects by using SQL Developer & TOAD tool.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.

Environment: Oracle 11g/10g, Oracle APEX 3.2/4.0/4.2, Microsoft Visio, SQL, PL/SQL, TOAD, SQL Developer, SQL *Plus, Windows NT, Linux/UNIX

Confidential, Houston, TX

Sr. Oracle Developer ((PL/SQL and APEX)

Responsibilities:

• Developed query based conditional validations using APEX 4.2/4.1 for forms and reports in the page rendering and page processing.
• Create DB links and synonyms to connect the APEX application database to different database.
• Used Oracle APEX 4.2/4.1 utilities to Export and Import Large Volumes of Data in the format of CSV files, Excel Sheets into the tables.
• Developed and modified Oracle packages, stored procedures, functions, Scripts, synonyms, tables and indexes to implement business requirements and rules.
• Created Oracle Apex Application from Scratch for few applications.
• Implemented the Authorization and Authentication schemes for the application
• Developed query based conditional validations using APEX 4.1/4.2 for forms and reports in the page rendering and page processing.
• Implemented Oracle APEX APIs such as APEX ITEM, APEX MAIL, APEX COLLECTION, APEX APPLICATION, APEX PLSQL JOB and APEX UTIL.
• Created region type, item type and dynamic action plugins using the APEX Plugin functionality and Jquery plugins.
• Create DB links and synonyms to connect the APEX application database to different database.
• Sent Email notification to the users using APEX MAIL.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Implemented Performance Tuning by using Explain Plan and TKPROF tools that included Optimizer hints, using Indexes and also Query tuning.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Batch jobs Design using PL/SQL, SQL* Plus, SQL*Loader, Unix Shell programming.
• Prepare and execute unit and integration test cases and support the build and releases activities. Support the QA and UAT testing.
• Provided production support and 24/7 support for resolving the critical production issues.
• Involved in the solving the tickets that are raised by the end users.
• Responsible for creating PLSQL Programs and UNIX Scripts for Data Validation and Data Conversion.
• Prepared UNIX shell script for the transfer of files from FTP to SFTP.
• Used SVN version control management software’s for maintaining the code version standards and security.
• Involved in conversion of DBMS JOBS to control-m jobs to maintain SLA and to implement more options.
• UTL FILE utility used to write the debug information and also for saving the data to a flat file.
• Used multiple parameterized cursors and complex loops for extracting the data.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in creating UNIX shell Scripts for defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Developed data entry forms, complex and template forms in Forms 6i including creation of Pop-up Menus and maintaining Master Detail relationship.
• Used various LOVS (List of Values) and record groups at various points in runtime.
• Extensive experience with various test efforts like data validation, integrity testing and Unit testing.
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Wrote Shell Scripting programs to execute PL/SQL and SQL Files. Wrote the Corn Jobs to schedule the batch files. Written batch files to execute the backend PL/SQL Programs, and Oracle APEX Reports.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.

Environment: Oracle 11g, SQL, PL/SQL, SQL*Plus, Toad, UNIX, Shell, SVN, Putty PSFTP, SQL Developer, Oracle APEX 4.2/4.1,Oracle APEX 3.2, Control-M (Third-party tool).

Confidential

Oracle Developer ((PL/SQL and APEX)

Responsibilities:

• Developed and implemented authorization and authentication rules for Application Administrators in order to manage the Oracle APEX applications, users, and their log activity details.
• Involved in designing and developing various interactive reports with column filters for managing Applications using Oracle Application Express APEX 3.1/3.2
• Also involved in making changes to the existing forms, and reports (Master-Detail) using Oracle APEX3.2; depending upon the user suggestions and feedback.
• Responsible for moving the Oracle APEX applications to the new development and production server environments.
• Responsible for performing validations against the database column data in Oracle APEX Interactive reports and tabular forms using JavaScript.
• Involved in exporting, importing, and installing the Oracle APEX Applications to the new environments using the Utilities provided in Oracle APEX 3.2
• Created lot of images within the system in the form of Logo, applied the image as a report column, created tabs, lists and many pages using pl/sql.
• Created sign in and signup process for the user login.
• Developed various types of regions (HTML, Report, Form, Chart, Tree, List, PL/SQL Dynamic) using Oracle APEX 3.2 depending upon the requirements, which is a part of page rendering process of the Application.
• Created Custom authorization and authentication for the application.
• Created documentation, design and implemented rich user interfaces using Oracle Apex.
• Created database objects like Tables, Indexes, Sequences and Views etc.
• Involved in design, development and Modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.
• Used extensively Cursor Expressions for data retrieval and manipulation in Oracle Database.
• Developed Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on Table Partitioning and deploying various methods of indexing like local Indexes and Global Indexes on portioned tables.
• Used UTL file package to read and write to external files.
• Used BI Publisher reports to get the data for the application as and needed.

Environment: Oracle APEX 3.1/3.2, Oracle 11g, SQL, PL/SQL, SQL*Plus, PL/SQL Developer, XML, UNIX, PERL.

Confidential

Oracle Developer

Responsibilities:

• Developed Stored Procedures, Packages, and Functions using PL/SQL for the batch framework.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, triggers, packages, stored procedures, roles and granting privileges.
• Responsible for 24/7 Production support during loads.
• Writing PERL shell scripts to massage the data before loading into the database tables.
• Used SERENA pvcs version control management software’s for maintaining the code version standards and security.
• Implementing quality control techniques for bug fixing & troubleshooting the existing batch jobs dependencies and code modules, also used BUGZILLA bug tracking tool.
• Extensively used TOAD, SQL Loader, Materialized views.
• Involved in major code rewrite effort to increase performance by normalizing the data and using index organized tables.
• Performed application SQL tuning using Explain plan, TKPROF, Indexes, Partition Pruning, Bulk Processing and Hints.
• Extensively worked with SQL* LOADER, XML style sheets, global temporary tables to load data into the database.
• Implemented Export/Import Oracle utilities using External tables to move data to different schemas.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Involved in tuning the long running PL/SQL queries for maximum efficiency in various business schemas of batch processing.
• Worked with Business teams to make sure requirements were converted correctly and the correct logic was implemented in the technical design and code.
• Worked with CFM files for the application frontend.

Environment: Oracle 10g, SQL, PL/SQL, SQL Navigator 5.5, Shell scripting, PERL, Adobe Cold Fusion and Windows XP, Linux.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created database objects for the system like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
• Developed Front-end forms depending upon the logic such as Master-Detail form and complex forms for the application.
• Loaded data into various tables from Flat files, Access database as well as from Excel Spreadsheets using SQL*Loader.
• Developed stored procedures, packages and functions for the application that could be called by Forms & Reports.
• Developed complex reports like matrix reports, tabular reports for the systems using running totals, sub totals, grand totals and daily balance.
• Written scripts to create Temporary tables in various schemas and Audit Transactions.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 8i/9i, Linux, UNIX, SQL, SQL*Plus, PL/SQL, SQL*Loader, TOAD