adiip6@r.postjobfree.com cell: 813-***-****

**** ***** **, *********, ******* 46143

SENIOR ORACLE DEVELOPER / ORACLE FORMS DEVELOPER

Versatile, results-driven IT professional with 13+ years of experience developing applications while participating in planning, analysis, and implementation of solutions in support of business objectives. Excel at providing comprehensive design, system analysis, and full life cycle project management. Hands-on experience in leading all stages of system development efforts, including requirement gathering, architecture, software analysis, design, development, support, and performance tuning. Worked in a wide variety of applications areas, can work as part of a team and on own initiative, working towards corporate goals.

AREAS OF EXPERTISE:

Oracle (SQL, PL/SQL) 8.0/9i/10g/11g/12c

Oracle forms & reports (6i, 10g, 11g & 12c)

DBMS Scheduler

SQL loader

SHELL scripting

Linux Crontab Jobs

PHP

TECHNICAL PROFICIENCIES

Tools:

Toad, SQL developer, PL/SQL developer, Visio, SQL* Loader, SVN, Notepad++, Microsoft Office, Oracle forms & reports (6i, 10g, 11g & 12c),

PHP, Git

Oracle Applications:

Oracle E-Business Suite (Accounts Receivable (AR), Accounts Payable (AP), and General Ledger (GL))

Databases:

Oracle 8i/9i/10g/11g/12c

Platforms:

Windows 2008/9x/NT/XP/Vista/10, UNIX (Sun Solaris, HP-UX, AIX), Linux (Red Hat)

Languages:

PL/SQL

Scripting:

Shell Scripting, Python

Job Scheduling methods:

DBMS Scheduler, Linux Crontab Jobs

Industry Skills:

Technology, Financial Services, Retail Services, Healthcare, IT Services, Insurance, Manufacturing, Utility, BMV Services, Education Applications

Methodologies:

Waterfall, Agile, Scrum, Unit Testing

Applications:

TFS

PROFESSIONAL EXPERIENCE

NGA GROUP INC, NORTH BRUNSWICK, NEW JERSEY

Project for Client – Department of Education, State of Mississippi

ORACLE FORMS DEVELOPER Mar’20 – Present

This client Department of Education, State of Mississippi provides web portal for teachers. The portal offers modules to maintain student’s information, courses, and grades. The role involved Oracle 12c Database, Oracle forms & reports 12c, TOAD technologies and PHP.

Key Achievements:

Enhancement of the existing programs and development of new programs according to end user requirements.

Designed, developed, troubleshoot and debug of the Application software.

Working on Oracle form triggers, alerts, data blocks, LOVs, menus, parameters, libraries, and program units by using PL/SQL procedures and functions of objects-oriented methodology.

Design and coding of Database Objects such as procedures, functions, packages, and triggers according User requirements.

Worked under the guidance of senior PHP developer to design and code new features or enhancements for existing web applications.

Worked with the database schema design and normalization for database accessed by the procedural PHP pages.

Designed dynamic websites according to client requirements and wrote appropriate PHP program scripting commands to ensure accurate data is retrieved from database.

Utilized tools such as Git and SVN.

Project for Client – Department of Revenue – Motor Carrier Services, State of Indiana

SENIOR ORACLE FORMS DEVELOPER Jul’17 – Feb’20

Recruited to design and implement motor carrier international registration process modernization project for State of Indiana, Department of Revenue – Motor Carrier Services. This client provides web portal for motor carriers. The portal offers modules for vehicle registration and filing fuel taxes, the data-driven rules processing engine and reconciliation, helping the end user to validate registration and fuel taxes before they are processed for payments/refunds. The role involved Oracle 12c Database, Oracle forms & reports 11g/12c, PHP, TOAD, DBMS Scheduler, SVN, Git and Linux shell scripting technologies. Agile development practices were used.

Key Achievements:

Creating and developing highly complex applications using Oracle as back-end with expertise in design and development of Oracle PL/SQL packages and procedures.

Construct complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD).

Extensively used cursors, ref cursors and exceptions in developing packages, procedures, and functions.

Debugging the code and created error log package to record all the bad records along with error codes and error message.

Involved in debugging and performance tuning of top resource consuming programs.

