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 Purchasing(PO),Accounts Payable(AP), Accounts Receivables(AR), General Ledger(GL),iProcurement, Oracle Projects(PA) (Costing & Billing), Procure to Pay cycle(P2P),Oracle Alerts and XML Publisher.
• Experienced in designing, coding, testing custom applications with 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, 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 usingJDeveloper.
• 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, testingand 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 processand Performance tuning for Oracle custom processes.
• 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.

TECHNICAL SKILLS

Applications: Oracle Applications 11.5.10 and R12 Applications, Markview

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

Languages: Java,SQL, PL/SQL,XML, XSLT,HTML, Linux Shell Scripting

Software/Tools: OracleJdeveloper,Oracle Forms 10g and 6i, Reports 10g and 6i, SQL * PLUS,SQL * Loader, PL/SQL Developer, TOAD, Putty, WinSCP, WINCVS, BI Publisher, Workflow Builder 2.6, Microsoft Office, MS-Visio, Microsoft Visual Source Safe

RDBMS: Oracle 9i/10g/11g

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

PROFESSIONAL EXPERIENCE

Confidential, Miami

Oracle Techno functional Consultant

Responsibilities:

• Remediating 11i custom components to R12 including interfaces, custom Forms and custom Reports
• Experience in developing inbound and outbound Interfaces forAP, AR, POand 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.
• 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.
• Developed and automated scripts for Data cleansing for different modules.
• Gathering the requirements from various parties and working with multiple groups to carry out the development.
• Supporting custom interfaces between Project Accounting PA and Receivables AR, Payables AP and Purchasing PO.
• 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.

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

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

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Primarily worked as a Techno-Functional consultant with core expertise in Oracle EBS in the Procure to Pay cycle and provide production support.
• Monitoring Oracle Applications systems and work on creating scripts for data fix and breakfix changes.
• Created monitoring scripts using Linux shell scripting and PLSQL to monitor business critical processes.
• Manage full life cycle of design, development and testing phases and develop solution design and lead client throughout implementation and support phases.
• Created various data extraction scripts to extract data for reporting and auditing purposes.
• Analyze and solve complex customer issues related to data and processes.
• Perform functional setups, create design documents, user requirement specification, analyze the AS-IS process and provide gap analysis.
• Worked on resolving issues with workflow approval for POs and Internet Expenses.
• Working with Oracle support through Service Requests in resolving issues with standard processes.
• Co-ordinate across teams during integration testing, troubleshooting issues and tracking support tickets.Resolve Production Support tickets with a quick turnover time.
• Worked with DBAs for analyzing and testing patches.
• Organized daily calls with users to report the status of current issues and understand the issues.
• Provide Knowledge Transfer and groom personnel in the team to support the system.

Environment: Oracle Apps 12.0.6, Oracle 11G, Oracle Reports11i, Oracle Forms11i

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

Confidential

Oracle Developer

Responsibilities:

• Worked on modifications to the existing custom objects including custom interfaces viz., OAF, reports and forms.
• Developed multiple interfaces in different modules including PA, AP, and PO.
• 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.
• 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.
• Creating and updating Technical and Functional understanding documents for the developments.
• Process Improvement of the existing billing system.
• 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.
• Coordinating with DBA for promotion of changes from one environment to other environment.

Environment: Oracle Apps 11.5.10, Oracle 10G.

Tools: PL/SQL, Forms 6i, Reports 6i, JDeveloper.