SDET

Madhu Rebbana Mobile #: 425-***-**** **********@*****.***

Experience Summary

9+ years as a Software development Engineer in test with good experience in Automation Testing, Web Services testing, SOAP and RESTFul calls testing using Selenium (Web Driver, Grid), SoapUI and VSTS.

Over 9 years of experience in IT, with specializing in Software Quality Assurance Testing, proficient in testing on Client/Server and Web-based applications.

Extensive working experience on all phases of Software Development Life Cycle (SDLC), its methodologies and process.

Experienced in SQA (Software Quality Assurance) including Manual and Automated testing with tools such as Selenium RC/WebDriver/IDE/Grid, TestNG, VSTS, Quality Center and SOAPUI.

Sound knowledge on TestNG framework for Unit testing, Appium for mobile automation testing, Cucumber for behavior-driven development, Page object design patterns, Maven and Ant for Project building tool and Jenkins/Hudson for Continuous Integration.

Work experience in integrating Automation scripts (Selenium WebDriver API) on Continuous Integration tools Hudson/Jenkins for nightly batch run of the Script.

Developed Page Object model test automation framework along with Reusable modules, data driven testing, TestNG annotations, Jenkins integration and HTML test reports.

Can develop Groovy script using SoapUI tool.

Experienced in using Maven build tools to manage framework dependency jar files.

Good experience in Selenium Test Environment setup using the entire open source tools.

Excellent knowledge in writing unique XPath using firebug and fire path to identify web elements.

Cross browser testing using Firefox, Google Chrome, IE & Safari.

Experienced in making Data Driven and Keyword Driven framework to maintain test suite.

Experience with comprehensive understanding of all phases of Test Life Cycle, including requirements gathering, test planning, and scheduling, testing, defect tracking, and reporting.

Expertise in Automation Testing, Manual Testing, Smoke Testing, GUI Software Testing, and Backend Testing, Black-box Testing, Functional Testing, System Testing, and Regression Testing.

Good experience in Web Services testing using SOAPUI, XML, & WSDL. Providing required input data to request XML & get the required data from response XML & use the response data from other request XML using SOAPUI.

Strong experience with SOA architecture which include Soap Web Service and Restful Web Service Testing

Extensive experience in all MS Office, MS Windows Operating Systems, designing and implementing web-enabled and enterprise Client/Server applications with various software tools in various architectures.

Expertise in back end testing, BI testing (ETL testing & Report Testing) and writing SQL queries, Joins, procedures using SQL.

Strong knowledge of Software Development Life Cycle (SDLC) methodologies such as Agile, SCRUM and waterfall models and TDD.

Strong working knowledge of T-SQL including complex joins, data modeling, data mapping, and stored procedures.

Excellent working experience on data ware house projects includes but not limited to : Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process

Experienced in writing and executing SQL queries to verifying Source-to-Target Mapping.

Excellent working knowledge on DB mirroring, Replication, Recovery models, clustering, DB restore using back up & transactional logs and troubleshooting techniques.

Ability to develop complicated SQL scripts for Data validation testing by running SQL script, procedures.

Understanding of web applications: HTML, React.js, CSS, JavaScript and web servers.

Worked on Dynamics CRM features: Account Management, Opportunity, Workflows, Sales, Order Management and administration.

Working experience on testing Microsoft Dynamics CRM, Microsoft Dynamics Axapta, PeopleSoft CRM and Intec Singleview billing System products.

Guiding the test offshore and onsite team to achieve team goals with respect to project deliverables. Effort estimation and resource planning

Concurrent user hit testing, step-up load testing, database tuning, Search query execution time testing and SQL Profiling.

Achieved real time user load by generating different levels of orders load through SQL batch jobs and also observed the application behavior.

Worked on Performance testing and KPI factors like latency, throughput, maximum concurrent Virtual Users.

Experience in working with multiple teams across Project groups as part of software development life cycle. Effective communication with different teams to accomplish the project goals and implement required actions.

Experience in handling as an Onsite/Offshore coordinator.

Good analytical and communication skills and ability to work independently with minimal supervision and also perform as part of a team.

