PROFILE SUMMARY:

• Around 8 Plus 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 in systems Analysis, design and development of complex software systems in Banking, Healthcare, Manufacturingsectors.
• 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.
• Experience in Design, Development, and Enhancement and Maintaining applications in Windows 9x/ NT/2000/XP and UNIX environments.
• 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.
• 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 .
• Developed and customized several Oracle Forms and Reports using Forms/Reports builder, Crystal Reports, XML publisher and Discoverer as per client specifications.
• 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.
• Good knowledge on Upgrading Oracle Forms Reports.
• Experience in developing Data Conversions/Data Migration ETL from Legacy System of various sources flat files, excel, Oracle, Non Oracle to Oracle system Using SQL Loader, UTL FILE.
• Hands on experience on ODBC and JDBC programming, UNIX, shell PERL scripting.
• Proficient in Application and SQL statement tuning using optimizer hints, Explain plan, SQL trace, TKPROF, Auto trace, Parallelism, Stored Outlines and Partitioning etc.
• Good working and conceptual knowledge of Java, JSP, web services, Pro C, XML and HTML.
• Having experience in using oracle in built packages DBMS JOB, DBMS SCHEDULER, DBMS ALERT, DBMS SQL, DBMS OUTPUT, DBMS AQ .
• Strong familiarity with AIM methodology in creating BRD, MD 50, MD 70, MD-120 and also Testing documents throughout multiple Projects.
• Worked with version control tools like VSS, CVS, PVCS, SUBVERSION, ClearCase.
• Versatile team player with good analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Proven track record of managing and delivering projects following complete SDLC.

Professional Experience:-

Confidential

Senior Oracle Forms Reports from Oracle 10g to 11g

• Develop conversion script to convert non-partitioned high data volume table to Partitioned table and implement for performance improvement.
• 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.
• Customize standard Unmapped Subsidiary Accounts report using Oracle Reports as per the user requirements for General Ledger Consolidation purposes.
• 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.
• 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 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, Form Builder 10g/11g, Reports 10g/11g, Form Builder 10g/11g

Confidential

Senior Oracle Forms Reports

• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases Worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, DB links and privileges
• Effectively used Triggers to track the user profile updates and to send the messages to downstream systems
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
• Created PL/SQL Stored Procedures, Functions, Packages, and Triggers extensively used Cursors, REF cursors, User-defined object types, Records, forms and reports in PL/SQL programming
• Extracted data from the XML files transmitted to the bank and loaded them efficiently into oracle temp tables for day-to-day customer financial transaction reconciliation.
• Designed and developed Oracle Forms Reports using Forms11g/10g/6i and Reports11g/10g/ 6i Including Forms based on stored procedures
• Analyzed and fixed the data discrepancies between various systems and identified bad data caused due to the data migration from various legacy systems.
• Involved in design and development phases of Software Development Life Cycle SDLC .
• Involved in uploading historical GL Balances through conversion program for various entities
• Used performance-tuning methods to increase the performance of the oracle database.
• Used oracle application server for building reports over the Intranet
• Created new module using Forms and Reports for number portability module.
• Involved in building interfaces between Oracle Accounts Payables AP , order management OM , Purchasing PO , Accounts Receivables AR and Third party systems and provided functional input
• Designed, documented and developed staging tables, conversion routines, Custom PL/SQL API's for converting Inventory Items, AR Invoices and Receipts, Customers using TCA, Open Purchase Orders, Open Requisitions, AP Open Invoices, Suppliers, Supplier Sites, and Supplier Contacts from legacy system to Oracle Applications
• Created and modified several UNIX Shell Scripts according to the changing needs of the project requirements.

Environment:Oracle Applications Release R12 / 11i / 11.5.10, FA, AP, PO, GL, Oracle 11g/10g/9i,Oracle Forms 11g/10g, Reports11g/10g, PL/SQL, SQL Server, UNIX Shell Scripting, Toad, ER-Win Windows XP, .Net, SQL Loader, UTL Scripts

Confidential

Senior Oracle Forms Reports

