TECHNICAL SKILLS

Oracle skills: Oracle Applications R12 and 11i Modules OM, PO, AR, AP, INV, GL, Financials Accounting Hub (FAH), Fixed Assets, Cash Management, E - Business Tax (R12), CRM, Advanced Collections, iReceivables, Credit Management, Oracle Sales Online, Customers Online, Quoting, Incentive Compensation, Field Service, TeleService, Customer Support, Knowledge Management (Knowledge Base), iStore, Install Base, and Service Contracts, WIP, Oracle MDM, Product Data Hub (PDH), Customer Data Hub (CDH), Supplier Data Hub (SDH), TCA, Data Librarian, DQM (Data Quality Management), EDI/e-Commerce Gateway, Oracle Workflow and Workflow Builder, Oracle Approvals Management (AME), OA Framework, VPD (Virtual Private Data), Developer Suite 10g, Reports, Forms, XML Publisher/BI Publisher, ADI, Discoverer, AIM. Functional and Technical configurations. Develop and maintain packages, procedures, and triggers utilizing PL/SQL. Create and maintain DDL for tables, views, indexes, etc. SQL tuning. Oracle Web Toolkit. Integration with third-party software Optio, Vertex and Trillium.

Other languages/skills: Optio, Vertex, Trillium, Visual Basic, Visual Basic for Applications/Access development, SQL, HTML, UNIX script, EDI, and JavaScript.

Operating Systems: Linux, UNIX (Sun Solaris and IBM AIX), NT.

Computer software: specifically Oracle Applications, Oracle databases, PeopleSoft, Optio, Excel, Access, Word.

PROFESSIONAL EXPERIENCE:

Confidential, Versailles, OH

Independent consultant/Functional/Technical

Responsibilities:

• Designed and developed interfaces between Oracle HCM and Oracle HRMS using WebCenter
• Developed customized AR Customer Statements through BI Publisher, using bursting to fax/email/print the statements
• Upgraded ftp processes for both inbound and outbound POs
• Upgrade, customize, and tune multiple customized sales reports in BI Publisher

Confidential, Long Beach, CA

Technical Developer

Responsibilities:

• Designed and developed solution to integrate Oracle Cash Management/Treasury using interfaces to/from multiple banks

Confidential

Oracle eBusiness Suite Consultant

Responsibilities:

• Designed and developed inbound interfaces for BAI2, MT940, and MT535 transactions through SWIFT
• Designed and developed reports within BI Publisher for Forecasting and Positioning
• Modified the MT103 format using BI Publisher to meet SWIFT requirements
• Configured Oracle Payments to process Bank Account Transfers to SWIFT

Confidential, Nashville, TN

Functional and Technical/Consultant Oracle

Responsibilities:

• Designed TCA structure within a B2B environment
• Designed and developed the following programs:
• GL Journal Import Interface
• Customer Interface
• AR Invoice Interface
• AR Cash Application Chargeback Interface
• AR Statements
• AR Adjustments Interface
• AP Invoice Import Interface

Confidential, Bethesda, MD

Oracle Solution Architect

Responsibilities:

• Designed TCA customer structure to function within both CDH and Oracle eBusiness Suite.
• Performed all necessary configurations within CDH, including DQM rules for deduplication and duplicate prevention.
• Designed an integrated solution with CDH as the customer master, feeding and receiving customer data from Oracle Service Cloud, an in-house web procurement site, and a marketing database.

Confidential, Cleveland, OH

Functional/Technical Lead Oracle

Responsibilities:

• Re-design TCA structure to allow Confidential to effectively manage and use customer data that has been converted from multiple sources
• Architect solution for re-implementing TCA
• Design Advanced Collections solution and configure the module.
• Created a custom dunning letter for Advanced Collections using BI Publisher.

Confidential, Chicago, IL

Functional Lead/Technical Lead/Solution Architect/Data Architect

Responsibilities:

• Analyze requirements for customer data and design and configure TCA structure to meet client needs.
• Design and develop both inbound and outbound interfaces for PIM and CDH. Enqueing and dequeing XML messages and data files inbound/outbound between Oracle eBusiness Suite and SOA.
• Assist with configurations within PIM and Inventory.
• Design data structure to accommodate custom ordering system.
• Mentor and Lead team of developers in customizing PDH and CDH to meet business’ needs.

Oracle eBusiness Suite Consultant

Confidential, Wilmington, DE

Responsibilities:

• Designed, developed and configured 4 custom scoring engines
• Designed and configured 24 custom strategies
• Performed all configurations within Advanced Collections
• Designed custom interfacing and reporting and lead both onshore and offshore resources in completing development tasks for these interfaces and reports.

Confidential,Chicago, IL

Technical Lead/Developer

Responsibilities:

• Designed and Developed concurrent processes to clone, archive, and purge data from the XLA and GL schemas primarily for performance tuning purposes.

Confidential

Functional Lead/Data Architect

Responsibilities:

