Belavendiran
PROFESSIONAL EXPERIENCE:
10+ Years of strong experience in Software Quality with 7+ years of strong experience in Test
Data Management (TDM)
Currently working as Automation Data Analyst for Automating & flowing Data across End To End
Systems spanning multiple technologies including Mainframe (DB2), ETL, Oracle.
Experience as DevOps Engineer with 5+ years of hands-on experience in automating and
optimizing mission critical deployments and in developing CI/CD pipelines.
Home Depot Experience: 5+ years (2012 to 2017) overall experience in Home Depot in
Merchandising (Pricing, Discount Engine) and Test Data Management Team (E2E Data
automation for SKU Creation & Transmission, Transmission of New Vendor, PO transmission,
Mainframes Batch execution etc.)
Anthem Experience: 10+ years (2005 to 2012 & 2017 to till date) overall experience in Anthem
Inc in Membership, ANSI Transactions (270/271, 276/277, 278, 834, 835, 837), Gentran, Finance
(Claims and Provider Payment), SOA, Spending Accounts, Benefits, Member Billing, Non-
Strategic Source Systems (CS90/ACES/CHIPS/FACETS/GBDFACETS), Strategic Source Systems
(WGS/ISG-STAR), Reimagine Consumer Portal (RCP) and Test Data Management Team – Setting
up members from source system and loading them to EHUB tables and registering the members
for End to End testing.
5+ Years of Mainframe development/maintenance experience in EDI Transactions –
Online/Batch
15+ Years of sound IT experience in both Development and Functional areas.
Quality Assurance – Web based & client-server applications, Mainframe and Database Testing
validation. Automation experience with Selenium and Restful API for Front End and Back End
Automation.
Methodologies – Waterfall and Agile Methodologies
Business Experience in Retail (Merchandising/Supply Chain/Store systems) and Healthcare
Domains (Membership/Claims Process/Benefits/Spending Accounts/Pharmacy)
Summary
Experience in all aspects of the Software Development Life Cycle & Defect management life
cycle, with specific focus on development and manual/automation/cloud testing
Strong expertise in Automation & Manual testing in Web-Browser and client/server
applications, Mainframe Testing, DB2 Testing, ETL Testing, Agile Testing, User Acceptance
Testing, System Integration Testing (SIT), System Acceptance Testing, SOAP UI Testing,
Rest Assured Automation Testing and Cloud Testing (Web Services Testing).
Share point testing, Analytical, Quantitative analysis testing.
Experience in maintaining Test data across different LLC environments using Test Data
Management Tool
Experience in Service Oriented Architecture (SOA) software design
Experience in automation testing using CA Lisa - DevTest for Web Services
Experience in running performance tests using CA Lisa DevTest
Experience in testing JSON/XML messages with REST API services
Experience in partnering with SDET for automation within the sprint
Test Data Management (TDM) – HOME DEPOT
o Experience in setting up End to End Test data for SKU creation and pushing the SKU
to stores
o Experience in automating the End to End process for SKU creation, POWMS, PO2DC
and TOSTORE process
Experience in scheduling/running the test scripts from Jenkins
Experience in testing Cloud hosted web applications and Web Services
Experience in maintaining the automation scripts in GIT source
Experience in creating automation scripts using Selenium with Homer Framework
Experience in automating Restful API services using BDD Lites Framework
Experience in creating automation scripts in Postman and running Json collection using
Newman
Experience in End to End Testing making sure the flow of data is accurate across the
different systems.
Experience in Store Application KIOSK – Point of Sale (POS) for verifying the discounts in
Cash Register
Experience in creating Daily, weekly and monthly metrics and publishing the reports for
Clients
Experienced in SQA (Software Quality Assurance) with tools such as Quality Center and HP
Application Life Cycle Management (ALM).
Work experience in using the Quality Center/HP ALM to manage the software testing
process by creating Defects and tracking them till they are getting closed
Worked directly with Business Analysts/Product Owners to gather and understand the
requirements.
Specialized in user requirement analysis, Requirement traceability matrix, documenting
test plans, execution of test cases to verify application functionality against business
requirements.
Strong Experience in creating Test estimations, Test strategies and Test Plans, writing and
executing Test Cases, Test scripts and Automation Testing
Extensive experience in GUI, Regression, Functional, Integration, System, User Acceptance
(UAT), Cross Browser, Security and Database Testing.
Comfortable working with MVS/ZOS Mainframe Platform, COBOL, JCL, HTML, DB2, IMS,
Informix DB, Oracle, SQL, MongoDB
7+ years of hands on experience on ZOS/Mainframe Batch Jobs and Online CICS screens
development and testing.
Excellent team leading capabilities with excellent written, verbal communication and
interpersonal skills
Experience in handling multiple Projects across different portfolios and strong experience in
Multi-Vendor environment
Certified in the Agile Methodology with strong experience in Agile Tools JIRA, Pivotal
Tracker
Good in handling offshore-onshore (Global Delivery Model) projects.
Ability to handle multiple tasks and work independently as well as in a team
Strong Experience in creating test members based on requirement using the Healthcare
FACETS Application .
FACETS Member enrollment and loading the members to EHUB UAT Tables for further
Testing.
Working with FACETS Team to create Claims for the created members and load them into
EHUB Claim table for Processing.
NASCO – Good Experience on creating/enrolling NASCO members through EMOL
application. Loading the created members to EHUB tables for verification and Testing
through ReImagine Consumer Portal
Have exceptional work ethics and time management skills.
TECHNICAL SKILLS
Web & Client/server, Manual Testing, Mainframe Testing,
Analytical, Database Testing, ETL Testing , Quantitative
analysis testing, System Integration Testing, System
Testing Skills Acceptance Testing, Performance Testing, User Acceptance
Testing, Pivotal Cloud Foundry(PCF), Google Cloud Testing,
Web Services Testing, API testing, Automation Testing, Rest
Assured, SOAP Services, Point of Sale(POS) Testing
HP Quality Center, ALM, CA Lisa DevTest, Postman, SOAP UI,
Testing Tools
JMETER, NeoLoad, Jenkins, SQ Hub
Message Transactions EDI ANSI Transactions, XML, JSON
Defect Tracking Tools HP Quality Center, ALM, JIRA, Pivotal Tracker
Mainframe Skills JCL, Cobol, VSAM, IMS DB, CICS, Batch Jobs, DB2
Windows, Z/OS, Unix
Operating System
VB,COBOL, Easytrieve, CICS, JCL, QTP-Basic, Java Script, Basic
Languages
JAVA
HTML, VB script, Dev Test , Postman, Restful Service,
Web technologies
Selenium IDE
Middleware Message Queue - MQ
DB2, Oracle, MS Access, VSAM, Informix DB , Cassandra DB,
Database
IMS DB, Mongo DB, HIVE
Ansi Generator tool, Mercator Tool, De-Identification Tool,
Quality Control, File Manager, File Aid, Fault Analyzer,
Other Tools
Gentran, ChangeMan , Xpeditor, SPUFI, CA7- Job Tool , GIT
Hub, SQL Developer, TOAD, DB2 Client, Optim
HCLS – 10 Years of Experience
Domain Retail (Merchandising/Supply Chain/Pricing - Discount
Engine)– 5 Years
CERTIFICATIONS/TRAININGS
E1 Certification – Health Care and Life Science (HCLs)
Agile Certificate – Testing
PROFESSIONAL EXPERIENCE
Client: Anthem Inc, Mason, OH Oct 2017 – Till Date
Role: Software Development Engineer in Test/Data Analyst
1. SOA ReImagine Anthem – Membership CDHP/ReImagine Consumer Portal
Responsibilities:
Working with different backend teams(ACES/CS90/CHIPS) to create/identify specific
member data for testing the API services for specific JIRA stories
FACETS :
o As part of NSS Migration worked on creating/enrolling new members in
FACETS Application and loading the members to EHUB for verification
o Creating multi contract FACETS members as part of Test data creation.
o Working with FACETS team to create the necessary claims and load the
claim details to EHUB tables for testing.
o Verifying the loaded claims in ReImagine Consumer Portal making sure the
claim flow is maintained across the different sources
Creating new members/subscribers/dependents using FACETS/GBD FACETS
Application and load the members to EHUB UAT Oracle DB
Running the necessary Mainframe jobs to load the members from Mainframe DB
tables to Oracle DB tables
Running the necessary ETL jobs to load the specific members from different backend
systems to EHUB UAT Oracle DB tables
Running the necessary automation scripts to register/create the UserID’s for the
members.
Creating automation scripts in Postman and running Json collection using Newman
Integration.
Thorough analysis of user stories for their completeness
Design, develop and customize the back-end automation test scripts using Rest
Assured API
Co-ordinate the development and maintenance effort of automation framework
and automation scripts for business scenarios.
Develop API automation test scripts using JavaScript for SOA Test
Prepare and execute Performance tests using Apache JMeter and analyse the results
against SLAs (Response time and Throughput).
Creating tasks in JIRA under the specific stories as part of Test data dependency
Working on WGS system and ISG system for identifying the test data based on
requirement.
Creating medical claims for WGS members in Test environment and loading them in
EHUB UAT Oracle Test DB
Verifying the NASCO members and making sure they are in sync with Test
Environment EHUB tables
Creating WGS/ISG/NASCO members with HSA/HRA/HIAPlus accounts and load them
into LITES Test Environment
Testing cloud hosted web applications and web services.
Testing the membership API services and Docker Services based on the identified
data for verification
System Integration Testing covering the API services between SOA API and different
backend API services
Running the regression automation test suite in Lower Life Cycle environment
System Acceptance Testing covering the Anthem ReImagine API service and SOA API
Service Testing
Working on the EHUB tool to extract and create test data across all Lower Life Cycle
Environments
Working on the SET TDM tool to load data into CHUB environment for Integration
Testing
Involved in E2E testing for the membership API services
Involved in story grooming and breaking the complex stories into minimal stories
based on functionality to ensure the Agile methodology
Involved in Functional Testing for the membership API services using SOAP UI
Executing simple and complex queries in IBM DB2 and Oracle for data analytics and
testing
2. SOA DEIDENTIFIED EHUB - Masked Virtual DB
Responsibilities:
As part of TDM team involved in copying the Production Member data from source
to target Virtual DB and masking the PHI details through Optim Tool using lua script
Involved in copying the masked data from source to specific SIT Virtual DB.
Worked with respective application teams and collected all the necessary API
services associated with Consumer Portal application.
Worked with Config/Devops team to update the SIT config file of each service to use
the Masked DB in SIT Test environment.
Verified the masked data using the common identifier to make sure the data is
masked correctly and PHI details are not showing.
As part of application verification ran the necessary API services to make sure all the
services are working fine with the newly pointed Masked Virtual DB
Tools Used : JIRA, SET TDM UI, ReImagine Consumer Portal (RCP) Tool, Rest Assured API, JMeter,
Postman, DB2 Query Tools, EnB Tool, FACETS , GBDFACETS, Node JS, Newnan, Clarity ID Card, CAD
Admin, Compass Mongo DB, OPTIM (Data Masking), HADOOP, HIVE, TOAD Tool, MSWord, MS Excel,
DB Visualizer, Oracle SQL, SOAP UI, Mainframe – IBM DB2, IMS DB, SPUFI, FILEAID, JCL, COBOL, CICS
Client: The Home Depot, Atlanta, GA Jan 2015 – Sep 2017
Role: Test Data Management/QA Automation Lead
3. Merchandising –Pricing Discount Engine
Discount Engine involves in creating different discounts for both online and Store SKU’s.
Responsibilities:
Creating Test estimations, Test strategies and Test Plans, writing and executing Test
Cases.
Business requirement analysis to understand the scope of Epic Story/Task assigned
for each Sprint.
Design, develop and customize the back-end automation test scripts using
Rest-Assured and Postman for the necessary Business functionality
Conducting User Acceptance Testing/System Acceptance Testing on PromoAdmin UI
to verify the developed application satisfies the business needs as mentioned in the
feature story
Testing the Discount Engine application based on the stories for each sprint created
in Pivotal tracker
As part of DevOps creating and maintaining the CI/CD pipeline in Jenkins for
continuous integration and testing.
Maintaining the automation code in Github and making sure the right code is
executing through Jenkins
Managing the Test Data Management tool to extract and create test data across all
Lower Life Cycle Environments
Managing the created discount data is sync between discount Price application and
Label Print application for System Integration Testing
Point of Sale (POS) Testing :
o As part of End To end Testing created discounts for the item/sku through
the Pricing Discount application for the specific stores/markets.
o Verify the discounts are available in both Label Print tables and Point of sale
system.
o Run the necessary label process to print the label and verify the created
discount details are printing successfully
o Verify the discounts are showing correctly in Point of Sale (POS) system and
reflecting in the final purchase bill.
Involved in Functional Testing for the different promotions created and store in
Google Cloud GPAS
Performed the Functional , End-to-End, Regression, UAT and Production Support
Testing for Cloud applications in Pivotal Cloud Foundry and Google cloud
Executing simple and complex queries in IBM DB2 and Oracle for data analytics and
testing
Involved in creating single SKU bulk request through REBA application and
Mainframe jobs
Automate and execute Web Service Testing using Rest Assured and Java
Executing Performance Testing in CA Lisa DevTest for the different Web Services
available in the application
Creating Traceability matrix and executing test cases in HP ALM and validating the
results
Running the unit tests, Functional Tests, Implementation tests in Concourse and
publishing the results in SQHUB for Audit
Creating and publishing the daily, weekly and monthly project and defect reports to
higher management
Involved in preparing the necessary documents required for Implementation Review
Board (IRB) to deploy the changes
Tools Used : Pivotal Tracker, Discount Admin UI, Postman, HP Quality Center 10, DB2 Query
Tools, MSWord, MS Excel, DB Visualizer, Redis in Cloud, Selenium, CA LISA DevTest, DevOps
– (Jenkins, Git), Rest Assured, TestNG, Mainframe – IBM DB2, SPUFI, FILEAID, JCL, COBOL,
CICS
Client : The Home Depot, Atlanta, GA Apr 2013 – Jan 2015
Role: Test Data Management/QA Automation Lead
4. Merchandising –Store Level Pricing
SLP Project involves pricing the SKU at specific store level apart from pricing the items at
Market Level where the same SKU will have different retail price across different stores.
Responsibilities:
Creating Test estimations, Test strategies and Test Plans, writing and executing Test
Cases.
Testing the PACMAN/REBA application based on the JIRA stories for each sprint
Creating the SQL queries and setting up the test data in DB2 using SQL developer
Running necessary mainframe jobs for creating Store level price changes,
Promotional Price Changes , Clearance Price Changes and Market Level Price
Changes
Tested and Implemented the Store Level Price using Agile Testing Methodology for
monthly Production Release
Managing the Test Data Management tool to extract and create test data across all
Lower Life Cycle Environments
Managing the Test Data is sync between different environments for Integration
Testing by running necessary Mainframe jobs
Performed the Functional , End-to-End, Regression, Performance, UAT and
Production Support Testing
QA Lead for the members of offshore and review their deliverables before sharing
the results with client
Creating Traceability matrix and executing test cases in Quality Center and
validating the results
Creating and publishing the daily, weekly and monthly project and defect reports to
higher management
Tools Used : PACMAN, REBA Application, HP Quality Center 10, DB2 Query Tools, MS
Project, MSWord, MS Excel, DB Visualizer, SQL Developer, JIRA, JENKINS, Selenium, Git
Mainframe – IBM DB2, SPUFI, FILEAID, JCL, COBOL, CICS
5. Merchandising – Item Data Management (IDM)-ETL Testing
Creating new item in IDM and pushing the item along with the attributes across different
types of environment tables through ETL jobs.
Responsibilities:
Leading the Project with 6 team members
Involved IDM – Data Mapping and prepared the necessary queries to understand
the mapping rules between the different tables in DB2 and Oracle tables.
Involved in understanding the Mapping between DB2 CCD tables and the
corresponding entries in Oracle Target tables
Involved in IDM – Pricing project for Test data set up in IDM STEP server and making
sure the correct data are being delivered to Project team for their testing.
Involved in analysis , test case preparation using Table Mapping rules, test case
review and Quality activities in HP ALM
Prioritizing, tracking and reviewing the deliverables received from offshore and
ensuring the quality delivery on time.
Creating triggers through application which will be used by ETL jobs for updating the
tables
Coordinating with customer to make sure all changes are going through fine.
Responsible for Onsite-offshore co-ordination activities and necessary weekly
reports for customers
Tools Used : IDM Vendor Portal, IDM STEP Application, HP ALM, DB2 Query Tools, MS
Project, MSWord, MS Excel, SQL, IBM DB2, Oracle , DB Visualizer
6. Supply Chain IPR/DC – Test Data Management (TDM) and WMS
Involved in creating the Test Data Management tool through which different Project teams
will raise requests for Test Data Setup for their projects.
Responsibilities:
Leading the Project with 4 team members
Involved in TDM tool design for analyzing the different types of requests that will be
raised by the Project teams
Prepared the necessary adhoc mainframe jobs required for creating the test data in
Mainframe DB2 and Informix DB2 tables
Involved in automating the single/bulk SKU creation process and pushing the SKU’s
to specific stores as per Test data requirement.
Involved in creating POWMS, PO2DC, TOSTR, OMPHO, EDIBYO files through
mainframe jobs and FTP the respective files to the required WMS Server
Worked with Mainframe support team to schedule the necessary automated
mainframe jobs for creating POWMS, PO2DC and TOSTR files.
Prioritizing, tracking and reviewing the various requests raised by the Project teams
and processing the requests based on priority level.
Involved in Analysis, Code review, Test Review and Quality activities
Coordinating with customer to make sure all changes are going through fine.
Responsible for Onsite-offshore co-ordination activities and necessary weekly
reports to higher management with the list of requests raised by different teams
Tools Used : TDM Request Tool, Mainframe –COBOL, JCL, DB2 Query Tools, MS Project, MSWord,
MS Excel, EDI Ansi Message
WELLPOINT, GA Oct 2009 – Mar 2013
Role : Project Lead/Team Management
1. QCARE-LOQ
QCRARE system involves the Creation and maintenance of Member Enrollment for different
Medical policies, Member eligibility/ benefit details and Provider Payment details.
Responsibilities:
Involved in QCARE LOQ Finance process which involves in generating the Provider
Monthly payment through Electronic Fund Transfer and Check Printing method.
Developed the COBOL source code for the new and existing application
Monitoring the Production jobs and fixing the abend making sure all the Finance
jobs are going through fine without any issue within the workaround time
Debugging the COBOL and CICS (Online Screen) codes for fixing the issues.
Performed Unit Testing for COBOL Codes and for CICS Online Screens.
Excellent logical and analytical skills
Extensive knowledge on EDI ANSI transactions – x12 (830)
Hands on expertise in XPEDITOR for debugging the online CICS programs
Involved in Analysis, Code review, Test Review and Quality activities
Involved in automating the mainframe testing using the QTP (Quick Test
Professional) tool by writing the necessary VB script based on business functionality.
Involved in creating new JCL and updating existing JCL as per the requirement
Hands on expertise on CONTROL-M job scheduling and Changeman Tool
Responsible for Onsite-offshore co-ordination activities
Tools Used : COBOL, JCL, Easytrieve, CICS, DB2,File Aid, File Manager, ChangeMan, CICS,
Control M, QTP Tool, VB Script
2. QCARE-Finance Test Region
Creating a new test region for the QCARE Finance System
Responsibilities:
Analyzed and guided in preparing the list of files, Programs, Transaction Entries,
table details, table entries needs to be updated for the new Test region.
List of Changes to be made to the Files, Programs, Tables, jobs, control cards with
respect to the new Test region.
Run the batch job using JCL in mainframe for uploading the Test data as per the
specific requirement.
Responsible for Onsite-offshore co-ordination activities.
Tools Used : COBOL, JCL, CICS, DB2,File Aid, File Manager
WELLPOINT, Mason, OH Oct 2008 – Sep 2009
Role : Test Engineer
1. Integration Architecture System
IAS is a gateway through which all the ANSI requests will flow to different systems and the
specific response for each request will be sent back through IAS EDI gateway.
Responsibilities:
Involved in testing the ANSI requests for QCARE system
EDI ANSI request involves – 270/271 , 276/277 and 278 Provider Referal request
Involved in preparing test strategies for client side verifications and validations.
Involved in functional testing, negative testing, regression testing, and End-to-End
Testing
Participated in Daily Stand-up Meetings and provided status on work progress.
QA Lead for the members at offshores and review their deliverables before sharing
the results with the client.
Excellent logical and analytical skills
Hands on expertise in Ansi Generator Tool, Mercator Tool for converting the XML to
ANSI
Responsible for Onsite-offshore co-ordination activities
Tools Used : VSAM, File Aid, File Manager, Mercator Tool, EDI Ansi Generator Tool, ChangeMan
WELLPOINT Dec 2004 – Sep 2008
Role : Software Engineer
1. QCARE – EDI Gateway Real Time
EDI Gateway is the process in which the members submit their requests and verifies the
Policy Benefit response , providers verifies their payment details .
Responsibilities:
Involved in monitoring the different types of ANSI real time requests and making
sure the responses are going within the specified time frame
ANSI request involves – 270/271 , 276/277 and 278 Provider Referral request
Batch processing ANSI requests – 834, 835 and 837 transacations.
Involved in monitoring the Requests queues in Message Queue and making sure the
request are picked up by the CICS process and responses are sent within the time
frame.
Involved in fixing the production issue by removing the request containing invalid
data and processing them separately.
Monitoring the daily production mainframe jobs and making sure all jobs are going
through fine without any issues.
Creating new COBOL programs and fixing the existing COBOL programs as per the
requirements
Excellent logical and analytical skills
Debugging the COBOL and CICS (Online Screen) codes for fixing the issues.
Performed Unit Testing for COBOL Codes and for CICS Online Screens.
Hands on expertise in XPEDITOR for debugging the online CICS programs
Involved in Analysis, Code review, Test Review and Quality activities
Involved in creating new JCL and updating existing JCL as per the requirement
Hands on expertise on CONTROL-M job scheduling and Changeman Tool
Responsible for Onsite-offshore co-ordination activities
Tools Used : COBOL, JCL, CICS, VSAM, File Aid, File Manager, MQ, Xpeditor, Control M