SUMMARY:

• Total 8 years of experience in Oracle Technologies and E - Business Suite of Applications.
• Implementation and technical expertise in Oracle Applications R12/11x, across Modules such as Accounts Payable(AP), Purchasing(PO), Accounts Receivables(AR), General Ledger(GL), Fixed Assets(FA), Cash management(CE), Internet Expenses(OIE), iProcurement (iProc), Alerts and XML Publisher
• Experienced in designing, coding, testing custom applications with an integration to Oracle Applications
• Experienced in Oracle Application System Administration, AOL System Admin Activities such as Creating KFFs, DFFs, Profile Options, Value Sets, Users, Responsibilities, Managing Concurrent Programs and Requests.
• Extensive experience in creating Stored Procedures, Functions, Packages and other database objects using SQL and PL/SQL. Experienced in UNIX/LINUX shell scripting.
• Experienced in developing custom Oracle Forms using Oracle Forms 10g/6i. Used CUSTOM.pll to customize the standard Oracle Forms and Forms personalization to personalize the forms.
• Experienced in Customizing standard Oracle Reports using Reports 10g/6i in GL, AP, FA, AR and PO modules as per business user requirements.
• Experienced in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper.
• Experienced in requirement gathering, design and development of custom applications in Oracle Applications Framework (OAF) environment.
• Experienced in implementation and upgrade from Oracle 11i to R12
• Experience with Oracle SLA(Sub Ledger Accounting), MOAC and TCA
• Experienced in implementing, scripting, testing and supporting heavily customized Oracle Applications environment.
• Experienced in implementing WebADI and Oracle Report Manager Utility for Oracle reporting.
• Experienced in implementing in Oracle XML Publisher Bursting functionality.
• Experienced in integrating SOA with Oracle EBS using BPEL processes
• Experienced in Patch analysis process and Performance tuning for Oracle custom processes
• Completed Oracle s in Oracle EBS R12 and 11i
• Experience includes exposure to all the phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance.
• Great exposure to Client Interaction, Requirement Gathering, Designing, Development, Testing, Team Leading, Release Management and Follow ups.
• Experienced working in onsite-offshore support model.
• Possesses excellent communication and inter-personal skills.

SKILL:

Applications: Oracle Applications 11.5.10 and R12 Applications, Markview

Modules: PO, AP, AR, GL, CE, FA & AOL, Oracle Workflow

Languages: SQL, PL/SQL, Linux Shell Scripting

Software/Tools: Oracle Forms 10g and 6i, Reports 10g and 6i, SQL * PLUSSQL * Loader, PL/SQL Developer, TOAD, Putty, WinSCP, Oracle Jdeveloper 10gBI Publisher, Workflow Builder 2.6, Microsoft Office, MS-Visio

RDBMS: Oracle 9i/10g/11g

Operating System: HP-UX, Linux, Windows XP, Windows 7

PROFESSIONAL EXPERIENCE:

Confidential, Miami

Apps Technical Consultant

Responsibilities:

• Remediating 11i custom components to R12 including interfaces, custom Forms and custom Reports
• Experience in developing inbound and outbound Interfaces for AP, AR, PO, CE and GL interfaces to load data from legacy systems into Oracle.
• Developed custom interface to load GL daily rates from external system.
• Developed custom treasury application for Confidential financial reporting.
• Developed GL Budget interface to load Oracle budget data from external system.
• Developed Custom reports based on RDF and BI Publisher Templates for all financial modules
• Worked on Form personalization on PO Entry form, Daily Rates Form and OAF personalization on Supplier entry page.
• Experienced in using FNDLOAD and XDOLOADER functionalities in migrating various components from one instance to another instance.
• Customized PO Approval workflow to default the From Email address of the notification based on the OU of the PO and Expense Approval workflow to modify the default approval durations
• Gathering the requirements from various parties and working with multiple groups to carry out the development.
• Customized Supplier entry OAF page to force the supplier name Upper case by extending the controller
• Developed and migrated OAF personalization on various OAF pages to hide/show fields/buttons and enabling DFF values.
• Preparing and reviewing MD050, MD070, MD120 and UTC documents.
• Function as the primary liaison between the business line, operations, and the technical areas.
• Organizing daily calls with onsite/offshore to report the status of current development and understand the issues.
• Creating and reviewing the technical design documents and test case documents for all the components
• Coordinating with users for SIT/UAT testing.

