We provide IT Staff Augmentation Services!

Sr. Quality Analyst/ Validation Analyst Resume

4.00/5 (Submit Your Rating)

WI

SUMMARY:

  • 9 + years of experience in Software Quality Assurance and Quality Control in various domain like Finance, Insurance, Healthcare and Telecommunication.
  • Good knowledge of Quality Assurance methodologies like Agile,Waterfall
  • Experienced with different   Relational databases like Teradata, Data Stage, Oracle and SQL Server.
  • UAT and production validation support outside regular business hours, which led to the successful data conversion of >1 million online banking customers.
  • Adaptable to any kind of project - worked on long term, high complexity projects as well as shorter projects with several changes.
  • Proficient in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing&User Acceptance testing (UAT)& Involved in Load Testing, Performance Testing & Stress Testing for .Net, Java and Python languages .
  • Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases and also involved in review of ETL architecture, ETLdesign, and analysis and ETL technical specifications.
  • Developed Test Cases and Test Scripts for System and UAT Testing.
  • Designed and executed the UAT cases.
  • Excellent Knowledge on Unix
  • Has good knowledge of Software Development Life Cycle (SDLC) Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Prepared UAT Test plan and coordinated UAT with stakeholders and business users.
  • Great knowledge of banking systems and procedures
  • Extensive experience in testing Data warehousing environment, experience in testing to ensure that ETL process functions well with all the upstream and downstream processes.
  • Involved in Master Data Management (MDM) testing for source identification, data collection, data transformation, rule administration, data consolidation and data reconciliation.
  • Well versed with writing detailed test cases for functional &nonfunctional requirements.
  • Experience in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for Manual, Automated & bug tracking tools.
  • Executed regression tests at each new build in QTP.
  • Open to dynamic work environment and ability to work collaboratively with business analysts, other testers, developers and other team members in the overall enhancement of software product quality.
  • Developed automated Test scripts using QTP to perform Functional and Regression testing.
  • Responsible for collection of metrics/ reporting on metrics/ design preventative and corrective measures for senior management consideration.
  • Proficient Created unit and functional test cases through use of testing tools for .Net, Java and Python  languages.
  • Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases.
  • Familiarity with Programming&Scripting languages.
  • Extensive experience working with onsite/ off site team model; aware of the cultural issues; aware of the issues in terms of planning efforts/ schedules etc.
  • Reviewed the QTP Scripts developed by the team members.
  • Experience in interacting with business analysts, developers, technical support & help them base line the requirement specifications.
  • Attend periodic meetings, teleconferences and led discussions on problem resolution.

TECHNICAL SKILLS:

Operating System: Windows 7/2000/2003/XP/NT/VISTA, LINUX, UNIX, OS X, MS-DOS.

Languages: C++, HTML, XML, VB Script, Java Script, Python, .Net, Oracle.

Database: Oracle 10g, 11g, SQL Server 2005/ 2008, MS Access, MYSQL, Db2,unix,

Bug Reporting Tools: ALM, JIRA, Citrix, Bugzilla, Mantis, Quality Center, Test Director, Rational Clear Quest.

Testing Tools: Quick Test Pro (QTP), Win Runner, SOAP UI, ALM, Quality Center, Tara Data Client 14.00, Service Manager, Rich Client BI, Netezza, and Toad,MDM,

Other Tools: MS Office (Word, Excel, PowerPoint, Outlook), MS Project, MS Visio, Toad, Snagit9, IBM Clear Case. Sniping

PROFESSIONAL EXPERIENCE:

Confidential, WI

Sr. Quality Analyst/ Validation Analyst

Environment: Windows 7 & 10, ALM, and Agile

