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 on Defect 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 of Oracle databases and 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 theETL processes.
• Strong knowledge of Informatica Power Center and concepts.
• Experienced inETLTesting, 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, Inner joins/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 Negative testing.
• Responsible for documenting Test plan/Test cases/ Test scripts as per Business rules for each release.
• Well versed in Software Testing 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, TOAD Version 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.