• Design TCA structure to accommodate business requirements and flows related to Oracle Receivables, Purchasing, Payable and CRM.
• Design strategy for integrating CDH (Customer Data Hub) and SDH (Supplier Data Hub) with 7 legacy systems
• Perform all necessary configurations within SDH/SLM and CDH

Confidential, Chicago, IL

Lead Oracle TCA Consultant

Responsibilities:

• Design complex Oracle TCA structure to accommodate multiple operating units integrating customer data within Oracle TCA
• Design and develop interface and conversion programs to create customer data within Oracle TCA
• Design and develop AR Cash Receipt transfer interface
• Support AR and Advanced Collections implementation

Confidential

Functional/Technical Resource

Responsibilities:

• Design and develop a complex program to convert units of measure for weight, volume, area and length for metal alloys
• Develop forms for maintaining Advanced Pricing data
• Develop BI Publisher reports for Project Accounting activities

Confidential, Boston, MA

Functional/Technical Resource

Responsibilities:

• Designed TCA Structure
• Perform configurations within AR, AP and HR foundation
• Design and develop conversions and interfaces for Customers, Employees, Vendors and Bank Accounts from Oracle 11i into Oracle R12.

Confidential, Austin, TX

Oracle Applications Consultant

Responsibilities:

• Customers and Contacts
• Analyze data from multiple legacy systems, analyze required customer data within Customer Support/TeleService, and design TCA structure to accommodate these requirements
• Roles and Responsibilities
• Analyze security required, and recommend solution utilizing VPD and customizations within OA Framework to achieve property security within the Customer Support html screens.
• Event-based Notifications
• Gathered requirements for sending notifications when certain events occur (e.g., Service Request status changes, notes added, etc) using Oracle Workflow
• Assets and Entitlements
• Analyzed requirements and designed solutions to allow for decrementing of resolution-based contracts for Install Base items listed in Service Contracts.
• Employees, Users, and Resources
• Design and develop interfaces for uploading Employees, Users, and Resources into Oracle

Confidential, Philadelphia, PA

Oracle Applications Consultant

Responsibilities:

• Oracle TCA
• Analyzed current TCA structure
• Gathered requirements for reporting within AR (including revenue reporting, aging, and invoicing)
• Analyzed TCA structure for current Sales Online implementation and expectations for the implementation of future CRM modules
• Implemented interfacing of D&B data into Oracle TCA
• Oracle Customers Online
• Gathered requirements for implementation, recommended solutions, assisted with drafting the BR100 configuration document, and assisted with the configurations during the implementation
• Oracle Receivables
• Restructured AR Invoice format, and provided all accompanying AR configurations
• Proof-of-Concept for installation of Vertex Q-Series Sales Tax

Confidential

Oracle Applications Consultant

Responsibilities:

• Designed and modified the seeded PO Account Generator workflow (POWFPOAG) to derive the Charge Account based upon Default Account ID assigned to the Buyer and the Category and item type of the line item
• Designed and modified the seeded Purchasing Approvals Workflow (POAPPRVL) to print a custom Purchase Order print program during the submission for approval.
• Standard Purchase Order conversion. Designed, developed, and tested conversion program to import PO Headers, Lines, and Distributions into staging tables, scrub the data, and import into standard interface tables.
• Payables Invoice conversion. Designed, developed, and tested conversion program to import AP Invoice Headers/Lines into staging tables, scrub data, and import into standard interface tables.

Confidential

Oracle Applications Consultant

Responsibilities:

• Gathered requirements, provided functional and technical expertise, finalized processes, and drafted Oracle Tutor and AIM (BR30 and BR100) documentation for the CRM modules Sales Online, Quoting, Incentive Compensation, iStore, Field Service, Service Contracts
• Lead technical and functional resource for Oracle Workflow. Developed and presented functional and technical Oracle Workflow for additional project resources.
• Assisted with design of TCA structure
• CRM track Conversion, Interface, and Extension Lead. I led and performed a portion of the design and development for the following deliverables:
• Field Service Request (Requests, Notes, Tasks, and Debriefs) conversion and interface
• Knowledge Base conversion
• CRM Resources conversion
• Territory Assignment conversion iStore Sales Assistance workflow
• Quoting Approval (Oracle Approvals Management)
• Service Request workflow
• Task Manager/Task Dispatch workflow
• Install Base workflow
• Quoting and iStore notification workflows

Confidential, Irvine, CA

Oracle Applications Consultant

Responsibilities:

• Custom AP Invoice Approval routing by using Oracle Workflow Builder to modify the AP Invoice Approval workflow process and configuring Approvals Management Engine (AME).
• Outbound interface that extracts item and vendor information from the Approved Supplier Lists.
• Outbound EDI 820 EFT payment file and EDI 850 PO extracts using e-Commerce Gateway.
• Custom Purchase Order and Requisition approval processes by modifying the delivered PO Approval workflow and PO Requisition Approval workflow processes, respectively.
• Customized the delivered FA Account Generator to derive the Asset level, Book level, and Category level accounts, according to the client’s requirements.
• Customized Order Management (OM) line workflows, providing flows that fit exactly within Toshiba’s sales order business model, including automated interfacing to AR and automated holds applied/released prior to Pick Release/Ship Confirm.
• Integrate Oracle Order Management with legacy order systems and inbound EDI 850 Purchase Orders, by creating common canonicals in webMethods and webMethods services to map and insert data to the Oracle OM OIT tables and execute the Order Import process.
• Configurations to implement Oracle Order Management and to integrate OM with Oracle Receivables and Oracle Purchasing (for Drop Ship order functionality).

