We provide IT Staff Augmentation Services!

Senior Oracle Ebs Techno Functional Consultant Resume

Seattle, WA

SUMMARY

  • Oracle Certified wif 11 years of experience as Oracle Applications Techno - Functional Consultant
  • Extensive experience in Solution Design, Integration, Analysis, Development, Testing and post-production support for Oracle EBS Suite R11 &R12 version.
  • Multiple full Life Cycle implementations, rollouts, upgrade and support projects from 11i to R12
  • Experience in Order to Cash (OTC) and Procure to Pay (P2P) business flows, Has multiple Project experiences in working directly wif business users to gather functional requirements and developing technical components
  • Good Knowledge in Data Model of Order Management (OM), TCA Architecture, Account Receivables (AR), Purchasing (PO), Account Payables (AP), General Ledger (GL), Fixed Assets (FA) Modules and work Experience in OPM Inventory, Service Contracts, HRMS and Payroll Modules
  • Technical Expertise in SQL, PL/SQL, Interfaces, Conversions, Extensions, XMLP, Discoverer 10g, Oracle Reports, Forms, Oracle Form Personalization, Custom.pll, Oracle Workflow, Unix Shell Scripting.
  • Strong programming knowledge in creating procedure, API, Packages, Functions, Triggers and other database objects
  • Experience in SOA Middleware concepts BPEL, ESB and BAM technologies
  • Experience in fine tuning teh code for better performance
  • Experience in creating Development Requirements, Technical Designs, Conversion Mapping Documents, User training manuals, Test procedure document preparation
  • Experienced in writing AIM Documents - MD70, CV60, MD120, TE020
  • Well versed wif defect tracking tool such as HP Quality Center (QC), Clear Quest (CQ) and requirement tracking tool such as Project Portfolio Management (PPM) and migration tools like Kintana
  • Worked wif Oracle support to resolve seeded application issues. Created service requests (SRs) wif oracle support and tracking them to closure.
  • Experience in Onshore-Offshore model Implementation and commitment to excellence proven by an outstanding career track
  • Knowledge in OBIEE, ODI and Hyperion reporting tools

TECHNICAL SKILLS:

Primary Skills: Oracle EBS Technical Development (RICEF Components), Interface (Inbound and Outbound), Conversions, Extensions, Forms, Form Personalization, Workflow builder, XML & Discoverer Reports

Packages (Incl ver): Oracle EBS 12.1.3, 12.1.2, 11.5.10, 11.5.9

Modules: Order Management (OM), Account Receivables (AR), Purchasing (PO), Account Payables (AP), General Ledger (GL), Inventory (INV), OPM Inventory, Fixed Assets (FA), Install Base (IB), HRMS, Payroll, Time and Attendance Modules

Operating Systems: Win 7, XP, 98, UNIX

Languages: Oracle SQL, PL/SQL, C, CPP, Java, UNIX Shell Scripting

Development Tools: Toad, SQL * Plus, SQL Developer, JDeveloper, Forms, Reports, BI Publisher, Putty

Database: Oracle 10g, 9i, 8i

Configuration Tools: PPM Clear Case, Clear Quest, VSS, Kintana

Documentation: MD70, MD120, CV60, CV70

PROFESSIONAL EXPERIENCE:

Confidential, Seattle WA

Senior Oracle EBS Techno Functional Consultant

