Objective:

Seeking a fast paced dynamic environment to align my professional Software Quality Assurance skills with a progressive company where in the application of my technical education and work ethics that would provide a significant contribution to the company’s continued success and thereby adding value to the organization.

Expertise:

Around 7 years of progressive working experience in Software Quality Assurance and Software Tester with diverse projects, clients and industry.

Prepared documentation such as business requirements, functional specifications and master documents based on business needs.

Experienced in developing Test Plans, Test Cases and Test Script.

Good knowledge of MS Visio and MS Project.

Expertise in using Automated Testing Tools such as QTP.

Good skills for problem solving and Bug Tracking using HP ALM and Quality Center.

Experienced in testing Client-Server and Web-Based Applications.

Extensive knowledge of SDLC (Software Development Life Cycle) methodologies.

Experience in Positive, Negative, Data-driven, Unit, System, Integrated, and Back-End Testing.

Performed Back End Testing by executing SQL queries.

Experience in gathering business requirements, analyzing business requirements and using the information to develop detailed comprehensive test strategies to verify system changes to meet the needs of the client.

Expertise in Performance Testing, Stress Testing, Smoke Testing, Functionality Testing, Load Testing and Volume Testing of client/server and web based applications using different tools.

Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.

Experienced in DW projects ETL testing against DW testing with Informatica, and data stage tools.

Participated in design walkthroughs and verified QC Test Scripts and results.

Experienced in GUI, Regression, and Functional Testing.

Effective Time Management Skills and consistent ability to meet client deadline.

Good team player with the ability to lead, manage and work independently in a time sensitive.

Extensive knowledge of Test Matrix, Traceability Matrix and Gap Analysis.

Experience in performing Black Box Testing on Web-based application.

Analyzed Modification requests and Enhancement requests.

Ability to generate and analyze different kinds of Performance and Summary Reports.

Assisted the Project Manager Plan, Coordinate, and Monitor project levels of performance and activities to ensure project completion.

Excellent communication, presentation, and interpersonal skills.

Technical Skills:

Testing Tools

QTP

Bug Reporting Tools

ALM, Mercury Quality Center, JIRA, Bugzilla

Data Bases

Teradata, Oracle, SQL Developer, MS SQL Server, MS Access, DB2, VB Script

Web Technology

HTML, UML, CSS, XML, Rational Rose, RUP

Operating System

Windows XP,7,8

MS Office Tool

MS Office Suit

Web Server

IIS.

U.S Courts, Washington D.C Jan-2016 - Dec-2016

Position: QA Tester

The JITF was established by Congress in fiscal year 1990 (28 U.S.C. § 612) to assist the judiciary in implementing its automation initiatives. It provides the judiciary with a funds management tool that allows more effective and efficient planning, budgeting, and use of funds for IT activities. The RM staff manages budget formulation, execution, and reporting activities associated with the JITF; coordinating funding for the judiciary’s decentralized office automation programs, local area networks, and the courtroom technologies program. The Department of Technology Services (DTS) Judiciary Information Technology Fund (JITF) budget formulation process has been enhanced and expanded over the past few years, in great part by using a Microsoft Access database. The database is used by JITF allocation holders to enter budget requirements and estimates, and by the Resource Management (RM) staff to generate a variety of reports. In order to enhance the JITF budget processes, the database should be upgraded from Microsoft Access to a web-based application and database management system. The updated model could then be used by other offices with similar budget execution and reporting functions.

Responsibilities:

Participated in setting up testing environment.

Reviewed STM Source to Target Mapping, Business requirement Documents and functional requirements.

Involved in preparing Test Cases and Test Plans based on business requirements.

Examined business requirements and prepared Test Plan and Test Cases accordingly.

Involved in full cycle of system testing activities in terms of data and report’s testing.

Created test data according to business requirements and loaded via sql loader in the test environment.

Extensively involved in Business Objects reports end to end testing to ensure all required functionalities are working as expected.

Performed Positive and Negative Testing.

Created defects tracking document and reviewed it with developers and managers.

