SUMMARY

• Around 7 years of hands - on software testing and analytical experience on client-server, web application and database systems in Retail, Brokerage and Banking industries
• Experience with Hadoop ecosystems, HDFS, Big Data, ETL, RDBMS
• Responsible for Requirement Specification, Business understanding, Review, Walkthrough, Inspection, RTM - Requirement Traceability Matrix preparation
• Preparing Test Plan, Test approach, Test Coverage, Testing Efforts Estimation techniques, QA Environment set-up
• Designing Integration, System, Functional, Non-Functional, User Stories, Use Cases, Test Suites, Test Scripts, Review, Uploading into QC
• Defects logging, tracking and monitoring on daily basis for test project success. Monitoring test case design, execution, defects clustering, Risks/Issues reported, determining upcoming risks
• Monitoring real-time and historical data within Cassandra using DataStax OpsCenter (UI)
• Used Hadoop File System (HDFS) to track directories and files in the system to locate the data
• Written Hive query language as per requirements to validate data loaded into Hadoop
• Worked on different data sources like Flat files, XML files and Databases
• Tested web services using SOAP UI
• Working knowledge in developing test scripts to automate process of testing in Selenium WebDriver and iTKO LISA
• Involved in discussions with development team on defects fixing, determining uncertain scenarios in project developments
• Experience working in an Agile methodology environment

TECHNICAL SKILLS

Operating Systems: WINDOWS and UNIX

Big Data Ecosystems: Hadoop, MapReduce, HDFS, Hbase, Hive, Cassandra and Talend

Web Technologies: HTML, XML, JSON

Business Mgmt. Tools: MS-Office, VISIO, MS Project, Sharepoint, Confluence

Testing Tools: Quality Center (11.0), Monitoring Tivoli, Atlassian JIRA, SOAP UI 5.1.3

Test Automation: Selenium WebDriver, iTKO LISA

Development Tools: Eclipse, Dev Center, OPS Center

Databases: SQL Server, Oracle, MS Access, DB Visualizer

Languages: Java, VB

Query tools: TOAD, DB Visualizer and SQL Plus

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

QA Analyst

Responsibilities:

• Worked with the Project Manager in project planning and project estimation
• Analyze Business requirements by interacting with Developers and Business Analyst to create high level Test Strategy presentation
• Testing of XML tags. Analyze the content of the XML and verify that data enclosed in the XML tags is matching with test data generated for customers
• Used SOAP UI and REST client to test Web Services
• Created Requirements Traceability matrix to track the test coverage with all the functional and technical specifications
• Requirement understanding, walkthroughs, communicating with business team and other project teams.
• Led offshore team about work allocation and get project status updates through daily conference calls and prepared status reports for the same.
• Executed Functional, Regression, Non-Functional and Integration testing for UCS 3.0 Web services
• Hands on experience in using ecosystem components from Horton Works like HDFS, Hbase, Hive and Cassandra
• Responsible for building test environment to create the test data and keep them ready for test execution
• Used HP Quality Center to upload, write and execute test cases with design steps, pre-requisites, expected results, priority, procedures, test data, defects etc.
• Involved with other team members to cover projects functional and technical support in end-end testing and ensured entire testing is covered
• Followed Agile process and maintained track of the project progress
• Provided a detail schedule of the test metrics and status reports to the client and managers of THD with the ongoing project testing progress
• Interacted directly with the client and business associates for any new change request
• Was responsible to send all projects status reports to the VP at end of each week
• Updated relevant documentation on Share Point for respective team reference

Confidential

Business Analyst/QA

Responsibilities:

• Gathered high level requirements and developed scope of the project
• Followed a systematic approach to eliciting, organizing, and documenting requirements
• Created story board presentation for the leadership team
• Prepared meeting agenda and ensure delivery of specifications to members in adequate time for their review.
• Daily interaction and communication with business users for discussing project issues and any scope changes
• Interacted with technical team for requirement gathering and translation of business requirement to technical specifications.
• Prepared Functional Design Specifications (FDS) employing use case scenarios
• Documented Test Cases and assisted the QA Team with the Test Plan
• Documented the Traceability Matrix for tracing the requirements
• Involved with offshore and onsite coordination activities
• Coordinated with QA Management in evaluating Hadoop testing tool for increased testing productivity

Confidential

QA Analyst

Responsibilities:

• Performed Data Analysis, Data Verification/Validation and Data Mapping testing
• Analyzed Source to Target mapping document based on facts and dimensions
• Validated DDL, Counts, Not Nulls, Duplicates, Primary Key and Foreign Key validation, business rules to be applied on target tables
• Performed extensive data profiling and Data validation using Hive queries and back-end testing
• Analyzing and validating UNIX shell scripting for Hadoop jobs. On failure of a job, go to the .config file in Unix box and verified the shell scripts
• Written Hive queries to test the data
• Performed Database Testing, UAT testing, Functional Testing, GUI Testing, Integration Testing, end to end testing, Regression Testing, Smoke Testing, Sanity Testing, and Performance testing
• Testing Error logs, finding data quality issues to improve Data Quality
• Created Non-Functional test cases packages to validate business rules
• Generated QA Reports on daily basis until completion of successful execution
• Involved with the production support team to clean up the bad data

Confidential - Huntington Beach

QA Analyst

Responsibilities:

• Reviewed business requirements and technical specification documents
• Developed test plans, test cases based on functional specifications and design documents
• Involved in preparing the test scenarios from the Use Cases
• Maintained requirements and created Traceability between requirements and test cases
• Prepared the test cases and executed the test scripts
• Executed queries in SQL for analyzing data and data validations
• Worked closely with users and program developers to ensure that the application development met the user expectations
• Involved in all phases of Testing Methodologies that included User Acceptance Testing, Functionality Testing, Interface Testing, and Alpha Testing, Beta Testing, End to End testing
• Defects were tracked, reviewed, analyzed

Confidential - Los Angeles

QA Tester

Responsibilities:

• Understanding of Requirements Specifications
• Writing and Executing Test Cases in Quality Center
• GUI, Smoke, Sanity, Functional, Integration, System, Database Testing, Regression Testing
• Validated and verified data logged as per user actions in TOAD using SQL
• Written SQL Queries for back end testing
• Verifying business rules, Foreign, Primary Key concepts, data constraints
• Involved in design discussions, preparation of database design, data models
• Defect logging and retesting in Quality Center.