Uploaded File
Anne
annepaul9194@gmail.com
904-429-2439
15097 Russell Bridge Dr
Jacksonville, FL 32259
Sr. QA and Systems Analyst
13 years experience W2
3
Recommendations
Average rating
450
Profile views
Summary

Sr. QA with 12 years and 8 months of experience in the US Health care domain. In-depth knowledge about various phases of IT projects which include planning and designing, gathering business requirements, analysis, development, testing, data modeling, data governance, and implementation encompassing both waterfall and AGILE SDLC methodologies.

  • 12+ years of experience in the development, maintenance, enhancement, and testing of mainframe applications.
  • Rich experience in leading technical teams and maintaining client relationships.
  • Strong background in US Healthcare legacy systems, specifically in Provider, Claims Processing, and Member enrollment (834 enrollment format).
  • Expertise in COBOL, JCL, DB2, IMS, and VSAM.
  • Successfully executed various types of projects (development, system integration, compliance, data migration) in Mainframe technology.
  • Conversant with all phases of Project Life Cycle including Requirement gathering, Analysis, Design, Development, Implementation, Quality Assurance.
  • Technical expertise to provide services and solutions that consistently exceed Client’ expectations.
  • Worked on various IBM tools like TSO/ISPF, ABEND aid, File-aid, File manager, Changeman, Endeavor, and other tools like TOAD, HP ALM, IBM Data Studio, Oracle SQL developer, Rally, JIRA, and MongoDB Compass.
  • Extensively used Changeman and Endevor as version controllers.
  • Used and have good knowledge of the SOAP UI tool.
  • Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
  • Trained in CMMI Level 5 processes.
  • IBM Certified DB2 Application Developer.

Skills

Mainframe:

COBOL, JCL, DB2, JCL, VSAM, IMS DB, SPUFI, QMF, SQL, Changeman, Endevor File-Aid, Xpediter, Control-M, IDCAMS, FTP, SORT Utilities, Stored Procedures, File Manager, Debug tool, AbendAid, Fault Analyser, SOAP UI, Blaze advisor, Teradata, and Table Base.

MS Office:

Word, Excel, and PowerPoint

Tools:

ALM, Rally, IBM Data Studio, Toad, SQL Navigator, Selenium, MS Project, and MS Visio.

Experience
Sr. System Analyst
Insurance
Dec 2020 - present
Jacksonville, FL

Currently, for the ITS home claims, the DF (Disposition Format) is not automatically populated for all claims. Those claims will have to be pulled by an operator and DF will have to be populated manually in B2. As part of this internal project, the claims that are not DF automated and analyzed to understand how DF could be automated. By DF automating the claims the cost of manually creating the DF by an operator can be reduced.

Roles & Responsibilities:

  • Facilitate the meetings with the business, development team, and testing teams.
  • Analyze the changes and create the technical requirements in JIRA.
  • Organize the requirement walkthrough with testing and development teams.
  • Create and present the FRP (Functional requirements Presentation), review TDD, UTR.
  • Review and test sample claims.
  • Offshore coordination.
  • Support and facilitate SIT, UAT, and production pilot testing.
  • Prepare implementation plan and coordinate the final implementation activities.
  • Support the release checkout activities
  • Prepare and share the project status reports with senior management

Environment: COBOL, DB2, JCL, IMS, Endevor, JIRA, Teradata, MS Excel, MS Word, MS Teams.

Microsoft Excel System Analysis UAT Teradata JIRA DB2 Cobol ENDEVOR JCL IMS TDD
Remove Skill
Senior Testing Specialist
Insurance
Dec 2016 - Dec 2020
Jacksonville, FL

The APS system will handle the payments for Providers. In order to process the payments, they need the data from the dataland tables. Since they cannot have direct access to FB tables (dataland tables), the APS DL team extracts the data that the APS team may need for their payment calculations and shares it as an extract on a daily basis. APS DL generates member extracts, policy extracts, product extracts, and provider extracts.

Roles & Responsibilities – QA Analyst/Tester :

  • QA test planning - Analyze BPR (Business Process Rules) and drill it to the technical details.
  • Prepare the test Approach document, test cases, and test plan.
  • QA test case authoring and execution - develop the SQL queries corresponding to the technical requirements and execute the queries corresponding to each of the requirements; validate the extract data.
  • QA status project updates - Execute the test cases in Rally and update the status.
  • Verify the target data by executing the SQL Scripts in IBM Data studio/SQL Navigator/TOAD, Mongo DB, Postgres.
  • Log defects if any found during the testing.
  • Interact with the Development team/SA to discuss and validate the results/defects and manage all Defects to closure.
  • Facilitation of defects during UAT

Environment: IBM Data Studio, Rally, SQL Navigator, SOAP UI, TOAD, MS Excel.

UAT TOAD Test Planning Test Case Preparation SQL SQL Navigator SOAP Rally PostgreSQL MongoDB BPR Agile Methodology Oracle System Testing Microsoft Excel DB2 Backend Testing Database Testing Manual Testing Microsoft Word Hive Requirement Analysis XML HP ALM Quality Assurance
Remove Skill
References
Average Rating

