Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

RITA RIJAL

Summary

5+ years of IT experience in Quality Assurance for ETL, Backend, Web-based, Client/Server applications using Manual and Automated testing tools. Strong understanding and experience in Software Testing Life Cycle. Expertise in building Test Strategies, Test Plans, Test Cases, Manual and Automated Scripts, and creating and maintaining Traceability Matrices. Extensive testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor, and Server Manager), AutoSys, Control M, and Maestro. Experienced working for Data Migration, Data Extraction, Data Cleansing, Data Profiling, Data Consolidation, Data Standardization and Data Quality for various business data feeds. Proficient in using testing tools such as Quality Center, Win Runner, Load Runner and Quick Test Professional for web-based and client-server applications. Preparing Dashboards using advance table calculations, parameters, calculated fields, groups, sets, forecasting, and hierarchies in Tableau. Involved in design and implementation of Selenium WebDriver automation framework for smoke and regression test suites Performed MS SQL Server T-SQL Queries, creating Tables, and Views by following Teradata Best Practices. Involved in testing the Micro strategy reports by writing complex SQL queries Supported User acceptance testing (UAT) in preparing the test scripts and test execution. Created status reports. Strong experience with ETL systems and having expertise with tools Informatica and Data stage. Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications. Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading. Experience in Dimensional Data Modeling using Star and Snowflake Schema Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation, and Data Loading (ETL) Experience in maintaining Full and Incremental loads through ETL tools in different environments. Experienced in Defect Management using ALM, HP Quality Center, Jira . Good experience in writing SQL to data validation in migration as part of backend testing Good exposure with databases like Oracle 10g, DB2, SQL Server 2012 Dashboard Visualization through Tableau BI application. Experience in debugging the issues by analyzing the SQL queries, and anlyse the error in log. Good experience in working with UNIX scripts in executing and validating logs for the issues. Experience with testing reporting tools (Cognos/Business Objects).

Overview

10
10
years of professional experience

Work History

Test Analyst/Onsite Co-Ordinator

Blue shield of California
Oakland, California
03.2022 - Current
  • Understand the requirement and Participated in Sprint planning, User story refinement, Daily huddles, Sprint Review, and Retrospective meetings
  • Created Test strategy, Test plans and Test scenarios based on the user stories and enabler stories and reviewed them with the developers and Product owners and entire project Team
  • Involved in the Static testing , data set up, envirioment set up as per Release calender
  • Performed data analysis, and data profiling using SQL and Explorer on various sources systems including Oracle and Netezza,Facets, Denodo Mongo DB
  • Performed, Functional, Integration, Regression, End to End testing and participated in User Acceptance Testing
  • Wrote SQL Queries, test script as per the maping documents
  • Involved in Creating temp Tables
  • Execute in Query Netezza Database and Denodo Views
  • Experience in maintaining Full and Incremental loads through ETL tools in different environments Strong understanding of Batch files and XML request/ Response validation
  • Involved in the Test execution,and responsible for reporting the defects to the development team
  • Track the defect in defect management tool using Jira
  • Retested the code, after the defect is fixed
  • Work closely with Development team and guide the off shore team
  • Worked in an Agile and Kanbarn board
  • Developed automated test scripts using bitbucket repository and execute through Jenkins
  • Involved in both manual and automated testing
  • Verify manually MQMFT/Sterling process, which automate the file to specific location and Tidal jobs
  • Experienced in verifying the extract data, file layout, file name, archival location others different scenario as per the requirement
  • Experienced of testing different files format .txt, csv,xmL, Json file, pipe delimetd, .dat
  • Etc Worked with UNIX scripts in executing and validating logs for the issues
  • Ran the jaws command, manifest Run to load the data in the table
  • Run the worlflow,and Validated the informatica jobs, generates the extract
  • Used winscp and putty for placing the inbound files in required path as per the grid page
  • Worked on environment issues, Compatibility checks after post-migration
  • Analysis the log and error files
  • Dashboard Visualization through Tableau BI application
  • Created, Submitted weekly bug report updates to the Project Manager in the form of the QA Error Log
  • Strong understanding of Health care system and entire data flow process
  • Review the test result with Business , UAT team,and Project Team, got approval in time
  • Submit the Functional and Regression sign off with Data service Team and entire project team
  • Delivered the assignment before time, so received client appreciation.