Used JIRA (KanBan Board) to track and manage defects.

Documented bugs found out during the process of testing.

Extensively used Business Objects to validate the reports functionalities and data validation.

Wrote queries to validate the data in Oracle DB.

Checked the data flow from front end to backend and used SQL queries to extract the data from the database.

Ensure that product is defect less before moving it to higher environment (Production).

Participated in QA team meeting and bug tracking meetings.

Environment: Oracle 11g, SQL Developer, Toad, SVN, JIRA, SAP Business Objects and MS-Office.

CareSource, Dayton, OH Dec-2014 to Nov-2015

Position: SQA Tester

CareSource is a leading non-profit managed care company based in Dayton, Ohio. CareSource has grown to be the largest Medicaid managed care plan in Ohio and one of the largest in the country, serving more than 800,000 members in Ohio, Kentucky and Michigan.

Responsibilities:

Participated in setting up testing environment.

Reviewed STM Source to Target Mapping, Business requirement Documents and functional requirements.

Involved in preparing Test Cases based on business requirements.

Examined business requirements and prepared Test Plan and Test Cases accordingly.

Performed Integration Testing and Certification Testing (UAT)

Involved RFC (Request For Change) process for all environments (DEV, INT, CRT, PRD)

Responsible for creating and uploading the project artifacts in Share point site and providing release support.

Expertise in Claims, Subscriber/Member, Plan/Product, Claims, Provider, Commissions and Billing Modules of FACETS.

Implementation and knowledge of HIPAA code set ICD-9, ICD-10.

Ensured that EDI files were in compliance with ICD-10 standards.

Performed analysis of ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD-10 PCS conversion compliances.

ETL Testing Data Extract, Input/Output, Relational Databases, XML and Flat Files

Extract, Transform and Load (ETL), Data Warehousing

Ensure that products and changes are fully documented.

Analyzing and documenting detailed program information working and interacting with software developers and members of various other dependent departments

Analyzing User and Functional requirements to point out gaps between used SQL queries to extract the data from the database.

Tested source data for data completeness, data correctness and data integrity

Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.

Involved in data warehouse testing by checking ETL procedures/mappings.

Worked on Data Mapping to map Facets data to outbound eligibility extracts.

Wrote SQL queries to extract and validate the data from the Facets database.

Database integrity testing by executing SQL statements.

Created and maintained SQL Scripts to perform back-end testing on the database.

Environment: Teradata, Server, MS Office, Agile/ Scrum, UAT, HP ALM Quality Center, Data warehouse/Data warehousing

Health Net, Woodland Hills, CA Jan-2013 to Oct-2014

Position: QA Tester

Health Net is among the most respected health care companies in U.S. It has an extensive network of physicians, physician group locations, and pharmacies all working together to serve 2.5 million members.

As QA Tester, involved in testing the Claims application and HIPAA EDI Transactions. The integration between Claims application and other applications like Providers, Eligibility and Member Services application had been tested by using SQL and Quality Center.

Responsibilities:

Examined business requirements and prepared Test Plan and Test Cases accordingly.

Performed Sanity Testing & Smoke Testing.

Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Enrollment Claim Processing and Subscriber/Member module.

Set claim processing data for different Facets Module.

Conducted a session with business, SME and other parties to gather the requirement for the integration of Facets with the providers and other third parties.

Involved in writing SQL queries to check for the data validation.

Authored Test cases for HIPPA EDI Transactions 270/271, 276/277, 837/835.

Tested HIPAA Transactions and Code Sets Standards such as 270/271, 276/277 transactions.

Executed Test cases manually by composing 270, 276 EDI files and dropped inbound and check response 271,277 using interleaves in outbound.

Experienced with External claim editing system on frontend system of Facets.

Extensively worked on all kind of joins and operators to fetch data from multiple tables.

Tested and validated the database tables using SQL queries and Stored Procedures and performed Data Validation and Data Integration.

Set claim processing data for different Facets Module.

