Quality Assurance Manual Tester

Summary:

Over ** years of experience in software Analysis, Design and Software Quality Assurance Testing (Manual / Automation) of web, mainframe and Lotus Notes Applications

Experience with Agile Product Quality Management, QA end to end design and development

Extensive experience in developing Test Strategy and Test Plans for Unit, Functional, Integration, Regression, User Acceptance, System, GUI, Load, Stress, Performance Testing.

Experience with Financial products like Fixed Income, Securities, Options, Stocks, Equities, Bonds, Clearance, Derivatives, Global Custody, Credit Cards, Banking, and Loans etc.

Extensive experience in Loan Origination, Underwriting, Pricing, Servicing, Primary and Secondary Mortgage market

Excellent communication, presentation and documentation Skills, attention to detail, efficient problem solving ability, analytical and programming skills.

Ability to liaise with clients, vendors, technical teams and management.

Experienced in working independently in fast-paced and high-pressure

Education:

Bachelors in Computer Science Engineering, Nagarjuna University, India

Certifications:

ISTQB – CTFL, CTAL -- Test Architect, CTAL –Test Manager

CSPO (Certified Scrum Product Owner), CSM (Certified Scrum Master)

ITIL – Foundation, ITIL Intermediate Continual Service Improvement

Technical Skills:

Testing Tools: JIRA, Confluence, X-Ray, Selenium, Cucumber, Behave, ALM, Clear Quest

Web Technology: J2EE, Java, Servlets, EJB, Struts, JSP, JDBC, XML, XSL, HTML,

JavaScript, VB Script, ASP, UNIX Shell Scripts, SOAP, REST

App Servers: BEA WebLogic, IBM WebSphere, AWS, IIS

Databases & RDBMS: Oracle, MS Access, DB2, and SQL Server 2000, Power BI, Tableau

Operating Systems: Windows 95/98/2000/ME/NT/XP, MVS, Sun Solaris and UNIX .

Languages: Java, SQL, PL/SQL, SQABASIC, COBOL, CICS, JCL, Lotus Notes

Professional Experience:

Fannie Mae, Washington DC, Product Quality Lead Nov ’16 – Till Date

Project: PSS-Pricing Shared Services

PSS Application is a pricing engine developed to price the MBS Loans. PSS handles 2 types of Pricing. Risk Based Pricing and BUBD Pricing. PSS gets the Loan and Pool data from MBSPool and the Contract data from MCTSX. All these attributes are used in pricing to fetch a grid that matches all the criteria and subsequently calculate the Prices based on the value obtained from the grid. Once the Prices are calculated the payment amounts are sent to downstream systems and then eventually paid by or to the lender.

Role & Responsibilities:

Managed, mentored and trained as needed, 6 scrum test teams across 2 Products/ARTs

Improved the run-time of test cycles by enabling industry best practices and quantifying risk

Consistently measured the maturity levels and progress against the KPIs set up by the Enterprise QA shared services and also the respective Scrum teams.

Created various metrics related to code quality, test planning, execution and incident reporting for continuous improvement of test areas.

Managed the MSPs and the SOWs of resources to align with the demand of the test teams.

Worked in the BDD, ATDD and TDD Agile methodologies

Created the System Test Plan and Test Strategy documents for products under test

Created and managed Test cases in JIRA/X-Ray based on the User Stories

Collaborated with development and Business team to understand the product features for the purpose of developing Test Cases, Test Scenarios and Test conditions

Designed the framework for Integration and End to End testing, and reviewed the plan and results with the Product managers.

Designed Test procedures for Testing large volumes of data during Integration and E2E Testing

Designed Automation test scenarios using Cucumber Gherkin format

Designed UI test cases and performed cross-browser testing with Selenium

Used Jenkins and Selenium node framework to kick off automation on multiple instances

Created the RTM between the Test cases and the Epics and features to ensure adequate test coverage.

Created Test Plans to run the batches on a cycle basis which starts from dry-run to full Cycle

Manually executed the Testscripts by running all daily and monthly batches one by one and validated the data.

Created automated test pipelines using Jenkins, so that the Tests are executed immediately after the code deployment and on demand

Created various data pools for various cycles based on Positive, Negative and Alternate Scenarios.

Executed the Test cases in JIRA and set the status of the test cases

Executed Back end-test scenarios using UNIX and SQL based on the Legacy Code and Solution Specifications and User stories

Validated the service (XML/JSON) responses by comparing with the expected results and with the Database.

Tracked the progress of testing against the KPIs set at the ART level

Performed testing of API service calls using SOAP UI and Postman

