Scott M Martin

North Smithfield, RI 02896

Scott@smartininc.com

Summary of Experience Hardware:

PC, IBM iSeries, IBM AS/400, IBM-PC, WANG-VS65, IBM Mainframe Operating Systems:Windows XP, Windows 2000 Advanced Server, Windows NT Server, IBM OS/400, Windows 98, Windows 95, Windows 3.x, DOS, OS/2, WANG-VS Software:Visual Studio .NET, Microsoft .NET Framework, Visual Basic .NET, Visual Studio 2000, Office 2000, Office 97, HTML, Microsfot ASP, IIS, MTS, COM, ActiveX DLL, InterDev, HomeSite, Access, Visual Basic, SQL Server Stored Procedures, SQL Mail, JavaScript, VB Script, SQL, NT Performance Monitor, Windows API, Crystal Reports, ODBC API, Client Access, RPGILE, RPGIII, RPGII, CLPILE, CLP, AS/SET. ServerObject's:ASPMAIL, ASPNNTP, ASPCHART Databases:Microsoft Sql Server, Microsoft Access 97, 2.0, DB/2

Professional History 10/01 – Present SMARTIN Inc., Cranston, RI – Software Solutions Provider

Independent Consultant At Innovatum

    Gathered requirements, Designed, Code, Tested, Implemented and Support a .Net application that is a repository of documents for a given workflow for multiply tasks for a companies process. The system has a DB2 AS/400 database that has triggers on certain functions on the AS/400 files that would generate work flows. These work flows can then have multiply documents attached to them, emails can be sent from within the tasks, multiply notes can be created and multiply status can be assigned as the tasks work through the system. Carried the project through the entire life cycle, which included submitting proposals to upper management, managing the project resources, coding the project, supervising user testing and training, and performing implementation and support. The system was designed and is about to be marketed by Innovatum as a system named DocuThread.

10/01 – Present SMARTIN Inc., Cranston, RI – Software Solutions Provider Independent Consultant At Staples Corporate Offices

    Gathered requirements, Designed, Code, Tested, Implemented and Support an Order Consolidator process which takes orders during the week for a given customer and consolidates all orders into one order for once a week delivery. This was written for a customer that needed this functionality in which brought in a two hundred and fifty million dollars contract to Staples over the next five years. This process is being rolled out to additional Staples customers. This process saves Staples monies in that they are delivering once a week and the boxes delivered are decreased due to the consolidation of the orders.

    Re-wrote the Staples Contract Pricing Engine to adhere to new Staples standards. Added additional pricing functionality for Staples Contract line of business to maximize margin on products. They include but not limited to the following;

  • Primary and Secondary off-contract pricing for Staples and Wholesaler Skus.
  • E-Diversity Pricing
  • Cost Plus, Fixed Price, List Less with Cap, List Less, Range with List Cap, Range and Matrix Column
  • Promotional Pricing
  • Hinge Pricing
    •

    Enhanced the feeds to Staples Link, which is the order entry system for Staples Contract line of business over the web. This includes product loads sent to Link nightly. It also included the feeds for creation of Orders which happen on the AS/400 via MQ.

    Designed and implemented an interface for credit card orders to the ClearCommerce fraud detection engine. ClearCommerce is a Third Party Unix based system which utilizes Java API to communicate with other platforms. I was responsible for the design/creation/implementation of an RPG ILE program, which calls numerous AS/400 Java methods on the AS/400. The Java program is a compiled Java program that runs on the AS/400. I had to create numerous fixes/workarounds to accomplish this because of bugs in the IBM RPG to Java interface. The garbage collector did not work like it was suppose to. This brought the Chargebacks from 1 million six hundred thousand dollars a month to fewer than fifty thousand dollars per month.

    Made modifications to the Staples Contract front-end system and Staples Direct front-end system for a consignment project which allowed Staples to take products on Consignment from there vendors. The modifications were to introduce the cost of the item at the time of the sale. Consignment costs are held on the back end systems. This resulted in over one hundred million dollars in saving for Staples in the first year alone.

    On a daily basis, perform bug fixes and production issues relating to the Staples Contract line of business.

 9/00 – 10/01 SMARTIN Inc., Cranston, RI – Software Solutions Provider Independent Consultant At Iron Mountain

    Maintenance and enhancements of the client's Safe Keeper Internet product. This software allows certain customer to view their cartons and files on line and run reports over them.

    Implementing Microsoft Site Server 3.0 as the client’s Portal site for the Intranet and Extranet. Created a whole new suite of graphical interface pages over the site server database. We only used the database and created our own Iron Mountain pages over the database. Heavy use of CDO, MTS objects and Java Script. Created dynamic pages that changed on the client, not the server.

 10/99 – 9/00 EDP Contract Services, Needham, MA – Software Solutions Provider Independent Consultant At TAC Worldwide Companies
    Maintenance and enhancement of the client's nine business unit web sites which are used for Internet recruiting. There is also an operational web site which is used to customize the client's nine web sites. The web sites are three-tiered enterprise-level Internet web sites that are completely database driven. The sites are developed using Windows NT/ IIS / MTS / ASP / COM / DCOM / Sql Server / Stored Procedures / Visual Basic and ActiveX DLL's. It also encompasses feeds to multiply legacy systems and outside recruiting companies. For example DICE, Monster and Hot Jobs.

    Also, maintenance and enhancements of an Internet enabled invoice lift product called Tacworks. Tacworks is the requisitioning and invoicing system-of-record for TAC’s largest customer. This product allows users to enter in workers and requisitions, which are then passed, backed to a people pac system. This product is also developed using Windows NT/ IIS / MTS / ASP / COM / DCOM / Sql Server / Stored Procedures / Visual Basic and ActiveX DLL's. This system processes 4M in weekly invoices and contributes several million dollars in revenue to TAC. There are numerous reports that are driven off the data in which individual workers for the company or outiside vendors can view.

    There is a complete security system built around each of the two products. Both products have numerous Email push functionality and also uses SSL.

    Proven ability to design, manage, develop, and deliver effective, timely, reliable, and maintainable mission-critical systems.

 11/98 – 10/99 SMARTIN Inc., Cranston, RI – Software Solutions Provider Independent Consultant At the Moore Company
    Carried several projects through their entire life cycle, which included submitting proposals to upper management, managing the project resources, coding the majority of the project, supervising user testing and training, and performing implementation and support. All the projects were performed in the century date compliant version of BPCS 4.05 CD and were completed under budget and ahead of schedule. The projects included the following;

  • Modifying BPCS to allow a supplier to ship goods on the same order to multiple addresses. The supplier can specify ship to addresses on a line by line basis. In addition, each line can have a different carrier and/or different freight terms. The modification allows invoices to be generated for like order number, ship to address, carrier terms, and freight terms, whereas base BPCS only allows invoice generation for like order number.
  • Modifying BPCS to allow a customer to take goods on consignment, an arrangement in which the supplier sends the goods to the customer but does not bill them. The customer then electronically sends the supplier an ASCII file, which lists lots that have been acknowledged (received), and whether the goods have been used. Billing takes place when the customer notifies the supplier that a lot has been used. The project included creating a program that alerts the supplier when goods have been at a customer for 45 days, a program that allows the supplier to bill the customer for a lot, a program that transfers the ASCII file from the PC to the AS/400. Also supporting reports that show goods that have not been acknowledged, goods that have not been invoiced, and the dollar value of unbilled goods at month end, and inquiry screens that display lot information including the shipped date, acknowledged date, used date, invoiced date, yardage, and extended price. This modification allows the goods not to be billed to the customer until one of the three conditions occur.
    Streamlining the packing line applications, which included the following projects:

  • Redesigning the packing slips to increase the number of rolls per packing slip and to include the actual roll width for specific customers. The increase of rolls allows the client to send pallets to its customers.
  • Streamlining the bill of lading system, which originally required four separate data entry operations to process each container. The redesigned system allows containers to be processed in one data entry operation.
  • Streamlining the bill & hold system, which allows the supplier to bill the customer but hold the goods. These modifications cut the average time to process a bill & hold packing slip from 20 minutes to 3 minutes.
  • Modifying BPCS/Home Grown system to allow the supplier to perform credit checking at the container, lot, or customer level. Base BPCS only allows credit checking at the customer level.
  • Implementing the current release of CDM. BPCS (4.05 CD) does not function as shipped; modifications are required.,
    Proven ability to design, manage, develop, and deliver effective, timely, reliable, and maintainable mission-critical systems.

1/98 - 11/98 SMARTIN Inc., Cranston, RI - Software Solutions Provider Independent Consultant At Chapman Equipment Rental Company
  • Developed a rental equipment management application using Microsoft’s Visual Basic 5.0.
  • Work closely with client to determine business models and future business needs.
  • This product extensively used ODBC API calls to the database.
    • 3/97 - 10/98 P A Consulting and Analysis Corp., N. Attleboro, MA - Software Solutions Provider Independent Consultant At DuPont Merck Pharmaceutical Company
  • Successfully implemented a Year 2000 project for a global pharmaceutical products company for both their North American and European divisions.
  • Converted RPG, CLP, display files, print files and AS/SET Action Diagrams using NEXGEN’s Focus/2000 conversion tool. Overall, the North American phase of the project required the conversion of nearly 6,000 objects. The European phase of the project required the conversion of nearly 1,000 objects.
  • Contributed to the development of the AS/SET and RPG versions of Focus/2000.
  • Met all project deadlines and completed the project under budget.
  • Performed quality assurance review for project programmers.
  • Worked closely with upper management to ensure the availability of the resources necessary to meet all deadlines and provide continued support.
  • Was responsible for the testing and support of converted programs during the user acceptance testing, integration testing, pre-implementation and post-implementation phases of the project.
    • 7/92 - 3/97 QCC Inc., Westwood, MA - Software Solutions Provider Worked closely with the product development staff of System Software Associates (SSA) to define and plan projects associated with QCC’s Advance Remittance Processing(ARP) and Credit and Deduction Management (CDM). These products were sold to SSA as BPCS modules and were supported by QCC. The products were designed using AS/SET, an AS/400 case tool that can generate both RPG/400 and UNIX code. In addition to the interactive and batch programs designed using AS/SET, numerous CLP programs and some RPG programs were written to take advantage of AS/400 functionality not supported in the case tool.

    Proven ability to design, manage, develop, and deliver effective, timely, reliable, and maintainable mission-critical systems.

    Project Manager/Consultant
  • Served as Project Manager/Senior Technical Advisor for a project that involved interfacing ARP and CDM to BPCS Accounts Receivable, Multi Currency, Order Entry, and CEA, Configurable Enterprise Accounting, the new G/L module for BPCS 6.0 and beyond. It was the first release of BPCS to make extensive use of imbedded SQL and it was there first century date compliant release before 4.05CD.
  • Designed, developed, implemented, supported and user trained CREDT, a deduction management application. The product was also sold to SSA and private labeled as CDM, a BPCS module. As the primary liaison between QCC and SSA, I approved enhancements and provided product support. The product is sold worldwide and has been installed at more than 250 sites.
    • Senior Programmer/Analyst
  • Designed, developed, implemented, supported and user trained enhancements for AutoClear, an automatic cash application system. The product was also sold to SSA and private labeled as ARP, a BPCS module. I was primarily responsible for modifying the product to look and feel like a BPCS module. The product is sold worldwide and has been installed at more than 250 sites.
  • Completed a four day class for Powersoft’s Fast Track to PowerBuilder.
  • Was responsible for the complete life cycle of the following internal products:
  • A change management application that extracts information from the AS/SET repository.
  • An application that uses information from the change management system to track and produce Program Temporary Fix (PTF) and new release tapes for QCC and SSA.
  • An application that generates temporary and permanent software access keys for QCC products. The keys allow sales personnel to track user base information and maximize product revenues.
    • 6/89 - 7/92 Trina Inc., Fall River, MA - Manufacturing Company Programmer/Analyst
  • Designed, developed, implemented, supported and user trained an automatic scheduling system, a spoilage and substitutions system, and a charge back system for accounts receivable.
  • Redesigned, developed, implemented, supported and user trained the company’s existing purchase order system.
  • Served as the backup support person for the company’s EDI application.
  • Gained experience with Wang-VS65, RPGII, and COBOL.
  • Worked daily with Accounts Receivable, Accounts Payable, Sales, Production, Payroll, Finished Goods, Raw Materials, and Work In Process Inventories applications as necessary.
    •

    Education 9/85 - 5/89 Rhode Island College, Providence, RI.

    Bachelor of Science, Computer Information Systems. Other Accomplishments Wrestling Team, Captain. Four-time NECCWA Champion. Two-time NCAA Division III ALL AMERICAN Wrestler. Heatherman Award Winner. Dean’s List.
    Member number:2634
    Additional Contact information is available on the Information Page.
    The Software Contractors' Guild (www.scguild.com).
    Copyright(c) 1998 Scott Martin and The Software Contractors' Guild, Post Office Box 257, Nottingham, NH USA 03290-0257