Solution Environment: Oracle Apps R12.1, Oracle 11G, Oracle Reports 10g, Oracle Forms 10g, Oracle SOA

Tools: PL/SQL, Toad 8.6.1.0, Jdeveloper, Workflow Developer, SQLPlus, BI Publisher

Modules: PO, AP, AR, GL, FA, OIE and AOL

Oracle EBS Production Support

Confidential, Miami

Responsibilities:

• Working as a Techno-Functional Consultant for this project to support issues in Oracle applications functional and technical areas including custom interfaces, forms, and reports.
• Monitoring Oracle Applications and Markview systems.
• Worked on creating scripts for data fix and breakfix changes.
• Worked on resolving issues with workflow approval for POs and Internet Expenses.
• Creating and using WEBADI templates to for GL Daily Rates, FA Mass Additions, GL Budgets and GL Journals.
• Configuring and supporting FSG reports
• Developing adhoc SQL queries to help users pulling setup and transactional data for auditing and monitoring purposes.
• Created multiple monitoring scripts based on Linux shell scripting and PLSQL queries.
• Configuring and using SVN Tool to version control of different objects.
• Working with Oracle support through Service Requests in resolving issues with standard processes
• Analyzing the issues and preparing Root Cause Analysis (RCA) documents for Problem Management.
• Resolved Production Support tickets with a quick turnover time
• Function as the primary liaison between the business line, operations, and the technical areas.
• Organized daily/weekly calls with Business users to report the status of current issues and understand the issues.
• Organizing daily calls with offshore team
• Provide Knowledge Transfer and groom personnel in the team to support the system

Solution Environment: Oracle Apps 11.5.10, Oracle 11G, Oracle Reports 61, Oracle Forms 61, Oracle SOA

Tools: PL/SQL, Toad 8.6.1.0, Jdeveloper, SQLPlus, BI Publisher

Modules: PO, AP, AR, GL, FA, CE, OIE and AOL

Confidential

Technical Consultant

Responsibilities:

• Code Remediation - Make changes to custom objects (Forms, Reports and Interfaces) to make them compatible to 11g database.
• Testing Support - Assist users and team members during various phases of testing including Unit Testing, SIT and UAT.
• Performance testing support - Assist in performance testing team by providing Oracle set up details and data gathering.
• Participating in customer calls to clarify on the requirements and to discuss weekly status.
• Development of design document for the changes made during DB upgrade.

Solution Environment: Oracle Apps 11.5.10, Oracle 10G

Tools: PL/SQL, Forms 6i, Reports 6i, UNIX Shell scripting and HP LoadRunner

Modules: PO, AP, GL, AR, FA, CE, OIE and AOL

Confidential, Miami

Oracle Developer

Responsibilities:

• Developed multiple inbound and outbound interfaces in different modules including AP, PO, GL and AR.
• Worked on modifications to the existing custom objects including custom interfaces, custom reports and custom forms
• Developed custom interface to load Purchase Orders and Receipts to Oracle from external systems (Crunchtime, AMOS and Stockwatch)
• Developed Custom interface to load AP invoices from external system IMS.
• Created form personalization to default the Payment terms from vendor site for Quickmatch Invoices in Invoice workbench.
• Created Form personalization to automatically copy the PO header DFF values to PO Distribution upon PO approval
• Performing Unit test results for the developments and creating unit test results documents
• Creating and updating Technical and Functional understanding documents for the developments.
• Coordinating with users for UAT testing
• Coordinating with DBA for promotion of changes from one environment to other environment.

Solution Environment: Oracle Apps 11.5.10, Oracle 10g, Oracle Reports, Oracle Forms, Linux Shell Scripting

Tools: PL/SQL, Toad 8.6.1.0

Modules: PO, AP, AR, GL, FA and AOL