We provide IT Staff Augmentation Services!

Analyst - Conversion Of Loan Systems Resume

5.00 Rating

SUMMARY:

  • Over experience of 30 years working with IBM mainframes, as well as working with the UNIX midrange and Windows NT platforms.
  • Assignments include all phases of planning, management, business analysis, systems analysis, design, development, coding, testing, debugging, implementation, conversion, auditing, reconstruction, disaster recovery, regulatory compliance and documentation.
  • Extensive management, business analysis and system support experience.
  • Managed three different groups concurrently.

HIGHLY SKILLED AREAS:

Project Management/Business Analysis, Systems Design and Implementation, System or Application Conversions, Production Maintenance and Support, System Auditing and Reconstruction, Disaster Recovery, Systems Documentation, Regulatory Compliance, HIPAA Implementation and Sarbanes - Oxley (SOX) Implementation

TECHNICAL SKILLS:

Software: Connex, ISO, zOS, 64 BIT Architecture, TESTBASE, CMM, Estimator, JAD, Visual SourceSafe, ClearCase, ClearQuest, Remedy, APTF, XCOM, SAR, PDF Scan, Startool, ToolBox (Endeavor) COBOL, APS Cobol, IBM DEBUG(both Online and Batch), CICS, DB2, SQL, Spufi, RapidSQL, JCL, Assembler, SAS, PL1, Macro, TSO, ISPF, Fortran, SAP, Platinum, Easytrieve, OS/MVS, MS-DOS, OS/2, DOS/VS, VM, VSE, IMS (DB, DC), IDMS, FAQS, UNIX, LINUX, TableBASE, DataManagement, MQSeries, BMI, MS Sharepoint (Documentation, Requirements, Specifications, Test Scripts, Change Tracker), MS Office, MS Word, MS Excel, MS Visio, MS Project, MS Access, Abend-AID, Lotus Notes, XPEDITER, SCLM, Changeman, Endeavor, CA7, Control-M, FileAid, Zeke, Panvalet, Oracle, SAP, HTML, XML, Java 2, SQLJ, Visual Age 3, EJB, JDBC, TCF, PVCS, UDB ON AIX, Rational Rose, RUP, OO (Artifacts, Conceptual Design, Use Cases), Subscriber, Dispatch, Infopac, XACT, AS400, WebSphere, COD (computer Operations Documentation)

Systems: Financial (Banking, Loan Systems, Trust Accounting, Investments, Mutual Funds, Credit Cards, Insurance), Health Care, Utilities, Human Resources, Employee Benefits, and Manufacturing.

PROFESSIONAL EXPERIENCE:

Confidential

Analyst - Conversion of Loan Systems

Responsibilities:

  • I was a part of a team that was responsible for validating the conversion of the Personal Loans system, and the development of a reconciliation system to assist in determining that the system data conversions were complete and accurate.
  • This was accomplished by creating programs to extract the data fields from the Confidential system and systemically verifying that the conversion to the FINANCLE system was accurate.
  • This was accomplished by accessing both mainframe and UNIX platforms while primarily using SAS, DB2, ORACLE, COBOL and VBA.
  • Various Audit and Statistical reports were produced which identified both Mapped and Defaulted data fields as well as the Percentages of Errors identified.

Technologies Used: SAS, DB2, ORACLE, COBOL, VBA, SQL, Microsoft Office, Microsoft tools

Confidential

Analyst - Legacy System Support

Responsibilities:

  • Confidential is building a new system with their existing system staff.
  • I was part of a team of contractors brought in to support the existing legacy system(daily, monthly, quarterly and annual processing).
  • My particular focus was the financial systems which required a daily reconciliation and working with the business support staff to research issues, abends, out-of-balance conditions as well as modifying and correcting errors (processing or system) as they occurred.
  • This system is primarily a mainframe system with interfaces to SAP and Peoplesoft, and a variety of external vendors.

Technologies Used: Assembler, COBOL (mainframe, UNIX), SAS (V9), EasyTrieve, DB2, Use Cases, SAP, Peoplesoft, MQSeries, JAVA, WebSphere, HTML, CICS, VSAM, ZOS, JCL, TCPIP, FTP, Microsoft Office, Microsoft tools, MS Sharepoint (Documentation, Requirements, Specifications, Test Scripts, Change Tracker) as well as a number of in-house developed tools.

Confidential

Analyst - Credit Card Division