Responsibilities:

  • Involved in Implementation of a new fulfillment center for PRG2 (Prague, CZ), Design and development of Interfaces& XML reports wifin Oracle EBS - Including preparation of Technical design document, Installation document, and test scripts.
  • Vendor Returns, and Return Vendor Returns Interface wif VPS System Integration.
  • Contra COGS Interface & AP Invoice Interface (DFP Process)
  • AR Invoice print reports (XML Reports for multiple batch sources/channels), and Modifying/Customization ofBI print reports.
  • Involved in streamlining AWS AR Invoice import process which saved 8-10 hours every-month during AR month closure period.
  • AWS feed 6 Million invoices to OFA during every month closure period, One of teh bottleneck wif traditional approach was it would wait until Auto invoice complete to spawn teh next run, me has introduced a wrapper program which will internally spawn Auto invoice master program and teh request set will no longer wait on Auto invoice Master program to complete, as invoicing will happen parallel and will give request set spawn immediately after wrapper program completes in seconds.
  • Increase teh TPM (transactions per minute) for Auto-invoice import program from 3.5K to 10K, wif teh standard approach suggested by Oracle.
  • Involved in supporting AR Month-closure activities for global ledgers (8 Ledgers/OU’s), and worked closely wif AR super users across teh Geographic’sbyproviding solutions for month closure blockers / issues dat hamper period close process.
  • Supporting day-to-day production activities for all 8 OU’s, fixing teh defects by deploying data-fix for short term resolution and working wif Dev team by providing teh root-cause/resolutions for a long termsolution.
  • Involved in developing enhancement for AWS Revenue Recognition process, Confidential Custom solution dat import AR invoices and Receipts based on teh Revenue Recognition flag.
  • Involved in performance initiatives
  • Developed additional hints/indexes which improved teh CLOSE PERIOD button performance from 35 minutes to 15 minutes.
  • Involved in tuning Deferred Revenue report (Custom Report) for a better performance.
  • Involved in Customization for Oracle EBS Integrations wif Confidential Systems (both upstream & downstream systems).
  • Vendor Payable Systems (VPS), Vendor PO’s and Tax information integration wif Oracle EBS.
  • Vendor Central & S3 Uploads, Managing Vendor Invoice Print documents and Primary System for Vendor information
  • Garter &Apian Applications, Custom Approval process integration wif Oracle EBS.
  • Involved in Streamlining MCB issues thus making month end closure process on-time wif-in defined SLA’s.

Environment: Oracle Applications R12.1.3 - Account Receivables (AR), Account Payables (AP), Trading Community Architecture (TCA), Oracle 11g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, SVN Repository, Confidential Cloud, Confidential Vendor Processing System (VPS), Confidential Vendor Central System (VCS)

Confidential, Los Angeles CA

Senior Oracle EBS Techno Functional Consultant

Responsibilities:

  • Working as Senior Oracle EBS Applications Developer for Oracle R12 deployment for new projects/enhancementsand Production Support.
  • Involved in development for Inbound Order Import Process (for multiple 3rd Party Systems, Sample Orders, and Win-back/Promotions Order Imports) using Oracle API’s and Interface tables.
  • Involved inDesign&Development of Auto-reship project(Auto-reship is a Regular shipment of a product on teh basis of original order supported by automatic payment), Read XML format data file and process Order Import by using Standard API’s, and Create Auto-reship Shipment based on teh Original order shipment confirmation.
  • Involved in developing teh integration of PayPal payment method, Developed AR Receipts Interface,and Created Manual Receipt Batch for Open AR Invoices related to PayPal payment method type.
  • DevelopedInterface to update Customer Headers, Sites and Site Use Attributes (DFF) Columns and Standard Columns by using standard API’s for a specific Customer account which has 2000 plus active sites.
  • Developed Interface in Inventory module using Standard APIs for Item Assignment update.
  • Involved in development of Custom.pll for Quick Sales Order Form and Customer Care Order Entry Form
  • Developed Form Personalization’s in Order Management (OM) module to Enable/Disable Standard Fields, Push Buttons, and functionality to restrict usersnot to add a New Order Line in Quick Sales Order form for particular Order Source
  • Involved in development of complex reports like Gross Sales Report, Tax Reports (1099 Pre-printed material) XML Report, and Supporting XML Bursting reports.
  • Involved in developing PL/SQL Stored procedure programs Ex: Demantra prerequisite update scripts (Demand Class Code update), Adhoc Data load programs to custom tables using SQL Loader for reporting purpose, Update Incorrect customer address for eligible Open Orders, etc.
  • Involved in development of UNIX and Java Concurrent Programs to handle teh GPG & PGP file encryption process as part of PCI Compliance (One of teh Effective way to handle customers credit card information, which stores in teh external source data files)
  • Developed multiple Oracle Alerts (Periodic Alerts) to report Interface errors to users, and to notify daily 3rdParty Order feed status.
  • Involved in Supporting EDI Outbound Invoice (810) and Inbound Orders (850)
  • Prepared change request documentation and unit test plans. Performed unit testing and system integration testing. Preparation of technical design document, Installation documents and test scripts

