Sandhya Rajanna
Location: Toronto ON
****************@*****.***
A dedicated software professional with a over 10+ years of experience in SQL, Test Automation, SAP and more in Retail Banking and Telecom Domains. An enthusiastic and a quick learner with excellent articulation skills, currently looking for a challenging environment to contribute and learn together.
PROFESSIONAL SUMMARY
Technical
Experience in Application Analysis & Design, Development, Implementation, Unit Testing, Smoke testing, System Testing, End to End, UAT and Certified Professional Scrum Master.
Test Automation Developer/Engineer with expertise in Manual and Automated testing with tools such as Robot Framework, Selenium WebDriver, TestNG, Maven, Jenkins and JIRA using programming language Python.
Expertise in testing and automating web services using SOAP UI, Postman and Rest Assured. Well versed in SOAP Web Services and REST APIs.
Responsibly managed and delivered high quality products in strictly agile environments. Also worked in different Software Development Life Cycle (SDLC) setups like Waterfall and Agile (SPRINT/SCRUM). Developed effective test strategies and objectives, test procedures and metrices.
Strong automation development experience using tools such as Selenium WebDriver, Jenkins (continuous integration), Cucumber/Behave, TestNG, PyUnit, Robot Framework using Python.
Highly experienced in creating and enhancing different testing frameworks like Hybrid, Keyword Driven, Data Driven, Behavior Driven & Page Object Model (POM) and executing and analyzing build pipelines with automated testing frameworks.
Expertise in end-to-end Software Testing Life Cycle (STLC): Planning Process, Test Design, Test execution, Test coverage enhancement, Test Reporting, Defect Tracking and Test Management.
Expertise is Creating Source to Target Mapping documents
Excellent SQL Writing, Data Analytical, Debugging and Problem-Solving Skills
Knowledge of ETL, Spark-Hadoop concepts driven Tool and Machine Learning with Python Programming Language
Diversified experience in Manual and Automated Testing of Web, Client Server and applications in the various environments.
Experienced in Building and Executing Automation scripts for Keyword driven Automation tool like Robot Framework.
Expertise in writing Test Scenarios, Test Design and Test Execution
Managerial
Expertise in Planning, Effort Estimation, Resource Forecast and Task Allocation
Experience in Writing Master Test Plans, Test Strategy Documents
Experience in Status Reporting,
Excellent Process Implementation, Configuration Management, Root Cause Analysis
Experience in working in an Onshore-Offshore work model in multiple projects
Experience in Recruitment, Onboarding, Training & Mentoring, Team building
Experience in Configuration Management, Root Cause Analysis and creating KT Documents
Experience in creating Daily, Weekly status reports to present to the Clients and Stakeholders
Experience in People management, Escalations and Issue management
Experience in Scope Discussions, Setting Priorities, Prepare Signoff Documents for each release and attend any Go/No Go meetings
Participate in Requirements Gathering Sessions, Design and Walkthrough Reports with Clients
Co-ordination with Clients and Dev Team for Impact Analysis and Resolution
Personal
Effective communication and Interpersonal skills
Enthusiastic Team Player & Leader
Quick Learner with extensive Organizational skills
TECHNICAL SKILLS:
Defect Tracking Tools: HP ALM 11.0, Ticketing System- JIRA, HP QC 9.0, Rally, HP Sprinter.
Database: Oracle 8/9i, MS-SQL Server 7/2000, Java
Data Migration: BAPI & LSMW.
Testing Tools: Runtime analysis, ABAP Debugger, SQL Trace, Dump analysis.
Programming Language: Python, Java
Scripting Language: Python Script, Java Script
ERP: SAP BW,CRM,MM,SD,PI
Automation Tools: ROBOT Framework with Python Script and selenium framework, HP QTP, SOAPUI, Ready API, BitBucket, Devops Tools Like Ansible.
PROFESSIONAL EXPERIENCE
ASSIGNMENT 1: July`16 – Present
Project Title : ONLINE BANKING WEBSITE
Client : BANK OF MONTREAL
Implementation Partner : Tata Consulting Services, Canada
Location : Toronto, CA
Role : Quality Analyst Lead Consultant
Responsibilities:
Understand the complex requirements of the application with minimal support and no detail documentation
Worked with BA and Development on a daily basis for Requirements clarification, Test Case walkthrough and bug life cycle
Responsible for Code deployment in right SIT environment using Devops Tool- Ansible which in turn trigger automated regression test suite.
Lead and direct QA team towards the “Zero defect” Goal in live environments
Offshore and On-shore delegations to improve the productivity for maximum utilizations of infrastructure.
In charge to prioritize, divide and connect logical bundles to accomplish each release with QA retrospective; make necessary Go/No-Go decisions and approvals for quality Sign-off
Automation
oBuilt and execution of Test scripts using Robot framework using Python language and selenium framework.
oTesting Web services using Ready API Tool and also worked on automation of same using Selenium.
oWorked closely with Business Analyst team and Development team to analyze requirements and develop Test Cases / Scripts
oCreated detailed Test Scripts for new Enhancements in the application
Manual
oWorked as a single manual Testing resource for a critical release and handled all phases of QA
oWorked on Test Plan creation, Test Design, Test Case Development and Test Execution for couple of releases
oDeveloped detailed Test Steps for every Test Case created such that any tester can do the execution with minimal knowledge.
oParticipated in Test Case Walkthroughs and Reviewed others Test Cases.
ASSIGNMENT 2: Sep `14 – July`16
Project Title : R(etail) C(redit) T(ransformation)
Client : RBC
Implementation Partner : Capgemini Canada
Location : Toronto, CA
Role : Technical Quality Lead Consultant
Project Description:
RBC is one of the largest North American bank. The bank is one of the first financial services institutions (FSIs) that committed itself to a CRM strategy that would give equal emphasis to service and sales. The project scope as a maintenance partner is primarily is around maintenance of SAP CRM system via HPQC ticketing.
Responsibilities:
Involved in all aspects of testing such as functional, integration testing and regression testing with all the modules in SAP.
Managed QA teams(Offshore) on projects and reporting to QA manager and project teams on project status.
Participated in sizing exercises, kick off meetings, status meetings, scrum and stand up meetings
Analyzed User requirements, specifications & models for testability and identified test scenarios, test cases
Created test cases based on business requirements, technical specifications, and executed them
Prepared test plan and test scenarios from business requirement specifications to cover overall quality assurance testing process
Logged all the defects identified during testing phase and reported to the development team with proper priorities and severities in HP Quality Center.
Extract and Execute test cases in HP sprinter.
Used data driven testing technique to test the functionality with multiple sets of data.
Performed User Acceptance Testing (UAT), Validation Testing, Smoke Testing, Unit testing, Functionality Testing and Integration Testing.
Provided the status to the management through daily execution status reports
Maintained and executed test scenarios, test cases and test scripts.
Automation
oTesting Web services using SOAP UI Tool.
oBuilt and execution of Test scripts using Robot framework using Python language and selenium framework.
ASSIGNMENT 3: Jan `11- May `14
Project Title : TeliaSonera
Client : TeliaSonera
Implementation Partner : Accenture, India
Location : Bangalore, India
Role : SAP Development Consultant
Project Description:
TeliaSonera is a Telecom company dominant in Sweden and Finland. It also operates in Northern and Eastern Europe, Central Asia and Spain. After TeliaSonera acquired Netcom in Norway, there was a requirement to roll out SAP for TeliaSonera operations in Norway.
Roles & Responsibilities:
Extensively involved in testing of SAP HR Personal Management, Time Management, Payroll, Training and Event management modules.
Tested the menus for PA30 and PA40 Transactions as per customer requirements. Maintained Organizational Structure (Transaction PPOME) and info types 1000, 1001, 1005, 1008, 1013 etc.
Test analysis of Hiring Action that includes all Payroll relevant info types.
Tested and created various subtypes for the standard info types. Created custom info types and time constraint.
Tested wage type models and feature LGMST to default basic pay wage types in info type 0008, Setup feature TARIF to default pay scale type/pay scale area/planned compensation indicator in info type 0008, and setup feature ABKRS to default payroll accounting area in organizational assignment info type 0001.
Tested wage types permissibility for info types and wage type permissibility for PS and ESG groupings.
Tested Wage Types for Basic Pay (info type 0008), Recurring Payments / Deductions (info type 0014), Additional payments (info type 0015). Define wage types for indirect valuation using indirect valuation modules ANSAL and TARIF.
Tested the configuration of public holidays, holiday calendars, break schedules, work schedules and work schedule rules.
Expertise in creating System Landscape (Technical System and Business systems), Enterprise Service Repository (Message mappings, Interface Mapping), Integration Directory (Routing Channels, Receiver/Interface determination).
Extraction, Replication, and Reconciliation of data for the phases FUT (Functional Unit Testing). QA, Pre-Production Phase and Production Phase.
Test analysis of PA, OM modules.
Preparation of test scripts for PA, OM, PY etc
ASSIGNMENT 4: August`07-April`08
Client : ANZ Bank
Implementation Partner : Hewlett Packard
Location : Bangalore, India
Role : Process Analyst
Australia and New Zealand Banking Group Limited (ANZ) is one of the leading bank in Australia and New Zealand.
Responsibilities:
Handling Database for Australian and New Zealand Partners using Tools like Seibal, Business Objects.
Test Execution: Smoke Testing, Execution of functional Test Cases, Execution of Regression Test Cases, Ad-hoc testing, Defect Verification from earlier Release/Cycles, Defect verification from UAT defect list of previous cycle, creating new Defects and Tracking, creation of test cases from Ad-hoc defects.
Close communication with clients for clarifications, status reporting
EDUCATION:
MCA [Master of Computer Applications]
Bachelor of Science (Bsc- Computer Science)
ACHIEVEMENTS AND TRAININGS:
“Employee of the Month” award for 3 consecutive time in Accenture.
SAP ABAP and SAP PI in house training in Accenture.
References
Available upon request