SUMMARY:

• Oracle Partner Network certified professional in technical and functional aspects with more than 10 Yrs. of IT Experience as a consultant for JD Edwards One World Xe, Oracle JD Edwards EnterpriseOne 8.11, 8.12, 9.0, 9.1, 9.2 backed up with exceptional communication and literacy skills.
• Expert in JD Edwards EnterpriseOne reports, applications, table conversions.
• Debugging/Customization/New Development of Interactive & Batch Applications.
• Testing & Debugging C Business Functions (C BSFN).
• Performance Work bench to fine tune UBE performance
• Experienced in converting Functional Design Document/Specification into Technical Design Document/Specification for Objects development, EDI, Z - Table Interfaces, Flat File Conversion, SOA Integration using EDF, ETL Integration, ESU analysis
• Business Services (BSSV) Development
• BI Publisher Development
• Create form Support

SKILL:

Programming Languages: C, C++, Basic Java

ERP: Oracle JD Edwards OneWorld Xe, EnterpriseOne ., 9.0, 9.1, 9.2 and Lawson case 4GL

Database: Microsoft Access, Oracle 11g., DB2/400

Other Tools: Ticketing tools Remedy, HP Quality Center, Dell KACE, SoapUIJDeveloper, Desktop BI, SQL Developer, Create Form Designer & Director

FUNCTIONAL SKILLS:

• Distribution and Logistics
• Procurement and Sales processes
• Requisition Process
• Approval Setups & Routing to specific departments of Ops & Finance
• Procure to pay and Order to cash
• EDI Purchase Order Processing
• Address Book, Customer Master, Inventory Management etc.
• Knowledgeable in Manufacturing Module for Work Order Management including Work Order Creation, Parts List creation and related BOM etc
• Prepare process oriented documentation, change control for quality standards.
• HPQC - HP Quality Center for testing and running test scripts.
• Ticketing tools Remedy and KACE.
• Microsoft Excel Macros.
• Oracle SQL Developer.
• Ability to read RPG Programming and Scheduler to setup automatic Jobs using CL Language
• Knowledgeable in DSI related running scripts like Shipment Confirmation, PO Receipts, Cycle Counting using dcLink

PROFESSIONAL EXPERIENCE:

Confidential

IT Business and Systems Analyst

Responsibilities:

• Analyzes and documents relevant business processes.
• Participates in interviews with customers to define requirements.
• Defines, documents and reviews functional requirements.
• Conducts gap analysis.
• Owns the Integration Testing process, including development of test plans, test cases and scenarios and documentation of results
• Responsible for ensuring that application meets functionality requirements and expected business benefits.
• Responsible for all facets of the User Acceptance Testing & signoff process.
• Prepares and/or reviews end user documentation, materials, curriculum and schedule.
• Conducts classes
• Provides first line post implementation support to users regarding functional issues.
• Engages all relevant participants in change management activities, where appropriate.
• Monitors the daily operational activities of systems and provides support to users.
• Takes ownership of functional issues by identifying underlying problems, analyzing potential solutions and implementing system resolutions, including workarounds.
• Addresses and/or escalates issues in a timely fashion.
• Applies department change control policies & procedures.
• Coordinates with other IT departments on integrated system support.
• Logs, tracks and prioritizes system issues.
• Is responsible for quality, accurate, and timely deliverables to internal/external customers.
• Works as a member of a cross-functional, integrated team.
• Communicates plans, status and issues to management on a regular basis.
• Adheres to and enforces department standards, policies, procedures and industry best practices.

Confidential, Westlake, CA

JDE Implementation and Support

Responsibilities:

• Worked on Procurement, Manufacturing Module and a custom interface built called APDS (Applied Plasma Disposition) - Selection of Disposition Bin Lots to Teardown Work Order, Forwarding Container Quantity from JDE to EBM as a lead design consultant.
• Part of business team to improve performance, defect testing and system monitoring.
• Worked with business users to analyze, resolve performance issues and application/report level errors.
• Supported all issues from Purchase Orders, Work Orders etc.
• Supported all BI issues.
• Worked on trouble shooting and bug fixes Custom Interfaces like APDS that interact with Confidential E1 via AIP Middleware and Integration.
• Provided post Implementation support for all enhancements, Bug fixes etc.
• Defect/Bug Identification: Tested applications and created defects and enhancement requests. Followed by testing and promotion of the fixes to production.
• Quality Control: Executed all the emergency/planned SQL’s via a documented quality process called change controls, which are discussed among all business heads to assess the impact. All the changes were documented and upload in SharePoint tool.
• Test scripts: Created and rationalized test scripts to automate the testing process. The test scripts consisted detailed steps including menu paths and data.
• Documented and shared all the business process via SharePoint for common use, along with steps to resolve the common issues
• Trained and mentored peers and offshore resources, cross self in Manufacturing.
• Functional requirement analysis.
• Preparation of Technical Design and technical specifications.
• Preparing Unit test cases based on Functional requirement analysis.
• Development, Customization, Testing of objects in all major JDE Modules.
• Prepared quality documents like trace matrix to match functional requirements with technical specifications.
• Prepared check lists to ensure technical specifications and unit test cases standards.
• Developed custom applications for Purchase order Print, Master Batch Record Report (For Multiple Branch Plants) and other applications.
• Designed and developed Business Functions for Media Object Extraction from E1 to external system, APDS related interface business functions. Modified Master Business functions like B4200311 to override the Location of the Branch Plant instead of assigning from Branch Plant Constants.
• Designed and developed BI Reports for MBR, Purchase Order prints for multiple branches, Shipment discrepancy reports (Received, Not-Received Orders).
• Modified Vocabulary Overrides to suit the User needs

