SUMMARY:

• Experienced Oracle Retail Technical Consultant with over 25 years of experience in all phases of the software development life cycle. Deep technical Retail knowledge obtained while being involved in multiple large retail implementations. Experienced in customization for Retek packages and code, data conversion and post go - live support. Proven experience in performance tuning and SQL query optimization. Experienced in application Design, Database Organization/setup and also the underlying Operating Systems memory and disk subsystems to solve real enterprise problems. Ability to handle multiple tasks and capable of handling responsibilities independently or in a team environment. Involved in multiple implementation of the Oracle Retail Suite 8.x and higher including 13.x. Technical expertise includes the following Oracle Retail modules:
• Oracle Retail Merchandising System (ORMS)
• Oracle Retail Price Management (ORPM)
• Oracle Retail Sales Audit (OReSA)
• Oracle Retail Allocations (ORA)
• Oracle Retail Invoice Matching (OReIM)
• Oracle Store Inventory Management(OSIM)
• Oracle Warehouse Management System(OWMS)

TECHNICAL SKILLS:

Software Languages: PHP, Java, JavaScript, Perl, C/C++, PL/SQL, COBOL, PHP

Operating Systems: HPUX, AIX, X-Windows, Windows NT, SUN Solaris Unix

Databases: Oracle 8i, Oracle 9i, Oracle 11g, Oracle 11g Oracle 10g Express, Microsoft Access, SQL Server

Oracle Tools: Oracle Application Express, Oracle Forms 6i, Oracle Reports 6i, Crystal 9.0, ProC/C++ 2.2, Oracle OCI, Oracle Designer, Oracle 9iAS, BI publisher

Batch Schedulers: Autosys, Appworx, CA7, UC4

Microsoft Tools: Visual C++ 6.0 with MFC, Visual Basic 6.0, Visual Studio .net

Client Server Tools: Power Builder 4.0, Visual Basic 6.0

Web Tools: JDeveloper, Oracle Application Express, HTML and XML, Eclipse

Hardware Platforms: Confidential HP-700/800, IBM PC's, Data General MV8000, IBM RS6000, SUN

WORK EXPERIENCE:

Confidential

Technical Consultant

Responsibilities:

• Worked with the Operations department to stabilize the Oracle Retail Batch system. Developed semi-automatic Software migration procedures to allow Operations to deploy code changes. Developed batch monitoring scripts for long running jobs and late batch alerts. Worked with the Application Development team to come up with procedures to fix issues with the SIM ThirdParty stock count process. Help train operations on installing and triaging issues with the UC4 scheduler server and agents. Worked on upgrade project to migrate scheduler from V8 to V10. Worked with Application developers on unix scripting issues found in batch programs. Help triage production batch issues. Worked with infrastructure team to successfully migrate system to an Oracle exadata environment.

Confidential

Oracle Enterprise Architect (Veteran Canteen Services)

Responsibilities:

• Technical lead on support of all Oracle Retail products for the Veteran Canteen Services. Leading design effort to integrate Oracle Retail to a new Point of Sale System. This interface effort involves generating inbound XML data to send item information to the POS system and processing outbound XML data that respresent sales, receipts, and orders back to RMS. Provide leadership for technical team on process improvements and customizations of the Oracle Retail Suite. Led design of new EDI pre-processor that allows better EDI file visibility and corrections. Lead knowledge transfer sessions as needed. Implemented process to parse and validate all EDI 810 and EDI 856 documents received at the Veteran Canteen Service. Designed and implemented new item ranging process to allow customer to upload item ranging from a spreadsheet. Implemented and designed new online POS refresh process. Provide updates to VA intranet and internet websites.

Confidential, Inver Grove Heights, MN

Senior Consultant (Veteran Canteen Services)

Responsibilities:

