PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience with emphasis on Software Quality Assurance in both Manual and Automated testing on web based and client server applications.
• Experienced in testing Web based and Client Server applications under multi - browser environments.
• Documenting Test cases, Test scripts, pre-conditions, input data and expected results for System testing.
• Expertise in UNIX/Linux working experience for destructive build scripts.
• Experience onDefect Reporting using Quality Center/Jira and following it up until the satisfactory resolution is obtained.
• Worked with Business Analysts to understand user requirements and worked with programmers to resolve defects.
• Extensively worked with Data science team for data quality check and data quality analysis, Backend Testing.
• Excellent knowledge and working experience in Neo4j writing cyphers for data quality analysis.
• Extensively worked on data quality analysis between Neo4j and Oracle.
• Experienced in automation testing using functional testing tools and management tools like Quick Test Pro 9.2/9.5, HP Quality Center, Mercury Quality Center 9.0/9.2/9.5 and Test Director 8.0
• Worked extensively on Manual Testing of the application includes Functional, Regression, and Security testing.
• Extensive knowledge in all stages of the Software Development Life Cycle (SDLC) and software development methodologies and software engineering standards, like Waterfall and Agile methodology.
• Have a good knowledge on Capital Markets with experience testing applications for Fixed Income securities, Derivative trading system and Order Management System.
• Extensively worked on database testing using SQL on different versions ofOracle databasesand SQL server.
• Hands on experience in Backend testing with Oracle Database.
• Proficient in writing SQL Queries using DDL, DML, DCL, Transition Control statements and develop stored procedures. 
• Understanding of source to target data mapping and Business rules associated with the   ETL processes.
• Strong knowledge of Informatica Power Center and concepts.
• Experienced in   ETL  Testing, Data Mapping and Source to Target Mapping with multiple sources. 
• Tested applications, involved Feed/Flat File data, based on the requirements.
• Proficient in writing medium to complex queries using select, Innerjoins/outer joins, sub queries, logical conditions, group by and aggregate functions.
• Excellent knowledge and working experience in writing test scenarios, test cases, test conditions, test data, executing tests scripts and analyzing test results.
• Proficient in all stages of software testing by using System testing, Integration testing, GUI testing, Black Box testing, Unit testing, Backend testing, Positive and Negativetesting.
• Responsible for documenting Test plan/Test cases/ Test scripts as per Business rules for each release.
• Well versed inSoftwareTesting Life Cycle (STLC) - phases include: Test planning, Test design, Test data identification and Defect management.
• Proficient in XML, HTML, SOA, SOAP and Web services.
• Proficient in UML - Use case Diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams.

TECHNICAL SKILLS:

Operating System: Windows NT/2000/2003/Windows7,XP,Unix

Development Framework: JAVA, .NET, JavaScript,D3.js,js Angular, VBScript, web services, XML, HTML,SOA, SOAP, SQL

RDBMS: Oracle8i/9i/10/11, SQL Server

Defect Tracking Tools: Test Director, QTP, Quality Center (QC), JIRA

Project management Tools: MS Excel, MS Word, Ms Power Point,MS Outlook

Version control tools: MS Visual Source Safe 6.0, Team forge

Database Tools/IDE: Toad version 9.7.2.5, Oracle, MS SQL Server Studio,Neo4j

ETL Tool: Informatica Power Center 8.1/9.1

PROFESSIONAL EXPERIENCE:

Confidential, NY

QA Analyst

Responsibilities:

• Participated in Requirement Analysis, Use-Case Analysis with Business Analysts, project Architects, Leads and developers
• Was responsible for gathering QA requirements to create test cases based on the functional and nonfunctional requirements
• Performed QA testing on various modules of COCO project
• Led the QA testing life cycle (test analysis, test planning, test execution and defect tracking)
• Established working relationship with BA, Architect and Developers and communicated effectively on the status of the QA throughout the project life cycle
• Accountable for selecting test approaches, estimating the time, effort and cost of testing, acquiring resources, defining test levels, cycles, and planning incident management
• Participated in daily stand-up and scrum meetings to discuss status 
• Worked as a QA Analyst for testing the applications and closely worked on agile software development methodology.
• As QA I worked in all the modules, also front end and back end testing
• Conducted Black box testing like smoke testing, functional testing, negative testing, positive testing, system testing, integration testing and performance testing to check how well the component conforms to the requirements.
• Actively participated in the defect management process by identifying, replicating, and logging, escalating, documenting, categorized them on severity and resolving defects/issues of the application.
• Interacted with developers for defect fixes. Used Jira as defect tracking tool.
• Performed GUI testing to test the screen navigation to make sure that they function as per the requirements.
• Carried out regression testing to confirm that the application was out of any defects after changes being made in it.
• Closely worked with Data scientist team for Data quality check and in Data quality analysis between Neo4j and Oracle.
• Extensively worked in Unix/Linux to test the destructive build scripts.
• Performed exhaustive validation of the backend/databases of the applications using
• SQL queries in Oracle.
• Identified bugs present in database and coordinated with software developers and resolved the issues.

Environment: Graph Database (Neo4J), NoSQL (Hadoop and Cassandra), D3.js, Angular.js, jQuery, Python, Core Java, Kettle ETL, CIS (Cisco Information Server) JavaScript,, Spring, Oracle, Jira, Google API, Tomcat.

Confidential, NY

QA Analyst

Responsibilities:

• Worked as a QA Analyst for testing the applications and closely worked on agile software development methodology. Maintained the Requirement Traceability Matrix.
• Reviewed Business Requirements Document (BRD) and collected the software requirements and specifications.
• Involved in testing life cycle (Test Analysis, Test Planning, Test Execution, and Defect Tracking).
• Plan the tests including selecting test approaches, estimating the time, effort and cost of testing, acquiring resources, defining test levels, cycles, and planning incident management.
• Involved in JAD Sessions, walkthrough and inspection meetings to verify the status of testing.
• Developed the test plan, test scripts and test cases for the project in Quality Center which provide detailed list of conditions under which the system will be tested.
• Conducted Black box testing like smoke testing, functional testing, negative testing, positive testing, system testing, integration testing and performance testing to check how well the component conforms to the requirements.
• Actively participated in the defect management process by identifying, replicating, and logging, escalating, documenting, categorized them on severity and resolving defects/issues of the application. Interacted with developers for defect fixes. Used Quality Center as the web-test management tool.
• Performed GUI testing to test the screen navigation, graphics and hyperlinks, etc. to make sure that they function as per the requirements.
• Performed SOA / Web Service testing using Soap UI.
• Analyze the received data feeds from data vendors (XML & Flat files) and mapped the filtered data source to the target source.
• Carried out regression testing to confirm that the application was out of any defects after changes being made in it.
• Performed exhaustive validation of the backend/databases of all the applications using SQL queries in Oracle.
• Identified all bugs present in database and coordinated with software developers and resolved all issues.

Environment: Quality Center 9.5/10, QTP 9.2/9.5, .Net, HTML, XML, JavaScript, Oracle 11, Windows XP, Visual Source Safe 6.0.

Confidential, NY

QA Analyst

Responsibilities:

• Participated in Requirement Analysis, JAD sessions, Use-Case Analysis and Gap Analysis with Business Analysts, project Leads and end users.
• Assisted the team lead with daily QA tasks. Attended project meetings, release meetings, and QA status meetings.
• Defects were identified and reported to the development team using Quality Center.
• Creating and Generating System test scripts for different test scenarios covering all aspects of project functionality.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios.
• Conducted System, Functional, GUI, Regression, Smoke, Database Integrity, User-Acceptance (UAT) and Performance testing
• Conducted functional testing using QTP as well as manual testing methodology.
• Performed SOA / Web Service testing using Soap UI.
• Compile data (XML and Flat files) from different data vendors and prepare data mapping documents for multiple attributes for various security types and subtypes; defining source data, mapped target data and business rules which was been used by the risk management applications and accounts departments.
• Extensively used SQL queries to extract data from Oracle. Written SQL statements manually to validate data from Database using SQL*PLUS Environment.
• Performed backend database testing by using SQL queries for inserting, retrieving and updating the data
• Conducted various management activities by analyzing and verifying test results, providing status reports.
• Created Traceability between Requirements and Test Cases using Quality Center.
• Conducted GUI testing to ensure the graphical user interface meets its specifications
• Conducted data-driven testing on pricing functionality with different data sets.
• Conducted formal bug review meetings & produced daily progress report to Business and Project Managers.
• Actively participated in Change Requirement Meeting and reviewed Change Request Documents

Environment/Testing tool: Quality Center 9.2, QTP 9.2/9.5, Oracle10g, TOADVersion 9.7.2.5, Java, J2EE, SOA, VSS, Team forge, Web service.

Confidential

Analyst / Jr. Oracle PLSQL Developer

Responsibilities:

• Extensively interacted with the data analysts/business analysts to understand the user requirement and the business logic.
• Worked on PL/SQL based development of functions/procedures for data setup and clean-up.
• Performance tuning of application by identifying the SQL, which are not written well; providing inputs to the application programmer; correcting and implementing the right components.
• Involved in scheduling various jobs using DBMS job scheduler.
• Involved in designing and developing of forms and Unit testing.
• Involved in development of integration of modules and testing.
• Scheduled oracle jobs through DBMS SCHEDULER.
• Created Views using a bunch of Joins, Union and minus operators on the reference tables which hold the data’s with new symbolic specifications.
• Created triggers for some change requests.
• Identifying test scenarios and preparing test cases for UAT test phase.
• Requirements gathering analysis and Preparation of Business Requirement Document based on inputs from business analysts and end users.
• Developed and reviewed the test cases written for functional, user interface and regression testing.
• Involved in Defect logging at the time of execution.
• Involved in preparation of daily status reports at the time of execution.
• Worked on test reporting using Quality Center/Test Director.

Environment:Oracle 9i, SQL and PL/SQL, Windows NT/2000, Forms 6i, Reports 6i, SQL*Loader, ODI, MS Access 2000, C++, UNIX Test Director, ASP.Net.

Confidential

Database Support Analyst

Responsibilities:

• Created tables, views, synonyms and sequences.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Optimized queries using rule based & cost based approach.
• Used SQL Loader for data loading.
• Modified existing forms, reports, and graphs as per the enhancement.
• Responsible for testing Branch reports, application developed for Branch Managers.
• Involved in Test Plans meetings and user meetings
• Involved in cross browser testing of the application on various Browsers to ensure that it functions similarly on all browsers.
• Responsible for testing User Login, Account Information.
• Developed Automated and Manual test plans to test User Statements, Transfers and history of payments and other functionalities Studied the project requirement and designed the project.
• Tested different links for the user's in the site
• Determined the nature and severity of bugs uncovered while testing and documented the defects
• Maintained a defect tracking schedule describing in close detail bugs encountered during testing and replicating such bugs for the benefit of developers

Environment:Oracle 7.x, Windows NT/2000, Test Director, UNIX, XML, ASP.Net.