SUMMARY

• 14+ years of total experience in the IT industry wif exposure to client projects in financial, manufacturing, pharmaceutical & Automobile industries and have worked closely wif Client Cell Leads, Client users and development teams and developed various critical business processes in a very efficient manner wifout compromising wif the Quality and successfully translated business requirements into specifications and deliverables.
• TEMPEffective team member wif excellent Verbal and written communication skills. Self - motivated and ability to work under pressure as an individual or as a Team Lead and can work overtime wif 24X7 supports.
• 8+ year of experience on Oracle APEX 4.0/4.1/4.2/5.0/5.1/18.2/19.2/20.1 well versed wif RDBMS like Oracle 10g/11g/12c/18c/19c including the technical design, development and documentation. Adept at responsive web techniques, XML, HTML5, CSS3, JavaScript and jQuery development, progressive enhancement/graceful degradation and mobile web development.
• 9+ years of experience as Oracle Applications (E-Business Suite) Consultant /Developer performing Technical and Functional work in various Financial and SCM Modules.
• Successfully Developed and implemented more than 10 applications using Oracle APEX as per user requirement.
• Expertise in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations
• Implementation, Customization, Upgradation, Extensions, Conversion and Post Implementation Support of Oracle Applications R12 and 11i.
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express.
• Rich experience in writing SQL queries, Views, Materialized views, Database links, PL/SQL procedures, functions, packages, triggers, cursors, collections, Dynamic SQL.
• Good Knowledge in creating E-mails using UTL SMTP & UTL MAIL and in UTL SMTP & UTL MAIL attachment concepts.
• Rich experience in writing SQL queries, Views, Materialized views, Database links, PL/SQL procedures,
• Involved in various stages of Software Development Life Cycle (SDLC) like interacting wif business users, gathering business requirements, drawing up Business/system requirements study, system analysis, unit testing, System integration testing, Documentation
• Expertise SQL, PL/SQL and JAVA programming skills. Proficient in writing Stored Procedures, Functions, Packages and Database Triggers using SQL Plus, SQL Navigator, PLSQL Developer and Toad as development tools.
• Good knowledge of Key Accounting Flex field structure, Chart of Accounts. Very good practice and experience in setting up and customizing Accounting Flexfield of General Ledger based on the Organization’s business setup.
• Extensive experience in design using AIM methodology documents like BR100, MD50/CV40, MD70/CV60, TE20/CV70 and MD120/CV120.
• Strong problem solving and troubleshooting skills while providing production support.
• Expertise in developing forms based on views, tables and procedures in tabular and form layouts.
• Expertise in developing interactive grid, collections, APEX MAIL and etc.
• Expertise in developing both web layout and paper lay out reports in various styles based on the user requirements.

TECHNICAL SKILLS

Oracle ERP Application Suite: Oracle Applications R12, 11.5.10.2, 11.5.10, 11.5.9, 11.0.3 Financial Modules: Account Receivables (AR), Account Payables(AP), iExpense, Fixed Assets (FA), General Ledger (GL), Cash Management (CM), Advanced Collections, TCA. Supply Chain / Manufacturing / Distribution Modules: Purchasing (PO), Order Management (OM), Advanced Pricing, Inventory (INV), iStore, iSupplier, iProcurement. Other Modules: Oracle Workflows, Oracle AOL (System Administration), Oracle Alerts

Oracle Application Express: APEX 3.2/ 4.0/4.1/4.2/5.0/5.1/18.2/19.2/20.1

Development Tools/ Utilities: Forms 10g/9i/6i, Reports 10g/9i/6i, SQL*Plus, SQL Loader, XML Publisher 5.6.2/5.6.3 , Discoverer 4i/9i/10g, Workflow Builder 2.5/2.6, Web ADI Client, Optio, TOAD, PLSQL Developer, SQL Developer, Jdeveloper 9.0.3/10g, J2EE

Web Technologies: OA Framework (OAF), Oracle APEX

Languages: Cobol, C, C++, PRO*C, SQL, PL/SQL, JAVA, JSP, HTML, XML.

RDBMS: Oracle 7i/8i/9i/10g,11g, 12C,18c and 19c SQL Server 2000/2005, MS-Excel

Version Control Tools: Visual Source Safe, PVCS, KINTANA, Star Team

Platforms: MS Windows, HP-UX, Sun SPARC Solaris, UNIX, LINUX, AIX

PROFESSIONAL EXPERIENCE

Confidential, MD

Sr.Oracle Consultant

Responsibilities:

• Provided production technical and functional support and solved many high priority issues.
• Developed database triggers include the part of an existing trigger framework implemented in PL / SQL code and external procedures
• Supporting Employees time, payroll and advanced benefits.
• Developed several XML reports on Oracle APEX.
• Security Features were applied for access rights on various levels using the Authentication and authorization schemes in Oracle APEX.
• Developed Data Templates and Layout Templates for new reports using XML Publisher.
• Prepare program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
• Used dynamic action feature inOracle APEXto increase the functionality and reduce the complexity
• Created Tables, Indexes, Sequences, Triggers, Procedures, and Functions for faster data access and to in corporate business logic
• Involved in integration Bi publisher wifAPEXin printing the reports and printing PDF confirmation forms.
• Used dynamic action feature inOracle APEXto increase the functionality and reduce the complexity
• DevelopedApexapplications and worked in teams and communicated wif different teams at various levels Developed several XML reports on OracleAPEX.
• Involved in fixing the problems and raised issues from custom modifications in the module
• Designed and developed User Interface forms and reports usingOracle APEX
• Was an active member of the requirements gathering team, attended meetings wif the users to gather requirements along wif the business analyst
• Created text items, display items, LOV’s, pop ups and otherapexitems
• Created Custom reports and Customization of Standard Reports in AP, AR and GL which includes extensive PL/SQL code (Procedures and Functions).

