SUMMARY

• Around 8 years of experience as Oracle Developer with Extensive knowledge and work Experience in Software Development Life Cycle (SDLC) of client implementations including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.
• Strong experience with E - Business Applications Financials 11i General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), Purchasing (PO), Order Management (OM), HRMS, Oracle Utility Billing (OUB) and Applications Object Library (AOL).
• Strong Experience in front-end and back-end development using Forms 10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/9i, XML Publisher, Workflow Builder, SQL, PL/SQL, Oracle 11g/10g/9i/8i and Oracle Designer10g for Data modeling.
• Extensive and proven experience writing simple and complex SQL queries using Joins, Analytical Functions, Inline views.
• Extensive experience writing Database Triggers, Stored Procedures, Functions, Cursors and Packages using PL/SQL.
• Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, and Tables, Indexes, Constraints, Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Views, materialized views, Bulk collect, Analytic functions (e.g. ratio-to-report, rank etc.) Roles and privileges and others in Oracle 11g/10g /9i database.
• Experience in design and development of inbound and outbound interfaces integrating Oracle Apps with Legacy System using SQL*Loader.
• Hands on experience in implementing RICE (Oracle Reports /Forms, Interfaces, Conversions, Extensions) components, workflows, OBIEE, Oracle Alerts, Lookups, OA Framework (OAF), XML Publisher Reports.
• Expertise in Oracle SQL, PL/SQL. Skilled in Application development using Oracle Forms and Reports with knowledge in master-detail blocks, forms triggers, system variables, multiple form applications, menus, alerts and LOV's.
• Strong in Data Modeling including Analysis of requirements Document, Design of the Dataflow, ER Diagrams, Use Cases, Normalization and Demoralization of Tables.
• Good knowledge on Upgrading Oracle Forms & Reports.
• Proficient in Application and SQL statement tuning using optimizer hints, Explain plan, SQL trace, TKPROF, Auto trace, Parallelism, Stored Outlines and Partitioning etc.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.
• Good team spirit and organized working habits with a willingness to learn new concepts.

TECHNICAL SKILLS

ERP Application Version: Oracle 11i, R12

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

Databases: Oracle 8i/9i/10g/11g,DB2, MS Access, My SQL

Tools: PL/SQL Developer, TOAD, SQL*Loader, SQL*Net, SQL*PLUSData Loader, Erwin

Reporting Tools: XML/BI Publisher, OBIEE, QlikView

GUI: Forms 6i/9i/10g/11g,Reports 6i/9i/10g/11g,OAF using JDeveloper 9i/10g/11g, Discoverer 9i/10g, Informatica 8.6, Eclipse 3.2.2

Bug Management Tools: STAR JIRA, Bugzilla, Numara Track IT, Footprints

Environment: Windows NT/9X/2000/XP, UNIX, LINUX, MS-DOS

Web Servers: Apache, Tomcat, OC4J, Oracle Application Server, Web Logic

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

Oracle Developer

Responsibilities:

• Worked on complete Software development Lifecycle (SDLC, from gathering requirements to deployment).
• Created heavy stored procedures by using procedural parameters & worked with packages, blocks & exception handling, Oracle stored procedures, packages, Forms, and Reports.
• Involved writing complex SQL, Stored Procedures, Triggers and monitoring performance to ensure efficient data retrieval and generate forms and reports.
• Created database objects such as Stored Procedures, Functions, Packages, synonyms, Collections, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links and user-defined data types in Oracle according to the business requirement.
• Created Views based on Multiple Tables and performed data changes using Instead of Triggers for the underlying tables.
• Generation of Forms Templates, and developed standards for forms and reports, olb and attached libraries development.
• Developed PL/SQL packages for generating various feeds from oracle database using UTL FILE utility in the client's secure data transmission server.
• Extensively used PL/SQL tables and Bulk loader programs for processing data and loading into oracle tables.
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Used SQL*Loaders to download the data into database from the text files and spread sheets.
• Developed UNIX scripts for sending mails to the client and the business team, when the external feeds to the client are received.
• Used SQL Navigator, a popular tool which increases user productivity and application code quality with rich features to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries.
• Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.
• Created various ad hoc reports as of when required for the production analysis and bug fixing.
• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. For best results, I used these tools with EXPLAIN PLAN.
• Develop AP/AR/GL/PO reports using discoverer which include the following PO requisition reports, AR sales profit report with cost of goods, GL Summary Report.
• .Developed Documentation Templates such as Data Mapping, Functional, Technical and Testing like CV60, MD70 using AIM.
• Customization of PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
• Interfaced legacy system GL data using Journal Import. Run Journal Import to load data into GL JE BATCHES, GL JE HEADERS and GL JE LINES tables.
• Tracking the issues in the CC2012 and specifying the solution.

