SUMMARY

• A highly motivated Business Analyst/Quality Analyst with 10+ years of progressive experience in Requirement Analysis, QA/Testing and implementation of information technology projects
• Strong knowledge of the QA Best Practices, Software Development Life Cycle, Methodology, Testing Standards, Test Processes, and Test Methods to validate and ensure the quality of software through testing.
• Experience in BI, ETL, Database, Migration and Data conversion projects
• Good knowledge of ETL and Data Warehousing concepts with best practices
• Experienced in Object Oriented Analysis, Data Analysis, Requirement Analysis, Business Modelling and Use Case development using UML methodology
• Well - versed in Requirements/Change Management, Impact Analysis and Gap Analysis
• Fluent in a broad range of technologies, including business process tools such as MS Project, Excel, Access and Visio.
• Testing Methodology knowledge and experience in Agile Testing, V-Model, and Waterfall.
• Expertise to design Business Requirement Specification (BRD), System Requirement Specification (SRS), User Requirement Specification (URS), Use Cases Document, Work Breakdown Document (WBD), and Requirement Traceability Matrix (RTM).
• Highly skilled in manual testing within all phases including functional, integration, system testing (end-to-end), regression, data conversion, and user acceptance testing.
• Experience in Manual and Automated Software Testing tools QTP
• Experience in defining test plans, identifying and creating test cases according to the technical / business specifications
• Configured development and QA environments to meet data privacy and data sub setting requirements using Optim Test Data Management (TDM) services.
• Experience API testing knowledge like Postman, Soap UI and AdvancedRestclient.
• Experience with CCDA using FHIR Technology.
• Experience in test execution, documenting defects, testing results, and metric reporting
• Experience with black box testing methods; Positive, Negative, Data Integrity, Acceptance, Cross Browser Compatibility, Data Conversion, Smoke, Regression, Etc.
• Extensive knowledge and experience using ALM/Quality Center and TestRail on projects to track requirement coverage, test case development, execution and defect reporting
• Worked closely with Developers, Business Analysts, and Subject Matter experts to help facilitate the quick resolution of issues / defects found during testing
• Strong in writing SQL queries and reporting the results to the business team
• Good understanding of Database Management Systems like Oracle and SQL Server
• Interacted with large teams of testers and developers through excellent communication and interpersonal skills with ability to work independently as well as in a team

TECHNICAL SKILLS

Methodologies: Waterfall, RUP, Agile, UML, Design Patterns

Modelling Tools: Rational Rose, MS Visio

Testing and defect tracking Tools: Rational Clear Quest, Rational Clear Case, Quality Center, ALM, Selenium, Quick Test Pro (QTP), JIRA, TestRail.

Project Management Tool: MS Project

Operating Systems: Windows Vista/XP/2000/98/95, UNIX, Mac, Linux

DBMS: MS SQL Server 2008, Oracle, MS Access 7.x, MY SQL, PL/SQL

Web Technologies: CSS, HTML

API Technologies: Soap UI, Postman and AdvancedRestclient

Database Tools: TOAD, WINSQL, SQL server management studio

Office Software: MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Visio, Office Suite.

Data Warehouse Tools: SSIS 2008/2012, Informatica Power Center 8/9

Reporting Tools: Micro Strategy, Jasper Soft

PROFESSIONAL EXPERIENCE

Confidential, MA

Lead Quality Analyst

Responsibilities:

• Gather technical business requirements and develop conceptual and technical designs for our web based applications.
• Develop testing programs that address areas such as database impacts, software scenarios, regression testing, negative testing, error or bug retests, or usability.
• Document software defects using a bug tracking system and report defects to software developers.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Developing scripts for connection with the DB2 database.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Involve in test data preparation for the Parameterized values in the scripts for multiplescenarios
• Plan test schedules or strategies in accordance with project scope or delivery dates.
• Work with Automation Testing, QTP, model based testing, Quality Center, manual testing and Selenium web testing.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
• Plan test schedules or strategies in accordance with project scope or delivery dates.
• Translate functional requirements into software application designs and implement those designs; perform application development. Participate in code reviews.
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.

Environment: Windows, MS Office, MS Visio, MS Project, UML, XML, Sql Server Management studio, HP Quality Center, Jira, Toad, TestRail, Beyond compare tool.

