SUMMARY

• Over 10 years of Software Quality Assurance and testing experience in distributed systems.
• Experience leading QA teams, test plan preparation, providing testing estimates and testing metrics to managers. Excellent knowledge of QA methodologies.
• Actively involved in entire software lifecycles of several products and responsible for certifying high quality releases in QA which were successfully deployed to production. Proactively provided production support and troubleshooting of issues whenever required.
• Experience with Agile and Scrum software development methodologies. Participated in daily Scrum standups, monthly sprint planning, team capacity and Sprint Burn down reviews.
• Designed entire regression test case suite from available design specification, functional requirement specifications and after discussions with the product manager and Business analysts.
• Hands on experience deploying QA builds and maintaining testing environment in both Solaris and Linux environment.
• Extensive experience in functional testing, regression and integration testing. Expertise in black box testing, white box testing, database testing, data integrity checks. Good knowledge of API and XML testing.
• Wrote and maintained test scripts with VBScripts, including regression test case suites in QTP 11.0
• Experience coordinating with clients and customer problem resolutions using Salesforce.com
• Fast learner and a team player with excellent communication skills and ability to complete tasks and meet deadlines with minimal or no supervision.

TECHNICAL SKILLS

Testing Tools: QTP 11.0, Win Runner

Version Control: Tortoise Subversion (SVN), Visual Source Safe, SharePoint, Requisite Pro

Defect Tracking: Team Foundation Server (TFS), HP Quality Center

Programming Languages: C, C++, JAVA, .Net

Web Technologies: HTML, XML, JavaScript, VBScript

Application Servers: Weblogic, JBoss

RDBMS: Oracle 8i, 10g, 11g, MS SQL Server 2008, MS Access

Tools for DB Query: TOAD (Tool for Oracle Application Developers), SQuirell

Operating System: UNIX - Solaris and Linux, Windows

Other Tools: Word, PowerPoint, Excel, WinSCP, Putty, UltraEdit

Software Methodologies: Agile, Scrum, Waterfall

WORK EXPERIENCE

Confidential, Torrance, CA

QA/ETL Tester

Responsibilities:

• Acquiring complete knowledge on the integration systems that are interfaced with the current STARS Siebel application
• Participating in the scope discussion related to replacing the current STARS CRM application with the Salesforce service cloud
• Reviewing the requirements and user stories with the Business teams
• Responsible for QA assessment during the project forming stage to determine test approach and present estimates to the project management
• Creation of high level planning, tasks, and testing milestones for the project
• Developing Test Strategy, defining test approaches for various types of testing identified for this project
• Coordinating with the offshore team for business and technical requirement walkthroughs and ambiguity clarifications
• Conducting of training on peer and formal review processes to offshore team to enhance the quality of test design
• Participated in Sprint Planning, Sprint Review, Daily Scrum Calls
• Coordinating sessions with BAs on test ambiguities and gearing the offshore team for completion of test design
• Responsible for technical review of test scenarios and provide walkthrough to business team for sign off
• Delivery coordination of and test design\test execution and defect reports metrics to project management
• Integration testing for Retail & Lease Financial Accounts: TIBCO, ETL and Focus Host
• Data base testing with using SQL by using Developer Console or Workbench

Environment:Informatica 9.6, Oracle 11 g, Salesforce.com, Autosys, Unix, Windows XP,TOAD, AGILE, HTML,SOAP UI, XML, Oracle SQL Developer, HP ALM.

QA/ETL Tester

Responsibilities:

• Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.  
• Prepared Test Cases and Test Plans for the mappings developed through the   ETL   tool from the requirements.  
• Validated Customer and Orders data while Extracting, loading from Liferay(source) to stage and stage to EBS(Target).
• Used Informatica MDM (MASTER DATA MANAGEMENT)   Ensure data is managed, cleansed, integrated and synchronized in real-time to a single accurate view of company data across multiple domains and data sources
• Written several complex SQL queries for data verification and data quality checks.  
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.  
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process
• Involved in testing the Informatica mappings, by validating whether the mapping adhere to the development standards and naming conventions
• Used Agile SCRUM methodologies utilizing JIRA for version controlling and for managing SDLC.
• Responsible for multi-tier testing (back end and UI testing)
• Responsible for Web and cross browser testing
• Extensive SQL query writing to validate BEACHBODY Customer/user data from source to the target in TOAD.
• Writing queries to provide the data samples to business for UAT testing.
• Identified the defects and developed Defect Tracking report using JIRA this involved Bug life cycle.

Environment:Informatica 9.6, Oracle 11 g, Microstrategy,Test Rail, Autosys, Unix ,Windows XP,TOAD, AGILE, HTML,SOAP UI, XML,WinSCP, Oracle E-Business Suite 12.1.3, Oracle SQL Developer.

