SUMMARY:

• Around 7 Years of IT industry experience in manual testing on web based, Client/Server and data warehousing applications.
• Excellent working experience of various stages of Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC).
• Good retail experience and tolling experience.
• Experienced in build verification, Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box, white box, positive, negative, boundary level testing and GUI testing.
• Experienced in testing Back - End Jobs, ETL, Data Conversion & Interfaces and web application testing.
• Knowledge of Database Schema, Data Model, Data Dictionary, Meta Data.
• Experience working in AWS RDS instances, EMR, EC2 clusters, Big Data.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Good understanding of Source -2- Target column mappings, SCD and Data transformations.
• Good ability in Analyzing Requirements and Development of RTM, Test Plans, Test Procedures, Test Cases/Scenarios.
• Experience in SQL and PL/SQL scripting, querying and testing RDBMS such as Oracle, Netezza, MS SQL Sever using SQL, PL/SQL for data integrity.
• Worked with jQuery to customize the UI.
• Experience in working with Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies. .
• Good Attention to Detail, Good verbal & written communication skills with ability to work as an individual and as a part of a team.

SKILL:

Operating Systems: MS-DOS, Windows 95, 98, NT, XP, 2000, Sun Solaris, HP UNIX, Linux

Languages: C, C++, Java, SQL, PL/SQL, UNIX Shell scripting

ETL Tools: Syncsort, Informatica, HDFS, Hadoop/ Hive, Hue

RDBMS: Oracle, Netezza, JAVA, MS-Access, MS SQL Server SQL, TOAD, PL/SQL

QA Automation: QTP, Selenium

Defect Tracking Tools: JIRA, ClearQuest, HP Quality Center

Version Control Tools: Clear Case

Web Servers: IBM Web Sphere, Web logic, BizTalk

Internet Technologies: JSP, HTML, ASP, VB Script, DHTML, XML

Miscellaneous: Jquery UI, MS-Office Suite, Siebel CRM, Tableau, Microstrategy, Crystal Reports, SOAP UI

Assignments:

Confidential, NY

Environment: MS-SQL Server 2008, JIRA, JAMA, Siebel, Jquery UI, SOAP UI, Linux, Selenium, Sharepoint, Crystal Reports, Tableau, MS Office.

Senior QA Analyst

Responsibilities:

• Worked on multiple projects like Florida and New York EZ Pass Tolling systems as a QA lead role in them responsible for the overall testing, test strategy, testing guidelines and handing off deliverable.
• Worked on back end SQL scripts, running batch jobs in Linux and testing user interfaces.
• Was responsible for working on weekly status of the Testing team/ progress on various functionalities testing and the JIRA status.
• Designed UI using jQuery UI and customized the same by using utilities, effects and widgets.
• Prepared Test Plans/ Test Documents/ Test Scenarios for key project areas which varied from project to project in “Agile” environment.
• Performed Integration Testing/ Functional tests for complex Test Cases that needed Integration between back end and front end applications.
• Conducted manual testing involving all the modules, Defect Identifying, Logging, tracking & Reporting, and subsequent Re-testing of Defects/Enhancements, Defect analysis & Defect aging.
• Participated in Daily Synchs or daily project huddles, Regular Test Meetings in Agile methodology.
• Worked with other team members to get an insight into the project as well as the challenges that needs to be addressed as far as testing is concerned.
• Regressive testing on Siebel application.
• Performed System/Regression and Final User Acceptance testing and executed test scripts and reported any defects utilizing JIRA
• Worked with AUTOMATION Scripts using Selenium.
• Extensively worked on Data extraction, data analysis, data validation and preparing dummy test data…
• Worked on audit documents and regression scripts and process improvement on the same.
• Performed data validation using SQL Server 2008 to make sure ETL, Stage and Data warehouses are loaded as per Source to target Mapping Rules and DTLM document.
• Worked on SOAP UI web services and web applications like TBM, EZ Pass web basically user interacting websites
• Tested the data results by documenting and making sure it matches up to what is required as per the business document.
• Created Test /dummy data for the testing team for various scenarios for the application under test and involved in all phases of test life cycles of every project.
• Co-ordinated with Offshore and Onshore team members including the developers, BA, Project manager etc to successfully execute CAT alongside with Client Counterpart.
• Ensured that all the team members are aware of the test scenarios, issues, concerns etc by communicating effectively to the whole group in SCRUM meetings.
• Performed testing by updating Test Status in JAMA and created Test Reports and updated the status to the Test Director/ Test Manager on regular basis in daily huddles.
• Travelled to client site and was an active member during the RFR and Dry run tests as well as in the final CAT.

Confidential, Columbia, MD

Environment: MS-SQL Server 2008, Netezza, TOAD, JIRA, QTP, Quality Center, RedPoint Campaign tool, Alterian Campaign tool, Business Objects, Tableau, MS Office.

QA Analyst

Responsibilities:

• Worked on many retail projects like Sanofi, Bose, Microsoft, RCI, and The Limited within a short span and with stringent deadlines, played a QA lead role in all of them responsible for the overall test Framework, test planning and handing off deliverables.
• Have a very good functional knowledge and experience in testing and analysis of the retail applications during the testing.
• Tested the back end by generating SQL scripts for data verification as well as front end or User Interface in all the projects.
• Testing data pipelines from staging to HIVE targets in HUE.
• Prepared Test Plans and Test Cases for key project areas which varied from project to project in “Agile” environment.
• Performed Integration Testing for complex Test Cases that needed Integration between Client and Confidential campaign capabilities.
• Conducted Manual testing involving all the modules and automation testing using QTP, Defect Identifying, Logging, tracking & Reporting.
• Participated in Daily Synchs or daily project huddles, Regular Test Meetings in Agile methodology.
• Worked with other team members to get an insight into the project as well as the challenges that needs to be addressed as far as testing is concerned.
• Performed System/Regression and Final User Acceptance testing and executed test scripts and reported any defects utilizing JIRA
• Performed data validation using SQL Server 2008 to make sure ETL, Stage and Data warehouses are loaded as per Source to target Mapping Rules and DTLM document.
• Prepared Requirements Traceability Matrix wherein tested for each business requirement by framing test cases
• Tested the data results by documenting and making sure it matches up to what is required as per the business document.
• Prepared Test Reports and updated the status to the Project Manager/ Solution Manager on regular basis in daily huddles.
• Created Test data for various scenarios for the application under test and involved in all phases of test life cycles of every project.
• Co-ordinated with appropriate team members including the developers, BSA, Campaign manager etc to successfully execute UAT alongside with Client Counterpart.
• Ensured that all the team members are aware of the test scenarios, issues, concerns etc by communicating effectively to the whole group in SCRUM meetings.
• Conducted the campaign test report validation using Business objects.