Highly motivated team player with analytical, organizational and technical skills, unique ability to adapt quickly to challenges and changing environment.

Excellent interpersonal skills, proven team player with an analytical bent to problem solving and delivering under high stress environment.

Ability to deal with complex situations and Manage time effectively, from day to day time to project schedules

Strong written and verbal communication skills.

Work Authorization: H1B Full time/Corp-Corp/W-2

Domain Expertise

Domain Area

Product worked on

Supply Chain Management, Finance

Microsoft Dynamics AX 2009

Customer Relationship management

Microsoft Dynamics CRM

Telecom

PeopleSoft CRM, Intec SingleView billing system

Technical Expertise

Software Testing skills

Functional, Integration testing, System testing, Automation testing, ETL testing, Web Services testing (RESTful services), Localization Testing, Database Migration testing, MS CRM testing, PeopleSoft CRM testing, MS Axapta functional testing

Programming Languages

Java, C#

Database

Microsoft BI, OBIEE, SQL Server 2005, 2008, 2012

Tools used for testing

Selenium, SoapUI, VSTS, QTP

Configuration Management

Source Depot, share point

Certifications

QTP, QC from HP. Agile & Lean certified.

Scripting Languages

Groovy, JavaScript

Overall Responsibilities:

Project Proposal:

• Gather requirements from the Business Analyst to understand the project, skill sets required.

• Analyze time required on the assignment and the # of resources to be deployed based on an initial estimation.

• Gather review inputs on resourcing and estimation from test manager.

• Create case studies to highlight experience / credentials which feed into the proposals.

Knowledge Transition and Technical Guidance:

• Understand the high-level requirements through review of documents (eg Component Design Document/ Requirements document).

• Document the understanding as part of the reverse KT.

• Seek signoff from the client.

• Partner with the Business Analyst to provide suggestions on the requirements to drive clarity based on experience in earlier projects.

• Update/Review KT documents created by Test Analyst.

• Seek review of updated documents from relevant stakeholders.

• Understand the critical business flow in terms of resource load, volume of data etc.

• Conduct feasibility study to identify tools /methodologies /frameworks to meet the client's requirements.

• Design estimates based on the analysis of the requirements and inputs from the test analyst.

Test Requirements Study:

• Understand and analyze the requirements (through review of requirement document) to identify the testable requirements.

• Prioritize the requirements based on the time required.

• Review/create the requirement traceability matrix.

• Create requirement query tracker (or clarification document) to track any clarification.

• Identify gaps in the requirements and take actions to close the same.

• Prepare high-level flow documents.

• Organize and drive the requirement walkthrough session.

• Prepare/Review the flow diagrams.

• Reach out to Technology team if required.

• Seek clarification on the requirements from the customer.

• Perform Proof of concepts or evaluate different tools if required.

Test Strategy & Test Planning:

• Create test strategy (that includes release date, types of testing, scope of the project, and detail explanation of particular release, RAID Risk, Assumptions, Issues and Dependencies etc).

• Gather inputs from the client (eg Types of testing, Development teams, Client managers etc).

• Prepare test plan covering timelines, resource (Man /Machine) deployment (How it will be tested).

• Seek signoff on the test plan.

• Identify specific entry and exit criteria.

• Provide Test Environment Requests.

• Identify need for test automation.

Test Design & Test Development:

• Identify the test scenarios based on the understanding of systems, interfaces and application.

• Identify end to end business critical scenarios.

• Create & Review the test scenarios.

• Design estimates (time /effort) based on the requirements analysis.

• In case of critical technology, create test scripts and seek review inputs from the test lead.

• Identify and validate test scenarios for automation.

• Create automation test scripts.

• Share created test scripts for review.

• Conduct pilot automation test run to validate the test scripts.

• Validate the test environment set up.

• Participate in customer review meetings and seek sign off by customer on the review comments.

• Based on the changes in the requirement, identify regression scenario and the impacted areas on need basis.

• If required, provide Test Case walkthrough and seek customer sign off inclusive of Prioritization of Test cases, Optimization options.

Test Execution & Closure:

• Test the defect and update the status, if required.

• Conduct root cause analysis of the defects logged.