Confidential, Austin, TX

Business Analysis/Oracle Financials

Responsibilities:

• Design, develop, and implement Oracle 11i Cash Management module. Set up and troubleshoot Bank Reconciliation process and related AP configurations. Analyze Oracle Cash Forecasting capabilities.
• Develop and test Oracle Sales Online/Sales Offline. Personalize appearance and profiles for OSO.
• Business analysis and gap analysis for the implementation of Oracle Business Intelligence System (BIS) utilizing Oracle Reports and Oracle Discoverer. Schedule required programs, configure performance targets, evaluate BIS reports, and customize Personal HomePage (PHP) for respective users.
• Draft project charters and perform cost-benefit analyses for Oracle Business Intelligence and custom Funding process flows.
• Business analysis and setup of Oracle HRMS, specifically HRMS benefits and self-service HRMS.

Confidential, Austin, TX

ERP Developer

Responsibilities:

• Functional configurations of PO, AP, AR, GL, FA, and INV modules during design and implementation phases.
• CRM using Oracle PL/SQL Web toolkit, HTML, and JavaScript. Used by 40+ internal individuals for entering, storing, and viewing customer information from all points of contact with the customer - customer service, sales, etc. Integrated CRM with Oracle Order Entry, Oracle Purchasing, and customer Order Management data tables. Used UTL SMTP to automatically email users when a CRM log has been assigned to them.
• Hyperion Essbase and Hyperion Analyzer. Created extracts from Oracle database for import into Hyperion Essbase. Designed Essbase for financials reporting, imported dimensions and data, installed and utilized Hyperion Analyzer and Essbase Excel plug-ins, and developed reports within Hyperion Analyzer.
• Sourcing engine utilizing Oracle Workflow and PL/SQL, used to determine to which vendor catalog items are to be sourced on a real-time basis based upon vendor price, vendor and customer geographic locations, and customer ps.
• Receiving/Shipping Management tool using Oracle PL/SQL Web toolkit, HTML, and JavaScript. Provides order management team members with the ability to track and record shipping information from vendors and delivery information to our customers of items that have been procured through our vendors. This tool provided the capability to grow procurement by over 400% without requiring additional resources to manage the procurement effort.
• RMA/Cancellation management tool designed to allow for seamless communication of Return/Cancellation requests between our Customer Care, Order Management, and Finance groups. Outbound AR Invoice interface from Oracle AR, which automatically sends electronic Invoices in either ASCII, CSV, or XML formats to customers.
• AR, AP, INV, PO, OE, and GL Interfaces, utilizing eCommerce Gateway. Both inbound and outbound EDI files(850, 810, 855, 856, 857) interfacing with GenTran and Supplier VANs.
• PL/SQL packages and DataLoader scripts to load and maintain catalog data within Oracle Applications.
• Oracle Alerts using PL/SQL and UNIX scripting to send automated email responses to users as a result of errors within the reconciliation of order information from the web environment to orders that have been interfaced to Oracle Applications.

Confidential, Austin, TX

Applications Analyst

• PeopleSoft developer during upgrade to PeopleSoft Financials 7.5. Design, develop, test, and implement custom reports for financial reporting using PeopleSoft Query, nVision, SQR, and Crystal Reports.
• Create consolidated financial reports utilizing Application Designer, PeopleCode, and SQR. Consult with users to determine desired functionality within financial reports and determine feasibility.
• Perform tuning of programs and embedded SQL to improve processing efficiency of programs. Develop Access database for the purpose of revenue reporting.

Confidential, Austin, TX

Consultant/Programmer

Responsibilities:

• Voucher Load(EDI 810) interface utilizing SQR, EDI Manager, COBOL, Query, Crystal Reports, PeopleCode, Data Designer, and Panel Designer.
• Bank Reconciliation interface utilizing SQR, PeopleCode, Panel Designer, and EDI Manager
• Vendor Information and Vendor Contract Conversions utilizing SQR
• Report identifying outstanding/unreconciled/unmatched Purchase Orders

Confidential, Austin, TX

Programmer/Quality Control Specialist

Responsibilities:

• Design, test, and implement programs to facilitate processing of retirement plans. Extract and manipulate financial statistics from a relational database.
• Train and provide technical support to processors utilizing new programs. Maintain relationships between the firm and financial trustees.
• Developed automatic trustee links, thus increasing trading capabilities by 100% and decreasing processing time by 70%
• Successfully increased number of clients by 15% while maintaining a consistent number of daily valuation processors.