Responsibilities:

  • Business design sessions were required due to the complexity of the systems and data. In addition to coding and testing, System Design Documents were prepared as well as formal Program Documentation and Documented Test Plans.
  • A series of programs were modified to include new flags and counters to identify and count credit card accounts identified as linked Multiple Accounts with Balances, Pooled accounts having Rewards, non Pooled accounts having Rewards and accounts with no Rewards.
  • A new table was created and maintained to capture these counts.
  • In addition to coding and testing, System Design Documents were prepared as well as formal Program Documentation and Documented Test Plans.
  • The periodic purge of credit card accounts affects many tables.
  • Programs were updated to include new tables in this process. Testing of these programs required extreme care and diligence.
  • In addition to coding and testing, System Design Documents were prepared as well as formal Program Documentation and Documented Test Plans.

Technologies Used: Assembler, COBOL), APS Cobol, IBM DEBUG(both Online and Batch), DB2, Use Cases, MQSeries, HTML, CICS, VSAM, ZOS, JCL, SQL, Microsoft Office, Microsoft tools, Documentation Maintenance

Confidential

Business Analyst/Mainframe Technical Lead

Responsibilities:

  • I was responsible for the Functional Requirements (using Sharepoint) and working with the business users and the technical teams while participating in the design and creation of an automated system to replace a manual mailbox system in order to coordinate the processing of both automated and manual restructurings of delinquent loans.
  • This required the integration of functions across three systems - Coach (Oracle), HTS and CIM (DB2) in addition to designing and implementing new reporting requirements.
  • Responsibilities also included the setup of a daily processing schedule and the setup and review of all testing requirements.
  • I was responsible for drafting the following Functional Requirements: Credit Bureau Reporting, Delinquency Codes, Account Closure, Bankruptcy - Chapter 7, and Bankruptcy - Chapters 11 and 13 to convert the current Confidential system to the Confidential - LoanServ system.
  • This involved extensive interaction (JAD sessions, WEBEX and conference calls) with business users, outside vendors, other consulting firms and the technical teams.
  • Additionally, I participated in and approved the technical code design reviews for all of the Functional Requirements.
  • I designed, coded and implemented a Conversion Reconciliation system to assist in determining that the system data conversions were complete and accurate.
  • This was accomplished by creating programs to extract the 1800+ data fields from the new system after conversion as well as re-extracting the original data fields from the old system used in the conversion and systemically verifying that the conversion was accurate.
  • Various Audit and Statistical reports were produced which identifies both Matching and Non-Matching data fields and the Percentages of Matching achieved.

Technologies Used: Assembler, COBOL), SAS (V9), DB2, Sharepoint, Use Cases, MQSeries, JAVA, WebSphere, HTML, CICS, VSAM, ZOS, JCL, SQL, Microsoft Office, Microsoft tools, SDM (Documentation Maintanence)

Confidential

Business Analyst/Technical Project Manager/System Analyst/Programmer Analyst/Testing Analyst

Responsibilities:

  • I worked with multiple business units to document the functions of the existing system and to review and assess new functionality either required or desired. Created the Business Requirements Document which became the blueprint for the new system design.
  • The new system design required a consistent input format from all Vendors. The Vendors were contacted and supplied with the new system requirements which have been implemented.
  • Created the new system design specifications (using Sharepoint) including the creation of 13 tables which eliminates module maintenance when new Vendors or new payment methodologies are required. (The old system had in excess of 200 modules, whereas the new system has 25 modules). The system is designed to receive FTP input from Vendors, process those payments, and feed downstream reconciling systems.
  • Worked with the Data Warehouse group to in corporate the new tables into the data warehouse. Adhoc reporting by business users is available from the warehouse to facilitate and simplify the reconciliation of errors and internal balancing requirements.
  • Developed new SQL modules, sort procedures, control cards and copybooks in support of the system development
  • Unit and system tested the system and working with Vendors conducted parallel testing to compare and contrast the results of the old vs. new system

Technologies Used: Assembler, COBOL (mainframe, UNIX), SAS (V9), EasyTrieve, DB2, Use Cases, MQSeries, JAVA, WebSphere, HTML, CICS, VSAM, ZOS, JCL, TCPIP, FTP, SQL, Microsoft Office, Microsoft tools, MS Sharepoint (Documentation, Requirements, Specifications, Test Scripts, Change Tracker) as well as a number of in-house developed tools

Confidential, IL

Senior System Analyst