Environment: Oracle Applications R12.1.2 - Order Management (OM), Account Receivables (AR), General Ledger (GL), Inventory (INV), Oracle Alerts, XML Reports, Oracle 11g/10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Form Personalization, Custom.pll, Silver pop, UTL FILE package, EDI Gateway, Java

Confidential, Pittsburgh PA

Lead Oracle Applications Technical Consultant

Responsibilities:

  • Worked as a Senior system Analyst for Oracle R12.1.3 deployment for Purchasing (PO), Account Payables (AP),Enterprise Asset Management (eAM), Inventory (INV), HRMS & Payrollmodules (for 3 different phases of teh Project)
  • Lead teh design and development of Integration between Enterprise asset management(eAM) and Purchasing (PO)Modules
  • Involved in development of complex RICEF objects in accordance wif technical development standards.
  • Involved in development of below Conversions and Interfaces,
  • Purchase Requisitions Conversion.
  • On-Hand Quantity Conversion
  • Maintenance Route Conversion, data used toextract fromUS Steel legacy system called Passport and load Route Maintenance data to Oracle EBS.
  • HR People data conversion for around 8K employees, Extract teh data from Legacy source system called BIMS (Benefit Information Management System) and load teh data to Oracle EBS.
  • Employee Assignments data conversion for US Steel Active and Canadian Active Employees (8K Active Employees, 75K Retirees, CA Active 2K and CA Retiree of 15K records) data files to Oracle EBS.
  • Developed Form Personalization/Customizations
  • In teh Move Order form, whenever user select an item from LOV, It will validate if teh item is on Open Blanket agreement, and tan display a custom message.
  • Form to Default WO Title and Planner Code in teh Task Requirements
  • Disable OK button on Purchase Requisition form when it is launched, and Enable teh Action Menu to launch teh route Information (Custom Form) and enter all teh mandatory Information in teh form and tan Enable OK button to Process.
  • Involved in customization of Putaway form, Form is used to view what needs to be putaway and indicate where teh goods are being putaway wif teh ability to process teh movement from teh form.
  • Developed multiple XML reports from Scratch and Customized standard reports as per teh business requirements
  • Work Order Purchasing Traceability report - Report is used to track teh material requirements for a single Work order and display teh material Information linked to teh Work Order, Move Order and Purchase Requisition
  • Min Max Planning Report - Customized seeded report to include teh demand and availability related to WIP Move Orders, Parameters and Output remains unchanged, Change is in teh Calculation of Supply, Demand and Availability at teh Item/Sub-inventory level.
  • Putaway Report - Material Management will run teh report to Identify Items dat has been received and are in stage delivery sub-inventory
  • Fixed Asset ledger Report - Report contains fixed asset information which is used for Accounting and Tax Department.
  • Customization of Standard Workflow (POAPPRV), whenever there is a change in promise date or quantity on a PO and Promise date is greater TEMPthan need by date, teh Original Move Order and Work Order will be updated and send a notification to teh Requester/Planner
  • Involved in customization of Standard Workflow (POSCHORD), Business Requirement is when teh requestor associated to a PO wif a pending change request should not receive a notification of teh pending promise date change.
  • Involved in supporting teh new item request (NIR) approval process using Standard Workflow (ENGCHMGT), workflow will be invoked from Oracle New Item Request Page upon submission of an NIR. A notification is sent to teh group listed in teh order defined in teh workflow (using standard functionality) to approve / reject / request more information
  • Involved in developing teh Extension to handle situation where there is a change in teh requested date and/or in teh quantity on a Move Order. Integration sub sequential documents - Move Order, Work Order, Purchase Requisition and/or Purchase Order will always be updated to reflect any changes in requested date and/or quantity
  • Involved in fixing performance issues raised due to custom code, Fixed performance issues in UAT (User Acceptance Test Phase) and PT (Product Test Phase), and worked wif oracle support team through Service Requests (SR’s) on seeded performance Issues
  • Involved in Post Production Support, and timely resolution of incidents based on teh estimate agreed date/ time and delivering Change Requests wif high quality turn around.
  • Involved in Assembly testing & Product testing phase to make sure custom solution has at most bug free, by testing all teh possible test cases scenarios.
  • Involved in end-to-end object reviews (Technical design, coding & UTP scripts) for new development, change request and Post-production defects (me.e. for all teh code artifact’s which are eligible for Prod deployment)
  • Co-ordinate wif onshore/offshore team for open clarifications/Issues raised by development team, propose & fix FD gaps identified during object reviews.
  • Identified areas of Improvements, suggest strategies and changes wherever applicable to work products, processes and development standards, in-order to mitigate gaps and thereby improving overall quality and efficiency of process.
  • Identified most common errors in development team and conducted CAR (Casual Analysis Report) sessions, to educate teh team on teh Issues to make sure they are not repeating in next time
  • Actively Involved in Pre and Post go-live activities, Involved in go-live deployment activities for all teh 3 phases in teh project

