SUMMARY

• Certified Oracle Applications Technical/Techno - functional consultant with seven plus years in the IT industry with experience in handling assignments in R12 Upgrade, Enhancement, Support and Implementation projects in both R12 and 11i.
• Have expertise and proven track record in all the phases of SDLC with sound technical and functional knowledge clubbed with excellent communication skills.
• Have worked in various roles of Senior Technical Consultant, Systems Analyst, Production Support Engineer and Project Technical Lead in Oracle Applications E-Business Suite Financials/SCM/MFG/HRMS.
• Worked with International clients (Qualcomm, Confidential and Confidential ) and proven ability to bridge technology and business goals to provide productive solutions & ensure SLA compliance levels and year on year improvements in service for support engagements.
• Strong background in Oracle EBS Application support engagement, implementing new business logic and Oracle EBS RICE (Reports, Interfaces, Customization, and Enhancements) components. Extensive experience in designing and developing of RICE components for various Oracle Applications Modules, AOL components.
• Have considerable experience in Oracle EBS R12 Upgrade project.
• My technology forte is Oracle Applications Financials (AR, AP, GL and FA), SQL, PL/SQL, Oracle Reports/Forms, Discoverer, XML Publisher, Forms Personalization, UNIX, OAF, AOL, RICE, O2C and P2P cycles. I have also worked and have considerable knowledge in OM, Manufacturing, BOM, WIP, PA and HRMS modules.
• Have knowledge on FSG, EAM, COA concepts.
• Good team player and problem solving skills.
• Good Communication, negotiation, leadership & analytical skills with clear understanding of business logic
• I am an Oracle OCA and R12 Essentials, Payables and Receivables certified.

TECHNICAL SKILLS

Technologies: SQL, PLSQL, Unix, OAF, Oracle Database 10g/11gOracle Applications E-Business-Suite 11i & R12.

Tools: Oracle Reports/Forms, XML Publisher, TOAD, Discoverer, Quality CenterOracle Alerts, Logical Apps, Forms Personalization, Oracle JDeveloper, Project and Portfolio management (PPM), WINCVS, PVCS, Remedy, Putty, WINSCP, Kintana

Methodologies: AIM

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Senior Oracle Apps Developer

Environment: Oracle EBS AR, AP, GL, FA, PA, HRMS, O2C, P2P, EBS R12, Oracle 11g, Oracle Reports 10g, Oracle Forms 10g, Discoverer, XML Publisher, Toad, PVCS Version Control tool, Project and portfolio management (PPM) tool, Kintana, Putty, Oracle Alerts, Logical Apps, Forms Personalization

Responsibilities:

• Worked on Interfaces, RDF/XML Publisher reports, Forms, performance tuning of reports, enhancements, AOL components, Oracle alerts for the Corp Oracle R12 business.
• Has worked in international rollouts like Israel on interfaces like GL Daily rates Program which populates exchange rates.
• Worked on production issues which need understanding the business logic, root cause analysis of the issue, debugging and business friendly solutions.
• Technical research, impact analysis of AME approvals for HR hierarchy changes.
• Worked on the Order to Cash (O2C) and Procure to Pay (P2P) cycles.
• Worked on a mini projects like Sales Force mini project to disable all the old unused email distribution lists across all modules, HR Organization automation and Oracle Leases in FA.
• Working closely with the functional consultants to understand the requirements and design feasible solutions accordingly.
• Have worked on tools like Project portfolio management (PPM) and PVCS (Version control tool).
• Working on the AIM documents like MD050, MD070, TE020.
• Regular interaction via team meetings with the onshore and the offshore teams to collective discuss updates and issue resolutions.

Confidential, San Diego, CA

Oracle Apps Techno-functional consultant, System Analyst

Environment: EBS Inventory, BOM, WIP, AR, AP, GL, EBS 11i, Oracle 10g, HP Quality Center (ALM),Toad, Wincvs, Winscp, SQL, PLSQL

Responsibilities:

• In depth analysis of the complex business requirements and functional specifications and design Test scripts.
• Work closely with the Functional team, Business Process Analysts, developers and users to design ‘attitude to break’ test scripts which covers all aspects of testing.
• Design test steps for all positive and negative scenarios for any given business requirement.
• Worked extensively in Quality Center to design test scripts in Test plan and execute test scripts in Test labs.
• Raising defects in Quality Center and categorizing them majorly into Business requirement change or Developer issue.
• Worked in testing new business logic implemented in Oracle manufacturing, BOM and WIP accounting.
• Created Test Scripts, Test Summary Documents, Test Strategy, Traceability Matrix and conducted meetings to review them.
• Build a comprehensive list of test cases across standard Oracle modules, 3rd party applications and RICE (Reports, Interfaces, Customization, and Enhancements) components in Quality Center.
• Identify and track defects and interact with development staff to isolate and resolve, retests to confirm defects have been corrected.
• Verified that the components of the solution, both standard functionality and custom components (including Reports, Interfaces, Customizations and Enhancements), operate together in a single environment, successfully and as expected
• Working on the Quality Center to track the defects or update evidences for defects worked on and test cases executed respectively.
• Provide Test Status Reports for the various phases of the project
• Regular interaction with the business process analysts and testers for testing strategy, identify test cases for each phase, interface testing, communication plan and inputs on defects and processes.
• Actively involved in the Core financial interfaces and processes.

