SUMMARY

• 5+ years of extensive experience in Software Development/Testing life cycle (SDLC/STLC)
• Experience in Agile (Scrum, XP) on Sprint by Sprint Deliveries
• Experienced in creating Business Requirement (BRD) and Functional Requirement documents.
• Good Knowledge of Investment Banking and Capital Markets Domain.
• Strong knowledge of Equity, Swaps, Fixed Income and Derivatives products
• Fully exposed to Trade Life Cycle/Securities trade life cycle which includes Order initiation and delivery, Risk management and order routing, Order matching and conversion into trade, Affirmation and confirmation & Clearing and Settlement.
• Expertise in Manual Test Plans, Test Scenarios, Test cases/Scripts, System Testing
• Good knowledge of ETL Tools and Data Warehouse Concepts
• More than three years of ETL testing, manual and automated testing, and black/white box testing
• Well versed in ETL processes, performance based systems, and ETL process flow and standards
• In - depth knowledge of Enterprise Data warehousing ETL, Data warehousing requirements, and Enterprise level data warehousing
• Experience in Web-based Testing (Client - Server Architecture).
• Good experience in Smoke Testing, Functional Testing, Integration Testing, Regression
• Expertise in Black Box Testing, GUI Testing, Back-end testing
• Worked for various Advisor’s & US banks (i.e. Albridge, Advent, Pinnacle, kanaly, Broadrigde, Pershing, Bonaire, Redtail)
• File to File and Field to Field comparison using Winmerge & Notepad ++
• Experience in testing different file formats (Fixed Length, Delimited flat files & XML files)
• Software Documentation from Business, Technical and Functional Requirement.
• Experience in TOAD/SQL Developer
• Expertise in SQL scripts/queries for data verification.
• Experience with HP Quality Center; the Test Plan, Test Lab and Defect modules 
• Strong knowledge of testing data files & report Testing by using SQL reports.
• Conducted Defect Triage calls with Business on daily basis in sync with Offshore team in all testing phases (Functional, System and UAT)
• Excellent hands on experience in Leading, Coordinating and Planning Testing while interacting with client and Team Members to collect requirements, identify risks and define scope and timelines
• Strong analytical and troubleshooting abilities, excellent written and oral communication skills, interpersonal skills and a great team player.
• Proven expertise in Data, End-user requirement and Production Issues analysis and Drive Improvements

TECHNICAL SKILLS:

Database: Oracle 10g, Oracle 11g, SQL Server, MySQL.

ETL Tools: Infomatica

Operating Systems : Windows, UNIX

Tools : Informatica Power Center, Oracle SQL Developer, SQL Server Management Studio 2008, Visual Studio 2008, HP QC, JIRA, GIT, SVN

Business Process Modeling: /Web Application Platform Action Workflow, CASE wise, UML, Visio SharePoint

Methodology : Waterfall, Agile (Scrum, XP), V- Model

Reporting Tools : Microsoft Word, Excel (Advanced)

PROJECT SUMMARY:

Quality Analyst

Responsibilities:

• Involved in database testing using SQL queries, and on different versions
• Understood and articulated business requirements from user interviews and then converted requirements into functional specifications.
• Created Business Requirement Document and Summary Reports.
• Involved in record, playback and modify the scripts in QTP.
• Maintained test case suites in Quality center.
• Created questionnaires for SMEs to gather requirements.
• Experience in testing data files & data repots using SQL report.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure, features and functionality with the new business design using the “As Is” and “To Be” methodology.
• Created Test plans and Test cases.
• End-to-End testing, Regression Testing and User Acceptance Testing, and on different versions.
• Executed Manual Test Cases by using positive and negative data inputs.
• Captured defects in Quality Center and linked them to requirements.
• Extensively used Excel for automating the calculation of system generated complex scenarios as per the use case and matched them with system generated output.
• Tested data flow in the end of day job from GWMP Platform to Data Warehouse( ETL).
• Verify Data Movement to Data Warehouse (DW)
• Extensively executed SQL Queries to verify the data in the tables for Back-end testing and data validation.
• Tested data flow in the end of day job from GWMP Platform to Data Warehouse.
• Created SQL Queries to verify the data in the tables for Back-end testing and data validation.
• Coordinated and monitored the process of testing of defects, bugs and monitored the smooth transition of the application.
• Coordinated with offshore and onshore team in analyzing the defects and tracking them to a closure

Quality Analyst

Responsibilities:

• Followed waterfall methodology, Coordinating and working closely with the project team (DEV, QA, and PM) Expertise in Manual Testing - Validation with real time devices. Writing and executing of Test Cases. Logging defects.
• Clarifying requirements, understanding design requirements and creating Test Scenarios / Test Cases /scripts etc
• Setup meetings with the development team, Business Analyst for the questions/concerns while reviewing the requirement documents and preparation of the test cases.
• Perform manual testing of a web based applications (ASP.NET) - smoke testing, regression testing, End to End testing and integration testing..
• Prepare Traceability matrix to ensure the fully coverage of all the partials
• Extensively executed SQL Queries to verify the data in the tables for Back-end testing and data validation.
• Negative and Positive testing of various Modules.
• Initiated Test Case Review Meetings and Bug Review Meetings
• Maintained test case suites in Quality center
• Reported results and defects in Quality Center and linked them to requirements.

QA Tester

Responsibilities:

• Understand the Requirements and prepared high level scenarios.
• Developed Test Cases and maintained in excel sheet.
• Communicate requirements traceability matrix and track requirements status throughout the project..
• Performed automated testing on the Applications Based on GUI using Quick Test Pro.
• Involved in System Integration, UAT & Regression Testing.
• Prepared Automated Test scripts using Data Driven Framework in UFT/QTP to calculate the Mortgage Repayment summary.
• Used JIRA for managing the defect flow.