Data analyst Resume
SA
SUMMARY:
- Over all 9 years of experience in all phases of Software Development Life Cycle (SDLC) and Testing Life Cycle.
- Expertise in in Software Testing on Client/Server, Windows based, and Web based applications.
- Experienced in both Manual and Automated testing.
- Experienced in developing Test Plans, Test Conditions, Test Cases, Trace Matrix, and Summary Reports.
- Performed Functional Testing solutions using SOUP UI.
- Tested webservices, XML, WSDL using SOAPUI tool. Modified end points when we worked on different servers and different versions of Web Services
- Expertise in Agile methodology of software delivery
- Experienced in scripting language like Java Script, VB Script and programming knowledge in SQL and PL/SQL.
- Extensively worked with Relational Databases ORACLE, MS SQL, DB2 and MS - Access.
- Expertise using Quality Center/ HP ALM for writing test conditions, writing test cases, requirements traceability, executing test cases and generating reports in each phase of testing.
- Experience in creating management reports in Excel that became company standard for recording financial information.
- Experience in Software Development Life Cycle (SDLC) using the Waterfall Model and good understanding of Agile Methodology.
- Experience in Functional Testing, Performance Testing, Integration Testing and Regression Testing, both manual as well as using automated testing tools including Quick Test Pro, LoadRunner, Performance Center and Quality Center/ HP ALM.
- Experienced to execute Test Cases using QTP/UFT as part of Regression Testing.
- Experienced with Functional Testing, Performance Testing, Smoke Testing and User Acceptance Testing (UAT).
- Experienced on successfully implementing Test Automation as part of Regression Testing.
- Experienced in working with operating systems like UNIX, Linux and Windows.
- Interacted actively with the team in identifying bugs.
- Always worked closely with system users and management personnel and gained reputation of loyalty, quick problem solving skills, excellent teamwork player and communication skills.
- Self-motivated, dedicated and a natural team player with capability to work independently.
- Excellent written and verbal communication skills with strong analytical and problem-solving skills.
TECHNICAL SKILLS:
Operating Systems: Windows and UNIX, Mainframe
Languages: C, C++, JAVA, VB Script,.NET
Host Technologies: LPS/MSP, Attachmate terminal emulation
Database: SQL Server2012, Oracle11g, DB2,Sybase and MS Access
Web Servers: JavaWebServer0, Apache Tomcat
Application Servers: JBoss, WebLogic, IBM WebSphere
Internet Technologies: JavaScript, VBSCRIPT, HTML, DHTML, XML, XSL, XSLT, JSP, Ajax.
IDE / Tools: QTP/UFT12.2, Eclipse, SOUPUI,JIRA, Mercury Test Director, Mercury Quality Center /ALM 12.0, Selenium
Methodologies: Waterfall, Iterative, Agile
Editors: Textpad, VI Editor
PROFESSIONAL EXPERIENCE:
Confidential, SA
DATA Analyst
Responsibilities:
- Crafted and collated data from legacy systems.
- Performed data migration enforcement tasks.
- Executed data migration in coordination with management and technical services personnel.
- Test Scripts Execution/modification of existing scripts.
- Participated and coordinated test case walkthroughs.
- Performed data cleansing enrichment and mapping tasks.
QA Analyst
Environment: UFT 12.02, ALM 12.01, SQL Server 2012, Java, Windows XP, Microsoft Excel, MSP- P2 region -Attachmate Reflection2014 SP1(15.6)
Responsibilities:
- Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions in Excel
- Created and maintain Project Plan, Test Plan, overall Test Strategy document and Test Scripts.
- Prepared Test Completion Report executed Regression Testing, System Testing, User Acceptance Testing (UAT), and Smoke Testing & Functional Testing.
- Created Automation Test Scripts in Test Complete and involved in Automation Infrastructure.
- Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables.
- Analyzed business requirements, system architecture and design.
- Review all Requirement specification docs, Functional design docs for completeness testability.
- Worked on SQL and PL/SQL and performed Backend validations
- Assisting the team while Test Case execution.
- Test Scripts Execution/modification of existing UFT scripts.
- Participated and coordinated test case walkthroughs.
- Developed and executed manual and automated test cases using complex SQL, analyzed results and reported defects in ALM 12.
- Attending weekly test plan/project status meetings and reviews.
- Maintaining and running Regression test cases.
- Involved in Automation Infrastructure Development in Quick Test.
- Managing and Analyzing and prioritizing defect lists and defect resolution. Monitoring progress based upon schedules and requirements.
- Assessing and reporting on the quality and status of testing deliverables.
- Participating in the Weekly Status Conference Call with Onshore Coordinator.
- Coordinating with technical leads for determining when fixes will be promoted to test environments.
- Executed test cases and verified actual results with expected results using the Test Lab feature of Quality Center.
- Updated Requirement traceability matrix
- Documented all phases of QA process.
Billing Support Analyst
Environment: Web Services, ALM 11, Oracle, citrix, ACSR, JIRA, Soup UI, REST, XML, PL\SQL, Windows, Excel.
Responsibilities:
- Executing Backend Testing using SQL queries to extract data from the database.
- Involving in daily walkthroughs and inspection meetings, to verify the status of the testing effort and the project as a whole.
- Import data into Excel from DB. And generate reports for failed accounts standard for recorded information.
- Interacting with the development team to resolve the Technical Issues.
- Identified manual processing deficiencies, and instituted automation techniques which reduced manual labor and increased work flow efficiency.
- Generating the daily reports of execution status and Defect Summary.
- Attended daily status meeting to follow-up and resolve outstanding group issues.
- Assisted in streamlining processes to reduce and make daily workload more efficient.
- Reduced processing time by analyzing job schedules and implementing appropriate modifications.
- Develop and implemented standard operating procedures to bridge data gaps and resolve related issues.
- Communicated with OMA (Order Management Agents) on bridges, chat rooms and using live meeting software to accurately identify problems and investigate solutions software to accurately identify problems and investigate solutions
- Perform Functional Testing solutions using SOUP UI.
- Tested web services, XML, WSDL using SOAPUI tool. Modified end points when we worked on different servers and different versions of Web Services.
- Tracked bugs using Quality Center/ALM and performed Regression Testing of the entire application once the bugs are fixed.
- Inserted verification checkpoints, synchronization points, and parameterized data using QTP.
- Developed test scripts to automate process of testing in Selenium WebDriver.
- Tested Web Services, providing required input data to request XML and validated response XML.
- Worked with GUI clients with different subsystems communicating with the system to troubleshoot problems
- Used OMS/ GUI to understand issues being faced by agents and to help in understanding resolutions.
- Assisted in streamlining processes to reduce and make daily workload more efficient.
- Tested various software enhancement implementations by development team to ensure quality releases and minimize costs to client
- Worked on application performance testing and identified the bottlenecks and implemented the code patches to resolve the issues.
- Performing Manual Testing in accordance with the test plans and test cases.
- Participated in weekly meeting with QA, developers, analysts and management team.
- Participated in bug review meetings on behalf of the QA team
Systems QA Analyst
Environment: QC11.0, SQL Server 2008, MS-Office2007, MSP- P2 region, Java, Windows XP, Attachmate terminal emulation
Responsibilities:
- Preparing Test plan and Traceability Matrix and getting approval from Business.
- Performing System Integration Testing and Regression Testing.
- Involved in complete testing life cycle of the project.
- Prepared status summary reports with details of executed, passed and failed test cases.
- Prepared positive, negative and boundary condition test scenarios
- Working closely with development team to resolve the defects and testability issues.
- Create Test Plans, Test Cases and Test Scripts for modules of the Application Under Test (AUT).
- Reviewed business requirements documents and technical specifications.
- Performed Smoke, System, Functional and E2E tests.
- Interact with Business Analysts to clarify User Design Specifications and functionality of the application.
- Interact with Business Analysts to clarify User Design Specifications and functionality of the application.
- Worked closely with team to create test scripts using IBM Rational Functional Tester, QTP and Rational Manual Tester .
System Analyst
Environment: IBM RFT, QTP 8.2, IBM Rational Test Manager, IBM Rational Requisite Pro, IBM Rational Clear Quest 7.0.1, IBM Clear Case, Html, Oracle9i, MS SQL Server 2000/7.0, SQL, SQL*Plus, XML, FLUX4, SecureCRT4.1 and WinSCP4.1.6.
Responsibilities:
- Execute the test cases using TestDirector and analyzed the results for test case Management.
- Followed up with developers on defects status on a daily basis
- Prepared and executed Test cases as per the system requirements
- Execute the test cases using TestDirector and analyzed the results for test case Management.
- Manage spreadsheets and maintain data currency to ensure accurate data availability for managers and decision-makers.
- Monitored test scripts and status using IBM Rational Functional Tester and Manual
- Written SQL queries to retrieve test data and validate test cases.
- Manually testing each module of the application before automation.
- Executed test cases to compare the actual result with expected results in accordance with business, technical and functional specs of the applications.
