SUMMARY

• Software professional with OCA certified having 13.5 Yrs. experience in Oracle ERP and oracle fusion cloud Experience including Developing, Customizing, Designing, Testing and Implementation of Oracle Financials and Manufacturing modules in Oracle Applications 11i, R12 and oracle fusion cloud R13 20B.
• 1 Year hands on experience in oracle fusion cloud technical R13 in Finance and SCM modules in SaaS (Software as Service) and PaaS (Platform as Service).
• Good Experience in oracle fusion cloud inbound and outbound interfaces, BI reports, OTBI reports, BPM automation
• Good understanding of Fast Formulas in Fusion HCM
• Good experience in Fusion Application Security.
• Good Knowledge in using REST and SOAP services.
• ADF web pages development (Jdeveloper 11g, 12c), ADF - EBS integration (embedded/standalone), Weblogic Server deployment.
• 3 Years hands on experience Oracle ADF 12c, JDeveloper, Oracle ADF Development (ADF, ADF Faces, ADF Task Flows, Business Components, View Criteria’s, DataControls & Bindings, view accessor) with Web Services.
• Good knowledge in MVC, ADF Architecture and ADF Life cycle.
• OAF web pages application development (Jdeveloper 10g, EBS R12.1.x, R12.2.x)
• Expertise in developing Oracle Application Framework(OAF) Pages extensively
• Implemented various customizations by developing custom oracle forms and Custom PLL and Forms Personalization.
• Good knowledge in Strong database conceptual skills and SQL, PL/SQL & SQL*Plus Programming Languages.
• Good Experience in working on Oracle 8/8i/9i/10g Database, Oracle Applications 11.5.10i, R12.2.3 Developer 2000 2.1, Developer 6i.
• Expertise in reporting the various oracle reporting tools includes Oracle Reports, XML publisher, BI Publisher, SQL Reports.
• Expertise in developing Interface loading scripts extensively
• System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Developed Loader Control scripts for different conversions and interfaces using SQL Loader.
• Worked-on customizing various Oracle Forms6i and Forms10g with Template.fmb.
• Good experience in using Application Implementation Methodology (AIM)
• Involved in all phases of Software Development Life Cycle.
• Expertise in Shell Scripting.
• Expert in vertex O series tax engine integration with oracle ERP.
• Exposure to Development and Migration Projects
• Proficient Experience in Payables (AP), Receivables (AR), General Ledger (GL), Fixes Assets (FA), Project Accounting(PA), Purchase Order (PO), Order Management (OM), Inventory (INV), IExpense, Isupplier, AOL and System Administration.
• Good communication, analytical, computational and teaming skills.
• Experienced in Documenting the Software Requirements Specifications including Functional Requirements, Data Requirements and Performance Requirements.
• Strong Technical background, excellent analytical ability, team player and goal oriented, with a commitment toward excellence.
• Highly organized with the ability to manage multiple projects and meet deadlines.
• Have the motivation to take independent responsibility as well as ability to contribute and be a productive team member.
• Excellent team player and can work in Development/Staging/Production environment.
• Good team player and can work independently and willing to relocate.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Shell Programming

ERP: Oracle Apps 11.5.10, R12.2.3 ( AP, AR, GL, FA, PO, OM, INV, PA, IExpense and ISupplier) and Oracle Fusion cloud ( AP, AR, GL, FA, PO, OM, INV)

Databases: Oracle 9i, 10g

Reporting Tools & GUI: Oracle Reports, TOAD, XML Publisher, BI Publisher(BI and OTBI), Oracle Forms, Customizations (CUSTOM pll and Forms personalization), Workflows, Oracle Discoverer and Oracle SQL Developer

Frameworks: Oracle Application Framework(OAF), Application Development Framework (ADF)

Oracle Tools: Sql * Plus and Sql * Loader

Web Technologies: HTML, JavaScript and XML

OS: Windows 2000, WinNT, Win-/95/98

Other Tools: SQL * Plus, SQL*Loader, Data Loader, Toad

Methods: Oracle AIM for Documentation and Test Scripts preparation

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, Neveda

Senior Programmer Analyst

Responsibilities:

• Highly responsible in Coordinating with Project Manager, Business Leads and Functional Owners to gather requirement for all new OAF, ADF and RICEW Components.
• Involved in the design of AIM (Application Implementation Methodology) documents (MD50, MD70 and MD120) for all the RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects, OAF and ADF components.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications R12 Procure to Pay Modules (Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), General Ledger (GL), Purchasing (PO), Inventory (INV),Order Management (OM), Project Accounting(PA), Iprocurement and Iexpenses).
• Expertise in Fusion Application Extensions and Customizations (Page Composer, MDS Customizations)
• Involved in developing outbound and inbound interfaces in Fusion Finance modules using the FBDI.
• Involved in Fusion Application Security Setup.
• Developed the new reports in Fusion application using the BI/OTBI.
• ADF web pages development (Jdeveloper 11g, 12c), ADF-EBS integration (embedded/standalone), Weblogic Server deployment .
• OAF web pages application development (Jdeveloper 10g, R12.2.x)
• Developed new ADF pages for the AP module.
• Developed new OAF pages for the various modules in oracle EBS.
• Worked on oracle ERP integration with Vertex engine coding and expert in analyzing the code for Tax Links.
• Developed some new interfaces for new operating unit ON Services and integrated with oracle ERP using SOA suite.
• Worked as developer in Multi Organization Access Control (MOAC) project and converted all the oracle objects to work in the MOAC environment
• Developed the solution for long standing problem for PDF rendering, which helped the business to complete the work in less time
• Developed the program to extract all the custom oracle objects and created the repository for code change for all the developers.
• For R12c database upgrade, tuned so many reports (.rdf and xml publisher reports) and interfaces for performance improvement.
• Developed new Discoverer reports for Tax and AP discounts.
• In OAF, developed the new custom pages from scratch, done the CO, VO and AM extensions and page personalization’s.
• Helping the offshore team in understanding the business process, code reviews and suggesting optimistic solution designs.
• Developed the XML Publisher reports on the Purchasing module for PO print report and worked on the new enhancements for other XML Publisher reports.
• Worked on the production issues and enhancement requests for all the financial modules AP, AR, GL, FA, CM IExpense and Isupplier and Supply chain modules INV, PO, OM and FA .
• Involved in the testing of all the components for database 12c upgrade project.
• Developed the new OAF form for Audio and Video Flow in the Confidential show events.
• Responsible for developing the new XML Publisher reports and to modify the existing reports for the new enhancements.
• Written new interfaces and shell scripts for Iexpense notifications.
• Developing new OAF pages in IExpense and Isupplier.
• Doing the new ADF pages and enhancements for existing pages.
• Converting the .fmb forms to OAF and ADF pages.
• Requirement/feasibility analysis for any new developments in Oracle E-Business Suite (OAF, Workflow and ADF)
• Participating in meeting with functional team and assist in good design (in terms of feasibility and alternate approaches).
• Ensures that all the assigned deliverables are completed on time and with impeccable quality.
• Follow documentation, software development methodology, version control and testing, and migration standards.
• Responsible to create Unix Shell Scripts for code deployment of Packages, Procedures, SQL Files, Reports, OAF pages, XML Publisher reports and LDT files
• Responsible for creating New Forms, Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Worked to improve the performance of the system by tuning and restructuring PL/SQL units for optimum performance.
• Designed and developed PL/SQL concurrent programs, Oracle Forms, Oracle reports.
• Customized and modified the existing forms using Form builder according to the requirement of the Business user.

Confidential, Las Vegas, Neveda

Senior Programmer Analyst

Responsibilities:

• Highly responsible in Coordinating with Project Manager, Business Leads and Functional Owners to gather requirement for all new OAF, ADF and RICEW Components.
• Involved in the design of AIM (Application Implementation Methodology) documents (MD50, MD70 and MD120) for all the RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects, OAF and ADF components.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications R12 Procure to Pay Modules (Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), General Ledger (GL), Purchasing (PO), Inventory (INV),Order Management (OM), Iprocurement and Iexpenses).
• For R12c database upgrade, tuned so many reports (.rdf and xml publisher reports) and interfaces for performance improvement.
• Developed new Discoverer reports for Tax and AP discounts.
• In OAF, developed the new custom pages from scratch, done the CO, VO and AM extensions and page personalization’s.
• Developed the XML Publisher reports on the Purchasing module for PO print report and worked on the new enhancements for other XML Publisher reports.
• Worked on the production issues and enhancement requests for all the financial modules AP, AR, GL, FA, CM IExpense and Isupplier and Supply chain modules INV, PO, OM and FA .
• Involved in the testing of all the components for database 12c upgrade project.
• Developed the new OAF form for Audio and Video Flow in the Confidential show events.
• Responsible for developing the new XML Publisher reports and to modify the existing reports for the new enhancements.
• Written new interfaces and shell scripts for Iexpense notifications.
• Developed new OAF pages in IExpense and Isupplier.
• Developed the new ADF pages and enhancements for existing pages.
• Converting the .fmb forms to OAF and ADF pages.
• Requirement/feasibility analysis for any new developments in Oracle E-Business Suite (OAF, Workflow and ADF)
• Participating in meeting with functional team and assist in good design (in terms of feasibility and alternate approaches).
• Ensures that all the assigned deliverables are completed on time and with impeccable quality.
• Follow documentation, software development methodology, version control and testing, and migration standards.
• Responsible to create Unix Shell Scripts for code deployment of Packages, Procedures, SQL Files, Reports, OAF pages, XML Publisher reports and LDT files
• Responsible for creating New Forms, Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Worked to improve the performance of the system by tuning and restructuring PL/SQL units for optimum performance.
• Designed and developed PL/SQL concurrent programs, Oracle Forms, Oracle reports.
• Customized and modified the existing forms using Form builder according to the requirement of the Business user.