PROFESSIONAL SUMMARY:

• More than 14 Years of experience in manual testing and ETL Testing. Performed ETL QA lead, Senior Test analyst/Data Analyst in Software Quality Management System in various organizations.
• Proficient in leading the efforts for various frameworks like Data Validation Framework, Data Reconciliation Framework and Count Validation Framework.
• Proficient in SQL programming.
• Implement the ETL Process using Python, AWS Athena, Redshift and Hive SQLs, Informatica Cloud and SSIS Packages.
• Design and develop the database and its tables in SQL server, MYSQL and Amazon Redshift/Athena.
• Ability to work on service - oriented architecture and agile processes for data analytics and AI infrastructures.
• Possess a strong understanding of object-oriented programming and design.
• 7+ years of experience as a ETL QA Lead.
• Proficient experience in Testing FE websites like realtor.com, Confidential, Confidential .
• Highly skilled on conducting UAT, QAT and Expert in creation of test bed and test data for large projects.
• Migration, Import and modulation of the Data by using data warehousing tools.
• Expert in running various kinds of tests such as Unit, Integration, System, Regression, User Acceptance Test, Performance-Load & Stress, Backend for Client/Server, web and windows Applications.
• Expert in Bug reporting with Quality Center, Test Track, Jira and Clear Quest.
• Extensive experience working with Business and Functional Requirements in analyzing and designing Test Plans, Test Cases, Verifying and Validating Web based applications and Documentation based on standards for software Development and effective QA implementation in all phases of Development lifecycle (SDLC)
• Experience in ETL Testing and Data warehouse tools. Conducting Data compare using ETL tools.
• Extensive experience working with ETL tools like Informatica and SSIS .
• Extensive experience working with Amazon web services Redshift, Athena and S3.
• Worked with Development team and Business Analysts to analyze the test scenarios and ensured that test requirements are correct and completed
• Extensive experience in coordinating testing efforts, responsible for test deliverables, status reporting to management, issue escalations.
• Hands on Back-end testing experience in writing and executing SQL Queries.
• Strong Communication and Interpersonal skills to maintain effective work relationships with all levels of personnel. Clear Understanding of Business Rules and Ability to work as a part of team.
• Strong analytical and project management skills with the ability to manage multiple tasks simultaneously, resolve problems and present appropriate business solutions and recommendations.
• Strong experience in debugging and troubleshooting various applications running in Production and Test environment.
• Utilized strong interpersonal skills, proven leadership capabilities, goal-orientation, as well as technical and non-technical problem solving abilities to achieve company and client goals.
• Involved in Lotus Notes to Moss Migration Testing
• Reviewed user Stories in Product Backlog and Sprint Backlog
• Created Testing Tasks of testing and assigned to Team Member.
• Monitor Testing Tasks on Daily Basis
• Attended following Scrum meetings:
• Sprint planning meeting
• Daily Scrum Meeting
• Scrum of Scrums
• End Meetings
• Sprint retrospective Meetings
• Escalated and discussed impediments to Scrum Master and Product Owner.

EXPERTISE IN:

• Agile SCRUM Test Lead
• Test Coordination
• Non - Functional Testing
• Database Testing
• Mobile App Testing
• Web Service Testing
• ETL Testing
• Migration Testing
• Defect Tracking
• Test Reports
• Lotus notes Testing
• Share point application testing.
• Informatica cloud

TECHNICAL SUMMARY:

Operating Systems: Windows 95/98/XP/NT/2000, Mainframe.

Languages: HTML, XML, JavaScript, Java.

Databases: SQL Server2000/2005

Packages: Clear Quest, TFS and VSS.

Database Utilities/Tools: PL/SQL

Testing Tools: Test Director, Quality Center, ETL

Protocols: TCP/IP.

PROFESSIONAL EXPERIENCE:

Confidential

ETL-QA Lead

Responsibilities:

• Responsible for test planning, test management, devise test strategies, effort estimation, and risk analysis.
• Involved in Agile testing Team and led successfully Agile Team for multiple sprints towards completion.
• Used Rally for creation and tracking of agile tasks.
• Performed System, Functional, Integration, End to End, User Acceptance testing and Regression testing activities in Test environment and Production support environment
• Performed System, Integration, and Regression testing activities in Test environment and Production support environment.
• Performed manual testing and maintained documentation on different types of Testing viz. Positive, Negative, Performance and Black Box
• Working with Offshore by assigning the tasks & monitoring them. When required provide knowledge sharing sessions.
• Communicated with Manager, project lead daily for testing efforts and sent Status Reports as needed like Daily and Weekly.
• Interacted with development team in discussing/resolving various application defects.
• Track and report upon testing activities, including the test case execution stage, defect status if any defects opened during execution and the testing results status.
• Attended application walk-through and reviewed Requirements to understand the scope of the project and Attended project meetings as needed and Coordinated with the Developers to resolve the issues/defects.
• Performed Backend testing Using the tool SQL Commands extensively.
• Run the queries and reports to validate the results.
• Responsible for Production shakeout testing for every release.
• Responsible to tactfully communicate with project managers, development managers, release managers and developers to ensure comprehensive test planning and execution.
• Take offshore calls and resolve work related issues and review the day to day work deliverables.
• Extensively used SQL scripts/queries for data verification at the backend.
• Participated in requirements walkthroughs with users to get better understanding.
• Created various presentations for Clients explaining new functionality flows.
• Interacted with development team in discussing/resolving various application defects.

Tools: SQL Developer, .Net, Jira, SQL Server 2005, ETL,Informatica Cloud, Redhsift

Confidential

QA Lead

Responsibilities:

• Performed System, Functional, Integration, End to End, User Acceptance testing and Regression testing activities in Test environment and Production support environment
• Performed System, Integration, and Regression testing activities in Test environment and Production support environment.
• Performed manual testing and maintained documentation on different types of Testing viz. Positive, Negative, Performance and Black Box
• Understanding the Functional Specifications.
• Preparing of Test Cases.
• Reviewing, Rework if needed and Executing of Test Cases.
• Prepared a ‘Scenario document’ for each of the applications, which listed the major scenarios and conditions to be tested for MS Office 2010 and IE8 upgrade.
• Performed Browser compatibility testing by testing the application in different browsers like IE 6 and IE8.
• Involved in defect tracking and reporting by using IBM Rational Clear Quest Tool.

Tools: Lotus Notes, MOSS, IE8, Office 2010

Confidential

Sr. QA Engineer

Responsibilities:

• Performed System, Functional, Integration, End to End, User Acceptance testing and Regression testing activities in Test environment and Production support environment
• Performed System, Integration, and Regression testing activities in Test environment and Production support environment.
• Performed manual testing and maintained documentation on different types of Testing viz. Positive, Negative, Performance and Black Box
• Understanding the Functional Specifications.
• Preparing of Test Cases.
• Reviewing, Rework if needed and Executing of Test Cases.
• Understanding the Functional Specifications.
• Preparing of Test Cases.
• Reviewing, Rework if needed and Executing of Test Cases.
• Performed Functional Testing, Regression Testing.
• Performed Browser compatibility testing by testing the application in different browsers like IE 6, IE 7, Mozilla Firefox and Safari.
• Involved in defect tracking and reporting.

Tools: Quality Center 10.0, XP Professional, Web Logic, XML, JAVA.

Confidential

QA Engineer

Responsibilities:

• Performed various functions prior to conducting tests such as data analysis and mapping.
• Developed solid test documentation and created and maintained comprehensive test plans and test cases.
• Coordinated with developers and prepared and implemented test plans.
• Created Test Cases in Quality Center and RTM and mapped Test Cases to Requirements in Req Pro.
• Managed and conducted System testing, Integration testing and Functional testing.
• Worked on SQL scripts to load data in the tables.
• Analyzed tests results and identified areas where regression tests could be conducted.
• Developed and customized scripts for file system monitoring the daily Logs.
• Participated in requirements gathering, mapping the customer requirements and designing solutions for various clients.

Tools: HTML Java Script, VB Script, Java, DB2, Oracle 8i