SUMMARY:

• Keith is a seasoned AS/400 programmer with 25 years of experience that expands to business verticals ranging from manufacturing, health care, telecommunications and construction.
• Over 25 years’ experience with AS/400, ISeries, IBM i with a focus on database design and technologies.
• Over 17 years’ experience with SQL/400 as well as substantial experience with SQL Server and Oracle
• Technical lead on two BPCS data mapping/conversion projects.
• Experienced in data analysis, data modelling, Conceptual logical modelling and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems
• Strive to be flexible and impactful on positive project outcome.

TECHNICAL SKILLS:

Hardware: IBM ISeries, Windows Desktop/Server

Operating Systems: OS/400, Windows XP, DOS, Unix

Programming Languages: VB.Net, C#, Java, ASP.Net Visual Basic 6, RPG III/IV ILE, RPG Free, Synon, Cobol

Data Management/Database: DB2/400, Oracle, SQL Server, Access, IDMS, IMS, Mongo

Tools: and Utilities: SQL, XML/XLST, PL/SQL, Eclipse, Crystal Reports, Hyperion/Essbase, Stratum Data Warehouse, Hibernate

PROFESSIONAL EXPERIENCE:

Confidential, IA

Database Administrator

Responsibilities:

• Lead analyst and designed software and database to support Confidential ’s Critical Incident Stress Management (CISM) division.
• The application could create an event that spanned multiple locations and at each location multiple activities could be hosted in response to the event. Those activities could be training, CISM counseling, etc. Multiple Providers could be extended offers per activity.
• Provider time tracked. Follow - up metrics tracked for participants and provider payments issued. Worked with various groups to create requirements document. Produced UML and developed a prototype to confirm user requirements.
• Developed data model and RDB schema. Wrote DDL to produce schema. Created the object model in Hibernate. Wrote maintenance applications in Java/Seam. Implemented project. Created all AS/400 SQL views and stored procedures used by the application. Analyzed existing application using SQL.
• Designed/Developed Outlook Calendar application using VBA and C#. Using this tool, the user can schedule text messages/emails to be sent as appointment reminders.
• Identified network equipment operations required to access GSM network. Wrote the C# application that accessed the outlook object model to obtain the appointments on the calendar. Wrote AS/400 RPG Free embedded SQL stored procedures that sent the email appointment reminder.
• Technical lead on CBOR conversion. CBOR is Confidential 's customer/contract master. Did analysis for conversion using SQL Wrote DB2 RPG Free stored procedures programs to map AS/400 data. Wrote various tools that modified AS/400 DB2 DBMS system catalogs to clean up foreign key constraint errors after a partial clear.
• Provided general maintenance for IP module. Worked with Claims and Providers to accomplish goals.
• Provided general maintenance/Support for Auth Feed. Familiar with Confidential 's EHR, Provider module and Claims.

Confidential, MO

Senior Software Developer

Responsibilities:

• Did analysis for and designed/implemented G/L data warehouse cube using Hyperion/Essbase. Wrote data warehouse feeds using SQL DB2/400 stored procedures to map data to data warehouse. All analysis done using SQL.
• Worked with consultant to develop Sales/Inventory cube using Hyperion/Essbase. Wrote data warehouse feeds using SQL DB2/400 stored procedures to map the data.
• Technical Lead on Data warehouse project. Worked with consultants to implement Stratum Data warehouse. Wrote data warehouse feeds using SQL DB2/400 stored to map the data.
• Designed and coded a CRM application using ASP.Net. Used by Sales people to track customer calls. Review customer information before sales calls, etc. Iseries DB2 database used, with stored procedures as method of interaction.
• Designed and coded a production entry application for shop floor production reporting. Written in VB6 and uses Iseries DB2 and interfaced with PRMS. Simplified production reporting and made production values available real time.
• Technical lead on implementation of new ERP application ERP/LX (BPCS). Analyzed data mapping differences in coding and metrics. Wrote conversion programs. Rewrote data AS/400 warehouse feeds. Customized BPCS applications to fit ABMAURI manufacturing environment.
• Designed and coded a Laboratory Quality application. This application provided an easy, centralized application for the Laboratories to enter testing information related to the production of yeast. From this application quality factors and trends could be analyzed and identified. Also, it generated Certificates of Analysis for lot/batch production for recall tracking. Application was written in vb.net and Crystal Reports. Data accessed using AS/400 DB2 stored procedures.
• Wrote various development utilities using OS/400 API's mostly for database analysis and for object usage analysis. These tools also took advantage of Hawkeye relationship information.

Confidential, MO

Consultant

Responsibilities:

• Wrote development utilities using RPGIV and OS/400 API's that provided module/service program use information.
• Participated in a project that replaced standard AS/400 RPG reads for tables with an AS/400 SQL API. Wrote the sort procedure that provided ad hoc sorting of result tables. Worked on repairing SQL API in preparation for production.
• Provided general support for order entry system.
• Wrote test cases and provided system documentation for project.