Test Analyst Technology

EXPERIENCE SUMMARY

I am an Australian citizen with Canadian open work permit looking for Quality Assurance/Test Analyst job opportunities.

I have more than 14 years of experience in IT industry which includes experience in functional testing, web testing, manual testing, automation testing.

Also, I do hold development experience in OOP programming language Java in Finance, Banking, Telecommunication, Security and Project Accounting Domain.

I hold good experience in banking and finance domain when I worked for Westpac

I have an excellent Transact SQL (T-SQL) and PL/SQL skills. I have worked on a complex data warehouse application using SSIS/SSRS and .NET.

I have strong experience in Automating Web Application Testing using Selenium WebDriver.

I hold solid experience in ETL and data warehousing principles while working with Westpac. Also, I have done data validation, data verification and data migration testing, transfer pricing reconciliation of data driven systems (product systems Vs General Ledger GL).

I have robust experience in Agile (Scrum and Kanban methodologies) and waterfall SDLC methods. I do have experience in change management too.

I have expertise in software testing life cycle activities – requirement analysis, test scenario creation, Test Traceability Matrix creation, Test case creation, and risk-based prioritization, test case execution, and defect reporting and tracking of defects.

I also have proficiency in testing with Microsoft-focused environments viz. Visual Studio, SQL, Team Foundation Server (TFS) - Agile/SCRUM delivery, Data Warehousing and/or SharePoint systems.

I am proficient in using JIRA, Confluence, Git, HP Quality Centre (QC), and Microsoft TFS for defect lifecycle management.

Intermediate level experience in mobile testing – Android/iOS applications.

Strong analytical skills, problem-solving & decision-making abilities, Strong oral & written communication skills.

Proven leadership, self-starter, communication & people skills, with relationship management & organizational abilities.

Experience of working in a multi-cultural environment with project teams spread across multiple countries.

CURRENT EMPLOYER

Australian Prudential Regulation Authority, Australia

Duration: Since June 2022 – till date

Role: Senior Test Analyst

PREVIOUS EMPLOYERs

Integrated Research (IR), Australia

Duration: Since March 2019 – June 2022

Role: Senior Test Analyst

NSW Health (Ministry of Health), Australia

Duration: Since Jun 2018 – March 2019

Role: Senior Test Analyst

Herbert Smith Freehills (HSF), Australia

Duration: Since Aug 2017 – Jun 2018

Role: Senior Test Analyst

Indue, Australia

Duration: Since March 2017 – Aug 2017

Role: Senior Test Analyst

Westpac, Sydney (from Infosys, Australia)

Duration: Since August 2012 – March 2017

Role: Test Analyst

Cybage Software Pvt. Ltd. India, MH, Pune

Duration: Since November 2010 – August 2012

Role: Software Engineer (Software Developer)

Tata Consultancy Services (TCS) India, MH, Pune

Duration: Since September 2008 – November 2010

Role: Assistant System Engineer (Software Developer)

IT / SOFTWARE SKILLS

Software Tools : Atlassian JIRA, HP Quality Centre(QC)/HP ALM, Microsoft TFS, control M and Tidal job scheduler

Software Skills : Java, JavaScript, Web Services (REST, SOAP), WSDL, XPath, XSD, XML, SQL, PL/SQL

Database Tools : SQL Server Management studio, PLSQL Developer, TOAD, PostGresSQL, Oracle 11g, SQL Developer

Testing Tools/Framework : SOAP UI, Postman, Selenium framework, Katalon

Version Control tools: Microsoft Visual Source Safe 6.0 (VSS), Team Foundation Server (TFS), CVS, and Subversion (SVN), Git

Interests : Salesforce, Big data, Hadoop, Cloud, AWS, MEAN stacks

PROJECT EXPERIENCE

Project : Australian Prudential Regulation Authority, Australia

Duration : June 2022 – till date

Role : Senior Test Analyst

Technologies : Java, JavaScript, Selenium framework, SQL

Tools :SQL Server Management Studio, JIRA along with X-ray and Zephyr plugin, Katalon, Tidal job scheduler, Confluence, Git

My responsibilities & contribution:

Experience in Data and ETL deliveries; very strong SQL scripting skills

Prepare and deliver test strategies, test plans, test designs (test cases and test data), test scripts, test execution results, defect reports and test status summaries. Also, prepare test matrices (with reference to business requirements) when required.