Data/BI Tester

Volkswagen Group of America
Auburn Hills, MI
04.2020 - 02.2022
  • Created Test strategy, Test plans and Test scenarios based on the user stories and enabler stories and reviewed them with the developers and Product owners
  • Performed, Functional, Integration, Regression, End to End testing and participated in User Acceptance Testing
  • Exclusively involved in the execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to the development team
  • Actively participated in Sprint planning, User story refinement, Daily huddles, Sprint Review, and Retrospective meetings
  • Experience in testing and writing SQL, PL/SQL statements Worked in an Agile technology
  • Wrote Test cases in ALM and Defect report generation using ALM (Application Life cycle Management) Experienced in giving training to the functional testers to execute Test Cases using QTP/UFT as part of Regression Testing Worked with batch jobs, monitoring and scheduling of jobs as part of the interface testing validation of data flow between two systems as per predefined fields mapping sheet and mode of communication
  • Involved in backend testing for the front end of the application using SQL Queries in the Teradata database
  • Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata Conducted Data Driven Testing using parameterization in UFT to test the application with different sets of data
  • Developed automated test scripts using descriptive programming in UFT
  • Validated the Autosys Jil scripts for dependencies, owner, description, and other attributes
  • Created and Developed Reports and Graphs using ALM
  • SQL query writing to compare extract file / XML response data with Database Strong understanding of Auto industry calendar (End of Day, End of Quarter, End of Year, etc.) To have frequent meetings with all stakeholders for better clarity and understanding
  • Strong background in testing in an Agile/ SCRUM methodology

Data/BI Tester

Barclays
Wilmington, DE
03.2019 - 03.2020
  • Involved in Design Review, Test Case Review meetings with business analysts and developers
  • Developed required SQL scripts for reports and extract generated by executing the SQL queries
  • Wrote SQL Queries to extract data from the Tables
  • Experienced in giving training to the functional testers to execute Test Cases using QTP/UFT as part of Regression Testing
  • Involved in extensive DATA validation, data verification, and data conditioning using T-SQL queries and back-end testing Responsible for executing Selenium test scripts on different browsers and checking for compatibility
  • Configured Selenium WebDriver, TestNG, Maven tool and created Selenium automation scripts in java using TestNG before agile release
  • Involved in testing the batch programs by using the Autosys tool
  • Involved in the complete SDLC- (System Development Life Cycle) from Requirement gathering to actual delivery of the Extracts which include all the loan origination and servicing data Designed and implemented complex SQL queries for QA testing and report/ data validation
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
  • Worked in Agile technology with Scrum and waterfall models
  • Experienced in using Assure data standardizer tool to transform the data according to the pre-defined rules as part of the transformation process Provide support for technical integration and prod controls teams for execution of ETL mappings
  • Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Autosys
  • Created and managed UFT Test Scripts based on the Requirements and Scenarios
  • Written Test Plan document, Test Cases, Reported Defects using HP ALM
  • Used Toad for Data Analysts to compare Oracle and Teradata databases Used Putty to access files and directories in the UNIX environment
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database Defect tracking and Defect Report Generation are prepared using ALM and Quality Center Written several complex SQL queries for validating business object reports
  • Extensively tested business objects report for static/cosmetic errors like header, footer, logos fonts, etc
  • Which may appear in all pages of the reports
  • Responsible for defect management and driving to resolution and retesting the same
  • Performed negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values
  • Created SQL compare statements to validate actual results with the expected results
  • Tracked and executed the user Acceptance test cases (UAT) concerning the requirements to determine the feature coverage.

Data/BI Tester

