We provide IT Staff Augmentation Services!

Qa Analyst Resume Profile

Jessup, PA

OBJECTIVE:

To obtain a challenging position as a Software Quality Assurance Analyst and add value to a fast-paced technology company, by utilizing my proven Technical, Interpersonal, Analytical and Documentation skills, abilities and my diversified experience in software quality assurance, to ensure the company's sustained growth and continued success.

PROFESSIONAL SUMMARY:

  • Over 5 years of experience in manual and automation testing on web based, Client/Server and data warehousing applications.
  • Performed planning and development of Test Plans, Test Cases and Test Scenario to meet product's business requirements.
  • Over 3 years of experience in software testing process which Test Planning, Test Cases Design, Test Environment Setup, Test Data Setup, Defect Management, Test log, Test results, Test Traceability Matrix and Test Metrics.
  • Strong communication and interpersonal skills and proven ability to test with minimum software specifications.
  • High proficiency in Scheduling and Managing resources and activities in QA Team. Ability to work in a team as well as independently.
  • Expertise in Data warehouse and Data mart implementations including requirements gathering, planning, dimensional modeling using Star and Snow flake Schemas
  • Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
  • Good Experience on Selenium IDE and creating Scripts in selenium -RC by using Java.
  • Good Experience with Selenium 2 with Java, TestNG and Junit Framework.
  • Good experience with Ruby Selenium WebDriver.
  • Good Experience with Designing Selenium automation frameworks from scratch
  • Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
  • Tested the ETL Informatics mappings and other ETL Processes Data Warehouse Testing
  • Expert knowledge of Business Analysis methodologies and iterative Systems Development Life Cycle SDLC Agile, Scrum, Waterfall, etc.
  • Extensively executed SQL queries on SQL Server and Oracle database in order to validate the data.
  • Strong knowledge of using Single and Multiple protocols in Loadrunner Vugen like Web Http, WebSevices, Ajax Tru Client.
  • Over 3 experience in working with open source tools Selenium Selenium IDE, Selenium RC, and Selenium 2 WebDriver .
  • Excellent working knowledge of Oracle 10g/9i, MS Office, TOAD MS SQL Server 2000.
  • Participated in UAT and wrote Test Cases for UAT.
  • Experience in testing Web-based Java, .Net applications , Mobile Testing, Data warehouse and Client-Server applications on different environments.
  • Created various Scenarios using Load Runner Controller.
  • Implemented Sanity Testing, Smoke Testing, White Box testing, Black Box Testing, GUI Testing, Functionality Testing, Positive and Negative Testing, System Testing, User Acceptance Testing UAT and Regression Testing of Web Based Applications and Client-Server Applications.
  • Experience in Enterprise Defect tracking tools like HP Quality Center, JIRA
  • Maintained the Requirements Traceability Matrix RTM , Test Matrix and also performed Gap Analysis.
  • Professional expertise in MS Office and MS Project.
  • Ability to quickly understand and interpret business requirements.
  • Participated in Walkthroughs and Inspection meetings to review Test scripts and results.

TECHNICAL SKILLS:

  • Operating Systems: Windows 98/2000/XP, Windows NT/2000, UNIX
  • Testing Tools: HP Quality Center, QTP, Load Runner and Selenium, SOAP UI.
  • Mobile Devices OS Apple iPhone SDK, Apple iOS V4, V5 , Android SDK 3.0, 4.0
  • Reporting Tools: Quality Center, JIRA, MS Project Manager, COGNOS, INFORMATICA
  • Databases: Oracle, MS SQL Server, MS Access
  • Web Technologies: HTML, XML, JAVA Script, VB Script
  • MS Office Tools: MS Office, MS Visio, MS project
  • Programming Languages: C, C , Java, SQL, VB, VC

PROFESSIONAL EXPERIENCE:

Confidential

Position: QA Analyst

Confidential is in the business of business process outsourcing BPO . The company is a fast-growing provider of BPO services to health plans and insurers nationwide that need help with Medicare and Medicaid management. TMG Health provides both administrative services and computer-systems integration to help organizations deliver public health benefits to its enrollees. It offers billing, claims processing, data management, enrollment and eligibility processing, and support marketing services to more than 30 health plans nationwide. TMG Health was founded in 1998. It is now a part of Chicago-based Health Care Service Corporation HCSC . As a QA Analyst I am involved in testing various applications such as .