Liaise with project team members including data engineers, project stakeholders and reporting of test results throughout the stages of the development lifecycle

Work within an Agile scrum, actively contributing to agile ceremonies

support data projects and initiatives with data engineering services (system testing/integration testing)

collaborate with system owners to ensure that data is available and interface with representatives of functions and business units on requirements and delivery of solutions.

communicate with and report to the leadership on high priority defects/issues as required.

Project : Integrated Research (IR) – Prognosis Monitoring (IAM module)

Duration : March 2019 – June 2022

Role : Senior Test Analyst

Technologies : Java, JavaScript, Selenium framework, SQL

Tools : Microsoft Team Foundation Server (TFS), SQL Server Management Studio, JIRA along with X-ray and Zephyr plugin, Katalon, Confluence, Git

My responsibilities & contribution:

Perform application testing for a developed feature and verifying compliance with the quality assurance procedure

Analyse user stories and business requirements, write thorough test scripts which covers these requirements technically and functionally.

Refine requirements for testing environments and participate in the creation and configuration of test environments

In depth experience in manual testing and writing automation test scripts using selenium framework in Java and JavaScript

Write and update a series of manual and automated test cases for new and existing features of the system.

Broad experience of CI/CD through Jenkins

Provide mentoring to other test analysts as required, under the direction of the manager. Have taken responsibility of problems discovered during sprint and followed the process to get it fixed and deployed in each of the test environments. I also have taken responsibility for escalation of issues to appropriate managers when needed.

Intermediate level of experience in AWS cloud technology

Project : NSW Health – Enterprise Data-Warehouse Analysis, Reporting and Decisions – BI Implementation

Duration : Jun 2018 – March 2019

Role : Senior Test Analyst

Technologies : T-SQL, SSIS

Tools : Microsoft Team Foundation Server (TFS), SQL Server Management Studio, JIRA

My responsibilities & contribution:

Write and update a series of manual and automated test cases for new and existing features of the system

Perform manual and automated SIT, functional and regression testing

Detect, log and take ownership of issues and defects

Write automated test cases from the existing framework using Selenium

Maintain & Create test data for the automated test scripts

Participate in SCRUM ceremonies and collaborate with the team to deliver user stories.

Robust experience in Microsoft SQL Server Stack with an emphasis on SSIS.

Experience with ETL design

Strong relational SQL database experience

Extensive experience using T-SQL and stored procedures to perform analysis and manipulate data

Holds very good experience in designing, creating, executing and analyzing manual and automated tests for both sprint and regression testing.

Experience working in an Agile environment

Experience with Data Warehouse scheduling and orchestration tools

Experience with change and environment control in a complex data warehouse environment

Beginner level DBA experience on SQL Server

Experience in Data Warehousing Methodologies like Star Schema Design

Work closely with development teams, business analysts, technical leads and development and QA Manager to design, development and maintenance of Test Automation.

Demonstrated ability to solve technical problems and implement innovative solutions.

Project : HSF – BAU Enhancements & ETL/data warehouse reporting

Duration : Aug 2017 – Jun 2018

Role : Test Analyst

Technologies : T-SQL, SSIS, XML, Automation Testing with Selenium, Java

Tools : Microsoft Team Foundation Server (TFS), Microsoft Team Management Server (MTM), SQL Server Management Studio

Visual Studio), JIRA & Zephyr

My responsibilities & contribution:

Experience in developing test plans and preparing test data required for test examination and acceptance criteria for agile sprint testing.

Maintain and improve the levels of functional regression test coverage through automated testing using selenium web-driver with java across key systems and as part of agile sprints.

Experience in testing complex web applications with knowledge of browsers and user-interface testing techniques.

Work closely with development teams, technical leads and development and QA Manager to design, development and maintenance of Test Automation.

Good understanding of software practices like TDD, BDD and CI/CD.

Work within various multi-disciplined teams, using own experience to contribute towards requirements analysis, development and support processes. Identify and report on technical issues or risks and collaborate on their resolution.

Design and establishment of test environments including the creation, loading, and manipulation of test data.

Identify and automate manual test cases where necessary.

Have built entire project in Zephyr on JIRA for scrum methodology – creating custom fields, custom screens, issue types, workflow and its schemes etc.

Logging of test results, exceptions and verification using JIRA as well as raising new issues with detailed information.

