Edgar Lawson Bolton

Systems Analyst / Computer Programmer / Software Engineer

Physical - 3002 Shreveport Hwy, Pineville, LA 71360 Home: 318-***-**** Cell: 318-***-**** Work: 318-

***-****

Mailing - PO Box 416, Tioga, LA 71477

Email: wywohl@r.postjobfree.com URL: http://www.4jobs.com/BoltonEdgar

Cellular One (MTPCS) MS-Office/Excel/VB6 NOC/Switch Tech I June 14, 2012 -

present

Network Operations Center switch tech for cellular technology and Alert Notifications presentation. (Full

Time some-IT)

The Home Depot Merchandising Execution Team Associate, TN and LA Feb '10 – June 13,

2012

Product presentation and customer service utilizing First-Phone/Mobile-Cart technology. (Full Time non-IT)

Faith Baptist Church IT Chairman (Voluntary IT) Sept '09 to Oct ‘10

PC assemble/rebuild/Install maintenance and wireless networked. Set ‘MediaShout/PowerPoint’ Audio/Visual

presentations.

Kohler (Sheridan) Manpower Professional VFP9/MS-Access/Office/VB6/SAP Sr. Consultant Aug ’05

to Sept ‘09

VB MS-Access97 and T-SQL used to assist reporting Inventory System labels and cards. Working closely with

the accountant team, I created the VFP 9 Accounting Chart HTML/PDF EXCEL post automation from SAP text

dumps, freeing two man-hours daily. Advanced EXCEL and ACCESS detail: I automated HTML posting of

linked Charts from previous day SAP Cost Center text dumps for workstation activity management review.

This involved accounting calculations/formulas/lookup within a ‘master’ spreadsheet.

The VFP application automation was immolated via VB scripting (HTML_POST macro) within each

Cost Center spreadsheet for manual posting.

My most recent ACCESS program is used to perform Special Label Kohler site Inventory posting to

master multi-spreadsheets. (Part Time Contract - DBA - Bolton and Associates)

TN Mental Health and Developmental Disabilities (Sharon Hill – CIBER)

CIBER IT Contractor (Production and Test environments: XP Pro) Jan. ’08 to July ‘09

Converted FoxPro2.6/VFP6 Forensic from Oracle 8 BHIS to SQL Manager 2005. Maintained SQL’s to AVATAR

PM for Crystal Report 7 & XI for reports. VB-Script used for automatic nighttime processing.

I employ queries against SQL SERVER databases (TDMHDD AVATAR PM).

Non-work-related C#.NET and VB.NET (Visual Studio 2005) development included an Internet

Browser program and a Text find and modify application.

AllCare Pharmacy (WP Malone, Inc.)

Senior System Analyst Programmer Dec. ‘06 to Sept. ‘07

(Production environment: Desktop 2000 Professional networked to LINUX server.

Test environment: PC Windows 2000 Professional with network connection.)

IT team of three members. Program in Synergy/DE (DIBOL – like COBOL): Document PDF Pharmacy Reports

with MS-Office.

Validation tests to ensure quality.

Create “Packer Comment Message” system. Windows interface project used VBA/SQL for GUI

reporting operations.

Edgar Bolton

Non-work-related VFP-SOAP, AJAX familiarity for .NET data store authentication and password

retrieval.

Part Time Contract - DBA - Bolton and Associates (The Following Three Accomplishments)

Home Depot (Arkansas) Pomeroy POS Installer April ’06 to Oct ‘06

Precision Lighting (Hot Springs) PC repair / Network Admin./ Point / VBA Consultant April ’05 to Aug ‘06

Sunbay Resort (Hot Springs) MS-Access Database / Network Admin / IIS Consultant May ’05 to Aug ‘06

Arkansas Blue Cross Blue Shield

EDI Senior System Analyst Programmer Sept. '01 to Jan. '05

(Production environment: File Server 2000 professional networked to BBS/Gateway.

Test environment: PC Windows 2000 Pro and Laptop NT with network connection.)

Built, configured, and managed a Windows 2000 server. Automate an AMCTIMER application to handle all

EDI JCL scheduling. Enforced HIPPA compliant mandates for all Remit Advice, Claim, and ANSI X12 997

electronic data interchanges. Performed duties and prepared diagrammed Dataflow, technical processing,

and end-user documents with Microsoft Office Word, Access, Excel, Outlook, PowerPoint, Microsoft Publisher,

Microsoft Visio, Adobe Illustrator, and Paint Shop Pro. Used OOP VFP to develop FTP-CRON

(AMCRON/GATECRON) jobs for handling claims, messaging, and remittance advice; provided analysts with

VFP BBS and Gateway input/output processing tools. Devised and documented a Disaster Recovery Plan.

Create an integrated Excel 2000 to VFP database to gather information for report processes. Performed

several Gateway operations using NETX and Access 8.0 AIX; established and documented Gateway data

integrity using OOP VFP Exit-Firewall applications. Optimize DBMS dealing with MS-Access, Excel, and some

mainframe COBOL. The MOOGLE System provides the business solution for connectivity of partner,

customer, and supplier data and disparate platforms heterogeneous sources and technologies. Utilize

queries to SQL Server DB for problem solving. Applications include event scheduling and monitoring

programs via Visual FoxPro, VC++, and VB. In order to make transparent the mainframe/gateway boundary,

I developed JCL calls from within VFP. I conducted classroom instruction-demos.

Designed an SQL/FTP/JCL MOOGLE application to provide real-time EDI ERA system assessment,

which not only doubled the efficiency of EDI representatives (remit and claim research) and became the

ultimate solution for EDI customer inquiries, but also saved the EDI department over $40K annually.

(AMCTIMER, AMCRON, and GATECRON)

