Qa Lead Resume
Rochester New, YorK
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