PROFESSIONAL SUMMARY:

• 8 years of Experience in Analysis, Design, Testing and Implementation in the field of Software Quality Assurance.
• Experience working on different domain applications like Finance, Insurance, Healthcare, and Retail.
• Excellent understanding of Waterfall, RUP and Agile (Scrum) methodologies in the Software Development Life Cycle (SDLC).
• Proficient in reviewing various project related documents like BRD, FRD, Use Case, Test plan, Summary, Sign off and Business Report Documents
• Experience in Functional, Integration, System, Sanity, Smoke, Performance, Regression, Compatibility, Security, and ETL Database Testing.
• Proficient in documenting and writing Test Plans, Test Scenarios, T est Strategy, Test Cases, Test Labs, Test Processes, Lessons Learned for various projects.
• Experience in writing Bug Reports and filing Defects as part of Day to Day Testing activity.
• Extensively involved in tracking defects with Quality Center, Clear Quest and Bugzilla.
• Excellent knowledge and experience in Data Warehousing, Data Modeling (logical and physical), Data Validations, Data Mapping, ETL and Relational Database Management Systems (RDBMS).
• Involved in Security, Anti - Money Laundering and Fraud Analysis by coordinating with downstream systems. Worked in Mobile/Tablet Projects on Money Movement Systems.
• Extensive experience in AUTOSYS and BATCH Process on various SOR platforms like Online Banking, Mobile and Tablet.
• Knowledge of Automation using tools like QTP, LoadRunner, Soap UI and Selenium.
• Performed testing of XML/Web Services files using Soap UI from various downstream systems for Error handing purposes and validating the request and response received from various layers and troubleshooting the issues.
• Experience in Leading Projects and delivering within the crucial time frame. Experience in handling Multiple Projects during the same Release.
• Experience in using Load Runner for monitoring the System resources, Server performance and Identification of the performance bottlenecks during heavy load.
• Worked on UNIX Utilities like AWK, GREP, VI Editor, Processes, Redirection, Files and Directories.
• Outstanding skills working with SQL Sub Queries , Joins , Functions and Database Schema Objects like tables, Views, Indexes, Sequences, and Synonyms .
• Involved in Production Support and troubleshooting when required. Participated in Systems Requirement Reviews and Team meetings.
• Experience in coordinating with development, Project management, onshore, off-shore teams and Peers. Good Verbal Communication and technical skills.
• Identify and communicate risks to Project team, attend defect triage meetings and provide regular updates and status reports to the Project Coordinator/Manager.
• Excellent Inter Personal and Business analytical skill, ability to learn new concepts in a fast paced environment, Multi-task and prioritize.

TECHNICAL SKILLS:

Languages: C, Java, PL/SQL, T-SQL, UNIX Shell Scripting

Databases: Oracle, MS SQL Server, MS Access, MySQL

Operating Systems: UNIX, Windows (2003/NT/XP/VISTA/7), IOS, Android OS

Automation Tools: QTP, LoadRunner, SoapUI, Selenium

Tools: SQL* Plus, Toad, Visio, Visual Studio, Code Blocks, Eclipse IDE, ERwin, SSIS, SSAS, SSRS, SQL Loader, SDK, SQL Developer, AUTOSYS, HOGAN, Informatica

Version Control: VSS, Tortoise SVN

Web Technologies: HTML, CSS, XML, PHP, JavaScript, VB Script, Flash, Photoshop

Web Servers: Tomcat, Apache

Browsers: IE, Google Chrome, Firefox, Safari, Opera

Defect & Test Management Tools: JIRA, Confidential Quality Center, ALM QC, Bugzilla, Edit Plus, Rally

Applications/Software: VMware, Win SCP, PUTTY, FTP, Excel

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

ETL DATA QA

Responsibilities:

• Responsible for Data Validation in Extraction, Transformation and Load for the Enterprise Data Warehouse
• Performed UAT of the data as per the Line of Business Requirements 
• Testing in production, trouble shooting and resolving production issues promptly.
• Involved in the validation and testing of Retail (US Auto, Other Consumer) and Small Business Schedules for the Confidential (BOW) and First Hawaiian Bank (FHB).
• Mapping and Validation based on the Functional, Technical and Business Specification Documents and writing SQL queries based on the requirements.
• Writing Code based on the mapping provided with the business mapping documents.
• Comparing data between the source and target tables and Vice versa to validate data migration
• Validation of mapping keys, tables as required for the Federal Edit checks and CCAR submission. Validation of Data Quality and compliance to the FED Edit check rules
• Track Defects or Service Requests in QC with different severities
• Worked on TDA for the manual upload process and validation
• Involved in backend validation of the Regulatory and Call reports, GL accounts and balances.
• Involved in Functional, Integration, Smoke, Regression and backend testing and validation
• Continuous Coordination with Data, BA, QA, Reporting, Development and Production OPS team. Troubleshooting issues with triage calls and working with development under strict timelines.
• Worked on OBIEE dash boards for front end and back end report validation for the Finance and Risk Datamart.
• Worked on Informatica for ETL Validation. Compared the data loaded from Informatica and Oracle

Environment: ALM QC, Excel, TOAD, TDA, EDIT Plus, Visio, ORACLE, Informatica, Linux, OBIEE and call Reports

Confidential, Pleasanton, CA

ETL Automation QA

Responsibilities:

• Worked extensively in MySQL and Linux for the Data Migration of the BLISS Data.
• Rigorous testing using MySQL. Troubleshooting the Logs and working with the development team to fix Issues on day to day basis.
• Written Test cases for the different test scenarios and Mapping based on the Functional, Technical and Business Specification Documents.
• All test cases are MySQL Stored Procedures which were called and executed by the Spring Batch JAVA Framework Validation Services to produce a UI Validation Report.
• Responsible for the Data Validation in Extraction, Transformation and Load for bulk data.
• Used Shell Scripting for manipulation, Load and Testing of the data into the Staging area and the Final Load Database.
• Used Putty and WINSCP to work with data in different servers.
• Performed Testing with web services and JSON parser for all the existing and enhanced features of the application.
• Involved in working with the Development and DBA for fine tuning the various queries and Performance Tuning.
• Involved in testing and analysis of Production Issues promptly under strict deadlines.
• Performed Internal and External walkthrough of Test plan and Test cases.
• Involved in continuous coordination with the Development and off shore team for concerns, issues and defects during the project.
• Track Defects or Service Requests in Rally with different severities.
• Involved in the Project meetings and Discussion with Technical Leads, SME’s, Project Manager and Development Team.
• Weekly preparation of test status report and test execution tracking report.
• Actively involved in day to day Scrum meetings and grooming sessions for the user stories for the Agile Project.
• Continuous Coordination with Data, Project, Technical and Development team for the successful completion of the project.

Environment: UNIX, MySQL, Putty, WINSCP, FTP, XML, Windows, Rally, Excel, Shell Script, SQL* Loader, Shell Scripting, MySQL Stored Procedures, EDIT Plus, Informatica

Database: MySQL in the cloud

Confidential, San Francisco, CA

AUTOSYS BATCH QA

Responsibilities:

• Worked extensively in SQL, AUTOSYS and BATCH processing for the OLTP/OLAP Data Warehouse system on various SOR platforms like Online Banking (OLB), Mobile and Tablet.
• Developed Functional Test Plans, Test Cases and Defect Summary Reports for the various projects in each Build.
• Rigorous BATCH testing using AUTOSYS for running Daily Jobs, Daily Reports for the Data Warehouse and all OLTP Transactions. Troubleshooting the Logs and working with the development team to fix Issues.
• Written Test cases for the different test scenarios based on the Functional, Technical and Batch Specification Documents in Mercury ALM Quality Center (QC).
• Worked on HOGAN system for the money movement solutions.
• Prepared the Test Strategy document that elicits the test environment, different phases of testing, testing timeline, entry and exit criteria for the different phases of testing and the resources involved in the project.
• Track Defects or Service Requests in IBM Rational Clear Quest (CQ) with different severities.
• Working with the Build and Engineering services team (BEST) to track environmental and build issues during the initial phase of the project.
• Involved in continuous coordination with the Development and Business teams to have the ambiguity reviews for projects and to solve issues and concerns.
• Responsible for performing functional and data-related testing for the different types of SLA’s like DDA’s, CC, Student Loans, Mortgage, Brokerage, Credit and Loan accounts.
• Involved in the discussion about the projects with Technical Leads, Project Manager and Development Team. Assign and work with the project team if leading a project.
• Weekly preparation of test status report and test execution tracking report.
• Prepare the Test Lab having the test cases to be executed for project and manually execute all the test cases in Confidential ALM Quality Center to verify the expected results.
• Performed manual continuous Regression Testing for all the existing and enhanced features of the application.
• Involved in testing and analysis of Production Issues promptly under strict deadlines.
• Performed Internal and External walkthrough of Test plan and Test cases.
• Continuous coordination with an outside vendor tool called the Clear Exchange (CXC) system for all the online Money Movement Transactions.
• Participated in various meetings and discussed Enhancement and Modification Request issues with on shore and off shore teams. Actively involved in Scrum meetings for the projects.
• Continuous Coordination with Data, Development, Business, Fraud, Anti-Money Laundering, Compliance, Technical and Project team for the successful completion of the project.

Environment: AUTOSYS, UNIX, SQL, XML, Windows, SharePoint, SOAPUI, HOGAN, Mercury ALM Quality Center (QC), IBM Rational Clear Quest, Putty, WINSCP, FTP, Excel, Third Party Vendor Systems (CXC), Shell Script, SQL* Loader, SQL Developer, Toad, EDIT Plus, Snipping tool

Database: Oracle

Confidential, San Francisco, CA

Quality Analyst

Responsibilities:

• Analyzed and tested according to the development activities based on the User Stories in various Sprints in an agile environment.
• Performed Basic Acceptance Test to determine whether new builds are qualified to be tested.
• Tested the application on different browsers like IE, Firefox, Google chrome, and Safari.
• Tested the application for navigation to different pages, buttons and other features on the web application.
• Participated in reviewing software requirements and functional specifications for completeness and testability
• Wrote test protocols, test scenarios, test procedures, and test cases using Quality Center.
• Involved in data validation - input parameters and XML output from the back end services.
• Extensively used SQL Queries to validate the backend Database. Worked with SQL Joins, sub queries for Data Validation and Data Integrity.
• Created adaptable and reusable test scripts to check functionality as well as the property of the different windows and objects of the application.
• Work directly with Developers to verify if Test Cases meets User Story requirements
• Responsible for Performing System Integration testing to ensure flow of data to the Web based application. Performed API testing using SOAP UI services.
• Performed daily activities such as planning and control, choosing test conditions, designing test Cases and checking results, evaluating exit criteria, reporting and closing the test.

Environment: Soap UI, Selenium, Agile, SQL, XML, UNIX, ORACLE, Java Script, QC

Confidential, Cupertino, CA

ETL/QA Analyst

Responsibilities:

• Experienced in building test strategies for end to end testing of the different BI applications like the SSRS reports, and SSAS cubes for data validation.
• Created and executed Use cases based on test plans, and ETL mapping documents.
• Experience in Backend testing using SQL queries to verify that the data is properly loaded in the database and the application is correctly loading and extracting data from the database.
• Tested complex SQL queries, Functions, Tables, Views, Joins and other T-SQL code to implement business rules.
• Worked on T-SQL procedures, SSRS Reports, SSAS cubes for data validation.
• Tested and Analyzed TABLIX Reports, Tabular Reports, Matrix Reports, parameterized reports, Cascaded parameters and various Charts created using SQL Server Reporting Services (SSRS).
• Checked and tested the weekly and monthly reports with date range and time unit for data validation.
• Solid testing experience working with Stored Procedures, Functions, Tables, Views, Joins and other T-SQL code to implement business rules. Extensively used LTRIM, RTRIM, DECODE, ISNULL, IF ELSE, INSTR and Date Functions in validations.
• Worked on UNIX utilities like AWK, GREP, SED, Vi Editor, files and directories.
• Worked with log files to verify the processes for debugging and test data verification.
• Experienced writing various reports like Test Log Summary Report, Test Plan Detail Report, and Defects Summary Report and Test Cycle Status Report to analyze the testing process.
• Worked with version control system SVN to troubleshoot build related issues
• Participated in Sprint, and off shore meetings with business users.

