SUMMARY:

Seeking a position with a progressive organization where I can use my technical and functional knowledge to enhance and simplify day to day business operations by utilizing information technology

TECHNICAL SKILLS:

Oracle Standard Processes: Order to Cash (OTC)

Subject Matter Expert: Procure to Pay (P2P)

Subject Matter Expert: Advanced Pricing

High familiarity and hands on experience: ERP Oracle Application Modules

Oracle Procurement: Oracle Purchasing (PO)

Oracle Supply Chain: Order Management (ONT), Bills of Materials (BOM), Work in Process (WIP)

Oracle Manufacturing: Inventory (IM)

Oracle Financials: Cash Management (CM), Accounts Payable (AP), Accounts Receivable (AR),General Ledger (GL), Fixed Assets (FA)

Other: Alert (ALR), Web ADI (BNE), Application Object Library (FND)

Oracle Applications: R12, 11i

Oracle Databases: 11g, 10g

Middleware: Oracle Application Server

Programming Languages: SQL, PL/SQL, Unix, XML

Operating Systems: Linux, Windows (7, XP, 2000)

Version control tools: PVCS, SVN, Clear Case, Change Man

SAS applications: Concur, Mercury Gate Transportation Management

Project Management Tools: Microsoft Project, Microsoft Project Server, Microsoft Share Point

Development Tools: BI (XML) Publisher, Oracle Discoverer 10g, Oracle Reports 6i/9i, Adobe Captivate, MS Office Suite (Excel, Word, Power Point, Visio), Toad, SQL Navigator, Notepad++

PROFESSIONAL EXPERIENCE:

Oracle EBS Consultant

Confidential, Mt Laurel NJ

Responsibilities:

• Serve as a techno - functional lead responsible for requirement gathering and suggesting technical solutions
• Extend EBS standard and custom functionality using custom and standard APIs, Alerts, Business Events and Oracle Form Personalization
• Extend seeded workflows and develop new workflows
• Work with offshore development team to develop and test technical solutions
• Evaluate and improve business processes
• Perform production set ups (profiles, transaction types, subinventories, organizations, account aliases, item categories, KFFs, DFFs, BOMs, Oracle Advanced pricing qualifiers and modifiers)
• Support day-to-day production environment (Oracle supply chain modules and Oracle Financial Modules)
• Designed and developed automated discrete jobs custom process
• This automated process takes manually created discrete job and after performing various validations pick releases the components required to build the requested item. XML file is generated and Ftp’d to one of the 3PLs. The processes receives and processes discrete job updates and appropriately updates quantities of items that have been build and have gone through discrete manufacturing process
• Developed retest cylinder process
• This process moves cylinders that have been shipped to Israel for retesting to a retest sub-inventory. During the move, the retest cylinder item is split into its components. Upon receipt of test cylinders back from Israel, a business event is triggered that scraps certain components and moves the other components into appropriate sub-inventory. An automated email is generated to notify Department of Finance of the quantity and items scrapped
• Perform various Work Flow customizations and updates of order processing to support business order flow utilizing Workflow Builder (Order minimum amount validation, Price doesn’t match price list validation)
• Performed set ups of Employees, Jobs, Positions, Positional hierarchies, Approval Groups and Approval Assignments
• Set up and tested drop ship process for international orders (US to Mexico) and for orders originating from Israel to US retailers. Process and testing included:
• Items definition changes, Sourcing Rules creation, Sales Order Creation, Requisition Import, Purchase Order creation via Auto Create, Purchase Order approval, Inventory Receipt into virtual inventory organization, Auto Invoice
• Developed financial and logistics reports utilizing BI (XML) Publisher and Discoverer Reports
• Personalized variety of Oracle Forms (Order Header Form, Order Lines Form, Discrete Jobs Form)
• Set up variety of modifiers and qualifiers in Oracle’s Advance Pricing module to support product specials and customer contractual discounts
• Performed set up and testing of new inventory organizations
• Assisted Finance and Logistics departments during month end close

Senior Systems Analyst

Confidential, Philadelphia PA

Responsibilities:

• Work with stake holders and business users to gather detailed requirements
• Interact with all levels of Oracle Financial E-Business Suite client base to resolve issues and develop innovative solutions
• Support Oracle Financial Application suite (GL, AP, FA, PO and IP)
• Perform set up and testing of new GL feeders
• Design and develop functional specifications and suggest technical solutions
• Work on tuning queries for better performance
• Interact with Oracle support via Oracle Support as needed

Senior Software Engineer

Confidential, Moorestown NJ

Responsibilities:

• Performed systems modeling
• Added code customizations to existing DOD AEGIS system based on the specs provided by the NAVY
• Developed and presented custom workflow for given specification for approval
• Designed unit tests of complex software systems
• Reviewed completion and implementation of technical products

Senior Programmer/Analyst

Confidential, Cherry Hill NJ

Responsibilities:

• Gathered business requirements and created detailed functional and technical specification documentation using Oracle AIM methodology
• Automated order processing of SNE and SDC (Subaru’s Independent Distributors) orders via OM Order import
• Designed and developed Oracle e-Business customizations
• Defined inventory item templates
• Performed conversion of master inventory items and item categories via Oracle open interface during 11i upgrade
• Designed and developed a process for new inventory item creation and template application
• Worked on adding additional steps to order workflow in OM utilizing Oracle workflow builder
• Developed Discoverer 10g reports to compare warehouse inventory in Red Prairie with Oracle inventory
• Provided day to day production support of critical Oracle e-Business systems
• Interacted with Oracle Support Services through Oracle Support to resolve urgent issues
• Coordinated code migrations between different environments (i.e., Development, QA, and Production)
• Designed, developed and deployed training videos for Subaru dealerships utilizing Adobe Captivate

Cost Center Manager

Confidential, Paulsboro NJ

Responsibilities:

• Developed and enforced cost center policies in order to minimize shrink
• Negotiated contracts with local suppliers
• Supervised and trained 15-20 employees
• Evaluated and analyzed local market demand for various products
• Optimized employee labor scheduling based on the sales volume
• Evaluated employees’ performance on annual basis. Suggested areas of improvement and offered training when and where appropriate
• Placed purchase orders with corporate suppliers based on lead times
• Occasionally received and inspected ordered merchandise that met certain criteria (high end, expensive items)
• At the end of the month performed financial month close and forwarded the reports to the accounting department
• Performed quarterly inventory counts and reconciliations
• Assisted in annual inventory counts by an outside organization