SUMMARY

• Around 7+ years of IT experience in Quality Assurance and Software Testing of various business applications in Client/Server environments and Data Warehousing solutions.
• Strong knowledge of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall, Agile.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
• Have solid experience on database query tools such as TOAD, SQL Navigator, and SQL Assistant.
• Experience on UNIX commands and Shell Scripting.
• Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress Testing, Smoke Testing, Recovery Testing and GUI Testing.
• Strong experience in preparing documentation, preparing test environments, executing and analyzing the results.
• Involved in testing the batch jobs, using UNIX and Autosys.
• Have experience in testing reconcile (initial) and delta (daily) loads.
• Have tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.
• Experienced in using the Oracle SQL* Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like HP Quality Center/ALM, Clear Quest, TFS - Team Foundation Server, Rally.
• Expert in writing complexSQL queries for back-end testing.
• Experience in interacting with Clients, Business Analysts, UAT Users and Developers.
• Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
• Knowledge on the phases of agile methodology and scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.
• Experience in Automation Testing through Test complete tool.
• Have keen knowledge in Test complete tool like cross browser testing.

TECHNICAL SKILLS

QA Methodologies: Iterative, Agile, Waterfall and Spiral Methodology

QA Tools: Hewlett Packard (HP) - Quality Center, Test Director IBM / Rational - Clear Quest, TFS - Team Foundation Server

DBMS Tools: TOAD, Rapid SQL, SQL Developer, SQL Navigator

Operating Systems: Microsoft Windows - Vista, XP, 2000, NT 4.0, OS/2 UNIX - Sun Solaris

Databases: Oracle 10g, 9i, 8i, Sybase

Microsoft: MS Access, SQL Server 2005/2008

IBM: DB2, DB2/UDB, Teradata V2R6, V2R5, Hadoop

Languages: SQL, PL/SQL UNIX Shell Scripts, VB Script, Java, C

Version Control Tools: Clear Case, DOORS, Requisite Pro

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

Sr. QA Analyst/DW/BA/Data Analyst

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible to translate business requirements into quality assurance test cases.
• Review of test scenarios, test cases and Data warehouse Test Results.
• Involved in business processes and quality assurance on testing across entire product life cycle stages from requirements to implementation.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL Informatica tool from the requirements.
• Create user stories and task in Rally and also track defects in Rally.
• Used Quality center for test scripts repository and Clear Quest for defect tracking.
• Prepared daily Status report after executing of scripts from the Quality center.
• Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Coordinated with development team for bug tracking till closure, preparation ofSQArelease reports, Test summary reports and monthly metrics.
• Involved in running data stage jobs using data stage director.
• Assisted in generating Post Deployment Scripts and UAT scripts.
• Queried data from different database tables as per the requirement by writing complex SQL queries for data validation.
• Extensively used UNIX commands for fetching and checking the Log files.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Testing has been done based on Change Requests and Defect Resolved.
• Effectively coordinated with the development team for resolving defects.
• Having experience working on BIGDATA environment in EDW level. Knows how to connect with database and also can write query as command line level in HIVE. Extracting data in .csv or .txt format.
• Having experience testing the data flow in HADOOP as the end user requirement. Worked on partitions based on dates or flags or keys followed by the requirements of clients.
• Used to create own data table for testing. Worked on Source table, Materialized View table, Target Table, Pre production and Production tables.
• Experience writing sql queries for multiple tables which are joined as left outer or right outer or inner joined to find the accuracy of the data.
• Worked on different kinds of functions Worked on primary keys, foreign keys, Null values and duplicate queries.
• Having experience writing user stories as parent and child stories for Scrum Master and also assigning task to the required person.
• Divide the points and hours to the stories as 50% points goes to QA. Manage defects and also maintain the flow of work based on hours for each and every sprint.

Confidential, Charlotte, NC

Sr. QA Analyst/DW/BA/Data Analyst

Responsibilities:

• Analyzed the Requirements from the client and developedTest cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Verified the logs to identify the errors occurred during the ETL execution.
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Have tested reconcile and incremental ETL loads for the project.
• Exclusively used test plan module to write and test lab module to execute the test cases in HP Quality Centre/ALM.
• Exclusively used requirement module for requirement and defect module for entering the defects in HP Quality Centre/ALM.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.
• Have experience working on Big tables with enterprise data level. Experience working with DML & DDL language. Used to create own data table for testing.
• Worked on Source table, View table, Materialized View table, Target Table, Pre production and Production tables.
• Experience writing sql queries for multiple tables which are joined as left outer or right outer or inner or full joined to find the accuracy of the data.
• Used to create own data from the UI and check it in the database in different environment like SIT, UAT for the exact flow of data by writing Sql queries in toad and Teradata.
• Worked on partition and history tables as well as for the follow up of data. Worked on different kinds of functions, sub functions, case, loops etc. Worked on primary keys, foreign keys, Null values, and duplicate queries.
• Worked on create release and sprints, write requirements, write test cases for different environments and connect test cases with the requirements, track defects. Knows how to manage artifacts in QC.
• Worked on SIT environment to check everything is performed as the client’s requirements. Managed and participated in everyday meetings of the SIT team to follow up the updates.
• Worked with multiple offshore team. Wrote HLD, LLD data mappings. Wrote test plan and test cases for SIT environment and also check with developers if there are any defects.
• Participated in the project planning meetings and also with the developers if there are any concern on project or data.
• Have experience writing SIT sign off and SIT exit documents as well as the risk management of every particular sprint or release.
• Worked on UAT environment to check everything is performed well in SIT and also as the client’s requirements.
• Managed and participated in everyday meetings of the UAT team to follow up the updates of UAT and SIT.
• Write test plan and test cases for UAT environment and also check with SIT team and developers if there are any defects of if any requirement has bypassed or missed.
• Participated in the project planning meeting. Have experience writing UAT sign off and UAT exit documents as well as the risk management of every particular sprint or release.
• Always try to have good knowledge of the project so that the meeting runs well with the End user or Client’s proposed requirement. Try to understand client’s requirement.

Confidential, Lorton, VA

Sr. QA Analyst/DW/BI Tester/Data Analyst

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible to translate business requirements into quality assurance test cases.
• Review of test scenarios, test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Responsible in testing Initial and daily loads of ETL jobs.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports andSQAReport.
• Participated in enhancement meetings, investigated software bugs, and helped the developers to resolve technical issues.
• Manually tested the applications and handled Test Cases through Test Management tool Quality Centre/ALM.
• Analyzed Test Results and generated Defect Reporting and tracking via Quality Centre/ALM 11. Consolidated and presented regular updates to project team management.
• Generated Test Execution and Defect Summary reports from Quality Centre to the management and Product owners
• Planned ahead of time to test the mapping parameters and variables by discussing with BA’s.
• Extensively tested several Business Objects BOXI Reports for data quality, fonts, headers, footers, and cosmetics.
• Extensively involved in testing theETLprocess of data sources, Teradata, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.
• Executed automated test scripts using QTP for Regression testing.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Responsible for documenting the process for future references.
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Confidential

QA Analyst

Responsibilities:

• Developed Test Plans, Test Strategies and Test Cases.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Tested various Mappings & Mapplets to load data from Open Data Source using different transformations.
• PerformedextensiveBack end testingusing SQL Queries,to verify the integrity, consistencyof thecolumn values, validated column to column mappings, field value counts.
• Extensive testing on the Performance of the Stored Procedures in PL/SQL.
• Developed UNIX shell scripts to format the session log files and to extract the information from error logs.
• Used Test Director as defect tracking tool.
• Set up database backup and recovery strategies.
• Validated various web interfaces according to functional requirements.
• Performed Data Validation of the data flow from the front-end to the back-end.
• Responsible for performing GUI testing
• Performed Regression and Functionality Testing.
• Investigated software bugs and interacted with the developers to resolve the issues
• Interacted with Business Analysts, Developers and QA team members in different defect raising situations.