Environment: SQL, T-SQL, SSRS, SSAS, SSIS, Microsoft Visual Studio, Erwin, ALTOVA, UNIX Shell Script, JavaScript, SVN, SharePoint, Windows XP.

Confidential, Woodland Hills, CA

QA Analyst

Responsibilities:

• Responsible for validation and testing of migrating data from different data sources to the Oracle database for NWCS.
• Involved in Integration, Functional, System, Database, Regression, and testing for the Data Warehouse Application
• Involved in Gap Analysis and worked with developers to troubleshoot problems and inconsistencies.
• Written technical queries for Source to Target mappings based on requirements.
• Designed test plans and test cases for testing the dimension and fact builds for incremental load and execution.
• Experience in Backend testing using SQL queries and TOAD to verify that the data is properly loaded in the database and the application is correctly loading and extracting data from the database.
• Involved in testing the XML files and checked whether the data is parsed and loaded into the staging tables
• Worked on the Log files to verify the processes for debugging and test data verification.
• Validated the load process of ETL to make sure the target tables are populated according to the data mapping provided after the job execution.
• Worked on UNIX utilities like Processes, Redirection, Files and Directories.
• Validated the filters and data results for balances, totals and subtotals for the data set.
• Identified duplicate records in the staging area before the data gets processed.
• Worked on Shell scripts for file transfer, error log creation and log file cleanup.

Environment: UNIX, Oracle, Informatica, MS Access, MS SQL, SharePoint, QTP, SOAPUI, ETL, QC, WINSCP, FTP, Excel, COGNOS, Shell script, SQL* Loader, Erwin

Confidential, Boston, MA

QA Analyst

Responsibilities:

• Developed and modified the testing documents including test plan, test scenarios, test cases and relevant scripts throughout the project.
• Tested the system to verify the compliance with HIPAA in terms of privacy, security and standards.
• Performed Manual Regression Testing by testing entire functionality of the application and executing manual test cases on different builds and validated the actual results against the expected results.
• Validated the Inbound and Outbound claims processing systems.
• Involved in creating Requirements Traceability Matrix to map the test cases and the requirements.
• Created Base Files on Transactions for the Medical Claims Analysis and created Test files based on test scenarios and conditions.
• Performed Smoke, Functional, Regression, System, Database and Integration testing.
• Inserted Check Points to check for the broken links, text, and standard properties of an object.
• Worked with developers to develop SQL-queries/procedures for database and backend testing.
• Used QC for tracking, reviewing and analyzing the various defects in the application.

Environment: SQL, Oracle, TOAD, UNIX, QTP, QC, Version Control, Windows XP, FTP

Confidential, Cranston, RI

QA

Responsibilities:

• Reviewed Business, Functional, and Process Design documents to create and execute Test Cases on multiple projects.
• Performed balance and customer information inquiries against host systems,
• Performed smoke testing on the application before accepting the build. Performed Regression testing by manually validating the entire functionality of the application and executing manual test cases on different builds.
• Responsible for the preparation of test Scenarios, test scripts from requirement documents.
• Identified and documented the defects using Quality Center and involved with the development team to solve the defects.
• Performed backend Integration testing by writing and executing SQL queries on the SQL server database. Performed data validation and querying with SQL queries.
• Experience testing document processing applications like scanning, Indexing, Exception processing, Scan Exceptions, Integration of document processing with vendor applications, delivery of documents.

Environment: SQL, QC, Web Applications, JavaScript, ORACLE