SUMMARY

• Over 7 years of experience as an Oracle Applications Techno Functional Consultant in all aspects of Software Development Lifecycle (SDLC) including documentation of technical and functional documents using Applications Implementation Methodology (AIM).
• Experience in Oracle Applications modules like:
• Supply Chain Management: Oracle Purchasing (PO), i - procurement, ASCP, Order Management (OM), Oracle Inventory (INV), Supplier Management, i-suppliers
• Oracle Financials: Receivables (AR), Payables (AP), Fixed Assets (FA), General Ledger (GL), i-Expenses
• Experience in Development and Support of both Development and Production Systems.
• Proficient in using Oracle Applications with Implementations, Upgrades, Post-Production support.
• Expertise in the functional flow of Order to Cash (O2C) & Procure to Pay (P2P).
• Very Good understanding of Multi-org architecture.
• Experience in designing, developing, implementing and customizing RICE (Reports, Interfaces, Conversions and Extensions) components.
• Strong SQL and PL/SQL programming and performance tuning skills.
• Strong knowledge in Development & Customization of Forms 6i/4.5, Personalization of forms with sound understanding of Application Object Library (AOL).
• Experience in designing new reports and modifying existing Reports using Oracle Reports 6i, BI Publisher and Discoverer 4i/6i/9i.
• Profound knowledge in integrating Oracle EBS with ClearOrbit’s Supplier Collaboration systems
• Expertise in Oracle tools like Web ADI, SQL*Loader and UTL file utilities.
• Well versed with Unix Shell Scripting.
• Involved in Application Integration Methodology (AIM) development of CV60, CV70, CV80, MD050, MD070, MD100, MD0120, MD130, MD200 and TE020.
• Strong experience in writing Stored Procedures, Functions, Packages, Cursors and Triggers.
• Experience includes System Administration activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, working with Profile Options and registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical or functional issues.
• Able to manage changing responsibilities and deliver time critical projects on schedule. Proven ability to accept challenges and produce results in a multi-tasked environment. Motivated to learn new technologies and can work in a team or independently. Ability to communicate and work with people at different levels of Organization.
• Highly motivated, enthusiastic professional with a high degree of commitment to succeed.
• Recognized by management at different occasions for dedication and devotion at work in various projects.
• Experienced in onsite-offshore working model.
• Good Team player and superior verbal and written communication skills.

TECHNICAL SKILLS

ERP: Oracle Applications EBS R12/11i/10.7.

Oracle Financialsmodules: Receivables (AR), Payables (AP), General Ledger (GL), Fixed Assets (FA), i-Expenses

Oracle SCM modules: Oracle Purchasing (PO), i-procurement, Order Management (OM), Oracle Inventory (INV), i-Suppliers

Languages: SQL, PL/SQL, UNIX Shell Scripting and C.

Databases: Oracle10g/9i/8i, SQL-Server 2005.

Tools: SQL*PLUS, Oracle Discoverer 4i/6i/9i, Forms 4.5/5.0/6i, Reports 4.5/6i/9i, Oracle BI publisher, ClearOrbit, Workflow builder, AOL, Web ADI, Eclipse BIRT.

Oracle Utilities: Oracle SQL *Loader, TOAD, SQL Developer, Putty.

Framework: OAF Personalization

Environment: Windows-98/2000/XP/NT/7, UNIX, Linux.

Project Management tools: MS Word, PowerPoint and MS Excel.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in dealing with all the stakeholders on the project to gather requirements, firm up the requirements and then get the sign off by the stakeholders for each functional track.
• Involved in designing the Project Plan for the individual modules.
• Worked on PO, Employees, Customers, Suppliers, Open AR invoices, Open AP Invoice conversions.
• Worked on Check printing for Bank of America.
• Also, worked on PO printing and AR Invoice printing.
• Customized the AR Auto invoice program as per the client requirements.
• Purchasing - Worked on the configuration of the Purchasing module including the setups of the Approval hierarchies, Purchasing Options, Setting up Matching, etc.
• Performing AOL Tasks like creating responsibilities, users, request groups, attaching responsibilities to users etc.
• Interfaced Active Assets from FMSA Corporate book to FTBA Corporate book via WEB ADI.
• Conducted several sessions with key users to analyze business requirements and performed fit-gap analysis to map user requirements using AIM methodology.
• Responsible for developing and maintaining BR100, MD050, User training documents, test scripts and results.
• Worked with Oracle support for Oracle functionality issues by raising Service Requests.
• Designed and Developed the Test Plan for testing the System as well as testing of the entire bolt on modules and custom RICE components.
• Post go-live level 3 support.

