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…
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
|
