PROFESSIONAL SUMMARY:

• Over 5 years of experience as Techno Functional Consultant in Oracle E - Business Suite Applications and web-based applications using different technologies.
• Experience in Oracle Finance and SCM Modules -General Ledger (GL), SubLedger Accounting (SLA), Accounts Receivables (AR), Accounts Payables (AP), Order Management (OM), Oracle Inventory (INV), Oracle Purchasing (PO), iProcurement, iExpenses, Advanced Pricing, HRMS, OLFM ( Oracle Lease and Finance Management).
• Working experience in System Administration activities and Strong knowledge of AOL objects like Value Sets, Lookups, Flexfields, Profiles.
• Good knowledge on Multi-Org concept, Order to Cash (OTC) cycle, Procure to Pay (P2P) cycle, and Supply Chain Management (SCM) business flow.
• Adept at development and customization of RICE (Reports, Interfaces, Conversions, and Extensions) objects.
• Expertise in design and development of Interface, Conversion, Migration and Customization programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces, APIs and UTL FILE Packages.
• Expertise in process/data flow, base tables, interface tables and standard APIs.
• Proficient in registering Concurrent Programs, Form, Functions, Tables, developing Descriptive Flex-fields in Custom Applications and defining Profile values by using Application Object Library (AOL), System Administration and Documentation in Oracle Applications.
• Proficiency with tools used to support Oracle Applications development including Form Builder, Report Builder, and XML Publisher, BI Publisher.
• Experienced in new implementation from legacy systems to Oracle EBS and have very good experience inOracle API's.
• Expertise in SQL, PL/SQL and having good knowledge in advanced PL/SQL concepts like Nested tables, Varrays, PL/SQL Tables.
• Proficient in writing PL/SQL Packages, Stored Procedures, Functions, Database Triggers and SQL * Loader scripts.
• Experience in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf and Indexing. Very proficient in SQL tuning and optimization of queries.
• Experienced in OA Framework Technology (OAF) and MVC (Model-View-Controller) Architecture.
• Worked on Search page, Create page by using LOVs, Insert, Update and Delete operations.
• Experience in supporting the production system and handling day-to-day issues.
• Experience in integrating systems with Oracle SCM Cloud and Custom Product hosted on AWS.
• Experience in all stages of the Software Development Life Cycle involving gathering user requirements, analyzing, designing, developing, testing, implementing and maintaining software applications using diverse software technologies.
• Delivered project deliverables using JIRA under Agile environment.
• Experience in upgrade and implementation of Oracle Applications R12/11x, across the modules such as Order Management(OM), Inventory(INV), iStore.
• Experience in customizing standard oracle reports using Reports 10g/6i and developing custom forms.
• Extensive experience in customizing JSPs, PL/SQL APIs and designing new JSPs, PL/SQL APIs. Also customization experience with workflow messages using oracle workflow builder.
• Prepared technical design documents for customizations and conversions using AIM documentation methodology.
• Experience in research and development of Machine Learning models for security problems, in the area of Networking, Application and Data.
• Strong analytical and problem solving skills and a proven ability to be an effective team player with excellent time management skills.

TECHNICAL SKILLS:

ERP Suite: Oracle E-Business Suite R12/11, Oracle Fusion ; Oracle Order Management, Oracle Inventory, Shipping, iExpenses, iSupplier, iStore.

Database Tools: SQL * Plus, Toad, SQL Developer.

RDBMS: Oracle 10g/9i/8i, SQL Server 6.5/7.0/2000.

Oracle Tools: Forms 10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/4i, Oracle Workflow Builder 2.6.3.5, Developer 2000, XML Publisher, Oracle JDeveloper.

Other Languages: C, C++, Java, JSP, Python, SQL, PL/SQL, HTML, CSS, Java Script, Spark.

Document Methodologies: MD.070, MD.050.

Operating Systems: MS DOS, Windows Family, UNIX, Linux.

Other Tools: MS-Office, Jira.

WORK EXPERIENCE:

Confidential, Davenport, FL

Oracle Apps Consultant

Responsibilities:

• Requirements gathering for the Interface and reports through interaction with functional teams and business users.
• External tables are created as part of development to import legacy data into staging tables which works as loader program.
• Worked on Application System Administration activities such as user set up, defining responsibilities, value sets, request groups, registering reports, concurrent programs, procedures.
• Developed Outbound interface using UTL FILE package which generates the file in FTP location and send sales order list to UPS for delivery.
• Created Unix shell script program which runs on a daily basis to archives the file into archive directory.
• Excellent understanding of AP-SLA-GL link tables in R12.
• Involved in writing Package to extract Orders from Legacy System, validated and imported into Order Management Interface tables and submitted a concurrent request to populate base tables.
• Worked on the development of Interfaces, Customizing Oracle Reports in various modules such as GL, AP, INV and OM.
• Developed Purchase order PO listing report.
• Performed and implemented requirements on Procure to Pay (P2P) Cycle.
• Performed the whole Order Cycle in Order Management (OM), which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order.
• Responsible for Creating Value Sets In AOL and also created Request groups and assigned concurrent programs to them.
• Creating request sets to perform parallel execution of concurrent programs.
• Extensively worked on XML reports, PL/SQL reports with different data model and layout combinations.
• Developed Complex RTF templates using XDO functions also created EXCEL templates and implemented multi sheet concept.
• Developed BI publisher bursting report to send output channel and achieved dynamic selection of templates.
• Converted multiple traditional reports 10g reports into latest BI Publisher reports with RTF layout as per the business requirements.
• Worked on OAF personalization and customization as per the business requirement.
• Involved in performance tuning and done code fixes to improve the performance using Explain Plan, TKPROF and Hints in TOAD.
• Perform unit testing and created Unit test cases and Unit test results for better understanding of the component functionality.
• Creation of release documents which defines Steps for DBA to migrate the components to Test instance and also activities for Apps support team to build AOL objects.
• Helping the users test the application and testing from a development point of view. Also, responsible for End-to-End Testing.