Environment: Oracle Applications EBS 11i, Oracle ERP 11.5.10.2, Windows XP/7, UNIX

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Gathering business requirements, allocation of work and On-Time delivery.
• Involved in the Legal Entity implementation.
• Worked on Procure-to-Pay (P2P) cycle for creation of requisitions, purchase orders and receipts. Created invoices in AP.
• Worked as SPOC and represented Confidential in various calls.
• Involved in the development of technical documentations, Release notes of reports and interfaces.
• Designed and developed procedures and functions and encapsulated into PL/SQL packages to extract the data specific to customers.
• Development and customization of reports based on Customer requirements.
• Involved in the development & Support of interfaces and to import the data from legacy systems into oracle application base tables.
• Involved in debugging, troubleshooting Procedures, Functions, Packages and customizing the existing ones.
• Designing of MD200 and develop code by coordinating with Businesses.
• Prepared Test scripts and involved in Application Integration Testing and System Integration Testing at clients place.
• Prepare issue and risk tracker and submit to client weekly basis. Worked with technical team to resolve / provide technical issues.
• Analyze and estimate the effort for the Change request and bug reported and provide the fix for the same.
• Customized the existing PO Print Report based on Customers Requirement.
• Created many standard and ad-hoc reports based on business requirements.
• Knowledge in Oracle Purchasing seeded reports.
• Basic Knowledge in XML Publisher RTF report designing.
• Customized PO shipment form to restrict and default the type of matching based on line type.
• Customized Supplier Site for by adding extended DFF & implemented form validations based on business requirement.
• Customized oracle account generated Workflow to flip segment2 based on UNSPSC.
• Customized existing PO & Requisition workflow for implementing new customizations based on GE Business requirement.
• Involved in applying OAF Personalization in i-procurement Self Service Purchasing responsibility on various levels Seeded function, User, Responsibility, Organization .
• Partnered with business to gather business requirements, designed new process flows, worked with developers to develop the package and worked with users to implement the new system.
• Techno Functional role involved in implementing New LE & BLE Business LE Entity implementation.
• Migration of Old Operating Units into new GE Infra currency based Operating units.
• Supporting technical design of all Infra Businesses’ activities.
• Migration of all Buy to Pay Operating Units in SSP5 to Release 12 from existing 11i version.
• Performing Impact analysis in current business process to identify critical impacts to existing business specific customizations with respect to R12 upgrade changes/enhancements.
• Participating in SSP5 Corporate workouts and meetings as Technical Lead from GE Infra Businesses to gather business specific requirements.
• Working with the corporate teams to ensure that the delivery of the ORACLE upgrade meets the functional and technical requirements defined by the business client.
• Assist in resolving application upgrade issues related to customizations and validate the same.
• Study of new business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs.
• Provide tactical and strategic input under the direction of IT Business owners towards Working Links current and future business applications.
• Business process mapping with all standard and customized functionalities in SSS modules.
• Analyzing and testing SSP5 integration with 3rd Parties applications and legacy systems.
• Analyzing user needs, conferring with Business Leaders to improve procedures and identifying and solving problems within existing functionalities.
• Post go-live level 3 support.

Environment: Oracle Applications EBS R12/11i, Oracle ERP 11.5.10.2, Windows NT/XP/7, UNIX, Linux.

Confidential

Oracle Techno-Functional Consultant

Responsibilities:

• Gathering business requirements, providing solutions and proposing strategies for integrating ERP systems with ClearOrbit.
• Creating Business Rules, Ad-Hoc Reports and troubleshooting system issues.
• Creating test planning, writing test scripts based on functional requirements and managing different testing activities for System Integrations, patch releases, and providing support for UAT.
• Creating dynamic Purchase Order, Shipment, Package and Quality reports using Eclipse BIRT reporting tool.
• Configured ClearOrbit for different business requirements, prepared code repositories, reusable scripts for Company and User creation, created and scheduled concurrent programs at ERP and ClearOrbit to automate integration process.
• Involved in implementing Disaster Recovery planning.
• Created Dashboards for performance and trend analysis.
• Participated in weekly Leadership meetings with Management team in providing project roadmap and creative solutions on critical client issues (including process changes).
• Organized offsite events for team building, created SOP and training documents.
• Managed a Support Central community to facilitate Business and end users.

Environment: Oracle EBS 11i, ClearOrbit, Oracle PL/SQL, Windows XP.

Confidential, Reston, VA

Oracle Techno-Functional Consultant

Responsibilities:

• Used UNIX Shell Scripts and developed PL/SQL procedures to extract and load data for month-end batch processing.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Customized various reports as per customer requirements such as Open Sales order report, Min-max report with historical usage and range of suppliers, item-vendor report, PO/items expediting report, Open sales orders reports etc.
• Worked on rebuilding the interfaces and customizations on Accounts Payables and Purchasing Modules. E.g. Payables Open Interface (for two different sources), Purchasing Receiving Interface and PO outbound programs.
• In the OM module, designed and developed Interface Programs for Importing Purchase Orders using Import Standard Purchase Orders.
• In the INV module, designed and developed Inventory Purchasing requirements Report in extension of inventory min-max report. This report gives all item information including minimum, maximum, on hand, available, reorder as well detail level of supply /demand type, supply/demand quantities, projected on hand and other useful information.
• Used Discoverer 4i to access information from organization database for analysis and Reporting to extend the functionality and capability of the End User.
• Developed screens using Forms 6i - to enter new business data using billing form, to input information for facultative processing, to view policy on-line, to reinsure a policy implementation of fine grain access control.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Customers, Parties, Customer Accounts, Party sites using TCA architecture.
• Involved in writing Pl/SQL procedures and Packages as part of implementation and production support.
• Coding of interface specific SQL * Loader control files, PL/SQL package and SQL*Plus Script (For building the interface table and related synonyms, indexes, granting privileges, defining value sets, concurrent programs, parameters, request group, adding concurrent programs to request groups).
• Develop the new Report in Report Builder as per the requirement like PO Report, Suppliers Report etc.,
• Involved in designing and development of PO XML report.
• Involved in preparation of Technical Design Documents (MD 200)
• Registration of Concurrent Programs.

Environment: Oracle Applications EBS 11i, Oracle ERP 11.5.10.2, Windows NT, UNIX.