Resume

Sign in

QA Analyst

Location:
Monmouth Junction, New Jersey, United States
Posted:
March 15, 2019

Contact this candidate

Resume:

Madhuri Recherla

Email: ac8soh@r.postjobfree.com

Summary:

• Over 6 years of IT experience in software testing and analyzing and execution of Test Plans, Test Scripts and Test Cases in the Investment Banking Domain.

• Significant knowledge in Black box Testing, Functional Testing, Component Testing, System Integration Testing and Test Execution.

• Experience in implementation of different QA methodologies in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

• Extensive experience in preparation of Test Strategy, Test Plans and Test cases.

• Experience using query tools like Toad, PL SQL Developer for Oracle/Sybase databases to validate reports and troubleshoot data quality issues.

• Expertise in developing UML Diagrams using Rational Rose and Microsoft Visio.

• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica Power Center.

• Experience in creating Business Requirement Document (BRD) and Change Request (CR) document.

• Experience on Cognos Reports.

• Experience on Control-M

• Experience with quality assurance and web application testing.

• Experience with Wire Frame and Style Guide validation.

• Expertise to perform bug reporting through HP Quality Center/Jira Enterprise ticketing system.

• Good Knowledge on Automation tools like QTP and SOAPUI tools.

• Good Knowledge on performance testing using Load Runner.

• Interface with developers/business analyst/project managers in the development, execution and reporting of test automation results.

• Identify and eliminate performance bottlenecks during the development lifecycle

• Good understanding of Web Applications/Web Services architecture.

• Effective Time Management Skills and consistent ability to meet client deadline.

• Excellent inter-personal abilities and a self-starter with good communication skills, problem solving skills, analytical skills.

Technical Skill:

RDBMS : Oracle, Sybase ASE, My SQL

Operating Systems : UNIX/Linux, Windows 95/98/2000/NT/XP/VISTA/7/10

Repository Tools : Git, SVN

Bug Reporting Tools : Jira Enterprise, HP Quality Center, Bugzilla

Testing Tools : Load Runner 11, Quick Test Pro 8.2

Reporting Tools : Cognos

Scheduler Tools : Control M

Scripting Languages : UNIX Shell Scripting

Professional Experience:

Deutsche Bank Services Sep 2016 – Jan 2019

QA Analyst / Jr. BA

Project: Mortgage Portfolio

Description: Mortgage Portfolio web application is used by PWM Business to track Loans. This provides access to different types of loans like Structured Lending & Mortgage. This application supported File uploads from back office to track all pay down, pay offs, Interest rates etc.

Responsibilities:

• Analyzed business requirements, functional specs and assisted QA Team lead in writing the Test Plans.

• Attended Business meetings, FSD walkthrough.

• Created Test cases and executed them.

• Tested Control-M jobs to test report generation and validate reports.

• Executed Cognos reports and validating the data.

• Conducted UAT sessions with Business to ensure that the system meets all the requirements.

• Used excel functions and macros for quick data verification.

• Created Change Request Document.

• Worked closely with Developers to resolve system test issues and re-test.

• Worked Jira ticketing tool extensively to track issues, releases etc.

• Created filters/Dashboards in Jira to group issues/back logs/releases.

• Worked in Agile model, Sprints and Short releases. Worked on tight deadlines.

Environment: Control M, Cognos, Jira Enterprise, PL/SQL Developer, Oracle, Unix, WinSCP, Microsoft SharePoint, Excel Macros.

Project: Pharaoh - Bank Consolidation

Description: This project was to create one comprehensive banking platform for wealth management decision to help reduce the banks overall vendor expense and to better position. This project is to consolidate both Domestic & LatAm Bank into single bank. International Bank (LatAm) was used for US clients who are located outside US.

This project is mainly to keep operations untouched at DB side and convert Vendor files (with Single Bank) to separate Bank files as before. Files were generated using Cobol. These files are used by different downstream applications.

Responsibilities:

• Analyzed functional specs for different downstream applications.

• Attended Business meetings, FSD walkthrough.

• Organized meetings with different downstream applications to understand end to end flows.

• Prepared different test plan for each module.

• Test plan is prepared according to each module phase as well as end to end testing.

• Created Test cases for each module and complete test case to run end to end flow. As there are 8 downstream applications there were different leaf nodes and had to prepare almost 4 End-to-end flows.

• Ordered and tested Control-M jobs that execute Cobol jobs to generate output files. Prepared sample bank files for Dev/QA testing.

• Coordinated with Vendor team to compete UAT testing.

