SUMMARY

• Over 7 years of experience in developing Test Strategies, comprising Test Plan, Test Scenarios, Test Scripts and Automation of testing of various Data warehousing, BI, Client/Server and Web applications.
• Coordinated the plans, strategies and tasks with the Project Manager, Business Analyst, Developer, QA Team, Release Management
• Experience using query tools for Oracle, Teradata, MS SQL Server to validate reports and troubleshoot data quality issues.
• Managed handling multiple projects and Worked as Test Lead for many offshore/onsite models.
• Experience in testing and writing SQL and PL/SQL statements.
• Expert in writing Test Plan, Test Cases, Test Matrix, Traceability Matrix and Test Scripts.
• Tested the reports generated by OBIEE/Tableau and verified and validated the reports using SQL.
• Extensive experience working on regulatory projects like Basel II, Basel III using OFSAA/AXIOM frameworks.
• RIS submission Data (Account and Portfolio) in production validated using Mapping docs against EIP for TDR, OCC,MLL,HELOC,FICO, FHLB and Credit Card before sending to AXIOM and Argus.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Expertise in testing complex Business rules by creating mapping and various transformations.
• Experience in testing XML files and validating the data loaded to staging tables.
• Good experience in Tableau Reports testing.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Experience in all phases of Software Development life cycle.
• Experience in coordinating testing efforts among the team, exposure to Software development life cycle (SDLC), Waterfall, Agile and SCRUM methodologies.
• Application Data warehousing experience in Banking, Pharmaceutical and Insurance.
• Performed Unit, Integration and System Testing.
• Good analytical and problem solving skills.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.
• Team oriented and ability to understand and adapt to new technologies and environments faster. Good at analysis and troubleshooting.
• Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS

Databases: SQL Server 2014, Oracle 11g, MS Access.

Programming: VB Scripting, SQL, PL/SQL, HTML, VBA Macros, Visual Basic.

Tools: HP QC/ALM, QTP/UFT, JIRA, Tableau, OFSAA, OBIEE, SharePoint Designer, Putty.

PROFESSIONAL EXPERIENCE

Confidential

QA Analyst

Responsibilities:

• Tested RIS submission Data in Production validating EIP data against Mapping doc. before sending them OCC.
• Tested EIP portfolio and account data for TDR, OCC, MLL, HELOC, FHLB before sending them to Argus.
• Tested EIP account and portfolio data against AXIOM.
• Co - ordinated with Development Team and all stakeholders to discuss defects/issues.
• Helping Business team with required information for UAT in QA environment.
• Coordinate the plans, strategies and tasks with the Project Manager, Business Analyst, Developer, QA Team, Release Management.
• Involved in documenting clearly defined test scenarios into test cases.
• Updated tasks statuses in excel to ensure burn down charts are not skewed.
• Assisted project manager in maintaining test schedules, issue/decision logs.
• Designed reports to provide summary of test status using MS Project and Excel.
• Performed Functional, Data Migration, Regression and System Integration testing.
• Analyzed defect aging and reported to management to ensure that the release is not affected.
• Analyzed recurring defects and presented root cause analysis (RCA) to the management.
• Requirement review meetings with business analysts and providing Suggestions / Feedback for better validation.
• Validated the Dodd Frank 165 (unstressed) 30 Day Projection Report.
• Validation of the reports bases the rules/short hands given by the Business.
• Executing and monitoring the RWA Calculator batches and validating the FFIEC 101 Reports.
• Meetings with Development team to understand code implementation and impact using Oracle Solution and Sizing documents.
• Preparing test scenario documents.
• Creating test sets in test plan and modified the scripts based on the latest business requirement changes in ALM 12
• Traceability of Defect or Requirement with Test Case.
• Worked on OFSAA (Revalues), processing data from various sources.
• Documented all the changes that needed for functional requirements.
• Update management with the statistics of the Test execution.
• Wrote SQL queries to validate data.
• Automated the Test Scripts for GUI, Functional, Data Driven and regression testing using QTP.
• Debugged and resolved the QTP scripts.
• Prepare and presented test results and reports.
• Interacted with development team to track delivery schedule.
• Participated in Defect Meetings with QA, product owner and development team.
• Attended project meetings, release meetings and QA status meetings.
• Updated the Client/management with daily/weekly work status.

Environment: ALM, QTP, VB Script, Oracle 11g, TOAD, Teradata Assistant 14.0, Teradata Studio, Sql Server, MS Office, OBIEE, Tableau,Widows, UNIX

Confidential

Software Tester

Responsibilities:

• Reviewed and verified for adequacy of SDLC documents (Software development plan, functional specification, risk management plan, deployment guide, release management and user manual.
• Designed and developed Test Scenario/Test Cases/Test steps for various Business Services/methods covering both positive and negative testing requirements.
• Involved in reviewing and implementing the Business Requirement Documents to create a comprehensive list of Test Cases and various test scenarios.
• Participated in Requirements walk through and analyzed developed Use Cases.
• Verified and edited test data in new or existing systems.
• Prepared Excel Sheet for Requirements and export the requirements to HPALM.
• Wrote comprehensive Test Cases and executed written Test Cases of the application.
• Used HP ALM as the test repository, executing the Test Cases, Test Scripts and logging & generating various reports and graphs for further analysis.
• Wrote and recorded VB Scripts for automating the testing procedure using QuickTest Professional.
• Maintained Test Matrix for the latest test results information.
• Reviewed Business Requirement documents for writing Test Cases and Test Procedures.
• Identified Defects and discrepancies, documented & tracked Defects in HP ALM and coordinated defect calls.
• Retested defect fixes and provided update to development team.
• Planned Test Script execution to allow enough time for multiple passes and/or significant regression tests.
• Communicated defects encountered during regression test and followed-up with developers until all issues were resolved.
• Created SQL queries to retrieve data from database to validate the input data.
• Executed different SQL Queries to ensure data integrity.

Environment: HPALM, Quick Test Professional (QTP), Agile test methodology, JavaScript, HTML and SQL.

Confidential

Automation Tester

Responsibilities:

• Designing of Test Scenarios, Test Cases, and Test Conditions as per the requirements.
• Involved in Requirements Analysis and creating Traceability Matrices.
• Tracking Defects using HP ALM
• Activity Tracking.
• Performing Sanity, Functional, Integration and Regression testing.
• Preparing the scripts for Automation and executing it within the framework (Data Driven).
• Integrating HP ALM and QTP for reporting defects.
• Developed scripts using VB Script and Descriptive programming in QTP for regression testing activities of front end-application of the web based testing.
• Involved in automation regression testing using QTP and data driven framework.
• Developed robust Test Scripts using QTP.
• Wrote SQL queries to validate the data.
• Reporting Test Results, defect tracking, defect review, validation.
• Reviewing the status of the project and taking corrective measures as required.
• Training the other resources and allocating work.
• Involved in Resource planning and Effort estimation.
• Involved in Post Implementation Activities like root cause analysis.
• Involved in requirements capturing, documentation of the system & enhancement of the application.
• Reporting Daily and Weekly Status Reports to clients.
• Post Production Support.

Environment: QTP, HP ALM, VB Script, SQL Server, MS Office, Windows