Peningo Systems, Inc.
Resume of Candidate: PEN160
Rate: email us at info@peningo.com for rate information or call (914) 921-3102
Oracle Transportation Management Consultant
SUMMARY
Solutions-oriented Oracle Applications and OTM Consultant with notable success working in qualified, productive teams throughout implementation of a
broad range of fully integrated Oracle-based solutions, while participating in development, analysis, implementation, strategy, and planning of robust
systems supporting core business needs.
Success in the analysis and design of innovative Oracle-based solutions directly leading to increased revenues, significantly reduced expenses,
improved systems capabilities, and cross-functional business growth.
Diligent and precise at authoring procedures and specifications, as well as performing tuning and training and supervising teams in all
development, administration, and support arenas.
Influential communications and relationship building abilities; successfully prepare and facilitate communications between business and technical
teams, cohesively articulating IT solutions to clients and staff at all levels of technical proficiency.
Exceptional leadership and supervisory abilities, with experience assembling, motivating, and supervising productive, cohesive teams to
consistently exceed business goals.
An accomplished career of increasing industry responsibilities providing full-lifecycle project and program management on large-scale initiatives,
specializing in fully integrated Oracle Applications solutions.
Recognition by clients and employers as a top rated professional attaining exceptional awards and performance ratings.
CORE COMPETENCIES:
Oracle Applications/ OTM Service Oriented Architecture Oracle Database Design
Business/Technology Strategic Alignment Systems Migration User Training & Support
FUNCTIONAL BACKGROUND
Modules: Oracle Transportation Management, Oracle Warehouse Management Systems, Oracle Order Management, Accounts Receivable, Oracle
Cash Management
TECHNICAL BACKGROUND
Platforms: UNIX, Windows NT/2000/XP,7 and 8
Tools: Oracle JDeveloper, Oracle SOA 11g, XML, XSLT 1.x and 2.x, PL/SQL, SQL, Oracle (7.x – 11g), Oracle Applications 11i and 12, Mercury IT
Governance, Oracle Portal, Oracle workflow, Oracle XML Publisher, Java (including JSP and JDBC), Oracle OA Framework, Oracle MWA Framework, HTML,
C, Pascal, Ada
PROFESSIONAL EXPERIENCE
2012 – Present
OTM/EBS Senior Consultant
Implemented a complex OTM and E-business R12 integration project and supported customers’ live solutions on OTM
Key Achievements:
Trouble shoot and resolve bulk planning issues
Setup locations, items, rates, service providers and itineraries to facilitate single and multi-leg shipment planning.
Worked on customizing the EBS R12 to OTM integration processes to transfer additional information from EBS to OTM such as party information.
Created the MD 50 design document for a major shipment upload interface to OTM to update ship unit weight and other key elements. The design
provided the mapping between the inbound external data file and the GLOG schema XPATH expressions. Also created the agent that recalculates the
shipment upon shipment upload.
Setup key OTM agents to orchestrate the order release creation and shipment planning process for orders originating in Order Management as
well as in Oracle SNO (Strategic Network Optimization) module.
Setup OTM agents to automate seeded reports email distribution when the user clicks on a custom shipment action. Linked custom action with a
custom agent to run the report while another custom agent listened on the Report Ready event and distributed the report to groups of contacts.
Designed and developed key Oracle SOA 11g BPEL processes to handle the integration between OTM and Oracle PS (Production Scheduling)
module. The development involved constructing the PS schema out of OTM shipments and updating the shipments back based on the PS schedule.
Using SOA 11g, designed and developed several key XSLT 2.0 components to handle the complex transformation of data from OTM to various
systems and back.
Created an OTM scheduled process to automate the transmission of all eligible shipment XML via the GLOG XML schema format and based on a
saved query to a SOA BPEL process that will construct the transformation XML for PS.
Created an OTM custom profile to filter the outbound GLOG XML and include only the XPATH elements that are needed by the receiving SOA BPEL
process.
Uploaded Service Provider OTM users, Service Provider association and OTM locations CSV files to OTM using the standard tools.
Customized OTM style sheets using XSLT 1.0 to be used for sending customized shipment advices to various customers.
Supported a Java Struts JSP based implementation for a major KSAP client that involved design and development of many custom JSP screens that
integrate flawlessly with the OTM standard application.
Worked on OTM system admin tasks such as customizing screen sets, menus, user access and custom actions.
Provided unique and key knowledge to the OTM and EBS teams on the table schemas of OTM and EBS highlighting a thorough understanding of the
EBS and OTM data models.
IBM Canada Ltd. 2004 – 2012
Managing Consultant
Supported a complex OTM and E-business integration project on a large Oracle Applications 11i implementation, while applying Oracle’s methodology in
documentation, design and development.
Key Achievements:
Created XSLT style sheet to filter Shipment stop information in OTM and send the resulting output XML to planet press using an external system.
Setup OTM agent to fire upon ship confirm, run the shipment event in OTM and call the planet press external system for each stop on the
shipment. This supported multi stop shipments.
Designed/Developed SQL Stored Procedures for saved queries to be used in agents.
Supported various integration custom and seeded BPEL processes between Oracle Applications R11i (Shipping Execution) and OTM 5.5 using BPEL
10.1.3.4 technology.
Created BPEL process to provide tighter validation and integration between OTM agents and Oracle shipping execution processes.
Supported sales efforts and demos for R12 of Oracle Applications including using SOA invocation framework, which is part of the integrated SOA
gateway to communicate with third party web services.
Designed and developed a series of flexible and productive UI screens, using OA Framework Java based technology, to automate all client change
orders on sales orders and purchase orders using Oracle public APIs.
Designed and developed PL/SQL programs to automate the splitting of order lines to coincide with Oracle OTM order releases in a custom OTM
domain (Virtual Trucks).
Worked on a first phase of a successful client engagement to completely redesign their pricing systems in Oracle Order Management using Oracle
advanced pricing module. This included setting up complex business rules and various pricing models. Business requirements were documented using
CMMI methodology.
Established client firm’s first project management methodology based on CMMI solution and used it to implement Oracle AR and GL.
Provided on-hand development to a number of projects on tools ranging from OA-Framework using JDeveloper, Oracle Forms 6i, Oracle Reports 6i,
Oracle Discoverer Desktop and Administrator, and Oracle workflow.
Supervised multidisciplinary teams in migration from Oracle 10.7 to Oracle 11i, including Oracle Applications implementation (GL/AR/AP/INV/OM)
supporting Oracle database
Provided hands on technical expertise to the development team to resolve urgent development and production problems.
Designed and developed interface architecture standards and code to automate the transfer of hundreds of data files between Oracle Applications
and various legacy systems.
Designed and developed an AP invoices interface to automate the process of invoices entry from various vendors.
Provided technical estimates of work required for various functionalities to the project management Office based on Oracle AIM templates and
estimating standards.
Implemented and coordinated the configuration management and code transfer of a 180 RICE (Reports, Interfaces, Conversions and Extensions)
elements from development to production.
Worked on design and code reviews to ensure the quality of the deliverables for a number of client projects.
Computer Task Group 2004-2004
Systems Analyst
Developed programs that are compatible with the client’s multi organizational, and multi currency applications environment, while applying Oracle’s
methodology in documentation, design and development.
Key Achievements:
Worked on an inventory quantities report, aged inventory report and inventory lot traceability report out of Oracle Inventory.
Implemented a customized a version of the Oracle margin analysis program to integrate with the client’s unique business setup. The program pulls
cost of goods and revenue information from Oracle inventory and Oracle GL for margin calculation and assessment.
Successfully customized Oracle bills of material to provide business analysts with a tool to assess how well their material forecasting matches with
real production composition.
Created a budget control report to align procurement needs with the budget and help the organization avoid costly budget overruns in a timely
manner.
Authored functional design of new interface that will compute the cost of sales for each product by raw material category, and developed the new
interface.
INTERNATIONAL TURNKEY SYSTEMS (ITS) 2002 – 2003
Project Manager
Performed full lifecycle project management throughout development and implementation of large-scale banking and financial initiatives for
corporations throughout the region. Coordinated and oversaw efforts of cross-functional teams, including business analysts, solution specialists,
designers, and developers to ensure fulfillment of unique customer needs. Participated in status meetings, articulating risks, project scope, budgets,
assumptions, and resource needs based on needs analysis and requirements gathering sessions.
Key Achievements:
Spearheaded successful implementation of Core Banking System for a major commercial bank, recognized as firm’s most complex system to-date
and including Phoenix Core Banking System, Mosaic, Trade Wind, and Sybase 12.
Supervised multidisciplinary teams in design and implementation of Consumer Finance Solution, including Oracle Applications implementation
(GL/AR/AP/INV) supporting Oracle database, for International Commercial House.
Led successful Oracle-based implementation for a financial company.
Established firm’s first project management methodology, based on ITS solution, as well as participating in technical design of ERP solutions, and
development of conversion scripts.
ORACLE CORPORATION CANADA 1997– 2002
Principal Consultant
Recruited to provide consultative services, applying expertise in Oracle design, development, and administration while working with customers on ERP
implementations, customized Oracle solutions, and Oracle Forms/Reports development. Completed large-scale projects for clients across broad range
of industries, including insurance, manufacturing, and financial services, performing all development phases including needs analysis, project scope
definition, development and customization, and implementation. Applied process model, entity relationship model, and functional hierarchy model to
ensure fulfillment of client business needs, while leading technical teams in adherence with best practices and standards.
Key Achievements:
Implemented customized version of Oracle iStore and Oracle Financials supporting large Business-to-Business eCommerce initiative for the Bank
of Montreal.
Successfully customized Oracle Human Resources and Payroll for high-profile ERP application initiatives, enabling 100% automation of actions.
Designed custom interfaces, reporting schemas, and modules for Home Hardware Limited.
Served instrumental role in analysis and design of stock options system for Research in Motion, enabling monitoring and management of options
grants, as well as monitoring of transactions.
Recognized for outstanding performance and commitment to customer satisfaction with Consultant of the Quarter award; regularly requested to
fulfill escalated technical issues.
Additional Notable Clients: Ontario Municipal Employees Retirement Systems, University of Waterloo, Home Hardware Limited, Guarantee Company
of North America, AIM Mutual Funds.
COMPUTER AND COMMUNICATIONS SYSTEMS (CCS) 1994 – 1996
Programmer/Analyst
Gained expertise in Oracle systems design, development, and administration while participating in development activities for financial services
provider. Served key role in design of fully integrated Bank Automation System, including functionality for bank transfers, letters of credit, and loans
discounted bills. Created numerous forms and reports to ensure full integration, while programming PL/SQL code packages and functions. Successfully
reverse engineered solution into Oracle Designer repository.
EDUCATION / TRAINING
MBA in IT Management (2006)
ATHABASCA UNIVERSITY, Athabasca, Canada
Related coursework: Project Management, Human Factors in IT, Information Technology Strategy, Strategic Management, Marketing, Financial
Accounting, Analytical Tools, Human Resource Management, Operations Management, New venture Development
Bachelor of Mathematics/Computer Science (1994)
UNIVERSITY OF WATERLOO, Waterloo, Canada
Professional Training:
Oracle Warehouse Management Systems, Oracle Advanced Supply Chain Planning, Oracle OA-Framework, Oracle Order Management use and
Implementation, Consulting Skills, Oracle 9i New Features, XML Design and Programming, Web Server Administration, Oracle Developer 2000 V6.0, Oracle
Designer 2000 V1.3 Process Modeling, HTML Programming, Oracle SQL Statement Tuning
 | |  | |  | |  | |  | |  | |  |