Madhuri Wuntakal
Email: adbndl@r.postjobfree.com Mobile: 407-***-****
Objective
A position as a Senior Engineer that utilizes my knowledge and experience and provides me with versatile and challenging opportunities
Experience and summary
ISTQB certified Senior Software Tester.
Have extensive 7.5 Years of experience in Software Quality Assurance, Manual Testing, Automation Testing and ETL (Extract Transform Load) Testing of Data Warehouse.
Senior Software QA tester with full Software Testing lifecycle(STLC) experience, including designing, developing and implementing test plans, test cases and test processes fueling swift corrective actions and fault-free audits
Good understanding of Agile Software Development Lifecycle and have strong testing experience in Agile environment using SCRUM Methodology and as well as Waterfall models
Proficient in Data Warehouse Testing/ETL Testing within the environment of Oracle, SQL Server, IBM Web Sphere Data Stage, DB2, TeraData
Expert in working in different modules in IBM Web Sphere Data stage like Data Stage Designer, Manager and Director
Experience in Automation Testing using tools like Quick Test Professional(QTP) and Selenium
Possess specific experience in performing System, Integration, Usability, Database Testing, Imperial Testing, Localization Testing, License Testing, End-to-end Testing and Regression Testing
Proficient in HP Quality Center and IBM Rational Quality Manager for Test Designing, Requirement Mapping, Reports, Test Execution and Defect Tracking.
Experience in using Software Configuration Management tools like Rational Clear Case for Version Control.
Understanding and experience working on a variety of technologies Including SQL, HTML, CSS, WSDL,JAVA SCRIPT and XML.
Good communication skills and ability to learn and master new technologies in a short span.
Have excellent analytical, Methodical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and work as a part of a team as well as independently.
Good in prioritization of work and completion of all assignments within schedule.
Education
Examination
Discipline
School/college
Board/University
Year of Passing
Bachelor of Technology
Mechanical Engineering
Intell Engineering College, Anantapur
Jawaharlal Nehru Technological University(JNTU)
2007
PUC
Physics, Chemistry, Mathematics
K.S.R Girls Junior College, Anantapur
PUC Board
2003
S. S. C
S.S.C
Shanti Vidya Nikethan, Anantapur
SSC Board.
2001
Skills summary
Involved in Manual testing of Applications in Waterfall model SDLC and Agile methodology
Involved in Automation Testing using Quick Test Pro and Selenium
Test & Defect Management Tool: HP Quality Center 11, IBM Rational Quality Manager (RQM)
Test Execution Tracking Tool: IBM Run Rate
Defect Tracking: HP Quality Center 11, BugZilla, JIRA, IBM Rational Clear Quest
Databases: SQL Server 2008/2005, Oracle 11g, DB2 UDB, TeraData, TOAD, SQL Developer
ETL Job Scheduling Tool: Control-M
ETL & BI Tools: IBM Web Sphere Data Stage, Informatica, Cognos 8.0
Configuration Management: IBM Rational Clear Case
Web Service Testing Tools: SOAP UI, Restful Web Services
Operating Systems/ Products: UNIX, Windows – 7, Vista, XP
Languages: C, C#, Java
Certifications
International Software Testing Qualifications Board(ISTQB) Certified Tester Foundation Level on 14th July 2012
Professional Experience
Company
Designation
Duration
ISite Technologies Inc
Senior Tester
August 2018 - Till now
MindTree Pvt Limited
Test Specialist
November 2011 - February 2013
IBM India Pvt Ltd
Test Specialist
December 2009 - November 2011
EDS-An HP Company
Test Engineer
September 2007 – December 2009
Project Details
Project : PriceFX
Client : Vi-Jon
Role : Agile Tester
Company : Isite Technologies Inc
Location : USA
Pricefx is a global leader in SaaS Pricing Software. It is a cloud-based price management & Configure Price Quote (CPQ) software which is fast, flexible and friendly for all industries and all B2B and B2C companies. The client Vi-Jon Laboratories is a health and beauty care company that produces both Private Label and brand name products. Vi-Jon is trying to implement the Price f(X) software tool as part of the Vi-Jon Pricing Process Initiative, to establish a full-suite price management solution including a replacement and enhancement of the PBA (Price Book Analysis) for use in analyzing current price and modelling future price changes.
Responsibilities:
·Involved in Scrum meetings and Sprint Planning meetings
·Involved in verification of user stories which were accepted and suggested any changes if required
·Analyzed user stories and translated requirements into written test plans, detailed test cases and test schedules by following Agile/Scrum process
·Created test cases to validate the user stories during each sprint
·Involved in functional, regression, end to end system testing as a part of sprint cycles
·Reporting any defects found to the configuration engineer and to track them till closure
·Attend standup calls every day to report progress of testing
·Attend Sprint retrospective meetings at the end of each sprint to discuss about what went well, things to improve and lessons learnt from the current sprint
·Verifying the fixes for UAT defects and tracking them till closure
·Perform regression testing after any major fixes
·Involved in Automation Infrastructure Development using Selenium
·Created Test cases Using Element locators and Selenium Webdriver methods.
·Enhanced Test cases using Java programming features and TestNG Annotations.
·Execution of Selenium Test cases and Reporting defects.
·Enhancing the Test Scripts for Global Execution.
· Involved in Regression Testing using Selenium
·Preparation of weekly and monthly status reports.
Project : Zurich SOA Billing Services
Client : Farmers Insurance
Role : Agile Tester
Company : Isite Technologies Inc
Location : USA
Billing CSS is one of the projects which are part of Farmers Enterprise Web Strategy Program. One of the goals of this strategy is to provide and improve the Customer Self Service options available to the Customers, Agents and CSR community. Billing CSS implementation will be useful for Farmers Personal Lines on FAB and includes a focus on Self Service Functionality, User Interface Enhancements, and foundational enhancements.
Responsibilities:
·Involved in Scrum meetings and Sprint Planning meetings
·Involved in verification of user stories which were accepted and suggested requirements changes if any
·Analyzed functional requirements/user stories and translated requirements into written test plans, detailed test cases and test schedules by following Agile/Scrum process
·Created test cases to validate the Source and Target database systems data and mapping rules for data transformation
·Involved in functional, Integration, regression, end to end system testing and UAT as a part of sprint cycles
·Reporting any defects found to the development team and to track them till closure
·Writing SQL Queries for data analysis
·Attend scrum calls every day to report progress of testing
Project : Everest - Enterprise Data warehouse (EDW)
Client : Target
Role : ETL Tester
Company : Mindtree Pvt Limited
Location : Bangalore, India
Target, is an American retailing company headquartered in Minneapolis. It is the second-largest discount retailer in the United States, behind Walmart. Target spans many states with store formats that include clothing, shoes, jewelry, health and beauty products, electronics etc. Project Everest is an intensive effort to transform Target's retail websiteTarget.com to deliver better consumer experience and interactivity, drawing the consumer to pay more visits and stay longer to finally translate into higher conversion rates. Earlier Target.com operated on Amazon's platform since 2001. In general, an Enterprise Data Warehouse (EDW) is a data store designed to produce a single, comprehensive view of data that accumulated during the course operations. The main objective of the project is to design and build a data warehouse for query & analysis purpose to take effective decisions. Data was extracted from Flat files Source transformed and loaded to Staging Area and Staging Area to Warehouse. Reports generated from the ETL process is shown onto the front end by using Cognos technology.
Responsibilities:
·Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
·Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
·Worked closely with DBA's to develop dimensional model using Erwin and created the physical model using Forward Engineering.
·Worked with Datastage Administrator for creating projects, defining the hierarchy of users and their access.
·Defined granularity, aggregation and partition required at target database.
·Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.
·Develop Test Plans, Test Cases and Test Scripts for System Testing
·Checking UNIX servers if the files are sent by Upstream systems for us to extract or not using UNIX commands during End to End Testing.
·Used IBM Web Sphere Data Stage as an ETL tool to extract data from different source system, applying transformations and loading the transformed data into Enterprise Data Warehouse(EDW)
·Imported table/file definitions into Data Stage Repository.
·Extensively worked with Data Stage Director to monitor the job status and to view logs for execution errors.
·Controlled Jobs execution using job scheduling tool Control-M
·Extensively wrote SQL Queries to validate all the foundation tables related in EDW to check if EDW is receiving the data properly from Source systems or not, by referring to STM (Source To Target Mapping) documents for data integrity
·Tracked the defects using HP Quality Center 11 tool.
·Tested Cognos Reports according to the business requirements.
·Prepared status summary reports with details of executed, passed and failed test cases.
·Interacted with developers, Business & Management Teams and End Users.
Environment: Windows XP, IBM Web sphere Datastage, Control-M, Cognos 8.0,HP Quality Center 11, Unix, Oracle 10g, TeraData, SQL Server 2008
Project : GCA Testing
Client : Target
Role : ETL Tester
Company : MindTree Pvt Limited
Location : Bangalore, India
Description:
When guests (Customers) in Target contact Guest Relations, through email, phone, or letters, their information is entered into Guest Connect (GC) as a guest record. The guest records are passed to downstream systems in the 4 outbound feeds. One among them downstream system is GCA (Guest Connect Analytics), all guest contact data is housed here, including service requests. GCA is used by Oracle Business Intelligence for reporting. As part of GCA Testing, GCA consumes 23 files related to different Item feeds which are sent by GC (Guest Connect) team. The main objective of this project is to consume two item feeds TGR_ISSUE_ITEM and TGR_SERVICE_REQUEST sent by Guest Connect (GC) as part of GCA. Once the feeds are consumed into GCA the data related to the two feeds should be loaded in GCA foundation Tables TGRISSUE_ITEM and TGR_SERVICE_REQUEST. Reports generated from the ETL process is shown onto the front end by using Cognos technology.
Responsibilities:
·Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
·Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
·Worked closely with DBA's to develop dimensional model using Erwin and created the physical model using Forward Engineering.
·Worked with Datastage Administrator for creating projects, defining the hierarchy of users and their access.
·Defined granularity, aggregation and partition required at target database.
·Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.
·Develop Test Plans, Test Cases and Test Scripts for System Testing
·Checking UNIX servers if the feeds are sent by Upstream systems for us to extract or not using UNIX commands.
·Used Informatica as an ETL tool to extract data from upstream systems, applying transformations and loading the transformed data into tables in Enterprise Data Warehouse(EDW)
·Imported table/file definitions into Informatica.
·Extensively wrote SQL Queries to validate all the foundation tables related in EDW to check if EDW is receiving the data properly from Source systems or not, by referring to STM (Source To Target Mapping) documents for data integrity
·Tracked the defects using HP Quality Center 11 tool.
·Tested Cognos Reports according to the business requirements.
·Prepared status summary reports with details of executed, passed and failed test cases.
·Interacted with developers, Business & Management Teams and End Users.
Environment: Windows XP, Informatica, Unix, Control-M, Cognos 8.0, HP Quality Center 11,Unix,Oracle 10g, SQL Server 2008,DB2
Project : Vendavo
Client : Vendavo
Role : Test Specialist
Company : MindTree Pvt Limited
Location : Bangalore, India
Description:
Vendavo is a SAP Price and Margin Management application. It helps its customers to set optimal prices so that customers make good money on every deal. It’s proven that 1% increase in price increases the company’s profit by 10%. Vendavo helps customers segment their markets effectively, set and optimize price. Vendavo application basically comprises of three modules Profit Analyzer, Price Manager, Deal Manager. In Profit Analyzer module we will analyze whether the product was profitable or not, where the organization would have made profit etc using historical transaction data available in a database Price Mart. After analyzing the data we will create Pricing policies, Pricing Programs and set Deal guidance in Price Manager module which helps sales representatives in negotiating profitable deals. The actual execution of deal takes place in Deal Manager where the Sales representatives negotiate deals using the deal guidance policies set in Price Manager module. The main objective of this project is to set optimal prices for customers product using all the modules considering different aspects in each modules to make product profitable.
Responsibilities:
·To write the System Test Plan according to the Functional and System Requirement document.
·To write the high level scenarios for System Testing in an excel sheet first keeping in mind all the GUI level, interface level, positive and negative test cases.
·To write the detailed Test cases in the Test Management Tool and map the cases to the requirements in the tool.
·To execute the System Test cases once the System Test Phase begins and the Regression Test cases during Regression Testing.
·To report the bugs in the tool JIRA and to track the defect until the defect is fixed by the developer and the issue is closed after retesting.
·To investigate each defect by querying the database, by referring to the requirement documents whenever necessary.
·Responsible for maintaining Object Repositories and Function Library.
·Characterized defects and defined criteria for passing and failing tests for test reports.
·Logged defects in Quality Center (Test Management Tool).
·Participated in defect discussion meetings.
·Follow up with the Project team and Application Team for Bug fixes.
·Wrote SQL queries to access data from the database.
·To give support during User Acceptance Testing, track each UAT issue using Tracker tool and to investigate the UAT issues.
·Performed Web Services testing and validated XML request/response data using SOAP UI
·Used Groovy Script to connect Database
·Created Test Sets to do Functional and Data Driven Testing on the Web Services.
Environment: Windows XP, VBScript,SDL, HP Quality Center 11,Oracle 10g,SQL Server 2008, SQL
Project : GIOM-AVPN
Client : AT&T
Role : Test Specialist
Company : IBM India Pvt Limited
Location : Bangalore, India
Description:
Global Integrated Order Manager is an AT&T product which gathers orders for AT&T’s Business Service Customers like Nodal Voice, Switch Voice, Local Voice, Calling cards, Data-PL/FR/ATM/AVPN. It has a single Shopping Cart to manage the integration of the ordering process across services. It performs edits to insure on time delivery of the service, a perfect bill, automate interfaces to legacy systems, to streamline the people process via automation, eliminate re-typing via defaults and by obtaining data from upstream and downstream systems. The main objective of this project is to ensure that the orders placed by customers and its data is flowing correctly to downstream systems or not.
Responsibilities:
·To attend the requirement reviews for each project conducted by the SE team and to identify the issues with the requirement documents if any.
·To write the System Test Plan according to the Functional and System Requirement document.
·To write the high level scenarios for System Testing in an excel sheet first keeping in mind all the GUI level, interface level, positive and negative test cases.
·To write the detailed Test cases in the Test Management Tool and map the cases to the requirements in the tool by creating Requirement Traceability Matrix(RTM).
·To execute the System Test cases once the System Test Phase begins and the Regression Test cases during Regression Testing.
·To report the bugs in the Rational Clear Quest tool and to track the defect until the defect is fixed by the developer and the issue is closed after retesting.
·To investigate each defect by checking logs in putty by referring to the requirement documents whenever necessary.
·Involved in Database Testing to check if the order data is stored correctly in the database or not by using SQL Queries in TOAD.
·Was involved in API Testing as to support other interfacing applications when the JST (Joint System Testing) and IST (Integration System Testing) begins.
·To give the UAT demo for the project completed during the ST.
·To give support during User Acceptance Testing, track each UAT issue using HP Mercury Quality Center tool and to investigate the UAT issues.
·Characterized defects and defined criteria for passing and failing tests for test reports.
·Logged defects in Quality Center (Test Management Tool) and handled exceptions using Recovery Scenario Manager.
·Performed Web Services testing and validated XML request/response data using SOAP UI.
·Used Groovy Script to connect Database
·Created Test Sets to do Functional and Data Driven Testing on the Web Services.
·Validated XML SOAP response using SOAP UI Assertions.
·Conducted LOAD Testing using SOAP UI
·Generated reports using SOAP UI
Environment: Windows XP, VBScript, HP Quality Center 11, OSB, SOAP UI 3.6,HTML,CSS, XML, JavaScript, TOAD, Oracle 11g, Unix, IBM Rational Clear Quest, IBM Rational Quality Manager, SQL, WSDL,BM Rational Clear Case
Project : Final Designer 1.3
Client : AVEVA
Role : Test Engineer
Company : EDS
Location : Bangalore, India
Description:
AVEVA Final Designer is an AutoCAD-based application that enables quick definition of styles and formats, and efficient production of drawings from the AVEVA PDMS model. It is used at any point in the drawing production process to complete the final design work on a drawing-by-drawing basis. Once exported we can perform all further work using Final Designer. The main objective of this project is the designs developed in Draft module can be easily exported to Final Designer application so that user can finish the final design work.
Responsibilities:
·To attend the requirement reviews for each project conducted by the SE team and to identify the issues with the requirement documents if any.
·To write the System Test Plan according to the Functional and System Requirement document.
·To write the high level scenarios for System Testing in an excel sheet first keeping in mind all the GUI level, interface level, positive and negative test cases.
·To write the detailed Test cases in the Test Management Tool and map the cases to the requirements in the tool creating Requirement Traceability Matrix(RTM).
·To execute the System Test cases once the System Test Phase begins and the Regression Test cases during Regression Testing.
·To report the bugs in the JIRA and to track the defect until the defect is fixed by the developer and the issue is closed after retesting.
·To support other interfacing applications when the JST (Joint System Testing) and IST (Integration System Testing) begins.
·To give the UAT demo for the project completed during the ST.
·To give support during User Acceptance Testing, track each UAT issue using HP Mercury Quality Center tool and to investigate the UAT issues.
·Involved in Adhoc Testing, Imperial Testing, Localization Testing, License Testing of the application.
·Involved in Automation Test Plan Preparation.
·Characterized defects and defined criteria for passing and failing tests for test reports.
·Logged defects in Quality Center (Test Management Tool).
·Handle exceptions using Recovery Scenario Manager.
·Interacting with the developers on a regular basis for application updates and enhancements.
Environment: Windows XP, Windows 7, Windows Vista, Auto CAD, VBScript, HP Quality Center, JIRA
Project : Nuclear Applications 11.6
Client : AVEVA
Role : Test Engineer
Company : EDS
Location : Bangalore, India
Description: Nuclear Applications is a combination of two new products Nuclear Concrete Design, Nuclear Room Manager. Nuclear Concrete Design for the modeling of structural elements for buildings and Nuclear Room Manager for the modeling of free space inside rooms for the calculation of inventories and the calculation of room volumes, flooding heights and paint areas. The main objective of this project is to design a Nuclear Power Plant using Nuclear Applications tool.
Responsibilities:
·To attend the requirement reviews for each project conducted by the SE team and to identify the issues with the requirement documents if any.
·To write the System Test Plan according to the Functional and System Requirement document.
·To write the high level scenarios for System Testing in an excel sheet first keeping in mind all the GUI level, interface level, positive and negative test cases.
·To write the detailed Test cases in the Test Management Tool and map the cases to the requirements in the tool.
·To execute the System Test cases once the System Test Phase begins and the Regression Test cases during Regression Testing.
·To report the bugs in the JIRA tool and to track the defect until the defect is fixed by the developer and the issue is closed after retesting.
·To support other interfacing applications when the JST (Joint System Testing) and IST (Integration System Testing) begins.
·To give the UAT demo for the project completed during the ST.
·To give support during User Acceptance Testing, track each UAT issue using HP Mercury Quality Center tool and to investigate the UAT issues.
·Involved in Imperial Testing, Localization Testing, License Testing of the application.
·Generated Automated Test Scripts for Regression testing using QTP and executed the Test Scripts.
·Characterized defects and defined criteria for passing and failing tests for test reports.
·Logged defects in Quality Center (Test Management Tool).
·Handle exceptions using Recovery Scenario Manager.
·Interacting with the developers on a regular basis for application updates and enhancements.
Environment: Windows XP, Windows Vista, VBScript, HP Quality Center, JIRA
Project : AVEVA PDMS 12.0
Client : AVEVA
Role : Test Engineer
Company : EDS
Location : Bangalore, India
Description:
AVEVA is the world's leading engineering IT software provider to the plant, power and marine industries. Many Industries now depend on AVEVA's integrated engineering software to drive every phase of a project's engineering workflow. Basically Aveva PDMS 12.0 is a designing tool for Plant and Marine Industries. It is the fastest, most productive and risk-free tool set to design, build and operate plant of any size and complexity. It is the most productive 3D plant design solution efficient access to project information enables accurate planning of maintenance, rapid upgrades, safe and efficient in the world. Plant owners demand maximum reliability and minimum downtime. The main objective of this project is to create an accurate and clash free plant design using different 3D structures available in PDMS tool.
Responsibilities:
·To write the detailed Test cases in HP Quality Center and map the cases to the requirements in the tool.
·To execute the System Test cases once the System Test Phase is started.
·Reporting the defects in JIRA and tracking them till closure after retesting.
·Created Requirement Traceability Matrix by mapping requirements to the test cases written.
·Created Test Coverage reports
·Involved in Imperial Testing, Localization Testing, License Testing of the application.
·To prepare Test Reports for each module.
·To give support during User Acceptance Testing, track each UAT issue using HP Mercury Quality Center tool and to investigate the UAT issues.
·Created Automated Test Scripts for Regression testing using QTP and executed the Test Scripts.
·Created QTP scripts with Local and Shared Object repositories and maintained them in Object Repository Manager.
·Responsible for maintaining Object Repositories and Function Library.
·Logged defects in Quality Center (Test Management Tool) and tracked them to closure after retesting.
Environment: Windows XP, Windows Vista,VBScript, .NET, HP Quality Center, JIRA