Assignment to Oklahoma State Office of Finance System Management - Authorizations, User, Display, Printer, Writer, Users Setup, FTP/TCPIP communications configurations. Software Development/Maintenance - WDSC, RPG FREE, RPG ILE, CLLE, Service Programs, APIs, BCD PROGEN WEBQRY DB2, and SQL (Embedded and Interactive). Project Management V5R4 to V7R1 (3/11), Date field conversions, and Standards for program architecture design, database normalizations standards, unit testing, user testing, and implementation. Mentoring: System Admin, CL programming, FTP scripting and AS/400 Concepts. (Open) project SQL Usage in V7R1 Operating System – 2012.
- Implemented Embedded SQL in RPGILE programs (Reduced Files in F-specs, avoid locking issues, elimination of I/O hits, and eliminating OPNQRYF command usage)
- Utilized RUNSQLSTM in CLLE programs and SQL Statements in a Source Physical file...View. Cyber Security, Administration, Oracle PeopleSoft help desk, Design programming and project specifications. Liaison between Executive Director and three deputy directors.
Cyber Security
- Collaborated with OBON IT Security Officer to review existing security policies and develop new policies as needed while conforming to the Office of State Finance’s published Information Security Policies, Procedures, Guidelines, for the security of sensitive data
- Audited security logs as specified in IT Security Policy Evaluated security needs when/if new technology or services were added.
System and Application Support
- Maintained the integrity of the IBM I-Series (AS/400) platform Hardware and Client Devices; analyzed performance of disk drive and CPU throughput; customized devices based upon functionality and user requirement; supported the i5/Operating System and network; maintained PTF levels and i5/OS software compatibility; administered the TCP/IP protocol.
- Administered and managed the DB2 Universal Database for I-Series.
- Managed User Access to the ISERIES; modified and controlled user profiles based on personnel changes; maintained application software and data access using i5/OS authorization rules; installed, upgraded and maintained MS Windows Client Terminal and printer emulations; verified security and authority of external access through VPN, FTP, etc. Modified and maintained Application Software using PROGEN-PLUS program generator; developed, coded and implemented new apps in ILE Objects design. Developed and implemented data-sharing functions between DB2.
- Created and tested: user data entry screens, reports, query and navigation tools; preprocessors and edits, procedures for database loading and verification; procedures for periodic re-indexing (adding fields or edits, software version upgrades, etc.); performed backups/restores; and debugged problems.
Business Process Enhancements
- Developed and implemented business policies and procedures.
- Analyzed, recommended, and developed work flow tools, automation, and improvements to existing hardware and software architecture. DB rules applied to the ILE program automated CL process for table population for Data Dictionary, Reference, and transaction files. Use of Turnover and Hawkeye Change Management Systems.