System Validation & Uat /data Analyst Resume
Plainsboro, NJ
WORK EXPERIENCE:
Confidential, Plainsboro, NJ
System Validation & UAT /Data Analyst
Environment: MS Office, ETL Informatica, data warehouse, .Net, Java, Quality Center 11.0, SQL Server, Windows XP, Windows 2003, UML, HTML, Web Services, Internet Explorer, Mozilla Firefox.
Responsibilities:
- Understand the requirement, Plan, create a test cases and execute test cases for maintaining a database, manipulate data and retrieve a data.
- Pulled data for testing different rules covering matched, Unmatched, Exceptions in positive, negative scenario by using SQL server, Create data sheets for all different rules, convert datasheets into text files to upload on Secure File Transfer server.
- Convert text files into XLS files to match and validate data for CAT (Customer Administration Tool), MDM Data Director Application Informatica, BI Prod and BI Test (SAP Business Objects for Production and Testing).
- Creating scripts from requirements and pulling test data for positive and negative testing scenarios to cover all rules and satisfy all testing conditions in accordance with the company’s computer systems validation policies with in project.
- To participate in the UAT testing execute all UAT scripts to ensure operational quality, system integrity and verify system process meet user needs, including all user acceptance testing activities.
- Performed execution of test cases manually to verify actual result meets the expected results using QC ALM.
- Good documentation practices for validated systems create all required pre and post testing documents, Log and report result of testing.
- Create Requirement Traceability Matrix report document prior to execute test cases and map the results of testing functionalities for software requirement on each step of testing.
- Update Requirement Traceability Matrix upon full testing cycle completed and post on server.
- Track and investigate issues, log and report defects as find.
- Knowledge of the 21 CFR Part 203 and Part 11desirable relationship to validation of systems that support regulated pharmaceutical industry.
- Work with other members of the Customer Data Operations Team, IT, QA to ensure a quality product is deployed.
Confidential, NY
Test Specialist
Environment: MS Office, .Net, Java, IBM Rational Clear Quest, IBM Rational DOORS, Quality Center ALM, QTP, Lotus 8.5, Share Point, Oracle, Windows XP, Windows 2003, UML, HTML, Web Services SOAP UI, Internet Explorer, Mozilla Firefox, Safari, Chrome
Responsibilities:
- Analyzed business requirements, functional specifications to provide inputs to develop Test Plan and Test Cases.
- Developed the testing strategies and test plan for cross - platform testing.
- Test case review, Test Plan, Test data identification and creation. Test Case execution find defects, Login to ALM, Track and retest pass closed defects/fail resend to assigned professional Documentation of all activities and Report to lead.
- Work with Agile Scrum methodology with Software Development Life Cycle.
- Test case review, Test data identification and creation. Test Case Development/Preparation, creation, updates and Execution of Positive testing and Negative testing.
- Test change control request of application among with existing application.
- Worked on data migration process and validated ETL (Extract Transfer Load) based on mapping documents.
- Performed execution of test cases manually to verify actual result meets the expected results using QC ALM.
- Logging defects in Clear Quest, Modify and track defects using Clear Quest. Retest once they are fixed and move to closed, sign off status using QC ALM.
- Analysis of project progress by queries reports and charts in Clear Quest.
- Tracking and managing defects and change requests throughout the development process using Clear Quest.
- To Meet the business goal analyze, trace, capture and manage changes to information and maintain standards using IBM Rational DOORS.
- Create Requirement Traceability Matrix report document prior to execute test cases and Update Requirement Traceability Matrix upon full testing cycle completed.
- Worked with business analysts and developers to resolve issues, Worked closely with development team, and off shore team.
- Used TOAD to Inspect and Verify Back end Database Tables for error logs and update the reports.
- Attend daily scrum meetings, weekly meeting with development team, reporting project status and setting goals to complete.
- Report daily activities to lead and prepare weekly reports of work and submit to Lead.
Confidential, Timonium, MD
QA Analyst
Environment: MS Office, ETL data warehouse, .Net, Java, Quality Center 11.0, JIRA, Oracle, Windows XP, Windows 2003, UML, HTML, Web Services, Internet Explorer, Mozilla Firefox.
Responsibilities:
- Worked on waterfall methodology with Software Development Life Cycle phase.
- Analyzed business requirements, functional specifications to provide inputs to develop Test Plan and Test Cases.
- Test Case Development/Preparation, creation, updates and Execution.
- Test data identification and creation. ETL(Extract Transformation and Load)testing.
- Understanding of data to be reported and Understanding and review of data model.
- Understanding and review of sourceto target mappings (transformations).
- Data Quality Assessment of Source data and Verification of transformation rules.
- Comparison of sample data between source and target.
- Checking of referential integrities and relations (primary key foreign key).
- Data Quality checks on target warehouse and Performance tests.
- Internal test case review and Internal review rework.
- External test case review and external review rework.
- TCAMS test cases input, perform regression testing.
- Test Data Development, Platform/Browser Testing.
- Coordinated with the other teams and Developers team involved in the testing.
- Worked with business analysts and developers to resolve issues.
- Logging defects and Change Control Requests in Quality Center 11.0
- Participate in Team planning by attending daily scrum meetings, weekly meetings.
- Reporting project status and setting goals to complete the assignment including Requirement Traceability Matrix creation and update Requirement Traceability Matrix status.
- Support in deployment activities and Implement quality of product.
Confidential, Rahway, NJ
QA Analyst
Environment: MS Office, .Net, Java, Quick Test Pro, Load Runner, Quality Center, Oracle, SQL Server, My SQL, VB.NET, Windows XP, Windows 2003, UML, HTML, Web Services SOAP UI, Internet Explorer, Mozilla Firefox.
Responsibilities:
- Analyzed business requirements, functional specifications to provide inputs to develop Test Plan and Test Cases.
- Developed the testing strategies for cross-platform testing.
- Performed Functional, GUI, SOAP UI, Regression, System Integration and content testing for the Applications.
- Generated test scenarios, test cases and test data. Executed tests on ICD 9, CPT, created status reports keeping under roof of HIPAA and JACHO.
- Worked with business analysts and developers to resolve issues.
- Worked closely with development team in creating automated scripts for the application using Quick Test Professional.
- Logging defects and Change Control Requests in Quality Center.
- Sign off on testing as phases are completed with release management.
- Installing new builds in test environments and managing the test environments.
- Executing End of day procedures and Regression Tests during testing phases.
- Executing manually and planning for automation of various modules in the application.
- Participated in various Team planning and retrospective meetings with Business Analysts to discuss on Enhancement and Modification requests.
- Developed Integration, System, Regression and Post Implementation Test cases to cover all over Quality and Assurance Testing of ICD 9, CPT.
- Used Data driver wizard to create data driven tests, for testing the application with multiple sets of data.
- Did extensive Regression testing on the new builds and executed the scripts.
- Investigating bugs and interacting with developers to resolve technical issues and use Quality Center to log and track defects.
- Responsible for interacting with developers to fix the problems especially pertaining to database, which are not populated to the online screen when customer enters his quote.
- Performed Acceptance testing, documentation of testing process and trained the end users.
- Used TOAD to Inspect and Verify Back end Database Tables updates by writing SQL Queries
- Attend daily scrum meetings, reporting project status and setting goals to complete.
Confidential, Edison, NJ
QA Analyst
Environment: Quality Center, TSYS, QTP, Calyx Point, SUN IDM 8.1, UNIX, VBScript, HTML, Oracle, MS Windows NT/XP/2000
Responsibilities:
- Conducted System Integration Test including Physical Configuration Audit (PCA), Functional Configuration Audit and Thread Test.
- Reviewed the Test Plan maintained by the team.
- Participated in preparing the Functional and System Requirement Document.
- Performed System Integration Testing.
- Also testing for Loan/Lease origination component, Loan Delivery process by using AUS(Automated Underwriting System), DU(Desktop Underwriter Fannie Mae), LP(Loan Prospector Freddie Mac) APR, banking and credit card issues with accounting department.
- Written the Detailed Test Cases to cover all the steps to perform the procedure.
- Performed execution of test cases manually to verify actual result meets the expected results.
- Prepared System Anomaly Reports (SARS) for the defects identified during testing.
- Coordinated with the other teams involved in the testing.
- Participated in the Daily Scrums meeting.
- Retested the SARS to ensure that the defects are fixed.
- Prepared the SAR Document in detail with all the information required.
- Prepared Daily Status Report to make sure that test case coverage has been done accordingly.
- Interacted with the developers regarding priority of defects and update the status of defects once they are fixed.
- Performed Sun IDM identity management to verify client’s identity in lifecycle on business level. Auditing systems, which are integrated to perform the procedure.
- Used Stubs and Drivers to perform the testing