Environment: Oracle Applications R12.1.3 - Enterprise Application Management (eAM), Purchasing (PO), Account Payables ( AP), Order Management (OM), TCA Architecture, Account Receivables (AR), HRMS and Payroll Modules, XML Reports, Oracle 11g/10g, SQL, PL/SQL, Forms, Workflow Builder, SQL Loader, Unix Shell Scripting, Form Personalization, Custom.pll, UTL FILE Package, OBIEE, VSS, ADM Methodology, HP Clear case, Clear Quest

Confidential, Costa Mesa, CA

Senior Oracle Applications Technical Consultant

Responsibilities:

  • Worked at Client location, Involved in requirements gathering, Client discussions, Knowledge sharing and production support.
  • Involved in teh Interface scope of work, and acted as key point of contact to offshore development team.
  • Involved in developing complex objects in accordance wif technical development standards and best practices.
  • Involved in design and development of conversions
  • Involved in reviewing team deliverables me.e. Technical Design documents, Build artifacts, Unit Test plan and Installation guide, and suggest teh best practice methods for a quality deliverable.
  • Involved in Functional clarification meeting and ensured teh gaps are not trickled down to Functional design documents.
  • Involved in designing teh prototype, preparing MD 50 specification based on teh BRD (business requirement document), MD 60 technical specification, Unit Test cases document, coding and Unit Testing.
  • Work wif DBA team and cross functional application teams for application change control and system performance Issues
  • Involved in Post Production support
  • Identify and Purpose best practice methods, Coding standards, Standard for documentations.
  • Involve in daily and weekly meetings wif onsite coordinator to discuss project status.
  • Scheduled and participated in weekly client status call and updated wif teh project status.
  • Timely resolution of incidents based on teh estimate and agreed date/ time and delivering Objects wif High Quality.
  • Provide support for business critical application problems and issues.
  • Involved in deployment activities, and supported for PT migrations and go-live migrations.

Environment: Oracle Applications R11.5.10 - Order Management (OM), Account Receivables (AR), TCA Architecture, BI/XML Reports, Oracle 11g/10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Form Personalization, Discoverer reports, AIM Methodology, Winscp tool

