SUMMARY

• 8+ yearsexperience in Quality Assurance, Testing process, Testing methodologies and strong experience on STLC and overall testing approaches and earned reputation for meeting testing deadlines and delivering the critical solutions.
• Expertise level knowledge in entire software development lifecycle (SDLC) process from business analysis to development, testing, deployment, documenting, maintaining and user training, experience on AGILE and SCRUM designmethodologies
• Extensive experience in Functional, Integration, Regression, User Acceptance, System and BatchTesting.
• Expertise in creating selenium web driver scripts and adept in handling selenium objects and Selenium IDE.
• Developed and enhanced data driven automation framework and used page object pattern.
• Good understanding of Object Oriented concepts and programming expertise in Eclipse.
• Hands on experience testing and programming Java/J2EE applications
• Experience in ETL (Ab Initio) Testing, Database (Oracle & Teradata)Testing.
• Working experience on Testing ETL Tools like Data Stage.
• Worked on Oracle Package, Function, Procedure, Triggers as a developer and tester.
• Experience in Telecomm Billing configuration Report development. worked on Teradata and Ab Initio testing
• Extracting defect status reports and managing defect status using the Quality center / ALM, Clear Quest and also conducting defect status calls.
• Excellent working experience in RDBMS technologies like Oracle, Teradata, DB2and MYSQL.
• Extensive working knowledge in UNIX environment.
• Interacted with the offshore QA team and the rest of the team based in the U.S for project and testing status.
• Extensive experience in utility tools like TOAD, SQL Query analyzer, SQL Assistant, SQL Developer, SQL* Plus, SQL*Loader and Rapid SQL
• Experience in Web and Object Oriented Technologies

TECHNICAL SKILLS

Testing Tools: Selenium Webdriver./ RC/ IDE, Quality Center 9.2/8.0 / 11.0/ ALM

Testing Frameworks: TestNG, JUnit

Databases: Oracle 8i/9i/10g, DB 2 8.0/7.0/6.0, MySQL, MS Access, MS Excel, Teradata V2R5/V2R6

Tools: / Products: Ushacomm Billing System Unicorn, Crystal report, Nikira (Fraud Management), Teradata and Ab Initio

ETL Tools: Ab Initio,Data Stage

MS Office: Word, Access, Power Point, Excel

Reporting Tools: Micro Strategy, Business Objects XIR2

Other tools: Maven, Ant, Eclipse, GitHub

Operating Systems: Windows 95/98/2000/XP, Linux and UNIX.

Web Programming: HTML, XML,JSP, Java Script

Programming languages: SQL, PL/SQL, Java, .Net

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Lead QA Engineer

Responsibilities:

• Coordination with onsite - offshore team to assign the work and also to track the progress.
• Trained & led team of offshore QA testers
• Performed testing of software web applications including Functional, Integration and Regression testing
• Analyzed Functional Requirements Document (FSD), BRD and Use Case to create Test Plan and Test Cases.
• Responsible for executing Test Cases, filing and reporting bugs through the Quality Center and verified known bugs against new builds.
• Involved in testing new development cycles using iterative testing cycle by creating manual business flows and scenarios.
• Created Automation Data driven Scripts using Selenium Web driver and ANT
• Involved in Selenium Script Review and Execution.
• Involved in creation in Reusable functions in Selenium.
• Implemented End to End Functional Testing using Selenium IDE/Web Driver
• Performed ETL testing by running jobs in Autosys server or Autosys GUI.
• Involved in Data conditioning of files and make files ready to process further before we run jobsin ETL.
• Involved in field to field mapping record validation between Database and the source files, when it gets loaded to Database from ETL .
• Validated Web services using SOAP UI by testing XML request and response datawith SOAP.
• Used UNIX commands to Monitor the Log files and examine the Error log files
• Performed backend testing to validate database contents by writing and executing SQL Queries.
• Reported thebugs in Clear quest, sending Email notifications to the developers usingQuality Center(ALM).
• Participated in meetings and walkthroughs.

Environment: Selenium Web Driver, TestNG, Java, Mercury Quality Center, Clear Quest, SOAPUI,TOAD/SQL Developer, UNIX, SOAPUI, Autosys

Confidential, San Francisco, CA

Lead Data-warehouse QA tester

Responsibilities:

• Coordination with onsite-offshore team to assign the work and also to track the progress.
• Performed testing of software web applications including Functional, Integration and Regression testing.
• Performed positive/negative testing for system validation using Selenium Automation Tools including Webdriver.
• Performed API testing with TestNGframework.
• Actively participated in framework design and developed Page Object Model (POM) framework
• Developed test cases, designed test steps and associated the corresponding requirement.
• Developed automation scripts using Selenium Webdriver.
• Led automation efforts for new features like best offer notification and extensively worked with locating web elements using Id, CSS selector and XPATH
• Used Selenium IDE and Firebug for capturing various XPaths/IDs.
• Developed page level libraries for functional automation.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project
• Validated ETL(Data Stage) scripts.
• Design and Enhancement Data Stage ETL
• Transformed and loaded the data into Confidential database using SSIS.
• Extensively involved in, data validation on the GUI and in database as well after the successful batch job-run.
• Performed Time Dependency to run test cases in batch and used notifications to alert lead whenever test cases pass/fail in Quality Center / ALM
• Developed User-Acceptance test scripts and assisted users in conducting UAT.
• Used UNIX commands to extract and examine the Error log files.
• Worked with Cross-Functional teams to resolve issues.
• Involved in defect reviews and performance test plans.
• Involved in backend and front end testing.
• Used Quality Center / ALM for test case management.

