We provide IT Staff Augmentation Services!

Oracle Consultant Resume

3.00/5 (Submit Your Rating)

Houston, TX

SUMMARY

  • Extensive experience with 10 years in manufacturing domain & IT sector, combined with solid problem - solving and quality improvement expertise. Successful in identifying and implementing strategies to reduce cost, increase revenue, improve business practices and drive profitable growth.
  • Good understanding of business process operations, organizational assessment and translating them into functional requirements
  • Strong experience in all Oracle Manufacturing and Distribution modules and integrations across modules as well along with strong hands on experience on Advanced Supply Chain Planning
  • Extensive knowledge on Inventory Controls, Order to Cash (O2C) & Procure to Pay (P2P) cycles
  • Expertise in business process analysis, requirement analysis (AS-IS) system, (TO-BE) mapping, CRP testing, Integration testing, UAT, system configuration, data conversions, master data loading, Go-live support, Post-Production Support
  • Understanding of all phases of ERP implementation such as business process study, business requirement gathering, gap analysis with respect To-Be solution design, development and testing, cut over, Go-Live and post production support
  • Functional expertise in Order Management (OM), Inventory (INV), Purchasing (PO), iProcurement (iProc), Bill of Materials(BOM), Work in Process(WIP), Advanced Supply Chain Planning(ASCP)
  • Excellent problem solving, communication, analytical, interpersonal & leadership skills
  • Expertise in Writing, Maintaining, Test Results and Generating software defects reports for the developers
  • Worked closely with business users to understand the business processes and prepare the business requirements definition documents
  • Expertise in implementing the projects and performing thorough testing during the User Acceptance phase of the project
  • Worked in cross functional environment, in groups and individually with minimum supervision
  • Used Application Implementation Methodology (AIM) for documentation purposes
  • Experience in using tools such as Data loader, SQL Develeper, Web ADI, and EXCEL for importing and exporting data
  • Experience interacting with customers at multiple levels in a variety of Industries & Business segments
  • Experience at providing On-site and Off-shore model consulting and support services to Global clients in different geographies. Worked closely with Oracle Technical support on all high prioritized open SR’s and conduct OWC sessions for speedy resolution of issues
  • Domain Industry Experience and exposure to different functions of the Manufacturing Industry.

AREAS OF EXPERTISE

  • Inventory
  • Advanced Supply Chain Planning
  • Work In-Process
  • Purchasing
  • Order Management
  • Bills of Material
  • Engineering
  • WMS
  • MES

TECHNICAL SKILLS

Oracle Modules: Inventory, Purchasing, ASCP, Order Management, WIP,BOM, ENG, iSupplier, PL/SQL, Data Loader, MS Office Suite

Good knowledge on usage of Minitab & MS applications: MS Projects, MS Visio, Critical Path Method (CPM), PERT Analysis, 7QC tools and Free-mind application for project tracking Visited USA four times prior to H1B to attend trainings and render support on New Projects.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Oracle Consultant

Responsibilities:

  • Provided excellent Go-Live & Post Go live support for new organizations in Multiple OUs
  • Extensively worked and resolved the issues on all SCM/MFG Modules and Work Flows (Requisition, Purchase Order, RMA Order, Sales Orders, Drop Ship Order)
  • Resolved the critical issues on ASCP Collections and Planning, Shipping Execution while Ship Confirming the Sales Order.
  • Worked and fixed the root cause problems in BOM,WIP,INV,PO, Depot Repair, MES modules
  • Analyzing the issues and finding out the root cause of the problem to get a permanent fix for the issues in various applications
  • Replicating the critical issues in Test instances to fix the problem in PROD instance
  • Resolving the issues on Pending Transactions as part for Period Close activity from various applications.
  • Maintained AIM documents like BR110, BR100, BR150,MD50 and TE40
  • Worked on making Test scripts and performed testing procedures for various Oracle Application modules like Inventory, WIP, Purchasing & Order Management
  • Implementation of Inventory, WIP, BOM, ENG Modules
  • Conducted CRP (Conference Room Pilots) and documented the results to ensure that the business processes were defined for all major business processes and could be performed successfully using oracle Applications
  • Tested the functionalities as per the client requirements
  • Performed bug checking and logging and followed up the TAR resolution process
  • Trained end users on Inventory and Order Management modules and provided user guide
  • Lead RT team for Release Regression testing and Regression testing for Production change management.
  • Patch Impact analysis for all patches going into production
  • Performed SIT & UAT as part of Regression Testing
  • Issue resolution on daily basis thru Incidents reported by business users and third parties
  • Lead project from onsite as SPOC for all issues and co-ordinated with offshore associates on bug-fixing, development
  • Weekly status reporting meetings with Client Instance Managers along with Internal Project/Delivery Managers.
  • Collaborating with Automation testing team and providing them step by step functional process instructions on each module for Automation script preparation though Application Lifecycle Management and Panaya.

Confidential

Planning Engineer

Responsibilities:

  • Responsible for executing Material Planning through Oracle Advanced Supply chain Planning and OTD of the end product
  • Coordinated with contract manufacturers and global planning team providing rolling forecast
  • Creating IR, ISOs for all inter-company transactions
  • Creating Purchase orders and Internal Requisitions, Work orders and Inventory Transactions as part of shared service team
  • Maintain a record of open orders, supplier shipments and demand/supply and report it to Master Production Scheduler for any discrepancies
  • Studied and analyzed the current business process and was part of business requirement meetings
  • Defined items, item status, item attributes and generated serial numbers and locators
  • Planning and Releasing of work orders for manufacturing on regular basis.
  • Collaboratively work with all functional departments on regular basis for business issues and process developments.
  • Involved in planning and execution of CRP's
  • Creation of Work Orders and take to Closure once production builds completed.
  • Creation and Maintenance of Bills of Material through Engineering change process.
  • Inventory planning through Min-Max
  • Creation & Maintenance of sub inventories, stock locators & setup shipping networks
  • Performed Cycle Counts and Physical Inventory for Inventory Accuracy
  • Co-ordination with other Functional department to ensure smoother run of assembly lines
  • Defined items, item status, item attributes and generated serial numbers and locators
  • Maintaining Quality standards as per ISO TS16949 Technical specification.
  • Involvement in Production part approval process and maintain zero defects.
  • Implementation of 5S for continuous improvement of process
  • Work with Engineering team for Prototype build, testing until Manufacturing build and shipment
  • Involvement in UAT & Go Live production acceptance test.
  • Performed inventory setups like inventory organization, locations, item parameters and replenishment planning
  • Setting up of complete order cycle setups from order entry in order management to ship confirm in shipping execution

Confidential

Group Leader

Responsibilities:

  • Production planning and execution of day to day Production targets for each assembly line in manufacturing Shopfloor
  • Perform physical inventory and cycle counting
  • Maintain Quality Standards as per ISO 9001.
  • Ensure day to day transactions are performed in Oracle.
  • Ensure Oracle transactions like WIP Issue, WIP Completion, return & Move orders are in In sync with Manufacturing execution
  • Co-ordination with other functional department for One time manufacturing, shipment & delivery with right quality of product
  • Perform Internal Quality & 5s Audits on specified days
  • Work with all production supervisors for status update and execution of plan as per customer requirement.

Confidential

Quality Technician

Responsibilities:

  • Worked in Quality Department as Quality Inspector for In-process Quality checks
  • Perform Production Part Approval Process (PAPP)for new released engineering materials
  • Quality Audits based Quality Matrix on specified days at each level of quality execution
  • Sampling Inspection of parts been produced on everyday basis and decide the product acceptance based on Tolerance limit set.

We'd love your feedback!