Design, analyze and performed Integration and wrote System requirements on different leading health care software’s such as FACETS.

Conducted Validations for different FACETS modules Providers, Claims and Membership.

Conducted Data integrity and Data validation test manually.

Checked the data flow from front end to backend and used SQL queries to extract the data from the database.

Writing PL/SQL Procedures & Batch Processes.

Involved in writing Traceability Matrix.

Performed Positive and Negative Testing.

Involved in testing EDIs according to code set X12 835 Claim Payment & Remittance Advice Claims processing and 837 Claim transactions.

Skilled in executing SQL queries to validate and update database and retrieve data for testing.

Worked on Data Mapping to map Facets data to outbound eligibility extracts.

Wrote SQL queries to extract and validate the data from the Facets database.

Database integrity testing by executing SQL statements.

Created and maintained SQL Scripts to perform back-end testing on the database.

Executing SQL commands performed back-end testing.

Executed SQL statements to check if the data integrity has been maintained.

Created SQL queries for data validation.

Performed manual Back-End testing on the application by writing complex SQL queries.

Wrote INNER, OUTER JOINS to retrieve desired or expected data from tables of database with and without comparison operators to perform Backend testing in QTP.

Participated in the team for User Acceptance Testing.

Used Mercury Quality Center for tracking and reporting the bugs.

Used Mercury Quality Center Project Entity customization to customize fields in the Defects Tab.

Environment: Oracle, MS Office, Agile/ Scrum, UAT, PL/SQL, Windows XP, IIS, Quality Center, JAVA, J2EE, SQL, UNIX, Data warehouse/Data warehousing

BCBS, Durham, NC May-2011 to Dec-2012

Position: QA Tester

BCBS is one of the leading providers of medical, dental, vision, and life insurance services. Company provides solutions to both individual and groups by providing broadest selection of leading health insurance plans.

The system initiates all the necessary procedures, standardizes and validates the data according to HIPAA regulations, and provides error-processing for the transactions that could not be fully processed through the system. The new application also allows the agents to track and manage the status of a health benefit claims.

Responsibilities:

As the QA Tester I was involved in developing and documenting Product Test Plans, using several SDLC methodologies

Assisted in writing efficient and effective Master Test Plan, Test Strategy, System Testing, End-to-End Test and User Acceptance Test Plan

Involved in Testing of HIPAA EDI Transactions (835,837,820,276) in various phases of implementation.

Analyzed HIPAA EDI transactions in XML and X12 responses and of 270 and 276 and looked for defects for amendment.

Did data analysis for various version changes of EDI messages on different sub-systems.

Performed end-to-end System Integration testing which covered the entire business process flow from the initial point of sales through to all the downstream systems and XML output files, including apps/interfaces.

Performed extensive testing of Mapped EDI 4010 provider claim payment/advice/status (835/837/276) from clearinghouse sources to ASC X12 formats.

Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata .

Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.

Strong experience in conducting Functional Testing, Regression Testing, User Acceptance Testing (UAT), and System Integration testing (SIT).

Facilitated Joint Application Development (JAD) Sessions for communicating and managing expectations involved in FACETS Implementation, involved end to end analysis of FACETS Billing, Claim Processing and Subscriber/Member module.

Also worked on claim processing for HIPAA transaction set 837(medical claims) on FACETS.

Worked on Facets Claims Screens and Facets Tables.

Participated in testing various interfaces (Inbound and Out bound) for Facets.

Provided the required test data for the developers in order to fix the defects

Monitored EDI Eligibility/Inquiry/Response (270/271) transactions via reports generated by the developers.

Worked on UNIX Platform and experienced in back end testing by executing SQL Queries.

Checked the data flow through the frontend to backend and used SQL Queries to extract the data from the database.

Involved in writing extensive SQL Queries for back end testing oracle database.

Retrieved files using SQL statements and UNIX commands.

Created and maintained SQL Queries for back-end testing.

Performed manual back-end testing using PL/SQL to connect to an Oracle 9i database on a UNIX server.

Established and maintained test cases and test data in Quality Center.

