Oracle EBS Techno-Functional Consultant / Onsite Project Lead Resume Cincinnati, OH - Hire IT People

SUMMARY

Techno Functional Oracle EBS Consultant / Project Lead
Oracle Techno - Functional Consultant - primary expertise on Finance modules (GL, AR, AP) and good understanding of INV, PO, and OM modules. Project Lead for implementation in GE. 16 years of total IT experience, of which 7+ years in Oracle EBS. Excellent track record managing complex IT projects at customer Confidential . Extensive experience customizing Oracle E-Business Suite.
Six Sigma Green Belt Certified. Received GE Star Awards and Valuable Contribution Awards for outstanding performance working with General Electric. Recognized Project Management skills in leading large ERP implementation teams of diverse skills, motivating and grooming team members, managing stakeholders and driving projects to successful implementation.

TECHNICAL SKILLS

Oracle E-Business Suite. Expert: GL, AR, AP. Proficient INV, PO, OM

Databases: Oracle 10g, Mainframe IDMS, DB2

Software: PL/SQL, Oracle Forms/ Reports, SQL, SQL Loader, Appworx, COBOL, JCL, VSAM, CA7, CICS

OS: HP-UX Unix, Mainframe MVS

PM Tools: HP Quality Center, MS Project, MS Office, Visual Safe Source

SDLC Methods: Waterfall, Agile Estimation Methods Function Point (FP), WBS

PROFESSIONAL EXPERIENCE

Oracle EBS Techno-Functional Consultant / Onsite Project Lead

Confidential, Cincinnati, OH

Responsibilities:

Create AIM documents customized as per GE standards - business requirements (BR.150), business processes (BP.080), Gap fit analysis, functional / technical design (MD.050, MD.070).
Integrate GE’s item configuration tool (e-BOM) with ERP.
Integrate GE’s Purchasing and Manufacturing legacy systems with PO module in Oracle EBS.
Integrate GE’s Cost Management system with Oracle EBS costing process.
Shipment & invoice integration with US Govt. system - Wide Area Work Flow (WAWF).
Design Advance Pay functionality.
AFF modification prior to Auto-Invoicing.
COGS Workflow customization.

Environment: Oracle EBS R12, Oracle 10g, PL/SQL, SQL Loader, UC4 Application Manager

Oracle EBS Techno-Functional Consultant / Onsite Project Lead

Confidential Cincinnati, OH

Responsibilities:

Create MD.050, MD.070 - and CV.060, CV.070 for Data Conversions
Architect of RSP module. RSP interfaces with AR to calculate revenue share, with OM to get order / pricing details, with INV to maintain virtual consigned inventory, with GL to post JE, and with AR Collections to verify payment.
Create AOL objects - functions, menus, concurrent programs, request groups & responsibilities
Concurrent program (PL/SQL) to extract order & invoice details into RSP
Calculate Revenue Sharing amount and interface JE to GL (interface, import & post)
Interface invoices to Global OU for Collections and track customer payment
Batch process to create Sourcing Rule & Assignment for RSP supplier parts
Update Frozen Cost of RSP suppliers’ parts; update RSP cost type with liability amount.
Data Conversion: Develop SQL Loader, PL/SQL to validate and load data to core tables
Scheduling concurrent programs using UC4 Application Manager / AppWorx
Project Status reporting, Technical reviews, System Integration Testing, UAT, Warranty Support

Environment: Oracle EBS 11.5.10.2, Oracle 10g, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, SQL Loader, UC4 Application Manager / AppWorx.

Oracle EBS Techno-Functional Consultant / Onsite Project Lead Received GE Star Award

Confidential, Cincinnati, OH

Responsibilities:

Create MD.070 for extensions and new Forms. CV.060, CV.070 for Data Conversions
Create AOL objects - functions, menus, concurrent programs, request groups & responsibilities
Develop PL/SQL objects (called from Forms) to create/maintain RSP supplier agreements
Extract order & invoice details into RSP and calculate revenue share amount
Book journal entries from RSP sub-ledger to GL using GL Interface
Design & develop code to sync up Oracle Inventory with RSP Virtual Inventory
Design & develop code to create & modify Sourcing Rule & Assignment for RSP supplier parts
Data Conversion: loader and conversion programs
Scheduling concurrent programs using UC4 Application Manager / AppWorx
Project Leader responsibilities

Environment: Oracle EBS 11.5.10.2, Oracle 10g, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, SQL Loader, UC4 Application Manager / AppWorx.

Oracle EBS Technical Consultant / Onsite Project Lead

Confidential, Cincinnati, OH

Responsibilities:

Create MD.050 and MD.070 for interfaces with legacy applications
Data mapping between source and target applications
Error handling & handshake mechanism between EBS and legacy applications / Datawarehouse.
Create views in Oracle EBS for outbound interfaces to Data Warehouse
Extensively worked with Informatica team to design and develop interfaces
ERP cutover planning and execution for 18 legacy applications
Receive warranty claims from legacy system and create credit memos in Oracle AR
Project Leader responsibilities

Environment: Oracle EBS 11.5.10.2, Oracle 10g, PL/SQL, SQL Loader, UC4 Application Manager / AppWorx, Mainframe: MVS Cobol, JCL, VSAM, IDMS DB, CA7.

We provide IT Staff Augmentation Services!

Oracle Ebs Techno-functional Consultant / Onsite Project Lead Resume

Cincinnati, OH

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship