About

My name is Franklin Jones.  I love long, moonlit walks on the … oh wait … wrong about page!

All seriousness aside. I am a devoted husband and father of three. I have been a software developer for most of my adult life. I love to design software. I love to write code. I love to talk about software. If I’m lucky people will even talk back to me!

Here you can find various bits of info about me…

profile for krawl at Stack Overflow, Q&A for professional and enthusiast programmers
View Franklin Jones's profile on LinkedIn

Download Resume in PDF Format
 

Download Resume in WORD Format

Summary

  • Fourteen years experience in information technologies
  • Self motivated and hard working
  • Ability to work with little or no supervision or within a team environment
  • Experience leading enterprise level solutions
  • Experience designing and implementing databases
  • Expert level T-SQL skills
  • Excellent verbal and written communication skills

Technologies

Languages C#, VB.NET, ASP.NET, HTML, CSS, jQuery/javascript, VB 6.0, ASP, XML, VB, Script, Java Script
Packages SSIS, SSRS, Visual Studio, Visual SourceSafe 6.0d/2005 MS Office, Visio, Project, Crystal Reports 8.5/10, Adobe PhotoShop (limited)
Operating Systems Windows 8, Windows 7, Windows Vista, Windows XP, Windows 2000, Windows NT, Workstation, Windows 98SE, Windows 95, Windows 3.11, MS DOS
Servers SQL Server, IIS
Other Dependency Injection, MVC, Entity Framework, ReSharper, MV.NET, dotPeek, RedGate SQL Backup, RedGate SQL Docs, RedGate SQL Prompt, RedGate SQL Compare, Telerik User Controls, ExactTarget Email Marketing, Meridian Systems Proliance, Visual Studio Tools for Office, Web Services, Infragistics DataGrid, Krypton User Controls

Professional Experience

02/13 – Present :: Programmer
Client Services, Inc., St. Charles, MO

Technologies #, ASP.NET, Windows Service, SSIS, Red-Gate Tools, SQL Server 2008 R2
Responsibilities Duties include various aspects of the development process from supporting existing solutions to creating new solutions and developing new standards for use in development.

  • Created a SQL standard used by the development team to aid in consistent SQL development practices.
  • Added new functionality to existing telephony application to enforce the dispositioning of inbound calls.
  • Implemented a new process to create real-time communication between a value based database system and an Aspect automated dialer system
  • Created various SSIS packages to perform data imports/exports for various systems
  • Perform roles as database administrator for five database servers
    • Monitor backups and system performance
    • Manage permissions
    • Migrated existing user permissions to active directory role-based permissions
    • Publish changes from development to production
  • Mentor existing developers in the technologies in use and the business processes
  • Maintain existing public facing WordPress sites
  • Work with various individuals from different teams (network services, admin, operations) to test and publish new releases of applications
  • Created documentation of new and existing systems and processes

05/12 – 01/13 :: Senior Software Engineer
SyllogisTeks, Chesterfield, MO

Client Cass Information Systems
Project Global
Description The Global Processing System uses complex database driven rules to verify billing for various clients in the transportation industry
Technologies SQL Server 2008 R2
Responsibilities Developed new processes using stored procedures and maintained existing processes to import data and process rules against that data on a daily basis

05/11 – 04/12:: Senior Applications Developer
AVALA Marketing Group, Inc., Fenton, MO

Project Title eConnect Customer Service Index
Description The eConnect Customer Service Index (CSI) provides survey processing functionality to various companies
Technologies C#, ASP.NET, Windows Service, SSIS, SQL Server 2008 R2
Responsibilities Designed and developed several aspects of the system including a job processing windows service, SSIS packages to import and process various data files, validation stored procedures to validate and clean data being imported into the system and a user interface to build surveys to be printed and displayed online for end user processing.
Project Title eConnect Lead Management System
Description The Fleet eConnect Lead Management System provides a lead management solution to various companies
Technologies C#, ASP.NET, Windows Service, SSIS, SQL Server 2008 R2
Responsibilities Responsibilities on this solution are primarily supportive. Adding functionality as the need arises

2/10 – 04/11 :: Owner and Developer
Blue Collar Development, LLC, O’Fallon, MO

Overview As an owner and developer of Blue Collar Development my responsibilities depend on the current client and project. These responsibilities include any aspect of software development: project management, requirements gathering and documenting, solution development, testing and deployment.
Client J.W. Terrill
Project Sagitta Reporting Tool
Technologies ASP .NET (v2.0), SQL Server 2005, C#
Responsibilities Created a solution to retrieve information from a third party via web services. The solution included scheduled jobs to retrieve data which was then stored in a Sql Server and viewed using a web front end.
Client Byrne Software Technologies, Inc.
Technologies WinForms VB.NET (3.5), Development Tools for Office, Meridian Systems Proliance
Responsibilities Developed several applications to integrate business processes with Meridian Systems Proliance

11/08 – 02/10 :: Programmer Analyst
American Railcar Industries, Inc., St. Charles, MO

Technologies ASP .NET (v2.0), SQL Server 2005, SQL Server 2008, SSRS, SSIS
Responsibilities I was responsible for the support and maintenance of several pre-existing Fleet Management systems. These systems included a mechanical system to track and report various data on railcars, a shopping system to track and report on maintenance work performed on a railcar, a data warehouse to provide various reporting needs to the Fleet Management group.

7/07 – 10/08 :: Programmer Analyst
Byrne Software Technologies, Inc., Chesterfield, MO

Client CB Richard Ellis
Project Titles
  • Invoice Quick App: Provides customer with quick entry of invoices into Proliance
  • Commitment SmartDoc: Provides customer with quick entry of contracts and change orders into Proliance.
  • Schedule Upload Quick App: Provides customer the ability to import Microsoft Project files into Proliance.
  • Budget/Transfers SmartDoc: Provides customer the ability to create budgets in Proliance.
Technologies WinForms VB.NET (2.0), Development Tools for Office, Meridian Systems Proliance
Responsibilities I was responsible for the initial gathering of requirements and documenting them and for designing and developing the systems. Responsibilities currently include the support and maintenance of the production system
Client Westfield UK
Project Titles
  • Invoice Quick App: Provides customer with quick entry of invoices into Proliance
  • Proliance MessageBus Integrations: Automated integration of Proliance and 3rd party applications.
Technologies orms VB.NET (2.0), Web Services, SQL Server 2005, Meridian Systems Proliance
Responsibilities I was responsible for the initial gathering of requirements and documenting them and for designing and developing the systems. Responsibilities currently include the support and maintenance of the production system

7/00 – 7/07 :: Senior Programmer Analyst
Forest Pharmaceuticals, Inc., Earth City, MO

Project Title Fleet Website
Description The Fleet Website was developed to provide all drivers of the company leased vehicles a method to view information regarding their leased vehicle. It also provides a means for the Fleet department to provide information regarding various fleet related policies.
Technologies WinForms VB.NET (1.1), ASP .NET (v2.0), SQL Server 2000
Responsibilities I was responsible for the initial gathering of requirements and documenting them and for designing and developing the system. Responsibilities currently include the support and maintenance of the production system.
Project Title Returns Processing System (RPS)
Description The Returns Processing System was developed to provide the Credit department with a means to price returns processed by a third party vendor. The system also interfaces with SAP sending it all the pricing information via sales documents so payment processing can occur in SAP.
Technologies WinForms Visual Basic .NET (v1.1), Crystal Reports, SAP, SQL Server 2000
Responsibilities I was responsible for the initial gathering of requirements and documenting them and for designing and developing the system. Responsibilities currently include the support and maintenance of the production system including adding new functionality as the user requests.
Project Title Lockout/Tagout (LOTO)
Description The Lockout/Tagout application was developed to provide manufacturing with a means to manage and report on all their lockout/tagout procedures.
Technologies ASP.NET (v1.1), Crystal Reports, SQL Server 2000
Responsibilities I was responsible for the initial gathering of requirements and documenting them and for designing and developing the system. Responsibilities currently include the support and maintenance of the production system including adding new functionality as the user requests.
Project Title Fleet Management System (FMS)
Description The Fleet Management System was developed to provide the Fleet department with a means to track and maintain over 3000 leased vehicles. The system also interfaces with SAP to process bills.
Technologies WinForms Visual Basic .NET (v1.1), Crystal Reports, SAP, SQL Server 2000
Responsibilities I was responsible for the initial gathering of requirements and documenting them and for designing and developing the system. Responsibilities currently include the support and maintenance of the production system including adding new functionality as the user requests.
Project Title Automation of Reports and Consolidated Order System (ARCOS)
Description ARCOS automates the reporting of the movement of controlled substances. It interfaces with SAP getting the movement information and provides several reporting options for generating reports and cover letters for the federal DEA and several state DEAs.
Technologies ASP 3.x, Visual Basic 6.0, Crystal Reports, SQL Server 2000
Responsibilities I was responsible for the initial gathering of requirements and documenting them and for designing and developing the system. Responsibilities currently include the support and maintenance of the production system.
Project Title Forest Contract And Rebate System (FCRS)
Description FCRS tracked and maintained all contracts on the products sold by Forest. It was also used to process chargebacks on products purchased at wholesale price. This system interfaced with SAP by saving all the contracts to SAP and by sending the chargeback information for payment to the various customers.
Technologies Visual Basic 6.0, ASP 3.x, Crystal Reports, SAP SQL Server 7.0
Responsibilities I was responsible for the support and maintenance of the production system. These duties included:

  • Developing a process to notify wholesalers of contract and member changes via EDI
  • Developing a process to notify wholesalers of chargebacks via EDI
  • Upgrading client side use of Crystal Reports to a web-based Crystal Reports solution.
  • Developed and maintained internal web applications for contract and rebate system.

4/99 – 7/00 :: PC/Networking Administrator
Forest Pharmaceuticals, Inc., Earth City, MO

Technologies Windows NT 4.0 Server, Windows NT Workstation, Windows 2000, Windows 98, Windows 95, Windows 3.11
Responsibilities Along with one other individual I supported and maintained over 150 Windows 3.1/9x/2000/NT workstations and 13 Windows NT 4.0 servers. I also supported and maintained over a dozen printers connected to the network. Other duties included:

  • Developed and maintained documentation of all workstation, network and server tasks
  • Installed and maintained Omtool’s Fax Sr. network faxing solution
  • Played a key role in analyzing and upgrading all software and hardware on network during Y2K.
  • Installed and maintained a Microsoft DNS server
  • Installed and maintained a Microsoft Proxy server
  • Wrote and maintained Visual Basic application for asset tracking