Environment: Oracle Applications R12, Oracle 10g, PL/SQL, Developer 10g (Forms 10g, Reports 10g), Windows XP, UNIX, Jdeveloper 10.1.3.1.0 , School Max, Xml Publisher 5.6.3, Workflow Builder 2.6.3.5, Dollar Universe and Star Team.Apex5.0

Confidential, Los Angeles CA

Oracle Techno-Functional Consultant

Responsibilities:

• Coordinated wif the front end design team to provide them wif the necessary stored procedures and packages and the necessary insight into the data.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX shellScriptsaccording to the changing needs of the project and client requirements.
• 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.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functionsandpackagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application

Confidential

Oracle Consultant

Responsibilities:

• Used OracleJDeveloperto support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java, .Net and Hierarchical databases like Oracle and Access.
• Developed and modified a number ofFormsand for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Wrote Shell Scripts forData loadingandDDL Scripts.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Used OracleJDeveloperto support JAVA, JSP and HTML codes used in modules.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
• Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
• Involved inLogical & Physical Database Layout Design.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Performance tuning of Oracle Databases and User applications.
• UsedSQL*Loaderas an ETL tool to load data into the staging tables.
• UsedDTS Packagesas ETL tool for migrating Data from SQL Server 2000 to Oracle 10g.
• Provided user training and production support.
• Improved the performance of the application by rewriting theSQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Confidential, FL

Oracle Technical Consultant

Responsibilities:

• Designed and Developed the GL Interface program to Import Journals into Oracle General Ledger.
• Designed custom programs to load transaction data (invoices etc) into oracle receivables (AR) from legacy system.
• Worked on TCA APIs to insert/update customer data for AR module.
• Customized the collections workflow according to the client requirements.
• Developed custom reports such as Detailed Expenditure Report and Journal Detail Report in General Ledger.
• Developed custom reports in AP, AR and GL, which includes extensive PL/SQL code (Procedures and Functions) using Report 6i.
• Created a form in GL where user can query or enter the new and old accounts and cost centers.
• Used descriptive flex fields to capture additional information in standard forms.
• Wrote UNIX shell scripts to automate the conversion from the legacy systems and also to ftp the files to the legacy systems and to send error message notifications to the user groups.
• Worked on Performance Tuning to optimize SQL Statements.
• Worked on MD-70 document for Development work done.

Environment: Oracle Applications 11.5.10, Oracle 9i, Windows 2000, Developer 2000, UNIX, Developer 6i (Forms 6i, Reports 6i), SQL*Loader, Shell Scripting, TOAD, Discoverer 4i, XML Publisher.

Confidential

Software Engineering

Responsibilities:

• Implemented multi-org feature.
• Modified the custom programs which feed records to the Customer Interface to use the new tables per Trading Community Architecture (TCA).
• Developed PL/SQL packages to validate legacy data for unapplied receipts and used APIs to create receipts.
• Designed and developed layout model and data model for Customization of Reports.
• Customized AP check printing program, Sales Order Acknowledgement and packing slip Reports in Order Management, Inventory and Account Payables using Reports 6i.
• Developed Custom Programs and scripts extensively using PL/SQL and SQL Loader.
• Customized Custom.pll extensively to include business requirements.
• Developed Custom form to hold additional data element in Order Header form
• Performed Forms Personalization in OM and AR.
• Implemented Reports in Discoverer.
• Participated in the research, analyzes, and evaluation of new applications of information technology and made recommendations for their deployment.
• Defined Customers, vendors, terms of payment, interest, also defined Banks, various financial and payables options.
• Involved in post-implementation support.
• Provided global technical support services to Oracle clients

Environment: Oracle Financials 11.5.10, Oracle (SQL, PL/SQL), Developer 6i (Forms 6i, Reports 6i), Developer 2000, Discoverer, Shell Scripting, Workflow builder, JDeveloper 9i, 1.4, UNIX & Windows.

Confidential

Software Engineering

Responsibilities:

• Involved in identifying gaps, other areas for improvement in current environment and implemented some appropriate solutions.
• Involved in pre-upgrade, auto-upgrade, post-upgrade and finishing steps of Oracle Applications upgrading from release 10.7 to 11i.
• Involved in designing and maintaining technical documents.
• Implemented AIM methodology and involved in designing AIM documents.
• Developed Auto Invoice and Auto Lockbox Interfaces in the AR Module.
• Created custom extensions to the standard financial reports by adding attribute columns since the standard report generated was not picking the extra information added through descriptive flex fields.
• Developed new forms using TEMPLATE.fmb and customized the existing forms.
• Initiated Technical Assistance Request wif Oracle Support to get the solutions in the events of product gaps and suspected bugs in the application products.
• Created a form in GL where user can query or enter the new and old accounts and cost centers.
• Created a form, which shows all the payment history made to the vendor including the bank information, invoice information etc.

Environment: Oracle Applications 10.7/11i, Developer 2000, Oracle 9i, PL/SQL, SQL*Plus, Shell Scripting, SQL*Loader, Developer 6i (Forms 6i, Reports 6i), Windows NT, UNIX