SUMMARY

• Over 7 years of IT experience in Quality Assurance for Web Based, Client/Server applications.
• Expertise in Analyzing Business Specifications and develop Test Plans, Test Cases and Test Scripts and execute them.
• Experience with test management and test automation tools like HP ALM, Team Forge, Box, TFS, Selenium and Informatica.
• Worked in important phases of Software Testing Life Cycle (STLC) like Smoke Testing, Functional Testing, Integration Testing, Regression testing, System Testing, End to End Testing, ETL Testing and User Acceptance Testing (UAT)
• Extensive experience inETL testing for many data migration projects using ETL Informatica.
• Comprehensive knowledge and experience in software development life cycle (SDLC) with business process models: waterfall & agile (Scrum) methodologies.
• Implemented Page Objects Design, Keyword Driven, Hybrid automation framework using SELENIUM, JAVA and TestNG.
• Experienced using Web - debugging tool like Fire Path and Firebug for finding elements locator.
• Hands on experience in designing and implementation of Selenium WebDriver Automation Framework for Smoke test and Regression test using TestNG.
• All testing engagements completed within project timelines and consistently met live-date project deadlines.
• Proven ability to work efficiently in both independent and team work environments.
• Experience in writing test plans, defining test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements, documented all phases of QA process.
• Extensively used Autosys for Job monitoring, batch Jobs andscheduling.
• Performed backend database testing by writing SQL scripts to verify dataintegrity.
• Experience using TDM Tool to compare tables between two differentdatabases.
• Experience in creating service now request for database refresh, creating OSA ID, AD Groups, SPP Request.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile-SCRUM

Defect Tracking Tools: TFS, HP ALM, Team Forge, JIRA

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, ETL, Informatica Power Center

Databases: SQL, Sybase, Oracle 9i, 10g and 11g.

Languages: C, C++, .NET, JAVA, C#, Perl, Gherkin

Web Services: Soap, Rest, JSON.

Web Technologies: XML, HTML, JavaScript, VB Script, Selenium, Test NG.

Operating Systems: Windows 10, MS-DOS, UNIX.

Tools: Rapid Sql, Eclipse, Toad, Win SQL, PVCS, CSS.

Office Tools: MS Word, Excel, Access, Power Point, Microsoft Share Point.

PROFESSIONAL EXPERIENCE

Confidential, Connecticut, CT

Selenium Tester

Responsibilities:

• Analyzed the functional specification document and Use Cases for testing the application, as well as preparation and execution of Test Cases according to the business document specifications.
• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Performed Functional, regression, System, Integration Testing and User Acceptance Testing for the new CART enhancements.
• Configured SeleniumWeb Driver, TestNG, Maven tool and created Seleniumautomation scripts in java using TestNG prior to agile release.
• Used Selenium Web Driver for testing application in different browsers.
• Used firebug tool for finding Xpath of the Web Elements.
• Used Eclipse as an IDE for developing Java/Junit/Selenium code.
• Created Automation script using Selenium WebDriver and executed scripts on different browsers.
• Involved in Database testing to verify data integrity tests.
• Attended weekly review meetings to discuss defects along with testers and Developers.
• Used SeleniumWebDriver APIs for writing TestNG test suites and test cases for testing functionality.

Environment: Windows 10, Team Forge, Selenium, HP ALM, Box, JIRA, SQL, XML, Java, Oracle, MS Office, Toad and REST.

Confidential, McLean, VA

QA/Database Tester

Responsibilities:

• Worked closely with business management, development team, UAT team to understand the objectives for betterresults.
• Responsible for analyzing Perl Programs and creatingtest scenarios, test cases.
• Participated in Sprint Planning and Grooming sessions of User Stories as part of Agilemethodology.
• Used TFS for Project related Documentation and Sprint related work in the project.
• Actively participated in standup meetings, story reviews, and retrospectives of the Agile process.
• Automated and scheduled the ETL jobs using UNIX Shell Scripting, AutoSys.
• Extensively used Autosy’s for Scheduling and monitoring batch jobs.
• Developed and executed SQL Queries to verify the database updates, inserts and delete of the records.
• Used TDM Tool to compare tables between two different databases before and after executingJobs.
• Established Traceability between the Requirements and the Tests in Traceability Matrix using TFS.
• Extensively used Rapid Sql to test data by writing sql queries in Sybaseserver.
• Wrote Sql queries to validate data between Perl and .NetJobs.
• Experience using Beyond Compare tool to validate textfiles.

