Data Analyst Resume
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.