SUMMARY

• Having 14+ years overall IT experience which involves Managing, development, upgrade, production support of Oracle ERP (EBS) R12 and 11i applications.
• Hands on experience in Oracle Applications Finance Modules as a Techno functional consultant.
• Very good experience in working complex and largescale business transformation implementation projects like COA redesign and merging two different E - Business applications under tight delivery time lines and across globe.
• Designed business flows of procure to pay(P2P) and other finance modules like AR, CM, FA and GL.
• Hands on experience in tuning SQL queries and PL/SQL packages
• Hands on experience in OAF personalization
• Hands on experience in implementing AME
• Good understanding of R 12.2 coding standards
• Hands on experience in integrating EDI with R12
• Involved in requirements gathering workshops, GAP analysis, setups (BR-100), and Functional design (MD050), Technical Design (MD070), CV40, CV60 documents using AIM methodology.
• Proficient in collecting requirements, designing and development for RICEWF components along with XML/BI publisher
• Worked on Advanced PL/SQL Concepts (PL/SQL Tables, Record type, Bulk Collects and Bulk Binds)
• Hands on experience in using SOAP and REST web services.
• Worked on Oracle EBS R12 and Oracle cloud (SaaS) integration.
• Experience in Release, configuration Management and version control tools like CVS and IBM clear case tools.

TECHNICAL SKILLS

Operating System: Windows NT/2000/XP, HP-UX, and Linux

Database: Oracle 9i, 10g, 11g.

Languages/Scripting: SQL, PL/SQL, Core Java and UNIX shell script

GUI: XML publisher, BI Publisher, Jdeveloper 11g and Workflow

Version Control: and other CVS and IBM clear case, SQL Loader, SQL Developer and TOAD

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Responsibilities:

• Involved in requirement gathering and Participated in fit gap analysis. Identifying the RICEWF components as part of fit gap analysis
• Preparing BR100 documents and performing setups for AP and PO module
• Responsible for high level design documents for enhancements and new requirements.
• Effort Estimation for RICEWF Components and prepare the delivery plan. Task allocation to the team members and tracking the progress on daily basis
• Helping the team members on technical, functional issues and review the code and unit testing results
• Experience in participating multiple CRP (s), SIT, UAT and Go-live phases of the projects.
• Detailed Cutover planning and communicating with all stake holders and align the cutover activities for smooth go live.
• Supporting first period closure after Go-live.
• Designed customer outbound interface using standard and custom Business event subscription.
• Designed and developed Purchase order interface from various third-party applications for standard purchase order and Blanket purchase agreement.
• Designed and developed purchase order receipt interface from various third-party applications.
• Designed Receivables invoices using standard interface tables and receipt interface using APIs from multiple legacy applications.
• Designed GL journal interface from various third-party applications.
• Supplier creation page personalization to make the DFF field as read only.
• Designed and developed PO and Item outbound interfaces from R12 to Oracle SaaS.

Environment: Oracle EBS Applications R12 (AP, PO, AR, CM, FA, EB-Tax and GL)

Software: Oracle11g, SQL, PL/SQL, Forms10g, Reports10g, BI Publisher, Jdeveloper11g, SQL Developer, ODI and SOA 11g, EDI

Confidential

Technology Lead

Responsibilities:

• Involved in requirement gathering as part of CRPs and participated in fit gap analysis. Identify the RICEWF components as part of fit gap analysis.
• Designing the overall approach for RICEWF components and delivery planning for Technical Components
• Designed the conversion strategy to migrate the data from 11i to R12 and Involved in resource planning.
• Helping the team members on technical, functional issues and managing a team of 15 members at peak.
• Task allocation to the team and tracking the progress on daily basis and reporting the daily progress to project management team
• Preparing BR100 documents and configuration of AP and PO modules.
• Helping the team members on technical and functional issues and review the code and unit testing
• Assisting the business leads in testing the custom components as part of UAT and taking care of version control and release management activities
• Worked on the customization of AP Invoice and Expense approvals using AME personalization on Standard Customer Screen to restrict reactivation of customer account if Classification is set to Merged using OAF personalization
• Expose Language field at the customer Site Address Level and send the dunning letter in the language that is set for the customer site using OAF personalization iSupplier user registration process
• AGIS Create Batch: Header and Transaction OAF screen modified using controller and view object extension using Jdeveloper
• Worked on enabling the attachment option and defaulting tax group using OAF personalization in iExpense form
• Worked on fixed and delimited payable payment formats for various banks like BofA, Chase across countries
• Designed and developed AP invoice interface from third party system like ARIBA

Environment: Oracle EBS Applications R12 (AP, PO, AR,FA, SLA, iExpenses and GL)

Software: Oracle10g, SQL, PL/SQL, Forms10g, Reports10g, BI Publisher, Jdeveloper 10g and SQL Developer

Confidential

Technology Lead

Responsibilities:

• Involved in requirement gathering and Participated in fit gap analysis. Identifying the RICEWF components as part of fit gap analysis.
• Designed the conversion strategy to migrate the data from 11i to R12 and involved in resource planning.
• Managing a team of 12 members at peak. Task allocation to the team and tracking the progress on daily basis and reporting the daily progress to project management team.
• Helping the team members on technical and functional issues. Review the code and unit testing
• Assisting the business leads in testing the custom components as part of UAT. Taking care of version control and release management activities
• Designed and developed AP invoices conversion from 11i to R12
• Designed and developed AP suppliers, supplier sites and supplier contacts conversion using standard interface programs
• Designed and developed supplier external banks conversion using the APIs
• Designed standard purchase orders conversion from 11i to R12
• Designed and developed the AR receipts conversion and AR Adjustments
• Designed projects, tasks conversion using APIs
• Worked on AR Customer statement report using XML publisher and mailing the customer statements using XML bursting

Environment: Oracle EBS Applications R12 (AP, PO, GL, FA, PA and AR)