Responsibilities:

  • Analyzed Business Requirements and prepared Test Plans
  • Reviewed the Business Functional Requirements and Solution Design Documents.
  • Designed, scheduled and executed test plans within the predefined timeframe.
  • Performed Functionality and Data driven testing manually.
  • Designed, communicated, and enhanced QA/testing plans for the Application
  • Executed SQL statements to check if the data integrity has been maintained.
  • Executed SQL statements to test the integration between application and database
  • Performed negative and positive testing using SQL Queries
  • Various tests like Smoke tests, functional tests, Integration tests, regression tests, and user acceptance tests were performed.
  • Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
  • Involved in Testing Web Services using SOAP UI.
  • Performed backend testing using UNIX commands.
  • Extensive use of UNIX shell scripts to perform the database/backend testing
  • Used SQL queries and UNIX script to validate the data between the backend and the front end
  • Conducted Backend testing writing extensive SQL queries.
  • Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members.
  • Tested the ETL Informatica mappings and other ETL Processes Data Warehouse Testing
  • Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX shell scripting.
  • Involved in writing SQL statements to create test data for test cases and data validation tests to extract data from the tables.
  • Extensively used Load Runner for generating the automated test scripts.
  • Developed Base line scripts in order to test the online transaction of the application.
  • Analyzed User Requirements attended Change Request meetings to document changes and implemented procedures for test changes.
  • Logged the defects using the defect module in QC
  • Customized Quality Center to suit the requirements of testing effort
  • Monitored the Defect Tracking Process and generated customized graphs and reports for the client using QC

Confidential

Position: Sr. Quality Engineer

Working Assets Funding Service is a telecom company with a progressive political conscience. The company resells long-distance and mobile phone service under the CREDO brand names and donates 1 of customers' charges to groups such as Greenpeace, Amnesty International, and Planned Parenthood. It also offers a credit card that donates 10 for each transaction to not-for-profit groups. Laura Scher, Michael Kieschnick, and Peter Barnes founded the company in 1985 as a spinoff of the Working Assets money-market fund. Since its inception, Working Assets has raised more than 60 million in donations for progressive groups. My project involved in testing the enhancements on Sprint Wireless enrollment billing application.

Responsibilities:

  • Prepared Test Plan and Test Cases according the business requirements.
  • Analyzed the user requirements, functional specifications and Use Case documents and created the Test Plans, Test cases for Functional testing.
  • Experienced working with business analysts, developers, management and end users in a cross functional Agile Scrum team.
  • Performed Functional, Negative, Positive, Integration, Regression, End to End and User Acceptance Testing.
  • Involved in preparing QA sizing document and QA Sign Off document based on the Test Plan approved by the Project Manager, QA lead and developers.
  • Developed test cases after analyzing the specifications document.
  • Writing test cases to test the Performance of the application manually.
  • Conducted Functionality and Regression testing during the various phases of the application.
  • Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
  • Execution of test scripts using Selenium.
  • Worked with System Administrator closely in setting up QA and testing environment
  • Involved in the gathering of Business Requirements, Functional and System Specification.
  • Created Test cases and Test matrices for integration and system testing.
  • Validated web services using SOAP UI.
  • Worked on Test scenarios for GUI, Functionality, Security, Database and Regression Testing
  • Performed usability testing and Back End Testing manually.
  • Created Rendezvous points to create intense Virtual user load on the server, configured the scenarios before executing them in Load Runner.
  • Prepared Test Cases, Vugen scripts, Load Test, Test Data, Execute test, validate results, Manage defects and report results
  • Used SOAP UI, WebLogic ANT task to test Web Services running on WebLogic Server.
  • Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
  • Used Altova XML Spy for comparison of XML Files.
  • Coordinating with Lead in gathering requirements, tasks and updates on the project.
  • Created and executed Manual Test scripts to verify complex system requirements and database testing. Transaction Verified through Data Verification of Backend Database using SQL Queries
  • Used various techniques like Ramp up, Ramp down, Transaction Point in Load Runner.
  • Performed Manual Testing for Screen Navigation.
  • Created and maintained test matrix and tractability matrix.
  • Reported problems/bugs found using Quality Center
  • Wrote Test scripts for the Data Integrity Testing and Back End Testing
  • Conducted result analysis and interacted with developers to resolve bugs.
  • Participated in the walkthroughs and project meetings.

Environment: HP Quality Center, Load Runner, SOAP UI, Selenium, Windows 2000/XP/VISTA, Oracle SQL, XML Spy, WebSphere Application Server, Agile, Scrum.

Confidential

Position: QA Analyst

Confidential is a wholly owned subsidiary of Montefiore Medical Center. Emerging Health IT, a healthcare IT consulting and professional services company, is a dynamic organization that provides hospitals and medical centers with world-class healthcare information solutions. We provide an exciting, fast-paced environment in which dedication and innovation are rewarded and where individuals can make a difference in the lives of patients. Join us in our mission to improve the quality of healthcare through advanced IT solutions Emerging Health IT is located in Yonkers, Confidential project involved in implementing testing an interface called JIVA and CCMS that will manage the customer's health condition and their health plan and coverage's.

