PROFESSIONAL SUMMARY:

• Over 7+ years of IT Industry experience in Manual and Automation testing on web based and data warehousing applications. 
• Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC). 
• Professional experience in Integration, Functional, Regression, Nonfunctional, System Testing, UAT Testing and GUI testing. 
• Knowledge in Informatica Transformations, Workflow Manager, Tasks, Sessions and Workflow Monitor. 
• Experience in SQL. 
• Created   ETL   test data for all   ETL   mapping rules to test the functionality of the Informatica mappings. 
• Knowledge and experience in Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W. 
• Tested the   ETL   Informatica mappings and other   ETL   Processes (Data Warehouse Testing). 
• Experience in Java Programming, Selenium Web driver, Cucumber, Junit and Testing. 
• Proficient in Test Automation using Selenium Tools Suite and preparation of automation test framework. 
• Well Versed with handling elements in Selenium Web Driver. 
• Experienced in using Accessing Forms, tables, link, Keyboard Mouse Events, Uploading File using Selenium WebDriver 
• Executed Selenium Test Cases and Reported Defects. 
• Experience in Data Driven Testing, Cross Browser Testing and Parallel Test Execution using Selenium Web Driver and Testing. 
• Strong experience writing test cases using Element Locators, WebDriver Methods, Java Programming features and Testing and Junit Annotations. 
• Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents. 
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables. 
• Experience in using HP Quality Center for Bug Tracking and Defect Reporting. 
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies. 
• Expertise in querying and testing in Oracle, MS SQL Server, Teradata, Sybase using SQL, PL/SQL for data integrity. 
• Working experience in Windows NT/2000/XP and UNIX environments 
• Clear understanding of business procedures and ability to work as an individual and as a part of a team. • Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents. 
• Experience in both manual and automation testing process and in creating automation environment using Quick Test Pro (QTP), Test Director, Quality Center. 
• Expertise in test strategy design based on the various types of testing including integration, function, system, End to End, load, stress and performance testing, Backend(Database) Testing. 
• Interact with clients for Quality discussions and responsible for the QA deliverables. 
• Expertise in Microsoft office (Word, Excel, Power Point, Outlook & Visio). 
• Proficient in SQL query and testing RDBMS such as Oracle, MySql, SQL Server for data validation. 
• Proficient in using SQL Queries using TOAD & SQL Plus to ensure data consistency of front-end and raw feed by developing and executed complex SQL queries for data base. 
• Strong experience in testing   ETL   applications and BI reports. 
• Sound Knowledge and experience in Star schema/Snowflake schema. 
• Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W. 
• Strong working experience in Windows NT/2000/XP and UNIX environments. 
• Strong testing experience in UNIX platform. 
• Expert in reviewing/reporting, tracking, & maintaining Defects with high level of detail, accuracy and informative recreation steps using Quality Center, Clear QUEST, Bugzilla, and Email (outlook) 
• Ability to learn and adapt to new tools and technologies very quickly. 
• Excellent Communication and interpersonal skills with clear understanding of business processes and ability to work as part of team or individually.

TECHNICAL SKILLS:

Data Bases: Oracle 11g/10g / 9i / 8i / 7.x, Main Frame via web3270, DB2 UDB, MS SQL Server … / 7.0, MS-Access, Teradata v2r6 

Development Languages: SQL*Plus, T-SQL, PL/SQL 2.2 / 8.x, Unix Shell Scripting, TOAD 7 / 7.6, SQL Loader, VBA 

Operating Systems: UNIX (AIX), Linux, MS-DOS, Windows vista / XP / 2000 / NT / 98 / 95. 

Methodologies: Ralph Kimball's Data modeling, Star and Snowflake Schema Modeling 

Testing Tools: Mercury Quality Center 11.0/ 10.0/ 9.0 / 8.0 , Test Director 7.6 / 7.0, Quick Test Professional 6.5 / 5.6, Win Runner 7.5 / 7.0 

Workflow Tools: Putty, WinSCP3, MS-Project, MS-Excel, MS-PowerPoint, MS-Word. 

Management Tools: Peregrine Service Center 5.1, HP Project and Portfolio Management Center (ITG) 7.1