Development and execution of test cases based on Agile Testing Principles.

Well experienced executing regression and integration tests.

Preparation of reports indicating the progress of testing.

Ability to write clear bug reports quickly and concisely

Extensive experience in Agile methodology viz. Kanban and scrum model.

Project : Indue - New Payments Platform NPP & Card Management Systems

Duration : Mar-17 – Aug-17

Role : Test Analyst

Technologies : T-SQL, SSIS, XML, Automation Testing Framework, .NET

Tools : Microsoft (Team Foundation Server, SQL Server Management Studio,

Visual Studio), SOAP-UI, SVN, Microsoft IDE

My responsibilities & contribution:

Design and create effective end-to-end test cases using the prescribed template and

Defined acceptance criterion to ensure system responds as expected.

Work closely with business analysts and stakeholders to derive test coverage, understand the business context of payment processing from an end-to-end perspective and articulate risks.

Create and document Test Strategies, Test Plans, Test Cases, Test Scripts, Test Scenarios and

Test Summary/Execution Reports for both Manual and Automated Testing.

Experience in testing web applications, Restful APIs and mobile Android/iOS applications for cards and payment area of banking services with knowledge of browsers and user-interface testing techniques.

Testing experience of Microsoft Dynamics products (D365 Operations)

Experience with API testing using POSTMAN

Extensive experience in Agile.

Project : Westpac Institutional Bank

Duration : Aug-2014 – March-2017

Role : Test Analyst

Technologies : T-SQL, SSIS, XML, Automation Testing Framework

Tools : Microsoft (Team Foundation Server, SQL Server Management Studio,

Visual Studio), BMC – Control M

My responsibilities & contribution:

Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification, data migration and identifying data mismatch.

Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion, loading and pricing reconciliation.

Capable in Back End Testing in Microsoft SQL environment by writing and executing SQL Queries. Expert in testing data transformations and data enrichment rules, flow of data from one data layer to other.

Tested the entire data reconciliation process for multiple sources and target systems like, Murex, Calypso, Vision Plus etc. Good exposure of treasury applications including FX, interest rate, cash flow risk, Murex etc.

Work extensively with slowly changing Dimensions & Audit Tables.

Maintain batch job scheduling for over 500 jobs in the production environment using BMC Control-M software.

Involved in manual as well as automation testing. Built an automation framework for regression testing in order to generate Test Summary Report for the project. Also, assist with the continuous improvement of the testing processes and framework.

Create and document Test Strategies, Test Plans, Test Cases, Test Scripts, Test Scenarios and Test Summary/Execution Reports for both Manual and Automated Testing.

Ability to understand and interpret user stories/requirements present in the product backlog, functional and design specifications to build test cases and test coverage plan.

Knowledge and experience testing in Agile (Scrum methodologies) and Waterfall methodologies

Very good experience in MS Visual Studios for test case creation, doing white box testing to read SSIS packages, validate stored procedures, triggers etc.

Good knowledge of SQL Server management studio and administration.

6+ years with SQL/PL-SQL and expertise in writing complex SQL Queries.

Strong programming skills with Java and experience in Test Automation Frameworks.

Assist with the creation of business readiness and technical release notes.

Well versed with Manual and Automated Testing methodologies and principles.

Analyze and identify test requirements and write test scripts in T-SQL to test them. Execute SIT/functional and regression testing to recognize any software defects with the help of automation and manual testing methods.

Good experience in working with onsite-offshore team model projects.

Record, track and retest defects using MS Visual Studios, JIRA, and HP-QC

Have undergone training on Selenium conducted by Westpac.

Project : Telenet (Belgium) Application Development / Maintenance (CR)

Duration : Aug-2013 – Aug-2014

Role : Technology Analyst

Technologies : Java, JSP, JavaScript, BPEL, Oracle SOA Suite (OSB, Web services), SOAP, WSDL, XML, XSLT, PL/SQL, Oracle Database

Tools : JDeveloper 11i, OEPE 11gR1, PLSQL developer, SOAP UI, JIRA, HP ALM, CVS, VSS, Clarify, Lotus Notes

My responsibilities & contribution:

Developed CRs belonging to OSS/BSS layer including O2B (Order to Bill), B2C (Bill to Cash),NM (Network Management) and CS (Customer Service) domain end-to-end i.e. from requirement gathering, giving estimations, performing impact analysis, build and System and integration testing and giving early life support (ELS) with minimum impact on the other system, which ensure stable production environment.