• Technical lead on the Oracle Retail 13.x implementation for the Veteran Canteen services. This position involved the implementation of RMS, RPM, ALLOCATION, Invoice Matching, RDW, SIM and Oracle Financials. Also it involved managing a team of up to 12 technical resources both from Logic and from the VA. Responsibilites included designing all data conversion methodology and scripts, CA7 wrapper script designs, CA7 batch infrastructure design and triaging all technical issues. Worked extensively with Avery Dennision and Direct-EDI who are VCS’s vendors for the handhead scanners and EDI implementation providing design requirements to interface with Oracle. Led technical conference room pilot and knowledge transfer sessions. Mentored entire team on unix and oracle retail technical internals such as the Oracle Retail Interface bus(RIB).

Confidential, Inver Grove Heights, MN

Senior Consultant (Gander Mountain)

Responsibilities:

• Worked on implementation team installing version 12 of Oracle and resolving issues in RMS, RDW, RPM, RDM, RDF and Gander Mountain customs programs. This involved writing and modifying Pro*C, Kornshell and Oracle Forms programs. Also I was involved with solving program performance and operating system security issue.
• Worked with team resolving Appworx scheduling issues. This involved installing, configuring and customizing the scheduling product. I also helped with defining scheduling modules and chains to meet project requirements.
• Mentored Junior programmers on programming standards and troubleshooting techniques.

Confidential, Inver Grove Heights, MN

Senior Consultant (Pamida)

Responsibilities:

• Responsible for design and development of enhancements to RMS at Pamida.
• Designed and implemented Pro*C program to convert file from EDI 856 format to Retek ASN upload format.
• Developed data model for storing ASN’s so that if errors are detected while processing ASN’s they can be edited on-line and reprocessed.

Confidential, High Point, NC

Senior Retek Technical Analyst

Responsibilities:

• Responsible for the technical design and deployment of complex retail systems based on RetekRMS.
• Assisted in all phases of system implementation including design, development, testing and support.
• Worked effectively with customers to learn specific design requirements and perform analysis and design of retail applications.
• Prepared and maintained documentation of applications.
• Provided support for production issues.
• Researched technical issues and provided solutions.
• Areas of expertise involved Unix Korn shell scripting, Pro*C, Oracle Forms and SQL tuning.

Confidential, Charlotte, NC

Senior Consultant

Responsibilities:

• Senior developer assigned to the Client Relationship Management Services group in support of the CED and CRT databases.
• Created documentation, triggers, stored procedure and packages according to established guidelines.
• Involved with performance tuning of batch processes and mentoring of staff.

Confidential, Charlotte, NC

Senior AIX Systems Administrator/Oracle Development DBA

Responsibilities:

• Created interface to monitor the allocation system interface between the Distribution Management System, Retail Management System and the Mainframe Allocation system. This involved designing and creating several User Interfaces to allow the user to view incoming shipments, allocation requests, and allocations. With this new interface the user was able to track down allocations problems a lot easier and allow movement of goods through the DC more efficiently and eliminated a lot of paperwork and phone communications.
• Created interfaces for processing inbound/outbound shipment information between Manhattan Associates' Trading Partner Management (TPM) system. These interfaces validated the electronic shipment data coming in from the outside vendor against our Retail Merchandising System (RMS) for accuracy. The interface updated in real time a web page that tracked the status of the incoming shipments and provided troubleshooting information for the Distribution Center Personel. These interfaces were designed and implemented using Pro*C, Java, PL/SQL and perl.
• Successfully led the task of converting our Retek Data Warehouse system from Oracle 8.0.5(32-bit) to Oracle 9i (64-Bit). This involved recompiling all Batch Pro*C against the Oracle 9I 64-Bit environment and running parallel batch cycles with production and comparing the results. The results were compared by the user community using the Microstrategy reporting tool.
• Successfully installed the application sever component of Oracle Financials 11i.
• Performed performance tuning of Retek's RMS and RDW Pro*C modules.
• Designed and implemented interface between Autosys and Crystal Reports' Enterprise Scheduler using server-side Javascript and Perl.
• Worked closely with DBA's in resolving database performance and execution issues.
• Created automated publishing of new and updated Crystal reports to the Crystal Enterprise Server as part of promotion process from PVCS.
• Designed and implemented technique for transmitting reports to the Vista Report Distribution System using Perl.
• Worked with technical services in setting up the Apache Web Server and Oracle 9iAS Application Server on our NT systems.
• Worked as MPS TECHNICAL TESTING MANAGER performing technical oversight for of all phases of MPS systems testing.
• Determined cause of problems (Batch, PL/SQL, Forms, etc.), whether a Cato problem or a Retek problem.
• Determined the severity of the problem and its effect on the testing.
• Assisted developers as needed in gaining an understanding of the issue, causes, and results, providing insight to possible solutions.
• Provided Unix system management support for the RS6000 AIX machines.
• Installed and implemented Software Configuration Management system that includes Source Control and promotion of software to Unix and NT target machines.
• Installed and implemented the Autosys scheduling system on Unix and worked with Operations to create the batch schedules and to train the Operations staff on how to support the Autosys system.
• Provided and mentoring to the software development staff on Software Standards, the use of Unix, and Software Development and debugging techniques in C, Java, Awk, Kornshell and in Oracle PL/SQL.