1 recommendation
Systems Analyst
Insurance
Sep 2016 - Dec 2016
Woodland Hills, CA

Project: SSD Atomic Services WGS/ISG SSCR &POR Delivery Project

Support the new services used by the Blue exchange system for the pre-authorization and pre-determination checks. These new services help the providers and users save more time because providers will be able to obtain the right information more quickly, enabling them to make better decisions.

Roles & Responsibilities:

  • Analyze the change request and drill down to the technical requirements.
  • Prepare HDD – high-level design documents, review TDD, checklists, pre-delivery checklists.
  • Review and test COBOL programs, JCL's.
  • Offshore coordination
  • Support code migration and facilitate SIT and production pilot testing.
  • Prepare implementation plan and coordinate the final implementation activities.
  • Prepare and share the weekly project status reports with senior management.

Environment and tools: COBOL, DB2, JCL, IMS, Changeman, SOAP UI, Rally.

System Analysis SOAP WGS DB2 Cobol CHANGEMAN TDD JCL IMS
Remove Skill
QA Analyst
Insurance
Sep 2014 - Aug 2016
Jacksonville, FL

Project: CIP/CON - QHP014-01 QHP 2015 / Individual QHP/ NQHP Data Landing

The object of this project is to verify that External Vendor (HPS, NASCO) mainframe source data lands in CIP/EDW DBs successfully. Data sources in the 834 file layout and warehouse feeds are in the mainframe file format structures and the data needs to land in CIP and EDW based on existing rules described in the mapping documents.

Roles & Responsibilities:

  • QA test planning - Analyze BPR (Business Process Rules) and drill it to the technical details.
  • Prepare the test Approach document, test cases, and test plan and load it to ALM to check if the data landed in the DBs as expected.
  • QA test case authoring and execution - develop the SQL queries corresponding to the technical requirements and execute the queries corresponding to each of the requirements; validate the EDI 834 enrollment file data.
  • QA status project updates - Execute the test cases in HP ALM and update the status.
  • Verify the target data by executing the SQL Scripts in IBM Data studio/SQL Navigator/TOAD.
  • Log defects if any found during the testing.
  • Interact with the Development team/SA to discuss and validate the results/defects and manage all Defects to closure.
  • Facilitation of defects during UAT

Environment and tools: Mainframe, IBM Data Studio, HP ALM, SQL Navigator, SOAP UI, Selenium TOAD.

SQL Test Case Preparation Test Planning UAT Quality Assurance HP ALM BPR EDI 834 SOAP SQL Navigator SDLC Microsoft Excel Oracle System Testing Waterfall Rally Backend Testing DB2 Microsoft Word Requirement Analysis XML Database Testing Selenium
Remove Skill
References
Average Rating

1 recommendation
Sr. Software Developer/SA
Insurance
Jul 2013 - Sep 2014
Woodland Hls, CA

Support the new services used by the WATSON system for the pre-authorization and pre-determination checks. These new services help the providers save more time because providers will be able to obtain the right information more quickly, enabling them to make better decisions about how they care for their patients.

Roles & Responsibilities:

  • Requirement Gathering, System Analysis, System Design
  • Detailed study of BRD and HDD/TDD and create all possible test cases.
  • Develop and maintain batch processes, report programs, and unit test the components.
  • Create one-time JCL's.
  • Worked extensively in the developing and unit testing COBOL, IMS, DB2, and JCL applications.
  • Developed and tested COBOL programs using SOAP UI.
  • Lead a team of 4 members.
  • Coordinating with offshore team and reviewing COBOL programs.
  • Executed System testing, Integration & Regression testing.
  • Provide timely status updates and escalations to management.

Environment: COBOL, DB2, JCL, IMS, Changeman, SOAP UI.

DB2 SOAP CHANGEMAN IMS JCL Cobol Unit Testing TDD Scala Regression Testing BRD System Testing
Remove Skill
Technical Lead/ Software Developer
Insurance
Jan 2011 - Jun 2013

The scope of this project included extracting and passing the WGS Limited liability data and the Accum data for the groups that were to be migrated. Due to the nature of the project being very close to the client’s business, this project was helpful in understanding the Healthcare business in a very broadway.

Roles & Responsibilities:

  • Prepare TDD, UTP, UTR review checklists, pre-delivery checklists.
  • Developed and tested COBOL programs.
  • Analyze and review existing COBOL programs and JCL
  • Setup test environment, support code migration and facilitate SIT and production pilot testing.
  • Prepare implementation plan and coordinate the final implementation activities.
  • Scheduled and ran the production jobs and monitored the ABENDS.
  • Prepare and share the weekly project status reports with senior management.

Environment: COBOL, DB2, JCL, IMS, Change man, VSAM, File aid.

DB2 Cobol CHANGEMAN VSAM JCL IMS WGS TDD
Remove Skill
Software developer, QC/DPC
Insurance
Sep 2010 - Dec 2010

Project: Pharmacy ESI Migration

