SUMMARY

• ISTQB certified IT professional with over 6 years of IT experience covering ETL Testing, Quality Assurance, Data Analytics, Middleware testing and Data Migration validation of Banking applications.
• Strong knowledge in SQL, Teradata SQL and Data Analytics for Data warehouse and ETL based project.
• Experience in Teradata SQL Assistant, Toad and SAS for reporting and analytics as part of Data Warehouse Migration project.
• Worked with major US Banking and Financial institution as Data Analyst,ETL Tester and QA analyst roles.
• Experience in working with VModel Methodologies along with Agile method for fast iterative software development.
• Strong Experience in handling critical deliveries and ensuring that they GO - LIVE as per planned schedule.
• Worked as a SME with experience in test planning & test strategy for most phases of STLC.
• Experience in FSD reviews, preparation of Block Diagram of individual Applications/modules, Application Map Matrix, Test Plan/Test Strategy, Test Conditions, Test Cases, Test Data, Test Data Mapping with the Test Conditions and Defect Management, SQL queries.
• CCAR, Basel and Regulatory Report validation and compliance testing
• Active involvement in functional and business Requirement analysis and data profile review sessions.
• Worked on Report Unwinding and developed the Data Lineage report for BCBS program.
• Maintaining the clarification log and obtaining the resolution from business and development teams.
• Prepared the Execution report, Root Cause Analysis report, Defect Rejection report and other metrics.
• Documented the Lessons learnt, reviewed the User guides and test closure reports.
• Experience in System, Functional, Regression Testing.
• Expertise in Defect Tracking and Management using HP ALM, JIRA and Quality Center.
• Have very good experience of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
• Established cordial relationships with various stakeholders viz Test Automation team, Business, Development leads and support team members.
• Provided Training sessions for New joinees and created reference documents for the team.

TECHNICAL SKILLS

Software language: SQL, Teradata SQL, Unix

Software Tools: Terdata SQL Assistant, SAS 9.3, Toad, Filezilla, Putty

Test Management Tool: HP ALM, HP Quality Center 10, JIRA

Middleware Testing: IBM Greenhat (RIT), SOAP UI

PROFESSIONAL EXPERIENCE

Confidential

ETL Tester/Data Analyst

Responsibilies:

• Participated in Business requirement and impact analysis walkthrough with Data stewards and Business team.
• Supported the Extraction, Transformation and Load process (ETL) for data load from legacy systems and analyse the gap.
• Validated Data migrated into new warehouse is in sync with legacy systems.
• Creating Data Trend Analysis on Month-to-Month data to ensure the Migration is effective.
• Interface testing with MSP, EMITS,RQMS, Finance Source of Records
• CCAR and Basel Report Validation for Audit and Governance.
• Internally Certify data to be compliant with regulatory standards by discussing with Data Stewards and DQM (Data Quality Management).
• Generated SQL code for Business requirement validation using Teradata SQL Assistant and Toad.
• Performed data analysis using SAS tool and create the report graphs.
• Performed data validation in Staging and Intergration layers.
• Validating the Data Transformations logic implementation and 3rd party data load.
• Walkthrough of the test summary results with IT, Business and Data Stewards.
• Attended and update the stakeholders on the progress of the testing effort on a daily, weekly and monthly basis through Status calls and Reports.
• Tracked the data variations closely to ensure that critical defects are uncovered at early phases and creating the Impact analysis.
• Vaidated the Source data files to make sure correct data has been captured to be loaded to target tables.
• Scheduled Defect triage meet with Development and Business team and provided the root cause of the issue based on the Analysis between STT and Test SQL.
• Creating dashboard reports, Test Closure report, DRR and other metrics.
• Provided Training on Tools and Business function to team and new joinees.

Environment: Terdata SQL Assistant, SAS 9.3, Toad for Oracle, Putty, Unix, Filezila, JIRA, IE, Windows 7, HP ALM, MS Office, IBM Cognos, Informatica Power center

Confidential

Quality Assurance

Responsibilies:

• Participated in Business requirement and impact analysis walkthrough and providing QA Signoff.
• Based on acquired knowledge, provided effort estimation required for testing.
• Analyzed system requirements to identify the scope of middleware services.
• Worked on Test strategy/Test Plan document for the releases/cycles.
• Defining the scope of testing within the context of each release / delivery
• Test Design, Execution and Defect tracking using HP ALM.
• Preparing Master Test Approach Document for every functional module, containing the list of functionalities and SQL query for test validation.
• Created Block Diagram for individual modules and relating them with their dependancies.
• Application Map Matrix preparation to record the number of changes made during each release on a particular module as per the FSDs associated with each of the subfunctions.
• Prepared Test Conditions to test case mapping, FSD mapping to test conditions, older/existing defects mapping to test cases (for regression testing)
• Prepared and executed SQL queries in SQL server, and these are used in the test cases for DB validation.
• Coordinated with the Automation team to automate test cases
• Performed middleware automation testing using IBM Green Hat/RIT.
• Validated Database using UNIX
• Validation of various Reports like .csv and accessing them from Filezilla
• Validation of XML request and response using SOAP UI
• Tracked the results closely to ensure that critical defects are uncovered at early phases.
• Attended project meetings with QA Manager, Automation team, Business and ITBA.
• Bridged the gap between business analyst and testers regarding the functional understanding and client’s requirements.
• Updated testware related to different modules, actions undertaken and issues tracking using JIRA in SharePoint.
• Creating Daily/Weekly/Monthly Status Reports along with test closure reports

Environment: SQL Server 2008, HP QC10, Putty, UNIX basic commands, Filezilla, JIRA, IBM Rational Integration Tester (RIT), IE, Windows 7, XML, SOAP UI, Webservices, MS Office, Macro

Confidential

QA Tester

Responsibilies:

• Participated in Business requirement discussions, High Level design (HLD) discussions, regular scrum calls.
• Analysed the requirement design and use cases.
• Worked on Agile methodology.
• Prepared SQL queries to test.
• Performed unit testing on modules coded by our team.
• Provided daily and weekly progress report to Client and TCS managers.
• Maintained the progress tracker, issue/log tracker.

Environment: Oracle, Toad, HP QC 10, Unix, MS Office, Windows XP, IE

Confidential

Jr.Tester

Responsibilies:

• Evaluating Business Requirements, IT Design Documents for all assigned Project releases.
• Performed UI Testing using Waterfall methodology.
• Validated the data using SQL queries for back end database testing.
• Performing Peer review for the prepared Test cases
• Writing test design steps in test plan in Quality Center
• Performed Positive and Negative testing to verify Functionality.
• Bug reporting, Defect tracking and re-testing using Quality center 9.2
• Preparing the status report and reporting.

Environment: SQL server 2008, Quality center 9.2, IE, Windows XP, MS Office