Responsibilities:

  • We worked with auditors from the State of Delaware to document, design, create and ultimately report 2010 insurance activity including commissions.
  • Five separate programs were required to report the activity.
  • We worked with business owners to document, design, create and report various insurance activities comparing and contrasting 5 year term with other than 5 year term life policies. Two separate programs were required.
  • I developed a re-conversion program to re-convert master files to their prior format if a major system enhancement had to be backed out and the original system restored.

Technologies Used: Assembler, COBOL (mainframe, UNIX), SAS (V9), EasyTrieve, DB2, IMS, RUP, Use Cases, SAP, Peoplesoft, MQSeries, JAVA, WebSphere, HTML, CICS, VSAM, ZOS, JCL, TCPIP, FTP, Microsoft Office, Microsoft tools, MS Sharepoint (Documentation, Requirements, Specifications, Test Scripts, Change Tracker) as well as a number of in-house developed tools.

Confidential, IL

Business/Functional Analyst Lead

Responsibilities:

  • Project Lead for project phase at Phoenix which was to review documents, gap analysis of existing systems
  • After conducting JAD sessions, we examined and documented all three systems by creating use cases and then provided a gap analysis comparing and contrasting all three systems based on system function as well as input screens, batch processes, data files, data elements, and SQL tables.
  • We also reviewed the systems X12 formats for upgrading from version 4010A1 to version 5010 and ICD-9 Clinical Modification (CM) Volumes 1 and 2 upgrade to version ICD-10 CM and ICD-9 CM Volume 3 upgrade to version ICD-10-PCS.

Technologies Used: COBOL (mainframe, tandem), SAS (V9), DB2, IMS, RUP, Use Cases, SAP, Peoplesoft, Assembler, DataManagement, MQSeries, JAVA, WebSphere, UNIX, HTML, CICS, VSAM, ZOS, JCL, TCPIP, FTP, SQL, Microsoft Office, Microsoft tools, MS Sharepoint (Documentation, Requirements, Specifications, Test Scripts, Change Tracker).

Confidential, WI

Systems/Business Analyst

Responsibilities:

  • Regulatory change to allow transfers of funds from Annuities for purposes of providing Long Term Care.
  • This activity involved Legal and Business users and required Business Analysis, system design, system requirements, program modifications, new system views,
  • Tablebase table changes, testing documentation, testing scripts, and preparation of JCL for 81 jobs for unit and system testing.
  • Research / Repair of SAS programs upgraded to V9
  • Tablebase changes for 2010 Holiday schedule
  • Program modifications for 2010 interest rates

Technologies Used: PL1, SAS (V9), Client Data Extract Component (KDEC), DB2, Assembler, COBOL, TableBASE, Changeman, DataManagement, MQSeries, BMI, JAVA, WebSphere, UNIX, HTML, CICS, VSAM, ZOS JCL, TCPIP, FTP, SQL, Microsoft Office, Microsoft tools, MS Sharepoint (Documentation, Requirements, Specifications, Test Scripts, Change Tracker), TSO, Spufi, RapidSQL, Remedy, Panvalet, FileAid

Confidential, IL

Systems/Business Analyst Lead

Responsibilities:

  • New development for Scheduling Annual Evaluations including DB2 table creation, loading and updating tables to provide for the scheduling of periodic annual trust account valuations.
  • This activity also included the creation of SQL stored procedures to accept XML encoded trust account search criteria from a Linux based Web application, parse the XML instructions, and execute one or more searches against DB2 tables to satisfy the search request.
  • Trust Servicing: New development of 15 separate procedures to extract data from mainframe DB2 tables and then FTP the extracted results to a UNIX based data warehouse.
  • Trust Servicing: New development to extract table data from a foreign-based AS400 system, reformat the data and insert, delete or modify mainframe DB2 tables based on a repetitive 20-minute schedule.
  • Trust Servicing: Legacy system modification (assembler code) to replace a hard-wired printer with a LAN based printer for the purposes of printing all checks (tax, personal or business) drawn against trust accounts as well as create restart/recovery procedures.
  • Trust Servicing: New development to identify personal trust accounts having global holdings and convert these accounts to Global based Accounts by examining DB2 tables and then inserting/updating selected Global tables.
  • Trust Servicing: Legacy system modification to identify, upgrade to V3.4, recompile and test all PL1 based batch and online programs. Some online modules use 2260 Simulation.