• Worked with all Teams to resolve system test issues and re-test.

• Worked Jira ticketing tool extensively to track issues, releases etc.

• Created filters/Dashboards in Jira to group issues/back logs/releases.

• Worked in Agile model, Worked on tight deadlines.

Environment: Cobol, Control M, PL/SQL Developer, Oracle, Unix, WinSCP, Microsoft SharePoint.

Project: Client on Boarding - Appway

Description: The main objective of this project is to deliver a solution that provides a more efficient Onboarding experience for the client by a compliant process based on “Global KYC Project”. Appway product was setup at DB for COB. This provides step by step workflow process for every client to go thru Anti Financial Crime (AFC), Anti Money Laundering (AML) etc.

Responsibilities:

• Attended Business Requirement and Functional Specification walkthroughs to understand complete process and to test workflow.

• Prepared testcases for different types of Account opening process

• Executing the Test cases that was provided by Business in UAT phase.

• Worked in Agile model, Sprints and Short releases. Worked on tight deadlines.

Environment: Appway, Oracle, Unix, WinSCP, Microsoft SharePoint.

Project: IRRBB - Interest Rate Risk in the Banking Book

Description: This project is to move existing legacy application to Java and reuse native C++ apis. C++ apis were called from Java code to convert Trade and Funding xml files (xmls files are generated from Risk DB thru Control M Jobs) to SDOS files (this also includes calculations on different Market data) which are fed to Risk Engine for further analysis.

Responsibilities:

• Attend BRD and FSD walk through to understand total migration process from legacy system to Java.

• Created test cases to execute control M jobs to generate Trade and Funding XML.

• Analyzed Unix job logs called by control M for detailed logging in Jira ticket.

• Created test cases to compare xml / SDOS files from legacy and new system.

• Worked closely with Business in UAT phase and in time of releases.

• Worked closely with Developers to resolve system test issues and re-test.

• Worked on Jira ticketing tool extensively to track issues, releases etc.

• Created filters/Dashboards in Jira to group issues/back logs/releases.

• Worked in Agile model, Sprints and Short releases. Worked on tight deadlines.

Environment: Control M, Jira Enterprise, PL/SQL Developer, Oracle, Unix, WinSCP, Microsoft SharePoint, Excel Macros.

Project: Client Segmentation

Description: This project is intended to remediate the self-identified issue and subsequent finding by group audit. The main object of this project is to enhance and improve the accuracy and efficiency and ability to gather required client segmentation data attribute for LR reporting and to identify new data elements required to address additional data segmentation.

Responsibilities:

• Analyzed user business requirements, functional specs.

• Worked closely with BA to finish BRD’s

• Attended Business meetings, FSD walkthrough.

• Created Test Plan according to the specifications and timelines given by Business.

• Created Test cases and executed them.

• Running to Control-M job to generate LR report using informatica.

• Checking data attributes if they are flowing correctly from front to back (i.e. from Appway to FIS) as per business requirements and making sure the logic for derived data in Liquid reporting is correct.

• Worked closely with Business in UAT phase and in time of releases.

• Worked with System Test Review Team and Developers to resolve system test issues and re-test.

• Worked on Jira ticketing tool extensively to track issues, releases etc.

• Created filters/Dashboards in Jira to group issues/back logs/releases.

• Worked in Agile model, Sprints and Short releases. Worked on tight deadlines.

Environment: Control M, PL/SQL Developer, Oracle, Unix, WinSCP, Microsoft SharePoint.

Growth Box – Bangalore, India Jun 2011 – Dec 2014

QA Analyst / Jr.BA

Project: Growth Box Website Enhancements.

Description: Growth Box is collaborative framework helps enterprises build sites that easily help clients manage, know and communicate with their users.

This Project includes several functional enhancements to the website such as new Inquiry Form, Tracing & Crewing functionality under Collaboration Tab, UI changes and Database redesign.

Responsibilities:

• Work with Business clients, gathering requirements to create Business requirement Document (BRD).

• Track all the requirements, assign deadlines to onsite and offshore developers.

• Reporting status to Project manager.

• Created Test Plans and Test cases for functional and Integration Testing.

• Reported bugs using Bugzilla and follow up.

• Updated Requirement Traceability Matrix after testing is completed.

• Updated Regression Test Case document as per New Requirements.

• Prepared Bug Report Status Document for each Build Release.

Environment: Window XP, Bugzilla, Oracle 9i, SVN Repository, Snag it, SQL Developer, HTML

Education:

• Bachelors in Technology – Engineering JNTU India.



Contact this candidate