Environment: TFS, Perl, Sybase, C#, GIT, Rapid SQL, TDM Tool, Autosy’s, Beyond Compare, Unix, Visual Studio.

Confidential, Connecticut, CT

ETL Tester

Responsibilities:

• Extensive experience working on multiple projects such as GeCA, CART, MTRT/PMT,Xavo.
• Experience working with different modules of CART (SCMApplication).
• Worked closely with business management, UAT team to understand the objectives for betterresults.
• Performed GUI testing, integration testing, regression testing, Ad -hoc testing, negative testing on multiple projects.
• Created appropriate test cases, test scenarios, logged defects in HP ALM.
• Worked with the developers, UAT Team and involved in production testing, was engaged in full cycle of testing from start to end.
• Used Toad to run the queries for the oracle database.
• Involved in data warehouse testing by checkingETLprocedures/mappings.
• Performed all aspects ofvalidation including functional, integration, regressionand system testing.
• Tested ComplexETLMappings and Sessions based on business user requirements and business rules to load data from source tables to target tables.
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETLtest data for allETLmapping rules to test the functionality of the Informatica Mapping.
• Tested theETLInformatica mappings and otherETLProcesses (Data Warehouse Testing).
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Communicated timely project status to appropriate levels of management.
• Mapped Test Cases to Requirements.
• Involved in extensive DATA validation by writing Complex SQL queries and involved in back-end testing and worked with data quality issues.
• Assured customer satisfaction with proper documentation and reports, understand relations between different tables and wrote queries using Joins, where conditions, date functions, viewsetc.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.

Environment: Windows 10, Team Forge, Informatica, HP ALM, HP PPM, Box, JIRA, SQL, XML, Java, Remedy, Oracle, Unix, MS Office, Toad, REST.

Confidential, Jersey City, NJ

QA Tester

Responsibilities:

• Responsible for creating completetest cases,test plans,test data, andreporting statusensuring accurate coverage of requirements and business processes.
• Performed ETL testing using Informatica (Power center), to extract, transform and load test data on the test environment.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Involved in developing detailed Test plan, Test cases and Test scripts using HP/ALM.
• Created Requirement Traceability Matrix to map between the requirements and test cases.
• Participated in defect review meetings with the team members and developers.
• Checking the data flow and extensively using SQL Queries to extract the data from the Database.
• Created and tested UNIX Shell scripts to verify the archived data in QA Server and to execute SQL scripts.
• Tested web services using SOAP UI (SOAP Web Services).
• Wrotecomplex queriesto compare the counts and data from source to target.
• Automated the Shell Scripts to load the data in timely manner.
• Constructed, maintained, and conducted Smoke test for UAT environment.
• Identify defects in aggregate tables and report data, enter defect in HP/ALM and coordinate with developers to resolve them based on defect severity and priority.

Environment: Informatica (Power center), HP/ALM, SOAP UI, Oracle, SQL, Windows 7, UNIX, .Net.

Confidential, Columbus, OH

QA Tester

Responsibilities:

• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Experience in SDLC and Agile methodologies such as SCRUM.
• Performed Integration, End-to-End, system testing & Regression Testing.
• Wrote and modified SQL validation scripts and writing scripts in SQL to validate the outputs.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting.
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects.
• Developing Test Matrix to give a better view of testing effort.
• Creating traceability relationship between requirements in the same module and between different modules.

Environment: Windows7, UNIX, Oracle, PL/SQL, Informatica8.6, SQL, DB2, HP Quality Center, IE7.0.

Confidential

HR Intern/ Trainee

Responsibilities:

• Assisting and coordinating in daily HR activities, including interacting with managers of otherdepartments.
• Collecting, scanning, and sorting job applications for candidate and calling deserving candidates for interviews.
• Helping in preparing identity cards, login id and passwords of newhires.
• Inspecting the entire facility and ensuring the workplace is hazardfree.
• Maintained and updated employee files and companydocumentation.

Environment: MS Office (MS Word, Excel, PowerPoint), Windows95.