Technologies Used: MVS, IMS (DB, DC), Assembler, COBOL, PL1, DB2, SCLM, CICS, VSAM, JCL, TCPIP, FTP, SQL, Microsoft tools, Lotus Notes, TSO, SAS, XACT, Spufi, RapidSQL, Remedy, Control M, Panvalet, FileAid, COD (computer Operations Documentation), XML, AS400, Linux, Unix

Confidential, IL

Business/Systems Analyst

Responsibilities:

  • Work with the former client and hardware vendor and then review and assist with the implementation of the IDMS system.
  • Additionally, reviewed the original system structure to determine areas that required modification due to incompatible hardware and/or software (for example - the use of FlashCopy on IBM’s Shark hardware or the use of Lotus Notes vs. Microsoft Outlook.)
  • Additionally, had to implement new system backup and Disaster Recovery backup plans and modify the security systems to the Acxiom environment.
  • Operational procedures were reviewed, modified and tested to insure operational readiness and execution.

Technologies Used: VM, VSE, IDMS, FAQS, Assembler, COBOL, CICS, VSAM, JCL, TCPIP, FTP, Microsoft tools, Lotus Notes, TSO, MVS.

Confidential, WI

Business/Systems Analyst Lead

Responsibilities:

  • Confidential runs the systems and supports the switches used in the Credit/Debit/Prepaid Card industry. Lead on implementation of Fraud package and system conversions project
  • Bridge to Fraud Manager, Designed coded and tested the linkage between the switches and Fraud Manager. Fraud Manager detects and identifies fraudulent activity based on card, terminal, company or other interconnecting system usage.
  • 64 BIT Architecture/Storage above the BAR, Researched and modified 31 bit system architecture to operate in 64 bit to provide for needing to have more than 2 Gigabytes of storage for internal files.
  • System Conversions, Designed, coded and tested the conversion (and deconversion) of system release 3.4 to 3.5.

Technologies Used: Connex, ISO, zOS, 64 BIT Architecture, Assembler, XDC, COBOL, CICS, VSAM, Easytrieve, JCL, DB2, FTP, Microsoft tools, Lotus Notes, TSO, MVS, Debug, File Manager, Panvalet

Confidential, IL

Systems/Programming Analyst Lead

Responsibilities:

  • I was tasked with retrieving data from all three systems, analyzing this data, developing programs to report this data, and then the Daily production and distribution of these reports.
  • This Bank was closed on a business day that Confidential was open and processing The Confidential daily process reprocessed the previous day’s file as though it was the current file.
  • I was requested to design and then implement in production a solution to prevent this type of problem from ever happening again in the future.

Technologies Used: COBOL, CICS, VSAM, Assembler, Easytrieve, JCL, DB2, FTP, Microsoft tools, Access, Lotus Notes, TSO, MVS, zOS, Debug, File Manager, Panvalet, FileMaster

Confidential, WI

Business Analyst, Systems Analyst and Data Management Analyst and Lead

Responsibilities:

  • Implementing and executing an Extract/Load process for 400+ DB2 tables and 10 VSAM files for 7 regions.
  • Lead on two primary testing assignments
  • Installing and testing TESTBASE (a vendor package) used for data scrubbing for SOX compliance
  • Analyzing, modifying and testing CICS online transactions to mask Account and Social Security numbers
  • Converting from Changeman to Endevor
  • Creating a QA environment for 7 different regions

Technologies Used: COBOL, CICS, VSAM, SAS, Assembler, Easytrieve, JCL, DB2, CA7 (scheduling), FTP, Microsoft tools, Access, Lotus Notes, TSO, MVS, VSE, zOS, Debug, File Manager, DB2 BMC, Spufi, TESTBASE

Confidential, IL

Business Analyst/System Analyst, Lead

Responsibilities:

  • Analysis and Installation of ClearCase, ClearQuest, XPEDITER DevEnterprise and a PMO Office, and Analysis and Recommendations for Change Management (Endeavor), Scheduling (CA7), Disaster Recovery, Testing (Unit, System, Regression, Integration and UAT), and the creation of QA testing LPARs.
  • Specific work assignments included code reviews, JCL reviews, and the preparation of testing documentation identifying processing dates, input parameters and input files.

Technologies Used: COBOL, CICS, VSAM, SAS, Assembler, JCL, DB2, IDMS, JAD, CA7 (scheduling), FTP (Mainframe/midrange/PC), Microsoft tools, Access, Lotus Notes, TSO, MVS, VSE, zOS, ClearCase, ClearQuest, XPEDITER DevEnterprise, Advanced Query Tool, and Application Explorer

We'd love your feedback!