Systems Analyst

Steven L. McNabb

***** ****** **.

Mabelvale, AR 72103 acbynd@r.postjobfree.com Cell: 501-***-****

SKILL SUMMARY

Languages: SQL, RPG/400, RPG/ILE, RPG/36, CLP, DTS, VBScript

Software: Crystal Reports, MS SQL Server, Query/400, MS Office,

HIS/ODBC, Windows

Databases: MS SQL2005, MS SQL 2003, Microsoft Access

Platforms: Relay Health (McKesson CECC), NextGen

WORK EXPERIENCE

Tek Systems (May 2013 to August 2013) Northrup Grummond - SQL Database

Administrator

. Running scripts from developers to fix database issues/errors.

. Analyze and troubleshoot system database error logs

. Maintained standards as defined by client (reviewing developer code to

ensure standards are met).

Baptist Health System (July 2007 to May 2013) Systems Administrator

. Responsible for overseeing implementation of Relay Health

software/hardware upgrade.

. Responsible for overseeing implementation of interface between NextGen

and Relay Health software.

. Responsible for maintaining multiple databases. These databases include

those used to control work flow as well as those used for analytical

reporting

. Perform systems analysis to determine the most efficient method of

collecting data and preparing reports. This includes analyzing existing

process to determine if improvements are warranted. It also includes, in

some cases, recommending software upgrades or new software to be more

efficient.

. Streamline existing processes using SQL stored procedures to automate

processes.

. Create reports using Crystal Reporting system and perform analysis of

data for accuracy. Review results of reports to determine trends that

are outside the norm.

. Document existing processes and systems.

. Serve as liaison between the users and the IT department.

Self-Employed Contract Programmer (October 2006 to June 2007)

. Maintain multiple clients.

. Support clients with MS SQL Server including working with Enterprise

Manager, writing queries, generating views, writing stored procedures,

general database analysis and troubleshooting.

. Generate client reports using Crystal Reports with data coming from a SQL

Server environment.

. Support clients with an AS/400 and network environment. Design and

develop new software and reports. Facilitated the transfer of data

between the AS/400 and the network through ODBC.

Eye Care Centers of America (January 1999 to January 2003) Senior

Programmer / Analyst.

1. Define, develop & implement new software on the AS/400. Modify existing

software on the AS/400.

2. Develop Crystal reports from AS/400 data utilizing ODBC.

3. Assist users with problem determination and general user support.

4. Train users on operation of the AS/400 and various software

applications.

5. Build stored procedures and DTS packages to support database conversion

in MS SQL2000.

6. Define file layouts and maps to support EDI processes.

M&M Computer Consultants (October 1997 to December 1998) self-employed

consultant.

7. Maintain multiple clients.

8. Develop & implement new software on the AS/400. Modify existing

software on the AS/400.

9. Perform general customer service for both hardware and software.

10. EDI using GENTRAN400.

Sage Energy Company (August 1996 to September 1997) Data Processing

Manager.

11. Perform general administration of the AS/400 including both hardware

and software.

12. Oversee consultants hired to work on projects.

13. Maintain communication with users and perform general user support.

14. Develop software and reports. Modify existing software, reports and

screens.

15. Perform regular maintenance / upgrades of hardware and software for

PC's.

QIV (June 1990 to July 1996) Programmer / Analyst.

16. Maintain multiple clients (AS/400 and S36).

17. Develop & implement new software, and modify existing software on the

AS/400 and S36.

18. Train users on general operation of AS/400 and on specific software

applications.

J.S. Associates (October 1989 to May 1990) Agent / System Engineer /

Programmer.

19. Support salesmen with sales calls. Perform needs analysis for sales

calls.

20. Perform customer support for existing customers. Maintain multiple

clients.

21. Train users on Query400.

22. Aid in support of customers along with IBM SE's. Develop & implement

new software, and modify existing software on the AS/400 and S36.

23. Perform file conversions.

24.

BESCO Supply (July 1989 to October 1989) Computer Operator.

25. General S36 operations.

26. Perform regular system backups.

27. Maintain communication with users and perform general user support.

28. Maintain hardware communications.

Municipal Software (June 1987 to June 1989) Programmer / Application

Installation Technician

29. Install municipal court and centralized cash receipts applications.

30. Train users on new software.

31. Modify software to meet customer needs.

32. Perform general customer support.

EDUCATION & TRAINING

B.S. Degree in Computer Science / Business - January 1987

Southern Nazarene University, Bethany, Oklahoma

Contact this candidate