We have an Oracle Developer available that has Oracle Retail RMS/RDM, PL/SQL, Forms and Reports experience. He is available immediately and can relocate anywhere in the U.S.
Scott Duhl Everest Technologies [email protected] 614-436-3120 LOUIE DUNGAO • Information Technology Professional with solid 6 years of experience in Software technology with domain expertise in Oracle RMS (Retek Retail/ Merchandising) and Manufacturing and customization of Oracle RMS, Oracle RDM (Retek Distribution Management), Oracle RPM (Retek Pricing Management), ReSA (Retek Sales Audit) and Oracle RIB (Retek Integration Bus) based systems • Expertise in Oracle RMS Modules: Stock Ledger, Oracle Purchasing, ROQ (Request Ordered Quantity), Allocations, Transfer, Inventory, Pricing, Order Forms Modules and Sale • Experience in customization of the following retail products/ packages / forms / tools (Oracle RETEK Merchandising System (RMS), Oracle RPM ( Retek Price Management), Oracle ReSa (Retek Sales Audit), and Oracle RIB (Retek Integration Bus) • Experienced with RDM using RF and GUI Forms interfaces • Well experienced in both functional and technical aspects of Oracle RMS/RDM modules • Full implementation of lifecycle development projects using the V- model approach • Strong analytical capabilities and problem solving skills • Acquainted with CMMI Level 5 quality procedures and BS7799 safety procedures • Strong initiative, team player, responsible, good leadership and communication skills • 5 years of experience in Oracle Application versions 6i, 9i, and 10g (Oracle RMS – Retek) • Working experience with Workflow development and customization • Development and Customization of Oracle Forms(6i/9i and 10g) • Executed projects to enhance/develop forms module in Oracle RMS (Retek) Merchandising System • Customization of the retail packages and forms like RMS, RIB and Pricing to meet various functionalities • Developing new forms with specific functionality which does not exist and adds to the RETEK Suite – for store system • Coordinated/designed development of complex forms • Support system test/ fix defects and change request for the customized modules for various projects SUMMARY OF SKILLS Oracle Applications Purchase Order, Order Management, Oracle Purchasing, Inventory, PO (order forms), Replenishment, Allocations, Transfers, Inventory, and Store System (Transfer Intsruction) Languages Oracle PL/SQL, C, Pro*C, UNIX Databases Oracle 8i, Oracle 9i, Oracle 10g Operating Systems Sun Solaris, HP Unix, MS-Windows 94/98/NT/2000/XP, MS DOS 6.0 Oracle Tools Oracle Developer Suite 10g, Developer 2000(Forms6i/9i), Apex, SQL * Developer; PL-SQL Developer Toad, Exceed HummingbirdFilezilla; S_FTP v5.05.96.08.21, ExamDiff – Visual File comparison Tool 1.61, Eitplus Editor and Crimson Editor 3.60, Form Diff Application, Putty (UNIX Box) Hardware Systems HP 2000, IBM Compatibles, PC Compatibles EXPERIENCE Everest Technologies Inc. Feb 2008 - Present Client: GAP Direct, Inc. (RDM) Groveport, OHIO Project: RDM MiniQ 02/09 – Present The project involves enhancements and maintenance of RETEK-RDM Application that supports business operations. The RDM MiniQ project is an Agile Driven project that customizes RDM modules to meet business requirements that includes customization of RDM core applications such as: distribution, waving, stock order download, invoices printing, inventory, ASN/NSC receiving, ROP replenishments, packing, picking and inventory balance upload Designer/ Developer Responsibilities: • Develop a Unit Test Plan based on the acceptance criteria of the story based on work request, business requirements and/or product specifications • Create summary design to address fix/enhancement code change to support story’s acceptance criteria • Code and test software that meets the design specifications; execute and document the tests necessary to ensure that an application or technical environment meets performance requirements • Drive a PDM review or execute test plan with the product manager to verify that acceptance criteria is met and/or verify that existing functionality of modified module works effectively • Support RDM MiniQ Releases (fixing bugs) of production issue identified during implementation QA Engineer Responsibilities: • Developed a Unit Test Plan in the Quality Center based on the acceptance criteria of the story based on work request, business requirements and/or product specifications • Test and execute test plan based on story (work request) criteria and perform Regression Testing • Drive a PDM signed-off review or execute test plan with the product manager to verify that acceptance criteria is met and/or verify that existing functionality of modified module works effectively • Perform a sanity check for RDM MiniQ before and/or during release testing Project: RDM Maintenance 02/08 – 01/09 The project involved in customization, enhancement, and implementation of the following modules: distribution, stock order download, replenishment, inventory balance upload, picking, wave planning, packing modules and cartonization functionality Responsibilities: • Create technical design (RF and GUI forms/PL/SQL/Pro*C Batch modules) based on business requirement • Facilitate technical design review with the business and functional group • Participate and contribute to strategy discussions • Install and implement cycle strategy • Execute and document tests necessary to ensure: the application or technical environment meets performance requirements • Code and test software that meets the design specifications • Maintain and repair applications to meet technical and functional specifications • Create issue resolution document based on work request • Validate code performance, costing and reusability of modules • Build/code modules based on rssue resolution document • Create install script and transition document for project implementation • Create a unit test plan on modules developed based on the requirements set forth in technical design specification, product specifications and work request • Version controlled documents using SVN and standard quality procedures Environment: Oracle 9i, Oracle Developer Suite - Forms6i, Apex, SQL*Plus 8.0, Pro*C; Oracle 10g, Oracle RMS (Retek), Oracle RDM Alphasoft Services Corporation, Walnut Creek, California 10/07 – 01/08 Internal Project Responsibilities: • Requirement Analysis, design, development, implementation, debugging, testing, deployment and maintenance of client/Server applications in Unix and Windows environment • Development of applications using Oracle SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i in Oracle database version 8i and 9i • Implementation, upgrade, conversion of RMS Retek Application using Oracle 9i Developer Suites • Customization and creation of Oracle Forms 6i and interfaces in Store system module in Retek RMS Environment: SQL*Plus 8.0 Accenture, Inc., Johannesburg, South Africa 04/05 – 10/07 Senior Software Engineer Project: EDCON Stores The project is to customize Oracle RMS (Retek) for EDCON Stores. As Programmer Analyst, Louie’s role is not limited to leading the development and implementation of Retek Merchandising System applications, and creation of Technical Specifications for forms and packages. The project was executed at CMM Level 5. EDCON Stores project will allow the Merchant and / or Chain Operations to send out transfer instruction down to stores. The projects will have new screens and a report that stores will print as part of their daily report printing. The benefit to having the instruction sent down to the store from Retek through the Store Systems, will be that there will now be a systematic control on what stores are allowed to send back and quantities they are allowed to send back. The store will now have a comprehensive list of what needs to be actioned and the value that needs to be actioned and also how to action the merchandise. Responsibilities: • Conduct Functional Design specification walkthrough with the client in preparation to Technical Design creation • Create a Technical design (form FORMS/PL/SQL/Pro*C Batch modules) based on Functional design given by the clients • Participate and contribute to strategy discussions • Designed, build and customized the following functionalities/modules in RMS as part of the current release • Create Technical Specifications for Forms and Packages • Involvement and Implementation in the development life cycle strategy • Review of technical documents - specs, designs, code and test plans created by other team member • Co-ordinate the development of the project • Facilitate Project Team Meeting and address any project related issues and concerns • Assist other team members in creating a Technical Design specification to completion/until it is signed-off • Assists and helps the less-experienced team members • Executes and documents the tests necessary to ensure that an application or technical environment meets performance requirements • Codes and test software that meets the design specifications • Maintains and repairs applications to keep them performing to meet technical and functional specifications • Identify issues in Functional Design specification and technically propose resolution to it • Create a unit test plan on modules developed based on the requirements set forth in Technical Design Specification, product specifications and detailed design documents • Version controlled documents using VSS and standard quality procedures Environment: Oracle 9i, Oracle Developer Suite - Forms6i, SQL*Plus 8.0, Pro*C; Oracle 10g Oracle RMS (Retek) Accenture, Inc., UK/Japan 04/05 – 11/05 Senior Software Engineer Project: TESCO Stores This project is customizing find forms for Oracle RMS (Retek). Tesco identified the need to differentiate users and responsibilities & access permissions. This requirement stems from the necessity to restrict access according to users’ Commercial business functions. Additionally, in the UK enterprise architecture, items will not be created within RMS but will be published to RMS from the Product Introduction Management application (PIM). As a result, most users should be prevented from creating items themselves within RMS. Responsibilities: • Realized the users and responsibilities & access permissions and its implementation • Customized Oracle RMS (Retek)forms (itemmaster and itemloc forms) • Creates Retrofit Detailed Design for RMS 10.1.10AL ( for pricing and promotion forms) • Create Defect prevention checklist for forms/Pro*C Batch/PL/SQL modules • Creates project specific QA (Quality Assurance) checklist to maintain high quality software product • Identify probable issues that may arise and raise it immediately to the counterpart during the creation of Retrofit Detailed Design • Perform peer review on modules developed by other team members and ensures that all requirements in the Technical Design are implemented in the code and to ensure that the code conforms to the project’s coding standards • Ensure quality in all modules being developed by adhering to the development standards set in the project • Develops programs using standards and established methodology • Code, test and implements configuration changes to meet both functional and technical requirements • Maintains and repairs applications to keep them performing in accordance with technical and functional specifications; resolve issues/defects • Administer/Mentor the newly rolled-in resources regarding projects standards and processes • Assist other team members in code testing/debugging and unit test execution and RMS functionality • Executes and documents the tests necessary to ensure that an application or technical environment meets performance requirements Environment: Oracle 9i, Oracle Developer Suite - Forms6i, SQL*Plus 8.0, Pro*C; Oracle 10g Oracle RMS (Retek) Accenture, Inc., China/Hongkong 02/03 – 08/05 Software Engineer Project: Watsons Stores This project involved in customization of Oracle RMS (Retek) forms and packages for the following functionality: Ordering – customized order form to suit Watsons the Chemist requirements RTV Maintenance Form - Watson The Chemist requires the option of using either the latest PO Cost or Weighted Average Cost (WAC) when calculating the cost of Return To Vendor (RTV) Transactions. Responsibilities: • Creates Detailed Design for PLS/SQL/Database objects from Functional Design Specification • Develops programs using standards and established methodology • Code, test and implements configuration changes to meet both functional and technical requirements and maintains and repairs applications to keep them performing in accordance with technical and functional specifications • Create and execute unit test plans and create packages based on Detailed Design. • Modify packages, forms, and batch program based on detailed design • Resolve issues/defects during development cycle • Assists and helps the less-experienced team members • Attends on conference meetings to communicate with the designers and clients • Codes and test software that meets the design specifications • Maintains and repairs applications to keep them performing to meet technical and functional specification Environment: Oracle 9i, Oracle Developer Suite - Forms6i, SQL*Plus 8.0, Pro*C; Oracle 10g Accenture, Inc., Johannesburg South Africa 04/05 – 11/05 Senior Software Engineer Project: Woolworths Stores This project included creation of new packages with batch processing logic and new interfaces to cater for the following requirements with Oracle RMS (Retek): • Support the Item Balance on Contract Outbound interface • Balance on Contract Interface to RPM and Merchandise Planning • New interface Clearing Account Interfaces - support the Daily Data outbound interface process new package to manage the Integration Diagnostic Logging and Variance functionality for the daily data interface • Woolworths is using the Oracle RMS (Retek) Retail Selling Price RIB message to communicate RSP and Promotion Price changes from peer systems to RMS. During the CRP and Design phase, a number of additional attributes were identified. These attributes will be added to the incoming data object, RIB_PrcChgReqDesc_REC, and the upload API, RMSSUB_PRCCHGREQ, will be updated to cater for the new data object • Extract Item Details - Support the Item outbound interface Responsibilities: • Successfully involved on leading a team during the support phase of development • Identify complexity of the modules and provides detailed estimates for the module • Create Detailed Design based on Changed Request and code and test of Foundation release tasks • Develop programs using the Oracle PL/SQL following the Technical Design prepared by the Johannesburg Team • Ensure quality in all modules being developed by adhering to the development standards set in the project • Prepare and execute unit test plans on assigned modules • Create and execute component test script to verify that all requirements in the functional design are covered and implemented in the code • Review modules of other team members • Be aware of the budgets and practically identify any cases where tasks will need to go over budget. Attempt to minimize going over budget whenever possible • Creates PL/SQL and Forms QA checklist for the project • Solve fix issues/bugs raised by Johannesburg • Facilitate project team meeting; and Facilitate brownbag session to provide both technical and functional knowledge needed for the project • Provides both technical and functional knowledge to newly joined team members • Creates and maintain the project’s BCP (Business Continuity Plan) document and other related documents • Update other related CMMi (Capability Maturity Model Initiatives) and other related document • Communicating best coding practices and assisting less-experienced staff • Attend on conference meetings to communicate with the designers and clients • Building a strong understanding of at least one functional area within a Retek product and be able to provide complete functional and detailed designs within that area • Displaying a positive attitude and willingness to expand current role and take on additional responsibilities Environment: Oracle 9i, Oracle Developer Suite - Forms6i, SQL*Plus 8.0, Pro*C; Oracle 10g Oracle RMS (Retek) Accenture, Inc., Minneapolis 09/2002 – 02/2003 Associate Software Engineer Project: GA Retrofits Retrofit the RMS 11 Patch to RMS Retek 10.1 based codes/module for Release 1 and 2 of the RMS software product and creates RIB API Design documentation – extracts code and convert it into a Detailed Design with the updated code and Technical Design and Appropriately updates the generation of new defect in Remedy (Patch10.1.7 Non-MDM and 10.1.8). Responsibilities: • Develop code from detailed design or defect descriptions • Apply retrofits from defect documentation RMS 11 baseline code • Creates and executes unit test plan • Fix system test defects in a timely manner • Raised issues encountered during the build or fix to tam lead immediately • Complete deliverables within budget and within schedule • Use processes and project standards • Follow version control and migration process • Use the correct code baseline for any deliverables • Keep status of defects accurate in Remedy • Adherence to coding standards and performance guidelines • Provide feedback on project processes and standards • Independently research issues before asking for assistance • Alert team lead as soon as it is clear that the budget for a deliverable will not be net, or when target end date may not be met • Provide assistance with the RMS functionality to other team members • Executes and documents the tests necessary to ensure that an application or technical environment meets performance requirements • Develops programs using standards and established methodology • Setting an example with a strong work ethic that can be followed by fellow team members • Codes and test software that meets the design specifications • Report issues promptly to his lead • Accomplish and submit Time Report and Time tracker sheet on time • Generate Metric workbook for CMMi Level 5 Accenture, Inc., Minneapolis 09/2002 – 02/2003 Associate Software Engineer Project: Office Depot Custom Pricing This project included customization of Oracle RMS (Retek) forms for Pricing Strategy. There are new screens to create Future List, and display the past and current list price. Build new packages based on technical and Functional Requirements Responsibilities: • Develops package program using Oracle PL/SQL following the technical design prepared by the Minneapolis team • Develop and customize Form modules using Oracle Form Developer v6i - Oracle RMS (Retek) • Develops programs using standards and established methodology • Code, test and implements configuration changes to meet both functional and technical requirements • Create and execute unit test plans; Maintains and repairs applications to keep them performing to meet technical and functional specifications • Executes and documents the tests necessary to ensure that an application or technical environment meets performance requirements • Ensure quality in all modules being developed by adhering to the development standards set in the project Environment: Oracle 9i, Oracle Developer Suite - Forms6i, SQL*Plus 8.0, Pro*C; Oracle 10g Oracle RMS (Retek) Hitachi 01/2002 – 09/2002 Quality Assurance Engineer As a Quality Assurance Engineer, Louie’s primary role is to analyze the Hard Disk Drive using Oscilloscope (associate defect using the waveform analysis) and Visual Check. Responsibilities: • Perform Magnetic Heads and Disk Failure Analysis of Hard Disk Drive (HDD) • Creates Engineering Technical Report (ETR) based on Failure Analysis investigation • Liaise to supplier the Failure Analysis result based on defect investigation and study • Propose recommendation as countermeasure for the result of Failure Analysis • Investigate any non conformity in the Assembly Line • Ensure that processes and standards set forth by the company are followed by revisiting the MPM (Monthly Preventive Maintenance) Checklist • Facilitate QA Meeting with the Production Engineers and discuss Failure Analysis results • Undergo trainings under Japanese Instructors and participate in Quality Assurance Initiatives • Facilitate conference call and accurately reports Quality Metrics and QA Failure Analysis Result in Tokyo EDUCATION Bachelor of Science (B.S. ECE) in Electronics and Communication Engineering Licensed Electronics and Communication Engineer Certifications: Retek Merchandising System (One Month Training – Accenture) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "KNOW.IT" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/KNOW_IT_AZ?hl=en -~----------~----~----~----~------~----~------~--~---
