SUMMARY:

• 9+ years of IT experience as an Oracle Apps Technical Consultant ; ability to build and maintain strong working relationships with cross - functional business groups, as well as technical specialists.
• Expertise in Implementation, Customization & Technical Support of Oracle Applications Modules: OM (Order Management), PO (Purchase Order), INV (Inventory), BOM (Bills of Material), WIP (Work In Process), AR (Account Receivables), AP (Accounts Payables), Oracle Projects Accounting & GL (General Ledger).
• Working knowledge on AR Autolock box.
• Great understanding of TCA (Trading community architecture in R12).
• Excellent analytical skills in analysis and business requirements gathering from end users to the client and experience in designing and using AIM methodology documents like MD050, MD070 etc.
• Having very good functional knowledge in both Order to Cash (O2C) cycle & Procure to pay (P2P) .
• Possesses expert knowledge of the Oracle Open Interface tables and APIs .
• Expertise in Developing/Customizing, Enhancing Oracle Forms, Reports, Oracle Workflow, Oracle Alerts, XML Publisher reports and registering Concurrent programs using Application Developer and System Administrator Responsibility.
• Strong in PL/SQL coding, Stored procedures, Functions, database triggers, Unix Shell scripting, SQL Loader files
• Strong problem solving and troubleshooting skills, highly motivated with ability to work as an individual and also as a dynamic team member.
• Understanding of Project life cycles and methodologies . Well proven track in achieving the timeline for deliverables.
• Good experience in handling customers from different geographies .
• Excellent written and oral communications skills .
• Flexible to take up assignments as per the requirements .

TECHNICAL EXPERTISE:

• Expertise in Developing/Customizing PL/SQL packages, Enhancing Oracle Forms, Reports, Oracle Workflow, Oracle Alerts, and XML Publisher reports, Oracle Interfaces & Conversions, Oracle Application Object Library (AOL).
• Strong in PL/SQL coding, stored procedures, Functions, database triggers, UNIX Shell scripting.
• Possesses expert knowledge of the Oracle Open Interface tables and APIs.
• Tools and Utilities: PL/SQL Developer, TOAD, SQL Developer, SQL*Loader, Putty, PVCS, Kintana, Quality Centre.
• Identifying functional and technical gaps, estimating work, architecting system interactions, designing custom solutions, scheduling, producing documentation, user manual to users and providing production support.
• Expertise in Implementation, Customization & Technical Support of Oracle Applications Modules: OM (Order Management), PO (Purchase Order), advanced pricing, INV (Inventory), BOM (Bills of Material), WIP (Work in Process), AR (Account Receivables), and AP (Accounts Payables).
• Excellent analytical skills in analysis and business requirements gathering from end users to the client and experience in designing and using AIM methodology documents like MD050, MD070 etc.
• Having very good functional knowledge in both Order to Cash (O2C) & Procure to pay (P2P) cycle.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Technical Lead for R12 Upgrade (12.1.3)

• Provided scope and technical feasibility to functional requirements in requirement and design phase.
• Retrofit change analysis as per R12 and 11i components table level changes.
• Providing estimates on new changes from existing process.
• Managing a technical team of 10 members from offshore.
• Collecting requirements and providing technical design documents to the development team.
• Reviewing and testing the individual objects delivered by the team.
• Conducting daily status calls with team working offshore.
• Monitoring and guiding the team on build activities on daily basis.
• Involved in reporting status and potential risks to the PMO for all technical activities.
• Involved in user sessions and end user trainings.
• Involved in the instance management plan to support the timely delivery of ERP instances

Confidential

Oracle Technical Lead

• Worked on Order import custom process.
• Implemented new custom forecast consumption process flow, which includes integration of multiple boundary systems. Extensive use of advance PL/SQL concepts.
• Requirements elicitation, Estimation, Business Impact analysis
• High Level Design review, Low Level Design Review, Schedule and task tracking
• Project/Release planning, Use Case Review, Problem analysis, Problem simulation
• Application Implementation, Release Management
• Integration Testing, System Testing, Test planning involving Oracle Applications and other bolt on applications.
• Involve in feature enhancements and bug fixes
• Documentation, Documentation Reviews, Troubleshooting, Co-ordination, Status reporting, Knowledge Management.
• Working extensively on Advance PL/SQL to build custom package procedures.

Environment/Tools: Oracle ERP 11i, Oracle 10g Database, TOAD, SQL Developer, PL/SQL, Putty, Kintana

Confidential

Oracle SCM Technical Consultant

• Developed custom packages, XML Reports and Oracle alerts.
• Migration of all components using STAT tool.
• Performed UAT and involved in SIT testing.
• Developed Expressions, filter, joins, Split, Variables, user functions Using ODI
• Performed sending mails to team whenever any ODI jobs are failed by using ODI tools. 
• Closely involved with Confidential business and Mexico team to test all the business scenarios.
• Prepared technical documents (MD 70) for all the components developed.
• Played major role in production cutover task which includes migration of development objects, AOL migrations, new responsibility creations and Oracle setups for Oracle Trade management.
• Drive daily status call with business along with IT to review open issues in UAT.

Environment/Tools: Oracle ERP R12, Oracle 11g Database, TOAD, PL/SQL, UNIX Shell Scripts, STAT tool, Putty

Confidential

Oracle Technical Consultant