I provided improved stability of the EDI procedures by completely transitioning claim/remittance

advice processing from the BBS to the Gateway. AMCTIMER, AMCRON, and GATECRON provided a saving

result for the EDI department of more than $16K annually. Developed recovery processes for tracking all

AMCRON/GATECRON claim/remit transfers.

Was a main contributor to developing “validate and deliver” applications (AMCRON and GATECRON),

which helped to establish new industry standards and suspend illegitimate endeavors, resulting in reduced

costs for all insurance policyholders.

Developed, using VFP, an automatic e-mail notification system to facilitate immediate response

requirements and automated scheduling of all EDI claim and remit program activity, eliminating the need

for the EDI programming staff to troubleshoot and producing substantial savings.

Chem-Fab Corporation (Triumph Group Company)

Microcomputer Information Systems Senior Systems Analyst 1997 to 2001

(Production environment: print/file server Windows 98 networked.

Edgar Bolton

Test environment: Windows 98 without network connection.)

Managed a 200+-node Ethernet comprised of Novell LAN, Risc6000, 2 NT, and a Linux Internet server.

Provide MI3MS Document Imaging support using SQLTALK Report Writer.

Designed a ‘tool information tracking system,’ (VFP) used as the main source of department

scheduling and acquisition, which allowed for infinite expansion limited only by hard drive capacity; the

application generated over $100K in revenue in the first two years and played a key role in enhancing the

company’s marketability. I conducted some classroom demonstrations.

I performed ProfitKey support duties using RMCOBOL-85 programming on the Risc6000 to report all

business information and indicators, which enabled the company to produce $3K in annual revenue;

customized the Risc6000 system for job scheduling of management reports with MS-Access and VBS.

I established in-house Minolta document imaging, eliminating outsourcing costs and creating $3.3K in

annual savings.

Used VFP to develop a financial tax form 5112 reporting system for tax preparation.

Create a job tracking reporting system for the HR load balancing procedure.

Assistant Management duties dealt with vendors/suppliers.

Prepared documentation, including DFD and ER diagrams with MS-Office and VISIO.

Maintained back-up and recovery tapes.

Communicated with end users to ensure their requirements were fulfilled.

Network security duty; including user accounts, groups, privileges, and access levels for all servers.

Chase Manhattan Mortgage Corporation of Monroe

Mainframe/Microcomputer Department Computer Programmer/Operator 1993 to 1997

(Production environment: print/file server OS/2 and Windows networked. 1985 to 1994 Troy &

Nichols

Test environment: Windows with network connection to test server.) Unisys COBOL

Lead in all phases of the system development lifecycle; encompassing analysis, design, coding, testing, and

implementation. Created and maintained FoxPro, MS Access, and SQL applications for mortgage Future-

Value calculations. Provided high-level specifications and detailed design charts, complete with end-user

documentation, for all MIS systems. Develop 25 FoxPro reports. Constructed one Informix Call Tracking

database GUI. File maintenance with C. Performed security duties as a second-level LAN manager;

supported an 800-node LAN with Ethernet connections across 22 Novell file servers.

Developed an internal department mail tracking system (MTS) with VB and FoxPro used to internally

scan, from department to department, the location of all vital mail parcels; the MTS produced internal

savings of $40K in the first two years.

Selected to serve as project leader for the creation of an employee job tracking help desk (JTHD)

application that used DBASE III and DataEase GUI for workload balancing and distribution for PC

maintenance schedules; the JTHD application reduced annual PC help desk operations costs by $30K.

Built a cursor and query library to facilitate application development in DBASE III; built classes to

facilitate application development in VFP 3.0.

Conducted a joint analysis and created a customer service tracking system (Fox 2.6), which

monitored all customer queries and responses.

EDUCATION, CERTIFICATIONS, AND TRAINING

NORTHEAST LOUISIANA UNIVERSITY, UNIVERSITY AVE. MONROE, LA

BBA Bachelor of Business Administration COMPUTER INFORMATION

SYSTEMS December 1991

BS Bachelor of Science AIR TRAFFIC MANAGEMENT May 1983

Edgar Bolton

Brainbench: Visual FoxPro 6.0; COBOL II Programmer Certificate New Horizons: Advanced Access 2000

CareerTrack: How to Manage Multiple Projects/Achieve Objectives Minolta: MI3MS3000 Document Imaging

One-On-One: MS Access 97 McCulley: ProfitKey AIX (IBM) Conference

CompuMaster: MS Windows Solutions Innovative: DataEase

Introduction/Intermediate

Micro: Clipper 5.2e Introduction/Intermediate HomeTech: MS Access 2.0 Advanced

IBM: Customizing OS/2 Flash: FoxPro 2.6 Codebook

TECHNICAL SUMMARY

Languages/Tools and Applications: ANSI C, C++, C#, Visual C++, VB 6.0, all VFP, HL7, HIPPA, COBOL, Visual

SourceSafe, MS SQL, Informix, MySQL, DataEase, DBASE III/IV, MS Access, all Visual FoxPro. Forensic Extract

SQL, Kohler Accounting Charts, MOOGLE, AMCTIMER, AMCRON, GATECRON, Tool Information Tracking

System, Mail Internal Tracking, Job Tracking Help Desk.

Operating Systems and Methodologies: Windows 2000/NT/95/3.x, DOS, OS/2, AIX UNIX/Linux. Internet

Technology, Visio, Reporting Tools, Report Writer, HTML, IIS, SAP, VBScript, JavaScript, VS.Net: VB.Net,

VC#.Net, SQL 2000, Visual Studio 2005, SQL Server 2005, BizTalk ’06, Synergy/DE.

Edgar Bolton

Contact this candidate