SUMMARY

• A self - starter, team player, worked on fast-faced agile environments committed to the deliverables within short sprints.
• Experience using Version One and TFS for managing daily updates in agile teams.
• Strong understanding of full software development life cycle (SDLC), requirement analysis, design, development, testing, and implementation.
• Experience in Test Plan/Test Strategy, created Business Assurance Strategy documents and clearly stating the scope of testing, business risks involved and mitigation strategies.
• Experience in creating Test Completion Reports with all test results of the testing process.
• Experienced in Banking (Mortgage and Auto and Card Financing), Telecom, Retail and Public Sectors
• Involved in development of system/integration test documents, status reporting, requirements traceability, risk analysis, scheduling, estimation, setting timelines and milestones, prioritization and scope determination for projects.
• Hands on experience in Database and Data warehousing technologies.
• Experience in using Quality Center (QC)/ Application Lifecycle Management (ALM) for managing test cases and test procedures and used as Defect Tracker.
• Expertise in backend testing - ETL (Abinitio, Data Stage, SSIS), Reports (Business Objects) data validations on business logics / transformations by monitoring the data flow from source to target using the transformation logic.
• Good knowledge on Java and Python.
• Expertise testing scheduling process using tools like Autosys and Control - M scheduling tool.
• Tested the data at report level in business objects reports developed on the presentation layer tables by writing complex queries and join conditions.
• Experience testing XML parsing in data warehouse.
• Experience testing HTML, JavaScript, Java and Dot Net.
• Experience working with Sales Force testing.
• Experience testing Type1 and Type2 Dimensional Model and objects.
• Experience Testing the Rule Engine in the ETL integrated with Frontend (GUI).
• Extensive experience in writing multiple SQL statements - Data retrieval, DML and DDL.
• Proficient in writing SQL queries and experience in UNIX, LINUX and WINDOWNS environments.
• Experience in the Relational Database (OLTP) and Data Warehousing Systems (OLAP)
• Good understanding of Data Modeling including ER,StarandSnow Flakedata models.
• Experience in performance testing the of Data warehouse.
• Experience using different databases likeOracle,Netezza, DB2, Teradata and SQL Server.
• Proficient in using UNIX executing jobs and validating data in UNIX environment.
• Experience using TOAD, WinSQL, SQL Developer, SQL Server Management Studio and Teradata query Analyzer for back end testing.
• Experience using QTP - Used the new keywords and functions created in QTP for regression Testing.
• Experience with Automation tools likeTOSCA, Selenium and Used Confidential compare for testing.
• Good Interpersonal relations, Communication, Management and Documentation Skills.
• Interact with offshore testing teams and co-ordinate testing delivery efforts on daily basis.

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL QA Analyst - Test Data Support Lead

Responsibilities:

• Involved in testing data flowing between Legacy systems and Data Warehouse(ETL).
• Mined and Conditioned Test Data to support migration projects to test ETL and other functional scenarios as part of Test Data Management Team(TDM).
• Executed Imports to Extract data from different source DBs (SQL,Oracle etc.) to create a test bed and test data.
• Involved in daily scrums and requirement grooming sessions and technical analysis discussions
• Also involved in created Datastage Jobs and using Autosys for scheduling and executing jobs for a migration project and performing unit testing.

Confidential

Data Warehouse QA

Responsibilities:

• Participate in story grooming sessions, estimating and daily scrums
• Create test plan and test cases based on the requirement and source to target mapping document and review with the team
• Using TFS (Agile tracking tool) for tracking agile stories, test execution and defect tracking.
• Execute ETL (Data stage) jobs and validate data from multiple sources to multiple targets based on the
• Source to Target mapping/requirement.
• Test the data structures, Initial data loads, updates and inserts.
• Validate type1 and type2 updates on the tables
• Used UNIX to run the jobs and verify error logs at the backend.

Confidential

Data Warehouse QA lead

Responsibilities:

• Involved in requirement gathering and analysis discussions.
• Involved in daily scrums and requirement grooming sessions and technical analysis discussions in agile environment.
• Created and maintained documentation needed by test team (test plan, test summary, test cases etc).
• Worked on Abinitio Control Centre to execute and monitor Jobs.
• Performed risk analysis and impact analysis to facilitate Functional, Regression Testing.
• Tested the data flowing from a web applications to data warehouse and reports.
• Worked on Performance testing of the data warehouse jobs.
• Prepared the Test data for the ETL process and compared the results to match the functionality.
• Extensively Used UNIX scripts and SQL queries for testing.
• Created test results document at the completion of entire testing process.

Confidential

Data Warehouse QS lead

Responsibilities:

• Review the requirements in grooming sessions with the business and identify the scope of testing and provide testing estimates.
• Worked closely with Business Analysts and Risk Owners to determine the scope of test.
• Created Business Assurance Strategy documents and clearly stating the scope of testing, risks involved and mitigation strategies.
• Attend daily scrums and update the scrum tracking tool ‘Version One’ on a daily basis.
• Worked on traceability matrix documentation to ensure all the requirements are covered.
• Validated the ETL transformations and validated the target data loaded to Reporting and analytical databases.(SQL server and Teradata).
• Validated the data flows from source to abinitio clean files and target tables.
• Coordinated with offshore team and onsite teams on day to day activities in the team.
• Create and upload Test Cases and track defects to ALM.
• Used SQL Developer Teradata for performing Backend Testing.
• Use UNIX to run the jobs in test environment and to check the connectivity to the database and query the database from UNIX.
• Tested the scheduling jobs using Control - M scheduling tool.
• Monitored the script execution through the Web EME.
• Worked with the DMLs in UNIX to identify NPI data for TDM to scrub the source data.
• Request/Prepare test data for System Testing and UAT testing with the help Test Data Management Team.
• Supported UAT with the business for successful UAT completion and signoffs.
• Create Test Completion Reports with Test results matrix and provide System Test signoff.
• Knowledge on Hadoop and Bigdata architecture and concepts.

Confidential

Data Warehouse QS lead

Responsibilities:

• Managed Onsite-Offshore resources.
• Conducted the Review meetings and mentored the offshore resources.
• Developed generic graphs to extract data from databases and from flat files for QS purposes.
• Created/ Updated Test plans (including estimating and maintaining a testing schedule) to ensure coverage and conformance to requirements.
• Gained thorough understanding of fact and dimension database model.
• Performed risk analysis and impact analysis to facilitate Functional, Regression Testing.
• Created RTM document and uploaded it to QC to ensure that all requirements are tested.
• Resolved issues of various severities during different stages of testing on time.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Analyzed data and ensured that it was accurate.
• Wrote stored procedures and Triggers using SQL Management Studio and Teradata for data validations.
• Identify, research, report, track and verify software defects proactively and comprehensively.
• Loaded UAT data for business users and provided extensive support until signoff is received.
• Created shell script to back up files using UNIX, and then automated the process.
• Worked with the development team to create staging tables, loaded them with data and used it for data validation against the target data.
• Assisted the development team to schedule the scripts automatically in test region using control-M scheduler.

Confidential

Quality Services lead

Responsibilities:

• Worked with the business to understand the scope of system testing for every sprint.
• Created Test Plan/Strategy (Business Assurance Strategy) with the clear scope of testing and data requirements.
• Performed risk analysis and impact analysis to facilitate Functional, Regression Testing.
• Tested the GUI/ Front End interface and compare with the data in the data warehouse to meet the business transformation.
• Developed generic graphs to extract data from databases and from flat files for QS purposes.
• Extensively tested the data movement from GUI to backend and backend to GUI with multiple scenarios.
• Conducted the Review meetings and mentored the offshore resources.
• Supported business user for successful UAT.
• Created Test Completion Reports with metrics and got approvals from the business.

Confidential

Quality Analyst

• Interacted with all levels of the software team to develop testing requirements for the new projects and also on enhancements of the existing telecom projects.
• Performed risk analysis and impact analysis to facilitate Functional, Regression Testing.
• Created RTM document and uploaded it to QC to ensure that all requirements are tested.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Associate all test inputs (Business Requirements) to the test case.
• Created and maintained documentation needed by test team (test plan, test summary, test cases etc).
• Performed interactive walkthroughs of test scripts with developers, business users and Business Analysts.
• Prepared Test Cases for the ETL mappings that load data into various tables confirming to the business rules.
• Perform routine analysis of data to ensure integrity and quality of data.
• Written SQL Scripts to extract data from Database and for testing purposes.
• Analyzed the data and the data flow of the existing system to better understand the compatibility of the data with the data model of the new system.
• Involved in validation of analysis datasets, tables and listings using Proc compare and code walk-through.
• Maintain accurate documentation of procedures and communicate list information with multiple feeds
• Responsible for System Integration and UAT (User Acceptance Testing).
• Developed Test Cases and Test Scripts based on requirements in Mercury Quality Center.
• Created XML files and tested the web services.
• Worked with SQL to test the database integrity (Oracle).
• Used Mercury Test Director / Quality Center for managing the defect flow.
• Worked with SQL queries and UNIX shell scripts.

Confidential

Test Analyst

Responsibilities:

• Supported the BI development and testing project.
• Worked on Business Objects webi XI report creation based on the requirement document.
• Supported on ETL enhancements project.
• Unit tested the Business Objects report and ETL code.
• Created Training Documents, User manuals for Support, Trainees and End users

Confidential

Test Analyst

• Developed Test Plans, test cases, test scenarios and test data for the new data migration project according to specifications.
• Involved in manual and automated testing.
• Tested the end to end functionality of E-Commerce projects.
• Developed multiple complex SQL statements to test the accuracy of the data migrated to the Portal system.
• Developed, executed, and maintained scripts using TestDirector.
• Developed and implemented various scripts using WinRunner of each individual functionality of the application.
• Used Test Director to store all testing results, metrics, implemented test plan document, created test cases, defect tracking and reporting.
• Performed functional, integration, white-box, black-box, system, regression and user acceptance tests.
• Automated the TSL scripts in Winrunner.
• Analyzed the use cases provided by analysts and wrote test cases.
• Analyzed the functionality and wrote test cases for both functional and regression testing
• Performed functional, regression, integration, cross browser and GUI testing manually.
• Performed backend testing by writing SQL queries.
• Defects are tracked and reported using Test Director.
• Reported tracked defects with reference to severity and types.
• Interacted with analysts and developers to resolve the issues.