Responsibilities:

  • Review the Business/Functional/System Requirement and Specifications Analysis and Design phase for various projects.
  • Responsible for analyzing business requirements and development specifications to create and execute test plans/Cases.
  • Worked with a team of developers in understanding QA needs for designing various test Sandboxes
  • Actively involved in use case planning and time estimation for QA for Phase 2 of the project on various work streams like Leading Conversion, Integration, Functional efforts for Conversion of Applications to JAVA 1.8 and migration of database from Sybase to SQL Server implementation
  • Very good understanding of Conversion and Upgrade process
  • Working closely with SAP Configuration Team to create manual test scripts, scenarios, test data and test conditions in ALM
  • Extensively worked with SAP ALM and SAP Solution Manager.
  • Experienced working / Validating with multiple Internal and External Applications at the same time.
  • Worked with BA’s and Developers on data profiling for Data Conversion work stream.
  • Worked with vendors to coordinate testing pre and post release
  • Experience in SAP Testing Methodology like Agile.
  • Participated in daily scrums to give updates on QA effort
  • Tested and transferred legacy data in to SAP system
  • Following the SDLC process, use requirements documents to create testing strategy including providing test estimates, documenting test plans and objectives, assessing and identifying testing risks, and developing test scenarios and test cases
  • Excellent experience in building & managing QA team ( using internal SAP Functional & Tech team )
  • Develop, document and maintain test artifacts like test data, data validation and automated test scripts.
  • Execute test scripts using ALM
  • Create and track bugs and generate bug reports using ALM
  • Use multiple tools to complete UI testing, including cross browser testing, salesforce testing, XML validation, SOAP UI
  • Attend project meetings and communicate with project team including project manager, development, business partners about testing deliverables and any issues that may hinder meeting testing deadlines. Also, provide regular test status reports and defect reports.
  • Ensure successful delivery of final content by the testing deadline including test sign off reports, any outstanding defects and how they would be handled, and hand off to UAT
  • Maintain the regression suite and oversee regression testing each release cycle, with automated testing delegated to offshore resources.
  • Work on multiple projects at one time and deliver high quality results within project timelines.
  • Maintain and update test documents on shared drive and SharePoint sites for audit and compliance purposes
  • QA and UAT testing and production validation for a very large project which involved the seamless migration of java 1.7 to java 1.8 and Sybase data base to SQL data base
  • Easily adapt to changes including project changes, timelines, and resources.

Confidential, St. Louis, Missouri

Sr. ETL Quality Analyst Lead

Responsibilities:

  • Experienced Working with Migration of an existing database to a new RDM /ETL solution implemented with some enhanced capabilities.
  • Experienced Working with an end to end RDM testing framework utilizing the best practices from Cognizant EDM /ETL Testing COE coupled with risk based testing approach to streamline the overall release testing process
  • Experienced Working with Testing all across functionalities of Informatica in line with the business rule
  • Experienced to ensure that critical enterprise data validated as correct, consistent, and complete when it is circulated for consumption by internal or external business processes, applications, or users.
  • Ensured Integrated Enterprises MDM delivery model and de-duplicated Master Data to maximize MDM benefit
  • Experienced with EDM /ETL Flow Understanding the layer wise data movement
  • Experienced with verifying migration policies to ensure the systematic movement of data (including data security)
  • Experienced creating Comprehensive Test PlanMeticulous planning for and deployment of a comprehensive EDM testing plan will ensure that data is properly converted, standardized & consolidated to form best breed of master data.
  • Experienced Working with Align MDM Testing to the stakeholder expectations on test coverage.
  • Ensured no fragmented data or any kind of missing info that may lead to any revenue loss
  • Experienced Working for Data Governance, Role based verifications (Billing user / RDM Admin / Accounting Admin etc.), Verifying search & update code values, Addition new attributes/code types, Enabling/Disabling ref code types, Bulk update / upload, Approval for key ref data update, Enrichment of data, Email notifications checking.
  • Experience in testing match rules for de-duplication
  • Expertise in testing application of trust values and Rules for data merge, testing Global reference data for effective master data governance
  • Experience in testing import rule and attribute validation.
  • Expertise in export rule checking and data format validation, Database validation for import data and Role based testing for Product Master Reference Hub.
  • Work closely with the business team to understand the scope of work
  • Walkthrough of the Test Strategy, Approach & other testing deliverables for final approvaland Manage the day-to-day testing activities.
  • Responsible for driving defects triage exercises, root cause analysis and defect density measurement and Serve as first point of escalation for Testing.
  • Maintained latest version of test cases and test data
  • Experienced to Understanding requirements and create test scenarios /cases, review of testing artifacts, Perform and Manage Dry run from offshore, Ensure to follow established testing process, Test case execution and Run sanity check for environments.

Confidential, West Bend, Wisconsin

Sr. ETL QA Analyst