Confidential, Charlotte, NC

Senior Consultant

Responsibilities:

• Developed program in Java to process mortgage applications being transmitted in XML format. The program utilized JDBC to store the processed information to an Oracle Database.

Confidential, Charlotte, NC

Senior Consultant

Responsibilities:

• Upgraded existing Pro*C applications to use Visual C++ 5.0 and added new options to the user interface component.

Confidential, Charlotte, NC

Senior Consultant

Responsibilities:

• Worked with Business Analyts to add enhancements to and create new Pro*C batch programs to support the Commercial Banking System database (CBS).
• Provided maintenance and on call support for Unix batch programs.
• Made modications to C++ programs running on a NT platform.
• Created PL/SQL programs to correct the CBS database for data errors because of a rule of only committing 100 records at a time to the database.
• Provided mentoring and guidance to junior level programmers in the area of C/C++, SQL, PL/SQL and Unix programming.
• Assigned to Architecture team to develop Java based programs for CBS

Confidential, Charlotte, NC

Senior Consultant

Responsibilities:

• Implemented custom enhancements to transportation management product using Pro*C, PL/SQL and Forms 4.5.
• Provided Analysis and Detailed design of proposed enhancements to transportation management product.
• Developed new functionality using Pro*C to include in a custom enhancement to transportation management product.
• Found and corrected bugs reported by clients. This work involved changing Pro*C programs that reside on HP-UX, Forms 4.5 applications running on Windows NT and PL/SQL stored procedures and triggers residing in a Oracle database.

Confidential, Charlotte, NC

Senior Consultant

Responsibilities:

• Ported DOS based Oracle Database applications to Windows 95. This effort involved the integration of Microsoft Visual C++ 4.0, Oracle ProC C++ 2.2, Oracle OCI, Oracle Forms 4.5 and Oracle Reports 2.5. Several user exits were created to work with Oracle Reports and Oracle Forms. The C++ programs monitors the database to determine if any database activity has occurred that requires reports to be generated. Several Database procedures and triggers were created to enforce business rules and to optimize the code.

Confidential, Clemmons, NC

Senior Software Engineer

Responsibilities:

• Implemented Microsoft Windows 95 version of an existing Electronics Parts Catalog System written for DOS. This work was done using Microsoft Visual C++ 4.0. The completed project allowed Confidential to use the same database format currently stored on CD-ROM but with a Windows 95 Front End to the data.
• Did the initial design work for a Client Server version that will use Oracle's Relational Database running on a Windows NT server.
• Maintained and incorporated enhancements into an existing Electronic Parts Catalog System. This work used Microsoft C and used a Network Database Model for the database. The enhancements were to create new user interface elements and to modify the database model to support new data requirements. The Electronic Parts Catalog System was MS-DOS based but I developed plans to convert it to Microsoft Windows 95.
• Developed a Power Builder 4.0 front-end to a Sybase SQL Anywhere Database to maintain customer's Fleet information for a Prototype Fleet Maintenance and Vehicle Tracking system.
• Developed a communication's message server using Microsoft Visual C++ to support wireless communication to and from vehicles in a fleet.
• Developed message formats and message content of data being transmitted. The Message Server runs as a background task on a NT server. The Message Server receives messages through the communications interface for inbound messages from the fleet and insert these messages into an Oracle database. Outbound messages placed in the database by other NT clients are removed and transmitted through the communications interface to the intended vehicle in the fleet.
• Developed a set of C++ classes to access the Oracle database.
• Developed a Visual Basic front-end to an Oracle Database to maintain customer's Fleet information for a Prototype Fleet Maintenance and Vehicle Tracking system.
• Developed several data-entry forms and data browsers' using the VBX's available with Visual Basic. The database queries were implemented using ODBC.

Confidential, Baltimore, MD

Senior Software Engineer

Responsibilities:

• Developed several database applications using Oracle's Pro*C compiler, Oracle Forms, and Oracle Report Writer as part of a system to track busses(SmartTrack) in large metropolitan areas.
• Developed a translator that reads customer bus schedules and route description files and translates them to formats usable by our SmartTrack system. Algorithms to sort and search large amounts of data had to be implemented. File layouts designed had to be highly efficient for retrieval of bus schedules by a real-time scheduling process running in the SmartTrack system. All worked was done on HP 700/800 machines running Unix and using their C compiler.
• Developed a Client Application in the SmartTrack system to query processes running in the system for status information to be displayed to the user. The work used my knowledge of Berkeley sockets, TCP protocols, and X-Window user interface design.
• Analyzed software for timing and sizing requirements on a Radar Project that used ADA for their embedded real-time processors. I significantly reduced the size of many software modules due to my previous experience with ADA and knowledge of efficient algorithms.
• Setup a small PC network to be used by a small group of engineers. Provided expertise on the use of major PC software packages such as WordPerfect, dBase, and Lotus Spreadsheets to the other Engineers in the group.
• Provided interface design data to the Hardware Designer for interfacing the CASS test set to the Computer(WRA-3) component of the Airborne Self Protection Jammer(ASPJ) system. Developed style guide for use in creating consistent Test programs on the CASS test set.
• Designed, coded and integrated software to test Electronic Warfare (EW) equipment using ADA. I wrote device drivers for VXI and VME cards using the Microtek "C" cross compiler. I was also responsible for troubleshooting the Test Set Electronics requiring the use of Logic Analyzers, 488 bus analyzers and detailed knowledge of digital logic design and UUT interface requirements.
• Lead a group of software engineers in the development of a product called the Time Line Editor that is a Compiler/Loader used to program a Westinghouse designed embedded controller located in a VME/VXI cardrack. I developed a high level language modeled after ADA using a product very similar to LEX & YACC. The product included a graphical programming interface that runs under DEC's UIS windowing system. I also developed procedures for software configuration and control using VAX CMS and MMS management tools.
• Designed, coded and integrated software using ATLAS(All Purpose Test Language) to test the Radar Receiver component of the B-1B radar. Also developed RF normalization techniques for the RF paths and self tests for the RF interface.
• Developed data editors, screen management routines, and keyboard handlers as part of team of engineers developing a standard test executive written in ADA for automatic test program development. I was also responsible for porting the entire product from a DATA GENERAL machine to a VAX machine in less than two weeks.
• Designed, coded and integrated automated test support software in Pascal to test components of the ASPJ system. Also supported modifications to the test executive software.

Confidential, Oakridge, Tennessee

Electrical Engineer

Responsibilities:

• Developed monitoring systems for weapon components during life cycle testing.
• Designed hardware and software and wrote detailed construction specification for shop personnel to build the systems