Software Developer Data Analyst

Lawrence Nobs

*** ********** ****** – Wentzville, MO 63385

Phone 314-***-**** • Email ********@*****.***

Software Developer with over 30 years of experience

NISC - National Information Solutions Coop - Feb 2020 – Dec 2024

Data Analyst. PL/SQL Programmer.

ETL Specialist

Data Conversion

Data Migration

Oracle

SQL Developer

Linux

Pentaho

Successfully completed several of the most difficult data conversion projects in the department.

Created innovative PL/SQL programs which ensured balancing to the penny for millions of converted data records. Programs will save the company thousands of hours and dollars in the coming years.

Gained proficiency in PL/SQL through self-directed learning.

Nobs Databases & Programming - Mar 2017 – Dec 2024

Software Developer.

Microsoft SQL Server

Microsoft Visual FoxPro

Crystal Reports

T-SQL

MySQL

PHP

Completed several custom programming projects using Microsoft SQL Server, T-SQL, Microsoft Visual FoxPro, Visual AccountMate Accounting Software, and Crystal Reports.

Created Shopify interface system for AccountMate Accounting Software using Visual FoxPro and JSON.

Designed, programmed, and implemented an upgraded system for a physics metrology lab. The system provided increases in automation, efficiency, stability, and fault tolerance. The main functions of the system were work order processing, Excel automation and conversion to PDF files, web site MySQL updates and FTP to an internet server. Also used Chilkat software and C# console programming.

Designed, programmed, and implemented a sales commission system using PHP Runner software tool and MySQL database. Optimized the system for speed and rugged reliability.

Dohmen Life Science Pharmaceuticals (Nov 2016 – Mar 2017)

Programmer Analyst.

Microsoft Visual FoxPro

Microsoft SQL Server

Completed several custom programming projects using Microsoft Visual FoxPro with a Microsoft SQL Server.

Microsoft SQL Database contained private patient information, contact management, and pharmaceutical processing. The system was coded with SQL Stored Procedures and Microsoft Visual FoxPro.

Unlimited Prepay Distribution (Jan 2016 – Nov 2016)

Software Developer.

Microsoft Visual FoxPro

MySQL

PHP

Mirrored proprietary FoxPro data to web-based MySQL tables with Microsoft Visual FoxPro and SQL. Data was then visible with PHP.

Analyzed and removed hundreds of thousands of prior duplicate records.

Data contained typical accounting data from sales orders, accounts receivable, and inventory control.

Created sales commission processing program which organized and reported on, tens of thousands of commission records monthly.

Created prototype Big Commerce web site updated from Microsoft Visual FoxPro using a C# .NET API.

Tamlin Software Developers (Jul 2014 – Jan 2016)

Software Developer.

Microsoft SQL Server

Microsoft Visual FoxPro

Crystal Reports

T-SQL

Developed strategy to reduce food ingredient tracing for FDA recalls from hours to a couple of minutes.

Developed a sales reporting program to show floating quarterly sales in detail. Reduced the prior reporting program run-time from dozens of minutes to a couple of minutes.

Developed alternative program load method to reduce program load time from a minute to a few seconds.

Completed dozens of custom programming assignments using Visual AccountMate Accounting Software, Microsoft SQL Server, T-SQL, Microsoft Visual FoxPro, and Crystal Reports.

Completed several data migrations successfully from prior versions of AccountMate Accounting for SQL Server to newer versions.

Nobs Computer Services (Jun 1994 – Jul 2014)

Software Developer.

Microsoft Visual FoxPro

Microsoft FoxPro for DOS

Designed, programmed, and implemented custom business software for dozens of clients.

Heavily customized AccountMate Accounting Software for several clients. This was accomplished with Microsoft Visual FoxPro and SQL.

Performed full data conversion, data migration, ETL for dozens of clients.

Also created custom systems with Microsoft FoxPro for DOS.

Experience includes work with Sales Order, Accounts Receivable, Purchase Order, Accounts Payable, Inventory Control, Manufacturing, Bank Reconciliation, Payroll, Job Cost, and General Ledger.

Experience includes EDI and extensive report writing.

Contact this candidate