Sign in

AS/400 professional

Los Angeles, California, United States
January 30, 2018

Contact this candidate


Linda McKinney

**** ***** ***., **** *****, Ca. *1304

Home 818-***-****, Cell 818-***-****


IT Analyst with 20+ years of diversified technical experience bringing exceptional problem solving and customer service skills.

Technical Skills:

Hardware: IBM ISeries, IBM AS/400, IBM S/38, IBM S/36, SQL servers 2010 - 2014

Software: RDBMS, DB2, OS/400, Excel, Power Point, MS Word, MS Access, MS Project, Visio, SharePoint 2013,Turnover CMS, Hawkeye, Aldon CMS, SEU, DBU, DFU, RLU, SDA, VIEW, AFP, IFS, FTP, DDM, NGS IQ Query, NGS Qport, AS/400 Query, DB2 Web Query, ROBOT Automation Products, Client Access, ODBC, IBM ClearQuest CMS, Elixir Forms Pro DMS, FastFax, Cognos Impromptu,, HP Quality Center, Exstream DMS, Service Now, Perrigrine, and JIRA ticketing systems, Lotus Notes

Programming Languages Used: SQL, Embedded SQL, HTML,

RPG II, RPG III, RPG IV, RPGILE, RPG Free, Stored procedures, Service Programs, CLP, CLLE

Employment Summary:

6/2013 – 8/2017: Business Analyst IT – Lender Services

National General Insurance, West Hills CA

Business Type: Mortgage Loan Insurance tracking

Primary duties:

Respond to internal customer helpdesk tickets and track issues to completion.

Creation of custom control reports over multiple platforms to analyze business processes for mortgage lenders using SQL 2014. Platforms include AS/400-Iseries, CCS IBM mainframe, Rembrandt DMS, and Track Source DMS systems.

Create SQL Ad-hoc query reports for line of business teams to identify data and logic issues.

Coordinate with IT Developers and stake holders to provide data for production changes and business requirements.

Assist in projects to create and validate QA test cases for user acceptance testing.

Develop and maintain the ISA user request ticketing site working with SharePoint software. Assist other mortgage lender groups in developing SharePoint team sites for daily work activities.

Write and maintain system documentation.

Conduct business analysis to help identify business rules and process gaps.

3/2013 - 6/2013 - Contractor – iSeries Report writer

Universal Music Group (UMG), Woodland Hills, CA

Business type: Music Corporation

Run daily reports and monitor systems during corporate transition.

Add users to authority lists for access to various systems.

4/2012 - 1/2013 - Contractor – Sr. RPG Programmer/Analyst – Loan Servicing Team

Bank of America, Simi Valley, CA

Business Type: Mortgage Lending

Responsible for ISeries Analysis and development to enhance the current 1099 tax reporting system in the Mortgage Lending line of business area. This includes:

Analyzing the current 1099 system that produces tax forms for various types of mortgage loans.

Coordinating all program enhancements with varying application development teams involved in regulating current line of business process changes. Teams include .NET, SQL Server, and iSeries teams.

Participate in Business requirements, High Level and Low Level design documentation.

Participate in code reviews, unit testing, and full life cycle of assigned objects. .

Modify, develop, and maintain program code changes using RPGLE, CLLE, Stored procedures, and SQL to multiple iSeries systems. Implement projects to test, QA and production environments utilizing Turnover CMS.

Create queries on multiple environments to ensure data accuracy.

4/2011 – 10/2011 Contractor – Sr. RPG Programmer/Analyst – PLS DEV Team

Bank of America, Agoura Hills, CA

Business Type: Mortgage Lending

Responsible for providing ISeries Development support and programming for PLS, CL loan boarding application systems.

Analyzing non-I Series loan origination data that is dropped into IFS folders and processed by RPG programs. These programs update multiple Iseries master files through DDM connections.

Provide support to QA team for project testing on iSeries test systems

Participate in code reviews, unit testing, and full life cycle of assigned projects.

Modify and maintain program code changes using RPGLE, CLLE, Stored procedures, and SQL to multiple iSeries systems for varying projects. Implemented projects to test and production utilizing Turnover CMS.

1999-2010 Sr. RPG Programmer/Analyst

Republic Indemnity, Encino, CA

Business Type: Worker’s Comp Insurance

Responsible for development and maintenance of the Policy management system using RPG II, III, IV, ILE, CL, SQL, embedded SQL, IQ Query, Qport, Elixir Forms Pro DMS, FTP, ODBC, and Aldon CMS, Lotus Notes.

Primary focus was to build and maintain the policy pricing applications to provide an effective interactive tool for the Underwriting department to price policies. Main priorities were in the areas of loss rating, dividends, submissions and logging, loss control.

Consult with users and management to identify current and future processing needs.

Analyze, review, and modify current programs to adapt to new requirements and industry regulation changes.

Write documentation to describe program development, logic, coding and corrections. Train users on new system enhancements.

Maintain internal website.

1998-1999 RPG Programmer/Analyst – Shield Healthcare, Valencia, CA

Business Type: Health Care product supplier

Assisted in the planning, development and implementation of the Y2K system conversion project using referential integrity and trigger programming. This included full testing of applications and systems across multiple iSeries platforms. Implemented projects to test and production utilizing Turnover CMS.

1997-1998 Programming Operations Analyst – Circuit City, Richmond VA

Business Type: Retail Electronics Merchandise

Analyze user requirements, procedures, and problems to automate nightly processing utilizing ROBOT automated software on multiple AS/400-iSeries environments.

Create user requirements, functional requirements, and identify steps required to develop or modify computer programs.

Upgrade computer systems and correct errors to maintain systems after implementation.

Used Lotus Notes as email system and some reporting requirements.

1992-1997 RPG Programmer/Analyst

The Reciprocal Group, Richmond, VA

Business Type: Malpractice, HMO, Worker’s comp. Insurance Company

Modify and maintain existing RPG programs. Design and implement user menus, screens, report layouts, subfiles, PF/LF files.

Create Ad-hoc user reports utilizing NGS I.Q. query software. Transferred data between the PC networks and the AS/400.

Develop and support databases using MS-Access. Provide technical support and training to in-house users. Automation of nightly processing utilizing ROBOT software products.

1988-1992 Technical Support Specialist/National Trainer

New Generation Software (NGS), Sacramento, CA

Business Type: iSeries Software Company

Provide training, telephone technical support, and onsite field support for an iSeries query package known as I.Q.

Researched customer problems and worked on fixes and custom applications for customers.

Analyzed software performance evaluations and requested enhancements for yearly releases.

Conducted on-site training classes nationwide.

Wrote CL programs to provide automation of complex query reports, and provide customers with an outside interface to the software product.

1985-1988 AS/400 Computer Operator

Capitol Federal Savings and Loan, Englewood, CO

Business Type: Savings and Loan Company

Monitoring AS/400 systems.

Performing nightly backups, monitoring Job and out queues.

Performing nightly, monthly and year end processing.

Customer support on software and job issues.

Printing nightly and monthly reports.

Troubleshooting printer jobs, batch jobs and all other iSeries system issues.

Create and manage nightly job schedules.

Education: 1996 - A.A.S. Computer Information systems –

J Sargent Reynolds Community College, Richmond, VA

Contact this candidate