We provide IT Staff Augmentation Services!

Data Analyst Resume

4.00/5 (Submit Your Rating)

Nyc, NY

SUMMARY

  • Over all 7+ years of experience in Software Testing for Client/Server and Web Based Applications in Finance, Insurance, and Commercial sectors.
  • Working as a Data Analyst for past one year with Confidential, NY
  • Extensive experience in Agile - Scrum & Waterfall Methodologies.
  • Strong hands-on experience in writing and execution of Test Strategies, Test plans, Test scripts, Test Report and Risk Assessment Forms.
  • Deep understanding of Test Life Cycle and Defect Life Cycle.
  • Strong experience in manual and automated testing using different tools like HP Quality Center, Bugzilla, JIRA, SOAPUI, QTP.
  • Excellent noledge of Sybase, MS SQL Server, Oracle, IBM DB2 databases.
  • Excellent in writing SQL queries to verify data using joins, functions, stored procedures and views.
  • Strong end-to-end experience in HP Quality Center as a test management tool.
  • SOAP & RESTful Web service testing using “SOAPUI”
  • Experience in testing with different web Based environment of Microsoft & Java Technologies.
  • Good experience in UNIX and Shell scripting.
  • Deep understanding of data structures like XML, JSON.
  • Good experience in writing VBA macros to optimize work. Got appreciation for this.
  • Experience in “Agile-scrum” methodology good understanding of Product Backlog, Release Backlog, Retrospective/planning meetings & Sprints.
  • Good experience in Active Directory & Single-Sign-on testing.
  • Profound experience in Web technologies, web architecture, web server configuration, HTML, XML, JSON and web protocols (HTTP GET/POST).
  • Ability to interact with developers and business analysts regarding testing status and maintain detailed QA documentation.
  • Good experience in working under onshore-offshore model.
  • A Quick learner and good team player with excellent logical, analytical and testing skills.
  • Good verbal and written communication skills.
  • Ability to work in time sensitive situations.

TECHNICAL SKILLS

Testing Tools: HP Quality Center, SOAPUI, JIRA, QTP

Languages: UNIX, Shell Scripts, C, XML, JSON, VBA (macros), .NET, JAVA

Databases/Application Server: Sybase, MS SQL Server, Oracle, IBM DB2, MS-Access, IIS, WebSphere 4.0, 5.0

GUI Tools: Developer 2000, Visual Basic 6.0, Toad 9.0

OS Environment: Unix/Linux, Windows 95/97/2000/NT/ME/XP/VISTA, MAC

Hardware: IBM - PC Compatible

Others: TOAD, SQL* loader, SQL* Plus, SQL Editor, Vi Editor

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Data Analyst

Responsibilities:

  • Analyzing the whole functional & the Technical requirements.
  • Involved in complete SDLC using Agile Scrum methodology.
  • Creating Test Strategy and Test Plan documents.
  • Creating, reviewing & executing test cases.
  • End-to-end test management in HP Quality Center for the project. Logging the defects in Quality Center.
  • Data analyses & comparison for different UAT Environments.
  • Working as mediator between technology and business teams in testing against requirements, investigating issues
  • Working in validation of Counterparty Credit Risk Models, Trade position data, Reference data and Indicative data.
  • Generating business exposure reports indicating the current and potential exposures and BASEL compliance.
  • Managing the offshore team, communicating with them on daily basis.
  • Analyzing Data and report the findings to the respective stakeholders.
  • Writing DA sign-off emails.
  • Sending test metrics and managing daily defect calls with BAs & Dev team.

Environment: Windows XP, ASP.Net, Sybase, HP Quality Center, JIRA, TOAD, Agile.

Confidential, Richmond, VA

Sr. Quality Analyst

Responsibilities:

  • Analyzing the whole functional & the Technical requirements.
  • Involved in complete SDLC using Agile Scrum methodology.
  • Creating Test Strategy and Test Plan documents.
  • Creating, reviewing & executing test cases.
  • End-to-end test management in HP Quality Center for the project. Logging the defects in Quality Center.
  • Database (MS SQL Server) testing to make sure the data flow is correct between systems.
  • Extensive Active Directory (LDAP) and Single Sign On (SSO) testing for authentication and authorization.
  • Web service testing using “SOAPUI”.
  • Mapping Requirements to test cases, defects & generating reports.
  • Managing the whole offshore team.
  • Analyze test results and report the findings to the lead, and provide recommendation for performance improvements as needed.
  • Writing QA sign-off emails.
  • Sending test metrics and managing daily defect calls with the dev. team during System testing.

Environment: Windows XP, ASP.Net, MS SQL Server 2008, HP Quality Center, JIRA, XML, SOAP, Agile.

Confidential