Responsibilities:

  • Attended walk though meeting in which business rules and functionalities were discussed
  • Coordinated all QA activities and enhancements using Agile Methodology.
  • Developed Test Plan and wrote Test Cases.
  • Performed Sanity testing, System testing, Functional testing, Integration testing, Web testing and GUI testing.
  • Performed Cross browser compatibility testing and cross platform compatibility.
  • Prepared Test Plan wrote Test Cases and executed test scripts as well as tracked bugs and generated defect report using Quality Center (QC).
  • Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
  • Delivered UAT documentation to the BA to make recommendations on changes to the applications
  • Designed various test Cases with different test conditions.
  • Validated correct process of ETL.
  • Prepared and reviewed UAT test artifacts (Test Plans, Test Scripts, Traceability matrices, etc.) with Project Stakeholders. 
  • Built and performed test cases for END to END testing using JIRA and SQL
  • Involved in implementation of ETLbest practices and Maintain, backup and restore the Informatica ETL repositories for the QA team.
  • Used SQL Queries to verify and validate Data populated in Front-End is consistent with that of Backend, used Insert, Update, Aggregate and Join queries.
  • Prepared and executed scenarios for the Regression testing on new ETL process builds.
  • Hands on experience in collecting several metrics and preparation of defect reports.
  • Prepared and executed scenarios for the Regression testing on new builds.
  • Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT.
  • Extensively involved in performing Backend testing by using SQL.
  • Performed Manual Testing of the application as well as identified the critical test scripts to be automated. Performed ETL testing to validate data is transformed correctly from OLTP to data warehouse.
  • Performed that all data is transformed correctly according to design spec.

Confidential

Sr. ETL QA Analyst

Responsibilities:

  • Supported all aspects of client engagements from scope definition to delivery
  • Conducted quantitative and qualitative analysis of data
  • Developed a clear plan for requirements management to include identification and estimation of business analysis activities
  • Elicited requirements using brainstorming, document analysis, focus groups, interface analysis, interviews, observations, requirements workshops and surveys/questionnaires
  • Coordinates and facilitates meetings with users to gather and document requirements and explore potential solutions.
  • Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.
  • Gathered Functional requirements through a variety of techniques such as work sessions and interviews.
  • Contributed to written and verbal communication in and out of the client, specific to the business and functional requirements
  • Configured and maintained of Facets and other application software products, such as Claim check, Facets
  • Analyzed and documented client complex business requirements and processes; communicates these requirements to appropriate parties
  • Tested the changes for the front end screens in FACETS related to following modules, test the FACETS batches (membership).
  • Worked with the technical team and provides clarification on Functional requirements
  • Participated in technical reviews and inspections to verify 'intent of change' is carried through the entire project.
  • Get the Facets Claim IDs from X12 in HTM, HP environment and verify them in  Facets Claim Adjudication system.
  • Worked in testing of Data Integrations related to data Warehousing and then to Master Data Management (MDM).
  • Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
  • Integrated provider data from all external and internal sources for Informatica MDM
  • Managed Individuals (physicians, nurses, laboratory technicians and home health providers and so on) and organizations (clinics, labs, pharmacies and so on) for provider Master

Confidential, Miami, Florida

Sr. ETL QA Analyst

Responsibilities:

  • Created UAT Test Cases to validate end-to-end business flows in Data Driven testing environment.
  • Responsible for creating UAT environment; ensure that all the test case input sources are available; test case output results were documented.
  • Responsible to resolve exceptions in UAT in a very expeditious way and re-UAT to ensure accurate and timely delivery.
  • Responsible for managing the Data Warehouse and Business Intelligence functions at Burger King
  • As part of QA team was involved in implementation of ETLbest practices.
  • Lead multi-persons QA team for the data migration and consolidation project to perform end-to-end test.
  • Developed automated Test scripts using QTP to perform Functional and Regression testing.
  • Ensured that UAT results are signed off by the right people in user community; worked with several different levels of users in UAT such as floor agents to the VP level.
  • Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
  • Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the data marts and feeder systems in the aggregation effort.
  • Experience in conducting end user training on various SAP R/3 modules.
  • Creating test plan , Walk through, integration approach and strategy document, test cases , scenarios, conditions and scripts, generated system test scripts for Customer Relationship Management  ( CRM ).
  • Created SSIS packages to import data from MS Access, Excel to SQL .
  • Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various cruise specialists and the business team.
  • Created SSIS packages to clean and load data to data warehouse
  • Execute Quality Checkpoints pertaining to testing readiness for Integration System Test, User Acceptance Test, and Performance Test.
  • Manually written the SQL queries to test the back end database.
  • Working with clients to improve their BI environment to improve the quality and availability of data to the end users.
  • Formulate methods to perform Positive and Negative testing against requirements.
  • Responsible for validation Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center also tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
  • Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
  • Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
  • Used Agile-testing methodology for achieving deadlines in UAT.
  • Executed and managed test cases and reported bugs in Quality Center.
  • Validated data in between source and target after running Mappings by the Informatica developer team.
  • Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
  • Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis for Caliber data mart.
  • Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.

