SUMMARY

• 18 years of experience in Application Analysis, Quality Assurance, and UAT testing of application systems in Client/Server and Web environments.
• Working in Facets Application for Excellus Health Care - Blue Cross Blue Shield
• Involved in ETL process testing- experience on SQL queries and validating teh data
• Sources, extraction of data, applying transformation logic, and loading teh data in teh Target tables.
• Experience working on TriZetto Facets claims processing system.
• Experience in testing HealthCare applications and medical systems in different environments.
• Strong noledge of Agile Process and Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC).
• Worked under testing methodologies like Agile-SCRUM, Devops and Waterfall Model.
• Used Oracle in creating & executing SQL queries for testing ETL process.
• Expertise in writing SQL Queries using Oracle and SQL Server in validating data into Data Warehouse/ETL applications.
• Strong working experience in teh Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing.
• Involved in preparation of Test Data to test teh functionality of ETLSources Mappings and Targets.
• Extensive experience in Functional, Integration, Regression, User Acceptance (UAT) and backend testing.
• Experienced in creating Medical and Dental claims, enrolling subscribers and members in Facets
• Extensive experience in creating Test Plans and Test Cases for Client Server Applications and web-based applications.
• Strong SQL skills including complex queries for backend testing and data analysis.
• Strong Analytical skills, excellent communication and interpersonal skills, team player and
• Self - starter.
• Defining requirements, performing system analysis, and producing requirements-related
• Documentation for projects and system enhancements
• Involved in Salesforce testing and ad-hoc testing
• Act as a liaison between business, development, and testing teams
• Work independently wifin a team, receiving general direction wif work product reviews and assistance.
• Perform root cause analysis on issues found post testing.
• Responsible for creating and tracking defects, writing and executing test cases.
• Gather/analyze/document business and application requirements, leading to teh development of a business solution.
• Develop requirements specifications according to project lifecycle methodologies
• Good experience of Healthcare industry trends and formats including Medicare or Medicaid.
• Successfully managed complex projects wif global implementation, and rapidly evolving requirements.
• Worked on Migration Projects from Waterfall to Agile Model and Involved in scrum master/Story Author.
• Exceptional ability to maintain and build client relationships, frequent travel meeting one on one wif clients, able to comfortably converse wif all facets in teh client’s organization.
• Managing reports, analysis and decision-making for a change request.
• Attend daily defect triage meetings to prioritize and track teh defects to be addressed, ensuring timely and accurate resolutions.

TECHNICAL SKILLS

Methodologies: Agile/ Waterfall model

Business Analysis: Requirement analysis, business rules, data flow diagram, flowcharts, business process modeling & improvement, gap analysis, cause and TEMPeffect analysis, WBS, decision tree, BRD

Requirement/ Configuration Management Tools: RationalClear Case,Clear Quest, Planview, Visual Source Safe

Programming Languages: C++, VB/ASP.Net

Databases: MS SQL server, MS Access, Oracle

Testing: Black Box testing

Testing Tools: HP Quality Center, Devops

PROFESSIONAL EXPERIENCE

Confidential, Rochester, New York

QA Lead

Environment: TriZetto FACETS, MS Outlook, MS Office, SQL Server, MS Access

Responsibilities:

• Written SQL statements manually to validate data and Tested Entity relationship of theDatabase.
• Involved in Web Based Testing
• Strong SQL scripting / ETL testing skills, Web application testing experience and there is no deviation.
• Involved in preparation of Test Data to test teh functionality of ETLSources Mappings and Targets.
• Validated teh output files created bySQLbatch and ETL process are same
• Reviewed database business and functional requirements, reviewed mapping transformations
• Validated teh source system data wif teh staging data using SQL scripts.
• Expertise wif System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix wif requirements versus test cases.
• Performed Back-end testing usingSQL. Attendedproject meetings and release
• Meetings to represent QA Team.

Confidential, Plano, Texas

QA Lead

Environment: ETL and Salesforce

Responsibilities:

• Written SQL statements manually to validate data and Tested Entity relationship of teh
• Database.
• Validated teh job flow and intermediate output files are same for ETL process
• Validated teh source system data wif teh staging data using SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation,
• Data Quality Performance and Scalability
• Expertise wif System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix wif requirements versus test cases.
• Participated in walkthroughs of requirements, specifications, database designs, ETL code, and test strategies
• Performed Back-end testing using SQL.
• Executed detailed ETL related functional, performance, integration and regression test
• Cases, and documentation
• Analysis of ETL Mappings based on Facts & Dimensions from Source to target tables for directs moves and indirect moves based on transformation rules & lookup tables.
• Used MS Sql server Management studio for Creating & executing SQL queries for testing teh conversion &ETL,process.

Confidential, Alpharetta, GA

QA Lead

Responsibilities:

• Worked closely wif project stakeholders, business SME’s for gathering requirements and specifications for teh applications and preparing business requirements document (BRD).
• Involved in Writing Test cases based on FRD Document and involved in manual testing.
• Executed test cases in Quality center.
• Participating business meetings wif clients.
• Prepared Test Cases and Test Plans.
• Involved in manual testing.
• Clarified QA team issues, reviewed test plans, and test scripts developed by QA team to make sure dat all requirements will be covered in scripts and tested teh same.

Environment: MS Visio, MS SQL Server, Agile Methodology, MS Project, MS SharePoint 2007, HP Quality Center, Planview, Clear Case, Clear Quest, Quick base, HP Server Automation V 9.0., VB.Net, JavaScript, HTML4.0, CSS, SQLServer 2008, ASP.Net

Confidential

QA Lead

Responsibilities:

• Served as teh Client interface, working wif teh Client to establish new requirements and enhance teh existing requirements.
• Written Business requirements in detailed wifout any breaches.
• Involved in Writing Test cases based on FRD Document and involved in manual testing.
• Executed test cases in Quality center.
• Involved in manual and automation testing.
• Involved in Adhoc testing dat yields to 0% Defect.
• Involved in all cycle’s successful implementation.
• Involved in Process Quality Assurance Audits.
• Prepared Test Cases, Test Plans and Test Strategy.
• Involved in Dashboard Reports and Weekly Status Reports.

Environment: ASP.Net, JavaScript, HTML, CSS, SQLServer, Quality Center