SUMMARY

• Data warehousing and BI QA Analyst with overall 8 years of rich experience in Software Testing/Development
• Good understanding of SDLC and STLC methodologies including Waterfall, Iterative, Agile and Scrum methodologies.
• Good knowledge on different functional areas like Retail, Health care & Banking and Financial Services.
• Solid testing experience of Functional Testing, System Testing, Writing Test Plan, Testing strategy, Testing Scenarios, Functional Test Cases, System Test Cases and Defect Management
• Involved in preparation of Test Metrics, Status Report and Defect Metrics.
• High degree of analytical skills which aids data and root cause analysis
• Worked extensively on BI, DW, Mainframe, client server and web based applications.
• Worked on all phases of Software Testing Life Cycle.
• Good understanding of onsite/offshore work model.
• Proficient with MS Excel and using advanced functions like VLOOKUP, Pivot Tables, Pivot Charts for data analysis and reporting.
• Extensive knowledge in ETL testing using SQL, UNIX, Pl/SQL.
• Good exposure in working various test management and defect management tools like Quality Center, Jira, Rally and HP ALM.
• Good knowledge on writing SQL queries to extract data from Database and to respond to ad - hoc requests.
• Extensively used joins and analytical functions in SQL to extract data stored across multiple tables in Relational Data Warehouse and getting it ready for further analysis.
• Hands on experience in working with SQL Stored Procedures, views and triggers.
• Proficient in testing complex Reports generated by OBIEE including Dashboards, Summary reports, Master detailed and Drill down.
• Expert in data analysis for correct data reporting.
• Good communication skills with all co-workers including Business teams.
• Flexible and versatile to adapt to a new environment and ability to multitasking and work independently

TECHNICAL SKILLS

Operating Systems: Windows XP, UNIX

Testing Tools: HP ALM, JIRA, Rally, Informatica DVO

Programming Languages: SQL, PL-SQL, C, XML

ETL Tools: Informatica10.2/10, SSIS

BI Tools: OBIEE, Tableau

Testing Methodologies: Water fall, STLC, Agile

Databases/Database tools: Oracle 13g, SQL Server 2008

Documentation Tools: MS-Office, MS-Visio, MS Project, PowerPoint

Scheduling Tools: Autosys

PROFESSIONAL EXPERIENCE

Confidential

Sr QA Analyst

Responsibilities:

• Analyzed the requirements in BRD and other specification documents to understand the desired changes in the functionality of system components.
• Documented the exact scope of functional, system integration and regression testing with thorough impact analysis
• Actively participated in the Daily scrum meetings to discuss tasks and issues relating to the project
• Created Test documents such as Test Plan, Test Cases / Test Scripts covering all the possible positive and negative test scenarios of impacted and dependent downstream objects.
• Updated HP Application Lifecycle Management (Quality Center) tool with the test cases and scripts.
• Executed the Unix scripts to load data into intake, staging layer and structural data model
• Validated the Informatica workflows for connections and properties.
• Performed DDL validations as part of functional testing.
• Performed Data validation both quantitative checks using counts and qualitative check by field by field verification.
• Verified all the expected data is loaded from source to target as part of data consistency and completeness check.
• Executed Referential integrity as well as default value validations as part of data integrity testing.
• Verified Duplicate rows present in the table due to any incorrect natural key selections.
• Participated in the System Integration Testing to test the functionality across the modules and interfaces.
• Performed end to end testing in the release environment to ensure modules interact appropriately with proper functioning of parameter file, load sequence and cross reference or look-up tables.
• Documented the Test Results and test Result summary and did walk through with lead.
• Reported any defects/issues in JIRA and helped the dev team for quicker resolution of issues with detailed investigation and providing possible root cause.
• Created automated scripts using Infosys Inhouse Tool where applicable to run regression for source to staging and staging to target tables.
• Participated in the prep-work needed for UAT validations.

Tools: Aginity Workbench for Natezza, Natezza, Informatica Power Center Client 10.2.0, PuTTy, JIRA, HPALM, Winscp