Confidential, Denver, CO

Technical Team Lead, Techno-Functional Consultant

Environment: EBS AR, AP, GL, SCM, EBS R12, Oracle 11g, SQL, PLSQL, Toad, Oracle Reports 10g,Oracle Forms 10g, XML publisher, Oracle Alerts, Forms Personalization, Oracle Application Framework (OAF), JDeveloper, Winscp, Wincvs, HP Quality Center (ALM),WINCVS

Responsibilities:

• In depth analysis of the business requirements which includes understanding of the complete business process, upstream/ downstream systems, interfaces and third party applications etc. to retrofit into the R12 system.
• Complete impact analysis of the functional processes and the technical components.
• Retrofitting the technical components to be compatible with R12 using a R12 Impact Analysis tool - ‘Assay’
• Retrofitting all the interfaces, reports, forms, plsql packages/functions/APIs, workflows, upstream/downstream systems and custom business process to be compatible with R12.
• Working on the functional changes to be implemented for the processes which are obsolete in R12.
• Studied, analyzed business needs, and tested GL, AP and AR modules.
• Working on the teams from the upstream/downstream processes on Java and Tibco interfaces.
• Worked closely with End Users, attended meetings, organized meetings and gathered any additional business requirements/changes or enhancements.
• Have regular meetings with Business, users and management stake holders on the progress of the project, issues and resolutions.
• Being a part of the CRP - demonstrating the new R12 system to the customer.
• Being a part of the Month End period closing team.
• Resolving the production support issues post Go-live using the remedy tool.
• Worked on the OAF development using JDeveloper for custom JSP pages replacing Oracle AK developer forms in R12.
• Actively involved in creating test scripts, Traceability matrix, testing strategies for each phase of the project.
• Responsible for the manual testing process of Oracle EBS Application for Oracle Financial modules.
• Update the test cases across standard Oracle modules, 3rd party applications and RICE components in Quality Center to be compatible with R12.
• Perform End- to- end SIT (System Integration Testing): Verify that the components of the solution, both standard functionality and custom components (including Reports, Interfaces, Customizations and Enhancements), operate together in a single environment, successfully and as expected
• Performing Regression/Sanity testing post major releases or instance clones.
• Working on the Quality Center to track the defects or update evidences for defects worked on and test cases executed respectively.
• Actively involved in the testing of Core financial interfaces and processes.
• Preparing documents and the users/developers community for new processes and code changes walkthroughs.

Confidential, San Jose CA

Sr. Oracle Apps Developer

Responsibilities:

• Supporting the Order Management process of the Production Environment ensuring smooth booking of orders and shipping.
• Resolving the customer escalation/user issues relating to OM with customers all across the globe.
• Managing the Confidential custom business logic components like the IC Engine, Trade Collaborator and Supply Order Manager which are used for Order Booking, Picking and shipping respectively.
• Working on the everyday customer issues/escalations and resolving them based on priority.
• Coordinating with other teams to help resolve cross functional issues.
• Performing production data fix for issues.
• Overall monitoring of the components to ensure smooth functioning of the system.
• Handling the heavy inflow of orders during the month end and the Quarter End process.
• Providing various Ad hoc reports as and when needed by the users.
• Monitoring and resolving issues with the CDB Queues and JMS.
• Also, handling some of the Advance pricing issues of the OM.

Confidential

Oracle Apps Developer

Responsibilities:

• Creation and enhancement of RDF, Discoverer and XML Publisher reports as per the user requirements.
• Developed new finance reports using Report 6i, Discoverer and XML publisher.
• Worked on the performance tuning of critical reports involving huge data.
• Worked on the Confidential custom NGB interface which involved interfacing transactions from ARBOR - third party application.
• Worked on the Auto Invoice and Auto Lock box interfaces in AR.
• Worked on Inbound and Outbound Interfaces in AR and AP.
• Creation of new discoverer reports by working on the noetix views.
• Worked on GL interface changes and enhancements.
• Providing various Ad hoc reports as and when needed by the users.
• Resolving the data issues of various reports.
• Created custom Forms for a new project from the scratch.
• Worked on the Order to Cash (O2C) and Procure to Pay (P2P) cycles.
• Have worked on complex procedures and UNIX scripts in certain issues encountered to copy data to server locations.
• Worked on XML Publisher Reports involving huge data.
• Preparation of MD 070, MD 050, TE 020 documents.
• Development of complex discoverer reports based on the client’s requirements.
• Developed various components using PL/SQL Procedures, Functions and Packages.
• Also worked on Oracle Alerts, Logical Apps and Forms Personalization.
• Development of Custom concurrent Programs, Value sets and registering them in Oracle Apps.
• Regular interaction with the onsite team and weekly calls with the customer for better understanding of the requirements and resolution approaches.
• Preparing weekly ITG Status Update Report.
• Participating in weekly and monthly status review with the clients.