Environment: Java,Selenium, JUnit, SQL, Eclipse, Selenium Webdriver, HTML, Selenium GRID, Data Stage, SQL Server 2008, PL/SQL, .Net, Oracle, HP Quality Center / ALM.

Confidential, Minneapolis, MN

Sr. Data-warehouse tester

Responsibilities:

• Prepared Acceptance, Functional, Regression and Performance Test Cases based on the scenario matrix and requirements.
• Interacted with the offshore QA team and the rest of the team based in the U.S for project and testing status.
• Created and maintained daily and weekly defect reports that helped monitor the progress of testing.
• Prepared Acceptance, Functional, Regression and Performance Test Cases based on the scenario matrix and requirements.
• Create design documents and workflow for various test cases..
• Conduct peer reviews and structured walkthroughs of test plan, test scripts and other testing materials
• Created Batch scripts for validating the data pre-run and the results post-run.
• Used PL/SQL function to validate some test scenarios.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT& regression testing
• Written the complex SQL queries to validate the initial and incremental ETL loads.
• Used Toad for Data Analysts to compare Teradata result sets.
• Managing test plan and strategize the work to meet timelines
• Onsite and Offshore work coordination and status update

Environment: Teradata, Quality Center, Windows, .Net and Unix

Confidential

Data-warehouse/ BI tester

Responsibilities:

• Performed Data-warehouse testing on Teradata and Ab Initio
• Participated in Solution Concept understand, testcase preparation, test data preparation, uploading testcase in QC, System testing, defect posting in QC for teradata.
• Developed of Procedures and triggers in Oracle database and performed database testing.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select for testing Business Intelligence Reports with various boundary conditions
• Tested ESB batch process in order to send the customer transaction to oracle staging table
• Executed SQL queries in order to check the data for customer transaction and payments tables
• Participated in QA scrum meetings.
• Worked with Compatibility Testing for Browser.
• Preparing the weekly status and defect reports and defect reports and reviewing them.
• Experience in Toad for Writing SQL Queries and executed them for Backend Testing
• Creating and executing SQL queries to validate test data using TOAD
• Used Inner join, Outer Join, Set operators and Case statements in SQL scripts.
• Used SQL Assistant to write SQL and query the Teradata database tables.
• Validated ETL(Data Stage) scripts.
• Experienced with Quality center for managing the defects and querying the Quality center for pulling Defect status reports.
• Updating the Defect status reports in defect status call with the managers and following up on the defect status.
• Facilitated extensive UAT and hands on training for business users on the system functionality.
• Interacted with developers to resolve the ETL and reports defects.

Environment: Teradata, Data Stage, Abinitio, Oracle Pl/Sql, .Net, Windows and Unix Quality Center 8.0.

Confidential

Data-Warehouse tester

Responsibilities:

• Successfully completed professional training on Teradata and Abinitio.
• Working as a developer and Tester in Teradata.
• Taking part in Solution Concept understand, test-case preparation, test data preparation, System testing, defect posting in MQC for teradata.
• Developed Macros, bteq and fastExport scripts in teradata.
• Developed of Procedures and triggers in Oracle database and performed testing..
• Responsible for testing the reports according to client’s requirement using Business Objects 6.5.1.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Teradata, Abinitio, Oracle Pl/Sql, Windows and Unix

Confidential

Software Engineer/ QA Engineer

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Performed various levels of testing in all stages of the SDLC, Involving Requirements, Design, and Development teams to implement the requirements.
• Developed and Performed execution of Test Cases manually to verify the expected results
• Involved in Manual and Automated testing Quality Center
• Participated in configuration of Nikira (Fraud rules, fraud types, alarm management).
• Designed adapter using diamond adapter designing tool.
• Performed database validation using SQL according to the business rules and specifications.

Environment: Nikira (Fraud Management Tool) and Diamond(Adapter designer),Windows XP, Quality Center

Confidential

Software Engineer/ QA Engineer

Responsibilities:

• Performed coding and unit testing.
• Developed a GUI for data analytics of Rave (Tech M revenue assurance product) using Core Java, JSP, JS, Oracle 10g and Tomcat web server.
• Developed Pl/Sql stored procedure, functions packages for querying RAFM reports.
• Writing test cases for different modules.
• Extensively performed DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Developed test cases for ETL process and reporting.
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones with the dependencies.
• Created and executed test cases for ETL jobs to upload master data to repository.
• Used Unix Diff command to compare two text files.
• Experienced with UNIX commands like GREP, PS, WC and CHMOD.
• Worked with Users to develop Test cases for user acceptance testing.
• Learned revenue assurance, fraud management, ETL and completed Certification in SubexNikira User and Admin which is a Telecom Fraud management tool

Environment: Oracle 10g, Core Java, ETL, Windows XP, Unix

Confidential

Software Engineer

Responsibilities:

• Writing test cases for different modules.
• Performed functionality testing of Unicorn of different modules as per client requirement
• Performed coding and unit testing.
• Developed report using Crystal reports XI tools and used BO for deploying them.
• Created customs reports from Oracle database, write procedures using Pl/Sql and deployed them to BO.
• Configured Unicorn application portion (different offerings, customer, service order, TT).
• Written complex SQL queries.
• Heavily involved in interacting with UNIX Shell scripts

Environment: Oracle 9i, Unicorn (telecomm billing software), Crystal Report, Windows XP,Unix

Confidential

Software Engineer

Responsibilities:

• Participated in coding and unit testing
• Performed System, Integration, and Regression Testing..
• Performing the Configuration testing at System Level.

Environment: Oracle 10g Application server, Portlet, Windows XP