Developed Solutions by using Java, J2EE, Spring Framework and SOA (OSB, BPEL) for the development of the proposed functionality.

Simple data migration steps like importing and exporting data to/from plain text file to/from the database using SQL Loader.

Responsible for development of new programs analyzes current programs and processes and making recommendations which provides value addition to the customer.

Complete ownership of the task right from Development, Review, and Testing of the deliverable.

Prepared design, impact analysis documents and functional specification for the application development.

Testing web application for Telenet customers and performing UI testing as well as Functional testing of different orders that a customer can place. For instance, placing order for buying a new package of Analog/Digital TV, mobile etc. Testing entire cycle for these orders in different domains viz. Order to Bill (O2B), Network Management (NM), Bill to cash (B2C) etc.

Created Test Plans, Test Cases (sometimes test procedures/stubs), Test Scripts for E2E testing of entire telenet application which is used by Belgium based customers to order telecom/network products. (Handling end to end flows right from ordering product to its delivery and billing).

Raising defects, co-operation with developers and BAs (if required) resolving and retesting them, track test cases status, generate defect reports and test status reports.

Tested various workflows and provide the support to IT (Integration Testing) and UAT testing.

Perform validation activities like functional, integration, performance & security based on the plans to ensure quality deliverable.

Creation of Manual Test cases and automation scripts.

Experience working in Agile programs meeting sprint deliverables.

Involved in the review of the code of team member and coordination with testing team.

Complete ownership of the task right from Development, Review, and Testing of the deliverable.

Involved in Software Development Life Cycle (SDLC) – Agile (Scrum) Methodologies.

Prepare a weekly status report, issue tracker, Daily progress tracker.

Worked on the rapid fixing of defects raised during testing.

Actively involved in cut over activities and go-live.

Providing Post Go-Live implementation support.

Analyzing and solving the end-user problems.

Training and mentoring new team member and giving knowledge transition to them about Project.

Brief Profile:

Telenet Group is the largest provider in the field of telecommunication for cable broadband services in Belgium. Its business comprises the provision of analog and digital cable television, fixed and mobile telephone services, primarily to residential customers in Flanders and Brussels. In addition, Telenet offers services to business customers all across Belgium and in Luxembourg under its brand Telenet Solutions.

Telenet has a back-end application named as Café which is designed and developed to take care of end to end business flow in Telecom domain for Telenet back office users. MyTelenet is the application which is actually used by Telenet customers.

This application enables quick implementation to meet the business goals and overcome the challenges of today’s complex technology environments

Project : British Telecom, Application Development / Maintenance (FlowDesktop)

Duration : Sep 2012 – Aug-2013

Role : Technology Analyst

Tools/Technologies : Java, JSP, JavaScript, SQL, Oracle Database, HP QC, XML, Eclipse, SVN (Toad subversion)

My responsibilities & contribution:

Handling a team of 6 employees for all support activities

Resolving Urgent (2Hrs), High (8Hrs), Medium (48Hrs) and Low (96Hrs) Issues within SLA time frame.

Bug fix, code fix, data fix, code change, test and migration for Emergency Change Request (ECR) and CR.

Root Cause analysis of Urgent, High and Repetitive issues and also providing temporary and permanent fixes.

Training and mentoring new team member and giving knowledge transition to them about Project.

Brief Profile:

“FlowDesktop” project is to provide services mainly for British Telecom Customers for PSTN and Broadband lines

It is designed and developed to take care of end to end business flow in Telecom domain for BT users.

This application enables quick implementation to meet the business goals and overcome the challenges of today’s complex technology environments

Project : Provenir (US) Commercial Lending Application Development

Duration : Aug 2011 – Aug 2012

Role : Software Engineer

Tools/Technologies : Java,J2EE,JSP,SQL,Oracle Database

My responsibilities & contribution:

Understanding business requirement from Customer, designing and developing solution for it and translating business requirement and its solution details into technical details.

Solution Designing, Code Development, Enhancement, Bug Fixing, Migration and Testing.

Brief Profile:

“Commercial Lending Application” project is to provide solutions mainly for Lending and Collections with Multilingual support for clients across the globe.

The application is based on a modular architecture conforms to the principles of SOA and an Enterprise Service Bus (ESB).It is designed and developed to take care of end to end business flow in BFSI domain for Commercial Lending and Collections

