Objective

• To obtain a position as a software quality assurance engineer in a fast - paced technology company with varied responsibilities and the potential for advancement.

SUMMARY

• Over 6 years of experience in Quality Assurance and Software Testing in Healthcare Industry.
• Excellent skills in writing Test Plans and Test Cases
• Proficient in manual Testing on Windows environment.
• Very good experience in Back-End Testing using SQL on Windows platform to validate the consistency of data.
• Strong Knowledge on MS Office suite, MS Visio, and MS Access.
• Proficient knowledge in various types of Software Testing such as Unit testing, Integrated testing, System Testing, Black box testing, Positive Testing, Negative testing, Performance Testing, Stress Testing, Load Testing, Volume Testing, Data Driven Testing, Back end Testing and Regression Testing.
• Experience in HIPAAEDItransactions 837 (Institutional/Professional), 835(Payment Remittance Advice) 270 (Eligibility Request) / 271 (Eligibility Response), 276 (Claims Status Inquiry Request) / 277 (Claims Status Inquiry Response), 834(Benefit Enrollment and Maintenance Transaction), 278 (Prior Authorization), 997 (Transaction Acknowledgement
• Good working knowledge of major Operating Systems such as Windows 98, 2000, XP, Vista, 7 and UNIX
• Excellent communication and writing skills with the ability to adapt to new and dynamic environments
• Good team leader, Player and can work alone with minimal or no supervision.
• Ability to multi-task, prioritize and work with time constraints while paying attention to details
• Good problem-solving, judgment, and decision-making skill.
• Expertise in querying and testing using RDBMS tools like Oracle, MS SQL server, DB2, for Data integrity.
• Profound understanding of insurance policies like EDI transaction codes such as EDI 834(inquire/response health care benefits), and EDI 834(Benefit enrollment), (Payment/remittance advice), 834(Health care claim).
• Good Background in database, Installed, configured, and managed SQL Server.
• Developed complex SQL queries based on business requirements.
• Designed and developed customized databases for various government departments.
• Experienced in system and application testing
• Developed complex stored procedures, triggers, functions, indexes, tables, views, SQL joins and other TSQL code to implement business rules.
• Hands on experience in designing and implementing companywide SSRS report templates.
• Excellent experience in developing SSRS reports with functionality such as Drill Down, Drill through, and Parameters.
• Installed, configured and maintained SQL Server 2005/2008/2008 R2/2012.
• Upgraded databases from SQL Server /2008R2 and 2012.
• Created database objects includi8ng tables, views and functions.
• Developed procedures for implementing application functionality at the database side for performance improvement.

TECHNICAL SKILLS

Testing tools: Win Runner, Load Runner, QTP, Test Partner, Rational Team Test

Testing tools: HPALM,/ QC, Selenium

Testing Languages: TSL, SQA Basic

Database& programming languages: SQL Server, Oracle, DB2, Java

Web technology: HTML, XML, JSP, UML, .NET

Operating system: Windows95/98/XP/NT/2000/windows 10, UNIX, MS-DOS

Business Modeling Tools: MS Visio, Power Point

Modeling Diagrams: Use Case Diagrams, Data Flow Diagram, Deployment Diagrams

RDBMS: SQL Server 2000, 2005, 2008 and 2008R2 2012

Languages: VB.NET, C#, C++, T-SQL

Applications: MS-Office Tools

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

QA Analyst

Responsibilities:

• Worked for Version document with SME. Primary Liaison between Business User and development Team.
• Responsible for backend testing like Database Backup, Recovery and performance and individual projects like product-change notifications and service releases.
• Conducted GUI and functionality testing using QTP.
• Used SQL Queries and PL-SQL Procedures to perform database testing
• Assisted Project Manager and User managers to conduct Market Research and Feasibility Studies, and to develop Scope/Vision Documents.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Responsible for attaining HIPAA EDI validation from Medicare, Medicaid and other payers of government carriers.
• Determine the amount of coverage a customer should receive for Medical claim or Hospital claim according the procedure done and the coverage on the account.
• Managed and executed the test process, using Agile Methodology.
• Performing Backend Testing extensively by writing validation queries on DB2 database.
• Performed extensive Backend Testing of data validation of applications using SQL queries.
• Prepared Test Cases based on business requirements and business rules for HIPPA EDI Transaction 834 & 820.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Stay in constant contact with medical facilities providing service to determine accuracy of Medical claims being made.
• Meet with customers to discuss results of medical claims, explaining the process and outcome.
• Research current and new medical processing laws and regulations at both the state and federal level.
• Filed medical claims made by customers by entering and organizing data and inputting all information into the computer system.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Back-end testing of the database by writing SQL & PL/ SQL queries.
• Developed test scripts for the Backend testing for EDI 834(both outbound- enrollment and inbound- eligibility).
• Verifying Healthcare Eligibility, Claims, Benefit and Service using ANSI ASI X12 Standards.
• Involved in Backend Database manual testing in Oracle using SQL.
• Monitored the compliance mapping of transactions to the EDI transactions standards ANSI -X12.
• Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing using Mercury Test Director.
• Developed User Manual and Provided User Training.
• Conducted User Acceptance Testing.
• Extensively used SQL scripts/queries for data verification at the backend

Environment: RUP, UAT, UNIX, Java, Microsoft Word, Agile, Oracle, Excel, PowerPoint,DB2, ASP.Net, SQL, MS Visio, Microsoft Office suite.

Confidential, Boise, ID

QA Tester

Responsibilities:

• Testing both inbound and outbound, and XML files converted by Biz Talk that were in EDI format and prepare analysis document with various results
• Participated in development of Functional test plans, test cases, test strategy and estimation of test duration.
• Involved in the testing of web portal of NewMMISsystem
• Worked on Web Services and Tested XML data for validity. As part of Web Testing used SoapUI for verifying Request-Response data.
• Performed backend testing for data validation using SQL Queries. Used SQL Queries to find out test data and validation through DB2.
• Compliance check of various transactions (270/271, 834, 835, and 837).Performed End to End testing on EDI 837 I and P, 834 transactions.
• Did the Backend Testing by running the SQL Queries in DB2 Database.
• Ongoing membership maintenance load programs, input files being both Proprietary and HIPAA 834 file formats.
• Vendor outbound extract programs, files being in both Proprietary and HIPAA 834 formats.
• Worked with HIPAA Team for RIMS Companion Guide of X12 ANSI 270/271 and 276/277 Companion guides for Professional and Dental claims.
• Cross-functional team member in the implementation of the ANSI X12 involving 837 HIPAA compliance and 835 Remittance Advice.
• Used SQL queries to validate the data between the backend and the front end
• Used Process log browser to view different types of log history files to figure out issues with 834 transactions.
• Analyzed 824 and BRR reports to find the issues with 837 I and P, 834, and 820 transactions.
• Co-ordination of front-end changes in multiple development and testing environments.
• Reviewed Test Strategy and Test Plans to ensure that they reflect and include all functional, Performance, Usability and Security requirements.
• Used MS SQL Manager Studio 2005 to query the MS SQL database.

Environment: MS SQL Server 2005, RationalRequisitePro, Rational Clear, DB2, Soap UI, Java, Quest, Rational Manual Tester, Rational Test Manager.

Confidential, Jacksonville, FL

QA Analyst

Responsibilities:

• Analyzed the existing business scenario and understood the business rules.
• Performed smoke, functional, integration and regression testing of the website.
• Involved in Testing ofEDI834 Transactions in various phases of implementation.
• Manual Testing for checking the flow of the application functionality.
• Created and worked with Data requirements for various testing purposes.
• Investigated application bugs, reported & tracked testing process in the bug tracking using Quality Center.
• Frequently communicated with developers and senior QA team members to assist in the clarification of technical issues.
• Wrote complexSQLscripts in DB2 fortestingdata quality and validation.
• Involved with backend testing of the SQL database and verified the EDI data transactions going fine in the database.
• Did data analysis for various version changes ofEDImessages on different sub-systems.
• Performed Database testing using SQL queries.
• Performing Backend Testing extensively by writing validation queries on DB database.
• Performed backend testing for data validation using SQL Queries.
• Executed SQL statements to test the integration between application and database
• Executed SQL queries to retrieve data from tables and to create views and perform backend testing

Environment: Windows, Oracle, Share Point, SQL, Quality Center, MS Office, DB2, MS-Visio, UML

Confidential, Denver, CO

QA Analyst

Responsibilities:

• Involved in preparing Test Plan and Test Cases based on business requirements.
• Wrote Test Cases based on Technical Specifications, Functional Specifications and Business rules for online application system.
• Developed DB2 Queries to retrieve or create test data from different Test databases.
• Developed SQL Scripts for Backend Testing to ensure that the data is updated as per the Business Rules.
• Authored and executed Test cases manually for Tiered Benefit and mapped from website to PMHS.
• Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and Technical Specification in Excel and exported them in Quality Center/Test Director.
• Performed Integration Testing, System Testing and Regression Testing.
• Logged errors reported defects, determined repair priorities, did regression testing and close by using Quality Center.
• Executed Detailed and Risk Based testing for New Functionality.
• Documented and tracked Defects in Clear Quest.Retested fixed defects and approved code fixes.
• Used SQL Plus to query the oracle database
• Conducted functionally and Regression testing during the various phases of the application using Rational functional tester.

Environment: Windows XP, QTP, XML, SOAP, Quality Center, SQL, Oracle, DB2, UNIX, ASP.NET, and VB.NET, MS-office.