SUMMARY

• Over 11+ years of Experienced DWH and BI Tester/Analyst with strong background in design, development, and support of databases and information products as well as data analysis / reporting / processing.
• Hands - on experience in Verification & Validation Web based and Client Server applications are developed in Java, Java API, ASP, VB.Net and with business domains of Banking, Insurance and Retail.
• Experience in Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch
• Complete understanding of Quality Assurance Life Cycle (QALC), Defect Life Cycle, and Software Development Life Cycle (SDLC).
• Extensive experience in Web Based and GUI based client/server Application Testing / Automation Testing SOAP-UI/ System & Integration Testing / End-to-End Testing / Back-End Testing (SQL/TOAD)/User acceptance testing (UAT).
• Hands on experience in Document Imaging applications developed in FILENET P8.
• Hands on experience in performing Functionality Testing, Integration Testing, System Testing, Regression Testing, Performance Testing, Data Migration Testing, Web Service Testing and UAT and Business-Flow testing.
• Experienced in working agile software development environment.
• Proficient in all aspects of Test Documentation: Test Plans, Test Cases, Test Scripts, Defect Reports, Traceability Matrix and Test Completion Reports.
• Experience in using test management tools like Quality Center, Version One
• Experienced in analyzing Design Documents to determine and describe data flow from source to target Databases by coordinating with Business Analysts, DBA’s and Application Architects.
• Success driven team player with interpersonal skills, self-motivation, and early adaptation to new applications and technologies with proven skills in multi-tasking, handling multiple projects and responsibilities.
• Ability to balance competing priorities and tight deadlines.
• Having extensive experience in XML files data validation through XMLSpy or Editors

TECHNICAL SKILLS

Software Testing: Manual Testing, Test Cases preparation, System Testing, User Acceptance Testing, Regression Testing, Functional/Integration Testing, Database testing, Data warehouse testing, API testing (SOAP-UI, SOAP UI PRO ) testing, File Net projects testing, AWS, S3, SQL Workbench, Cygwin64

Test Tools: Quality Center 10.0, ALM 11.52 and Exposure in Automation UFT

Operating Systems: Windows XP/2000/98/95, UNIX

Methodologies: Agile, Waterfall

Industries: Banking and Finance

Database/ Tools: ETL Informatica, Oracle 9I, PL/SQL Developer, TOAD, TOAD for DA, SQL Work Bench

PROFESSIONAL EXPERIENCE

Confidential

ETL Tester/Onsite QA Lead

Responsibilities:

• Attending requirement review meetings with client and provide responses to their comments and capture action items and work on action items.
• Participate in QA (Quality Assurance) reviews and provides required support and clarifications as need for the reviewers.
• Conducted Defect Triage meetings with Developers and Business users on daily basis, and also responsible for creating defect management reports using Quality Center for Executive Management and Steering Committee
• Responsible for planning test execution schedule, and allocation of resources, tracking and monitoring actual work progress against planned work assignments
• Responsible for creating testing status reports and summary reports for Go./ No Go decision making and supported application deployments
• Verifying the Data Cleansing, Data Conversions, Data Transformation, Data Quality, Data Relationships, between Source Systems Analysis and Reporting
• Worked with Offshore team daily basis
• Conducting smoke test after releases and decide to accept or reject builds.
• Conducting Regression testing, functional Testing, System Testing using PLSQL scripts
• Performed Interface testing for Inbound and Out Bound Interfaces.
• Participating in the release planning meeting.
• Involving in UAT (User Acceptance Testing) support with business users
• Worked in interface partner test execution
• Validate the Records in Source and Target by using SQL
• Participating in technical discussions with customer for getting the business clarifications and requirements gaps
• Preparation of Test Strategy, test plan and Tradability Matrix documents
• Execution of Test Cases and defect reporting metrics preparation
• Experience in System Integration testing, Database and API testing, Functional testing (Black box testing) Security, Recovery, Negative, Regression testing, Load testing
• XML files data validation through XMLSpy or Editors

Environment: ORACLE DB10G, INFORMATICA 9.1, ERWIN 7.3.1, UNIX, XML Spy 10.0, TOAD for ORACEL 10.0, TOAD for DA 2.5

Confidential

ETL Tester/Onsite QA Lead

Responsibilities:

• Attending requirement review meetings with client and provide responses to their comments and capture action items and work on action items.
• Participate in QA (Quality Assurance) reviews and provides required support and clarifications as need for the reviewers.
• Adopted Agile/scrum methodology for - Risk Mitigation, Monitoring and Management (risk analysis) at every stage of the project Cycle with transparency in planning and module development.
• Daily project status meetings with client
• Conducted Defect Triage meetings with Developers and Business users on daily basis, and also responsible for creating defect management reports using Quality Center for Executive Management and Steering Committee
• Worked with Offshore team daily basis
• Validating CSV file data against XML files
• Creating a QA tables in SCHEMA for data importing from CSV and XML files
• Validating imported CSV and XML file data by preparing PLSQL scripts and compare both the tables data.
• Validate XML tags and structure by using XMLSpy
• Reviewing test results, defects. Submitting test results to Client for further review.
• Conducting smoke test after releases and decide to accept or reject builds.
• Conducting Regression testing, functional Testing, System Testing using PLSQL scripts
• Performed Interface testing for Inbound and Out Bound Interfaces.
• Participating in the release planning meeting.
• Involving in UAT (User Acceptance Testing) support with business users
• Preparation of Test Strategy, test plan and Tradability Matrix documents
• Execution of Test Cases and defect reporting metrics preparation
• Experience in System Integration testing, Database and Functional testing (Black box testing) Security, Recovery, Negative, Regression testing, Load testing

Environment: ORACLE DB10G, INFORMATICA 9.1, ERWIN 7.3.1, UNIX, XML Spy 10.0, TOAD for ORACEL 10.0, TOAD for DA 2.5, TOAD Data Analysis.

Confidential

Member Technical Staff

Responsibilities:

• Closely working with onsite team for getting the business clarifications
• Analyzing the requirements and preparing the test scripts
• Handled extensive Web-Service testing of the SEPA online application using SOAP-UI tool.
• Set up the test suits, test framework and automates the testing in SOAP UI.
• Participating in test execution and defects reporting
• Giving time estimations for project test execution
• Review the functional and Design specifications
• Preparation of Test Strategy, test plan and Tradability Matrix documents
• Prepared sql test scripts for data validation from source to target.
• Performed Functional, Regression and Integration testing
• Execution of Test Cases and defect reporting.
• Data validation through SQL queries from source to target
• Attending Scrum Calls

Environment: ORACLE DB10G, Business Objects(XI), Pega 6.2, INFORMATICA 9.1, ERWIN 7.3.1, UNIX, XML Spy 10.0, TOAD for ORACEL 10.0, TOAD for DA 2.5, SOUP UI 4.6.0

Confidential

Member Technical Staff

Responsibilities:

• Validate the Records in Source and Target by using SQL
• Closely working with business team for getting the business clarifications
• Participating in technical discussions with customer for getting the business clarifications and requirements gaps
• Wrote SQL queries to validate data from ORACLE Database
• Providing the time estimations for project test execution
• Review the functional and Design specifications
• Preparation of Test Strategy, test plan and Tradability Matrix documents
• Execution of Test Cases and defect reporting metrics preparation
• Experience in System Integration testing, Database and Functional testing (Black box testing) Security, Recovery, Negative, Regression testing, Load testing
• Performed Functional, Regression and Integration testing and End-To-End testing
• Performed CRUD properties validation
• Execution of Test Cases and Bug reporting.
• Participating Scrum calls and sprint planning meetings.
• Reviews the functional and Design specifications
• Preparation of Test plan and Trasability Matrix documents
• Provide test executions estimations on QA execution
• XML files data validation

Environment: ORACLE DB10G, INFORMATICA 9.1, ERWIN 7.3.1, UNIX, XML Spy 10.0, TOAD for ORACEL 10.0, TOAD for DA 2.5

Confidential

Senior QA Engineer

Responsibilities:

• Understanding the Requirements and maintaining the RTM.
• Handled extensive Web-Service testing using SOAP-UI tool.
• Preparing test plan and test sign off documents.
• Preparation of Test Scenarios based on Use cases.
• Involved in the preparation of Regression Test Package as per the end user requirements and also test data that corresponds to the test package.
• Coordinating with the onsite lead and getting clarification on the functionality gaps.
• Preparing high level diagrams and knowledge documents to the end users.
• Participating in the meetings with the end users to discuss about the project.
• Execution of Acceptance Testing with the end users.
• Reporting Bugs through HP Quality Centre 9.2.
• Tracking the Bug Fixes and re-testing them.
• Generating Reports and Graphs.

Environment: VB.Net, .Net 3.5, WCF, VS 2008, TFS, Oracle 11g, Infragistics WinClient RUI Controls,: Microsoft Enterprise Library 4.0(Validation Framework, Data Block). SOAP UI

Confidential

Associate QA

Responsibilities:

• Reviewed the M&T test cases and Updation
• Performed Functional and Regression testing
• Execution of Test Cases and Bug reporting.
• Preparing impact analysis to estimate the QA effort

Environment: ASP.Net, VB.Net, SQL Server 2005, Window workflow foundation, Crystal report, AJAX and Java script.