Software tester ETL tester
Resume:
RUBHA SHREE.M Contact Ph.no: 770-***-****
Email: *********************@*****.***
OBJECTIVE:
Software testing professional with 4.2 years of experience in ETL and BI testing. Desirous to utilize my expertise in Software Testing in an esteemed software organization that welcomes innovative ideas and offers growth opportunities and positive environment for accomplishing projects.
SUMMARY:
4.2 years of IT experience with strong SQL scripting, ETL and BI testing skills.
Experience in Development and Design of ETL test cases, scenarios, and SQL scripts to ensure quality in Data warehouse / BI applications.
Good Working Experience with Banking Financial services and Insurance domain - Guidewire suite-PC, BC, CC, Data hub and Info center testing.
Exposure to DB tools: TOAD/DBEAVER/ Oracle SQL developer and BI tools: Tableau, AXIOMSL, Cognos and OBIEE.
Exposure to Informatica power center- Data validation option tool.
Holding Good knowledge in understanding BRD and FRD and in Test Execution, Test Results Reporting, Identifying Defects and creating artifacts and evidence of testing.
Experience working on Water fall and Agile Methodology – Scrum.
TECHNICAL SKILLS:
Programming Languages
PL/SQL, C, C++, Java, RPA(UIPATH)
Test Management Tools
HPQC, JIRA, Share point
Domain
BFS and Insurance
BI Reporting Tools
Cognos, Tableau, OBIEE, and AXIOMSL
DB Tools
TOAD/DBEAVER/ Oracle SQL developer, Informatica DVO
SDLC Model
Waterfall & Agile (Scrum)
WORK EXPERIENCE:
Company: Capgemini Technology Services, Bangalore, India
Position: Senior Software Engineer
Experience: September 2017 – May 20, 2021
Company: Cognizant Technology Solutions, Coimbatore, India
Current Position: Associate
Experience: May 24, 2021– Present
PROJECT EXPERIENCE:
Project -1: PAVE and Same Day Automated Clearing House
Client
leading global bank based out of US
Technology used
Toad Software
Testing Applications
BOB, MHP, FTM
Testing Approach
Datawarehouse Testing/ETL testing
Test Management Tools
HPALM
Role
ETL and functional Tester
Description:
The Aim is to enhance validation of entire AML system, End-to-End investigation for target transaction filtering, transaction monitoring and KYC related from the data gateway by confirming whether there is no data truncation when data onboarded on various UI is flown to downstream/database/ Mainframes.
Same day ACH project aim is to verify whether the transaction initiated from BOB and MHP applications are getting settled on the same day by checking the final settlement date in file generated on FTM application.
Roles and Responsibilities:
Involved in the Requirements Review and participated in Requirement discussion with Business Analyst.
Prepared Test cases and Test data sheet by understanding and analyzing the application KDI fields form E2E and IID documents.
Onboarded data to UI application and verified whether it is flown to downstream databases without any truncation.
Prepared comprehensive reports on quality test results and presents findings to software creation team to immediately establish corrective measures.
Project -2: CT CORE Replacement and OFSAA OLM R2
Client
leading global bank based out of US
Technology Used
Toad software, OBIEE reporting tool.
Testing Approach
ETL Testing
Test Management Tools
HPALM
Role
ETL Tester
Description:
CT CORE Replacement and OFSAA OLM R2 are two different ETL project which involves testing of data flow into tables on different stages as data source -> PRE-STG->STG and finally into OBIEE reporting tool ensuring that data is flown according to the requirement from source to target tables.
Roles and Responsibilities:
Preparing Test plan, Test cases according to ETL specification, BRD and FRD Documents.
Verified tables are created with all constraints and structure as per requirement.
Fetched data from tables by writing complex SQL queries in Oracle database.
Compared data between source and target against each column of table and checked whether transformation logics are applied according to the requirements.
Verified OBIEE generates final report with the data of underlying tables for BI reporting.
Prepared comprehensive reports on quality test results and presents findings to software creation team to immediately establish corrective measures.
Project -4: Axiom Day 2 R2 and Pillar 2
Client
leading global bank based out of US
Technology Used
OBIEE, AXIOMSL Tool, AWS, HIVE, Tableau, Workiva
Testing Approach
ETL Testing
Test Management Tools
HPALM, JIRA
Role
ETL Tester
Description:
AXIOM tool generates reports which MUFG submits to Federal Reserve Bank, Project involves data integration testing of Risk reports where data flow from AWS->Tableau->Wdata->Workiva and Regulatory reports data flow from Hive-> Axiom and OBIEE ->Axiom.
Roles and Responsibilities:
Preparing Test plan, Test cases according to BRD and FRD Documents.
Written complex SQL queries to fetch data from AWS and Hive
Verifying whether data sources, data models, workflows and reports are configured according to the requirement.
Verifying the reports and adjustments made to the report in BI tools Axiom, Tableau and Workiva.
Prepared comprehensive reports on quality test results and presents findings to software creation team to immediately establish corrective measures.
Project -5: Agent 360
Client
leading Insurance company based out of US
Technology Used
Guide wire-PC, BC, CC, Info center, Datahub Cognos
Testing Approach
ETL and BI testing
Test Management Tools
Qtest, JIRA
Role
ETL and BI Tester
Description:
This project involves testing of Guidewire data model and integration among guidewire suite, and Cognos report testing as per business requirement.
Roles and Responsibilities:
Creating Test artifacts such as test plan, test case, test logs and defect logs in Jira.
Creating Test data in Policy center, Billing Center and Claim Center.
Writing SQL queries for data validation between the tables and Cognos.
Verifying whether the data in data hub and Info center tables are matching with Guidewire PC, BC, CC.
Verifying whether the Cognos report is developed as per the requirement provided by business and matching with the data in Info center.
EDUCATION:
Bachelor of Science in Electronics
PSG College of Arts & Science, Coimbatore, Tamil Nadu.
2014-2017
CERTIFICATIONS:
Completed “Professional Scrum Master-I” Certification from Scrum.org and was awarded Professional Certification.
Completed “ISTQB Certification” in Foundation Level.
Completed “RPA Developer Advanced certification” from UIPATH.
PERSONAL DETAILS:
Name
:
Rubha Shree.M
Father’s Name
:
Murugesan.N
Date of Birth
:
November 10, 1996
Nationality
:
Indian
Languages Known
:
English, Tamil.
Address
:
19, Pillayar Kovil st,
Sowripalayam,
Coimbatore-641028
DECLARATION:
I do hereby declare that the above information is true and complete to the Best of my knowledge and belief.
Thanks,
Rubha Shree. M
Contact this candidate