Confidential, Santa Monica, CA

Senior Oracle Applications Technical Consultant

Responsibilities:

  • Involved in Interface & Extensions scope for teh project
  • Mentor teh team, and ensure teh work assigned to Interface team in delivered on time wif quality turnaround.
  • Involved in developing Inbound and Outbound Interfaces in Financial modules.
  • Customer Conversion
  • Receipt Confirmation Outbound Interface
  • PO Acknowledge Inbound Interface
  • Expected PO Inbound Interface
  • Receipt Confirmation Inbound Interface
  • Involved in all teh dry runs and ensured deployment scripts are created in sequence by identifying teh migration dependent artifacts.
  • Involved in customization/modifying existing Oracle forms, Added Pay terms by removing Order Type column in teh Custom Pick Release form.
  • Preparation of technical design document, MD120 and test scripts
  • Unit testing of teh objects and support teh onsite during Integration testing
  • Involved in code and documentation review.
  • Involved in Dry run and code deployment activities.
  • Acted as Point of contact for teh Tools used in teh project.
  • Involved in providing daily status and weekly status reports to onshore and offshore leadership.

Environment: Oracle Applications R11 - Purchasing (PO), Account Payables (AP), Order Management (OM), Account Receivables (AR), Inventory (INV) and WIP Modules, BI/XML Reports, Oracle 11g/10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Forms 10g, Form Personalization, Kintena, VSS

Confidential, Boston, MA

Oracle Applications Technical Consultant

Responsibilities:

  • Worked at client location as end-user facing role, and Involved in developing Interfaces and Extractions in Payroll Module
  • Time and Attendance Interface
  • Corporate Financial Accounting Interface
  • Store Time Attendance Extraction
  • Outlook Soft Payroll Extraction
  • Incorporated teh Change Requests as per business requirement
  • Involved in Post production support and fixed multiple Oracle Workflow related defects.
  • Preparation of technical designing document and Test script document
  • Project Point of contact for Citrix access tools

Environment: Oracle Applications R11 - HRMS, Time and Attendance Modules, Oracle Reports, Oracle 10g, SQL, PL/SQL, Oracle Alerts, SQL Loader, UNIX Shell Scripting, Citrix tools.

Confidential, Costa Mesa, CA

Oracle Applications Technical Consultant

Responsibilities:

  • Involved in Fit Gap Analysis for entire scope of delivery
  • Developed High Complex Discoverer 10g Reports, Including Drill-down, Detail, Summary format report
  • Developed/CustomizedFinancial Statement Generator (FSG) reports, Account Analysis reports using Oracle RDF reports.
  • Involved in Customization of GL Trial Balance report.
  • Journal Import: Developed a package for GL Interface dat validates and imports journals to General Ledger.
  • Developed SQL script to extract and delete un-posted journal data for a given set of book id and period name.
  • Developed SQL script to generate reverse journal report for a given period.
  • Analyzed General Ledger Major Book Report to debug teh usage of “related document” column and based on teh details developed a script to track teh related AP invoice from GL Journals.
  • Troubleshoot and resolved issues regarding accounting events balancing at teh month-end processing.
  • Customized general ledger trial balance, supplier sub ledger by account standard report as per teh business requirements
  • Involved in developing and Customization of Oracle Reports
  • Timely resolution of incidents based on teh estimate and agreed date/ time and delivering Objects wif High Quality
  • Preparation of technical design documents, unit test scripts and Installation documents.

Environment: Oracle Applications R11 General Ledger (GL), Purchasing (PO), Account Payables (AP), Discoverer Reports, Oracle BI/XML Reports, Oracle 10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Clear Quest

Confidential

Oracle Applications Technical Consultant