• Provided maintenance and support for Order Management (O2C), Purchasing (P2P), iExpense, AP & AR in Oracle R12, Fusion in production environment.
• Worked on custom AR Revenue recognition process.
• Involved in quarter end closure successfully.
• Actively involved in resolving daily issues logged by customers, User acceptance testing for bug fixes and provide both Functional and Technical support.
• Worked on CITIBANK check payments in EDIFACT format.
• Resolved issues in I Expense with regard to Amex card creation and Credit card transactions.
• Setup Approval rules for Claim Types in OTM (Oracle Trade Management).
• Worked closely with Oracle Support to raise, monitor and follow up till the SR’s resolved, for standard oracle issues.
• Drive weekly status call with business to review open issues and provide ETA for pending issues.
• Coordinating with offshore team to ensure all incidents are taken care 24/5.
• Provided development services such as corrective maintenance and minor functional enhancements of all the above-mentioned applications.
• Involved in transformation initiatives to improve the operational efficiency such as created xml reports to automate the existing manual scripts executed in production.

Environment/Tools: Oracle ERP R12, Oracle 11g Database, TOAD, PL/SQL, UNIX Shell Scripts, STAT tool, Putty

Confidential

Oracle SCM Technical Consultant

• Worked on Order Imports and Quote to order custom process. This includes integration with oracle configurator and Advance pricing.
• Responsible for gathering the customer requirements, Providing feasible and oracle standard functional solutions, Bridging the Customer, Onsite and development teams on day to day progress,
• Design the functional requirement specification documents and testing documents, Development of components and performing unit, system and integration testing.
• Designed custom package to work with Oracle Standard Batch validation program to create configurations for the models.
• Involved in solution design for pricing. Created custom pricing context for pricing, pricing attributes based on model attributes. Attribute Mapping, Dynamic formula, modified standard custom hook package. Setup custom hook profile option at responsibility level.
• Worked on Standard Oracle Ignore Price hook to handle the pricing logic for current customer model pricing design.
• Developed custom programs Pre-Auto invoice and Post-Auto invoice which runs before and after Auto Invoice Master Program. Pre-Auto invoice is developed to modify the RA INTERFACE LINES ALL data to allow the eligible line for invoicing and creation of distribution records for the same.
• Worked extensively on Custom Make to Buy configurable models process, it allows user to update any additional cost for the configurable item and allows rolling up the cost to its base configurable item.
• Developed custom URD form which is used to maintain the unit related information of models.
• Automation of B2B process to handle forecasted or safety stock items and Non-forecasted items. The entire process involves order line workflow change to apply the hold by checking the on-hand availability of goods ordered and fulfills the same with a custom form and create the purchasing demand for the same.
• Worked in COGS reclassification for sub models. This program consolidates all the COGS information for the sub models being invoiced and populates the same into GL INTERFACE table.
• Involved in development of custom forms and Oracle Reports.
• Strong expertise in SQL/PLSQL.

Environment/Tools: Oracle ERP R12, Oracle 11g Database, Oracle forms & Reports 10g, TOAD, SQL Developer, D2K forms & Reports, SQL*Loader, Putty, Kintana & PVCS

Confidential

Oracle Technical Consultant

• Participated in requirements gathering for the components that are developed and delivered mainly in purchasing, Accounts payables and General Ledger.
• Developed three interfaces and two conversions.
• Developed 11i and R12 exchange rate interface. The exchange rates are sent by the third party system (Bloomberg), which needs to be modified as per the conversion types defined in both 11i and R12 and get it inserted into GL DAILY RATES INTERFACE table with all the standard validations.
• Worked on GL journal entry interface between 11i and SAP.
• Designed and developed custom package to handle Battery recharge and discharge process in Confidential . This component calculates the days since it last recharged and sends the notifications to the business used.
• Worked on Oracle Report and Oracle forms as a part of enhancement.
• Defined the Technical specifications reports and transformed the specifications to the Technical Team.
• Defined the functional specs for modification of coding in customizations of interfaces, reports.
• Involved in Unit testing and preparing test cases for QA. Also involved in UAT (User Acceptance Test).
• Involved in bug fixing reported from QA and End users.
• Direct interaction with Client from offshore to get actual business requirements.
• Active participation in all clients meetings in testing and user training on components.

Environment/Tools: Oracle ERP 11i, Oracle forms & Reports, TOAD, SQL Developer, D2K forms & Reports, SQL*Loader, Putty, Quality Center & Harvest Workbench

Confidential

Oracle Technical Consultant

• Worked on pilot project for implementation of R12.
• Worked on production support issues for Oracle Applications 11.0.3 and 11i.
• Majorly worked on the P2P and O2C cycles and supported the process.
• Handled Order Entry, Shipping, Purchasing, Inventory, Receivables and BOM.
• Performed root causes analysis for the regularly occurring issues and handled bug fixes.
• Worked on processing B2B drop ship orders.
• Worked on new enhancements for reduction of issues.
• Reduced the issue count by investigating the issues and providing permanent fixes for the issues.
• Lead the Manufacturing track at offshore. Responsibilities include managing the team and working on day to day issues, and giving appropriate solutions for the issues to recognize revenues on time.
• Managed SLA’s and never crossed below 97%.
• Managed the issue tracker metrics and reported the same to the senior management on a weekly basis.
• Successfully supported Confidential ² to operate 18+ EOQ’s smoothly.
• Performed the team lead role and managed 7 resources in manufacturing track.
• Performed KT’s for new resources on the process.
• Worked in critical situations to keep the system active and working.

Environment/Tools: Oracle ERP 11i, Oracle forms & Reports, TOAD, SQL Developer, D2K forms & Reports, SQL*Loader, Putty, Quality Center & Harvest Workbench