SUMMARY

• Having Around 10 Years of experience in Development, Customization, Support and Enhancement of Oracle Application R12&11i as a Technical Lead Consultant.
• Extensively worked on Oracle Applications Finance (AR, AP, GL, iexpense), SCM (PO, INV, OM) and CRM (Install Base and Service Contract) modules.
• Strong Technical skills in Discoverer, XML publisher, Oracle Alerts, SQL, PL/SQL Oracle Reports, Bar code Printing and Excel Printing Using XML Publisher, Workflow, OAF,XML Bursting, SQL*Loader and Pentaho tool.
• Worked on Interfaces to load the legacy information system to release R12 & 11i which Includes PO, OM, CRM modules using PL/SQL, SQL*Loader and Pentaho tool.
• Involved in Functional setups and provided Support for SCM and Finance Modules.
• Experience with merger & acquisitions project in streamlining processes and systems transition
• Worked on Out Bound Interfaces to transfer the data from Oracle application base tables into the Flat file.
• Interacted with all levels of business owners and users during the various stages of project lifecycle.
• Extensive experience on performance tuning.
• Worked on Alerts, Period close issue and Production Support
• Good Knowledge on workflow.
• Well versed with the AIM documentations of Functional (MD050), Technical (MD070), Installation documents (MD0120), Test cases (TE020), Conversion Functional (CV040) and Conversion Technical Design (CV060) and User Manual Documents.
• Excellent in verbal and written communications, analytical skills, time management and task management.
• A good team player with Strong interpersonal and negotiation skills and ability to articulate with people at all levels and Acquiring and implementing new Technologies easily.
• Delivering quality deliverables in timely manner.
• Ability to interact with individuals at all levels and Accustomed to working under tight schedules.
• Incorporated best practices in Development work environment in all the phases of project lifecycle to in corporate Company’s norms and coding standards.
• Self - motivated with the ability to effectively manage time and succeed in it.

TECHNICAL SKILLS

ERP: Oracle Applications 11i & R12 (INV, OM, AR, IB, SC, PO, AP, GL,FA)

Tools: Discoverer, XML Publisher, Pentaho,Workflow, Sql*Loader, Sql Developer

Languages: C, SQL, PL/ SQL.

GUI: Reports 6i/10g

PROFESSIONAL EXPERIENCE

Confidential, CA

Techno-Functional Lead

Environment: Oracle Applications R-12.2.2(P2P, O2C, Finance, HR, Install Base and Service Contracts), SQL, PLSQL And Reports10g OAF, Web Logic and XML Publisher

Responsibilities:

• Conducted Customer Meetings to understand the Process and documented the various process flows
• Interacted with the Business Analysts to understand the integrations with the other systems
• Preparation of the Test Cases based on AS IS Process
• Functional Testing
• Trained the Users of various roles on all modules.
• Developing RICE Objects
• Involved in Development of both Inbound/Outbound Interfaces.
• Provided Ongoing Support for Oracle E-business Suite.
• Performed the Functional Testing
• Registered reports, interfaces, and conversions with AOL
• Involved in the CRP1/CRP2/UAT Functional testing
• Worked on performance tuning.
• Reviewed the high-level technical architecture of the supply chain solution and financials.
• Providing SOX compliance evidence to Internal/External auditor to review Monthly and Quarterly.
• Involved in design, development and testing and preparing migration document and testing
• Interacting with offshore and onsite Team Members daily
• Customer registration process
• AR Invoice Conversion
• Developed Rev-Rec Integration.
• AP Expense Invoice load.
• Automated Oracle User creation and responsibility assignment process
• Developed AR Invoice Print Report
• Developed AR Revenue Report With Serial Number
• Developed Gross Billing Report
• Developed and automated the Sales order Acknowledgement and back order details process
• Developed Application interface Error report for AR,INV,OM,WIP and AOL modules
• Developed Inventory $0 Amount Distributions Report
• Developed Monthly Accrual Purchasing Requisition Report
• Developed Oracle EBS Modules Period Status Report
• Developed Supplier Conversion.
• Developed AP Expense Details Report

Confidential

Techno-Functional Lead

Environment: Oracle Applications R-12(P2P, O2C, Finance,HR, Install Base and Service Contracts), SQL, PLSQL and Reports10g, Discoverer and XML Publisher

Responsibilities:

