PEN92
|
Responsible for the management, ownership, and delivery of the Oracle Retail solution for major systems implementation • Provided expertise in the Oracle Retail space, specifically in the Retail Merchandise System (ORMS) and Retail Invoice Matching (ReIM) areas • Conducted four Conference Room Pilot (CRP) sessions around the Oracle Retail space • Supervised team of 3 clients creating To-Be Process Flows, gap documentation and resolution • Provided detailed functional training to clients pertaining to RMS & ReIM • Provided expertise and guidance to both client and Accenture resources regarding functional designs: Retail Merchandise System (ORMS), Retail Sales Audit (ReSa), Retail Invoice Matching (ReIM) • Established effective working relationships with client personnel to develop requirements and business process designs • Conducted reviews of all finalized designs (i.e. Transfers, PO's, Deals, ReSA, etc.) with Client Leadership to obtain approval • Provided detailed functional training to clients pertaining to RMS & ReIM
|
PEN93
|
For a corporate global effort to integrate critical production systems under Oracle Retail (Retek) and Oracle E-Business Suite (EBS) • Designed, developed, tested and deployed data conversions and interfaces from RMS to POS for price and sign changes using PL/SQL stored procedures, triggers, shell scripts. Modeled the persistence layer of interfaces infrastructure. • Designed price conversions and interfaces from RMS to Advanced Pricing (QP) module of Oracle EBS. Wrote CV40 (Oracle conversion functional) and CV60 (Oracle conversion technical) documents. Wrote MD50(functional design) and MD70 (technical design) documents. Performed code reviews to identify potential issues and assured compliance with corporate security standards. International Promotion System • Redesigned and implemented the user interface for IPS (International Promotion System) using Java, Oracle ADF, ADF Business Components and PL/SQL stored procedures. • Designed and developed data conversions and data interfaces to synchronize data from systems of record to data consumer subsystems. Price List Management System • Took part in the design and implementation of the web-based user interfaces for contract pricing using Java, Oracle ADF, Oracle JDeveloper, ADF Faces, ADF Business Components and SQL. DemandTec Phase II – Strategic Pricing Approval • Lead the phase II of this project which consisted of business approval of the prices received from DemandTec, the provider of pricing optimization for Office Depot. • Gathered requirements • Designed the integration with RMS, the system of record for pricing. • Implemented the integration subsystem using Pro*C on Unix and PL/SQL. • Designed the user interface for the approval subsystem, which was implemented in Java, J2EE and Struts on WebSphere. Environment: Pro*C, PL/SQL, Oracle 10g, Unix, ksh, Java, XML, Oracle ADF, Toad, SQL Developer, ChangeMan, Subversion, JDeveloper, Struts, WSAD, Mercury TestDirector, ITG
|
PEN95
|
Oracle Retail Merchandising System Consultant including integration, customization and interfacing. Over ten years of very large-scale Oracle RDBMS application design and development experience. Expertise in Oracle Retail business merchandising modules (ORMS / OSIM / ORDF / Replenishment/ReSA/RDW/Allocations; Electric utilities applications, Government oil & gas reserves management applications
|
|