Environment: Oracle Database 11g/12C, UNIX, Windows XP, SQL * Loader, TOAD, SQL Navigator, Oracle Reports 6i, Oracle Forms 6i, PL/SQL, UNIX, Perl, XML, JSP, Explain Plans, Oracle Applications 11i, GL, AR, AP, PO, Discoverer, HTML Shell scripts.

Confidential, Bloomington, IL

Oracle Developer

Responsibilities:

• Upgrade, maintain and troubleshoot Oracle Forms and Reports.
• Resolve issues with Oracle 11g Forms/Reports application, such as workstation using side printers for slip printing and other reported problems.
• Resolve issues with Oracle 6i Forms/Reports application running on windows 7 or Windows Server 2008R2, if upgrade option is not feasible.
• Resolve issues with Oracle Forms/reports (10g or higher) applications to run on or already deployed on Oracle Exalogic Servers as well as windows 7/8 and windows server 2008R2/2012 use cases, like Development, Virtual machines and Citrix platform.
• Develop a best practice or standards document for Oracle 6i/10g/11gForms/Reports application development.
• Assist in the migration and resolution of issues of the following Oracle 11g Forms and Reports applications to the Oracle Exalogic Servers.
• Worked on solving the behavioral difference issues between 10g and 11g forms debugging the errors.
• Design interface programs to facilitate transfer of large volumes of legacy data from flat file to Oracle Apps modules like AP, AR, GL and FA.
• Participated in R12 upgrade project - upgrading from 11.5.10.2 to R 12.1.3.
• Work on the XML reports like Pick slip report, Packing slip report, Sales Order Acknowledgement report, Invoice reports, quotation reports, Purchase Order reports and Discoverer reports to make sure they are upgraded from 10 to 11 and displaying the same output as in 10.
• Performance tuning of existing Oracle forms as well as newly created Oracle forms using different built-in as well as User-defined functions and procedures.
• Create Database Objects like Stored Procedures, Views, Triggers and functions.
• Create PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Create stored procedures and functions to support efficient data storage and manipulation.
• Gather requirements, write technical (MD070) and Functional (MD050) and specifications.
• Develop conversion script to convert non-partitioned high data volume table to Partitioned table and implement for performance improvement.
• Involve in conversion of 10g forms into 11g as well as 32-bit to 64-bit Pro*C modules and make sure they function as supposed to.
• Develop scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Hands on experience on all the RICE components like reports, interfaces, conversions, and enhancements.

Environment: Oracle 11g/10g, Oracle Applications 12.1.3, AP, AR, iProcurement, OA Framework(OAF), Oracle Collections, Oracle IPayment, OM, Java, SQL, PL/SQL, Discoverer 4i, Workflow, Forms 10g/11g

Confidential, Pittsburg, PA