Responsibilities:

  • Responsible for the execution for the project life cycle, including requirements gathering, design, testing, implementation and documentation, as required.
  • Executed test cases found errors reported defects, determined repair priorities, did regression testing and closed by using HP Quality Center.
  • Customized Quality Center to suit the requirements of testing effort.
  • Monitored the Defect Tracking Process and generated customized graphs and reports for the client using QC.
  • Organized and conducted extensive JAD sessions with users to identify and understand requirements.
  • Created documents that incorporated both the technical and functional details.
  • Initiated test plans, develop and execute test cases and scenarios worked with users to develop specific acceptance criteria and prepare test exhibits.
  • Performed Positive and Negative Testing Manually.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Involved in ETL process testing using Informatica ETL tool.
  • Provided reports and other documentation on projects to client and internal staffs, as needed.
  • Created effective Mapping Document to support interface mapping.
  • Tested the ETL mappings from Source to Target.
  • Maintained accurate eligibility records for individuals and/or assigned employer groups
  • Authored test case scenarios in Excel spread sheet and export them into Quality Center.
  • Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.
  • Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
  • Used Teradata utilities MLOAD FLOAD to load the source files in to test region. And did the querying on the same data.
  • Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
  • Responsible for doing the gap analysis for the interfacing system.
  • Tested the mapping and integrity of data populated in the database using SQL scripts in SQL plus.
  • Performed validation using PL/SQL, Worked with UNIX shell scripts extensively.
  • Processed all enrollment, plan changes and disenrollment transactions
  • Responded promptly to customer inquiries relating to members' eligibility status.
  • Facilitated requirements gathering activities, including meeting with users to discuss System Task Requests STRs ,
  • Created and maintained SQL Scripts to perform back-end testing on the oracle database.
  • Wrote complex SQL queries to perform the Back End Testing of the Oracle database using SQL.
  • Performed Security Testing on the application.
  • Authored test case scenarios in Excel spread sheet and export them into Quality Center.
  • Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.

Environment: HP Quality Center, MS Office, Windows 2000/XP, Oracle, SQL, SQL Plus, UNIX Oracle SQL, XML.

Confidential

Position: Sr. QA Analyst/Data Analyst

Confidential is the largest health insurer based in Confidential serving nearly 3.4 million people with over 92,000 providers in 150,000 locations across the tri-state region. Emblem Health's Care Management System provides a solution in simplified and a smart way to manage the health of members, which improves the quality and affordability of care. I was involved in implementing projects in Claims adjudication. My project involved upgrading the claim submission process based on new rules and changes provided by the state. Responsibilities:

  • Created documents that incorporated both the technical and functional details.
  • Defined data mapping rules and created source data for the Data stage ETL.
  • Performed Unit, Integration, Smoke, Functional, Regression and system testing.
  • Used Quality Centre for preparing the Test Plans and manual Test scripts.
  • Reported Defects using Quality Centre.
  • Used SQL queries and utilities to transfer data and databases between different Test environments that are located on different Servers.
  • Supported the extraction, transformation and load process ETL for a Data Warehouse from their legacy systems using Informatica.
  • Worked on different claim types like COB Benefit claims, Q-care claims, Medicare claims.
  • Involved in creating documents and diagrams for Membership Enrollment according to the HIPAA 834 Compliance Standards for Membership Enrollment.
  • Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
  • Enrolled members through online screens and 834 Transactions to Facets.
  • Modified the 834 file and then checked if the eligibility enrollment is properly loaded onto Facets.
  • Involved in testing the Pharmacy claims and Hospital Claims.
  • Involved in testing the Medical and Dental claims.
  • Checked database and with application queried result is being equal, SQL queries is being extensively used to check the data from the data base using Toad.
  • Tested the Members, Providers, Facets Workflow and Claims in Facets.
  • Ability to work from functional Specifications to write test plans.
  • Performed backend testing using SQL queries and verified data Integrity.
  • Recommend opportunities for reuse of data models in new environments.
  • Documented requirements using Use Case UC analysis for the development team. Also, stored the documentation in a common SharePoint Repository for version control.
  • Performed data analysis and data profiling using SQL and Informatica on various sources systems including Oracle and Teradata.
  • Worked on Data Mapping to map Facets data to outbound eligibility extracts
  • Wrote complex SQL queries to extract and validate the data from the Facets database
  • Analyze data-related system integration challenges and propose appropriate solutions.
  • Develop data models according to company standards.
  • Bug reporting using HPQC.
  • Worked with the Developers and the Test Lead to verify the Test Cases.
  • Designed and Analyzed Test case design document basing on the Functional Requirement Specifications to implement through testing process.
  • Functioned as a back-up for other Eligibility Analysts as needed, completing tasks timely and accurately.
  • Entered numerous claims for testing purposes to ensure accurate and quality adjudication and implementation of business and operational requirements.
  • Wrote complex SQL queries to perform the backend testing of the Oracle database using PL/SQL developer.
  • Data mapping of project data elements to existing systems.
  • Analyze data and perform gap analysis.
  • Worked on Data Mapping to map Facets data to outbound eligibility extracts
  • Wrote complex SQL queries to extract and validate the data from the Facets database