Confidential

QA Lead

Responsibilities:

• Participated in the User Stories refinements for clear evaluation of acceptance criteria in JIRA and to discuss and understand the requirements for DW updates and QA validations.
• Helped to create and translate user stories to define the functions the system must provide with thorough understanding of requirements.
• Actively participated in the Daily scrum meetings to discuss tasks and issues relating to the project
• Created Test documents such as Test Plan, Test Cases / Test Scripts with thorough understanding of the requirements and careful impact analysis of dependent objects.
• Co-ordinated with the upstream application team for the availability of test files and with the Developer about the correct process of execution of jobs.
• Validated the file using UNIX and reported any issues to concerned team.
• Validated the ETL sessions and workflow details including parameter files before execution and reported any transformation error observed in Informatica Monitor and Session logs.
• Co-ordinated with the DBAs in case of table refresh required in QA environment for proper sync up with Prod.
• Created and Executed test cases in DVO.
• Executed SQL queries for Oracle Objects validations and documented the Test Results and test Result summary and did walk through with lead.
• Reported any test results discrepancies and helped the dev team for quicker resolution of issues with detailed investigation and providing possible root cause.
• Updated HP Application Lifecycle Management (Quality Center) tool with the defects observed and followed up with the Dev team for defect resolution.
• Created automated scripts using Data Validation Option Tool where applicable to run regression for source to staging and staging to target tables.
• Executed and Validated the Backfill process jobs correcting any missing/erroneous data related issues
• Participated in monthly maintenance validation activities such as validation of encrypted field and regression testing of remaining fields and validation of the new fields and expected values
• Regression tested existing objects as part of process updates.
• Participated in post-Production deployment validations

Tools: Toad for Oracle 13.0, Informatica Power Center Client 10.2.0, Informatica DVO Data Validation Option 10.2.0, PuTTy, JIRA, HPALM

Confidential

QA Lead

Responsibilities:

• Analyzed available documents i.e. BRD, FSD and TSDs and discussed with other teams to understand the requirements for QA validations
• Clarified requirements by communicating to Business Users.
• Created Test plans for ETL validations and OBIEE validations of above applications.
• Created and documented test scenarios and test scripts for Smoke Testing, GUI Testing, Functional Testing, Data Integrity Testing etc. for ETL and OBIEE Validations.
• Analyzed data displayed on previous reports to come up with exact join conditions and tables/views to be used for new Reports.
• Validated thoroughly all the Informatica mappings, workflows, Target Tables/Files, Triggers and Audit Tables using complex SQL Queries
• Created test data when needed for accurate execution of all test scenarios.
• Executed regression tests for ETL and OBIEE validations.
• Validated the subject areas in OBIEE used for Ad-hoc Reporting by Business Users.
• Validated the filter criteria and Grouping etc. used in Report as per the Business logic.
• Logged issues and defects in JIRA and ALM with clear description, screenshots and comments.
• Helped Dev teams for quicker resolution of issues/defects with detailed investigation and providing possible root cause.
• Worked with Dev teams for accurate mappings of the new source fields to reporting fields as per Business logic.
• Validated the Autosys Job parameters efficiently for automated batch cycles.
• Collaborated with multiple teams in resolving issues.
• Initiated requests and monitored installation of new versions of required software applications for QA team
• Contributed to the project Compliance for all documentation including Test plan, Test cases and Test Summary Artifacts.
• Assisted in identifying missing/erroneous data, disparities/ inconsistencies between data sources as well as validating accuracy and consistency with stated business rules.
• Created defect log and metrics summary to report to the management.
• Co-ordinated with Off-shore team members for various testing activities.

Environment: Windows 10, Informatica 10/10.2, OBIEE 11g, IBM Data Studio 4.1.3, HP ALM (Application life cycle management)12.53, SQL, PLSQL, Oracle 11g, UNIX, Informatica DVO 10.2.0,Toad