• Prepare Test summary Report and share the same for review/ Review the test results/test reports submitted by the test analyst.

• Capture lessons learnt and the best practices adopted.

• Identify the time and cost saving made due to the best practices adopted.

• If requested, participate in release management to share impact of production dates.

• Periodically generate metrics based on the audience.

• Review metrics to identify areas for process optimization.

• Conduct dry run/smoke testing to ensure scripts readiness.

• Execute the scripts.

• Monitor appropriate server monitoring counters (eg CPU utilization, memory utilization etc).

• Perform high level/Sanity testing to ensure testing is intact.

• Participate in the defect triages to gather evidence for defect identification on periodic basis for defect prioritization and fix.

• Conduct acceptance testing, if required.

• Track defect metrics to ensure testing effectiveness as generated by QC/TFS tool.

• Track # of test cases executed as part of the daily tracker to ensure productivity.

• Provide automation/white box and other NFR status to Test Lead.

Knowledge Management:

• Maintain knowledge management portals and create knowledge artefacts (eg collaterals, reusable assets) to drive knowledge management.

• Capture and document the business/ application levels requirements details that can be used for induction of new members to the project teams.

• Conduct KT for new team members.

Audit and Maintenance and Support:

• Participate in audit at various stages to check for adherence to the company processes or guidelines (sometimes client specific).

• Upload the project specific information in portal (share point portal).

Project & Stakeholder Management:

• Track resource availability based on the criticality of the project.

• Take corrective steps to ensure project health.

• Assess the technical skills of the resources.

• Provide requisite training.

• Seek additional resources from test manager, if needed.

• Identify and track the risks along with the mitigation for closure.

