Qa Analyst Resume
Detroit, MI
OBJECTIVE
- I have over 8+ years of diverse experience in Information Technology with an emphasis on Software Quality Assurance.
- My ambition is to take up a challenging position in the area of Software Quality Assurance and Testing in a progressive, fast - paced dynamic environment that will allow me to align my skills in the organization in the most efficient manner.
SUMMARY
- Over 8+ years of diverse experience in Information Technology spanning 4 projects with an emphasis on Software Quality Assurance, performing Manual and Automated Testing of standalone, client/server and web applications
- Extensive knowledge of various phases of different Software Development Life Cycle (SDLC); models like Waterfall, Agile, SCRUM, RUP, etc
- Experienced in Full life cycle Manual and Automated Testing in Web-based Applications (JAVA, .NET etc), Client/Server Applications, andmainframe applications in Multi-Tier environments
- Extensive knowledge of different kinds of testing like Back-EndTesting, Positive/Negative Testing, Black/White box Testing, Configuration Testing, Data DrivenTesting, Black-box/White-Box Testing, End to End Testing, UnitTesting, Functional, Integration Testing, System Testing and Regression Testing
- Expertise in problem solving and bug tracking using Quality Center, Doors and Rational Clear Quest
- Expertise in querying and testing using RDBMS tools likeOracle, MS SQL server, PL/SQL, DB2, QMF, TOAD, and MS Accessfor Data integrity
- Thorough understanding of Software Development with various programming languages such as, C, C++, Java, .Net, HTML, XML, etc
- Well versed in the Internet technologies and Object Oriented Programs
- Experienced in working with wide range of projects including CMM Level 2 Certified projects by following industry standards and Agile methodologies for Web based, Client/Server, Legacy Mainframe, SOA (SAP, TIBCO) and CRM Siebel applications on Windows, Mac, LINUX, UNIX, etc environments
- Huge exposure to variousbanking, financial, health, retail and data warehouse modules
- Expertise working in Healthcare industry with Insurance, Loans, Claim Processing, etc. Medicaid and Medicare modules as well as Interface Testing and Data Conversion
- Worked with ANSI X12 5010 as well as ANSI X12 4010 including medical transactions such as 837 (medical claims), 835 (medical claim payments), 270 (eligibility inquiry), 271 (eligibility response), 276 (claim status), 277 (claims status response) and 278.
- Strong experience withSOAarchitecture which includeSoapWeb ServiceandRestFul Web ServiceTesting
- Extensive knowledge of gap between HIPAA 4010 and 5010.
- Fluency in web services standards, technologies and tools (e.g. XML,RESTful, etc).
- Excellent knowledge of HIPAA standards, EDI (Electronic data interchange), transaction syntax like ANSI X12, Implementation and Knowledge of HIPAA code sets, ICD-9, ICD-10 coding and HL7
- Involved in various HIPAA and HL7 testing and validation for EDI transactions using 820, 834, 835, 837, 270/271, 267/277, 278
- Expert in analyzing system and functional specifications used cases, Business Requirements and business rules to prepare Test Plans and design Test Cases from business requirements
- Experience in Test automation and Scripting.
- Excellent understanding of Expertise in ETL process, Rational Unified Process (RUP), Unified Modeling Languages (UML) diagrams including Use Case-diagrams, Activity Diagrams, State Diagrams, Sequence Diagrams, Physical Diagram, etc
- Strong working experience in the data analysis, design and development, implementation and testing of data warehousing using data conversions, extraction, transformation and loading (ETL), Informatica, Business Objects, MS SQL server and Oracle
TECHNICAL SKILLS
Testing Tool: WinRunner, LoadRunner, Quick Test Pro, Quality Center/ALM
Test Reporting Tool: Quality Center/ALM, Rational Clear Quest, DOORS
Operating System: Windows 98/2000/XP/NT, UNIX, LINUX
Database: Oracle, MS SQL Server 2005/2008, MS Access, DB2, TOAD, QMF
Testing Language: TSL, SQA Basic, VB Scripting,python
Programming Language: C, C++, SQL, Java/J2EE
Web Technology: JSP, ASP, XML, HTML, .Net
Other: MS Office (Word, Excel, PowerPoint), IBM AS/400, Business Objects, Infomatica, Cybermation, Tortoise SVN, HIPAA, EDI, HL7, MMIS (Medicaid Management Information System), Trizetto Facets, UNIX Nile Server, Networking protocols and fundamentals
PROFESSIONAL EXPERIENCE
Confidential, Detroit, MI
QA Analyst
Environment: Windows XP,TOAD, Mainframes, SQL Server, Clear Quest, Quality Center/ALM, ETLprocess, Ultraedit.
Responsibilities:
- Translated requirements into functional testing scenarios and gained extensive knowledge on membership, enrollment, and claims processing
- Involved in IKA Systems Claims processing and having broad experience with mainframe technologies MVS, DB2 and IMS
- Testing flat file data transfers, ETL data warehouse components and execute test plans, test harnesses and test cases.
- Wrote complex SQL queries in TOAD (Relational DB) to perform Back-End testing. Participated in data analysis for verification purposes using SQL queries, views and procedures
- Wrote and enhanced test cases and test scripts to meet new functional requirements as per the new business requirements for ETL process verifications as well
- Maintained QA lab standards, documentation review assisted in establishing and maintaining best practices for QA and created requirements, test cases, test scripts with specified schedules
- Testing both inbound and outbound in mainframes and prepare analysis document with various results
- Performed User Acceptance Testing (UAT) with all business users and interacted with developers for any bugs found while UAT
- Involved in testing the functionalities of the application and validated against the requirements using Test result analysis and Database testing by performing SQL Queries and Commands
- Interacted with developers, discussed the Business Specifications/Requirements and also the changes and the discrepancies in the application
- Extensively involved for Back-End Testing and related database issues
- Initiate meetings concerning different clients at regular intervals to update them on the progress of the project
Confidential, Boston, MA
QA Analyst
Environment: Windows XP, Oracle on UNIX Nile Server, SQL, UNIX scripting, TOAD, Linux, Remedy Call Tracking System, python, Chairside-Proton diagnostic tool, Rest,Lotus Notes
Responsibilities:
- Review database design and other related documents for better understanding of the application
- Worked on Agile SCRUM approach implementation for the whole testing life cycle for Performance Test
- Fully engaged and mentored the development and management teams in the Agile/Scrum process
- Maintained QA lab standards, documentation review assisted in establishing and maintaining best practices for QA and created requirements, test cases, test scripts with specified schedules
- Responsible for performing computer system validation for new and legacy systems
- Assist clients in the computer systems usage best practices to avoid non-compliance. Also helped in the documentation for the same
- Created templates to be used in assessments of the system
- Conducted Back-End Testing manually for the purpose of Database Integrity
- Used UNIX Nile server to track the problem if the issue occurred in Chairsideor proton
- Written and maintained SQL scripts to accelerate the testing process
- Interacted with programmers to identify and resolve technical issues
- Responsible to take appropriate action using Chairside-proton diagnostic tool when a clinic reports to the help desk any issues with the Chairside application
- Involved in compliance audits of systems, general assessments and risk assessments
- Maintained and systematized the documentation process
- Participated in various meetings, which are done for Enhancement Request and Modification Request of applications, following the client requirements
- Participated in walkthroughs with the management team and developer team
- Coordinated with developers to fix the bugs and maintained bug status up-to-date
Confidential, Livonia, MI
QA Tester
Environment: JSP Servlets, JDBC, MS-Project, MS-Visio, Clear Case, Requisite Pro, Clear Quest, QTP, QC, SQL Server, XML, Jira, Toad, EDI ANSI X12/HIPAA, FACETS, SOAP UI, SharePoint, Business Objects.
Responsibilities:
- Involved in Data Hub Testing which included testing Data Exchange (Demographic & Enrollment Segments) Requirements, Data Management (Reconciliation & Information Management) Requirements and Architecture (Performance, Security & Standards) Requirements
- Created High Level Test Scenarios, Test Cases and Test Scripts for Data Hub requirements as described in RSD (Requirement Specification Documents) and DSD (Design Specification Documents) as well as HIPAA and HL7 regulations like 834, 835, 837, etc
- Created Baseline Database tables to load updated Source Eligibility Data; Created related baseline test scripts in order to test the future releases of the application
- Performed and monitored Daily Data Run process in Cybernation; validated data load using complex SQL scripts execution in Oracle SQL Server
- Validated Eligibility Source Systems data, analyze source system testing and if any testing gaps are identified, created and documents tests for demographic and enrollment records.
- Testing both inbound and outbound, and XML files converted by Biz Talk that were in EDI format and prepare analysis document with various results
- Analyzed and worked with HIPAA specific EDI transactions for claims, member enrollment, benefit enrollment, claims processing, and billing transactions. Worked specifically with 270/271,276/277,837, 834/835.
- Gathered Data Hub requirements and responsible for creating test cases and test scripts under Quality Center Test Plan and Test Lab modules, developed automation test scripts in Quality Center
- UsedSOAPUItool to test SOA based architecture application to test SOAP services andRESTAPI
- Converted entire Data Hub manual daily process to automation process using Oracle Packages
- Responsible for creating Automation Process for Data Hub Reconciliation Testing using Oracle SQL Server; Created Oracle packages and SQL Procedures for Reconciliation Automation Testing
- Extensively involved in Data Hub Back-End Testing using Oracle SQL Server; performed daily process testing using SQL scripts execution and logged test results in Quality Center
- Created and executed test scripts for approved Change Requests, logged their test results and related documentations in Quality Center
- Responsible for defect tracking and bug reporting using Quality Centerinteracted with developers and Business Analysts to discuss and resolve defects
- Verified and validated all the build or release related issues and resolve then through discussion with business analysts with the users approval
Confidential, St.Louis, MO
QA Analyst
Environment: Windows XP, VB, SQL, UNIX Shell scripts, Health Level 7 (HL7), FACETS, HIPAA, EDI, XML, SOAP UI, Quick Test Pro, Quality Center.
Responsibilities:
- Participated in setting up testing environment, including network, configuration, and system set up
- Involved in writing and implementation of the test plan, various test cases and test scripts in Quality Center
- Participated in sessions to define the solution approaches, and identifying assumptions, constraints, Risk Management and issues. Maintained and systematized the documentation process for the Performance Testing Plan
- Gathered requirements and created, executed and documented Test Cases as per requirements in Quality Center
- Tested the Web-services of theSOAusingSOAP-UI.
- Met with the developers and technical content writers on a daily basis to update the test documents
- Worked onXMLtools with various documents for further processing and worked onXMLAPI's.
- Worked with business leaders to translate business requirements and processes into test cases according to FACETS package requirements and subsequent effective FACETS configuration
- Prepared Test Plans and Test Cases based on the functional requirements, HIPAA and HL7 regulations like 834, 835, 837, etc
- Involved in testing Web services with a tool called'SOAP UI'.
- Developed Automation Test Scripts to perform Functionality, Security, UAT and Regression Testing using Quick Test Pro
- Used HL7 and FACETS to receive, store and send HIPAA-standard transactions
- Involved inTriCare programs specification related requirements review meetings and related testing status meetings
- Worked on EDI request transactions (270, 276, 278) and response transactions (271, 277)
- Also, conducted different Functionality and Data Testing for the extracted data using FACETS
- Conducted Back-End Testingmanuallyalso or the purpose of Database Integrity. Also, involved in Back-End Testing using SQL and UNIX scripting
- Defect tracking and bug reporting usingQuality Center
- Conducted result analysis and interacted with developers to resolve bugs
- Interacted with developers, business analysts and discussed technical problems and reported bugs
Confidential
QA Analyst
Environment: Windows XP, VB, Teradata SQL, UNIX Shell scripts, MainFrame system, ETLprocess, Infomatica, Quality Center.
Responsibilities:
- Created and managed requirements in Quality Center.
- Evaluated, modified and enhanced the existing quality methods and processes according to Agile methodology
- Maintained QA lab standards, documentation review assisted in establishing and maintaining best practices for QA
- Implemented the whole life cycle of QA methodology starting from planning, capturing, creating, executing reporting and tracking the defects
- Used Health Level 7 (HL7) asa communication protocol among different applications and for data exchange
- Thoroughly understand the HIPAA Title I and II rules to create the secure health plans for the customers
- Wrote and enhanced test cases and test scripts to meet new functional requirements as per the new business requirements for ETL process verifications as well
- Performed ETL data validation using Ms Excel and Informatica
- Used TeradataSQLqueries on database tables
- Used UNIX shell scripts for monitoring the servers during testing sessions
- Created and maintained Teradata SQL functions and UNIX Shell scripts to perform Back-End Testing on the Teradata RDBMS database
- Performed User Acceptance Testing (UAT) with business users
- Analyzed test results using reports and graphs generated in Quality Center
- Troubleshoot new releases issues. Worked with Release management to ensure a smooth turnover to operations and production support
- Participated in various meetings meant for enhancement and modifications of applications, following client request