Data migration from DB2 database to Oracle Database.

Experience with REST APIs, with a basic understanding of object-oriented programming (OOP) design patterns.

Managed and maintained development of PHP backend for dynamic database driven applications and a clear understanding of the entire project life cycle including analysis, design and development.

Built PHP for controlling text display issues cross-platform and cross-browser.

Worked with Senior PHP developers to understand and enhance user experience.

Contributing to the scrum team by analyzing, developing, testing, documenting, and maintaining high quality software solutions as required. Meeting the milestones set for projects and for completing user stories in sprint as stated in the definitions of done.

Supported QA team for testing and for demo related activities on the end of each of the two-week sprints.

Obtained hands-on experience of working with different open-source technologies, agile and scrum methodology, and understood the entire SDLC in corporate environment.

Developing, scheduling, and maintaining the Linux jobs (Crontab).

Working on daily production Issues from End Users.

Project for Client – Southwest Gas Corporation

PROGRAMMER ANALYST Feb’16 – Jun’17

Operated as Senior Oracle Forms developer with the client Southwest Gas on Gas Transaction System (GTS) module to buy gas from supplier and selling to customers. The project itself was rewriting the purchase module and creating the similar application to facilitate the new functionalities and process includes creating deals, scheduling gas, nominating gas pipe, invoicing. Took responsibility for developing features across both front end and back end.

Key Achievements:

Direct Interaction with the End Users and gathering the functional requirements for Gas Transaction System (GTS).

Written the Technical Design Documentation for the Functional Specifications.

Developed Various Transactions Forms (Creation of Deals, Scheduling GAS and Nominations of gas Pipe).

Developed Master / Setup related Forms for defining Transaction data (Deal Types, Penalty Types and Agreement Types).

Created daily jobs for appending data in multiple tables using Schedulers.

Scheduling Procedure, Functions or Packages to get next Cycle information using DBMS Scheduler.

Involved in Bug Fix & new customizations in oracle 11g forms and reports.

Written Views, packages, procedures, and functions in database for the forms usage.

Written test case and technical documents.

Enhancement of existing programs such as Procedures, Functions, Packages according to User requirements.

Tuned SQL statements using SQL Trace Files, Explain plan, TKPROF for maximum efficiency and performance.

Identified and fixed application performance issues by providing proven scientific solutions.

COGNIZANT TECHNOLOGY SOLUTIONS, CHENNAI, INDIA

Project for Client – AbbVie – SLM Development

SENIOR ASSOCIATE - PROJECTS Sep’15 – Jan’16

Operated as a Team Lead with the client AbbVie is a global biopharmaceutical company focused on developing advanced therapies that address some of the world’s most complex and serious diseases. This application is to transport the samples for testing in different cycles. We had created the application for the user to get the information of samples to be tested in particular timely manner. Combination of testing will be created for the samples and Notifications will inform the user about a testing sample. The role involved Oracle 11g Database, TOAD, FTP, WINSCP, Putty, and shell scripting technologies.

Key Achievements:

Involved in gathering the functional requirements from functional team.

Working with ADF development team during requirement gathering and Database designing phase.

Enhancement of existing programs such as Procedures, Functions, Packages according to End User requirements.

Analyzing the code and Estimating time for the bug tracker and assigning work to associates.

Extensively used cursors, ref cursors and exceptions in developing packages, procedures, and functions.

Project for Client – Abbott Laboratories – Apps Suite

SENIOR ASSOCIATE - PROJECTS Feb’14 – Aug’15

Operated as a Team Lead with the client AbbVie is a global biopharmaceutical company focused on developing advanced therapies that address some of the world’s most complex and serious diseases. This application to Self-Service modules of Oracle E-Business Suite (EBS) (Oracle Financials for Enterprise Resource Planning (ERP)). The role involved Oracle E-Business Suite (Working ~ 90% Technical and 10% Functional within Accounts Receivable (AR), Accounts Payable (AP), General Ledger (GL)), SQL Developer, FTP, WINSCP, Putty, and shell scripting technologies.

Key Achievements:

Working with application development leads, establishes, maintains, and ensures compliance with standards for development, testing, and documentation.

Advanced technical knowledge Financial Accounting Hub.