Project : Progress Software Corporation - Sonic ESB Courseware Development

Duration : Nov 2010 – July 2011

Role : Software Engineer

Tools/Technologies : Java, JSP, SQL, Oracle Database

My responsibilities & contribution:

Lead a team of 4 technical resources and working as a Subject Matter Expert.

Visited the client location Hyderabad for understanding the Business Requirement.

Understanding business requirement from Customer, designing and developing a solution for it and translating business requirement and its solution details into technical details.

Solution Designing, Code Development, Enhancement, Bug Fixing, Migration, and Testing.

Brief Profile:

“Progress Courseware Development” project is for Progress Software’s product Sonic ESB which is a messaging-based enterprise service bus that simplifies the integration and flexible reuse of business applications within an SOA.

Designing and developing a business case for the client to incorporate the different Sonic ESB concepts with the Sonic Workbench.

Project : ODC Access Control

Duration : Apr 2010 - Nov 2010

Role : Software Developer

Tools/Technologies : The project is developed using Java and Java Server Faces in TCS Ultimatix Framework with Oracle 10g database.

My responsibilities & contribution:

Solution Designing, Code Development, Enhancement, Bug Fixing, Migration, and Testing.

Developed and Enhanced audit Reports in an Excel format using Java, JSF.

Brief Profile:

“ODC Access Control” is a centralized software-based system to grant or revoke the access to TCS associates for TCS Offshore Development Centers (i.e. ODC).

The tool aims at controlling the physical access and facilitating the logical access inside a particular ODC.

Project : SWON Creation and Management in Project Accounting

Duration : Apr 2009 – Mar 2010

Role : Software Developer

Tools/Technologies : Java, OAF, PL/SQL

My responsibilities & contribution:

System Administration activities like creation of Responsibilities, Menus, etc.

Responsible for integrating the entire code of the application and deployed on UAT environment.

Was the Single Point of Contact during Performance Testing and interacted directly with the client for the same.

Value Additions and Enhancements and Customization of previously developed and implemented processes.

Active participation and contribution in personalization and customizations in Oracle Apps.

Technical and Functional Knowledge of PA module.

Updating Functional and Technical design Documents.

Maintained code in VSS.

Training and mentoring new team member and giving knowledge transition to them about Project.

Brief Profile:

"SWON creation and management" is a web-based application created using OAF in PA module for effectively creating and maintaining the project and its related activities with friendly user interface.

SWON (Standing Work Order Number) is a Project identification number used in TCS.

Project : Morgan Stanley - Securities Lending – Migration from Solaris to Linux

Duration : Oct 2008 – Mar 2009

Role : Software Developer

Tools/Technologies : C, C++, UNIX, PL/SQL

My responsibilities & contribution:

Understanding business requirement from Customer, designing and developing a solution for it and translating business requirement and its solution details into technical details.

Support to Customer during installations, configurations, Audits.

Maintained the code in the web-based version management system

Brief Profile:

Securities lending involves a loan of a security from one party (Lender) to another (Borrower). Morgan Stanley as a broker provides all their services to both parties.

The aim of this project is to do reverse engineering of all the Sec-Lending applications, generate test cases, migrate them from Solaris to Linux and do the testing with latest Morgan Stanley releases.

EDUCATION

Bachelor of Engineering in Electronics and Telecommunication from Cummins College of Engineering, Pune University Maharashtra, India (Passed in 2008 with 69%).

HSSC from Somalwar High-school Nagpur (Passed in 2004 with 92.33%).

SSC from Somalwar High-school Nagpur (Passed in 2002 with 89.33%).

ACADEMIC PROJECTS

Project Segmentation Automation:

Created an automated system for TCS to show the entire structure of an organization during the final year of Engineering in VB.

Microcontroller based Elevator Controller System:

Made a model of an Elevator controller System using Assembly Languages.

Color Image Classification:

Classified the images using neural networks, Gabor filters, and segmentation algorithm in Matlab.

PERSONAL PROFILE

Name : Rajeshri Zade

Years of Experience : 14 Years

Passport Number : J3402537

Hobbies : Playing Badminton, Listening to music, Swimming, Singing, and Cooking.

Present Address : 18 Speckled Alder St. Caledon, ON

Email : *****************@*****.***

Contact # : +1-289-***-****

Contact this candidate