Madhuri

Quality Assurance Professional

e-mail id: acz716@r.postjobfree.com

Phone #: 240-***-****

SUMMARY

•About 8 years of IT experience in testing Web and Client/Server based applications with expertise in full system development lifecycle

•Have experience in ETL and Data Warehousing testing using Informatica as ETL tool

•Experienced in Web Service testing using SOAP and REST protocol on SOAP UI

•Has extensive business domain knowledge in diversified fields

•Experience in both Water fall and Agile/Scrum Methodologies

•Extensively involved in preparing Test Strategies, Test Plans, Test Cases, Test scripts and Metrics

•Knowledge of SDLC, Testing Life cycle, Methodologies and Techniques

•Extensive experience in writing/ debugging of Stored Procedures, Functions, Triggers, Views, Indexes and Sequences in SQL, MySql,DB2, ORACLE and TERADATA

•Expertise in writing, executing & testing complex SQL queries

•Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications

•Extensively worked with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.

•Comprehensive understanding of OLTP/OLAP System Study, Slowly Changing Dimensions types (SCD'S) Analysis and E-R modeling

•Experience in testing SSRS, OBIEE, Cognos reports

•Mentored the team by providing technical and management assistance

•Responsible for performing all phases of Quality Assurance software testing during development and prior to the application being launched and continuing during the product life cycle

•Hands on Experience with basic Unix/Linux commands

•Experience in automating the functional/regression test cases using Hybrid and Page Object model Frameworks using Selenium

•Experience in working with Big Data and Hadoop File System (HDFS)

•Experience in working with ecosystems like Hive, Pig, Sqoop, Map Reduce, Flume, Oozie

•Good expertise on Exploratory Testing using Domain Knowledge

•Proficient in detecting, logging and managing Defects Lifecycle as part of Quality Assurance and worked on different test and defect management tools

•Developed Test Cases using WSDL, Schema files which defines Web Service Request, Response, methods/operations, End Point of web service to be tested

•Experience in setting up the environment and deploying the application builds

•Involved in providing status reports of team activities against the program plan or schedule

•Provided Application Support/Maintenance for already released product versions

•Reported the Status and Milestones of the projects to various stakeholders .Prepared Traceability Metrics to track the missing Test Cases

•Created and updated Quality Process Documents

•Experienced in working independently and as a team member in designing, developing and implementing innovative quality process and system solutions using new approaches and technology

•Self-starter, result oriented, and a hard working team player with a zeal to learn new technologies and undertake challenging tasks with a positive, flexible and a detailed oriented attitude.

•Managed QA Metrics by generating Defect Detection Ratio (DDR), Test Coverage Metrics, Defects by Severity, Total # of Defects, and Defects per build, Defect Fix Rate, and Defect Density Reports and various other measurements for Project status reporting

TECHNICAL SUMMARY

Software Testing Tools

Selenium 2.0

Bug Tracking Tools

HP Quality Center, HP ALM,TFS, BugNet,Mantis, Jira

Operating Systems

Windows 95/98/XP/NT/2000, UNIX

Internet Technologies

HTML, DHTML, VBScript, Java Script

Web Services Testing Tool

SOAP UI, Json, Swagger

RDBMS

ORACLE10g/11i,SQL Server, MS QL,DB2,Teradata

BI tools

SSRS 2008,OBIEE

ETL tools

Informatica 9.x

Big Data Tools

Cloudera 5.x, Yarn, Zookeeper, AirFlow

Big Data ecosystem

Hadoop – HDFS, Map reduce, Hbase, Pig, Hive, Flume

Packages

MS Office

MS Technologies

InfoPath

PROFESSIONAL EXPERIENCE

DETAILS OF THE PROJECTS

Project: Kogni

Sep 2016 - till date

Client

Clairvoyant–Chandler, AZ

Role

Test Lead

Technologies

MySQL, Oracle, MSSQL Server, Hadoop – HDFS, Map reduce, Hbase, Pig, Hive, Flume, Cloudera 5.x, JDBC drivers, ODBC drivers for Solaris, AirFlow, LDAP,HP Quality Center, Web services(Restful API)

Scope

Kogni is a suite of end-to-end tools and solutions for the Data Lake, designed to help data scientists, engineers, and business users unlock the value of data at every stage of the data journey, from data federation to decision making. It tools help hide the complexity of building scripts and jobs and make everyday tasks simple. Visual tools help you analyze, and secure data within the data lake

Currently Kogni constitutes the following features

1.Data Source Management (MySQL, Oracle, MSSQL Server, SyBase, HDFS and Hive)

2.Data Inspection (data in both Relation DBs and Hive/HDFS)

3.Data Ingestion (from MySQL, Oracle, MSSQL Server to Hive)

Kogni system is built in a modular fashion (micro services) where the modules are responsible for a specific functionality and the modules interact with each other using REST APIs.

Responsibilities

•Worked in a highly dynamic AGILE environment, worked effectively with Developers and participated in scrum and sprint meetings

•Managing the activities correlated with designing, implementing test cases and authenticating the defects after the fix

•Participated in Sprint Planning, daily stand ups, sprint demos and retrospectives

•Collaborated with Product Owner and Scrum Master to discuss testing progress.

•Conducted testing walk through with Product Owner and team

•Validated the Ingestor module responsible for ingesting the source tables/data to data lake and also tested the underlying RESTful web services using Swagger tool

•Created Test Suites, Test Cases used Request Step, Assertion Step, Script Step, and Property Step in the test cases for SOAPUI

•Validated the Sqoop task that gets the raw data from Data lake and also verified the data population to new hive tables

•Validated the loaded dataset into Hive for ETL (Extract, Transfer and Load) operation

•Involved in testing the functionality with different roles and user

•Participated in bug Triage meetings

•Interacted with offshore team on daily basis on understanding of different modules they worked on for testing.

•Identify the test data required to complete test scenarios and interact with project team members to ensure the data is available for testing the Application

•Monitored Airflow to check the schedule runs

• Published test summary reports to the team at the end of release cycle

Project: COX

June 2014 - Aug 2016

Client

Cox–Atlanta, GA

Role

QA Lead

Technologies

Informatica 8.6/9.1,ORACLE 10g,DB2, OBIEE,Windows, in-built tool for SQL, .Net Application, Web services ( RESTful service),HP Quality Center, TFS,Selenium WebDriver 2.0,MS-Word, MS-Excel,Microsoft Outlook

Scope

Cox provides cable and broadband services to its customers. It is best known for pioneering the bundle of television, Internet and telephone services together, offering consumers the ability to consolidate their services with one provider.

This program builds upon the data captured and is aggregated for usage and modem information. And this program adds web services support (providing data to internet tools and customer facing applications) and providing operation reports using OBIEE as reporting tool.

Responsibilities

•Worked in an Agile environment and collaborated effectively with development team members

•Participated in Scrum meeting for planning which involved clarification of user stories, estimates and breakdown user stories in tasks, daily scrum, and sprint demo and retrospective

•Collaborated with Product Owner and Scrum Master to discuss testing progress

•Explained the Task Break down, Functionality and Scope of the Application to the QA team

•Documented Test strategy and test plan based on the requirements

•Designed Test Cases and Test Scenarios for Functional, System and Integration Testing based on the requirements

•Mapped test cases to requirement in Requirements Traceability Matrix

•Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members

•Validated the data aggregations i.e. match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications

•Analyzed Source to Target mapping document based on Facts & Dimensions and validating the DDL, Counts, Not Nulls, Duplicates, PK & FK validation, business rules to be applied on target tables

•Validated Type II SCD for loading current and history data

•Tested ETL process to push the transactional data from the normalized data structure into the data marts

•Reviewed/Validated SQL queries/test scripts written by team members to validate data and check the query meets business requirements

•Performed Smoke, Functional, System, Ad-hoc, Regression and Database Testing

•Validated the existing data migrated from DB2,postgre SQL to Oracle

•Validated the metrics and testing OBIEE reports based on Business requirements

•Reviewed and executed Test Cases and captured test results in Test management tool

•Configured Selenium WebDriver, TestNG, and created selenium

automation scripts in java using TestNG prior to sprint release

•Created various Test Classes with Page Object model as per application business model using TestNG framework in selenium

•Involved in testing Web services(SOAP and REST) and XML with tool called 'SOAP UI' for the local WSDL / with URL and created Test cases, run them

•Tracked defects/issues reported by team members during testing

•Interacted with the product team through e-mail(microsoft outlook) and conference calls through Skype or WebEx and provided them with daily/weekly status of multiple projects, reported issues based on requirements

•Interacted with developers, business analysts to resolve technical business issues

•Worked with cross functional teams based on project needs.

•Extensively coordinated with business teams for review and sign-off of test artifacts

•Participated in periodic Bug Scrub meetings

Project: Orthopodz

Feb 2013 - Jun 2014

Client

OrthopodzInc.–Santa Ana, CA

Role

QA Lead

Technologies

Informatica 8.6/9.1,ORACLE 10g,OBIEE,Windows, in-built tool for SQL, .Net Application, Web services (ASMX, REST), HP Quality Center, Selenium WebDriver 2.0,MS-Word, MS-Excel

Scope

Orthopodz.com helps surgeons find orthopedic products that are related to their needs. The site helps surgeons understand new methods of surgery and give them a choice of products from many manufacturers that can be used. The site also caters to orthopedic companies trying to get their products in front of qualified Orthopedic Surgeons.

Responsibilities

•

Created and implemented Test Plan and Test Strategy Document outlining the scope, objectives, timeline and focus of software testing effort for functional, regression, black-box and User Acceptance Testing

•

Actively participated in QA meetings and regularly interacted with Business teams and the Development team to gain a better understanding of the Business Process and Requirements

•

Involved in Task Creation, Task Estimation, Task Distribution, Task Prioritization and Communication among Team Members

•

Performed Peer reviews for the Test Artifacts

•

Prepared Test Data based on the Test Scenarios and Test Conditions

•

Performed validation to verify the data extracts and record counts in the database tables

•

Analyzed and developed functional test scripts based on STM document to validate data for Administration, Patient Register, and Medical reports

•

Complete responsibility of all QA deliverables for QA and Processing teams

•

Conducted walkthroughs of test cases, test scenarios and took approvals from clients and project teams

•

Monitored the scheduled jobs in informatica monitor

•

Validated the SRRS reports based on business requirement by developing SQL queries against Data Mart tables and ODS

•

Performed UAT and Regression Testing

•

Conduct Bug Triage meeting with the development team to discuss the defects identified during testing and action items.

•

Automated regression testing using hybrid framework i.e. both data driven &keyword driven using Selenium WebDriver.

•

Worked closely with the development team to ensure quality deliverables

•

Played active role on Interacting with Clients to analyze the business needs and customize the products by designing, developing and testing the products at various phases

•

Prepared test reports and test metrics at the end of sprint

Project: AMO Healthcare

Jan 2012 - Dec 2012

Client

Advanced Medical Optics–Santa Ana, CA

Role

QA

Technologies

.NET Framework, C#, ASP. NET, Web Service, SQL Server 2008, InfoPath, Jscript and ASPX pages,Jira

Scope

This solution helped maintain a workflow along with email to give timely information about the changing status of an Action Request. Email reminders by the Notifications tool and color coded table of Action Requests in the website portal helped to keep better track of the Action Requests. It also helped reduce spreadsheet bottlenecks by using distributed forms collaboration. Auditing was provided where all versions of the Action Request were saved and could be very easily brought up to verify. Digital signatures and access based on security groups in the Active Directory was used to provide security so as to hold people accountable on the data at each part of the workflow of the Action Request.

Responsibilities

•Analyzed Business and system specifications, designed and developed test plan and test cases, test scenarios

•Actively participated in QA meetings and regularly interacted with Business teams and the

•Development team to gain a better understanding of the Business Process and Requirements.

•Performing quality assurance functions covering the full software development life cycle, including development and implementation of test plans, test scenarios and test cases.

•Identify test data required to complete test scenarios and interact with project team members to ensure the data is available for testing the Applications.

•Performed Web Services testing using various party tools like SOAP UI, Internal XML submission tool

•Wrote and Executed SQL scripts as part of Backend Testing

Project: Music Library Service Company (MLSC)

Jan 2011- Dec 2011

Client

Music Library Service Company –Wilmington, NC

Role

QA Analyst

Technologies

.NET Framework, C#, ASP.NET Application, and SQL Server 2008.

Scope

Marketing for small business has tended to be rather fragmented, time consuming and technically intimidating - often more of a distraction from running a successful business than creating competitive advantage. The challenge is to create an ultimate online sales and marketing resource for a small business that will deliver a comprehensive suite of online marketing tools, the "best of the web" to small business owners.

Music Library Service Company is a wholesale provider of recorded music and videos exclusively to academic and public libraries for eighteen years. MLSC supplies any CD/DVD in print and manage a database of over 700,000 active titles. Their main goal was to provide a rich user experience via web application to minimize phone based orders.

Responsibilities

•Managed activities correlated with designing, implementing test cases and authenticating the defects after the fix..

•Work with BA for requirement gathering, identifying test scope, test process, risk and mitigation/contingency plans

•Documented Test plan and designed Test Cases based on the functionality of the application

•Deployed application in test environment

•Conducting Back-end testing using SQL to enforce business rules.

•Identified and documented defects and coordinated the work with team members

•Reviewed and executed Test Cases and captured test results in test management tool

•Interacted with Developers in resolving issues and bugs

•Involved in weekly project meetings with development/ QA teams to review the development and QA updates and discuss the bugs.

•Prepared documents for project summary, test executions, Defect reports and status updates.

Project: Business Marketing Tools - Vavou Services

Dec 2009 - Nov 2010

Client

VAVOU–Atlanta, GA

Role

QA

Technologies

SQL Server 2008, Web services (ASMX, REST), ASP.NET web framework, Quality Center, Telerik Ajax control framework.

Scope

Vavou is a comprehensive suite of the World's best online applications in one location. Engage customers with compelling newsletters; update them with a blog or advertising campaign, then sell the products in their shop. And all in only a few clicks with no technical knowledge required. Using Vavou’s site, a small business owner can

Responsibilities

•

Understood the Requirement Specifications, Functionality and Scope of the Application

•

Documented Test plan and designed Test Cases based on the functionality of the Application

•

Modified and maintained Test cases due to changes in the application screens and workflow.

•

Maintained the bug Reports for defect tracking

•

Prepared test data and scripted test steps for UAT.

•

Interacted with the team on daily basis to provide daily & weekly status report to team members

•

Analyzed the test results and regularly tracked defects/issues reported by other team members

•

Provided daily/weekly status report of project and issues to stakeholders

•

Prepared Test Execution Metrics

Project: Lucid Commerce

Feb 2009 - Dec 2009

Client

Lucid Commerce–Seattle, WA

Role

Developer

Technologies

SQL server2005, Informatica,SSRS 2005,BugNet

Scope

Lucid Commerce is a leading provider of on-demand business intelligence solutions for direct marketers. It is a fast growing company based in Seattle. There software products enable direct marketers to maximize the returns on their marketing investments. With the attribution complete, Lucid Commerce is able to provide dashboards that report the true ROI of every media purchase a marketer makes.

Responsibilities

•Understood the functionality of the Core Product

•Involved in requirement gathering

•Developed SSRS reports based on the requirements

•Unit tested and documented the test results

•Coded reports according to Standards using best practices such as naming conventions, client specific standards, etc.

•Used BugNet for defect tracking

•Involved in defect fixing and provided support to QA during testing phase

•Prepared status reports and shared with internal Project management team on weekly basis

•Reviewed the Functional Specifications and Test Cases with the QA team

EDUCATION

Bachelors of Technology from C.B.I.T, Osmania University in 1999

Contact this candidate