Environment: HP Quality Center, Windows 2000/XP, Oracle SQL, QL server SSIS, SQL server SSRS, PL/SQL, Toad, XML, XSD, XML Spy XML/HTML

Confidential

Position: Software Quality Analyst

Confidential provides a full range of advanced broadband services and solutions to business organizations and individuals including Charter Business Internet, Charter Business Phone and Charter Business TV in Digital Entertainment Programming. I am involved extensively in testing on-line Interfaces charter.net, CSR Customer Service Representative and SPM Service Profile Manager . Both these modules are integrated, for creating and maintaining customer accounts and adding relevant charter services I am also involved in Mobile Application Testing where I am testing two different Mobile applications Charter Cloud Drive and Charter Mobile App .

Responsibilities:

  • Developed and execute test cases, test scenarios and followed-up defects.
  • Involved in preparing test plans and test cases based on system and business requirements.
  • Prepared the Test Plan and Test Cases based on the functional specifications.
  • Created and Maintained test Requirements in Quality Center
  • Experience in Provisioning and Unprovisioning Modem.
  • Extensive knowledge in troubleshooting modems.
  • Used Apache Axis utility to generate client for Web Services, executed Web Services using Eclipse Java IDE and SOAP UI.
  • Documented defects in JIRA General Access JRA and helped DIA team developers to identify the performance issues and modules to be fixed.
  • Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
  • Implemented system tests of STB hardware, STB software, audio / video test resources, conditional access, and security.
  • Involved in SOAP and Restful web services using SOAP UI, axis client.
  • Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using PVCS tracker, QC and Rally.
  • Prepared Test Plans and Test Cases for both positive and negative scenarios and mapped to testing requirements in Quality Center.
  • Record and run tests using QTP.
  • Installed, configured SOAP UI to test web services using WSDL file given by Development team.
  • SQL Query testing for Address Book and Cisco IPMA testing.
  • Extensive Knowledge and experience in Mobile Application Testing.
  • Installed and Validated the applications on Apple iPhone Android Family Samsung, LG, HTC
  • Studied User Requirement Specifications URS and converted them to Functional Requirement Specifications FRS and Software Requirement Specifications SRS for application modules.
  • Used Quality center to import test data, keywords, and test cases.
  • Performed Positive and Negative testing manually.
  • Performed Mobile Testing and Automated Mobile Simulator using QTP
  • Performed Usability, Functionality, regression, positive and negative Adhoc, Interruption, VIP, API, STB Motorola vip 1200 , VOD functionality, Network testing wifi, 3G, Offline Mode , DVR, provision-testing U100-U400 , Master a/c as well as sub a/c.
  • Conducted STB end-to-end system integration testing using digital video broadcast system comprised of video encoders, multiplexers, conditional access module, and video-on-demand server to validate new or upgraded features and/or functions prior to full deployment
  • Bug reporting, tracking and documentation on the Bug tracking System using Quality Center.
  • Analyzed the results of manual and automated tests.
  • Performed GUI/ Usability Testing.
  • Participated in daily defect tracking conference calls with developers and DIA team.
  • Participated in requirement walkthroughs and creation of test plan.
  • Conducted Gap Analysis to ensure all Business Requirements were covered by test cases.
  • Performed Sanity Testing and Smoke Testing.
  • Interfacing with developers to resolve the technical issues.
  • Attend meeting with Marketers to perform Usability Testing.
  • Developed strong working relationships with key business and IT decision Makers
  • Responsible for coordinating, facilitating, troubleshooting, and maintaining the overall integrity of the production environment.

Environment: HP Quality Center, SOAP UI, JIRA, Android All Devise , Windows 2000/XP, Oracle SQL, XML/HTML, iOS4/5, Android 2.2, Black Berry OS 7.0, HTC evo, google , Tablet editions iPad, Samsung Galaxy , Windows based OS smart devices

Hire Now