Genentech
SSF, CA
01.2017 - 02.2019
  • Created Test Plans and developed test strategies
  • Created Manual Test Suites for various modules
  • Tested stored procedures & views
  • Tested the reports generated by Micro strategy and verified and validated the reports using SQL
  • Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
  • Written SQL queries to data validation in migration as part of backend testing
  • Involved in extensive DATA validation using SQL queries and back-end testing Extensively used SQL to verify and validate the data load
  • Worked with developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted Performed the tests in both the SIT, QA, and contingency/backup environments Writing the test scripts for manual testing
  • Test newly developed features to ensure proper functioning before releasing them to QA for multiple MDM processes Worked on environment issues, Compatibility checks after post-migration of applications to Unix to Linux Worked with UNIX scripts in executing and validating logs for the issues
  • Reported bugs and tracked defects using Quality Center 8.0 (Test Director) Responsible for Functional, Regression, and User Acceptance testing - coordinated UAT testing Performed SIT/Functional, UAT Testing in Web-based application
  • Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log
  • Involving in Functional testing, End to End Testing, and Regression Testing Understanding of Functional Requirement Specifications and System Requirement Specifications
  • Extensively tested several Micro strategy reports for data quality Responsible for ETL batch jobs execution using UNIX shell scripting to load data from core database to Staging and Datamart tables
  • Wrote Complex SQL queries to verify report data with the source and target system (data warehouse) data
  • Assisted business users to execute UAT test scenarios and test data as part of Validation Testing Experience in Data validation, Data merging, Data cleansing, and Data aggregation activities
  • Validating the data against staging tables and target warehouse Find report defects and subsequently validate the fix, repeating the process until done
  • Perform Sanity Testing, Data-Driven Testing & Ad-hoc Testing when required
  • Perform system testing to ensure the validity of the Report requirements and mitigation of risks before formal acceptance
  • Report testing: Extensive experience with Reporting Tools like Micro strategy Performed Interface and Integration (SIT) Testing Extensively used SQL queries for data validation and backend testing
  • Working with Database testing Involved in Data Migration Testing and preparing documents
  • Functionality, Interface, and Regression testing.

ETL QA Tester

Capital Group Companies
Irvine, CA
03.2014 - 12.2016
  • Analyzed business requirements, system requirements, data mapping requirement specifications, and was responsible for documenting functional requirements and supplementary requirements in Quality Center
  • Created test data for testing specific membership functionality
  • Promoted Unix/Informatica application releases from development to QA and UAT environments as required
  • Responsible for testing packages using SSIS (ETL) to verify Data Completeness, Data Transformation, Data Quality, Integration Testing, UAT & Regression Testing
  • Involved in user training sessions and assisting in UAT (User Acceptance Testing)
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables
  • Created the test environment for the Staging area, loading the Staging area with data from multiple sources
  • Assisted in System Test and UAT testing scenarios as required
  • Extraction of test data from tables and loading of data into SQL tables
  • Design and build efficient SQL queries, analyze query cost comparison, use indexes efficiently
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
  • Used Quality Center for Bug reporting, tracking & generation of Test Metrics
  • Tested the ETL process both before data validation and after the data validation process
  • Experience in creating UNIX scripts for file transfer and file manipulation
  • Validating the data passed to downstream systems
  • Worked with Data Extraction, Transformation, and Loading (ETL)
  • Involved in testing the XML files and checking whether data is parsed and loaded to staging tables.

Education

Master of Arts -

Tribhuwan University
04-2009

Skills

  • SQL
  • PL/SQL
  • UNIX Shell Scripting
  • HP Quality Center 100
  • Rational Clear Quest
  • Bugzilla
  • Selenium
  • QTP/UTP
  • MS–Windows 9x/NT/2000/XP
  • Red Hat Linux
  • UNIX (Sun Solaris 58)
  • SQL Server 2008
  • Oracle 11i/10g/9i
  • Teradata V2R6
  • DB2
  • Sybase 125
  • Netezza
  • Denodo
  • Mongo DB
  • Toad
  • Citrix server
  • Oracle SQL Developer
  • SQL Advantage
  • Putty
  • Tableau
  • Micro Strategy
  • Cognos 80 Series
  • Crystal Reports
  • Hyperion
  • OBIEE
  • Informatica 5x/6x/7x/8x (PowerMart & PowerCenter)
  • SSIS
  • DataStage

References

REFERENCES AVAILABLE UPON REQUEST

Timeline

Test Analyst/Onsite Co-Ordinator

Blue shield of California
03.2022 - Current

Data/BI Tester

Volkswagen Group of America
04.2020 - 02.2022

Data/BI Tester

Barclays
03.2019 - 03.2020

Data/BI Tester

Genentech
01.2017 - 02.2019

ETL QA Tester

Capital Group Companies
03.2014 - 12.2016

Master of Arts -

Tribhuwan University

Similar Profiles

CREATE PROFILE
RITA RIJAL