Confidential, MA

Sr. Quality Analyst

Responsibilities:

• Review product requirement documents, functional specifications, and involved in developing test strategy, test plan and test case.
• Interacted with Business Analysts and software developers for bug reviews and participated in QA meetings.
• Proactively come up with innovative methods to improve software quality, test coverage, efficiency and regression coverage.
• Actively participated in scrum meetings, reviews and developed scenarios.
• Responsible for database testing using SQL queries in Toad.
• Created the trackability matrices to fill the gap between the requirements and the test cases covered
• Designed positive and negative test cases; performed regression testing; and produced report
• Monitored and reported bugs through JIRA, and coordinated with the Development Team in validating bug fixes and updating bug status.
• Coordinated with the Development Team to review modules and new product features for creating test cases.
• Conducted integration, black box, functional, system, and regression testing to verify application functionality.

Environment: Windows, MS Office, MS Visio, MS Project, UML, XML, Sql Server Management studio, HP Quality Center, Jira, Toad.

Confidential, MA

Sr. Quality Analyst

Responsibilities:

• Understanding Requirement Specifications and Design Documents.
• Participated in walkthrough meetings and inspection meetings to review
• Used Quality center to upload the Test Plan, Test Strategy and Test Results.
• Identified testing areas in the ETL processand created Test cases, Test scripts and Executed in HP Quality center.
• Performed extensive manual testing of each module like staging and Data warehouse.
• Worked in Agile Environment
• Participated in weekly meetings for reviewing progress and future testing efforts
• Performed manual testing for Initial and Incremental load.
• Performed BI report testing like validation and formatting.
• Evaluated and implemented QA process improvements for ongoing testing
• Prepared daily testing status reports and submitted them to the Project Manager.
• Record Count and Data Integrity Check between Source system and Target system.
• Data Quality Validation - Check for missing data, negatives and consistency.
• Data consistency validation within the Staging tables to check all Transformation Rules are followed.
• Involved in Execution of various types of Test Cases based on Duplicate Check, Null
• Parameters and constraint checking
• Verifying ETL data in target database.

Environment: Windows, MS Office, MS Excel, UML, XML, Sql Server 2008, Sql developer, HP Quality center,Jira

Confidential, CT

Sr. Quality Analyst

Responsibilities:

• Analyzed business requirements and developed detailed Test plans.
• Used Quality center to Create Test Plan, Test Strategy.
• Identified testing areas in the ETL processand created Test cases, Test scripts and Executed in HP Quality center.
• Performed Smoke, System, Integration, Unit and Regression Testing
• Performed extensive manual testing of each module like staging and Data warehouse.
• Worked in Agile Environment
• Participated in weekly meetings for reviewing progress and future testing efforts
• Participated in walkthrough meetings and inspection meetings to review
• Performed manual testing for Initial and Incremental load.
• Performed BI report testing like validation and formatting.
• Evaluated and implemented QA process improvements for ongoing testing
• Prepared daily testing status reports and submitted them to the Project Manager.
• Understanding Requirement Specifications and Design Documents.
• Record Count and Data Integrity Check between Source system and Target system.
• Data Quality Validation - Check for missing data, negatives and consistency.
• Data consistency validation within the Staging tables to check all Transformation Rules are followed.
• Write SQL codes for testing the dimension and fact tables.
• Involved in Execution of various types of Test Cases based on Duplicate Check, Null
• Parameters and constraint checking
• Verifying ETL data in target database.

Environment: Windows, MS Office, MS Excel, UML, XML, Sql Server 2008, Sql developer, HP Quality center.

Confidential

Sr. Quality Analyst

Responsibilities:

• Responsible to test the initial organization application and various review applications like IDM Users Organization, Business Service Onboarding, Business Service Owners Organization and EON Portal Administration.
• Review product requirement documents, functional specifications, and involved in developing test strategy, test plan and test case.
• Interacted with Business Analysts and software developers for bug reviews and participated in QA meetings.
• Proactively come up with innovative methods to improve software quality, test coverage, efficiency and regression coverage.
• Actively participated in scrum meetings, reviews and developed scenarios.
• Responsible for database testing using SQL queries in oracle server.
• Created the trackability matrices to fill the gap between the requirements and the test cases covered
• Designed positive and negative test cases; performed regression testing; and produced report
• Monitored and reported bugs through JIRA, and coordinated with the Development Team in validating bug fixes and updating bug status.
• Coordinated with the Development Team to review modules and new product features for creating test cases.
• Conducted integration, black box, functional, system, and regression testing to verify application functionality

