Business System Analyst Resume
West Hills, CA
TECHNICAL SKILLS
Hardware: IBM ISeries, IBM AS/400, IBM S/38, IBM S/36, SQL servers 2010 - 2014
Software: DB2, OS/400, 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, Excel, Power Point, MS Word, MS Access, Visio, SharePoint 2013, HP Quality Center, Exstream DMS
Programming Languages Used: RPG II, RPG III, RPG IV, RPGILE, RPG Free, Stored procedures, Service Programs, CLP, CLLE, SQL, Embedded SQL, HTML
PROFESSIONAL EXPERIENCE
Business System Analyst
Confidential, West Hills CA
Responsibilities:
- Creation of control reports to analyze business processes for multiple mortgage lenders using SQL 2014. SQL server data is created over multiple systems that connect to mortgage lenders AS/400 system of record, CCS IBM Mainframe system of record, Track Source Document management systems, Rembrandt work flow system and business rules.
- Assist in projects for QA testing scripts using HP Quality Center.
- Develop and maintain the user request ticketing site working with SharePoint software. Assist other mortgage lender groups in developing SharePoint team sites for daily work activities.
- Create Adhoc query reports for line of business teams to identify data and logic issues.
- Coordinate with IT Developers and Business Analyst to provide data for production changes and business requirements.
- Run daily reports and monitor systems during corporate transition.
- Add users to authority lists for access to AS/400 systems.
Senior RPG Programmer/Analyst
Confidential, Simi Valley, CA
Responsibilities:
- 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. Varying 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.
- Creating queries on multiple environments to ensure data accuracy.
Senior RPG Programmer/Analyst
Confidential, Agoura Hills, CA
Responsibilities:
- 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 AS/400 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.
Senior RPG Programmer/Analyst
Confidential, Encino, CA
Responsibilities:
- 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.
- 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.
Programming Operations Analyst
Confidential, Richmond VA
Responsibilities:
- Analyze user requirements, procedures, and problems to automate nightly processing utilizing ROBOT automated software.
- 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.
- Modify and maintain existing RPG programs. Design and implement user menus, screens, report layouts, subfiles, PF/LF files.
- Create Adhoc 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.
Technical Support Specialist/National Trainer
Confidential, Sacramento, CA
Responsibilities:
- 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.
- 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.