iStaff - Atlanta, Georgia -- Jun 2016 - Present -- Microsoft Access Application Developer
Client: Mitsubishi Electric Cooling & Heating .
- Provide Supply Chain data analysis, and rapid application development, including:
- Operations Assistant, a customer claims management system designed and deployed in three weeks that integrates data from SAP and SalesForce, which will net six figure savings in the first year and seven figure savings in the next few years
- CPFR Reports, a Collaborative Planning, Forecasting, and Replenishment (CPFR) System that will help customers better manage their inventory
- o Planning Assistant, a PSI (Purchase, Sales, and Inventory) Planning System that brings together all information pertinent to the demand planning process, allowing the planning team to produce more accurate forecasts
- Tools: MS Access, VBA, MS Excel, MS SQL, QlikView, and SAP
Self-Employed Consultant - Atlanta, Georgia -- Dec 2015 - Present -- MS Access/VBA Developer, Data Analyst
Client: 2Plus, Inc.
- Provide ad hoc reporting, application development, and data analysis.
- Tools: MS Access, VBA, MS Excel, and SQL.
ECS Team - Atlanta, Georgia -- Apr 2015 - Jan 2016 -- Technical Business Analyst
Client: Cricket Wireless
- Supported major infrastructure change for Cricket Wireless.
- Tools: MS Excel, VBA, Visio, Spark Enterprise Architect
2PLUS, INC - Atlanta, Georgia -- Jul 2014 - Apr 2015 -- Program Analyst and RidePro Manager
Client: Georgia Commute Options
- Provided data analysis and application development in conjunction with RidePro rideshare management software
- Tools: MS Access with Microsoft SQL backend, MS Excel, MS Word, MS Outlook, and VBA
THE CLEAN AIR CAMPAIGN - Atlanta, Georgia -- Dec 2009 - Jun 2014 -- Business Analyst / Systems Analyst
- Developed Salesforce application and MS Access applications for managing commuter rewards programs in conjunction with CommuteTrak rideshare management software
- Tools: MS Access with PostgreSQL backend, MS Excel, MS Word, MS Outlook, Access VBA, and SalesForce
AVITA COMMUNITY PARTNERS - Flowery Branch, Georgia -- Feb 2005 - November 2009 -- Operations Analyst
- Provided data analysis and MS Access application development, tying three disparate systems and multiple data sources together through Access databases
- Tools: various combinations of MS SQL, MS SQL Reporting Services, MS Access, Visual Basic, MS Word, MS Excel, and Crystal Reports.
CONSULTANT (Self-Employed) -- Sep 2001 - Jan 2005
- Provided small businesses with part time IT management, small application development, and website development on an as-needed basis.
- Tools: Visual Basic, MS Access, Netscape Composer and HTML for web development
PRIOR PROFESSIONAL EXPERIENCE
- After a term of service in the US Army, worked as a DP Manager, learned to program IBM Midrange Systems using RPG, then worked for three different software companies before starting a consulting business that supported small companies needing software development and on-call IT management. Later worked as an IT Director for a catalog/mail-order company, followed by RPG development opportunities in manufacturing and telecom.
- Tools: RPGII, RPGIII, RPG400, RPGIV, RPGILE, dBaseII, C, and SQL.