Systems Analyst Programmer
| Industry Focus: | Information Technology, Healthcare & Medical, Manufacturing & Production | Title: | Systems Analyst Programmer | |
| Experience: | 21+ Years | Position Type: | Full-Time, Any Position Type | |
| Education Level: | 4-Year College Degree | Security Clearance: | None | |
| Relocation: | Any Location | Travel Preference: | No Preference | |
Edgar Lawson Bolton
Systems Analyst / Computer Programmer / Software Engineer
Physical - 3002 Shreveport Hwy, Pineville, LA 71360 Home: 318-640-6933 Cell: 318-210-9384
Mailing - PO Box 416, Tioga, LA 71477
Email: boltone@hotmail.com URL: http://www.4jobs.com/BoltonEdgar
Current NON IT POSITION: Home Depot Merchandising Execution Team Associate, TN and LA Feb ''10 – Present
Product presentation and customer service utilizing First-Phone/Mobile-Cart technology.
CAREER TRACK --- FULL TIME POSITIONS
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 utilize 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.
Non-work-related VFP-SOAP, AJAX familiarity for .NET data store authentication and password retrieval.
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.
Completely transitioned AMCTIMER, AMCRON, and GATECRON claim and remittance advice processing from BBS to the Gateway, providing improved stability and saving the EDI department $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.
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.
Performed ProfitKey support duties using COBOL programming (RMCOBOL-85) 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.
Established in-house Minolta document imaging, eliminating outsourcing costs and creating $3.3K in annual savings.
Developed a financial tax form 5112 reporting system for tax preparation usage (VFP). 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.
CAREER TRACK PART TIME POSITIONS - DBA - Bolton and Associates
Faith Baptist Church (Theresa theresacrichardson@hotmail.com) IT Chairman 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 Feb ‘10
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.
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
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.