Responsibilities:

  • Design and Development Interface using BPEL Process Manager AP Invoice Inbound Interface
  • Involved in development Interface using ESB PO Outbound Interface
  • Involved in test development of File, FTP, Database, and Oracle Applications Adapters
  • Involved in writing Stored Procedures (PL/SQL) to test teh DB adapter
  • Taken multiple sessions on BPEL and other SOA technology components in teh organization.

Environment: SOA 10g (BPEL, ESB and BAM Components), Oracle Applications R11 - General Ledger(GL), Purchasing (PO), Account Payables (AP), Oracle 10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting

Confidential, San Jose, CA

Oracle Applications Technical Consultant

Responsibilities:

  • Involved in developing Conversions and Extractions
  • Customer Items & Cross reference Extraction
  • Customer Items & Cross reference Conversion
  • Involved in developing Service Contract & Install Base Extraction
  • Involved in developing Service Contract & Install Base Conversion
  • Involved in Developing multiple XML Reports as per client requirement
  • Involved in updating/modifying teh standard documents which was provided by client team.
  • Helping and guiding junior resources in teh team
  • Reviewing peers technical designs and teh code and suggest best practice methods where ever necessary and required. Preparation of technical design documents
  • Involved in deployment activities during go-live period
  • Involved in Knowledge transition and post-production support.

Environment: Oracle Applications R11 - Install Base (IB), Service Contracts, Order Management (OM), XML Reports, Oracle 10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting

Confidential

Oracle Applications Technical Consultant

Responsibilities:

  • Migration of HR Data Using Standard API’s
  • Involved in importing bank statement information into Cash Management table, to enable teh Bank Auto-reconciliation process.
  • Developed plug-in payroll formulas which calculate teh custom requirement logic and re-used as teh formula in SQL scripts and Discoverer reports.
  • Customization of reports in RDF, and XML Publisher for Business Documents.
  • Developed HRMS Letter Generation Reports (Templates)
  • Developed Cash forecasting custom reports in Cash Management based on teh requirements.
  • Developed Delimiter Report for Fixed Assets data (Convert into Excel Format )
  • Involved in fixing Oracle (Custom) forms Issues in Purchasing Responsibility.
  • Involved in feasible analysis for PO approval (POAPPRV) Standard workflow as per business requirement.
  • Developed and Customization of new reports in Purchasing and Fixed Assets as per Client Requirement
  • Responsible for moving code to teh production.
  • System Integration Testing(SIT)and Sanity checking
  • Preparation of technical design documents, Unit test scripts and Installation documents.

Environment: Oracle Applications R11 – HRMS, Cash Management (CM), Fixed Assets (FA), Purchasing (PO),RDF and XML Reports, Discoverer Reports, Oracle 9i/10g, SQL, PL/SQL, MS Tools, Oracle API’s

Confidential, Surat, GJ, IN

Oracle Applications Technical Consultant

Responsibilities:

  • Involved in developing of all teh Stores Ledger Reports (Oracle reports) belonging to teh three different Sites.
  • Developed Invoice Reports (Pre-printed Invoice)
  • Customized Purchase order (line locations) seeded form as per teh customer requirement.
  • Involved in Developing Various OPM Inventory Reports- REP Reports
  • Customization and Developing of reports in Purchasing and Accounts Payables, Inventory and OPM Inventory as per Requirement.
  • Developed SQL Script to extract comma separated file of applied receipts
  • Developed PL/SQL script to release AP invoice holds when corresponding AR invoice is cleared.
  • Customized standard Oracle Consolidated Billing Invoice Report wif additional IND specific field changes and tax logic.
  • Developed AR Transaction Interface which validates transaction information and loads teh transaction into AR seeded tables.
  • Developed PL/SQL Stored Procedure Executable Reports.

Environment: Oracle Applications R11- OPM Inventory (OPM), Account Receivables (AR), Purchasing (PO), Account Payables (AP), Oracle Reports, Oracle 9i/10g, SQL, PL/SQL, Data Loader

Hire Now