The objective of this project was to identify Dual Coverage Enrollee and Duplicate Member ID enrollee and populate the corresponding BIN numbers and transfer the data to ESI on a daily basis. The BIN number is populated as ‘610053’ for all the ProServ records. These records would be loaded to the ESI exception database. After migration, claims would be compared against the exception DB to determine the system in which the claims need to be adjudicated.

Roles & Responsibilities:

  • A careful reading of BRD and HDD and clarify all questions with Business/System analyst.
  • Develop and maintain batch processes, report programs, and unit test the components.
  • Create one-time JCLs for migration of data.
  • Worked extensively in the developing and unit testing COBOL, IMS, DB2, and JCL applications.
  • Prepare TDD, UTP, UTR
  • Prepare and share the weekly project status reports with senior management.
  • Running the daily/weekly jobs and updating the results.

Environment: COBOL, IMS DB, JCL, and Table Base

DB2 BSA BRD JCL System Analysis IMS Cobol TDD Unit Testing
Remove Skill
Software Developer
Insurance
Jul 2009 - Aug 2010

Project: WPD Autobagging

The Auto Bagging sub-system is a part of the Health insurance system. The Auto-Bagging project deals with the setting up of adjudication in an automatic fashion, rather than a manual one. The new business situation is to develop the WPD application to set up adjudication through an automated process, requiring limited manual intervention. In the current system, this logic depends on the product structure, which needs a lot of manual intervention. But in the automated one, the logic would be depending on the subset of the product structure, which would be more accurate by eliminating the Bag Id and setting rules and questions to each benefit covered in the claim.

Roles & Responsibilities:

  • Analyzing the requirements, design, coding, unit testing.
  • Preparation of the test data and maintaining the trackers.
  • Running the daily jobs, validating the results, and sending the reports to clients.
  • Analyzing the existing COBOL Programs and coding the change requirements.
  • Assist the SIT team to develop test plans and testing strategies.

Environment: COBOL, IMS DB, JCL, CHANGEMAN, ABEND-AID, XPEDITOR, and Table Base

Cobol CHANGEMAN JCL IMS ABENDAID XPEDITOR Unit Testing Test Planning
Remove Skill
Software Developer
Insurance
Aug 2008 - Jun 2009

Project: ETS Accumulator POC

ETS Accumulator Proof of Concept project aims for a single and consolidated view of accumulators for both IT and business with improved claim accuracy for “shared accumulators”, also eliminating out-of-sync accumulator reporting and issues, thus having a single view of accumulators throughout the enterprise.

Roles & Responsibilities:

  • Design – understanding the requirement and prepare the TDD and RTM from HDD.
  • Coding of COBOL DB2 programs.
  • Review COBOL and JCL's.
  • Unit testing – prepare UTP, UTR.
  • Maintaining Trackers

Environment: COBOL, JCL, FILE-AID, CHANGEMAN, XPEDITOR, DB2 programs

DB2 CHANGEMAN File-Aid Unit Testing TDD Cobol JCL XPEDITOR
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Information Technology
Cochin University. TKM Institute of Technology 2007
Certifications
Certified DB2 Application Developer
IBM
Certified Database Associate - DB2 Universal Database V8.1 Family Certificate.
IBM
Skills
DB2
2021
11
SOAP
2020
7
System Testing
2020
7
Test Planning
2020
7
Cobol
2021
6
JCL
2021
6
Microsoft Excel
2021
6
UAT
2021
6
Backend Testing
2020
5
BPR
2020
5
CHANGEMAN
2016
5
Database Testing
2020
5
HP ALM
2020
5
IMS
2021
5
Microsoft Word
2020
5
Oracle
2020
5
Quality Assurance
2020
5
Rally
2020
5
Requirement Analysis
2020
5
SQL
2020
5
SQL Navigator
2020
5
TDD
2021
5
Test Case Preparation
2020
5
XML
2020
5
Agile Methodology
2020
4
Hive
2020
4
Manual Testing
2020
4
MongoDB
2020
4
PostgreSQL
2020
4
TOAD
2020
4
MS Visio
2014
1
Unit Testing
2014
3
VSAM
2013
2
WGS
2016
2
Software Engineer
2014
1
Software Testing
2014
1
834
2016
1
ABENDAID
2010
1
BRD
2014
1
EDI
2016
1
Regression Testing
2014
1
Scala
2014
1
SDLC
2016
1
Selenium
2016
1
Waterfall
2016
1
XPEDITOR
2010
1
CICS
2016
1
Project Planning
2010
1
REST
2014
1
BSA
2010
1
BTEQ
2021
1
CMMI
0
1
Compliance
0
1
Configuration Management
0
1
ENDEVOR
2021
1
ETL
0
1
File-Aid
2009
1
FTP
0
1
IBM WTX
0
1
J2EE
0
1
Java
0
1
JIRA
2021
1
MS Project
0
1
mSQL
0
1
Requirements Gathering
0
1
SCOBOL
0
1
SQL Developer
0
1
Stored Procedure
0
1
System Analysis
2021
1
Teradata
2021
1
UI
0
1