SUMMARY

• 7+ years of strong techno - functional experience in Oracle EBS (that includes the organization’s ERP, SCM and CRM applications) with hands on experience in Requirement Analysis, Fit/Gap Analysis, Customization, Upgradation, integration, Implementation, Testing and Maintenance with a current emphasis Oracle E-Business SuiteR12.
• Expertise in Oracle Order Management App that automate a business entire's sales order management process and also includes EDI, XML, telesales and web storefronts.
• Experience in Configuration, Migration, Customization, Production and Support of Oracle Applications with major focus on Oracle SCM (AR, AP, OM, QP, BOM, INV, PO, WMS), Oracle CRM (Service Contracts and Install Base), Financial modules (GL, AP, AR) and Manufacturing ( Outside Processing).
• Extensive experience in holding the primary accountability of supporting the design, planning, development, testing, documentation and maintenance of best-in-class Business Intelligence capabilities, including data warehousing, ETL and reporting.
• Experience with Oracle E-Business Suite using SQL, PL/SQL, Forms, Reports, API's, Workflow, Discoverer and XML publisher.
• Advance knowledge of the Systems Development Life Cycle (SDLC) and implementation of methodologies such as Waterfall, Rapid Application Development (RAD), and Rational Unified Process (RUP).
• Extensive experience in gathering requirements and authoring Business Requirement Documents (BRD), Software Requirement Specification (SRS), Functional Requirement Document (FRD) and maintaining Requirement Traceability Matrix (RTM).
• Comprehensive knowledge of developing supply chain metrics usingOracleEBS,OracleASCP, Google Big-query and Tableau reports.
• Excellent functional knowledge in SCM, P2P and O2C modules like Inventory, Work in Progress, Engineering, BOM, MSCA, WMS,ASCP, Order Management, Purchasing, Receivables, Payables and iStore.
• Experience in OracleEBS Techno functional experience in implementingProcuretoPay(P2P) and Order-to-Cash (OTC) Cycles.
• Experience of Data Conversion and migration using Oracle Open Interface tables and standard APIs.
• Expertise in designing of payroll inbound and outbound interfaces which is related to non-Oracle Payroll entrainments like ADP, Integral as well and Oracle Payroll base environment
• Working knowledge of Procure-to-Pay (P2P), Order-to-Cash (OTC), Drop Shipment, Internal Sales Order (ISO) cycles.
• Experienced in writing AIM (Application Implementation Methodology) Documents - Technical design documents, unit testing documents and Installation Document's (CCL, MD70, CV60, UTC and MD120).
• Experienced with Analyzing Business Requirements from Black Box testing perspective. Reviewed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, User Interface, Performance, Usability and Security requirements (PCI, SOX, Change Management, etc.).
• Good knowledge in development of Business Processes, Custom interfaces, APIs, building control files, dealing with Application Object Library (AOL), reports and workflows.
• Expertise in database development tool (TOAD), and BI tool. And have strong knowledge of employee applicant tracking system (TALEO) and MS Excel used for candidate reporting.
• Experienced in EDI mapping for PO Outbound Interface to EDI 850 and EDI 860 standard formats.
• Extensive experience in working with PL/SQL Stored procedures, triggers, packages using Oracle8i/9i database. Experience in Development and Customization of Reports/XML Publisher/Form Personalization.
• Expert in all windows applicationstoperform P2P reporting and document functionstoinclude Microsoft Project, PowerPoint, Excel, Access, Word and Visio.

TECHNICAL SKILLS

• OracleEBS
• OracleASCP
• Google Big-query
• Tableau reports
• SQL
• PL/SQL
• Forms
• Reports

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

Sr. Oracle EBS Consultant/Analyst

Responsibilities:

• Assisted in Performing feasibility study on New implementation, integration configuration and Upgradation on Manufacturing and SCM Modules(R12): Including Inventory, WMS, WIP, ASCP and OM. utside processing
• Created Functional Specs for Core Processes like Outside Processing Product Sterilization and Subcontract business processes in Oracle Manufacturing modules.
• Functional Involvement in Implementation of WIP with outside processing (OSP) for handling the Contract Manufacturing.
• Supported SCM team configuringWMSand MSCA modules for definingWIPRules for Receiving, Shipping and Picking.
• Assisted in Outside Processing Pos with PO move resource Type operation in WIP when operation is move to Queue to Move, and then generated Import Requisition,
• Provided production support for Inventory, Purchasing, Depot Repair, Field Service, Installed Base, Service Contracts, iProcurement,WMSand MSCA.
• Involve in Configuration of Oracle PO, INV, PO (R12.2.4) also done Configuration of Taleo Reports through OBIEE Reporting and Trained and tested on the Taleo Social Sourcing Feature (TSS).
• Assisted in custom EDI mapping and managed EDI Defect resolution and worked onEDIMappingfor Order Import Data, Invoice Data in AR, Purchase Order data.
• Reviewed current business process and documented the business procedures for Procure to Pay cycle. Dealt with Buyer Setup, RFQ, and third party custom POs. Also dealt with Outbound POs throughEDI.
• Assisted in EDIsystem integration withOracleApps from ground zero. Assisted in developing PL/SQL stored procedures to meet the Interface and Conversion requirements.
• Prepared specifications for customization of reports, forms & workflows and worked with developers in developing the same.
• Created training documents forSCM (Supply Chain modules) and trained the super users and other team members.
• Simplified theOracleProcuretoPay& Financial stuck-up Processes.Manage, Design and Develop solutions forProcuretoPaytoreduce user dependability and time
• Involved in Integration between isupplier, Collaboration planning and ASCP for SOMI (Supplier Owned Managed Inventory
• Conducted Demantra integration, patch, customization, and impact analysis testing forASCPandSCM.
• Create PL/SQL packages to perform validations on the imported data and load into theInterface table from legacy system.
• Enabling Profile in integration interface for new org in Demantra and exporting Forecast into ASCP.
• Designed and developed Supplier, Supplier Site and Supplier Contact Conversions to migrate legacy Supplier data to Oracle R12 EBS system.
• Managed reporting migration from massive third-party partner payment processor, and manage readiness / change management ecosystem for an adoption of new BI (Business intelligence) strategy and tactical solution.
• Developed multiple OAF pages to address specific requirements including Advanced Tables, Table-in-tables, Parent Child relationships, Search, Partial Page Rendering, File Uploads.
• Activities involved stakeholder elicitation, requirementsdocumentation, modeling, enterprise analysis, requirement analysis, workflowdocumentation, solution verification and validation

Confidential, Columbus, OH

Oracle EBS Analyst

Responsibilities:

• Involved in Upgradation of Oracle Modules (AR, GL, AP) from 11i to R12 (11.5.10 to Oracle R12.1) and Implementation of AP interface program to interface telco bill with outside processing vendor.
• Worked on Oracle AR customer import interface to import party (customers, addresses, sites, payments, bank accounts) data into the system in accordance with Trading Community Architecture (TCA).
• Developed custom views to retrieve data from historical database using dblink for the AR collections form replica in new instance.
• Developed custom views to retrieve data from historical database using d blink for the AR collections form replica in new instance.
• Worked on errors faced in GL cross validation rules used in Receivable account generator validation process and Developed FSG Reports in GL like (Income statement, Debt Expenses, Inter Company Summary).
• Developed Journals Migration Program to migrate the journals into R12 GL module. The journals are inserted into the GL Interface table and then ran the Journal Import Program to load the data into GL base tables.
• In R12 upgrade project, managed tech team and DBA team during entire project, and also worked on customization upgrade, setup changes and user testing management.
• Migrated Oracle Receivables Receipts data from 11i to R12(11.5.10 to 12.1.1) of oracle applications. The data is imported into oracle receivables using Receipts Applications Programming Interface (API) Program.
• Developed Journals Migration Program to migrate the journals into R12 GL module. The journals are inserted into the GL Interface table and then ran the Journal Import Program to load the data into GL base tables.
• Developed XML Report to show the receivables transactions based on distribution accounts in Oracle different modules, specifically in AP, GL and AR Module.
• Developed custom AR Receipts Register Page, Open AR Transactions Page, AR Receipt Balances Page, AP Paid Invoices Page using OAF.
• Developed in Service Contracts customization using Oracle PL/SQL and Standard APIs.
• Also Involved in Design & Implementation of Oracle Identity & Access Management suite.
• Handled many inbound and outbound integrations as subject matter expert in Oracle E-Business Suite
• Created Shell Scripts for Host Concurrent programs and migration scripts for code deployment.
• Worked on extension of seeded OAF pages in Oracle module by implementing new logic in Controllers.
• Developed various Inbound Interfaces to include Item Master, Material Transactions, Purchase Orders, Requisitions and PO Receipts.
• Developed various Outbound Interfaces to include Item Master, Purchase Orders and Price List.
• Involved in fixing code issues raised during SIT (System Integration Testing) and UAT (User Acceptance Testing) and worked with oracle support team through Service Requests (SR's) on seeded performance Issues.

Confidential, Bentonville, AR

Oracle EBS Analyst

Responsibilities:

• Worked as a functional consultant for the implementation of Oracle 11i for CRM (Service Contracts and Install Base) Modules and Oracle HRMS.
• Worked in Configuration Teams and Oracle DEV and Support Teams to Address integration between Oracle HRMS, Project Accounting and CRM during implementation life cycle.
• Developing testing strategies for all aspects of theCRMto ensure the most effective approach for the company and its products.
• Customized CRMOD trial version and Integrated Google Talk and Microsoft outlook withOracleCRMon Demand. integration ofCRMwith other ERP modules like Order Management, Inventory Management, Accounts Receivables, General Ledger, Accounts Payables
• Involved in requirements session and solution design workshop for the legacy data conversion from existing mainframe system toOracleEBSCRMand then finally loading the customer, Service Contracts, Warranty and Asset (Installed Base) data into Salesforce using Salesforce Data Loader
• Developed a process which automatically integrates company home grown customer CRM system and warehouse shipping system to complete entire O2C transactions in Oracle EBS.
• Involved in Integration Testing for customed Payroll interface, reports and Payroll Year End Report.
• Involved in annual performance review and Career/succession planning for Business Units using Oracle HRMS.
• Worked on SQL query optimizations. And familiarized several utilities used in oracle applications
• Involved in company Oracle EBS 11i initial implementation. Focused on manufacturing module setups, customization development, system testing and user training, Especially in OTL and payroll module.
• Worked in Payables Interface tables and Supplier Open Interface Import programs to meet the Conversion requirements of Supplier records from legacy to Oracle.
• Involved in Designing applications extensions for custom retro pay process based on time skip in OTL and payroll interface.
• Designed Oracle Payroll Processes Like Check Writers, Deposit Advices to Process Huge Volume of Checks and
• Worked on Store E-Registers, Payroll Registers and Generated PDF's using BI Publishers and BI Bursting Mode
• As part of business acquisition, converted a Chinese ERP system into Oracle EBS. Worked on business entity definition, module setups, process flow definitions and data conversion script development.
• Developed XML based Sales Order Acknowledgement Report in oracle modules.
• Designed and implemented an automated interface on manufacture transactions with subcontractors’ MES system.
• Developed a process which automatically integrates company home grown customer CRM system and warehouse shipping system to complete entire O2C transactions in Oracle EBS.
• Worked on Workflow customizations on approval flow, function extension, account derivation, etc.
• Work closely with stakeholders to document all requirements for project Direct Reserve.
• Facilitated workshops, interviews, brainstorming sessions and meetings to elicit requirements from the business sponsor, partners, and users.

Confidential, Laramie, WY

Oracle EBS Analyst

Responsibilities:

• Responsible for the design specifications for implementation of Taleo Applicant tracking including integration with Oracle EBS HRMS
• Responsible for developing and implementing various configuration, extensions, customization, integration (CEMLIs) for oracle Time Labor(OTL) and payroll modules.
• Development of CEMLIs for OTL and Payroll modules including inbound/outbound interfaces to third party vendors.
• Involved in Integration Testing for customer Payroll interface, reports and Payroll Year End Report.
• Designed and developed several critical payroll and benefits reports using oracle tool Developer.
• Developed utilities to be able to import and export tables into oracle HRMS database using tools like SQL loader.
• Conducted User Acceptance Testing (UAT) and collaborated with the client stakeholders and QA team to develop the test plans, use cases and test data to be used in testing.
• Worked with Oracle Support by raising SR to resolve Oracle EBS issues with Oracle seeded functionality.
• Collaborated extensively with development team on development and customization of Oracle RICE (Reports, Interfaces, Conversions and Extensions) components as per business requirements.
• Documented existing and proposedbusinessprocess flow, analyzed current and target system, and conducted GAP analysis.
• Worked with development team to help create technical simulations during process to help business clients handle tangible artifacts.
• Assisted in User Acceptance Testing (UAT), post implementation support, and logged, tracked, and managed any defects in QC.
• Served as liaison between the business and deployment teams and ensured solution was both technically sound and met user’s needs.