SUMMARY

• Around 5 years of experience in automation and manual testing on web based, Client/Server and data warehousing applications.
• Experienced in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle.
• Professional experience inIntegration, Functional, Regression, System Testing, Load Testing, UAT Testing,Black Box, White Box and GUI testing.
• Experience in Web based applications like online banking, transactions applications.
• Experience with working tools like Eclipse, Intellij IDEA, Oracle Jdeveloper for creating and executing Java/J2EE programs.
• Good understanding concepts on Business Intelligence and Informatica Power Center 8.X/7.3 using Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Expertise in writing SQL Queries using Oracle and MySQL in validating data into Data Warehouse/ETL applications.
• Experience with working tools like SQL Developer, TOAD 10.0,Sequel Pro, Win SQL for creating and executing SQL Queries.
• Involved in preparation of Test Plans,Test Cases based on High level requirements and make it ensure detailed/system level process Test Scripts.
• Involved in preparation of Test Data to test the functionality of ETL Sources Mappings and Targets.
• Expertise in Defect management,Bug tracking,Bug Reportsand generating the graphs using Test Management Tools such as Quality Center,MS Visual Studio & TFS (Team Foundation Server).
• Involved in preparation of Traceability Matrixbased on High/Detail requirements and Test Cases.
• Experience in maintaining support documents,QA Sign off Documents and maintaining Weekly StatusReports.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x (Repository Manager, Designer, Workflow Monitor, Workflow Manager)

Databases & Tools: Oracle 10g /9i / 8.x, Oracle SQL Developer, TOAD, SQL PLUS, Sequel Pro

Platform: Windows Server, UNIX / Linux and MS - DOS

Languages and Scripts: C, C++, JAVA, SQL, PL/SQL and UNIX shell scripting

Testing Tools: Quality Center, Test Rail, Jira, Microsoft Test Manager (MTM), Selenium IDE & Web Driver, Eclipse (Mars), IntelliJ

PROFESSIONAL EXPERIENCE

Confidential, San Francisco - CA

QA Engineer

Responsibilities:

• Participated in report testing and back end validation using relational, Nosql (Mongo) and Graphdb databases.
• Used Sequel Pro client tool for running the queries with all join conditions that are needed for extracting the data as per requirements
• Used Maven’s Project Object Model (POM) to manage project’s build and reporting, and for release management, issue tracking purpose.
• Involved in the peer reviews and walkthroughs on the Test Case, and preliminary test approach.
• Involved in updating the testing process, code and requirement changes to offshore team members.
• Used Jira tool for bug tracking purpose from start till closing of the bug
• Used Selenium tool for developing framework for UI automation, which involves using TestNG, Junit for unit test validation.
• Extensively used sauce labs to capture screenshots and videos of selenium tests.
• Invoked TestNG with testing.xml file and run the test using Intellij’s IDEA as IDE
• Involved in performance testing using Jmeter

Environment: ETL Clojure, Sequel Pro, Neo4j, Jira, Jenkins SAML, Turgidson, Intellij IDEA 13, Eclipse (Mars), Jing, Selenium, Sauce Labs, Jmeter, Source Tree

Confidential - Pleasanton - CA

ETL Tester

Responsibilities:

• Participated and involved in the peer reviews and walkthroughs on the Test Case, and preliminary test approach, which contains high-level test conditions for verifying the software solution
• Review all requirements and specifications documentation for clarity, completeness and testability
• Worked closely with developers and project leads to ensure thorough testing based on requirements
• Used Informatica Workflow Manager to run the jobs in sequence that are needed for testing
• Interacting with business Analysts and gathered requirements based on changing needs
• Creating Test conditions, Test Cases, Test Design according to the business requirements
• Prepare test data by writing insert and update queries that covers all the test scenarios
• Writing queries to check whether the business logic is implemented correctly and for validating the data from different sources
• Reporting bugs and track defects using QCALM. Consolidating list of bugs at the end of the day using QCALM. Retesting and closing the defects that are fixed

