SUMMARY

• 10+ yrs of work experience in the field of Oracle Applications and Product Lifecycle Management
• Currently working as Sr. Oracle EBS Techno Functional Analyst for Confidential Software Inc.
• Main areas of expertise include iStore, Order Management, Advanced Pricing, Inventory Management, Receivables Manager, Payables, Purchasing, iProcurement modules, Service Contracts, Installbase, WMS, WIP, BOM, Depot Repair in Oracle E - Business Suite
• Excellent communication skills and efficient team player

TECHNICAL SKILLS

Oracle Applications: Oracle E-Business Suite 11i/R12, Order Management, Advanced Pricing, Inventory, Account Receivable, Account Payables, General Ledger, Workflow Manager, iStore, iProcurement, Service Contracts, Installbase, WMS, WIP, BOM, Depot Repair

Oracle Service Cloud: RightNow

Programming Languages: SQL, PL/SQL, HTML, VBScript

GUI Tools: TOAD, SQL Loader, QTP 10.00, QC, Workflow Builder, Oracle Reports, Git, SVN

Agile Methodology: JIRA

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Sr Oracle EBS Analyst

Responsibilities:

• Involved in the initial discussion with the Business to get the BRD documented
• Connect with different stakeholders like EBS Business Users, Banyan (warehouse team) to understand the requirement and the feasibility of each requirement
• Setup solution discussion calls with the internal IT team to design the solution architecture
• Provide time and development estimates for accurate Project Planning and Resource allocation
• Involved in UAT testing with the Business and identificy any defects and follow up with the Development team to closure
• Post Production go-live support for 2-3 weeks
• During the Payment Gateway switch over project:
• Involved with the initial discussions with the Bank to provide them with the detailed current Business process
• Setup calls with the Bank to understand if the new Payment Gateway had the capabilities of handling the existing business process
• Building Project Plan based on the different components like Credit Card and ACH Tokenization, Authorization, Capture and Settlement process
• Setup UAT sessions with the Business to capture all test case scenarions and follow up until closure of each test case
• Provide post go-live support for 2-3 weeks
• As part of Production Support, capture all defects through the ticketing portal (RemedyForce) and followup on each issue until resolution

Confidential

Responsibilities:

• Working on the R12 Implementation / Production Support for Confidential Magento site to Oracle EBS Integration
• Setup Client Meetings for Requirements Gathering during the 1st week of Implementation process
• Designed Solutions and documented BR100, MD120 based on the Client Requirements
• Involved in Unit Testing / SIT / UAT and Production Cut over and code migrations
• Interacting with Off-shore and Offsite resources for day to day development activity monitoring
• Providing Root Cause Analysis for all the Defects and provide the necessary solution to fix the issue

Confidential

Responsibilities:

• Worked on the R12 Production Support for Taylormade B2B iStore site as a Techno Functional Analyst
• Prioritized meeting with the Business to understand the criticality of each Defect after the go-live of the B2B site(s)
• Involved in providing KPI’s and metrics to the Business
• Provided Root Cause Analysis for all the defects with the necessary solution to fix the issue
• Co-ordindated with the Offshore team to make sure the defects gets fixed in time as per quality standards
• Involved in preparing MD120 for migrating fixes to Production. Co-ordinating with DBA team to make sure smooth migration

Confidential

Responsibilities:

• Worked on the R12 Upgrade of Confidential LS iStore site as a Functional Analyst
• Prepared documents such as BR100 (for Setup related changes) & MD050 (for Change Request of existing functionality or New Custom solution)
• Customized Single-Sign-On functionality for Password maintenance for LS store users and Confidential Employees using OAM/OID and third party Identity providers
• Involved in System Test/SIT/UAT testing and co-ordinating the testing efforts with the Offshore testers
• Converted activities related to iStore components, such as LS users, Item assignment to Catalog, Media Object conversion and Admin UI rule conversion

Confidential

Responsibilities:

• Worked on Enhancement & Bug fixes for Confidential iStore B2B site
• Prepared documents such as BR100 (for Setup related changes) & MD050 (for Change Request of existing functionality or New Custom solution)
• Involved in the Customization of the Google Analytics report for the existing iStore B2B site.
• Integrated iStore Search functionality with Google Custom search to give users better search results.
• Gathered requirements from Customer and co-ordination of Offshore Development activities

Confidential, Dallas

Responsibilities:

• Implemented iStore B2B site for Confidential Loyalty Program for Loyalty Customers
• Involved in preparation of BR100 and MD050 documents.
• Setup System Integration Test and User Acceptance Test instances
• To display the Customer Loyalty points in a separate Ministe
• Ability for the Customers to switch from regular minisite to Loyalty Ministe
• Customize the cart so that only Loyalty items are displayed in Loyalty minisite Cart
• Created a PL/SQL Concurrent Program to add points to Customer Account based on Sales Order lines shipped to the Customer
• Involved in the Post Production Support

