We provide IT Staff Augmentation Services!

Systems Analyst Resume Profile

2.00/5 (Submit Your Rating)

QUALIFICATION SUMMARY:

  • Over 15 years of ERP experience with 10 years as lead functional analyst with multiple Oracle functional modules Release 12.3, R12 and 11i with 4 successful go lives upgrades.
  • Extensive experience heavy hands on in new implementation Conception to implement , oracle applications upgrades, mergers acquisitions, process improvements, have successfully implemented numerous interfaces between Oracle applications and other third party / legacy systems.
  • Extensive experience in Purchasing: Supplier Master, Standard, blanket, planned contract purchase orders, Requisitions, iSupplier, RMA receipts, Drop Shipment logical receipt, Receipt Accounting, , ASL, Sourcing rules, internal sales order creation process, Receiving open interface ROI , ASN process purchase order workflow technologies
  • Extensive experience in Order management - Sales orders, Blanket sales agreements, Advanced Pricing, Order Import, Scheduling, ATP, Price Lists, Multi Currency Conversions, Pricing Agreements, Multi-Org Setup, Modifiers, Pick Release, Shipping, WMS Rules engine for shipping, WIP and receiving, Interface trip stop program, workflow background engine program, AR Auto Create Invoice program.
  • Expertise in Order Management processes - Standard Order, RMA Return, Internal Order, Drop Ship, Order Import, Requisition Import processes, Intercompany ISO Invoicing process, Uses of several OM workflows association to transaction types at header and line level.
  • Extensive experience in Warehouse Management / inventory inventory organization setups, Put away rules, strategies, picking direct ship, it, LPN management, user defined transactions. Write up procedures for identifying resolving struck transactions, month-end closing, cycle counting physical inventory
  • Several years of experience in planning Advanced supply chain planning ASCP , Distribution planning DRP , Min-Max planning with buyer notification.
  • Extensive experience in several financial cost accounting models Standard, Average, FIFO LIFO. Understanding of Cost Management Events WMS/Inventory, Purchasing, Receiving, Costing and WIP , and Create Accounting Program, Deferred Cogs and Revenue concepts.
  • Experience in mergers acquisitions identifying open interfaces for importing items, transactions, purchase orders, financial transactions, documenting AS-IS TO-BE process flows.
  • Implemented Discrete Inventory BOM, WIP associated cost accounting. Experience with setting up quality module for qualification skip lot functionality.

ERP INDUSTRY EXPERIENCE:

Hollander Home Fashions

April 2012 Current Oracle Discrete Manufacturing Boca Raton, FL

Project: Discrete Manufacturing and Supply Chain Rel 12.1.3.8 Re-Implementation

Position: Oracle Supply Chain Solution Architect

  • Hollander has 7 plants in USA, China Canada manufacturing pillows, comforters other bedding products. Conduct interview with inventory managers, plant managers, directors finance controller to identify all pain points write up business requirements identify process improvements in areas of Planning, Purchasing, Receiving shipping.
  • Designed warehouse management system for Inventory, Receiving ASN, LPN Labels, ICT etc , Work in process Shipping. Setup of several put away rules strategies for receiving. Implement several process changes to minimize scans during Put Away process with WMS forms personalization.
  • Designed supply chain solution for WMS receiving, Manufacturing work with consultants on distribution planning Manufacturing planning.
  • Major process improvement in recommending use of E-Commerce gateway over custom EDI processing with suppliers in China /India / Pakistan freight forwarders.
  • Supply chain solution also includes providing collaboration platform with Big box retailers like Walmart, Costco etc.
  • Identify areas of data cleanup that would impede the new solution provide guidelines for business to accomplish clear such transactions on a ongoing basis.

WORLD FUEL SERVICES

Confidential

Position: Sr. Oracle Functional supply chain

  • WFS acquired four different Lubricant warehouses having their custom home grown applications for warehouse management, supply chain financial functions.
  • Study each of these companies legacy business, gather write up requirements. Map business processes to oracle processes for procure to pay Order to cash, identify gaps.
  • Design solution lead in conducting CRP with various business teams, recommend minor business process changes to fit into standard oracle process thereby minimize customizations.
  • Designed Solution for business process- importing items, categories, purchasing, supplier pricelist, receiving, customer order fulfillment sales out of inventory, drop ship model for third party, average costing FIFO associated AP AR invoicing.
  • Provide solution for blending of two or more fuels to derive certain lubes by setting up Bill of Materials discrete jobs.

Confidential

Position: Sr. Oracle Functional supply chain

  • World acquired several UK fuel terminals. These operations were managed on several complex spread sheets home built software.
  • Project goals were to integrate these operations Supply chain all accounting into WFS system of records maintained in Oracle. Since, commodity are always hedged with Swap other derivatives, provide cost accounting for baking in profit / loss realized into the cost of fuel. Challenges included using Oracle Average costing allowing inventory to go negative as business would borrow fuel from counterparts.
  • Provided oracle solution to handle various deal types Order types by identifying and associating with different workflows under/over tolerance features to accurately invoice customer
  • o Various model include pay first collect later account for deferred revenue automate the process of recognizing revenue on actual order fulfillment,
  • o Create customer invoice on total shipped quantity reaching an over / under tolerance from the ordered quantity.
  • o Several other order types with minor variations
  • Define solution for automating sales order shipments with electronic feeds on the shipment information.

Confidential

