Manager Test Cases
Resume:
Amarnath Tripathy
QA Lead Consultant
Email ID: - ********.********@*****.***
Cell: 781-***-****
13+ Years of experience in IT
Professional Summary
Over 13+ years of Software Testing and Quality assurance of Client/Server and Web based applications using Quality Center,ALM, UFT, TAF, Mainframe, SunGard products as Investran Accounting.
Proficient experience in Manual and Automated Testing of GUI and functional aspects of the Client-Server and Web based Applications on multiple levels of SDLC and Testing Life Cycle (STLC).
Strong domain experience in Investment Banking, Mutual Fund, Securities, Custody, Money Market, Capital Market, Oil and Gas and Retail.
Worked on Cross Browser testing and have good expertise in testing applications in Internet Explorer, Google Chrome and Mozilla Firefox browser.
Experience in writing use case, test cases, and automated scripts & designing Test procedures, Test plan, and Test strategy.
Experience in the ETL testing (Extract, Transform and Load) of data into a data warehouse/data mart.
Performed Testing Life Cycle during the various phases of the application. Involved in converting manual test cases into automated scripts using UFT and TAF.
Good exposer in Business Analyst day by day activities- helping businesses implement technology solutions in a cost-effective way by determining the requirements of a project or program and communicating them clearly to stakeholders.
Involved in requirement gathering phase, collect requirements information from SME and design BRD, FRD with other BA’s.
Experience in analyzing Functional Requirement Specifications (FRS) and conversant with System Design Specifications (SDS).
Experience in designing and developing SQL statements and queries in SQL Server 2008 database.
Experience in working Web Services testing-SOAP UI.
Extensively used Quality Center, MTM and TAF to write Test Cases and for reporting.
Extensively uploaded test cases from MS Excel, MS Word to Quality Center and MTM and preparing Quality feedback to QA team & manager.
Strong knowledge of Finance solutions/Security and Oil and Gas domain with emphasis on Business Requirements and Functional Requirements.
Specialized in Test Planning, Analysis of SRS, Functional, Regression and Interrogation testing, responsible for implementing the organizations Automation strategy and framework, Risk Identification & Mitigation Plan, Goal setting and team problem solving in Agile process.
Proficient in Testing methodologies, Test Matrices and Trace matrix.
Extensive experience in Functional testing, Integration testing, Regression testing, GUI testing, Back-end testing, Browser Compatibility testing, Ad-hoc testing, Black Box Testing, System Testing, Build Verification Testing, User Acceptance Testing, Data migration testing and Data base testing.
Experience in Bug Tracking System and Process.
Experience in working mainframe system architecture applications in support of accounting, derivatives processing and securities valuation processes. - Mainframe testing.
Working Experience in various SWIFT message MT541, MT542, MT543 used for securities settlement across different asset like equities, fixed income.
Experience in managing Team of size-13+ in Offshore/Onshore models.
Experience in Agile process and Participation in daily agile standups, kick up meetings, test case designs, iteration planning, product demos and application walkthroughs.
Expertise in software development model such as Agile, Waterfall and Iterative.
Good knowledge of Microsoft Sharepoint.
Experience in preparing Project Estimates, Quality Metrics, ROI (Return on Investment) and define the strategy to drive the projects.
Strong expertise in Test estimation. Good knowledge of Delphi technique, Three Point technique and WBS technique
Proficient in Defect management, including Defect creation, reporting, modification and tracking using Quality Center (ALM)
Experience in defect tracking tools such as HP ALM (QC) and Bugzilla.
Good Knowledge in writing complex SQL queries and managing data in database tables
Good expertise in working with large team as well as small size teams, working in aggressive timelines, working in Multiple teams in Waterfall and Agile model.
As a QA lead, I supported Performance testing, Load testing and Stress testing
Involved in Formal Code reviews, Peer Review and Walkthroughs
Multitasking, Proactive, Motivated and Quick Learner
Education
Bachelors of Engineering- (Electronics & Inst.) from Utkal University, GHITM Puri- India.
(First class)
Technical Skills
Area
Software
Test Management Tools
Quality Centre (12.21), MTM (Microsoft Test Manager), SOAP UI 5.1, UFT 12.5, ALM (12.53)
Configuration Tool
TFS (Team Foundation Server), RTC
Database
Oracle, DB2, SQL Server 2008, SSIS package
Documentation Tools
MS-Office, MS Visio, MS Project.
Operating Systems
IE11, Chrome, Windows 7.
Project Experience
Feb 2017 to Present
Domain: Banking and Investment
Client name: World Bank Group
Role: QA Lead
Organization: RIVI Consulting Group
Location: Washington, DC
Responsibilities:
QA Lead
The World Bank Group is an international financial institution that provides loans to countries of the world for capital projects.
As a QA Lead worked on BEM/Investran Projects. The Business Event Manager (BEM) is a centralized web-based Workflow Manager that supports IFC equity-based accounting transactions. BEM associates a business event with an equity transaction, facilitates processing of the transaction using the straight-through-process (STP), and posts the related accounting entry to the Investran General Ledger (GL). The system ensures front office equity trade transactions entered by the Investment Officers (IO) automatically flow to Investran seamlessly, are processed correctly and the respective accounting entries are posted to the Investran general ledger accurately. This project focuses on upgrading the current BEM/Investran application to the latest release of Investran (7.0). This upgrade will ensure IFC continues to be received maintenance and support from the Investran vendor, SunGard.
The Investment groups tracked in BEM/Investran include:
a.Equity
b.Accounting Special Ledger (ASL)
c.Third Party Funds (TPF)
d.Pension Funds
Responsibilities:
Drive the completion and complete alignment of system design from business requirements and architectural design.
Track, drive and coordinate program development activities, per requirements and design, with Business owners, PO, and IT Development teams across US and India.
Document and analyze business requirements, functional requirements, system capabilities, and detailed design.
Developed and maintain test scenarios, cases and plans for Accounting and valuation applications.
Coordinate preparation of Test plan/design/ document, test-suite and user documentation. Define the Strategy.
Liaison between the Client and Testing teams
Coordinating defect triage meeting.
Test data creation and Test environment setup & maintenance.
Test execution of the test cases
Collecting Test Metrics from ALM, Analyzing and Reporting them to Management team
Creation of Defect status and Test execution status report on Daily and Monthly basis for multiple modules and systems.
Participated in preparing SSIS script for Data migration testing. Prepared report by using Investran tool and compared the data.
Verifying Test environment readiness
Creation of Test summary reports for current and past production releases
Creation of Defect trending graphs on Weekly basis
Creation of Oversight reports for multiple modules and systems
Helping the testing team in the issues that may arise during test process: infrastructure, data, user privileges for test apps, etc.
Involved in Data Migration Testing and Database testing with other stack holders.
Validate Big data and recon between Source and Target.
Meeting with Client to keep aligned and update the daily work
Creation of Test Closure report for production releases.
Providing Post production test support for production defect fixes
Creation of Test Closure and Lessons learnt documentation
Technical Skills and Tools used in the Project
Area
Software
Test Management Tools
UFT 12.5, ALM (12.53), Investran (Sun Gard tool)
Language
VBScript
Database
SQL Server 2008, SSIS package
Operating Systems
IE11, Chrome, Windows 7
May 2015 to Jan 2017
Client: State Street Bank, Quincy, USA
Domain: Capital Market, Money market, Securities, Custody and Mutual Fund.
Organization: Wipro Ltd(US)
Role: QA Lead
The State Street Corporation, known as State Street, is an American worldwide financial service holding company. They are committed to provide financial security solution to the customer.
As a QA Lead Worked on the Mark to Market process within the company to update a portfolio’s asset and liability accounts by comparing the current market value of the account to the cost. Involved in validating how the assets are performing in the current market. The Marks to Market (MTM) system automatically calculates and posts the appreciation/depreciation to the general ledger.
Also worked for State Street Gold Copy Team on the GTM FSCO and ETD processing. GTM FSCO is a transaction processing system designed to improve State Street’s internal straight-through processing capability.
ETD application is used for processing the transaction messages from the external application and transmits to the ETD system. MCH application receives the message elements and performs the transaction based on the message noted processes only the inbound messages and user verify outbound message.
Responsibilities:
Participating in meetings such as Release Planning, Iteration Planning, Retrospective, Backlog grooming, Preplanning, Daily standup Call, etc. Play effective role as SQA in story sizing.
Test scenarios, Test Cases, Test Scripts Creation, Test data setup for Manual test execution, Manual test execution, tracking defects discovered during Test execution, providing SQA signoff for passed user stories
Scheduling Nightly Batch run for Test cycle using task scheduler
Worked on Cross Browser testing and have good expertise in testing applications in Google Chrome, Mozilla Firefox and Internet Explorer browser
Worked on generating various admin reports in ALM using SQL queries
Meeting with Client to keep aligned and update the daily work
Developed reusable Generic and Application functions using VB script. These functions can be used anywhere in the test scripts
Writing complex SQL queries to retrieve the data from multiple tables using JOINs and combination of multiple input conditions
Worked on frameworks such as Keyword driven, Hybrid, Modular, etc
Liaison between the Client and Testing teams
Creation of the test data by retrieving the DB records using SQL queries
Test data validation of the Input data in Web application against the DB2 tables using Mainframe system’s QMF
Participates in Develop automation script with Offshore Team by using UFT.
In data driven frameworks for each Use Cases (functionality) written in Descriptive Programming.
Executing the test scripts in UFT and ALM. Developed test scripts and function libraries using VBScripts
Run automation script in the time of Production Release, End to End testing and as per client requirement.
Proactively identify and resolve issues by working with all portfolio teams.
Run daily functional, Regression test suits and analyze results, report defects, application outage and environment issues to project teams as they are identified.
Test data validation of the input data in Web services text input files against the Oracle DB tables using SQL Query Manager
Feasibility study for the regression Test Cases to identify which test cases can be automated.
Logging and tracking tasks in Rational Team Concert (RTC) tool and keeping it updated on day to day basis.
Presenting Functional Demo to Product owner(PO) on Passed user stories for every iteration
Co-coordinating with Team on daily basis to track status of tasks and providing required support
Daily and Weekly status reporting to the Client in timely manner and regularly attending daily standup call with the vendor development and client business teams to provide the status and get resolved any outstanding issues
Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects.
Managed Scope and change throughout the SDLC process of the product.
Manually tested the whole application before going for the automated testing.
Identifying the required Add-in for the application and ROI analysis before starting scripting
Creation of Weekly Status Report, Monthly status report and SQA Signoff documents
Technical Skills and Tools used in the Project
Area
Software
Test Management Tools
UFT 12.5, ALM (12.53), IBM RTC,TAF
Language
Java, HTML, XML
Database
SQL Server 2008, IBM DB2
Operating Systems
Windows XP, Windows 7, Mainframe (TSO and MCH)
July 2009- April 2015
Client: Halliburton
Domain: Oil and Gas
Organization: SAIC India Pvt Ltd-India (Wipro Technologies)
Role: QA Lead
The Halliburton is one of the world's largest providers of products and services to the energy industry.
As a QA lead worked on Well Sight Express (WSE) software which is utilized to manage the technical information captured from the Fluid Services operations and produce reports in Adobe Acrobat and Microsoft Office applications. Also communicate with different Aroid applications and transfer data via internet for ground level drilling.
The Well Sight Analyzer (WSA) is a drilling and well services query generator and export in a prescribed report formats for analysis. It is designed to provide unlimited ad-hoc query capability to the Well Sight database.
Responsibilities:
Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases.
Throughout the project, was involved in giving clarifications on domain and product functionality for the team.
Regular interaction with the core developers helped us in fixing the defects in less time.
Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts for WSA.
Conducted GUI and functionality testing using UFT.
Conduct QA testing of ETL data transformation and data warehouse for reporting solutions
Conducted data driven testing using UFT to conduct backend testing.
Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects.
Worked with ETL team during the upload process.
Involved in full life cycle of Business Objects reporting Application.
Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
Used SQL to test various reports and ETL load jobs in development, QA and production environment
Established traceability matrix to trace completeness of requirements in different SDLC stages.
Involved in Configured the Data mapping between Oracle and SQL Server 2005.
Automated confidence tests that run on new builds on regular basis.
Involved in setting up different configuration environment for compatibility testing and manual testing.
Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
Created test scripts for all the test cases in PL/SQL.
Analysis Use-Case diagrams and State diagrams using MS Visio.
Preparing Weekly action report & QA feedback to QA team & Manager.
Understand the testing effort by analyzing the requirements of project.
Estimate and obtain management support for the time, resources and budget required to perform the testing.
Prepare Resource Loading Sheet (RSL).
Organize the testing kick-off meeting.
Log effort and defect data.
Coordinate preparation of test plan/design/ document, test-suite and user documentation.
Define the Strategy.
Build a testing team of professionals with appropriate skills, attitudes and motivation.
Track and prepare the report of testing activities like test testing results, test case coverage, required resources, defects discovered and their status, performance baselines etc.
Also Experience in SOAP UI tool for Web service testing for WSE Baroid applications.
Technical Skills and Tools used in the Project
Area
Software
Test Management Tools
QC (10.8), TFS and MTM
Language
Sun Java, MSJVM, XML
Database
Oracle 8i/9i, SQL Server 2005, Informatic (Data processing)
Operating Systems
Windows XP, Windows 7
Jan 2007- June 2009
Client: Halliburton
Domain: Oil and Gas
Organization: Scicom Technologies-India (Wipro Technologies)
Role: Principal Test Engineer
The Halliburton is one of the world's largest providers of products and services to the energy industry.
As a QA worked on HIPS-Summit project which is a products and services to upstream oil and gas customers worldwide, like Logging, Security DBS Drill Bits,
Sperry Drilling Services, Cementing, Product Optimization, Tools and Testing, Completion Products and Services etc.
HIPS-Summit is a package consisting of a HIPS (Halliburton Integrated Proposal System) module and 7 PSLs like
Cementing, Logging, Tools and Testing, Security Drill Bit system, Product Enhancement, Completion Products
Testing and Completion Products and Services.
Responsibilities:
Performing black box, GUI, validation, integration, regression, acceptance, usability, compatibility, install/uninstall testing, Data Base Testing.
Logging errors in the Bug Tracking Tool- Quality Centre 9.2
Client Interaction in weekly Net-Meetings.
Daily reporting to client.
Tested and worked with software designers to establish a user-friendly environment.
Making sure the software is error free and solving problems.
Developed test cases, test design documents and quality test plans.
Checking and evaluating software at system, module, unit, requirements, and specifications level.
Documenting and evaluating software tests and results.
Identifying, analyzing and tracking defects and problems.
Investigating technical problems to determine root cause.
Designed and implemented SQL queries for QA testing.
Technical Skills and Tools used in the Project
Area
Software
Test Management Tools
QC (9.2)
Language
VB.NET
Database
SQL Server 2005
Operating Systems
Windows XP
Jun 2006- Nov 2006
Client: ML Network Pvt Ltd.
Organization: Zippy InfoTeck Pvt Ltd-India
Role: Test Engineer
ML Network Appraisal & monitoring Application is an application based on Network Marketing concept. Through this Application ML is able to manage its Network market effectively. Broadly this application stands on three parts: BP’s, Academy and Program. The Product are sold through BP’s by means of which they earn some points Called ML Points, this is the base of the application.
Responsibilities:
As a Sr. Test Engineer
Reviewed requirements together with QA Manager & Business Analyst
Facilitated four-hour long round table discussion with most managers and analysts along with QA manager to get their input [ad-hoc UAT] in the project
Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
Prepared Use cases and Activity flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO 2003.
Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
Performed White Box, Black Box, and Usability Testing
Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
Executing test cases, Bug logging in bug tracking System, Functional testing, Regression testing and Bug verification. Maintain the daily status report of testing, Discussion with development through mails.
Identifying, analyzing and tracking defects and problems.
Investigating technical problems to determine root cause.
At the end of the project period, a few defects with open status were sent back to the developers through Manager and BA.
Environment: Quality Centre 8.2, SQL Server 2005
Oct 2004- May2006
Client: Exton Online
Organization: Zippy InfoTeck Pvt Ltd-India
Role: Test Engineer
Exton Online Business System project aims at developments of a web based application that take Care of complete business at Exton online Including enquiry, ordering, and dealer Interaction, billing Transportation, and insurance. This will facilitate the Customers to enquire online about the Exton products that will be passed to concern for further Communication With the customers. It helps the dealer in online booking of the product, getting payment Information about their Payments, credit notes, debt notes, invoices. This project also has the facility for the four regional offices to raise bill Discount them with the back and finally collect payments from the dealer. In brief it aims at providing the complete Automation of the business.
Responsibilities:
As a Test Engineer
Reviewed requirements together with QA Manager & Business Analyst
Facilitated four-hour long round table discussion with most managers and analysts along with QA manager to get their input [ad-hoc UAT] in the project
Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
Prepared Use cases and Activity flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO 2003.
Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
Performed White Box, Black Box, and Usability Testing.
Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
Executing test cases, Bug logging in bug tracking System, Functional testing, Regression testing and Bug verification. Maintain the daily status report of testing, Discussion with development through mails.
Identifying, analyzing and tracking defects and problems.
Investigating technical problems to determine root cause.
Environment: Quality Centre 8.2, SQL Server 2005
Contact this candidate