Confidential

Quality Analyst

Responsibilities:

• Analyzing business requirements, data mapping requirements specification document.
• Experience on preparing SQL queries.
• Verifying all records successfully loaded in target, and mapping.
• Experience on testing SSIS Packages.
• Responsible for the ETL build validation process on an ongoing basis and for the validation of any modifications to the Micro Strategy reports.
• Performed Micro Strategy Reports Testing & Dashboard Testing.
• Driving defect Review meeting with Business Analyst and Dev partners.
• Reporting daily testing status report.
• Performed Regression testing.
• Defect Analyzing and Reporting.
• Participated in weekly Status meetings with business and development team.
• Identified test data requirements for test execution.
• Executed Test Cases during all phases of testing to validate the requirements and application functionality.
• Reported defects found during testing to the development team.
• Prepared test logs and defect summary reports during testing.

Environment: Windows, MS Office, MS Visio, MS Project, UML, XML, Sql Server 2008, Sql developer, JIRA.

Confidential

BA/QA

Responsibilities:

• Gathered Business requirements and documented Functional Design Documents
• Documented the As-Is and To-Be processes
• Organized JAD/JAR Sessions to collect requirements from system users and prepared business requirement that provided appropriate scope of work for technical team to develop prototype and overall system.
• Involved in Data Modelling sessions to ensure that the data model support key business requirements
• Helped in identifying potential sources of data for the data warehouse
• Identified end-to-end requirements for all systems and business units that may be impacted by the project.
• Worked with the Stakeholders, Project Manager and senior Business & SQA (Software Quality Assurance) Analysts in defining, documenting the business needs and Business Process flows.
• Established and maintained traceability matrix until business requirements were signed off
• Developed a Business Acceptance testing strategy and plan
• Created Source to Target mapping document for dimensions and facts
• Involved in developing test strategy and test plans to ensure that test cases reflects user needs for the functional, user interface, performance, usability and security requirements.
• Reviewed Integration Test Plan for integration between modules
• Performed smoke testing to accept and sign-off on functionalities.
• Created comprehensive test schedule, test cases and test data
• Performed User Acceptance Testing (UAT)
• Used defect-tracking tool to analyze, report and track application defects and enhancement change requests
• Used Quality Center with QA team for testing
• Used and wrote SQL to query SQL Server database tables for executing test scripts.
• Assisted project manager with the scheduling and execution of implementation tasks

Environment: Windows, MS Office, MS Visio, MS Project, UML, XML, Sql Server 2008, Sql Server Management studio, HP Quality Center.

Confidential

BA/QA

Responsibilities:

• Participated in Requirement Walk through meetings with Senior Business Analyst, and System Analysts
• Assisted in requirements gathering to capture testing scope for impacted systems by meeting with the application owners
• Reviewed project documentation including Business Requirements, Technical Requirements, and Functional Design Specifications
• Created Source to Target documents for ETL team
• Assisted in all phases of the testing lifecycle; Test Planning, Test Preparation, and Test Execution
• Collaborated with the Test Lead to assist in defining and documenting the Test Plan Strategy for project
• Utilized HP's Quality Center for capturing requirements, test case development, execution, and defect tracking
• Assisted in Functional, Integration, End to End, Regression, and User Acceptance Test Phases
• Identified test data requirements for test execution.
• Executed Test Cases during all phases of testing to validate the requirements and application functionality
• Reported defects found during testing to the development team.
• Prepared test logs and defect summary reports during testing.
• Escalated issues to the QA Lead when necessary
• Attended and participated in the weekly team meetings, weekly defect meetings, weekly change Management meetings, Project Status Meeting, etc.
• Responsible for reporting weekly status to the QA Manager

Environment: Oracle9i, Windows XP, NT, QTP, UNIX, SQL, VB Script, MS Office, MS Visio, MS Project, HP Quality Center.