SUMMARY:

• 8+years of IT experience as an Oracle Apps Techno - Functional Consultant; ability to build and maintain strong working relationships with cross-functional business groups, as well as technical specialists.
• Have been working extensively in Oracle Applications (R12/11i/11.0.3) and well versed with Design and development of PL/SQL Objects, AOL & Oracle forms & reportsTechnical Expertise:
• Expertise in Developing/Customizing PL/SQL packages, Enhancing Oracle Forms, Reports, Oracle Workflow, Oracle Alerts, 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, STAT Tool.
• 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), 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 & Procure to pay cycle.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Technical Lead

Responsibilities:

• Requirement Analysis, Business Process Mapping, Fit-Gap Analysis
• 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

SCM Technical Lead onsite

Responsibilities:

• Developed custom packages, XML Reports and Oracle alerts.
• Migration of all components using STAT tool.
• Performed UAT and involved in SIT testing.
• Closely involved with EA 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

Finance Lead

Responsibilities:

• Provided maintenance and support for Order Management(O2C), Purchasing (P2P), iExpense, AP & AR in Oracle R12, Fusion in production environment.
• 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.
• Resolved issues in iExpense 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

SCM Techno-Functional Consultant

Responsibilities:

• 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

SCM Techno-Functional (Order Management, AR)

Responsibilities:

• 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 EMC. 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 on components.

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

Confidential

SCM Techno-Functional

Responsibilities:

• Worked on pilot project for implementation of R12.
• Worked on production support issues for Oracle Applications 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 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 EMC² 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 11.0.3, Oracle forms & Reports. TOAD, SQL Developer, D2K forms & Reports, SQL*Loader, Putty, Quality Center & Harvest Workbench.