Confidential, Plano, TX

Sr. QA Tester

Responsibilities:

  • Coordinated all QA activities and enhancements using Agile Methodology.
  • Developed and maintained multiple project deliverables such as Test Plans and Test Cases.
  • Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
  • Assess manual test coverage and plan and coordinate the creation of automated tests (web UI, SOAP API)
  • Good experience is Data Masking Techniques. Executed Data masking POC successfully using DMSuite.
  • Involved in data migration from legacy database (Mainframe) to Oracle database.
  • Create Crystal Reports, which would facilitate decision-making. The Crystal Reports designed were complex and used formulas, parameters, selection criteria, sub reports etc.
  • Tested the performance bottlenecks at sources, targets, mappings, and sessions and employed required measures.
  • Involved as part of automation team using QTP, developed test scripts.
  • Experience in Data Transfers using Batch input methods, Transferred master data from previous system using LSMW SAP Tool .
  • Created test scenarios and test cases for Online CRM application based onthe requirements and provided to the business analyst for review andSignoff.
  • Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
  • Performed activities around testing such as developing test plans (i.e., integration, stress, and UAT) and schedules, test scripts, test data, use cases, and roles and responsibilities
  • As a Senior QA Analyst/Team Leader worked on Loan IQ application thatCovers the entire life cycle of a loan - from origination and deal tracking to administration and record maintenance.
  • Created Integrated summary data from multiple Oracle tables to represent the business perspective of the top management executives
  • Assisted users for user acceptance testing (UAT)
  • Prepared scripts, running tests, Analyzing results in Load Runner 9.1 for Performance testing.
  • Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
  • Worked on Loan IQ 5.4, 5.5, 6.0 and 7.0 versions.
  • Involved in Functional , Integration, System, Regression, Data migration & Compatibility Testing .
  • Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
  • Good knowledge of Financial Products like Derivatives, Equities and Fixed Income.
  • Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off- site team.
  • Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.

Confidential

Sr. QA Analyst

Responsibilities:

  • Responsible for reviewing Requirement Specifications and Design Documents.
  • Involved in Test Case Design with respect to Test Plan.
  • Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
  • Worked on conversion of manual integration tests into automated tests using QTP.
  • Prepared and executed scenarios for the Regression testing on new ETL process builds.
  • Tested Informatica folders, global sources, global targets, global ODBC connections, global FTP connections workflows, data profiling and manage metadata.
  • Performed tests for Functionality, GUI and Backend.
  • Provided UAT support and Post Implementation Support.
  • Executed automated as well as manual test scripts and validated Test conditions for Systems, Integration, Regression, and Conversion tests.
  • Tracked and managed UAT defects along with analyzing data and provided reports
  • Executing, Reporting and Tracking the defects using Quality Center.
  • Created and maintained Regression test suite to check the progress of the testing process by performing identical tests before and after fixing defects.
  • Customized the scripts according to the requirements by using conditional statements and loops.
  • Coordinate with manual tester and set up expectation on what will be handled by automation team.
  • Ensure that all the test casesare updated in the Quality Center along with Master test plan.
  • Provided weekly status report to the Team lead and discuss issues related to quality and deadlines.

Confidential

ETL Software Tester

Responsibilities:

  • Analyzed the requirement documents and detailed design documents to prepare test plans
  • Communicated with BA's for questions related to the requirements and use cases
  • Initially performed White box testing with alimited number of test cases to the internal workings of software under test and in the remaining part takes Black Box approach in applying input and just observing outputs
  • Involved in Test Case Design with respect to Test Plan.
  • Executed Positive and Negative Test cases. .
  • Involved in Test Execution and Bug Reporting using Test Director.
  • Used Joins like Inner join, Outer joins while testing from multiple tables.
  • Involved in performing various levels of testing like Unit Testing, System testing and Integration testing.
  • Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
  • Performed validation testing for each field in the application for different scenarios with the use of Mercury Test Director and HP QC.
  • Involved in Test reporting on daily/ weekly basis through company prescribed format.
  • Provide accurate and timely testing status reports to the QA Lead and Project Manager.
  • Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
  • Executed test cases through Iterative testing for testing the incremental functionality.
  • Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.

We'd love your feedback!