• Developed Menus in such way that users can access the forms through menus
• Development of Custom screens using Forms10g based on Stored Procedures to implement complex business functionality, Tab canvases.
• Development of Unix Shell scripts to monitor Crontab jobs, UNIX shell scripts run the stored procedures/functions from UNIX
• Development of code using Packages, Stored Procedures/Functions to facilitate business needs.
• Performed database tuning using EXPLAIN PLAN, TKPROF and SQL TRACE, enabling session specific trace using DBMS MONITOR.
• Developed Object Libraries to maintain standards in the Application.
• Usage of bulk inserts to insert the data into multiple tables.
• Developed Reports10g/9i to meet the business needs.
• Designed a workflow management system to streamline the process.
• Was involved in fast paced Agile environment
• Development of dynamic Reports by using Lexical parameter to run the Generic Reports.
• Using Data mapping tools to transfer data between source databases to destination database.
• Web based Development using iAS10g, Forms 10g/9i/6i, Reports10g/9i/6i.
• Developed List of values to populate data in certain conditions based on Record Groups.
• Knowledge in AWR Oracle Report generation from Oracle Instance
• Various procurement and receivables applications like Smart Plant Materials and great plains
• Maintenance of Production Test Databases
• Design and development of many form screens and reports according to business needs
• Performed huge real state arithmetical operations as per the business
• Performed Import Export to SQL Server.

Environment: Oracle Applications Release 11i / 11.5.10, Oracle Database 10g, Forms10g/9i/6i, Reports 10g/9i/6i, Windows XP and Sun Solaris v10

Confidential

Senior Oracle Developer

• Designed and implemented client-server application using Oracle Forms Builder.
• Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.
• Developed various new reports from scratch utilizing Oracle Reports Builder for day-to-day validations.
• Converted reports to browser supportable XML format.
• Customized the AR Invoice, Sales Tax Reports in Receivables using Reports 6i and XML Publisher.
• Created heavy stored procedures for financial transaction by using procedural parameters working with packages, blocks exception handling.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD to create new workflows for Company.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• Designed and Developed Forms for tracking the account details of the customer.
• Developed PLSQL packages for generating various feeds from oracle database using UTL FILE utility in the client's secure data transmission server.
• Extensively used PLSQL 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.
• Customized Order Management Header and Line workflows to meet business requirements
• Create Execute and Optimize SQL queries while providing an interactive community to support the user experience by using TOAD.
• Created procedures and SQL Loader Scripts to populate Customer interface tables with data such as Customer Profiles, Phone Contacts at various levels, Payment Method data Customer Bank data.
• Worked on TCA architecture on identifying relationships and validation process in install base.
• Used SQL Loaders to download the data into database from the text files and spread sheets.
• Developed UNIX scripts for sending mails to the bank and the business team, when the external feeds to the bank are received.
• Involved in conversion/migration of database from Access, SQL Server, DB2, flat files to Oracle data warehouse.
• Wrote PLSQL and T-SQL blocks, Procedures, Functions, and Packages for Migration of flat files and to transfer in exact format in Database Tables.
• Involved in supporting/fixing production defects and day-to-day business transaction issues.
• 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.
• Extensively utilized TOAD for performance tuning by generating explain Plans.

Environment: - Oracle APPS 11.5.10.2 Financials GL, OM, AR, IExpenses, Iprocurement, TCA , Oracle 9i, UNIX, Windows XP, SQL Loader, TOAD, XML Publisher, SQL Navigator, Workflow, Oracle Reports 6i, Oracle Forms 6i, PL/SQL, UNIX, Perl, XML, JSP

Confidential

Oracle Developer

• Extensively used PL/SQL to extract data from different tables with a Million records in some of the tables.
• Designed and developed Oracle forms reports generating up to 60 reports.
• Developed BI/XML publisher reports/XML Reporting in DF Purchasing Modules
• Data Conversion from Flat files to Oracle using Oracle SQL Loader.
• Involved in supporting the delivered conversions and Interface objects. Involved in meetings with users and onsite team.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Developed custom workflows in different modules like PO approval, AP Invoices
• Analysis of DB2 procedures and converted to oracle PL/SQL Procedures for the ETL, NMR Modules
• Analyzed and Designed the DB schema using Oracle database to include Header, Lines and Approvers table in all the modules Inventory, Order Management and Purchasing.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Involved in performance fine-tuning of the queries/reports using PL/SQL and SQL Plus
• Creation and modification of various SQL and PL/SQL scripts.
• Extensively developed PL/SQL procedures using Ref cursors and collections with bulk bind to insert and update millions of rows into target tables
• Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.
• Involved in Debugging, Troubleshooting Procedures, functions, and packages, customizing the existing ones.
• Developed ADHOC Queries and Reports for Users to check status at various levels

Environment: Solaris OS Unix based , Windows XP, PL/SQL, Unix Shell Scripting, Java/J2ee, Java, J2EE, Web Services, Service Oriented Architecture SOA , Oracle 6i Forms and Reports, Oracle Discoverer, Oracle 9i, XML Publisher/BI Publisher, Workflow Builder, TOAD, Oracle Application Framework, Oracle Application Server, HTML, CSS, Java Script, JSP, Oracle 11i Quoting Module.