Designed the Automation framework for API testing and ESB testing.

Created AWK Scripts to parse the data and validate the data.

Created SQL Scripts to extract the Data after the batch is successful and test the ETL transactions

Executed the Unix Shell scripts with embedded sqls to extract the data based on conditions and to compare them with the expected results

Reported defects using JIRA and Performed regression testing after fixing the bugs by going through all test case scenarios.

Scheduled the Unix shell scripts using Autosys Jil

Performed testing on complex SQL queries involving verify the SQL performance and extensive use of various Databases

Tested the 3 Web applications PET, PERT and EC using various data and tested the interaction between them.

Created the Test Summary Reports and got sign off s on all the deliverables.

Worked with the Developers and the users to create the User Manuals and Training Documents for PSS.

Environment: JIRA, Tableau, Power BI, Win SQL, Sybase, HP ALM, Lotus Notes, IBM Mainframes, ETL, Java/J2EE/WebLogic/Struts/EJBs/Sybase, UNIX, Windows NT/00, MS-Word, MS-Excel.

Freddie Mac, McLean, VA QA Lead May ’12 – Nov ’16

PE Pricing/PMA

Freddie Mac is a giant in the Secondary Mortgage market. Involved in testing the core business application of Freddie Mac. The PE Selling System and the Legacy systems are used by the EUCs to create Contracts, Allocate Loans to the Contracts and the settle the contracts based on their respective criteria. PMA provides for a flexible infrastructure for creative pricing strategies for both PE and Legacy loans. The infrastructure introduces distinctive pricing based on execution type; commitment date, Product Ids based pricing for cash and Swap loans and custom pricing for sellers wither by Master Commitment.

Responsibilities:

Identified the Gaps Between Requirements and Use cases

Evaluated the Backend Schemas and Approved the Data Model considering the Feasibility of the Testing LOE

IBM Doors is used to access the Requirements

Developed High-level test plans using MS Project and Word

Developed the Test cases, Test scripts and Data pools, Requirement Traceability between the test cases and the Requirements in HP ALM

Executed the test cases in Test Lab of ALM and manually logged the results for each Iterative build

Tested the Web Application on Various Browsers

The defects were logged in IBM Clear Quest

Created the SQL Scripts, Procedures and Triggers

Have done the database validations using IBM DB2 Command Center

Modified the Unix Shell scripts and executed them for various timely scheduled jobs to create the reports

Validated the Autosys jobs run each day

Performed End to End testing for all the systems from MIDAS

Created MCs and Loans using the Mainframe systems such as DPM and MIDANET

Created Contracts in CSWeb (Java App)

Used Humming Bird to FTP the flat files to Mainframe systems

Created a Flat file which is sent to JCL system thru Web methods and to the PMA TDS

Validated Data using DMLO and OLQ menu on mainframes CICS

Validated the Results by comparing the Expected and the Actual Results

Created the Automation Scripts in Rational Robot and Robot J, Modified the Scripts for various data and set up verification points in the scripts and executed the scripts.

Done the Regression Testing and executed the Automated Scripts in Cutover Environments when the application attained a stable state

Baselined the Automation Scripts for future releases

Analyzed the Graphs and Reports obtained by the Performance Team after the stress testing is done on the Client-Server Application

Change Management done through Clear Case when each build is deployed

Involved in Warranty Support after the Project released

Documented all the Test Logs and the Test Summary reports, ARR (App Readiness Review)

Assisted the Business Area to create the User Manuals, STAR Reports, Support documents and training documents

Environment: Rapid SQL, MsSQL server, Java, J2EE, HP ALM, IBM Clear Quest, Clear Case), Mainframes, IBM S390, COBOL, CICS, JCL, MVS, Oracle 8i, DB2, Unix, Windows NT/00,NetScape Navigator, MS-Word, MS-Excel.

SME on QA processes -- ALM Administration

Managed and performed enterprise-wide upgrades of ALM, QTP, Clear Quest, Virtual Machines and Performance Testing tools

Conducted the Testing User Group sessions for formalizing the Testing Processes

Other high level tasks that are part of this responsibility are

Managed the Testing Center of Excellence for the enterprise to help improve the Test process maturity

Managed the Governance model of the Testing SOPs.

Coordinating the migration of all 900 QC projects to ALM with the project owners

Created Test Management Procedure document which includes a standard ALM template

Created new set of standards for tools implementation such as the End to End Traceability model

Created customized simulated training for ALM and QTP using ART.

Administration of Quality Center, ALM, QTP, UFT, Clear View and QMDM tools