Logged the defects in Quality Center and maintained track of the defect throughout its life cycle

Participated in QA team meeting and bug tracking meetings.

Environment: PL/SQL, UAT, MS OFFICE, SDLC, AGILE, SQL, UNIX, ORACLE, QUALITY CENTER, QTP, WINDOWS XP, Data warehouse/Data warehousing

Aetna Health Care, Hartford, CT Jan 2010 – April 2011

Position: QA Tester

This is a major health care company makes available various health plans and third-party administrative services for its customers. Aetna offers broad-based, powerful enhancements that, address consumer-driven requirements, Internet selling and self-service, SQL database options, and integrated business intelligence. I was involved in Manual and testing using SQL, UNIX and Quality Center.

Responsibilities:

Participated in setting up testing environment.

Reviewed Business requirement Documents and functional requirements.

Involved in preparing Test Cases based on business requirements.

Extensively worked all Regions Inbound and Outbound Interfaces.

Tested HIPAA EDI Transactions and Code Sets Standards such as 837/835, 270/271, 276/277 transactions.

Conducted Value Analysis, Regression Analysis, and Risk Management.

Tested 837/ 835, 270/271, 276/277 transactions.

Authored and executed Test cases for Claims and Customer Service Workflow by manually.

Performed GUI/ Usability testing manually.

Wrote INNER, OUTER JOINS to retrieve desired or expected data from tables of database with and without comparison operators to perform Backend testing in QTP.

Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in Mercury Quality Center.

Responsible for Back-End Testing Using SQL Commands using TOAD.

Developed SQL queries, functions, stored procedures and triggers to perform the backend testing of the data

Perform functional, exception and scenario testing.

Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using Mercury Quality Center.

Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.

Extensive knowledge of Test Matrix, Traceability Matrix.

Quality Center was used to create the test plan, store test cases and run the test sets.

Provides feedback concerning completeness and accuracy of AUT.

Responsible for performing System and integration testing for release.

Environment: Windows, Oracle, SQL, SDLC, UAT, TOAD, Mercury Quality Center, MS Office, MS-Visio, Data warehouse/Data warehousing

T-Mobile, Bothell, WA Jan 2009 – Dec 2009

Position: QA Analyst

T-mobile is one of the largest wireless companies in the United States, with more than 20 million subscribers who use the digital voice network. T-mobile is dedicated to providing customers with wireless technology designed to enrich their lives.

The project dealt with testing the web based shopping application, called Customer Account Information System (CAIS). Here the customer’s log in to the application and once the customer logs in he can either check amount due and the date the payment is due as well as the minutes he/she is left in that particular month.

Responsibilities:

Analyzed System specifications and helped team members to achieve test goals.

Developed a detailed Test Plan for the testing effort of the User Interface.

Developed Test Cases based on the requirement documents.

Performed Positive and Negative testing manually.

Performed configuration/ compatibility and user interface testing manually.

Have experience designing and writing training manual templates, design formatting, project planning and writing technical documents.

Conducted GUI/Usability Testing and Black Box Testing according to specifications.

Involved in writing complex SQL queries to check the data integrity

Ensure that products and changes are fully documented.

Analyzing and documenting detailed program information working and interacting with software developers and members of various other dependent departments

Analyzing User and Functional requirements to point out gaps between used SQL queries to extract the data from the database.

Tested source data for data completeness, data correctness and data integrity

Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.

Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

Involved in data warehouse testing by checking ETL procedures/mappings.

Performed Smoke and Sanity testing.

Performed Positive and Negative Testing

Performed Security testing and Backend testing manually.

Participated in conducting System testing and End to End testing manually.

Performed Usability and Integration testing manually.

Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.

Documented bugs found out during the process of testing.

Environment: Quality Center, SQL, PL/SQL, Windows XP, MS Office, Agile, SDLC, IIS, UAT, Oracle, MS Visio.

Education:

BS in Computer Science

Mongol Business Institute

Ulaanbaatar, Mongolia

2004 to 2008

Contact this candidate