Confidential

Responsibilities:

• Provided Production Support which involved modules like iStore, Service Contracts, Installbase, OM, INV, PO, OLM, PA and AR
• Involved in preparation of BR100 for Setup related changes and MD050 for Change Request of existing functionality or New Custom solution or Report.
• Execution of System Integration Test and User Acceptance Test
• Involved in the Customization of the Invoicing Process of the existing T4P module as per the new Business Requirements.
• Involved in Weekly calls with the Client to discuss existing issues and progress Report of the CR's

Confidential

Responsibilities:

• Implemented of iStore B2B site for Confidential with integration to Service Contracts and Installbase
• Preparaed BR100 and MD050 documents
• Set up System Integration Test and User Acceptance Test servers
• Involved in the Customization of the Shipping Information / Billing Information page to include addition Ship To Contact
• Involved in the Post Production Support

Confidential, Dallas

Responsibilities:

• Involved in the Post Production Support providing additional support to the Client for any Production issues faced after the Implementation.
• Helped the client in getting few minor changes to Production to improve the performance of the iStore site and guided the DBA’s and Network team on the DMZ issues.
• Provided support to the client on User Account maintenance (addition/updation of iStore users)
• Conducted knowledge transfer sessions to the client team related to topics such as User Maintenance, Content Management (uploading media objects and assigning media objects to Content Component)

Confidential, Dallas

Responsibilities:

• Implemented iStore Minisite for B2B model setup that includes store Checkout processes
• Involved in requirements gathering, definition, conversion of Business Requirements into Functional specification.
• Customized the Catalog page, Product page and Cart page to implement the Minimum Order Qty and Dollar Minimum.
• Customized the Order Type mapping based on User Role/Permission using the Custom Hooks.
• Prepared setup documentation - BR100 according to Business requirements and MD050 for Functional Design Document to be delivered
• Set up System Integration Test and User Acceptance Test server

Confidential

Senior Software Engineer

Responsibilities:

• As part of the Confidential Development project, working as the Functional Analyst for the following modules: OM, INV, Purchasing, ASCP, iSupplier, iProcurement.
• Updated the CQ with the Defects found during the Functional Testing and follow up with the issue to closure.
• Invovled in Design/Testing of custom components in R12 environment for the modules like OM, INV, Purchasing.
• Automated test scripts using QTP 10.00 and QC 10.00

Confidential

Responsibilities:

• Analyzed Business requirements for BTI Projects and Financial Maintenance tickets
• Created Project definition documents and Functional Design documents. Modifying FD’s for the existing Interfaces to suit the new Business Processes
• Worked with development team to help them understand the functional requirements
• Resolved maintenance related issues logged by the business users
• Involved in onsite coordination activity ensuring all issue resolution information is provided Confidential the earliest
• Responsible for creating Functional Test Scripts for performing Functional Testing of the BTI Components for the modules like AP, GL and FA (Interfaces and Conversion) from Offshore

Confidential

Responsibilities:

• Primarily involved in performing Setups/Configuration in Oracle for the following modules: AR, AP, GL, OM, OPM, INV, PO.
• Responsibilities included Pre-implementation and Post Implementation Review of configurations i.e Review the OCR(Oracle Configuration Request) documents.
• Check if all the mandatory information are filled in the OCR; review the configurations done in INT instance (integration testing instance).
• This cycle would be carried for three more instances in sequence DEV, TST, ORT(Operation Readiness Testing instance) and finally into Production Instance.
• Handled all the Configurations related to a particular Release i.e FTI (Wyeth Integration)
• Performed weekly Alignment activities to make sure synchronization between all the Project and Production Instance.
• Reported these activities to the Management on Weekly / Monthly basis.
• Carried out Configuration activites for other non release specific requests i.e., OCR raised by the AD team.
• Worked extensively on System Admin related functions like Roles & Responsibilites, Menu creation etc.

Confidential

Responsibilities:

• Provided solutions to the issues raised by the client after thorough investigation and testing in the test instance
• Involved in development of complex RICEF objects in accordance with Technical Development standards for Purchasing module.
• Responsible for Daily Interface checks and error reporting for modules like AR, AP and PA.
• Work on the resolution of each error with in the application delivery scope
• Assisted Onshore team during the Period End Closure for modules like AR, AP and PA.
• Updated the BR100 for additional configurations
• Followed the Request for Change Process (RFC) to implement a new configuration or execute any data fix or patch.
• This involves thorough testing of the fix or regression testing of the patch in test instance.