Qa Analyst Resume Profile
CAREER SUMMARY:
Strong Background in management of application development, operations and QA teams, with resources off shore and local. CMMI Certified V1.2. Extensive experience in new development, system support, Project Management, and database design and maintenance. Heavy involvement with Vender software evaluation, implementation, and application performance evaluation. Extensive experience in management, design and implementation of commercial systems for Banking, Insurance, Healthcare, Manufacturing, and Financial applications. 20 years technical experience in designing, developing, implementing, and maintaining, hardware and software applications, utilizing microprocessor, IBM large systems, PC, and Client/Server technology. SDLC, SIX Sigma and CMMi proficiency.
APPLICATION EXPERIENCE:
ILS, AETNA, CIGNA, FLEET, THE HARTFORD, TRAVELERS, GE, KAISER PERMANENTE, ING, FEDERAL STATE TAX SYSTEM, LIFE HEALTH PREMIUM CALCULATION SYSTEM, SPECIAL RISK INSURANCE SYSTEM, PREMIUM SUSPENSE REFUND SYSTEM, DISBURSEMENT HISTORY SYSTEM, PENSION ANNUITY REPORTING SYSTEM, BANKING ACQUSITION DATABASE CONVERSION, INTERACTIVE SERVICE ACCOUNTING SYSTEM, CASH ACCOUNTING SYSTEM / BILLING INTERFACE, DATA INTEGRITY, CASH SYSTEM DATABASE CONVERSION, PREFERRED PARTNERS ORGANIZATION REPORTING SYSTEM, ACCOUNTS RECEIVABLE SYSTEM, AUTOMATED ELIGIBILITY, ADMINISTRATIVE LEVERAGE SYSTEM, PERSONAL LINES - AUTO, HUON SOLUTION - COMMISSIONS, CYBERSYSTEM TRADITIONAL LIFE, MARS MANUFACTURING REPORTING SYSTEM, ORACLE ADMIN SYSTEM, IM DATA WAREHOUSE, ENTERPRIZE DATA WAREHOUSING
WORKING KNOWLEDGE OF:
Project Portfolio Management Center PPM , COBOL II, COBOL, MICROFOCUS COBOL mainframe Client Server , VISUAL BASIC, SQL, CICS, OS/JCL, DMS, BASIC, ASSEMBLER, MACHINE LEVEL 16 BIT ASSEMBLER, FORTRAN,QUICKJOB, SAS, FOCUS, EASYTRIEVE PLUS, TSO, ISPF, CMS, QMF SPUFI, NT, NORTON UTILITIES, ORACLE, INTERTEST, ACCESS, MSQUERY, XBUG, ONLINE/BATCH XPEDITER, MVS, STROBE, PANVALET, WINDOWS, OS/2, DOS, EXEC, DFHSM, CLIST, FILE-AID, RMDS, PATHVU/RETROFIT, OPTICAL STORAGE/E-FICHE, EOS, ENDEVOR, ODBC, MSQuery, ACCESS, DB2, UDB, IMS/DLI, VSAM, FOCUS, XDB, QC, ReqPro, COGNOS
EXPERIENCE:
Senior Information Engineer-
- Managing a dedicated IT group for National Programs loading and consuming data into a datamart owned by the business unit. Staff on shore and offshore.
- Work Intake, estimation, dev/prioritization, and implementation for AIM, NPMI, UWRef, EPW NP
- Managing COGNOS resources for Adhoc reporting
- Project Management responsibility Tool design and build for Actuaries and Underwriters
- Developing solutions for customers
- Defined and implemented Disaster Recovery process where there was none by invoking a service from an existing partner Iron Mountain. Tactical solution while working on the Strategic one
- Implemented a CITRIX onshore solution to address latency issues
- Server consolidation reconfigured business unit to a more efficient model technically and financially
- Streamlined process for onboarding new users of application
- Proactively upgraded application to a version that is Windows 7 certified
- Responsible for coordinating the efforts between business and technical contributors BA, SME, DBA, QA .
- Developed and implemented test strategy: test cases, process plan, scope, report to stakeholders, and defect reporting and resolution.
- Support of internal and external customers across the business warehouse data stores
Release Manager Specialist-
- Developed and rolled out a Governance process that includes Work Intake, estimation, dev/prioritization, and implementation.
- Developed all process material, facilitated meetings between business owners and application owners, maintained the Checkbook across the applications.
- Developed metrics on all Maintenance Enhancement work.
- Assist teams with scheduling/managing their work by keeping information current on a Team Sharepoint site.
- Responsible for Governance meetings, scoping meetings, and Release meetings agendas, content and minutes.
- Provided updates on the segments release portfolio.
SDLC Liaison
- Provide the business a competitive advantage by operationalizing a standard systems development life cycle process that facilitates the consistent and reliable delivery of business enabling solutions.
- Empower individuals, in their roles, by communicating process and tools solutions.
- Attend Working group meetings to assist with 2 way communication between lines of business and SDLC solutions team.
IT Team Lead
Project Management
- Responsible for coordinating the efforts between business and technical contributors BA, SME, DBA, QA .
- Developed and implemented test strategy: test cases, process plan, scope, report to stakeholders, and defect reporting and resolution.
- Support of internal and external customers across the business warehouse data stores
- Provide customers with data that meets their business requirements, and aids with the analysis of reported data issues.
- Define daily plans and direction for resources within the team.
- Active Participant in a discussion to define process/data issues in the current design and what new development should look like.
- Address questions and issues that are forwarded to the Team.
- Assign new work based on work load and level of expertise.
- Engaged QA Analysts to do independent research to improve the process and provide better service to customers.
- Measured and improved performance, and decreased costs by driving an Archiving initiative within the error recycling process.
- Assist in assessing and selecting vendor companies for additional QA support.
- Technical lead of an IM technical operations team that oversaw the loading of the warehouse for all Healthcare data.
- Responsibilities include coordinating ALL resources, such as running all the required processes, coordinating storage, assuring the DB2 environment is set up correctly , to Load the Data warehouse, as well as building Data Marts.
- Effective communication skills, coordination skills, and sensitivity to the budget/resource issues are crucial.
- This role required managing across all of the touch points within CIGNA's healthcare systems, 23 source systems that were consolidated onto the Warehouse.
- Receiving data in extract form, via IBUS, or DPROP, depending on the interface agreement.
- Data was received from legacy systems from the mainframe, from UNIX, and other sources, physically residing in different parts of the US.
- All aspects of the project had to be closely monitored 24/7.
- Suggestions for process improvement were documented for the source systems and for the development environment within the IM team.
- My team built the JCL for all platforms of testing as well as the 'final' version for production implementation.
- Responsibility included promoting changes throughout the test environments using ENDEVOR tools.
- Provided Testers with Queries to help them validate the data integration and relationships.
- Extensive coordination between representatives from all integrated systems, ie..Provider, clients, membership, eligibility, claims.
- Data Marts were built for Financial Reporting.
- Tools used: COBOL II, DB2/SQL, CICS, QMF, SPUFI, DB2 Workbench, File Aid for DB2, SYNCSORT, EZTRIEVE, VSAM, MVS/JCL, MS OFFICE, VISIO.
- Manager of onshore and offshore resources maintaining and enhancing various Legacy Mainframe systems information across 7 mainframes , an Oracle Data warehouse system, and a KRONOS/AS400 payroll system.
- Applications provided manufacturing plants around the world with information for their daily operations.
- Information had to be gathered from the branch, the warehouse stock , and corporate level systems.
- Systems kept track of all inventory, their life expectancy, product delivery tracking, Customer requirements, forecasting, payroll processes for hourly and salaried employees, and many other functions.
- Administrative information was also stored in an ORACLE data warehouse, at the corporate level.
- Payroll/Administrative systems in the AS400, the mainframes, and in ORACLE environments had to run to completion.
- Tools: COBOL II, FILEAID, SYNCSORT, EZTRIEVE, RPG, KRONOS, VSAM, TSO/ISPF, MVS/JCL, FOCUS, BUSINESS OBJECTS, LOTUS NOTES, SAMETIME.
- Project lead for the STARS system.
- Coordination of efforts between designers, Technical, and testing resources within the company, the STATEMENT design vendor in BOSTON, and the printing/mailing vendor in CT.
- Production implementation team member instrumental in coordinating all the necessary components to implement a system in production.
- Coordination, documentation, interviewing teams, educating individuals in new system products, building JCL and moving it to ENDEVOR, and documenting on call procedures, as well as disaster recovery procedures.
- Programmer on an output team within the CYBERSYSTEM project.
- Responsible coding and testing of programs to create correspondence to customers and Agents.
- Extensive knowledge of COBOL II, IMS, VSAM, ENDEVOR, EOS, and JCL was required.
- Programmer on an IBM/HUON/TRAVELERS partnership team.
- Responsible for technical design, development, and implementation of existing and new modules/data, of the HUON system
- COBOL II, DB2/SQL, CICS, QMF, and SPUFI were the tools extensively used in this environment.
- Programmer working on a home grown personal lines system.
- Enhanced current process to include special conditions/requirements for each state. As mandated.
- COBOL II, MICROFOCUS COBOL, CICS, QMF, and SPUFI's were the tools extensively used in this environment.
- Key programmer/analyst in support of a conversion project involving the membership system of two merging health maintenance organizations.
- Responsible for analysis, design of specifications, documentation, coding, testing, and verification of the membership data. COBOL II, DB2/SQL, JCL, QMF, and SPUFI's were the tools extensively used in this environment.
- Administrative Leverage System maintained universal life system that included maintaining online, batch and executables in a client/server environment. This included using CA-REALIA, Norton Utilities, Netware Utilities, DOS, Windows, and MF COBOL.
- Automated Eligibility Systems responsible for developing/implementing reformatted for data coming into the company from client companies. Developed a dynamic JCL generator that created JOBS for backing up client data for audit purposes. The environment was COBOL II, COBOL, MF COBOL, EZTRIEVE, QUICKJOB, DB2, VSAM, CICS, TSO, JCL.
- RXPRIME, Vendor Feeds, PIXS development and maintenance of systems which interface with vendors that produce coverage cards for clients. The environment was COBOL II, COBOL, MF COBOL, EZTRIEVE, QUICKJOB, DB2, VSAM, CICS, TSO, JCL.
- CARBS -Solely responsible for converting an IMS database to a VSAM database of a Cash Accounting System utilizing DL/I, DB2, VSAM, QMF SPUFI, DL/I UTILITIES, QUICKJOB, FILE-AID, and COBOL II. Responsibilities included analysis, system design, and forecasting and project implementation.
- Preferred Partners Organization Reporting System Maintenance and enhancement responsibilities. Responsible for delivering reimbursement information via online reports to various areas in the organization. Tools included SAS and FOCUS.
- DB2 DBA responsibilities in a technical helpdesk environment. Responsible for several databases across the various systems copies which included running maintenance utilities such as LOAD, IMAGE COPIES, REORGS, etc. Responsible for standardizing database maintenance JCL utilizing BMC utilities. Developed ISPF Dialog manager to Attach and Detach CICS threads for various TSO environments, and various DB2 copies. Responsible for scheduling RCT's and PSB's.
- AR - Developed new online and batch applications utilizing CICS, DB2, DL/I, TELON, and MF COBOL. Also responsible for maintaining, enhancing, and rewriting existing online and batch applications. Project responsibilities included forecasting and implementation of project life cycle strategy.
- Part of a project team converting Commercial Loan Systems for acquired banks to Connecticut National Banks' in-house systems.
- Responsibilities included file conversions and development of a Financial Reporting package. Technical environment was COBOL, CICS, VSAM, and EASYTRIEVE PLUS.
- Programmer/Analyst part of a project team to design system to South African Company's specifications. Responsibilities included analysis, design, coding, and testing.
- Provided technical support for application programmers within an OS/MVS/XA environment. Supported programmers with TSO, CMS, VSAM, and PANVALET.
- Evaluated and installed vendor software consistent with Personal Financial Security Divisions' requirements. Areas of support included trouble shooting, DB2, SQL, COBOL, CICS, DL/I, VSAM, FILE-AID, AND ASSEMBLER.
- Maintained Divisions' application compiler procedures utilizing IBM Utilities.
- Provided performance evaluation of current systems and new development utilizing STROBE, PATHVU/RETROFIT, and MASCOT.
- Involved in preliminary stages of intelligent workstation development.
- Assisted with promoting corporate wide use of TSO, WSF/2, and PATHVU/RETROFIT software.
- Development and maintenance of online/batch systems within Life, Health, Special Risk, and Pensions.
- Responsible for assisting project development teams design online portions of application systems utilizing Command Level CICS and DMS panels.
- Used INTERTEST and Xpediter extensively for troubleshooting both online and batch applications.
- Generated VSAM files to interface with Aetna's Tax Reporting System.
- Responsible for the Federal and State Tax System FAST , and their respective maintenance staff.
Integrated Logic Systems -
Developed Microprocessor control panels for various machines such a factory flatbed X, Y, and Z , Sherwin Williams Paint mixing machine, tool sharpener, PC card drill.
