SUMMARY:

• Five plus years of experience in Software Quality Assurance with extensive knowledge in testing both web based and client server applications.
• Well versed with various SDLC methodologies like Agile & Waterfall and supporting the testing efforts during the various phases of the project.
• Expert in Manual and mid - level Automated Testing using tools like HP Quality Center-ALM, Quick Test Professional and SoapUI to verify SOAP based web services.
• Designed and executed SQL queries to extract the needed test data and validating the data accuracy.
• Validated the extraction, transformation and load (ETL) process for a Data Warehouse from their OLTP systems using Informatica.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Experienced with Test Management and documentation like writing Test Plans, detailed Test Cases, Collection of the required Test Data and publication of Test Results and Traceability Matrix.
• Experienced in Defect Management, communicating the status of the defects and determining the readiness for Product Owner or User verification using tools like JIRA and HP Quality Center-ALM.
• Played an active role in Defect Triage meetings and generated various reports to update the status to the management. Used Confluence to document the known issues, lessons learned and best practices for future .
• Experienced in working with cross-functional teams like Web-Services, Mobile and coordinated the test effort.
• Tested applications on mobile devices like iPhone, iPad and in multiple versions of iOS.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS:

Languages: HTML, SQL, XML, VB Script

Databases: Oracle/SQL

Platforms: Windows XP/2000/7/NT, UNIX, iOS

HP Quality Center: ALM, HP Quick Test Professional, Jira, Confluence

SoapUI, Altova XML: Spy, SQL Developer, MS SQL Server Management Studio, Informatica.

Browsers: Internet Explorer (IE), Google Chrome

Others: MS Office (Word, Excel, PowerPoint, Outlook), iPad, iPhone

PROFESSIONAL SUMMARY:

Confidential, Chicago, IL

QA Analyst

Responsibilities:

• Working directly with the client SME and developers to create the test plan, test scripts and test execution.
• Analyzing the test EDI 837I and 837P files and modifying them appropriately to create different test data scenarios to validate various business rules of the application.
• Experienced in working with 999 (Acknowledgement), 277CA (Accepted with errors), 278 (Authorization Request and Response), 835 (Claim approval with EOB) type EDI transactions.
• Possess good understanding of eligibility enquiry (270) and response (271) type EDI transactions.
• Have worked with edit codes to validate HIPAA compliance of the application.
• Experienced in working with ICD10 and HIPAA (5010).
• Experienced in working with Secured FTP client and SQL Database.
• Experienced in analyzing audit trails at database level for various audited transactions within the application.

Environment: .NET, Practitest Test Management Tool, Microsoft SQL Server Management Studio, Microsoft Office Suites, FileZilla SFTP, SQL Database.

Confidential, Northbrook, IL

QA Analyst (ETL)

Responsibilities:

• Participation in Business requirements review meetings and identification of key scenarios for functionality testing.
• Writing Test Plan, Test Scenarios, Test Cases and Test Matrix documents analyzing the Use Cases and updating the Traceability Matrix to check the coverage analysis.
• Good understanding of application build cycles and following the required test strategy to meet the testing requirements.
• Responsible for manually testing the entire application for GUI, Functionality, Business Logic and Use case adherence.
• Defect Reporting, Tracking and interacting with the development team and the real-time users to implement the entire Test Management process.
• Used HP Quality Center-ALM for writing test cases, reporting and tracking defects and test management.
• Used SQL Developer for extracting the required data related to testing, test data set creation and data validation.
• Used SoapUI to verify SOAP based web services.
• Tested the website on mobile devices like iPhone and iPad.
• Worked with on-site and off-shore resources and supported UAT testing.

Environment: Java, Hibernate, Spring, JSON, JQUERY, AJAX, S, Oracle, SOAP UI, HP Quality Center -ALM, Confluence, MS Office Suites, XML-Spy, iOS, Informatica.

Confidential, NY

QA Analyst

Responsibilities:

• Reviewed and analyzed Business Requirements, Project Plans, Prototype, Flow Diagrams, Use Cases, System Design documents and created Detailed Test Cases.
• Prepared traceability matrix to map the requirements against the test cases and validated the test coverage analysis.
• Experienced in reviewing and analyzing raw data of EDI 837 transactions as per HIPAA based transactional 5010 formats to triage incidents caused due to data discrepancy between the provider, TPA and claim processing system.
• Experienced in ICD 10, Obamacare/ PPACA and HIPAA 5010.
• Automated the key functional scenarios using QTP to support regression testing and managed the entire test efforts in an integrated QC environment.
• Good understanding of application build cycles and following the required test strategy to meet the testing requirements.
• Coordinated with offshore teams and organized conference calls to update the management team regarding the project testing status.
• Actively involved in Defect reporting, Triage, Defect Tracking, Summary Reports & Regression Testing. Used Quality Center for defect reporting and tracking.
• Drafted detailed defect reports with required attachments and steps to reproduce the defects and communicated effectively with the development team.

Environment: Java, Web logic, Web-Services, Oracle, IBM Mainframe, HP Quality Center, Quick Test Professional, SQL Developer, Microsoft Office Suites.

Confidential

ETL Tester

Responsibilities:

• Performed data validation testing writing SQL queries.
• Validated the extraction, transformation and load (ETL) process for a Data Warehouse from their legacy systems using Informatica.
• Verified data completeness and transformation rules.
• Tested referential relations and integrities of data.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Interacted with programmers to identify and resolve technical issues.

Environment: Java, JSP, JavaScript, UNIX, SQL, Windows XP, HP Quality Center, Microsoft Office Suites, Informatica Power Center.