Responsibilities:

  • Analyzing the requirement documents & the Technical Specifications.
  • Creating Test Plans based on Business, Functional & System requirement documents.
  • Extensively involved in Software Development Life Cycle (SDLC) using Agile (scrum) Methodology.
  • Involved in Sprint Retrospective & Planning meetings.
  • Extensively used Quality Center to load test cases, execute them and log defects found in system testing.
  • Actively participated in QA meetings and regularly interacted with business users to gain a better understanding of the Business Process and the Requirements.
  • Used Quality Center for repository, reporting bugs, tracking bugs and updates on resolving issues.
  • Closely worked with developers and the Engineers to nail down the technical problems.
  • Created and enhanced VB scripts for regression testing with verification checkpoints available in Quick Test pro.
  • FIX protocol testing for the orders going out to external vendors.
  • Created Traceability Matrix for all the test cases.
  • Involved in Regression testing against new builds and functional testing using QTP.
  • Writing SQL queries to validate performed transactions.
  • Analyze test results and report the findings to the lead, and provide recommendation for performance improvements as needed.
  • Writing QA sign-off emails.
  • Involved with the Architecture & Design for designing the entire Testing Process.

Environment: Windows XP/7, ASP.Net, IBM DB2, Quality Center, FIX, JIRA, SOAP, XML, QTP, Agile.

Confidential, NY

Sr. Quality Analyst

Responsibilities:

  • Involved in the whole Planning of Test, setting Test Conditions, Test Data and Expected results for Regression, Integration, and User Acceptance Testing.
  • Prepared and executed system test plans for the POS Application on both the iPad and the Mac Book.
  • Analyze business Requirement documents, Functionality Specification Documents and develop test cases accordingly
  • Perform integration, functionality and regression testing of the POS Application on both iTouch and MAC OS.
  • Conducted testing of the web based application, which interacts and supports the POS systems.
  • Tested backend Web Services and Applications to ensure security and reliability of information.
  • Used SQL Server 2008 to run SQL queries to verify the data in the database.
  • Interacted with Developers and System Analysts to understand the severity of the defects and assigned priorities to resolve the bugs.
  • Identify, document and communicate issues/defects discovered during test case development and execution in Quality Center and work with developers closely to reproduce them and verify them after they are fixed.
  • Prepared the Daily Test Report with Daily Test Script Status, Bug reports and issues to be discussed in the meeting.
  • Performed System testing and Integration testing
  • Participated in the interview process for the new hires.

Environment: Windows XP/7, .Net, SQL Server 2008, Quality Center, SOAP, XML, MS SQL Server.

Confidential

Sr. Application Test Engineer

Responsibilities:

  • Performed SOA - Functional Testing, Regression Testing, Simulation and validation for web service integration.Prepared test plan and identification of the test data.
  • Defect tracking and reporting by PVCS tracker. Involved in the Development of Test Plan and Test Cases for Integration, Functional, System and Regression Testing.
  • Responsible to gather and review Business, Functional Requirements and Use Case Documents
  • Involved in preparing the test cases for GUI, Functional Testing, Integration Testing, and Regression Testing.
  • Interfaced with developers in resolving the defects investigated in the application during testing.
  • Performed Functionality testing, Regression Testing, Positive/negative testing, system testing, User Acceptance testing and Smoke testing of the Application, its interfaces and Client-Server Utilities.
  • Conducted a wide range of quality tests to ensure dat software meets specified standards and end-user requirements.
  • Function testing of the application using QTP.
  • Wrote VBA macros to ease the testing of End-of-day case reports.
  • Involved in Point of Sale (POS) Testing.
  • Tracked and reported defects through Team Tracker which facilitates workflow issues and helped resolving.
  • Designed and performed negative & positive test cases to cover all validations.
  • Attended review meetings and discussed technical issues with developers.

Environment: ASP.net, Oracle, UNIX, IE7,MS- office, QTP, MS SQL Server 2005.

Confidential

QA Engineer

Responsibilities:

  • Involved in documentation & Scenarios.
  • Gathered requirements and prepared test plans.
  • Wrote test cases based on test plans.
  • Executed those test cases with reference to the functional specifications and business requirements.
  • Modified the test cases for subsequent releases according to the changing requirements.
  • Data verifications using SQL queries with Oracle database.
  • Conducted Testing meetings periodically.
  • Tested the application manually for the functionality and reported the bugs through Bugzilla.
  • Performed System, Regression & Functional testing.
  • Executed system/functional testing of the application by creating and executing the Visual Basic test scripts in QTP.
  • Carefully analyzed the application and implemented synchronization points whenever needed in QTP.
  • Generated reports in excel sheets.
  • Was involved in training new graduates.

Environment: ASP.NET 2.0, SQL Server 2000, Bugzilla, Microsoft office, QTP, Agile.

We'd love your feedback!