Confidential, Jacksonville, FL

JDE Implementation and Support

Responsibilities:

• Worked on the Data Migration Project to migrate from Old System to New
• Part of Business Team to assess all the requirements and convert into Functional Design.
• Analyzed, Developed and Supported Interfaces like OSI Pi Interface, ADP Interface, EDI Interface for Procurement, AP Workflow, Bank Interfaces like ACH, Concur, Exchange rates etc
• Inventory Updates and Analysis of GL Class codes, UOM, Substitute items, Supplier Level Item Costs, U-Type Items etc.
• Supported all issues related to Procurement, Finance, Inventory, Interfaces etc.
• Prepared process documents like Requisition & PO Approvals, Rejections etc.
• Manage and Monitor Object Reservations for record locks
• Monitor Scheduler Jobs and during down time need to manage single and Multi-threaded queues
• Supported Security related issues with the User Roles like conflicting User Roles, User accessibility to specific application/reports in Menus
• Created E1 User Profiles and assigned User Roles
• Created Menus, Tasks for the confined User Groups
• Functional requirement analysis
• Preparation of Technical Design and technical specifications.
• Preparing Unit test cases based on Functional requirement analysis.
• Development, Customization, Testing of objects in all major JDE Modules.
• Prepared quality documents like Review Checklist, Trace Matrix, and Unit Test Scripts to match functional requirements with technical specifications.
• Prepared check lists to ensure technical specifications and unit test cases standards.
• Monitor and Manage tickets in Dell KACE tool for quick response and resolution adhering to SLAs.
• Analyzed ESUs like Cancelled Requisitions (Need to fix Orders Awaiting Approval Form P43081 if remove message is clicked should not delete the Requisition from Requisition Header File (F4301), Voucher Reversal/Void Voucher etc
• Developed Custom Depreciation Schedule Report to show Asset Information like Remaining Life of Asset, Equipment Class, tax Entity, Prior/Current Period Cost, Prior/Current Period Accumulated Depreciation etc., PO Print Report etc
• Knowledge in creating One View Reporting (OVR) Profiles and User specific OVR Reports
• ACH related interface issues like Header Record is populating incorrectly with Bank Transit Number from Bank Transit File (F0030) on the report R04572T2 (Create A/P Bank Tape - CTX format)
• Used SQL Developer tool to run SQL Queries
• Supported E1 Mobility for Requisition and PO Approvals
• Retrofit all Objects from 8.12 to E9.1
• Retrofit Object types of Standard Objects, Standard Modified Objects, Copy Standard Objects, Custom Objects
• Requirement gathering for new Custom Objects like UBEs, Forms, Business Function, preparing Functional and Technical Design Document.
• Develop, unit test the code and manage all the cycle till object promoted to Production
• Post Upgrade Implementation support, analyze issues, bug fixes etc
• Implementation of Custom E1 9.1 Objects
• Requirement gathering
• Meet with business users to understand issues and new enhancements
• Design and Development
• Designed and Developed Applications, Reports, Menus for new enhancements like
• Change Location in Work Order Parts List (P3111)
• Print barcode Label (Sterile and Non-Sterile Items)
• Custom Forms created for Labor Reporting (Copy P311221 - Review Labor Hours), Sterile Load Tracking (Add/Remove Pallet to Load)
• Generate Lot Serial Number Application
• IQC Interface for PO Receipts Extraction
• ACH Standard Report Copy of R04572T1 to record an entry in F04572OW (From F04572, F04573) for AP Automatic Payments
• Custom PO Receipts Form (Copy of P4312)
• Custom Batch Job Configuration Application, Custom UBEs EDI Product Activity Data Extraction, Inventory Adjustment Sales Orders, Batch Job Master Report
• Testing:
• Prepared test scripts
• Tested E1 applications in TR and OQ and completed UAT
• Product support
• Support all E1 New Enhancements and analyze, test and bug fix