Developer Data

Resume of Rogers W. Claggett

email: adi98n@r.postjobfree.com

phone: 603-***-**** (cell)

SUMMARY:

• 38+ years of overall experience in IT industry.

• Extensive experience in Oracle SQL, PL/SQL, SQL Loader, Performance Tuning TKprof, Explain Plan, TOAD

• Designed, managed and implemented migrations to Manhattan WMS and Oracle RMS.

• Extensive experience with ERDs and working with data modelers.

• Extensive experience migrating data with XML

• Designed, developed, interfaced and migrated all areas of retail applications including warehouse, inventory, in-transit, order entry, EDI, accounts payable (Oracle)

• Managed developer teams for systems development and migrations. TECHNICAL SKILLS:

LANGUAGES: C, SQL, BASH

Database: Oracle 5 through 8i/9i/10g/11g/12c (SQL/ PLSQL), SQL*Loader, Toad OS: UNIX, Linux

EXPERIENCE:

04/2019 to The McLane Company, Temple, TX

04/2020 Senior Oracle Developer

on assignment via The Judge Group

• designed and began implementation of a interface whereby McLane will replace its homegrown mainframe warehouse system with Manhattan WMS.

• researched the existing host warehouse data sources and interfaces.

• mapped the existing host warehouse interfaces to Manhattan WMS interfaces.

• identified and designed solutions for the McLane/Manhattan data gaps.

• designed and deployed intermediate tables, triggers and stored procedures for data stored between McLane and Manhattan.

• Worked with the McLane senior dba using the erwin database modeler ERD tool as the means of creating the design in the database.

• designed and provided specs for programs to handle data passing back and forth between McLane and Manhattan.

• trained the team tasked with implementing the interface design.

• developed Linux and sqlplus tools for analyzing and monitoring database structures. 05/1987 to Burlington Coat Factory, Burlington, NJ 06/2016 Database Systems Architect

• Worked closely with CIO and VP level personnel for 28 years in gathering project requirements, designing systems, implementing and deploying systems.

• Developed/maintained SQLGEN, a C code generator to interface with Oracle databases.

• Redeveloped/Migrated Burlington's retail systems from Honeywell to Sequent (UNIX).

• Developed/maintained various retail, warehouse management systems using Oracle database, XML Transactions for all queue messages.

• Managed a ten-member developer group (OLTP - On Line Transaction Processing).

• Managed test suite methodology for applications to support reliable change and deployment.

• Migrated Burlington's retail systems for Sequent upgrades and eventually to Linux.

• Migrated Burlington's legacy warehouse systems to Manhattan's WMS.

• Analyzed inbound and outbound dataflows for legacy data systems for all warehouse systems including, PO, Pricing, Allocation, Receiving, Shipping, Reserve, EDI, In transit

• Designed WMS interfaces for legacy system dataflow, including dataflow diagrams, data field mappings and interface mechanisms

• Directed and worked with the database modeler using Oracle's database ERD tool.

• Managed implementation of all WMS interface software

• Planned and executed the deployment of the new WMS interfaces for Burlington's warehouses, thereby completing the migration from Burlington's legacy warehouse systems to WMS

• Designed and developed support tools and monitoring apps for WMS vs. legacy systems

• Migrated Burlington's retail systems to Oracle's RMS

• Coordinated with CIO to promote architectural goals and design concepts. 10/1977 to Wang Labs, Lowell, MA

05/1987 Software Engineer

• Maintained/Developed KFAM (B* Tree Key File Access Method)

• Maintained/Developed Wang Basic Interpreter, Pseudo Code compiler

• Hardware - Wang 2200, Wang PC

• Languages - Wang Basic, C

• Managed a small group of developers

EDUCATION:

University of New Hampshire

Bachelor of Science - BS, Mathematics

Trinity College Dublin

Higher Diploma in Education

Trinity College Dublin

Diploma of Computers in Education, Computer Science University of Massachusetts Lowell

Master's degree, Mathematics, Computer Science Option

Contact this candidate