We provide IT Staff Augmentation Services!

Data analyst Resume

3.00/5 (Submit Your Rating)

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.
Confidential, PA

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.
Confidential, Philadelphia (PA)

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
Confidential

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 .
Confidential

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.

We'd love your feedback!