Environment: Informatica Power Center 9.5.1, Oracle 11g, SQL, UNIX, HP ALM, Oracle SQL Developer, Lotus Notes 8.5, Win SCP, Snipping Tool, Text Pad, Flat Files

Confidential - Pleasanton - CA

QA Analyst

Responsibilities:

• Participated and involved in the peer reviews and walkthroughs on the Test Case, and preliminary test approach, which contains high-level test conditions for verifying the software solution
• Review all requirements and specifications documentation for clarity, completeness and testability and Interpret complex business/data requirements and translate these into a comprehensive test plan
• Worked closely with developers and project leads to ensure thorough testing based on requirements
• Involved in testing of Claim tracking system which involves validating minimum data elements and acknowledgement files from KPEG
• Tested the conversion of flat files to CCF (Claim Centric Format) by validating the mapping elements
• Prepared test data input files based on requirements that are needed for execution
• Used Unix commands to retrieve the input flat files
• Involved in retesting the bug and updated the bug status accordingly

Environment: Microsoft Test Manager (MTM), .NET, SQL, Mercury Quality Center, QTP

Confidential

QA Tester

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the Data Mart.
• Performed Functional testing, Regression Testing and Smoke Testing and identified regression test cases that are automatable
• Involved in gathering test data for testing both positive and negative scenarios and in the transmission of manual to automated testing
• Developed Test Plan, Test cases, test scenarios, expected results and prioritized tests according to the functionalities in Microsoft Test Manager
• Linked each test ids in MTM with functional methods in TFS and ran those test ids from MTM and Implemented Data-Driven test to verify the same functionality with multiple sets of data
• Executed white box testing to ensure coding standards and application requirements and involved in analyzing test results from MTM and fixed minor issues
• Involved in Unit testing of modified code in Microsoft visual studio
• Responsible for consolidating team efforts and sending test reports to client
• Written Indexes, primary keys and checked other performance tuning at data base level.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc. and created testing metrics using MS-Excel

Environment: Informatica PowerCenter 8.6/8.5, SQL Server 2005/2000, Oracle 10g, Teradata 6, SQL, PL/SQL, UNIX Shell Scripts, Cognos, Erwin, Maestro job scheduler, Mercury Quality Center

Confidential

QA/ETL Tester

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs.
• Incorporated identified factors into Informatica mappings to build Data Warehouse.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and load into Data warehouse using the Mapping Designer.
• Written Queries, procedures, created Indexes, primary keys and data base testing.
• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets and Transformations Developer.
• Used flat file and Oracle as the source and the target is Oracle database.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Most of the transformations were used like the Source qualifier, expressions, and joiner, Aggregators, Lookups, Filter, Rank and Update Strategy.
• Performed data manipulation using basic functions and Informatica transformations.
• Created mappings using transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Router, Rank, and Sequence Generator.
• Creating TDD (Technical Design Document) and UTP (Unit Test Plan).
• Creating Unit test cases.
• Identified sources, targets, mappings and sessions and tuned them to improve performance
• Actively participated in database testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc.

Confidential

QA Analyst

Responsibilities:

• Enhancing the QTP scripts by doingunit testingon the scripts before creating scenario based tests inTest-Lab Moduleof Quality Center
• Created automated functional regression test scripts using QTP and scheduled, organized and executed the test scripts in QC-QTP integrate environment and documented the test results
• Used Quality Center extensively for writing test cases, Execution of test cases, maintenance of test results, defect reporting & Tracking and also for generating detailed test reports
• Wrote bothFunctional and RegressionQTP scriptsfor Web Applications
• Performed functional testing by executing the QTP Scripts from Test Director. Used Python to launch QTP scripts from command line for continuous integration testing
• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets and Transformations Developer.
• Created mappings using Informatica Designer to build business rules to load data.
• Used flat file and Oracle as the source and the target is Oracle database.
• Used the Workflow Manager, to create the session, work lets.
• Developing and modifying changes in mappings according to business logic.
• Performing Unit Testing.

Environment: Informatica 8.6, Oracle 10g, Unix