Tripti Karmokar
**********@*****.***
Career Summary
Ten years of progressive experience in Quality Assurance and Software testing with analytical skills and experience of Rate of Returns, Insurance claims and Projects.
Diversify experience on large scale projects within Trading, Banking, Government, Insurance and Telecom domains.
Extensive experience in developing Test Plans, Test Cases, Test Scripts, Test Matrix and Status Reports.
Experience in Manual and Automated testing with various kinds of testing tools like HP ALM, Quality Center, Quick Test Pro (QTP), JIRA, Rational Test Manager, Rational Clear Quest, Compuware QA Hiperstation and Compuware Test Partner.
Used SQL on different database like Oracle, SQL server,VB2, Sybase.
Worked on different mainframe like AS400, INFO, KICK, SPRING.
Possess excellent communication with all levels of the team within an organization, with excellent interpersonal, written and oral communication skills.
Education
Masters Degree of Commerce (Finance), Graduated in 2005
Veer Narmad South Gujarat University, Gujarat, India
Bachelor Degree of Commerce, Graduated in 2003
Veer Narmad South Gujarat University, Gujarat, India
Certified in Software Testing.
Professional Experience
KPMG Asset Management, Toronto, ON
QA Analyst/Tester
Apr 2014 to Present
The Asset Management system was created to align a strategic modelling of asset classes within client portfolios. The model by asset class enhance the ability of investment advisors to perform asset allocations, dividing client’s investment portfolio into various asset classes like stocks, bonds and money market securities, and establish key strategies to obtained minimize risk and potentially maximise gains. The modelling by asset class capability was merged with the core asset allocation strategies like Strategic, Constant Weighting, Tactical, Dynamic, Insured and Integrated Asset Allocation
Highlights of Accomplishments:
Created test scripts/cases and performed manual and automated testing of the application.
Described input/output sources including detail plan for system design phase and obtained approval of system proposal.
Attended several walkthrough meetings with the Business Analysts, Project Manager and developers and provided feedback accordingly.
Developed and executed tests on different applications of the system.
Prioritized and tested important functions as per the user needs.
Recorded, parameterized and updated user scripts to maintain the critical business transactions.
Prepared Automation test scripts for Regression testing of the application.
Developed Data Driven Tests to validate the same situation with different Test Data.
Executed Web Testing to verify the broken Links in the Web Page.
Prepared test plans, used cases and regression test suites pertaining to data, interface, usability, and security for the web-enabled server-based application in order to improve the quality of deliverables
Produced bug reports and responsible to ensure that problems detected were fixed and verified.
Worked on various UNIX servers and database to validate the logs and outputs.
Modified UNIX SHELL Scripts and SQL/PL SQL Scripts and performed in UNIX Environment.
Worked with Risk Methodologies team throughout the project to ensure that all functional and non-functional requirements are met.
Accompanied review meetings and produced the test cases by making necessary changes to it.
Environment: ALM, UNIX, Java, J2EE, Html, SQL Server, TOAD, QTP.
Prudential Financials Canada, Toronto, ON
QA Analyst (PeopleSoft)
Feb 2013 to Mar 2014
Prudential Finance offers variety of funds including mutual funds, annuities, asset management, securities brokerage, banking and trust services and real estate brokerage franchises. Prudential Finance has developed its Financial Data warehouse. I was involved in this project to create and execute Test Plan and Test Scripts. After preparing Test Plans and scripts I have performed tests for PeopleSoft Financial Data warehouse with Essential data load (ETL).
Highlights of Accomplishments:
Prepared test cases with supported requirement documents and design specifications.
Created test case scenarios and prepare test scripts in HP Quality Center.
Engaged in complete Test Life-Cycle from analyzing Business Requirements to preparing Test Plans, Test Cases, and execution of Test Scripts and deployment of PeopleSoft Financial Modules such as General Ledger, Asset Management, Billing, Accounts Receivable, and Accounts Payable.
Developed test scripts for Credit Management Business Stream and also involved in testing its various modules.
Wrote SQL queries to extract data from PeopleSoft HRMS Payroll.
Reviewed the Functional activities of the Business Stream and Interfaces.
Prepared the Test Cases respectively for each Business Stream.
Created and executed automated test scripts using HP Interactive Tools.
Filed problem detected during system test and created status/Defect reports.
Performed Functional, Integration, Regression & Configuration Testing.
Extensively performed Performance Testing for Stress/Load on the system.
Managed defects through testing process including validation of the fix.
Environment: Oracle, People soft Finance, PeopleSoft HRMS Pay Roll, Application Designer, SQL, People code, BEA Web Logic, Sun-Solaris, MS Visio, Windows, TIMS, MS Project, Load Runner, QTP, and Quality Center.
Pennsylvania Department of Transportation (PennDOT), PA
Quality Assurance Test Analyst
Aug 2011 to Nov 2012
Pennsylvania Department of Transportation has implemented a five-year project plan (.centric) to redesign the Safety Administrations Driver Licensing and Motor Vehicle Computer Systems by replacing the existing Safety Administration Legacy System i.e., the order processing and Inventory Control Systems (TOPICS). The project .centric enhances and presented the way the Business Partners and Customers perform business with PennDOT.. centric was implemented in different phases for Drivers Licensing system, Motor Vehicles and Sanctioning.
Highlights of Accomplishments:
Involved in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
Participated in the creation of Test Plan and execution of test cases for Entity Administration, Inventory Management, Financial Administration and EDMS (Electronic Data Management System) modules based on SRS and DSD.
Involved in System Testing and User Acceptance Testing (UAT) of .centric application.
Created test plan for Identity Manager and executed Test Cases in Test Lab for Security purpose.
Developed and modified the Test Scripts with the help of requirements and use cases provided by Business personnel.
Analyzed, documented and maintained Test Results and Test Logs in Clear Quest for defect tracking purposes.
Automated major functionalities using QTP and set up as regression suite.
Wrote SQL Queries to extract data from the Oracle database using Toad.
Attend team meetings to discuss the post execution issues of Test Scenarios.
Interacted with developers for status of the bugs and re-tested the fixed Bugs.
Executed Batches and Reports using Business Objects Server.
Obtained Log Files for defects using Web Sphere Application Server.
Participated with Clients for UAT Testing of the Test Scenarios.
Maintained and updated Test metrics on build basis along with defects summary.
Conducted Regression Testing using Quick Test Professional for each build and release.
Involved in the documentation of the System and User Acceptance Testing test closer reports.
Environment: Quality Center, Clear Quest, JSP, J2EE, Java Script, .Net, SQL, Oracle, TOAD, MS Office, WAS Server, Business Objects, Requisite Pro, QTP
US Bank, Dallas, TX
Tester/Analyst
Nov 2010 to Jul 2011
Worked with U.S. Bank on multiple applications like Spans, Portal, Info Lease, Rate Tool, PCGIT and Remote Upload. SPANS (U.S. Bank Securities Processing Automated Note System) is an Online secure Internet-based system, meets all money market instruments processing needs whether issuing Cheques, Commercial Paper, Medium Term Notes (MTN's), Banker's Acceptances (BA's) or Certificates of deposit (CD's). U.S. Bank SPANS Online can provide balance information, transaction details and analysis tools without maintaining special software or a dedicated computer. The system is very user friendly, used to remote or send trade data and provide customize reports to meet customers requirements. Portal is a web application it has various logins and each login is dealt with different services like Vendor is for equipment manufacturers and equipment distributors, Bolt is for office equipment finance, Health care is providing convenient and competitive financing solutions for the medical and dental industries, Banker is for leasing, Manifest is for financing equipment through a network of independent finance brokers. Remote Upload is a web application, Rate Tool is an Intranet application and Info Lease is a Mainframe Application.
Highlights of Accomplishments:
Involved in preparing automated test scripts, fixed issues and documented reports for it.
Worked on Mainframe, Client/Server and Web Applications to create test scripts.
Executed GUI interface testing at client side using QTP.
Extensively performed Regression Testing using QTP.
Used Data Driven Wizard to test the functionality of the Application multiple times with multiple Data (positive as well as Negative).
Performed Build Verification, Integration, System, Performance/Load & User Acceptance testing.
Analyze the Changes, severity, tracking system and reporting in Quality Center.
Developing and executing test scenarios to support requirements validation, application testing, integration testing and user acceptance testing (UAT).
Created and maintained the test scripts as per changes in the requirements during the project life cycle.
Environment: QTP, Web Services, Load Runner, Quality Center, Oracle, SQL server, MS Access, UNIX, HTML, XML, Java++, Servlets, CORBA, Applets, Java Scripts and Visual Basic.
ING Insurance, Dallas, TX
QA Test Analyst
Feb 2009 to Oct 2010
Worked as a QA Test Analyst and involved in Functional & System testing of the Web Application. ING Direct deals with Life and Auto Insurance. ING Claim is workflow-based claims management system that enhances and redesigns the claim management that centred to work and significantly facilitate to provide reliable service at a minimum cost. The system was also improvising to help and organise Case Managers day to day work load assessment and prioritized related activities.
Highlights of Accomplishments:
Developed Smoke tests, Integration tests, System tests and User Acceptance tests.
Analysed bug reviews and participated client meetings.
Participated and executed black box testing for the products.
Documented Test Plans, Test Methodology and Test cases as per Functional and Business requirements for System, Integration, Stress/Performance and Regression testing.
Participated in the process of design and developed various test documents that followed the test procedures of IEEE standard.
Involved in full life cycle of QA, assisted the management from development to perform System Integration Testing (SIT), User Acceptance Testing (UAT) and deployment of releases.
Modified Test Scripts for Customized objects in the Application for verification of subsequent builds in the application.
Performed GUI functionality testing of the application to ensure end users specifications.
Verified the functionality of Secured Socket Layers and ensuring the Security of valuable information of Online Customers.
Have used calculations, equations and mathematical software while working on test cases.
Environment: QTP, Quality Center, Jira, Load Runner, IBM Filenet, Microsoft Visual Basic, SQL Server, IE
Allstate Insurance, Dallas, TX
QA Tester
Sep 2007 to Jan 2009
MAI application helps to get the online Quote & Purchase for Auto & Property Insurance in different provinces of United States. It also assist the customer to get the Quick / Full Quotes/New Business for Auto & Property (Home owners, Renters, Condominiums) Insurance with all details of the Driver's history and Vehicle history. It also manages the customer care claims. It helps to interact directly or mutually with Customers, Agents and Call center and worked as complete online e-transaction application.
Highlights of Accomplishments:
Participated in all stages of testing for the applications.
Responsible for testing the functionalities of Quote & Purchase for both Auto and Property Insurance, which compares with the Allstate premium.
Executed Regression & Integration Testing and responsible for interacting with developers to fix the problems especially pertaining to database which are not populated to the online screen when Customer enters his Quote such as Discounts, Models of Vehicles etc.
Participated in Testing data movement from traditional database to Legacy Systems (Mainframe & AS400)
Tested the applications in SIT, Business and Production environments, during different test phases.
Developed and obtained the Test data using Visual Source Safe.
Prepared Manual Test scripts and responsible to track and log the defects in Quality Center.
Tested the validity of the Quote Premiums and Purchase Premiums while comparing the entered Quotes and Purchases with Allstate Data.
Generated automated test scripts using QTP.
Created TSL scripts using QTP with Library functions, Data Driven functions to perform Regression Testing.
Participated in testing the Property & Casualty application, which delivers the online Auto Insurance information related to the accidents.
Performed the Quotes and Purchases operations from the Database by entering PL/SQL Queries
Conducted the Load, Stress and Performance testing using Load Runner.
Determined application performance and maximum scalability, critical parameter such as number of users, response times, hits per seconds and through put using Load Runner.
Participated in User Acceptance Testing (UAT).
Performed tests by creating 100, 200, 400 virtual users for load, volume and performance test respectively and Performance Monitor was used to monitor and analyze the performance of the server by producing several reports for CPU utilization, Memory Usage etc.
Have used calculations, equations and mathematical software while working on test cases.
Environment: Visual Basic, DB2, SQL Server, PL/SQL, XML, MVS, AS/400, Visual Source Safe, QTP, Quality Center, Load Runner, JCL.
AT&T, Dallas, TX
QA Analyst/Tester
Feb 2006 – Aug 2007
Worked with Amdocs IAF Horizon, which provides complete billing, customer-care and service-management solution. IAF is related to Customer care module, Self-Care, Reporting, Auto Registration, Configuration, Product console and Data Management modules. It help to Create and Maintain Accounts like BAN and SUB,, Handle Tunnels, Manage IP Addresses, View Billing and Usage information, Manage Users, Manage Account Administrators, Manage Receivables and Generate Reports.
BAN numbers are provided in ranges and when it gets exhausted, a new BAN range must be obtained. Expanding the length of the BAN sequence extends the pool of available TLG BAN ranges beyond the projected exhaustion date and provides a long-term solution to BAN sequence limitations. The suggested solution is to increase the BAN and CUSTOMER_ID field lengths from nine to 12 digits.
Highlights of Accomplishments:
Participated in documenting test plans and test cases for Amdocs CSM, POS based on Business Requirements using Quality Center.
Involved in validating BAN activities like activation, future activation, suspension, disconnection, cancellation for both sale and rental equipments.
Checked/reviewed the test case documents.
Provided status reports to client on weekly basis.
Created Test Sets in Quality Center, mapped test cases to the test sets, executed the test cases, reported and tracked defects using Quality Center.
Created and documented Test Calendars and prepare Test Plans, Test Cases and Test Scripts.
Used Telegence (CSM online) for activating Subscribers and ensure the movement of subscribers to Enabler successfully.
Worked on Online modules i.e. CSM, Billing, Price plan, Resource Management and Order Management system.
Worked on CORBA interface between IAF and eHelp Desk system.
Participated in testing of MAF, MPS, and Wireless Number portability.
Performed System Testing, Unit Testing, Functional Testing, UAT Testing and Regression Testing.
Tracked the Account changes before provision and after provision using TOAD.
Performed billing and customer profile process thoroughly and file sent over to TLG for processing.
Environment: SQL Plus, Oracle, MS SQL Server, Clarify, WebLogic Server, Sybase, DB2, Quality Center, CORBA, QTP, Perl, Java, Unix Script, ASP, C, C++, Windows NT, MS Office, Web Services, J2EE, Servlets and JSP