WORK EXPERIENCE:

ETL  Tester

Confidential, Austin, TX

Responsibilities: 

• Analyzed the existing system and process gaps in context of new conversion of Flagstar and RBCB bank changes. 
• Conducted JAD sessions with management, SME's, Business users and other stakeholders for open and pending issues to develop specifications. 
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle. 
• Prepared test cases in Test Plan tab execute in Test Lab and logged defects using Application Management Life Cycle QC 11. 
• Written SQL queries manually and also built SQL queries using TOAD to validate the Customers ' addresses and accounts level data. 
• Created ETL  test data for all ETL  mapping rules to test the functionality of the Informatica Mapping. 
• Ensured that migrated data is complete, accurate and correct from Oracle database. 
• Used TOAD Software for Querying ORACLE. 
• Performed Data Verification, data Validation, and Data Transformations on the Input data (Text files, XML files) before loading into target database. 
• Performed manual back end testing while retrieving the data from the Oracle database for financial applications like DDA, SVG, IRA, CDS, and DCA. 
• Test Business Objects reports for data validations and compare results with TOAD. 
• Tested reports using Business Objects functionality like Queries, Slice and Dice, Drilldown, Header, Drill up etc. 
• Extensively used MS Office and MS Word data sheets to import positive and negative results in QC 11. 
• Followed up with standard application testing process to perform different types of testing phase for the FLAGSTAR and RBCB projects. 
• Involved in developing UNIX Shell wrappers to run various SQL Scripts. 
• Co-ordinate with business and technical people regarding test run results. 
• Used IBM Lotus note and Clarity for documentation. 
• Weekly meeting with the Project Management team and share the Status Report on the weekly basis. 

Environment: SQL, TOAD 7.o, Quality Center 11, MS Office 2007, Windows XP/2003,Oracle 10g, Informatica 9, Business Objects XIR4

ETL Tester

Stanley, NY

Responsibilities: 

• Preparation and Execution of Test Plans Involved in testing the entire application across the various platforms. 
• Used DATASTAGE as an ETL  Tool for Developing the Data Warehouse. 
• Created Test Cases and developed Tractability Matrix and Test Coverage reports. 
• Managed and conducted System testing, Integration testing and Functional testing. 
• Extensively used the Auto Sys jobs for the entire project. 
• Used the Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database. 
• Worked on SQL scripts to load data in the tables. 
• Implemented testing process improvements, including the use of Selenium add-ons and creating reusable tests. 
• Implemented testing process improvements, including the use of Selenium add-ons and creating reusable tests 
• Experience testing on XML documents. 
• Validated the data movement and transformations are done correctly for MISMO. 
• Worked with Data Warehousing developers who extensively used DATASTAGE, to design mapping to move data from source to target database using Stages to do the functionality. 
• Prepared status summary reports with details of executed, passed and failed test cases 
• Interacted with developers, Business & Management Teams and End Users. 
• Participated in regular project status meetings related to testing.

Environment : Informatica Power Center, MDM, Business Objects, Oracle 10g, SQL Server 2008, SQL, PL/SQL, T-SQL, Oracle, Web services, SOAPUI, Flat files, Excel Files, UNIX, Quality Center

ETL Tester /QA Analyst

Brackenridge, PA

Responsibilities:

• Overall 5+ years of experience in IT industry with an emphasis on Software Quality Assurance & Testing. 
• Extensive experience working in various domains like Utility & Telecom. 
• Software Tester  and QA analyst experience for general Software Testing - GUI, web applications as well as knowledge in test automation and various database management systems 
• Test automation scripting using Selenium with different frameworks. 
• Hands-on experience augmenting and enhancing existing automation frameworks based on Selenium. 
• Excellent skills in preparing Test Plans, Test Scenarios, writing and executing test cases for Manual testing using HP Quality Center, Rational Test Suite and Microsoft Test Manager. 
• Experience in testing Web application, Client/Server applications, Stand-alone applications and knowledge in mobile application testing. 
• Experience in ETL  testing which includes Data mock up, Flat file mock up, DW, EDW, Production Validation Testing, Source to Target testing, Target to Source Testing, Main Frame Testing, Batch Modernization testing, Data Completeness Testing, Data Accuracy Testing, Data Transformation Testing, Data Quality Testing, Incremental and Data UI Push testing. 
• Thorough implementation knowledge of all phases of Software Development Life Cycle (SDLC) using Waterfall, V-model and Agile methodologies 
• Complete STLC experience in Design, Development, Test plan formulation and Testing Methodology. 
• Experience in all phases of testing including White Box, Smoke testing, Functional, System, Integration, end-user, Regression, Browser Compatibility, User Acceptance testing of web based Applications. 
• Created project process documents as well as user manuals and participated in Knowledge Transfer sessions to End users. 
• Having very good experience on running database scripts and writing SQL queries using Views, Joins, Where Clause, Having Clause, Order by Clauses and SQL functions for data verification and backend testing. 
• Good practical experience in using HP Quality Center (QC) for test management and Jira for defects tracking purpose. 
• Working knowledge in UNIX OS. 
• Ability to work on multiple projects under tight deadlines and changing priorities 
• Participated in various reviews and meetings with the Development team 
• Effective communicator, quick thinker, rapid problem solver, good team player, self-motivated to work independently with commitment, strong work ethic and excel at turnaround scenarios 
• Effective Time Management Skills and consistent ability to meet client deadline. 
• Excellent analytical, problem solving, presentation, and interpersonal skills. 
• Good team player with excellent communication skills, vendor experience and ability to lead, manage, coordinate and work independently in a time sensitive environment.

Environment: ETL  Informatica, BI Business Objects, Oracle 9i, RAD, Java, Struts1.1, JSF, QTP 9.0, Quality center, Solaris, Windows XP .

QA Tester/ Selenium

Confidential

Responsibilities: 

• Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, Detailed Design Documents and Requirement Matrix. 
• Involved in entering requirements, developing test plan tree, designing the test steps, writing test cases and running test scripts using Test Management Tool Quality Center. 
• Extensively involved in all stages of testing life cycle, Test Driven Development methodologies. 
• Software Development Life cycle (SDLC) using Waterfall, Agile methodologies. 
• Developed and implemented robust MVC pattern base testing with Selenium Web Driver which cut down the script development time in half. 
• Designed and Developed Test Cases for automated testing using Selenium, Testing and Eclipse IDE. 
• Developed test code in Java language using Eclipse IDE and Testing framework. 
• Configured Selenium Web Driver, Testing, Maven tool and created selenium automation scripts in java using Testing prior to agile release. 
• Created test cases, scripts based on functional specification, prepared test data for simultaneous and combined Trade testing. 
• Prepared UAT Test plan and Conducting UAT testing with UAT Team. 
• Identify, Execute tests, record results and document the defects using HP QC. 
• Developed Test cases manually and generated Automation Scripts using open source tools like Selenium Web Driver, Testing, SOAP UI, and Maven. 
• Involved in Designing & Developing data driven framework using Selenium Web Driver, Testing and implemented Java Mail to send the regression result automatically. 
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application's GUI and in the testing environment using Selenium Web Driver. 
• Developed test automation scripts using Selenium Web Driver for regression and performance testing of the various releases of the application. 
• Worked on Selenium GUI Object / element verification is done through XPath, CSS Locators. 
• Used Testing Annotations in Selenium Web Driver and executed a batch of tests as Testing suite. 
• Extensively used Page Objects design and page navigation framework for readable test script and easy maintenance from developer perspectives. 
• Created XML based test suit and integrated with Jenkins Server to execute automation scripts on a regular basis by scheduling Jenkins jobs in different test environments with different test configurations. 
• Uploaded the Test Plans Test Cases into Quality Center by using the Excel template and mapping the requirements to corresponding fields and pulled Test plan & Test Cases by using Document generator. 

Environment: Java, Selenium Web Driver, Testing, Maven, Jenkins, ALM 11.0, SOAP UI, Eclipse, TDD, Agile, HTML, XML, XPath, QTP, JavaScript, Quality Center 9.2, Firebug, SQL, PLSQL, Relational Database Oracle, Rational unified process(MAT), UNIX, Windows, Windows Server 2003.