Business Analyst Resume
Scottsdale, AZ
OBJECTIVE:
- I want to pursue a career as a Mainframe Software Engineer in Information Systems.
SUMMARY:
- I am a Mainframe Application Developer and GAP Accountant with knowledge of data collection/research/analysis, project management, mainframe application, and testing. I’ve worked as a Mainframe Analyst for the past 10 years. I’ve developing Health Care applications for Pharmaceutical Benefits Management (PBM). I’ve developed Financial applications under IBM's zOS 3090 MVS operating system using COBOL2, DB2, IMS, CICS, C++, SAS, and IBM mainframe Assembler.
- I am familiar with Agile, Scrum, and System Development Life Cycle (SDLC) project management methodologies.
TECHNICAL SKILLS:
Technology and Tools: IBM Mainframe 3090, ZOS, Z10* IBM PC's/Apple MAC* TI Business Calculator 3270 terminal* AS400 ISeries SOFTWARELanguages and Software IBM COBOL2* Windows* IBM Assembler* C++* HTML* MS Project CICS/MVS*IMS DB/DC* TSO/ISPF* Visio* JAVA* Six Sigma BAL/HAL/ALC* DB2/SQL Database* MS Office* JCL* SQL* SDLC SAS* Sync Sort * SharePoint TELECOMMUNICATION Asynchronous, Bisync, SNA, TCP/IP, MQSeries, SFPT, Accellion (Email) OPERATING SYSTEMS IBM AS400 ISeries, IBM zOS/MVS3090, Windows, DOS, UNIX PROJECT MANAGEMENTAGILE, SCRUM, and SDLC (Waterfall), MS Project TOOLS: Sales Force, File - aid, SAS, NDM, Syncsort, SFTP, Accellion, Quality Center, and TSO/ISPF
WORK EXPERIENCE:
Confidential, Scottsdale, AZ
BUSINESS ANALYST
Responsibilities:
- I capture business requirements for CVS clients who request pharmacy claim data. I act as the I.T business analysts between CVS Clients, Implementation Managers, Account Managers and I.T. We gathering requirements for the creation and delivery of report files (claim history) to clients and vendors, which follow the EDI format. The report files itemizes financial dollar amounts for drug claim data, which is used by the client for invoice balancing.
Confidential, Scottsdale, AZ
SENIOR SOFTWARE ENGINEER
Responsibilities:
- I have designed and coded ZOS Batch and Online IBM 3090 COBOL data retrieval module for connecting with an ISeries (AS400) via XML and HTTPS. This is the first time the IBM 390 mainframe system communicated with the AS400. SAS was used for pulling data from tapes for analysis and reporting.
- S:The IBM mainframe is now able to retrieve clam history records from AS400 iseries via HTTPS call and XML messages.
Confidential, Harrisburg, PA
SENIOR MAINFRAME SOFTWARE ENGINEER
Responsibilities:
- We converted Confidential ’s Group Maintenance mainframe application (GEMUS) from an IMS/DB database to a DB2/SQL database via COBOL external Stored Procedures. We converted IMS/DC online screen to a web based model using PEGA-7 client server.
- S:We removed IMS “DLI” calls from batch application and replaced with DB2 SQL calls. We removed us of the mainframe’s EMC2/TAO mailbox by creating an MQ interface to communicate with PEGA-7 Client Servers.
Confidential, Sacramento, CA
SENIOR SOFTWARE ENGINEER
Responsibilities:
- We handled Medicaid paper claims processing for the State of California's Medicaid System: MEDI-CAL. IBM works with the U.S. Federal Government's Center for Medicaid & Medical Services (CMS) and California's Department of Health Care Services (DHCS) paper claims processing. Our team handles COSTING, ADJUDICATING, SETTLEMENT, PRICING, PROCESSING, and AUDITING paper claims for forms: CMS1500, UB04, Long Term Care (LTC), and Pharmacy for In Confidential t, Out Confidential t, and Crossover claims.
- We used IBM’s File Manager to view contents of VSAM, and Sequential files. We used IBM utilities programs like IDCAMS, IEBGENER, and SYNCSORT to create JCL for job scheduling.
- S:Modified Paper claim processing to support conversion from ICD9 to ICD10 standards and modified electronic claim to support the new X12 HIPAA 5010 EDI standards.
Confidential, Scottsdale, AZ
SENIOR SOFTWARE ENGINEER
Responsibilities:
- CVS’s Support Systems project team built an automated SOX Audit and billing system for the United States Government (CMS) MED D prescription drug program. We designed the Sox Audit process to make sure every MED D Medicaid claim billed by CVS was sent and correctly charged to the government’s MED D drug program. We generated monthly billing statements. We performed weekly billing reconciliation plus billing adjustments.
- The project team consisted of (4) Senior programmers, (2) Business Units, and (2) Testers who aided in design, coding, testing, and installation. The tools used for development were COBOL and Assembler for processing, DB2 for SQL querying and “ad hoc” reporting and CICS for online processing and End User screen interface. We documented programs and program changes using the CMMI/SDLC development methodology, which includes aiding our Business Unit in creating Business Requirement Statement (BRS) documents as well as High Level Detail Design (HLD) documents.
- We used IBM’s File Manager to view contents of VSAM, DB2, and Sequential files. We used SPUFI to query contents of DB2 Databases. We used IBM utilities programs like IDCAMS, IEBGENER, and SYNCSORT to create JCL for job scheduling.
Confidential, Scottsdale, AZ
SENIOR SOFTWARE ENGINEER
Responsibilities:
- Our Systems Support Team built (1) a Medicaid Claims billing system, (2) a Medicaid Claims Pricing system, and (3) a Medicaid claims Tape archival system for CVS’s Pharmaceutical Benefit Management (PBM) division. We designed the system to support WEB portal bill presentment using MQ series as middleware between mainframe and WEB Client Servers. CICS screen were created for Call center and customer service support to handle billing inquiries.
- S:Created a 2 terabyte Pharmaceutical Claims database
- The old system only retained 12 months of claim history before claims had to be archived off to tape. The new system holds up to 20 years of billing and claims history online. Customers are now able to view all claims and prescriptions over a WEB portal for up to 20 years. This created tremendous customer loyalty.
Confidential, Phoenix, AZ
SENIOR SOFTWARE ENGINEER
Responsibilities:
- The Drug Analysis team, in the Pfizer department, provided statistical analysis reports (using SAS, COBOL, and DB2) of prescription written by doctors or health care providers.
- We converted SAS programs to COBOL and DB2 to automate reporting and client billing. We finalize forms, procedures, and other documentation needed for the installation and maintenance of application programs.
- S:Converted all SAS based programs to COBOL.
- System performance increased tremendously. Mainframe response time reduced from 15 seconds a query to 1 second a query.
Confidential, Scottsdale, AZ
SENIOR SOFTWARE ENGINEER
Responsibilities:
- Due to Airborne’s merger with Confidential, the “Airborne to Confidential ” merger project team redesigned, recoded, retested, converted, and integrated Airborne’s billing system to Confidential ’s current billing and Pricing system. We rewrote CICS programs, we recreated maps, we redesigned DB2 tables, we transformed data, and we loaded tables. Programs and program changes on Confidential ’s Pricing System were documented.
- S:Converted Airborne’s’ Billing Pricing system to Confidential billing system.
- Prior to changes, Confidential had to deal with two billing systems. Once the two systems were merged, Confidential ’s billing and pricing system became very efficient and easy to work with.
Confidential, Winston-Salem, NC.
SENIOR SYSTEMS ANALYST/PROGRAMMER
Responsibilities:
- A credit card bill presentation system.
- We built online interfaces to the credit issuers using using MQ series and CICS.
- We built a Internet banking web portal which uses a CICS interface with merchant credit card online authorization system.
- Created a credit card Clearing and settlement bach and online system.
- On the mainframe, our development tools were COBOL, Assembler, CICS, DB2, and JCL. On the Client Server side, we used HTML, JAVA, and C++.
- The team converted Wachovia’s Telephone Banking system from using a VSAM file structure to a DB2 database file system. We developed over 100 execution Jobs and Cataloged procedures for business unit reporting. We developed over 30 CICS screen for customer support and the call center.
- We converted three applications from CICS version 3 to CICS Transaction Server 4. Our Team lead the conversion of Wachovia’s Home Banking System from ANSI COBOL to COBOL2 - over 100 modules had to be modified and recompiled. The department developed 20 new CICS modules, 5 BMS screens, and 22 VSAM files.
- The E-Commerce team assisted in Y2K conversion: Modified JCL, parm cards, Copybooks, COBOL programs, CICS programs, and Assembler programs with Y2K retrofits. We Lead conversion of legacy based Home Banking system to a web based system, which included developing an Internet Home Banking web applications using HTML, JAVA, and C++.
- We converted Home Banking System’s 24 bit CICS programs to use 31 bit addressing - this allowed application to run in the higher memory space. This increased the response time and minimized paging. I converted Wachovia’s Home Banking System from COBOL/2 to COBOL/390. This included recompiling over 150 CICS programs and maps.
Confidential, Milwaukee, WI
INFORMATION SYSTEMS ANALYST
Responsibilities:
- We were responsible for enhancing and developing CICS programs to meet the changing regulatory environment of NY State’s Medicaid EMEVS system.
- We processed Electronic Benefit Transfer (EBT) transaction using Debit Card (EFT) technology, which included processing EBT claims through ATM machines.
- We wrote an EBT transaction authorization system for doctors to get pre approval for medical procedures.
- I wrote CICS interface to accept EBT transactions from Veriphone POS terminals and ATM machines.
- I was trained as a Point of Sales (POS) device programmer. This included card scanners and bar code readers. NY State Medicaid doctors whom needed to authenticate Medicaid recipients used POS devices.
- Reduced the company’s telecommunication costs by 75%
- We developed a CICS based Point of Sale (POS) software download system for NY state’s Medicaid doctors.
Confidential, Dallas, TX
SYSTEMS ENGINEER TRAINER
Responsibilities:
- I trained new employees in JCL, CICS, COBOL, IMS, and Assembler.
- I taught control break processing, VSAM file processing, QSAM file processing, Sequential file updating, JCL Job stream creation, Compile-link-go, and Pseudo-conversational programming.
- I taught Regression testing, test script writing, and I taught how to use MVS utilities like IDCAMS, IEBGENER, IEBPTPCH, IEBCOPY, IEBUPDTE, and IEBR14, and ABEND and DUMP reading.
- I worked for Confidential ( Confidential ) as a Mainframe Developer supporting their CAD/CAM systems using COBOL, DB2, and JCL to generate cost reports