Position: Sr. Oracle Functional lead supply chain

  • World fuel has three business segments: Land, Marine Aviation. Land segment had financials already on Oracle application. Project purpose was to get the business out of spread sheets in tracking their inventory associated cost accounting to Oracle application. US Land segments had multiple pipelines covering various parts of the nation.
  • Provide oracle solution to handle for inventory management of fuel for various pipeline, Average costing also accounting for hedge settlements to be baked into the average cost of the fuel.
  • Provide oracle solution for handling various deal types which include, but not limited to Inventory sales orders, Prepay a small percent, third party fulfilling sales orders use of several pricing lists.

Confidential

Position: Sr. Oracle Functional supply chain

  • WFS Aviation division relies on billing from various third parties which include FBO Fuel based operators operating in several countries in all continents. Due to enormous fuel tickets getting invoiced, there were about 2 of them that were not correct example: Price, quantity, location etc.
  • Project scope to provide a system for a credit re-bill process
  • Provide oracle solution to manage effective auditable credit re-bill system where the business used advanced collection to record a dispute the system allowing credit only for those with dispute several check balances. Defined various order types as it included different business models fuel coming from inventory, third party inventory customer owned inventory etc.
  • Provide solution for customer owned inventory where WFS would manage the inventory for several smaller airlines JET Blue, Southwest airlines etc ,

Confidential

Position: Oracle Developer to Oracle Solution Architect Supply Chain

Position: Oracle Solution Architect Supply Chain

  • ADT has about 200 sales service offices SSO across the country couple of distribution centers. SSO would use inventory for new install new customer , maintenance jobs.
  • Lead from conception to implementation on defining an automated system of automatically replenishing SSO inventory when it went under safety stock. Safety stock was based on a user defined formula based on a set of distribution accounts determining the type of install Commercial, residential or service etc. . Process would automatically create requisitions notify the defined distribution list for the SSO.

Confidential

Position: Oracle Supply Chain Lead

  • Review Oracle Patches for upgrade, Lead effort in identifying customization affected by patches in the areas of Supply Chain related costing.
  • Define testing strategy Assist QA team in writing QA scripts for end to end system integration testing for procure to Pay as well as order to cash process flows.
  • Lead in conducting system integration testing managing issues getting resolved.

Confidential

Position: Oracle Supply Chain Lead

  • ADT had about 200 sales service offices where they had excess inventory totally over 20 million, Project purpose was to bring all these to a centralized location use the existing distribution system to deplete the excess inventory on ADT books.
  • Designed solution to automate the process of using the excess inventory prior to ordering from external suppliers.
  • Lead in conducting user acceptance testing, system integration testing.

Confidential

Position: Oracle Solution Architect

  • Identify Functional Gaps in Oracle Application write technical requirements to meet the user requirements.
  • Lead from conception to implementation on rolling out Oracle inventory management for the 150 sales service offices. Define business process for ordering from distribution centers, receiving use of material for install service jobs. Service jobs using a custom application called mastermind project was to automate the depletion of inventory in oracle by creating interface with the custom application.
  • ADT had about 200 sales service offices who would order inventory from distribution centers. On shipping from distribution centers, the material was expensed out.
  • System Design for several new Perpetual inventory process including on how to handle NSI Non standard Items , Move orders etc.
  • Write functional specifications, manage 6 to 8 developers for the entire duration of the project.
  • Conduct several CRP System integration testing

Confidential

Position: Oracle Supply chain Analyst

  • Lead from conception to implementation on automating the process of ship confirm in oracle when UPS package is scanned on the UPS scale prior to pick up.
  • Design solution in identifying API that was used to automatically ship confirm when shipments were weighed using the delivery number / sales order as reference. This vastly improved productivity gains as it reduced the sales orders to be ship confirmed in oracle to the ones that User decided to back order a part of the picked orders.
  • Business had the ability to track the package on UPS website without logging out of Oracle.

Confidential

Position: Lead Developer

  • Document all existing customization identifying the each object, its type the high level functions of those objects. Review those that could be eliminated also those that were impacted by the upgrade.
  • Lead a team of 3 internal developers 6-8 technical consultants in rewrite of several custom objects due to high level change in the structure of Order Management related tables along with other architectural changes.
  • Responsible for ensuring all custom objects totalling over 200 performed their intended functionality.
  • Write up end to end system integration testing document that spanned the procure to pay order to cash, Cost accounting General ledger.

Confidential

Position: Oracle Developer

  • Part of team work with dozens of consultants in the area of supply chain visiting business users distribution in several states.
  • Take ownership of all customizations from technical consultants.
  • Design process for Mass load of Items, categories etc using standard oracle open interfaces.

Confidential

Position: Systems Analyst

Work on several main frame projects in the areas of procurement.

Confidential

Position: System Analyst

  • Assigned to work on purchasing, Inventory, order management HR areas. Work on reports customizations
  • Prepare BR100 configuration documents for Purchasing Inventory.
  • Work with consultant on conducting system Integration testing in the areas of PO, OM INV

Confidential

Position: IDMS/COBOL Consultant

  • Work on custom solution on IBM using IDMS / COBOL ADSO.
  • Work mostly on Inventory, Purchasing business areas associated accounting.
  • Work on several other Main frame projects

COMPUTER LITERACY

  • Business Applications: MS Office-MS Excel, MS Word, MS PowerPoint, MS Project and MS Visio
  • Knowledge and experience SQL SQL Plus, PL/SQL Programming, Oracle Reports, Oracle Forms Oracle Discoverer.

We'd love your feedback!