Shaik Mohamed chandpachu

Over 14+ years of experience in ETL/DWH testing, Big data testing, Mainframe testing, API testing & Automation testing. Expertise in testing Web services using Rest Assured BDD Framework, Parasoft SOA, SOAP UI and Postman. Extensive experience in ETL testing using Informatica and Big data tools.

Expertise in Mainframe testing both Batch validations and online validations using JCL batch jobs and online screens. Worked on developing new API micro services using .Net for SOS project. Responsible for all QE responsibilities within sprint: Requirements Grooming, Test Planning, Data Setup, Test Scripts Creation/Maintenance, Test Execution, Defect Reporting.

Solid understanding of SDLC, STLC best/proven practices in Software Testing and Quality Assurance.

Experience in writing test plans, test cases, test procedures and test scripts from requirements and use-cases.

Experience in Performance testing of Rest API's using MOX scripts. Proficient in developing excel macros to validate the data.

Experience in validating transaction logs in DEVO and ADX. Expertise in documenting defects using bug tracking tools such as JIRA and HP ALM (QC). Strong SQL experience in different Databases like Oracle, MS SQL Server and DB2, Azure database.

Certified Scrum

Master and completed 35 hr PDU's for PMP certification and preparing for the PMP certificate examination.

Test Analyst - Cognizant/Manulife/John Hancock - Halifax, Nova Scotia

(2022-04)

Project: EDGE Production Support

• Analyzing the production tickets opened by business team and working on with the integration teams for the fix.
• Developing/Maintaining Proactive report automation suits and executing daily and identifying the production issues before business users report the issue.
• Working with Business team on daily Production Issues triage call and providing the status for all open issues.
• Experience in developing new Restful API's using .Net for Summary Orchestration Service application.
• Working as Onsite coordinator for Offshore team.
• Developed/Maintaining edelivery proactive report to validate API services responses for bulk policies.
• Developed/Maintaining UI automation proactive report to validate Salesforce Opportunities are created with correct data.
• Developed/Maintaining ELS reconciliation using excel macros.
• Developed evidence data validation proactive report using Python.
• Developed daily Correspondence reconciliation report using Python

Test Analyst - Cognizant/Manulife - Halifax, Nova Scotia

(2021-10 - 2022-03)

Project: Global retirement data lake

• Analyzed business STM (source to target mapping) documents for the MVPs and work closely with the business team to get clarifications addressed.
• Prepare the test cases for all the transformations from STM documents.
• Execute the Oozie workflows to ingest the data from Ingestion layer to Curation layer and Curation layer to Semantic layer.
• Validate the test cases in Curation and Semantic layers.
• Validated the Ingestion of 5 sources data from MS SQL Server to Hive using pyspark framework.
• Validated the Ingestion of 2 sources data from excel files to Hive using pyspark framework.
• Validated Ingestion of API source to Hive using pyspark framework.
• Experience in bug tracking and reporting using Jira and HP ALM.
• Write and execute HQL queries using unix platform.
• Automate the HIVE validation using shell scripts.

Test Analyst - NTT Data/Fidelity Investments - Halifax, NS

(2020-08 - 2021-09)

Project: UID_migration

• Involved in creating test plans, test cases, test scripts, requirement traceability matrix and other test deliverables for UID requirements.
• For generating the UID for each participant, Participants contacts details like telephone, email, name, address and govt id data should be loaded to Oracle database through QREP realtime replication from DB2 tables.
• Informatica workflows are executed to load the participants data from different source systems like IDB and FPRS as batch proces.
• Validated the reject records from batch process and QREP process and reloaded them by running the reject reprocessing workflow for each target table.
• Validated the ESP (event streaming process) to make sure the outbound event messages are generated for all the events and Reltio system consumes all the events and UID is updated correctly in UID table for each participant through inbound ESP process.

Test Analyst - NTT Data/Fidelity Investments - Halifax, NS

(2019-07 - 2020-07)

Project: Realtime Prelims -RTP

• Mainframe SCF files will be created with participants Indicative and Financial data such as Contribution, loan repayment, salary and hours based on the record layouts.
• SCF files will be FTP to informatica server.
• RTP engine will process these files and convert them as JSON files.
• Outbound process will read these files and load to Mainframe DB2 tables.
• Defects are logged in HP QC.

Test Analyst - NTT Data/Fidelity Investments - Halifax, NS

(2017-06 - 2019-06)

Project: DC_MDM_PlanId_Batch_process

• DC and HSA participants data is loaded in two separate source systems, STM requirements document are analyzed to prepare the test cases for each transformation rules.
• Workflows for DC and HSA sources are executed to load the data to DWH.
• Validated the counts and data from each source systems.
• Validated the reject records from batch process.
• Defects are logged in Jira

Test Analyst - NTT Data/Fidelity Investments - India

(2016-10 - 2017-05)

Project: Reimbursement Accounts feed

• All clients send the HRA, HSFSA, DCFSA transaction details to fidelity through text files. These files will be send through Axway to Mainframe and processed through mainframe batches.
• Loading the RA feeds data to mainframe and storing them as 80-byte files.
• Running the Mainframe batch jobs to process these files and convert them to 100-byte files by adding client id for each row.
• Validated the FTP process to move these files to Informatica server.
• Executed the Outbound workflows to load the data to ODS tables and validated the wage works files which got generated as per the business rules

Test Analyst - NTT Data/Fidelity Investments - India

(2013-08 - 2016-09)

Project: MDM Apollo

• Validated the new 5 Rest API's to load the data to Oracle database.
• Functional testing for these 5 API's is done through Parasoft SOA and Postman.
• Automated the Functional testcases using Rest Assured BDD framework.
• Created the Jenkins jobs for each API and implemented the CICD pipeline and scheduled the jobs to run daily.
• Enhanced the Regression suite based on new enhancements for these 5 API's.
• Involved in Performance testing of API's using MOX scripts

Test Analyst - NTT Data/Fidelity Investments - India

(2011-08 - 2013-07)

Project: Beneficiary Registry UI

• Validated the new UI application through functional test cases.
• Automated the functional test cases Selenium Page object model.
• Created the Jenkins job and implemented the CICD pipeline.
• Enhanced the automated regression suite based on new stories related to UI enhancements.
• Defects are logged in QC

Master of Computer Applications

Bachelor of Computer Science