Strong functional knowledge of Oracle Financial apps modules (GL, AR, AP, Oracle workflows).

Development efforts include standard and or custom solutions, internal & third-party interfaces, reporting, conversions, migrations, and upgrades Interact with peer developers, analysts, system administrators to diagnose and implement enhancements, projects, patches, & bug fixes.

Build time estimates for complex project work, enhancements, and bug/fixes.

Participates in systems planning, scheduling and implementation. Collaborates with project team to keep projects on schedule by coordinating activities, monitoring project schedules, and costs.

3I-INFOTECH, CHENNAI, INDIA

Project for Client – Star Health and Allied Insurance Co Ltd.

TECHNICAL LEAD Feb’10 – Jan’14

I am operated as a Technical lead as well as Senior Oracle Forms and Report developer, working on all parts of PREMIA (Health Insurance product) that drives them for this Client Star Health and Allied Insurance Company Limited (Star Health) which deals in Personal Accident, Mediclaim’s and Overseas Travel Insurance. Implemented PREMIA for their Underwriting, Claims and Finance modules. Technical lead for few small projects like Agent Commission. The role involved Oracle 11g Database, Oracle forms & Reports 10g & 11g, TOAD, FTP, WINSCP, Putty, and shell scripting technologies.

Key Achievements:

Performance improvement and tuning (SQL queries and PL/SQL programs) using OEM and AWR reports.

Design and coding of many Database Objects such as procedures, functions, packages, and triggers according User requirements.

Application maintenance and enhancement support to the end user regarding the product/software application.

Created several new non-template Oracle forms from scratch. Customized existing Oracle forms to accommodate new functionality.

Worked on complex multi-forms issues which includes CALL_FORM, OPEN_FORM, NEW_FORM and form triggers features.

Oracle forms developed and deployed in all UNIX environment through development, test, and production Oracle applications environment.

Worked on TOAD data modeler and TOAD monitoring.

Generated daily and weekly flat files using the UTL packages and sending to data warehouse (ETL) schemas.

Enhancement of the existing programs and development of new programs according to end user requirements.

Designed, developed, troubleshoot and debug of the software.

Installing and Configuring the Oracle Forms and Reports 12c.

Developed the new modules as per the end user requirement such as Renewal Control System, DMS, and Agency Commission Process etc.

STRABUS SOFTWARE SOLUTIONS PVT LTD, HYDERABAD, INDIA

Project for Client – Owens Corning

SENIOR ENGINEER Apr’07 – Jan’10

I developed and maintained applications in ERP System software suite for the client Owen Corning Glass fibre Manufacturing unit. The ERP System software suite is an integrated product of all Modules contains Accounts, Payroll, Production and Quality, Purchase, Stores, Trading and Warehouse modules and is written in Oracle forms & Reports. It has a multi-tier architecture with a repository stored in Oracle database, which is designed for concurrent multi-user access. Full lifecycle software development. The role involved Oracle 11g Database, Oracle forms (4.0 & 6i) & Reports (2.0 & 6i), TOAD.

Key Achievements:

Customization, Design and Development of Forms and Reports Including Changes in Stored Procedures, Functions, Packages and Triggers in PL/SQL Blocks.

Created several new Forms from scratch and customized existing Forms to accommodate new functionality.

Worked on Forms Triggers, Alerts, Data Blocks, LOVs, Menus, Parameters, libraries, and Program units by using PL/SQL procedures and functions of objects-oriented methodology.

Real time updating of financial data in books of accounts by integration of all modules thereby ensuring the correct information with minimal data entry

Involved in support and enhancements of all modules, User creation, Database Enhancements

Interacting with User for requirement gathering, system analysis and finalization of technical/ functional specifications for the project and Maintaining Live Database Server

Real time updating of financial data in books of accounts by integration of all modules thereby ensuring the correct information with minimal data entry

Developed Material gate pass & Visitor’s gate pass Module

Development of Payroll (for workers) Module linking to PACE Swiping System as inputs

Bank Payments of HDFC Bank are handled through system in a respective format given by HDFC Bank.

EDUCATION

Bachelor of Technology in Information Technology Aug’03 – Nov’06

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY AT ANDHRA PRADESH, India

Contact this candidate