• Prepare status reports (task planned for the current & next week, tasks accomplished, and action items.

• Share information on the project health through weekly calls with client.

• Participate in a monthly governance meeting (Progress on each application, Utilization Report, Types of defects, Value add provided by the team, Improvements in the form of artefact creation, productivity etc).

• Track and Monitor metrics (productivity, effort deviation, schedule deviation etc).

Brief descriptions of Projects worked:

Company: Wipro Ltd Bellevue, WA

Project

AdCRM BI & Jazz.

Duration

Dec 2010 – till date

Position: SDET

Description

AdCRM is a highly customized version of MS CRM. AdCRM is a Sales, Marketing, Analysis and Reporting Tool. This tool is used by MSN sales team which includes Account Executives, Account Managers, Sales Managers and Sales Planner. Business process which AdCRM deals relates to the sales of online advertisements on various MS properties and search like Display Ads, Search Ads, Direct Response, Shopping, Massive, and Facebook. This project is being executed on Agile (Scrum) Model.

We have mainly handled Sales module, which include Lead Management System, Contact Management System, Account Management system and Order management system. This project mainly deals with Advertisement agencies and it maintains all customers’ data in MS CRM. The project is also about getting the data from AdExpert application through staging database and then to destination server using ETL mechanism which triggers the CRM order creation and customer based on business logic. Completed CRM 4.0 to 2011 migration during the course of the project.

Roles and Responsibilities

Worked in Agile methodology, Attended daily stand up meetings to review User Stories.

Developed Test Plan and Test cases based on the user stories (Functional requirements) using the HP Quality Center

Converted manual test cases to automation test scripts.

Developed automation test framework for SoapUI and Selenium.

Developed Page Object model test automation framework along with Reusable modules, data driven testing, TestNG annotations, Jenkins integration and HTML test reports.

Cross browser testing using Firefox, Google Chrome, IE & Safari.

Worked on Continuous Integration Testing using Jenkins to execute the automation scripts using Selenium and SoapUI.

Tested Web Services, Validated Request and Response XML, SOAP Calls, RESTFul calls and WSDL using SOAPUI tool.

Validated Web Services request and response xml using SOAPUI tool.

Written custom groovy scripts to dynamically capture request and responses.

Interacted with off shore team to resolve defects and functional issues of the application.

Developed test scripts for Data driven testing using parameterization in SoapUI by using Excel sheet for test data and Database Queries based on the functionality.

Enhanced the scripts by adding user-defined functions.

Automated test scenarios for GUI, Functionality, Integration, Database, Boundary, Security and Regression Testing.

Involved in Data warehouse (DWH) testing while migrating data from existing legacy system to Dynamics CRM 4.0 and reviewed mapping documents and developed test cases for ETL testing using SSIS.

Involved in ETL testing, executed SQL queries to validate the data in target database and familiarity with fact tables, dimension tables, star schema and snow flake schema.

Attending sprint plan meetings every two to four weeks to review the user stories.

Detected Defects, Communicated to the developers using Bug Reporting Tool and Tracking the Defects using Quality Centre.

Extensively used Quality Center for test planning, bug tracking and reporting.

Uploaded Business requirements, test scenarios, test cases and defects to Quality Center.

Executed shell scripts in Unix/Linux. Worked in full QA Life Cycle.

Guiding the QA offshore and onsite team to achieve team goals with respect to project deliverables

Effort estimation and resource planning

Discussing with development team on open defects through triage calls & stand up meetings

Regression & re-testing after the defects are closed.

Business flow testing by replicating production environment data

Handling deployments on QA and UAT environments.

Performance/Load testing: Avg. response time, think time, work load modeling, Network bandwidth testing, Geographic based testing, running performance test scripts on global servers on different time zones of the day and Summarizing performance test results

UAT testing support

UAT users training & Production Support

Status report to all stake holders involved in project execution

Prepared the daily execution summary during the Execution and delivered the Sign-off document to Client& other stakeholders.

Tools/Skills: Selenium web driver/Grid, Java/J2EE, TestNG, Groovy Scripting, Eclipse, Quality Center, OBIEE Reporting tool, Linux/ UNIX, Web Services, SoapUI, XML, Dynamics CRM (4.0, 2011, 2013), Wireshark, Fiddler, Firefox, Google Chrome, IE, PL/SQL.

Project

Supply Chain Management, Microsoft USA.

Duration

Jan 2010 – Nov 2010

Senior Quality Assurance Analyst

Description

SCM project includes the maintaining different warehouse information with up to date inventory & various reports for each category like inventory management, Accounts payable, Accounts Receivables and batch job Execution. Supply Chain Management (SCM) automated solution for the Hardware Procurement Process uses MS Dynamics AX as base platform. As part of the Purchase Order life cycle, the system is integrated with multiple applications for PO Approvals, Financial Postings (SAP), Confirmation and Fulfillment of POs (ICOE and Suppliers like HP, Dell WWT), Asset Postings (I-Admin).

Manageability services group (MSG) is a group owns and develops several internal tools used heavily by other teams in Microsoft Global Foundation Services and Windows Live. This group develops various services to monitor the servers in datacenters. These services will monitor the servers and generates alerts which will be posted to a pipeline. There will be a web service which pulls the all data centers information from various expanded environment servers and sync the data all over the leaf nodes.

The goal of this project is to integrate the Microsoft Dynamics AX with different applications to fulfill the Hardware procurement process. This project is being executed on Agile (Scrum) Model.

Roles and Responsibilities

Worked on core modules of Dynamics AX like Inventory Management, Accounts receivable, Accounts Payable, General Ledger, Master Planning, Procurement, Reporting and integration with other applications.

Worked on Dynamics AX product features: Item Creation, Sales order, Purchase order creation, Invoice generation, General Ledger, Cost Groups, Master planning, AX jobs, item master, On-hand, SKU lifecycle, Asset valuation and Bills of materials (BOM).

Worked on end to end testing and module level testing.

Participated in AX deployment and configurations on test servers.

Guiding the test offshore and onsite team to achieve team goals with respect to project deliverables.

Effort estimation and resource planning

Participated in Functional Spec and Technical Spec Reviews

Gathering the Functional requirements from Business

Test scenarios, test cases, test plan preparation and reviews

Test data creation prior to test execution phase

Procurement of licensing keys and environment from Product groups.

Test case execution and defect logging. Making sure that high priority & severity bugs are logged during early phase of test execution cycle.

Discussing with development team on open defects through triage calls & stand up meetings

Regression & re-testing after the defects are closed.

Adhoc testing during final phase of test execution.

Business flow testing by replicating production environment data

Complex scenarios identification and finding defects

Boundary value analysis and negative testing

Project work break down structure development, Providing the estimates

Handling deployments on QA and UAT environments.

Automation & functional testing and issue management

Worked on data migration testing using SSIS packages

End to end ETL testing from child node to root node to check the data quality, consistency & relevancy

Worked on setup & testing of DB mirroring, Replication, Recovery models, clustering, DB restore using back up & transactional logs and troubleshooting techniques.

Extensive web services testing using complex scenarios

Regression test pass.

Performance/Load testing: Avg. response time, think time, work load modeling, Network bandwidth testing, Geographic based testing, running performance test scripts on global servers on different time zones of the day and Summarizing performance test results

Identified the bottle necks in application performance and worked with dependent teams to resolve the issues

Log bugs and follow up

UAT & Production support

Daily, Weekly & Monthly Status report to all stake holders involved in project execution.

Documenting best practices & Project Postmortem once it is released to production.

Tools/Skills: Microsoft Dynamics AX 2009, VSTS, TFS, Source Depot, Visual Studio ultimate, SSIS, SQL Server 2008, PL/SQL, Windows 2008 Server, REST API, C#.Net.

Since 2006 Tech Mahindra (formerly Mahindra Satyam)

Project

SingleView Convergent billing system

Duration

Jan 2009– Dec 2009

QA Analyst

Description

MTNL is Telecom Service Provider, operating its Wire line & Wireless businesses from Delhi & Mumbai in India, providing a wide spectrum of voice & data related services to its customers using different OSS/BSS. MTNL Convergent billing and customer care presently executed by Mahindra Satyam covers the implementation of OSS/BSS systems for the various postpaid and prepaid GSM/GPRS/CDMA/Wire line/Broadband/Leased circuit services. It is intended to transform MTNL’s existing CCBS which is a bespoke development to best of breed convergent Customer Care & Billing solution. This solution is built around Intec Singl.eview billing system, People Soft CRM based on IBM MB MQ Series / EAI to cater for their existing service offerings and to provide convergent invoice across all line of business.

Roles and Responsibilities

Involved in the project from design phase onwards

Participated in Functional Spec and Technical Spec Reviews

Provided clarifications to the team in Singl.eview billing system and peoplesoft CRM applications

Understanding data flow topology and test scenarios identification.

Attended client meetings to get more clarity on Billing and order management systems.

Tested the integration with different modules like CRM, EAI, and Provisioning systems to complete the flow of any request.

Prepared the Estimations of efforts required and informed manager to allocate the resources and Hardware

Identifying High level scenarios and Test scenarios preparation from SRS and BRD

Preparation of test cases, reviews and Inspections

Suggested and implemented corrective actions wherever required

Involved in Preparation of test plan and test strategy

Task allocation to team members through Execution plan

Involved in Functional, GUI and Backend Testing

Handled CDMA LOB UAT testing alone by integrating with Call Center and IVRS at MTNL Delhi client site.

Identified the test cases which can be automated

Identified the Performance testing scenarios

Performed DB& ETL testing

Prepared scripts in VB using QTP and done Automation testing using the QTP 9.2.

Logged the results in Bug tracking tool HP Quality center

Active interaction with development team for analyzing bugs

Report on weekly progress to the concerned manager

Conducted the triage calls and status meetings

Prepared the daily execution summary during the Execution and delivered the Sign-off document to Client at the end of the SIT and UAT for GSM and CDMA LOB’s

Tools Used QC, Selenium, PeopleSoft CRM, Intec Single view billing system, IBM web sphere MB/MQ EAI, SQL Toad, Edit plus and UNIX platform interface Putty, OBIEE,Oracle 9i, Windows XP, Windows 7

Project

Microsoft Dynamics CRM Live

Duration

June 2007– December 2008

Software Test Engineer

Description

The concept behind CRM Live is to offer Microsoft’s CRM product as a Microsoft-hosted subscription service. CRM Live will provide ease of use and maintenance. Microsoft’s goal will be to provide the customer with a “try, buy, deploy and grow” model. Here Team members used to place an order for customers on behalf of Partners using Order Management System. And also as part of the requirement Database has been migrated from a private vendor to Microsoft. As part of this there is a need to check whether the total tables, data, DB structure is being migrated from the old database to new database. And also testing has been done to check whether front end operations are properly updated in new DB schema.

Roles and Responsibilities

Involved in the project from design phase onwards

Participated in Functional Spec and Technical Spec Reviews

Prepared the Estimations of efforts required and informed manager to allocate the resources and Hardware.

Involved in Functional,GUI and Backend Testing

Suggested and implemented automation frameworks

Participated in the various estimations involved while preparation of the Test Plan

Identifying High level scenarios and Test scenarios preparation

Preparation of test plan and test strategy

Executed the test cases using Quality Center and analyzed the results

Involved in various levels of testing like Functionality, Regression Testing

Task allocation to team members through Execution plan

Preparation of test cases, reviews and Inspections

Attended the client meetings to finalize the scope of the project

Performed ETL Testing

Performed the security testing

Performance Testing on Customer & Partners portals

Performed Database Migration testing

Performed back end testing by writing SQL Queries effectively

Assigned and Executed the Test Cases

Logged the results in Product Studio

Raised the bugs for the failed Test Cases through Product Studio.

Did bug regression. If everything worked fine, closed that bug and passed the respective Test Cases

Active interaction with development team for analyzing bugs

Report on Daily and weekly progress to the concerned manager

Conducted the triage calls and status meetings

Prepared the daily execution summary during the Execution and delivered the Sign-off document to Client at the end of the SIT and UAT.

Provided 24*7 support to UAT testers

Prepared SIT and UAT sign-off documents with all the best practices followed

Delivered Go-No Go Live document to move the code into production

Prepared the Project Information and Application information documents which reduced the time and cost to train the new team members.

Tools Used Microsoft Product Studio 2.10, Microsoft Dynamics CRM, SQL Server 2005, Bugger 3.2, Macro enabled Excel work book for TSP/PSP process

Project

CRM Localization/PS Globalization

Duration

Jan 2007– May 2007

Software Test Engineer

Description

SSWS, CustomerSource and PartnerSource applications have been localized to 20 languages and tested the all .aspx pages with the Microsoft standard translator GIAA(Glossary Based Internet Application Architecture). And also designed BFAT (Automation) tool to capture the screenshots of above applications to send the screens for SUB UI reviewers, So that UI Reviewers will check for grammatical mistakes.

Roles and Responsibilities

Involved in the project from design phase onwards

Participated in Functional Spec and Technical Spec Reviews

Given class room training to new team members about the Microsoft applications

Involved in Functional,GUI, Security and Backend Testing

Suggested and implemented corrective actions wherever required

Participated in the various estimations involved while preparation of the Test Plan

Identifying High level scenarios and Test scenarios preparation

Executed the test cases using Quality Center and analyzed the results

Involved in various levels of testing like Functionality, Regression Testing

Preparation of test plan and test strategy

Task allocation to team members through Execution plan

Preparation of test cases, reviews and Inspections

Attended the client meetings to finalize the scope of the project

Did BVT Testing before SIT execution

Performed back end testing by writing SQL Queries effectively

Assigned and Executed the Test Cases

Logged the results in Product Studio

Raised the bugs for the failed Test Cases through Product Studio.

Active interaction with development team for analyzing bugs

Report on Daily and weekly progress to the concerned manager

Conducted the triage calls and status meetings

Prepared the daily execution summary during the Execution and delivered the Sign-off document to Client at the end of the SIT and UAT.

Provided 24*7 support to UAT testers

Prepared SIT and UAT sign-off documents with all the best practices followed

Delivered Go-No Go Live document to move the code in production

Prepared the Project Information and Application information documents which reduced the time and cost to train the new team members.

Tools Used Microsoft Product Studio 2.10, SQL Server 2005, Bugger 3.2, Macro enabled Excel work book for TSP/PSP process

Education:

Bachelor of Technology with specialization in Electrical & Electronics Engineering, Jawaharlal Nehru Technological University, Hyderabad, India, 2006.

Contact this candidate