QA_Ipsita mohapatra
Resume:
Ipsita Mohapatra
Employer: Sapna
********@*****.***
******@***********.***
Professional Summary
> QAI Certified Software Test Engineer (CSTE) with 8 years of extensive
experience in IT solutions in Testing & Test Data Management
solutions.
> Excellent understanding of Software Development Life Cycle (SDLC) &
Software Testing Life Cycle (STLC) in different testing methodologies
like Agile and Waterfall Model etc.
> Experienced in developing Test Strategy, Test Estimations, Test Plan
and Test Case preparation and execution in testing the applications
manually and automatic with focus on Quality Assurance, Functional
testing, GUI Testing, System Testing, Black Box Testing, End to End
testing, UAT and Regression Testing of Web-based and Client/Server
based applications.
> Experienced in field of testing Web-based applications, Web Services,
Windows based application, Java & .Net based applications.
> Well versed with CMMI quality processes and implementation
> Experienced in Test Data Management across domains involving Test Data
strategy preparation, Test Data creation, Data Integration,
Subsetting & Profiling.
> Proficiency in Structured Query Language (SQL), extensively involved
in test data preparation & Data validation from Relational databases
Oracle, MS-SQL.
> Experienced in participating & conducting requirement review meetings,
analyzing requirements, developing test plan, test cases & Requirement
Traceability Matrix, Defect management, Reporting and tracking & Root
Cause Analysis (RCA).
> Experienced in Mobile Testing of applications developed using various
mobile technologies including J2ME, Blackberry, Android, Symbian, .Net
Technology etc for Browser-Based mobile apps, Native Mobile apps and
Hybrid Mobile apps.
> Very good exposure of testing applications on wide range of Mobile
handset of different vendors which includes Nokia, Samsung, Google G1,
Sony Ericson, Motorola, Windows Mobile, HTC, LG, I phone and
Blackberry.
> Extensive knowledge in mobile technologies like GSM, GPRS, WAP.
> Experienced in testing web based applications & web-services such as
online checking/saving account, Consumer loans, Credit cards, Fund
transfer, Mortgage lending, Insurance and Foreign exchange etc.
> Technically adept with exceptional skills in requirement analysis,
testing & documentation.
> Experienced in preparing the test reports after post mortem analysis
of the software based on test results and defect reports.
> Highly motivated, self-starter, able to work independently and
collaboratively within a diverse technical team, experienced in
interacting with Business Analysts, Subject Matter Experts and
Database Designers.
> Self motivated, excellent communication and excellent people
management skills, Result oriented, committed and hard working with a
quest to learn new technologies and undertake challenging tasks.
TECHNICAL EXPERTISE
Operating Windows 95/98/NT/XP, UNIX/ Linux (HP-UX, Sun Solaris)
Systems
Testing Tool HP Quality Center/ ALM, QTP 9.5, 10, SOAP UI,REST, Clear Quest,
Rapid SQL, Putty, Microsoft Test Manager, JIRA, Bugzilla,
Rally, IBM(Rational) Test Manager
Languages C, C++, HTML, XML, Visual Basic(VB),SQL, Java, JSP, .NET
Databases ORACLE 8i, 9i, SQL server7.0, Toad for interface with oracle,
SYBASE, MS-Access
Web/ App Server Tomcat, Apache, IBM Websphere, Web Logic Server, SoapUI, Web
& Other tools Services,WSDL, AJAX, HTTP, HTML, XML, Informatica (ETL, Data
warehouse),Microsoft Visual Source Safe, Sharepoint, Team
Foundation Server ( Visual Studio 2010), Clear Case
Education: Bachelor's in Computer Science, India 2005
Professional Experience
Capital Group of companies, Los Angeles, CA
May 2012-Present
Project Description:
The Capital Group Companies, Inc. (CGC) provides central services to its
affiliates, which manage the investments of individuals and large
institutions through mutual funds, separately managed accounts and pooled
investment funds.
Quality Management service in CGC is a centralized service that supports
different testing activities such as System Testing, Integration Testing
and Test Data Management carried out as part of different programs,
projects and maintenance releases. Objective of System testing involves
simulating the real life scenarios in test environment .As part of the
Integration Testing, the activities include testing of the integrated
scenarios as per the current business scenario to the accuracy expected
in real life transactions. Test Data Management activities are to
generate accurate test data and distribute as required which improves
testing of various functional tracks and co-ordination among different
components by generating data at one place. Also the service includes
streamlining the Test data generation, Testing process and establishing
metrics to analyze effective use of Test Data.
Role: QA Analyst
Key Responsibilities:
. Extensively involved in all phases of SDLC (Software development Life
cycle) and follow Agile methodology. Participated in Scrum meetings in
agile environment that closely focused on the features required for
scrum development and followed a Sprint Cycle that is 3 weeks and
achieve the target set for the sprint.
. Analyzed the business requirements and developed Test plans, Test
strategies and Test cases.
. Worked with Project Management to scope the testing effort and provide
status and estimates.
. Conducted System Testing, End-to-End Testing, Regression testing .
. Participated in Walk-through and defect triage meetings periodically.
. Involved in performing GUI testing & Batch Testing.
. Written SQL queries for validating the front-end data with backend.
. Extracting data through SQL queries to test data in the reports.
. Involved in database testing using TOAD for accessing, inserting,
modifying and deleting data in the database.
. Scheduled batch jobs, checked the log files and the status of back-end
jobs running on UNIX servers using Putty & AUTOSYS.
. Executed scripts on UNIX test servers for real time data extraction
and loading, deployment on test servers.
. Used UNIX commands on test and production servers for file transfers,
editing and data validation.
. Developed User-Acceptance-Test scripts and assisted UAT team to
perform UAT.
. Used Rally for User story planning during Acceptance Testing.
. Participated in issues resolution and change control process.
. Reported bugs / defects through HP Quality Center and TFS (Team
Foundation Server).
. Created negative test scenarios, boundary tests for various
applications.
. Interacted with end-users to come up with a seamless, scalable
solution that provides an uncluttered and easy-to-use interface,
and allows consumers to find features faster.
. Used Quality Center for test planning, test execution and defect
tracking, upload requirements and test cases.
. Linked requirements to relevant test cases and defects for thorough
traceability.
. Involved in executing automated scripts using Quick Test Professional
for Regression Testing purpose.
. Tested web services, XML, WSDL using SOAPUI tool. Modified end points
when we worked on
different servers and different versions of Web Services.
. Tested WebServices, providing required input data to request XML and
validated response XML
. Also executed test scripts, maintained Test results and Test data in
TFS (Team Foundation Server).
. Coordinated with developers to recreate the errors and maintained the
trouble log reports. Involved in conducting the test walk-throughs and
worked closely with project management.
. Developed reports and test Metrics to analyze and present the test
results to the management.
. Created weekly status reports for team management on behalf
of QA team.
WellPoint, Mason, Ohio
Jan 2011 -May 2012
Project Description:
The process of transitioning business from WellPoint NextRx to Express-
Scripts was known as ESI Migration which was broken into two categories
of activity: pre-close and post close.Pre-close activities included all
efforts i.e Finance, Multisite, Rate Load, Retail Margin to allow
WellPoint to realize the benefits of the improved ESI negotiated rate
structure for drugs while still processing the business on the WellPoint
PBM platforms. Post-close activities focused on the conversion of the
PBM business to ESI systems; and establishing the environment required to
support the ongoing relationship. Platforms involved in migration are
Direct Clients, FACETS, WGS, CS90, ACES, CHIPS, AMISYS, Q-Care, STAR,
NASCO & Medicare etc.The Systems Migration and ICD-10 (MI-10) program
team ensures that the business goals established for systems migrations
are realized and that critical ICD-10 remediation activities are
implemented. Both functions are an important part of the larger WellPoint
technology vision.The QCARE Migration program is migration of "Legacy"
medical claims systems onto three enterprise medical claims processing
systems (WGS, NASCO and Facets), consolidating other processing
activities onto new enterprise applications ensuring critical ICD-10
remediation activities are also being implemented as these systems cannot
be remediated for ICD-10 as required by 2013.Test data management
activities for ESI Migration & QCARE Migration involved leading a
centralized Test data team which will help in making sure all involved
test teams have the required test date on time in their environments.
Role: Test Lead
Key Responsibilities:
. Performing System Testing, Integration Testing and Regression Testing
. Reviewing Functional Requirement Specifications and created test cases
based on test scenarios drawn from functional requirements.
. Developing Test Plans, Test Cases, Test Scripts, Test Strategy, Test
Scenarios and Test Reports.
. Using Quality Center & Team Foundation Server for cases, Defects
management and traceability.
. Testing Web Services through XML
. Using SOAPUI to validate the response.
. Perform Claims validation of facets application as required
. Responsible to prepare the Test Results and submitting to the higher
management.
. Tested the database tables for data integrity using SQL Queries.
. Performed data validations for STAGE application for all clients every
month.
. Prepared test summary documentation that was used by other team members
in the team. Uploaded the same to project share portal.
. Analyzing the requirements & preparing test data management
recommendations for test teams.
. Estimating effort required for data provisioning, coordinating and
creating Test Data Management Strategy
. Coordinating with the internal & external stakeholders who are involved
in different tiers of migration activities to satisfy their Test data
requirements at one place.
. Provisioning accurate data, managing the data, maintaining data integrity
and reusing them across migration testing of various functional tracks.
. Streamlining the Test data generation, Testing process and establishing
metrics to analyze effective use of Test Data.
. Daily and weekly Status Reporting to client that includes cumulative
Test and Bug Metrics
. Conducted gathering of requirements for functionality development and new
requirements from users, organized activities between development and QA
to ensure compliance with project timelines for Oracle order management
and Oracle Install Base modules during the upgrade of Oracle ERP from
Release 11.5.9 to Release 12.
. Expertly granted production support across Sales Online, Oracle Order
Management, Oracle Install Base, Oracle Discoverer and Custom Billing
application.
. Conducted root cause analysis of issues and worked with track lead and
development to provide fixes
Accurately created test cases and conduct unit, integration and user
acceptance testing
. Effectively designed and deployed business reports using Oracle
Discoverer.
. Ensured identification of software problems, accurately wrote easy-to-
follow bug reports and log them into Quality Center, monitored the
development and verified fixes
Bank of the West, CA
June 2010 - January 2011
Project Description:
Worked on Web Based Banking Applications at Bank of the West (CA). This
application is designed for the customers of the bank to perform the daily
activities of their account with the bank such as online checking/saving,
consumer loans, credit cards, mortgage landing, insurance, foreign exchange
etc.
Role: QA Analyst
Key Responsibilities:
. Analyze business, functional and system requirements to formulate a test
strategy and test plan for application developed in .Net framework.
. Wrote and executed test cases, test steps & automated scripts using
Quality Center and Quick Test Pro on the web and on desktops.
. Performed cross-browser and cross-platform testing.
. Manually tested backend using SQL Queries.
. Participated in reviews/walkthroughs of test plans, test cases, test
reports, functional requirements and technical specifications
. Used Bugzilla to file and manage defects for various Projects/Releases.
. Generating and maintaining test scenarios, test data, test environments
and its configuration for quick and timely testing.
. Established test data setup criteria for enhancing tester ability to test
all scenarios. Also coordinated with test data preparation group for the
purpose.
. Interacted with group leaders, developers and team members for quality
assurance.
. Responsible for making management aware of major issues and potential
issues.
State Auto Insurance, Colombus,OH
Jan 2010-Jun 2010
Project Description:
Guidewire suite is a web-based underwriting and policy administration
system for personal and commercial line carriers in the property and
casualty insurance (P&C) industry lifecycle. The system suite is mainly
integrated within products like PolicyCenter, BillingCenter and Contact
Management System in a Service Oriented Architecture. PolicyCenter typical
users can be underwriters/ producers/agents who
can create and manage policies, service accounts, evaluate risks, view
policies, create activities, and handle inquiries.As a QA Analyst and
tester I was involved in PolicyCenter customization with BA/SME's and in
validating according to the Autobusiness insurance process of American
Family Insurance. The major business jobs of a PolicyCenter is storing
information about a policy and managing a set of processes (jobs) like
submissions, renewals and changes. If completed successfully these jobs
might trigger an action
in other products like BillingCenter and Contact Management System with
other applications/products like OnBase and xPression. Some examples of
PolicyCenter jobs are: creation of a new policy, renewal of a policy for a
new term or cancellation of a policy.
Role: QA Analyst
Key Responsibilities:
. Reviewed and understood user stories/ functional Requirements and various
business requirements documents.
. Designed and executed Test plans and Test cases according to product
backlog and user stories
. Identified and organized the overall plan for test data, strategy and the
Scope of testing within the context of each Sprint.
. Performed Sprint level testing, Functional Testing, Systems Integration
Testing, UAT, and Regression Testing.
. Participated in dailyScrum Meetings, Sprint Planning Sessions, Sprint
Review and Sprint Retrospective Sessions.
. Involved in preparing burned down chart for measuring the progress of the
project with stakeholders.
. Demonstrated to client/product owner in sprint review sessions that all
requirements are met as per sprint backlog
. Interacted with developers, Business & Management Teams and End Users
. Prepared and provided status summary reports on system status, system
changes, problems and potential impacts.
. Interacted with different integrations services like Rating, Motor
Vehicle, Address validation and Document & Forms
. Tested various major functionalities like Policy Submissions, Changes,
Cancels, Reinstate, Rewrites and Renewals.
. Performed Policy and Billing Center Integration Testing on various
Billing Instructions.
. Worked with developers by updating the defects and resolving them and
tracking the status.
. Defects found during testing were logged in HP ALM (Quality Center 11).
. Queried database using SQL queries to ensure data integrity and to
validate the inserted and updated data
. Tested business integration between internal and external systems in a
SOA.
. Reviewed Product backlog and updated task status in Rally.
. Discussed with the team in identifying regression areas that can be
automated
. Maintained RTM to check if all the requirements are implemented and
Tested according to entry/exit criteria
Mshift Inc, Fremont, CA
Sep 2009 - Jan 2010
Project Description:
MShift is a pioneer and the leading provider within the Mobile Banking
industry. It powers over 200 US Mobile Banking/Financial
applications. Worked on mobile based applications for clients like Bank of
Hawaii, Bank Plus, JP Morgan Chase, US bank, Technology Credit Union,
Capital One, Fairwinds Credit Union and many more.
Role: QA Analyst
Key Responsibilities:
. Interacted with Business Analysts and developers in requirement analysis,
design reviews, testing and documentation of application developed in Agile
environment.
. Involved in Scrum meeting, reviews and developed test cases
. Preparing test plans and data requests for the various kinds of testing;
System, Functional and Regression.
. Creating and executing test cases using Quality Center and MS Excel for
end-to-end testing.
. Exposure of testing applications on wide range of Mobile handset of
different vendors which includes Motorola, HTC, Apple, Blackberry, Windows
Mobile, LG, Samsung and many more.
. Good understanding of working on the applications developed for touch
screen phones.
. In Depth knowledge and experience in Testing Banking applications modules
including Account Balances, Cross Account Transfers, Bill Pay and GPS
locations
. Worked on Android 2.2 and verified multiple mobile browser based
applications including Map, Geocoding and Location based services.
. Tested the applications secure sessions, view check images features,
emails, calendars and active alerts.
. Tested GUI and functionality of the application under test using multiple
browsers such as Netscape Navigator, Microsoft Explorer, Safari, and
Mozilla on multi platforms and interpreted the positive and negative
results.
. Validated data exception and system error log files by executing Unix
commands.
. Used SQL Queries like Joins, Select, Update, Drop, and Append to
manipulate the database.
. Troubleshooting issues with Testing Environment.
. Using tools like device anywhere to test applications on different cell
phone and carriers providers and Bugzilla for reporting the bugs.
. Training and mentoring co-workers, and sharing knowledge as a subject-
matter expert.
AT&T, Alpharetta, Georgia May 2009- Aug
2009
Project Description:
AT&T is one of the nation's leading communication service providers. It
also plays a major role in the local telephone industry. Detailed
information about billing, services, new features, company information, due
dates, minutes used, and payment information, are provided to each
customer. Customer Online Billing System (COBS) is a web based application
running on oracle database. It is used to generate customer bills based on
their billing cycle date, retrieve billing history, view customer
transactions etc., which will be published on internet for online viewing
by the customers. The system also generates comprehensive reports of
revenue generation for each region, market and for each product like Long
distance, DIA/DSL etc., for internal sales planning. The Carrier Access
Billing System(CABS) is used to bill customers for accessing the
AT&T network. AT&T utilizes either the Customer Records Information System
(CRIS) or the
Carrier Access Billing System (CABS) to bill AT&T's own customers and the
Competitive Local Exchange Carriers (CLECs) as customers in the same
manner.
Role: QA Analyst
Key Responsibilities:
. Requirement Analysis, Test planning, Test Scheduling and Test
Execution.
. Developed test cases and manually tested the functionality of the
application where required
. Test Activities includes documenting Test scripts from Test Scenarios
in the Quality Center test case repository.
. Test Activities included Smoke Testing, Integration Testing,
Regression Testing, GUI Testing, Compatibility Testing, Database
Testing and Ad-hoc testing.
. Involved in executing automated scripts using Quick Test
Professional.
. Extensively used SQL queries to check the Order flows.
. Developed Requirement Traceability Matrix.
. Evaluate and Report Test Results & reported the overall progress
periodically to the Project Management.
. Master Test Plan preparation.
. Executed SQL scripts/queries using SQL developer tool for data
verification to compare the expected results with database.
. Configuration Manager to manage the project documentation in
compliance with CMM Level5.
. Test case execution and Defect management using QC.
. Interaction with the development team in resolving the defects.
. Conducting review of test deliverables.
. Organizing Defect Triages with Development and related vendors.
. Daily Status Reporting to client that includes cumulative Test and Bug
Metrics.
. UAT support.
Verizon, Colorado Springs, Colorado
Jul 2008- Apr 2009
Project Description:
The CALNET project (California Integrated Information Network 2) enables
the State of California Department of General Services Telecommunications
Division (DGS/TD) to transition their existing CALNET I project over to
the new Verizon Business solution, which will be similar to the Verizon
Enterprise Center (VEC). The CALNET II contract is a multi module
proposal for which a vendor may reply to one or more of the modules.
(Module 1- Local based service, Module 2- LD, Module 3- IP based
services, and Module 4- Wireless services).OBJECTIVE being CALNET II
Portal- full function Ordering, Billing, Inventory, Reporting, Pricing
and Rating.The project also involved testing of managed services and
supply chain management services to support the products launched by
Verizon Business.Testing included End to End testing of various products
and services.
Role: QA Analyst
Key Responsibilities:
. Performed Functional, integration, system, and Regression testing at
different stages of the System Testing Life Cycle.
. Requirement Analysis, Designing test strategies and Test plans and
Test Estimation.
. End to end Test execution, Defect tracking and Validate requirements
coverage.
. Coordinating with the Development leads, System POCs.
. Weekly Status Report to client
. Execute both Manual and Automated test scripts based on Use cases.
. Developed and modified Unix scripts as per testing requirements.
. Conducted Web Based End to End testing for the entire Subsystem.
. Used Quality center to create the test plan, store test cases.
. Involved on testing the new functionalities based on test cases and
coordinated with development team in fixing the issues.
. Testing environment for Web applications under Firefox, Internet
Explorer, and Chrome.
. Involved in executing automated scripts using Quick Test Professional.
. Used QTP to Test Web Links, Objects, Images and text on Web pages.
. Ensure that all the test cases are updated in the Quality Center along
with Master test plan.
. Performed Regression testing & end-to-end testing of overall application
to ensure end-to-end usability. Front End Functionality & GUI testing.
. Experience in database development and writing SQL statements, stored
procedures and triggers.
. Report defects found during testing cycles and retest fixed in Bug
Tracking System.
AT&T, Dallas, TX
Jul 2005 - Jun 2008
Project Description:
This project handles all System Testing, Performance Testing, Regression
Testing and finally Production Validation Testing for various AT&T online
applications. Given below are the project details.
Online Ordering Application (SWOT)
. The project involved testing of Online ordering flow for telecom
products along with provisioning of these products provided by AT&T.
. Backend Validations as per the requests sent depending up on the BIS
system coordination.
Simplified API (SAPI)
. The objective was to test APIs offered to the PRM client who don't
have infrastructure to support detailed APIs for placing orders for
AT&T products using SAPI tool based on Simple Object Access Protocol.
. The intension of testing was not to communicate directly with the
detailed APIs like in SAFE, but to communicate with the SAPI wrapper
which in turn communicates with detailed APIs.
Light Speed R3
. Light speed being AT&T's initiative, the aim was to overcome the
triple threat offer of High Speed Internet Access (HSIA), IP
Television (IPTV) and VoIP.
. LS was supposed to deploy fiber optics closer to the customer and
build an advanced, IP-based (Internet Protocol) network capable of
delivering a rich array of integrated next-generation television, data
and voice services substantially beyond what is available from as
usual telephone, cable or satellite TV providers.
Role: QA Analyst
Key Responsibilities:
. Requirement Analysis, Test planning, Test Scheduling and tracking
. System and E2E Test Case Preparation.
. Batch job execution and validation of results
. Test case execution and Defect management
. Conducting review of test deliverables
. Interaction with the development team in resolving the defects
. Defect Management
. Batch job execution and validation of results
. Weekly Status Report to client
. UAT Support
Contact this candidate