ETL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering
• Leading or coordinating the Clients, Business Analysts with off shore team
• Preparation of Test Plan and approach based on the Business requirements
• Experienced in Data warehouse testing, in all the phases of Data warehouse life cycle.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Procedures, Test Cases, Test data in all phases of SDLC
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Strong knowledge in Data Warehouse and Business Intelligence solutions and a strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema, Snowflake Schema, FACT & Dimensions tables, Physical & Logical Data Modeling
• Strong experience using Oracle, MS SQL Server, Teradata.
• Experienced in Database / Data warehouse testing life cycle. i.e., Conversion Testing, Integration testing, System & Acceptance testing and Regression testing.
• Validating the complete source to target mappings along with transformation rules.
• Implemented data verification procedures for ETL processes in load testing.
• Used Data Stage ETL tool to load data from different sources into target database and validated different transformations to move data from source to target.
• Extensively used SQL and PL/SQL scripts to perform backend database testing and Tested Data Stage Mappings.
• Reviewed requirements and mapping documents to identify gaps analysis.
• Worked with developers in understating the ETL code for writing several complex test plans for testing both front-end and backend.
• Prepared several test scenarios for the work flow of the entire ETL cycle.
• Ran workflows created in Data Stage by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Developed Test Plans/Test Cases to Validate Key Business Requirements.
• Written and executed complex SQL queries to validate accuracy of the reports.
• Extensively used ETL tool to extract data from Oracle database and loaded into SQL Server database.

Environment: Informatica, MicroStrategy, Business Objects, SQL, PL/SQL, Unix, .Net, Business Objects XIR2, HP Quality Center 10.0, Teradata, XML, Salesforce.

ETL Tester/BI Tester

Responsibilities:

• Analyze the end-user requirements, use cases and develop test scripts that validate the complex business process and objectives of property taxes management. Hold test case review meeting with the technical and functional SME to incorporate additional scenarios and boundary conditions not identified in the requirement specifications.
• Work as liaison between the Technical SME and the offshore team, logging defects, in Team Foundation Server holding bug triage meetings and ensuring the offshore team got the required test data, post and preconditions for completing the use cases required for their unit and integration testing.
• Worked on Project deliverables including detailed test plan and descriptive test cases for testing the new functionalities in each release cycle of the product. Maintained the regression test suite after each release.
• Adopted Agile software development methodology by testing and delivering fully functional modules of the target system.
• Served as the lead to work with development to iteratively design, code, test modules in this Agile process. Attended daily scrum meetings as part of the process where the Sprint Backlog was reviewed.
• Participated in all design and test case reviews with the BA and development teams.
• Worked on Data Stage to resolve production issues perform testing and debugging of mappings and reports Extraction of test data from tables and loading of data into SQL tables
• Deployed weekly builds in QA environment after code drop to QA, was responsible for dry run before deployment to production. Also helped with release notes after QA certification.
• Reported all defects in QC bug tracking system. Reviewed bug reports by junior members, modified bug priorities, appropriate flags and assigned them to developers.
• Certified the products on various web browsers including IE, Firefox and Safari and Chrome

Environment:Informatica, MicroStrategy, Microsoft Outlook, Autosys, Unix, Windows XP, SOAP UI, Salesforce, TOAD

Confidential,‎ San Jose, CA

QA/ETL Tester

Responsibilities:

• 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.
• Worked with developers in understating the ETL code for writing several complex test plans for testing both front-end and backend.
• Analyze the end-user requirements, use cases and develop test scripts that validate the complex business process and objectives of property taxes management. Hold test case review meeting with the technical and functional SME to incorporate additional scenarios and boundary conditions not identified in the requirement specifications.
• Work as liaison between the Technical SME and the offshore team, logging defects, in Team Foundation Server holding bug triage meetings and ensuring the offshore team got the required test data, post and preconditions for completing the use cases required for their unit and integration testing.
• Prepared several test scenarios for the work flow of the entire ETL cycle.
• Ran workflows created in Informatics by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Prepared custom reports and performed SQL query, data analysis and verification on MS Access.
• Analyzed system requirements, identified the test cases based on the requirements and were involved in preparation of Test Plans and templates for test cases during pre and post releases.
• Developed Test Plans/Test Cases to Validate Key Business Requirements.
• Performed System Testing, Functionality testing, User Acceptance testing, Regression of the applications.
• Performed white box and black box testing in Oracle Data Warehouse environment.
• Developed the traceability matrix between test requirements and test cases.

Environment: Mercury Quality Center 9.0, Test Director, Oracle, Unix, TOAD, Informatica 7.1., Windows 2000/2003.

Software QA Analyst

Responsibilities:

• Involved in analyzing the business requirement documents (BRD),Component Requirement specification documents to prepare test cases.
• Experience in working with business analysts to understand the business complexity and analyzing the impact & risks.
• Involved in preparation of Test Scenarios and Test Cases as per the Business Requirements and Use Cases.
• Assisted developers in performing Unit testing for some modules using JUnit.
• Involved in creating, executing and managing Test Cases using Rational Quality Manager.
• Involved in analyzing the Software Requirement Specifications.
• Participated in review meetings for test case and test scenario development.
• Performed various levels of Regression Testing to ensure the product is bug free.
• Developed Test Plans and Test Cases for System, Integration and UAT testing.
• Maintained testing standards and was also involved in creating test scenarios.
• Actively participated in requirement gathering and Test Plan review meetings.
• Took part in the testing of different types of orders like Change of orders, order submission and cancellation of orders and service points with different statuses.
• Was involved in the regression testing after each modification and enhancements.
• Tracked the bugs and reported them using Test Director as the defect tracking tool and performed regression testing
• Reviewed and analyzed executed test results with business analysts for coverage analysis.

Environment: QTP 6.5/6.0, Test Director 7.8, Win Runner 7.5, Oracle 8.i, VBScript, IE, Microsoft Tools, J2EE, Web Sphere.