Sr Quality Analyst Resume
Cincinnati, OH
SUMMARY
- A result oriented individual with over 6 years of diversified experience in Quality Assurance and Software testing in Financial Services, Banking, Mortgage and Investment Services and Information Technology.
- Has good understanding of quality assurance testing methodology as per Software Development Lifecycle (SDLC).
- Experience in Back office and Middle office in Trading applications.
- Expertise in Manual Testing as well as testing done by using automated tools. Extensive working knowledge and experience in Functionality, System, Integration, Security, Browser Compatibility, Data driven, Regression and User Acceptance Testing (UAT). Expertise in Performance, Load, and Stress testing by using Load Runner. Familiar with Unit Testing such as Ruby testing. Also have experience on Pipeline testing and Selenium testing.
- Extensive experience in Manual and Automated testing using Mercury Interactive Tools like WinRunner, QTP, Load Runner, Performace Center, QA Load and Rational Tools like the Rational TeamTest.
- Develop test cases based on business requirements, functional and technical specifications, and development standards for assigned projects/applications.
- Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.
- Ability to effectively analyze a variety of Performance Reports and Summary Reports, as well as create and send issue reports to project team and management during test cycles.
- Skilled in bug reporting and tracking using Quality Center, Rational Clear Quest.
- Expertise in creating and maintaining the Requirements Traceability matrix(RTM)
- Extensive experience in Backend Testing on distributed databases using SQL queries directly as well as access tools like TOAD.
- Experience with MS Visual Studio, C#, and had hands-on experience with VB scripting, as well as designing GUI and testing web application.
- Experience with Quality Center.
- Excellent managerial, organizational, interpersonal, communication, written and documentation skills, as well as analytical and problem solving skills with ability to handle multiple tasks effectively and quickly master in new concepts and subjects.
- Creative and motivated self-starter with integrative skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments. Proven capability of adapting to new and fast changing technologies as well as new environments.
- Experience on International banking system and transaction with SWIFT codes and messaging system.
- Good knowledge of Financial Analysis (NPV analysis, Stocks/bonds valuation, Real/financial options pricing, and DCF analysis), Corporate Actions Analysis, Root Cause Analysis, Feasibility study and Risk assessment, SWOT analysis and Cost benefit analysis including ROI and Financial Justification.
- Strong understanding in Risk Management, Asset Management, Futures, Options and Derivatives, Fixed Income Assets, Equity, as well as Mutual Funds.
- Extensive knowledge in Risk Analysis like Credit Risk, Market Risk, Business Risk, etc.
- Good understanding of various loan types: - term loans, revolver, and letter of credit (L/C).
- Extensive knowledge in banking system and credit card system, as well as different accounts setups.
- Strong Statistical analysis skills and financial product Pricing experience, as well as investment portfolio management skills such as style and analytics analysis.
SKILL SPECIFICATION
Methodologies: UML, RAD, RUP, JAD, Agile(Scrum), SDLC
Requirement Management Tools: Quality Center, SharePoint
Defect Tracking Tools: Quality Center
Testing Tools: Quick Test Pro, Win Runner, Load Runner, Performance Center
Business Modeling Tools: MS Visio, MS Project
Web/Design Tools: MS Front Page, Adobe Photoshop, MS Visual Studio
Databases: SQL Server, MS Access
Programming Languages: SQL, Visual Basic, VB Scripting, Matlab
Office Tools: MS-Word, Access, Excel, PowerPoint, Outlook, Dropbox, SAS, PeopleSoft
Operating Systems: Win7, Windows NT/XP/2000, Vista, UNIX, LINUX
Data Warehousing Tools: Informatica
Others: Finance, Statistical Tools, Accounting, Futures, Options, Swaptions, GAAP, Fixed Income, Account Receivables, Account Payables, Risk Management, Portfolio Management, Interest Rate Derivatives, SWIFT Message System, International Settlement Documentation
EXPERIENCE
Confidential, Cincinnati, OH Aug 2011 Sep 2012
Sr Quality Analyst
Business Banking Division is one of the major sources of revenue for Fifth Third Bank. Portfolio Risk Advisor is an application which monitors the portfolio of Fifth Third on a daily basis to identify the risk to ensure the high risk accounts are identified and effective actions taken to reduce the losses due to deterioration of credit in the capital market. Bank2Business Data Warehouse is a project to import the data from Bank2Business database to a Fifth third Data Warehouse which is used for scoring by the business. Business uses Business Objects to customize and create reports based on their requirements. They adopted the Agile Model for the project.
- Involved in the meeting with Business process owners, SME (subject matter experts) and Marketing team for Requirements gathering in Definition Stage and also in JAD Sessions.
- Authored Process flow charts and business process documents to define system interactivity. Preparing presentations for senior management to update the status of various activities.
- Provided estimates to the Project Manager on the testing schedule and resources.
- Managed development and traceability of testing scripts and scenarios to business requirements
- Coordinated with Release Manger on scheduling builds to test and staging
- Involved in the portfolio management and investment management department which had experience on FOREX market, specifically in Eurodollar.
- Ensured Offshore QA team has the expertise on application knowledge before starting of testing phase
- Provided reports to management on QA phase of project
- Created automated test scripts using QTP. Had experience on Web Testing using Selenium and also familiar with C# designing.
- Ensured the projects follows the PMO process for quality which ensures the approval of Quality Gate
- Approval and Signoff of all project related documents
- Coordinated with all external teams to ensure a smooth execution phase
- Involved Sprint Planning, Sprint Retrospective meeting and daily stand up meetings.
- Created Test Plan based on the scope and schedule of the project.
- Used SQL to validate data stored and retrieved in the database.
- Wrote complex SQL queries to perform the backend testing of the database.
- Created and added tables to the SQL database when required.
- Defined the Entry/Exit Criteria for the project and ensure these criteria are met
- Reviewed and Analyzed Business Requirement Documents, Functional Specification with System Analysts and Developers.
- Attended Use Case Review and Design Review Meetings and provided feedback.
- Performed Requirement Decomposition to identify High Level Test Scenarios from Specification.
- Assigned and reviewed test cases created by the testing team in Quality Center
- Performed Smoke Test before moving the code to a Stable QA environment.
- Performed Execution of test cases in multiple cycles including Regression
- Triaged and Tracked Defects in Quality Center and sent daily Defect Report to Project Team
- Organized Defect Review Board meeting with Project Team for daily updates on defects during execution
- Experience on Credit Card data validation and transaction protocol data configuration.
- Involved in SWIFT and Bank Application administration and maintenance, specifically on international settlement and banking transaction using SWIFT code system.
- Coordinated with development team to ensure timely delivery of builds for new functionality and defect fixes.
- Coordinated with multiple teams to ensure exclusive access during the various phases of testing.
- Created a Regression Test Suite which can be progressively updated for new release of the application.
- Updated the Test Scripts for Regression build based on the enhancements to the application
- Created and Updated Test Execution Matrix and Defect Matrix.
- Scheduled and coordinated for Performance Testing of the application.
- Involved in GUI designing with MS Visual Studio, as well as web application, web server testing related to MS Visual Studio.
- Experience with the environment with Selenium, QC, QTP, Load Runner, Performance Center, Win Runner, UNIX, LINUX, C++, JAVA, VB Scripting, GUI, UC4, WEB Testing, as well as SQL and MS suite.
Confidential,Rockville, MD Aug 2010 Jul 2011
Quality Analyst
Thomson Financial was merged to Reuters as Thomson Reuters. Thomson Financial operates the business of Market Division which including Sales & Trading, Enterprise, Investment & Advisory, and Media. Thomson Financial has developed an Web site for their existing members to get information from market for different purposes. Registered Members can use their member ID to manage their account for different financial product assessment from the capital market. This Web site has been developed using HTML, and JavaScript. Back End is an Oracle database. As a QA Tester, I performed Manual/Automated Testing for the entire application
- Worked with Business Analysis team to prepare Test strategy and Test plan. Self-managed and self- motivated under Agile methodology and involved in scrum team work.
- Involved in the creation test cases for manual Testing and Automated Testing using QTP and QC. Designed and Scripted in QTP.
- Assist in creation of and ensure proper execution of test specifications, test cases, test scripts in alignment with established methodology and ensure that it supports Testing objectives.
- Conducts application analysis, participates in functional application design.
- Creates and analyzes ad-hoc reports and aids in the escalation/resolution of project risks and issues.
- Write SQL queries to validate that actual test results match expected results.
- Authorized, scheduled, supervised and smoke-tested thin code and data migration from development to test environments. Also in charge of code movement within the 2 test environments. This included new releases, patches, etc. Had to keep environment stable during certain periods for performance testing, UAT, etc needs.
- Experience on validating data based on Credit Card transaction system test.
- Experience on Data-driven testing and web application automation testing using QTP, Load Runner and Selenium as well. Conducted Performance testing and Management in Performance Center .Had extensive knowledge on C#.Net visual designing, as well as designing and scripting in QTP.
- Interacted with Business Analysis team to validate requirements
- Setup, co-ordinate & conduct system & UAT testing with Business Analysts and end-field users
- Interacted with the developers to help resolve critical issues
- Maintained Test Matrix and Requirements Traceability Matrix, Test Data Requirements Matrix
- Set-up, coordinated and performed Usability Testing with the Business Analysts and Business Users
- Reported bugs and enhanced Traceability using Quality Center.
- Generated a variety of Reports using Quality Center.
- Conducted Configuration, System and Integration Testing and User Acceptance Testing.
- Coordinate with the end users in doing the UAT and developed manuals.
- Make presentations to the end client during UAT.
- Worked with the DBA and Network administrators to set up the UAT environment
- Maintained test matrices on various dimensions like performance and test status to reflect test progress.
- Create various scenarios and scripts in Load Runner to get the performance of the application under varied conditions.
- Created Parameterization, Rendezvous, Host and Scheduling Operation (ramp up / ramp down) using Load Runner. Conducted performance testing using Load Runner and managed report and progress tracking with Performance Center.
- IP spoofing for Load Testing in Load Runner.
- Prepare Testing documents to communicate about the status and progress of the Testing efforts with the management team members.
- Submitted weekly status Reports stating the blocking issues of the current build.
- Attended weekly meeting with team leaders, managers and developers to discuss the issues found during the creation of the test case/scripts.
- Meet with the developers and technical content writers on a daily basis to update the test documents.
- Worked with Project Management to scope the Testing effort and provide status and estimates.
- Actively involved in all phases of SDLC.
- Hands-on experience with UI and GUI testing, as well as web application and client server testing.
- Follow up with developers on defects status on a daily basis.
- Published and scheduled Business Objects Reports to users using Scheduler.
- Experience with navigation in UNIX system, familiar with Shell language, as well as reading and understanding the UNIX file system and LINUX.
- Project environment specifically with automation tools such as QTP, Load Runner, and UC4.
Confidential,New York, NY Sep 2009 Aug2010
Quality Analyst
Northwestern Mutual is a financial network, which provides solutions for Personal Planning, Asset and Income Protection, Investment Services, Education Planning, Business Planning, Retirement Planning. It offers insurance products, investment products and advisory services that address client needs for financial security and protection and they are leading provider of Individual Life Insurance.
I was part of the testing team that concerned with billing module for Investment Services. Users would be able to check and monitor their accounts and pay bills online. Also automated Bills were generated for mailing purposes. Functionality and GUI testing was done manually and later by Win Runner. Load and Stress testing was performed using Load Runner.
- Involved in preparing Test Plan and Test Cases based on the functional specifications.
- Worked along with the Project Manager to tackle team and deadline issues.
- Conducted Performance Testing using Load Runner for Web Application.
- Conducted Data Driven Testing using Win Runner to test the application with different sets of data.
- Performed Automated Functional Testing using Win Runner and QTP
- Conducted Load Testing to generate the load on the server by creating Vuser scripts in the Vuser Generator
- Used various techniques like Ramp up, Ramp down, Rendezvous points, Transaction Point.
- Measured server performance under load by creating Rendezvous points to simulate heavy load on the server.
- Conducted result analysis using Online Monitors and Graphs to identify bottlenecks in the server resources using Load Runner.
- Interacted with developing team to resolve technical issues and investigated software faults.
- Conducted GUI Automated Testing using Win Runner
- Extensive knowledge working with UNIX file system as well as SQL Server data mining.
- Conducted Back-End testing of the application by writing complex SQL queries and accessing the Oracle Database from Win Runner
- Conducted Regression Testing for subsequent versions of the application using Load Runner and Win Runner
- Used Quality Center for defect reporting, tracking and documentation.
- Reviewed and updated Test Plan and Test Scenarios.
- Verified fixed defects.
- Performed Smoke Testing.
- Reviewed test results and reports with the team.
- Experience on International settlement and FOREX market, in which transaction involved sterling, and Earodollar.
- Identified and validated protocol transactions related to SWIFT code system, as well as some data-driven testing for SWIFT codes on bond marketing.
- Environment involved manual and automated testing under QTP, Load Runner, and UC4, as well as GUI and web UI.
Confidential,Los Angeles, CA Oct 2008 Aug 2009
Quality Analyst
Bank of America Corporation operates through its banking and non-banking subsidiaries as a provider of financial services and products throughout the United States and in selected international markets. Worked on the online web application which allows the user to access credit card account activity, bill pay, and individual transaction details, download account information, define account nicknames, change contact information and request for statements.
- Assisted the business analysis team in preparing the Functional Specifications document
- Prepared Test Plans and Test Cases based on the business requirements
- Prepared test scripts for automated testing using QTP, designing and scripting with VB scripting in QTP.
- Conducted GUI Testing using QTP
- Performed Functionality Testing using QTP
- Involved in Back End testing using SQL Queries on Oracle Database
- Drafted Test Scripts for Data Driven Testing using QTP to dynamically allow to put different loan parameters
- Undertook Performance Testing using QTP to emulate typical customer transactions to obtain a realistic preview of system performance
- Performed Security Testing in QTP using Positive and Negative Testing to ensure appropriate user authentication
- Refreshing or comparison the Fiscal reports (EDW & UAT).
- Analyzes, develops, tests, and implements segments of automated systems. Recommends and initiates system changes.
- Coded a Macro using VBA editor for sending a report as an attached PDF document every time the report is refreshed.
- Extensive knowledge on Credit Card and settlement processing.
- Colleting Requirements from the IVR team, Analyzing, Documenting, Building, exporting Universe to Repository, building OLAP and Crystal reports in Info view and testing reports.
- Efficient in Optimizing, Debugging and testing SQL queries, views and Stored.
- Extensively used filters, conditions, list of values (LOV), calculations, etc.
- Creating different types of reports such as Master/Detail, Cross Tab and Charts.
- Creating complex joins like outer joins, equi-join and theta joins and checked the integrity of the Universes.
- Applying slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis.
- Used Recovery Scenario Manager in QTP to handle exceptions
- Used Load Runner to simulate multiple V-user Scenario to measure server performance
- Defined Rendezvous Points to measure the server performance under peak load
- Scheduled scenarios by specifying Ramp Up, Ramp Down and Duration to depict varying amounts of user load on the server at any given moment
- Performed Load Testing using Load Runner to identify bottlenecks and breakpoints at high volumes
- Undertook Stress Testing using Load Runner
- Involved in Regression Testing using QTP
- Developed and Maintained Test Matrix on various dimensions like test status to reflect the test progress
- Participated in Walkthroughs and Inspection meetings to review
- Participated in working with International Settlement on SWIFT coding, as well as application of SWIFT protocol on bond and securities market.
- Generated detailed Bug Reports and documented Defects using Test Direct.
Confidential,Chicago, IL Aug 2007 Sep 2008
Quality Analyst
Allied Financial Service is one of the leading investment management companies that provide brokerage services for investors and planning help for individuals participating in a requirement plan. Involved in testing of different modules of Allied Financial, which is an Internet based application that provides customized services and personalized information. It enables customers to independently manage their portfolio, which includes online trading of securities, equities and mutual funds, up to date information on various indices such as the Dow Jones Industrial, NASDAQ, S&P 500, and S&P 100. Other features and functionality of Allied trade which were individually tested are application-displaying customers specific plan information, monitoring account balances, managing benefits and performing transactions.
- Involved in gathers, documents, and most importantly, analyzes application requirements.
- Conducts application analysis, participates in functional application design.
- Involved in creating thorough technical/functional test plans/scripts and performs QA testing of end-user application development.
- understand requirements and translate these into test cases, scenarios, procedures
- Analyzed the Business process specifications, Use cases, and User Interface specification documents and designed test cases and use scenarios for end to end testing
- Performed High Level Design document reviews. Participated in Feature Design review meetings and presented test case review, strategy and feature functionality
- Analyzed requirements customize and test various modules required for the Sales Order Entry and Distribution Systems.
- Writes automated test scripts where appropriate and assist developers to quickly determine the cause of production system problems
- Perform back-end testing manually on database by writing complex SQL queries.
- Used SQL to validate data entry into Server side databases Sybase.
- Used Embarcadero\'s Rapid SQL to write and execute SQL/Transact SQL against Sybase relational databases.
- Performed gap analysis, business risk analysis and documented
- Used Mercury Quality Center for defect reporting, tracking and documentation.
- Reviewed and updated Test Plan and Test Scenarios.
- Verified fixed defects.
- Created test scripts manually and performed interface, functionality, and regression testing on new builds of the software
- Identified the custom objects in the AUT and mapped them to the standard objects
- Performed security testing manually, and automated testing including Load, Stress and Performance Testing for Web services application using QTP, LoadRunner and WinRunner.
- Created various User Defined Functions for script enhancements and to verify business logic
- Responsible for Defect Tracking and Management Metrics
- Worked closely with Software Developers to isolate, track, and troubleshoot defects
- Attended reviews and walkthroughs to better understand the requirement documents
- Found workaround in case of system failures during testing.
Confidential,Chicago May 2006 Jun 2007
Quality Analyst
- Worked closely with Business Analysts and Developers to gather Application Requirements and Business Processes in order to formulate the test plan.
- Created high level strategy documentation and detailed test documents.
- Have written test scripts to test the Custom exit and the second pass programs written by the RIT team to display the LDT in the correct format.
- Participated in playing back GUI and Smoke Scripts to smoke test every build.
- Helped the management team in validating the test LDT before the CI team could send the file to the customer.
- Have been keeping track of the work done by the entire team using an internally created application called as the Migration Tracking Repository Application (MTRA).
- Performed Back End Testing by writing SQL queries.
- Planned and Executed backend testing using numerous SQL Queries to verify the dataflow from the database using iSeries navigator and DB Visualizer.
- Used TOAD to compare GUI and Database to resolve Database issues.
- Wrote Modification Request for the bugs in the AUT and helped developers to track the problem and resolve technical issues.
- Extensive knowledge on Credit Card application process and involved in validation of the database for the testing on Credit Card information as well as executing test cases related to Credit Card system.
- In addition to working on testing the alpha and beta versions before each release, I had also worked individually in creating the Lockbox Data Transmission (LDT) File, which helps the connectivity team in migrating the customer from OWL and Vicor platforms to Remit one Platform.
- Performed Smoke testing, Security Testing, as well as Load, Stress, and Performance Testing for Web Applications using LoadRunner and QTP. Performed on End to End testing and assisted on designing UI.
- Created and maintained the Requirements Traceability Matrix (RTM).
- Experience on international trades and transaction using SWIFT codes for equity and capital market.
- Interacted with the developers to report and track bugs using Quality Center.
EDUCATION
Master of Science, Finance, Financial Engineering