• Co-Ordinate with business user to get the requirements
• Provided Ongoing Support for Oracle E-business Suite.
• Developing RICE Objects
• Worked on mergers project and Responsible for integration of various functions including order-to-cash, pricing, inventory management, Install Base and Service Contracts technical processes data.
• Automated the business daily and weekly process.
• Preparing documents as per AIM methodology
• Worked on Subscription billing process
• Review the team codes and approve
• Involved in Solution Mappings for Global Business Requirements
• Involved in Development of both Inbound/Outbound Interfaces
• Providing SOX compliance evidence to Internal/External auditor to review Monthly and Quarterly.
• Helped in period closing activities
• Monthly Vertex Sales tax load
• ARENA Item Import automation
• Positive Pay process
• Expense Invoice creation
• End customer registration
• Serial Number installed at location
• Oracle to SFDC outbound automation
• Price List loaded
• Oracle to EDB outbound conversion.

Confidential

Consultant

Environment: Oracle Applications 12i, SQL, PLSQL and Reports10g.

Responsibilities:

• Preparation of Technical Design Document and Checklist Documents
• Did Sanity Check and Unit Testing before Users get actually involved
• All custom reports, discoverer reports are verified to work without any issues.
• Created SR’s and worked with oracle support team for oracle issue’s until resolved

Confidential

Consultant

Environment: Oracle Applications 12i, SQL, PLSQL and Reports10g.

Responsibilities:

• Development of new Reports and customization of existing reports
• Involved in Development of Conversions and Interfaces.
• Involved in design, development and testing and preparing migration document and testing
• Involved in workflow customizations
• Registered reports, interfaces, and conversions with AOL
• Involved in test case preparations
• Developed Customer Conversion.
• Developed Install Base Creation Interface.
• Developed Services Contract and Oracle IB Extract Program.
• Developed Install at location change program.
• Customized Sales Order Acknowledgement report
• Developed Apply Holds and Release Holds Program
• Developed Open Po report in Excel with Using XML Publisher.
• Developed Extron Extract Custom Program.
• Developed SOX Reports.
• Developed accurance Image Report.
• Customized Concur AP Invoice report.
• Customized Sales Order Exception Report
• Customized Item Attributes report.

Confidential

Associate Consultant

Environment: Oracle Applications (11.5.10).SQL, PLSQL and Reports6i.

Responsibilities:

• Provide support for the issues that arise in the .net applications.
• Coding, Testing and Deployment of Change Requests.
• Coordinate and Support the team.

Confidential

Associate Consultant

Environment: Oracle Applications (11.5.10).SQL, PLSQL, Reports6i

Responsibilities:

• Defining Concurrent Programs, Executables for PLSQL Procedures.
• Automated the process from Batch Creation to Batch close by using Oracle Standard API’s.(Includes Batch Creation, Release, Allocation, Step certify, Batch certify And Batch Close)
• Developed a program to Increase the qty for lot and non lot control Items
• Developed a program to create a lot and status change.
• Developed a program to Assign Costs to the items.
• Developed MS-ACCESS Reports as per the business requirement.

Confidential

Associate Consultant

Environment: Oracle Applications Release 12.

Responsibilities:

• Developed Job Conversion.
• Developed Employee Previous Experience Conversion.
• Developed Internal Bank Conversion.
• Worked on On hand Stock Inbound interface.
• Worked on Open Purchase Order Inbound interface.
• Worked on Salary Proposal Conversion.
• Involved in Preparing Document Specifications, Technical Specifications.

Confidential

Associate Consultant

Environment: Oracle Apps 12i (HR, Payroll), Oracle 10g.

Responsibilities:

• Developed Medical Expenses Report.
• Developed Employee Leave Balance Report.
• Developed List of Job Wise Competencies Report.
• Developed Rotation Leave Balance Report.

Confidential

System Executive

Environment: Oracle Applications 11.5.10.2(PO, OM, INV)

Responsibilities:

• Developed RMA Open Quantity Report.
• Developed RFQ Printing Report.
• Customized Open Purchase Order report.
• Developed Shipping Detail report in Bar Code Printing Using XML Publisher.
• Developed Requisitions Report in Xml Publisher.
• Developed PO Details Report.
• Customized Sales Order Acknowledgement report.
• Worked on AOL components as creation of Value Programs, etc...