Oracle EBS Developer
Resume:
RAVITEJA BORRA
ac4fg1@r.postjobfree.com
SENIOR ORACLE EBS DEVELOPER
SUMMARY:
* ***** ** ********** ** various roles/levels of software development, design, Support, Technology Consulting, Training, Customer Support and leading a team with excellent customer reviews and growth in Oracle EBS technologies.
Extensive experience in Conversions, Interfaces and WEB ADI integrators.
Expertise in developing Oracle Approval Workflows for Journals and SLA using AME.
Extensive experience in developing complex Oracle Forms, PLLs, Form Personalization’s, RDF Reports, PLSQL Reports and XML Publisher Reports.
Good Experience in developing Java programs and Oracle Application Framework (OAF) customizations.
Experience in developing ADF Desktop Integration applications for custom processes.
Along with oracle EBS, have experience in other solutions such as Panaya and Assay tool for upgradation to R12, Noetix workbench for reporting.
Proficient in Query Optimization, Debugging, Performance Tuning and Improvising performance of applications and programs using SQL Trace and Explain Plan to analyze queries for efficient data retrieval.
Experienced in Shell Scripting in UNIX Environment.
Expertise in Oracle EBS Accounts Payables(AP), Accounts Receivables(AR), General Ledger(GL), Order Management(OM), Purchasing(PO), INV, Manufacturing(OSFM) and Trade Management(TM) Modules.
Extensive experience in Oracle R12.1.3, R12.2.4 Upgrade projects.
Proficient in developing Discoverer and OBIEE(Presentation layer) reports.
Worked on Oracle ADF (EO, VO, View Link, Entity Association, and Application Module), ADF faces, Templates, Task flow.
Knowledge and experience in Data loader, AIM Methodology and documentations and experience of working with oracle through SRs.
Good domain knowledge of Semi-Conductor Industry and processes.
Extensive knowledge in all phases of Software Development Life Cycle (SDLC).
Excellent Team Management Skills - Played key role in training a team of Members in Oracle Apps and leading them.
Excellent analytical and debugging skills – Specialized in writing complex and customized programs.
EDUCATION:
Bachelors of Technology in Electrical and Electronics Engineering from JAWAHARLAL NEHRU TECHNOLOGY University.
TECHICAL SKILLS:
Languages : PL- SQL, XML, Java, UNIX Shell Script
Reporting Tools : Oracle Reports10g/6i, Discoverer, OBIEE and BI Publisher
Database Tools : PL/SQL Developer, Forms10g/6i, TOAD, SQL*Loader, SQL*Plus, HP Project and Portfolio Management (PPM), Noetix
Version Control Tools : PVCS, Tortoise SVN and Sharepoint
Java/Frameworks : Oracle ADF,ADFDI, JSF, JSP, Servlets, OAF.
ERP Applications : Oracle Apps 11i/R12
Operating systems : UNIX and Win NT/2000/2003/XP.
Databases : Oracle 10g/11g.
PROFESSIONAL EXPERIENCE
CLIENT: Qualcomm (QCT Oracle ERP) Support Project
FEB16– TILL DATE
Senior Oracle ebs Developer
This project provides Managed Support Services that includes technical support in QCT Oracle E-business Suite rel. 12.2.4. Troubleshooting all RICE components related to QCT Oracle ERP, providing technical assistance to the Qualcomm team on business issues across the Oracle applications and integrations, supporting interfaces between Oracle Applications, third party vendor products and other applications, developing new custom interfaces/forms/reports or enhancing existing and documenting the changes made to the application using AIM Methodology. Qualcomm acquired (CSR), a leading fabless provider of end-to-end semiconductor and software solutions for the Internet of Everything (IoE) and automotive segments. Spartan Project is to integrate business processes and systems and utilizing current QCT process design. This includes Forecast to Cash (FTC), Procure to Pay (PTP), Plan to Build (PTB) and QCT Finance processes. It also includes Master Data /Configuration Management (MD/CM), Quality, PTE touch points with Operations & tools, Sales Pipeline & Reference Hardware / Corp Engineering Services.
Responsibilities:
Developed an ERP outbound interface with C-Series product for Payment Process.
Worked on trade management adjustments and claims interface.
Improved performance of complex custom ADF DI application.
Developed custom complex quote approval, Journal AME and SLA AME approval workflows.
Developed WEB ADI integrators to update Supplier and Supplier bank details.
Fixing bugs in data and supporting the custom SAT Supplier Management Process.
Worked on Quote conversion script.
Working on high priority emergency release ITG’s.
Worked on Multi Ledger Multi Currency project.
Created custom SLA source to drive business line segment for revenue.
Developed custom approval workflow for ADF Price Management application.
Environment: Oracle Apps R12.2.4, Oracle 11g, Jdeveloper 12C, Oracle ADF Framework and Subversion
CLIENT: QUALCOMM CDMA TECHNOLOGIES (QCT) R12.2.4 UPGRADE
JAN 2014 – FEB 2016
SENIOR PROGRAMMER ANALYST
This project involves upgrading of oracle EBS from 11.5.10.2 to R12.2.4.
Responsibilities:
Involved in Co-ordination with the Onsite team.
Identifying the solution to the R12 retrofit issues.
Worked on View/Packages/Procedures/Functions/Materialized Views R12 Retrofit.
Worked on Forms/PLL’s R12 retrofit.
Worked on RDF/XML Publisher reports R12 retrofit.
Worked on AOL objects retrofit.
Worked on remediation of all other custom objects to work as is.
Migration to various environments.
Involved in R12 Upgrade Project by getting the remediation done on the finance related objects considering the list generated by Panaya. Involved in fixing critical issues in payment file generation, webadi journal import etc.
Worked on WEBADI tool, Jdeveloper 11g, Oracle Applications 11i, R12.2.4.
Environment: Oracle Apps 11i/R12, Jdeveloper 11g/12C, Oracle 11g, Oracle ADF Framework and Subversion
CLIENT: QUALCOMM SAT SUPPLIER MANAGEMENT
JUN 2013 – DEC 2013
PROGRAMMER ANALYST
Qualcomm CDMA Technologies (QCT) is in the process of restructuring the existing supply chain partner’s relationship and linkages. Suppliers send resource performed on job using 7B1 PIP messages and corresponding Invoices for the services performed in the form of 3C3 PIP messages. This requires company to track Known Good Die (KGD) sent from the foundry to the Subcontract Assembly and Test (SAT), and finished goods from the supplier to Oracle System. The Suppliers will then perform the assembly, test and Scan, Bake, and Tape (SBT) processes which will be interface in Oracle as value is added to the KGD. The Supplier Work in Process (WIP), Lot transformation and inventory movement information will be communicated to Oracle via the Rosettanet 7B1 PIP periodically. This information will be imported to Oracle using the Triniti Lot eDapter tools.
Responsibilities:
Developed WIP Transaction processor interface
Created a custom process Job pre-close processor for ESTIMATED SCRAP ABSORPTION, SCRAP RESOURCE, SUPPLIER PRICE VARIANCE adjustment records in Oracle Shop floor management.
Developed custom forms for custom resource cost.
Developed XML publisher reports.
Worked on 7B1/3C3 PIP transactions.
Worked on custom 3C3 invoice match program.
Developed ADF DI to update SSM control setup table.
Developed AR Inter Company Invoice program.
Environment: Oracle EBS 11i, Oracle 10g, Workflow 2.6.3.5, Oracle Application Framework, Application Development Framework and BI Publisher Reports. Oracle ADF Framework, ADF BC, ADF Faces, Oracle Fusion Middleware, JDeveloper 11g.
CLIENT: Qualcomm Corp Noetix Upgrade
SEP 2012 –JUN 2013
SYSTEM ANALYST
This Project is to convert the Qualcomm CORP Discoverer Reports in to OBIEE reports with underlying Noetix Views. Qualcomm CORP has a lot of Discoverer reports in SCM, Bus Ops and Finance modules. And this project provides IT Functional Support for all the OBIEE reports. Troubleshooting the reports and fixing the bugs of Discoverer in OBIEE. Developing new OBIEE reports by mapping the requirement of the report with the standard Noetix Standard answers. And also incorporating the new enhancements required in OBIEE reports. Also to develop new OBIEE reports with the available Standard and Custom Noetix Views.
Responsibilities:
Designed Functional Documents for the OBIEE reports in Purchasing, Inventory, WIP, Planning, Costing and Receiving modules.
Testing and Singing off the prototypes and OBIEE reports testing.
Developing OBIEE reports (presentation layer) based on the Noetix Global Views.
OBIEE Reports Migration.
Working with BPA team to get the requirements of reports and to Schedule OBIEE reports.
Environment: Oracle eBS 11i, R12, Oracle OBIEE, Oracle Developer 10g, Oracle Developer 11g, Noetix Workbench and Discoverer.
CLIENT: Qualcomm MEMS Technologies –R12 Implementation
DEC 2011- SEP 2012
PROGRAMMER ANALYST
QMT is implementing an Oracle EBS R12 ERP solution to initially support their QUALCOMM Display Corporation (QDC)’s business operations in Taiwan. The QMT ERP system will be the foundation for future QMT operations. The overall scope of the project is for the implementation of Oracle R12 modules to support business requirements for QMT/QDC Taiwan. This is a multi-phase project to support the immediate needs of the business. At the very end of the Implementation QDC is changed as QPM (Qualcomm Panel Manufacturing).
Responsibilities:
Worked on R12 WEBADI interfaces for uploading forecast data.
Worked on QMT GIB Outbound Interfaces.
Worked on Form Personalization, Workflows, Custom PLL’s and Reports.
Developed Oracle XML publisher reports.
Worked on AOL’s.
Developed PL/SQL Packages and Procedures.
Technical and Functional Documentation Based on AIM Methodology.
Worked on the R12 changes to reports and Alerts for QMT Projects.
Environment: Oracle eBS R12, Oracle 11g, Workflow 2.6.3.5, Oracle Application Framework, Application Development Framework and BI Publisher Reports.
CLIENT: Qualcomm (QCT Oracle ERP Support) Projects
MAR 2010- SEP 2012
PROGRAMMER ANALYST
This project provides Managed Support Services that includes technical support in QCT Oracle E-business Suite rel. 11.5.10.2. Troubleshooting all RICE components related to QCT Oracle ERP, providing technical assistance to the Qualcomm team on business issues across the Oracle applications and integrations, supporting interfaces between Oracle Applications, third party vendor products and other applications, developing new custom interfaces/forms/reports or enhancing existing and documenting the changes made to the application using AIM Methodology.
Responsibilities:
Worked on WEBADI interfaces like uploading ASL Programs.
Worked on Forms, Form Personalization’s and Custom PLL’s.
Developed Oracle XML publisher reports.
Modified OAF page.
Worked on AOL’s.
Developed complex PL/SQL Packages and Procedures.
Technical Documentation Based on AIM Methodology.
Environment: Oracle eBS 11i, Oracle 10g, Workflow 2.6.3.5, Oracle Application Framework and BI Publisher Reports.
Contact this candidate