SUREKHA MANDHANIA
** ******** ** **** ******* NJ 08550 Cell: 908-***-****
**********@*****.***
Summary:
3+ years of progressive experience in Information Technology with focus on QA
Analysis, Test Case Preparation, and testing of web based and Client-Server applications.
Knowledge of all phases of SDLC and Strong working knowledge of Software
testing (Functional, Integration, Performance, Quality Metrics).
Experienced in defining Testing Methodologies, Designing Test Plans and Test
Cases, Verifying and Validating Web applications and Documentation based on
standards for Software Development and effective QA implementation in all
phases of Software Development Life Cycle (SDLC).
Have Working knowledge on Automation tools (QTP) Proficient in all cycles of
test life cycle from test planning to defect tracking and managing defect lifecycle.
Basic Experience in Database/Back end testing using SQL & PL/SQL queries.
Experience in Working with databases like Oracle, MS SQL Server & MS Access
Has strong Domain Knowledge in brokerage, Wealth Management and in
Compliance products.
Professional experience in designing Test Cases for Windows environment.
Analyzing bugs and interacting with development team members in fixing the defects.
Developed and updated Test plans, Test Scenarios, and Test Cases for all company
products.
Technical Skills
Functional Testing Tool QTP 8.2, and Win runner.
Operating System Windows XP/20000/ME, Windows Vista.
Defect Tracking Tool Quality Center, Clear Quest.
Languages C
Browsers IE (5.x/6.0/7/8),mac
RDBMS\Database Oracle10g, SQL Server, MS- Access
Software Microsoft office Suite
PROJECT EXPERIENCE
Quality Assurance Tester
Epoch Solutions, Inc.
Oct 2014 to Current
Epoch Billing System (EBS) is CLEC Telecom Billing System. EBS is complete web-
based billing and customer care platform.
Responsibilities:
•Prepare & execute test cases and related scripts.
• Verify results with expected results.
• Performed Functional, Integration and Regression tests on several modules of the
application.
SUREKHA MANDHANIA
10 Woodbury CT West Windsor NJ 08550 Cell: 908-***-**** **********@*****.***
• Document and Communicate bugs using Test Director.
Quality Assurance \Data Analyst
Projects: GWM Client Data Migration, GWM Client Activation
02/11-7/11
Client: Merrill Lynch, Pennington NJ.
Project Synopsis: Global Wealth Management (GWM) deals with migrating hub
Client Data to one of the Master Profile (MP) Hubs. Using ETL staging process, client
data from MP hub is loaded into GWM Party Index Hub.
GWM hub Clients Activation is the process of creating new Merrill Lynch (ML)
Brokerage clients through Online Account Opening (OAO) and approving them in
Enterprise Account Opening (EAO) so that all the activated clients are displayed along
with Bank of America activated clients in WCC hub.
Responsibilities:
• Reviewed Design Documents and understood business flow.
• Verified data flows and connectivity between different components, which are
used for interfacing.
• Developed and used SQL scripts to validate Informatica, Data Stage and Micro
Strategy reports.
• Identified source tables and target tables based on the design documents
• Identified no of columns in target tables that are modified due to the
transformation logic.
• Identified the transformation logic involved for each target column based on the
design documents
• Developed test cases that include SQL queries to verify target tables against
source tables.
• Involved in Production testing for Portfolio Management project to check daily
data releases.
• Database analysis and backend testing using SQL to obtain sample data,
production verification, and reporting.
• Verified the mainframe reports in EAO.
• Coordinating with cross-functional teams in different locations for quality data
and analysis.
• Logged defects using Clear Quest.
• Shared test faults and outcomes to the project managers and the application
developers.
Environment: Oracle 10g, Mainframes, .Net, VB.Net, XML, JavaScript, SQL Server,
Windows XP.
Quality Assurance Tester
Epoch Solutions, Inc.
May 2010 to October 2010
Epoch Billing System (EBS) is CLEC Telecom Billing System. EBS is complete web-
based billing and customer care platform.
Responsibilities: • analyzed the Business Requirements of EBS.
• Involved in testing of the system both manual and automatic. Also responsible for
preparation and execution of Test cases and Test Scripts.
• Developed and executed test cases and verified actual results with expected results.
• Created Manual Scripts based on Use case requirements.
• Performed Functional, Integration and Regression tests on several modules of the
application.
• Managed Scenarios and ran them with the Objective of testing the server
performance with gradual increments in user loads and for obtaining average
response time.
• Documented and Reported bugs using Test Director.
QA Tester
Esmart Solutions
Edison, NJ
June 2009 to January 2010
CIMS (Customer information management system). This system imports data from
various client locations into database then tested for the duplications of the entries.
Used Black box testing for the data duplication
Responsibilities: • Entries were checked for duplication using PL/SQL scripts and
created temp tables
• Documented complete software testing process.
• Interacted with developers, and testing teams to identify applications defects.
ADDITIONAL EXPERIENCE
Teaching Hindi at Grover Middle School (West Windsor, NJ)
EDUCATION: Master's in Accounting, Osmania University INDIA.