Environment: Oracle Apps R12(PO, OM, INV, AP, AR, GL), Oracle 11g Database, PL/SQL Developer, TOAD, UNIX Shell scripting,, XML/BI Publisher

Confidential, Jacksonville, FL

Oracle Apps Technical Consultant

Responsibilities:

• Created new supplier/new supplier site report and implemented bursting logic to send the output as email attachment.
• Worked with Cisco Invoice Hold Report which works at the Operating unit level and has made it globalized to run at the theater level.
• Involved in adding new descriptive flex fields in Order Management (OM) to capture additional information.
• Development and Customization of Oracle reports using Oracle Report 6i/10g and PL/SQL Reports, XML Publisher, BI Publisher.
• Development of Conversions and Interfaces to import data into Oracle Applications and to export data fromOracle Applications to external files using UTL FILE Package.
• Worked in developing Procedures, Packages, Functions, Triggers, views, records, constraints, synonyms, indexes and other database objects using SQL and PL/SQL for validating the data loads.
• Registered Reports as concurrent programs in Application Object Library (AOL)
• Code Migrations using FNDLOAD for AOL objects and Shell Script for Database objects.
• Prepared Technical documents for requirements, design, and implementation steps, test plans and functional user training guides for all the phases of the project.
• Worked on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
• Developed a procedure to Update External Mass Additions with FCM Details and registered as concurrent program.
• Develop shell script programs to implement mailing and send email notifications to multiple users.
• Designed and developed XML reports, BI reports, PL/SQL reports and implemented bursting logic to send the report to requested users.
• Used FND PROGRAM APIs for registering and deleting programs and executables also used ad dd.register table/register column for registering user tables/columns.
• Created SQL Loader scripts to load data from legacy systems to Oracle Apps.
• Worked with XML Publisher responsibility and defined data definition and template definition while developing BI reports.
• Customized standard Oracle Apps Reports in Inventory and AP Modules.
• Developed Order Management, Inventory, and Fixed Assets, Receivables queries to compare summary information of the standard and custom reports.
• Involved during the Development, Production and Post-implementation support phases of the project.
• Activities also involved migration of deliverables such as PL/SQL packages, LDTs, RDF, and rtf templates to various environments using UNIX shell scripts and FNDLOAD.
• Worked on System Administration activities like Concurrent manager activities, Creating Users, Responsibilities, Menus, Request Set/Groups and Value Sets.
• Used SVN to maintain the code repository and developed migration scripts to migrate all the development work into new instance
• Developed design and implementation documents such as Code Review Checklists and user-documentation and test cases.

Environment: Oracle Apps R12(PO, INV, AP, AR, GL), Oracle 10g Database, PL/SQL Developer, TOAD, SQL Navigator, Oracle Reports 10g, Oracle Forms 10g, UNIX Shell scripting,, XML/BI Publisher, Workflow Builder.

Confidential

Oracle Apps Consultant

Responsibilities:

• Involved in understanding user requirements, designing and developing interfaces.
• Interacted with business analysts and worked on the application specifications to support detailed functional, technical design, and test specifications that fully satisfy business requirements.
• Developed Java Classes to serve the JSP requests that encapsulate business logic.
• Added custom functionality in jsp pages to have custom validations as per business logic.
• Proactively monitored the application status and health check of application environment system.
• Identify the production issues reported by end users and manage problem tickets.
• Lead the offshore team and coordinate day to day activity, work on production issues, providing weekly updates to clients.

Environment: Java, Jsp, Javascript, SQL, PL/SQL, Eclipse, Putty, SVN, Winscp. We used Oracle EBS for setups and backend using Oracle as the database.

Confidential

Associate Software Engineer

Responsibilities:

• Developed extensive Stored Procedures and Triggers in SQL Server.
• Worked on Forms Customizations through CUSTOM.pll and Forms Personalization as per the business requirement.
• Developed custom functionality in many jsp pages to have custom validations as per business logic.
• Involved in Unit Testing and Integration Testing of the entire application.
• Production Support post Go-live on closing issues.

Environment: R12 Upgrade Project, MD050, MD070, Developer 6i, 9i, Oracle Forms, Discoverer 9i, 10g, Reports 6i, 9i, XML, Web services, HTML, CSS, UML, Visual Studio 2012, XML, HTML, SQL Server 2014. We used Oracle EBS for setups and backend using Oracle as the database.