Oracle Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Designed/developed/Modified tables, views, materialized view, stored procedures, packagesandfunctions.
• Created newProcedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILE package.
• Critical resource for Level 3 (technical support) involving direct client interaction, worked on critical production issues, optimizingPL/SQLqueries for performance improvement using TKPROF, and SQL Trace. Good knowledge of key Oracle performance-related features, such as cost-based optimizer, execution plans, indexes.
• Experience in handling XML in SQL & PL/SQL
• Experience in custom ETL concept ( PL/SQL ) is added advantage
• Involved in creatingUNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to makeDatabaseFaster and easier to maintain.
• Worked on OLTP for optimization and to facilitate the processing of large numbers of concurrent updates to a database.
• Createdmaterialized viewsrequired for the application.
• Involved inUnit Testing Stored ProceduresandFunctions.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• Wrote Shell Scripts forData loadingandDDL Scripts.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential, Orlando, FL

Oracle Developer

Responsibilities:

• Worked on Agile methodology, and lead a team of 2 developers acting as a Scrum Master to deliver on time.
• Worked and resolved the issues on Drop Shipment, Internal Sales Order in Order Management application.
• Worked extensively on developing forms for the front end to populate various ICD (HealthCare) codes with the Confidential t information and the Diagnostic Codes using Oracle custom tables.
• Performed integrating testing and also worked extensively in tuning the performance.
• Developed Loader Scripts/Shell Scripts to load data into the custom tables.
• Working on serial controlled items and item reservations against the sales orders based on the scheduled ship date in Order Management.
• Developed API’s for the front end application for inbound and outbound data.
• Worked extensively on Reports and Custom Forms.
• Developed reports and customized standard Oracle reports using Report Builder 10g, Discoverer and BI/XML Publisher.
• Hands on experience on all the RICE components like reports, interfaces, conversions, and enhancement.
• Performed migration of Descriptive Flex Fields, Key Flex Fields, and Lookup types.
• Performed SQL tuning tasks for better performance of the queries.
• Developed various PL/SQL packages to perform tasks to insert Confidential t information and data file formats like ORTF and Member Demographic formats from various Pharmacists.

Environment: Java, SQL, PL/SQL, Discoverer 4i, Workflow, Forms 10g, Form Builder 10g/11g, Reports 10g, Form Builder 10g.

Confidential

Oracle Developer

Responsibilities:

• Involved in the Requirement gatherings (SRS) and Development of the Project.
• Responsible to create / modify reports to meet changing business needs.
• Provided complex queries for Data extraction by Business Objects tool for Report generation.
• Coding, Test Data Preparation, Test Case preparation, and Unit Testing of modules.
• Tested, debugged and took measures for maximum performance utilizing query optimization.
• Delivering the product successfully for the UAT Phase and to maintain the Product Version Management. Responsibility is to address any data issues found during UAT testing.
• Performing code review/analysis in a team environment and subsequent code testing in DEV and SIT environments.
• Responsible to implement the product successfully in the Production environment.
• Tuning of SQL queries and PL/SQL Performed performance tuning.
• Created database objects, Developed and modified PL/SQL packages, functions, procedures, triggers.
• New Change Requests for Application functionality and code perspective.
• Designing/modifying design of database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Modified shell scripts to call different procedures and functions in different environments to run in different time periods.
• Deployed, troubleshoot and supported database after implementation.

Environment: Oracle 10g, SQL*Loader, SQL Developer Forms 10g, Shell Scripts, UNIX, Windows XP

Confidential 

Oracle Developer

Responsibilities:

• Involved in Requirement gathering, design, code implementation.
• Created E-R diagrams using MS-Visio.
• Created Tables, Synonyms, Sequences, Views and Stored procedures.
• Requirement gathering, design, code implementation.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines
• Enforced database Integrity using primary keys and foreign keys.
• Created and Modified existing functions and procedures based on business requirements.
• Worked extensively on Exception handling to trouble-shootPL/SQLcode.
• Developed Indexes for faster retrieval of data.
• Implemented join conditions, group by functions and nested queries.
• Fine Tuned SQL Queries for maximum efficiency.
• Created parameterized reports and customized existing reports for presentations usingOracleForms and Reports.

Environment: Oracle 8i, Oracle Forms and Reports 6i, Windows NT, SQL, Forms 10g, PL/SQL, Visual Basic 6, Crystal Reports.