Managing Virtual Desktop images on the Virtual Machines using VMware

Created the integration of DOORS and Clear Quest with ALM/QC

Created ALM standard reports for management to use for the SDLC paperless initiative

FINRA, Rockville, MD, QA Tester Dec ‘09 - May’ 12

Project: OTCBB

Worked on NASDAQ’s two premier web sites www.nasdaqtrader.com, which gives the information about volume reports, historical data, securities, quotes, last sale data feeds, NASDAQ 100 Index and News for trading community. www.otcbb.com, which provides market statistics, trading activity reports, securities information, OTCBB daily list and NASD and SEC rules governing to OTCBB.

Responsibilities:

Involved in preparing High Level Test plans based on user requirement documents.

Involved in defining test objectives for the applications and performed Manual Testing.

Involved in cross browser testing using Netscape Navigator and Internet Explorer

Created test scenarios and test cases for the functionality, integration testing of the application.

Involved in developing Integration Test Plans, System Test Plans and Performance Test Plans for the applications.

Used SQL Queries to verify the data from the Oracle database

Tested various links of Global Navigation Bar, the text-hyperlinks, image-hyperlinks of Home Page and different Feature pages.

Developed Test Plans, Test Case design using Rational Test Manager

Identified the Test Cases to be automated and lead the effort for automating the product using Rational Robot.

Created Data Pools and used Data pools with Sessions and GUI Scripts to supply data values to the variables in the script during playback

Involved in testing applications which have been developed using two distributed component technologies i.e. Enterprise Java Beans (EJB) and the CORBA Component model.

Applications have been deployed using both server-side component models for developing distributed business objects.

Requirements management was done using Rational RequisitePro.

Rational RequisitePro is used for creating traceability between requirements and test cases.

Defect and Change Tracking was done using Rational Clear Quest.

Version control and configuration management using Rational Clear Case.

Worked extensively with Unix Shell Scripts.

Extensively used SQL/PLSQL to work on database for checking database integrity.

Validated the data on the Mainframes.

Interacted with the developers for bug fixes and problem resolution

Participated in regular project status meetings related to testing

Environment: Java2.0, J2EE, WebSphere, Mercury Suite (WinRunner,TestDirector),Rational Suite 2002, ClearCase 4.2, JSP, XML, Oracle 8i/9i, TOAD, MS-Project, Windows 2000/NT, UNIX, Mainframes (DB2, JCL, QMF, TSO/ISPF), Internet Explorer, Netscape.

The College Board, Reston, VA, Data Test Engineer, Apr ‘04 – Dec ‘09

Project: Enterprise Databases

The Enterprise Data Model provides an architectural framework for the integration of enterprise processes, manual and automated, independent of any particular program, system or application. As a data test engineer I was responsible for testing the ETL processes related to the transition toward the Integrated Data Store framework.

Extensively worked on the Student Registration systems integrating data feeds from multiple feeds into the Event and Assessment databases.

Developed Test Plans, Test cases and RTM based on the Data mapping specifications and requirements.

Involved in detailed target database analysis to minimize impact to existing applications.

Developed data quality queries to verify data integrity and consistency across source and target systems, run daily monitoring data feeds and ETL outputs.

Developed PL/SQL stored procedures to verify ETL processes across systems.

Facilitated defect review meetings involving all stakeholders to review defects, identify severity and set priorities as per client requirements, ensuring accuracy and conforming to deadlines.

Scheduled and executed Informatica ETL jobs. Monitored ETL execution trough Informatica Workflow Monitor.

Developed an automated test data creation tool for faster and larger test data volumes.

Extensively tested web broker services (REST) using SOAP UI.

Developed and documented QA testing and data creation training manual for various databases for cross training purposes.

Environment: Informatica, Oracle 11g, Flux, RESTful Web Services, Cognos & UNIX.

QA Analyst / Tester, S1 Corporation, Atlanta, GA Nov’ 2002- Mar ‘04

Title: S1 Financial/CRM Product

S1 Corporation develops enterprise software solutions that turn customer interactions into profits. S1 offers its customers the ability to view bank balances, travel reservations, e-commerce sites, email, news, and more, from thousands of leading web sites and data sources, all aggregated in one place and available with a single logon. The Marketing team will enter the deals in to the CRM System and managerial staff view data according to the permissions set for them.

Environment: Windows XP, Java, JDBC, Servlets, JSP, JavaScript, Web logic, XML, HTML, DHTML, Win Runner, Oracle 8x, SQL, C++, PVCS Tracker, Test Director.

Contact this candidate