EXPERIENCE SUMMARY:

• 8 years of working experience in QA and ETL testing.
• Expertise in SOA Web services testing.
• Good working experience in SQLDatabase (writing SQL queries, RDBMS Concepts).
• Have working experience as QA Tester and UAT tester.
• Experienced in working on various databases like SQL Server, Teradata, Oracle, DB2, Sybase.
• Experienced in working on various operating platforms like Windows and Unix.
• Excellent knowledge in tools like Parasoft 9.5, SOAP UI, JMS Test client, ALM 11.0, Informatica, Teradata, Putty, Sonic Management Console, Tortoise SVN, Stub - o - Matic, SQL Developer, Quality Centre 11.0, Rally, Winscp, HP Service Manager.
• Enforced the practice of the Automation Suite Versioning and its maintenance.
• Experienced in testing reports on various reporting tools like Cognos.
• Experienced in Automation Approach analysis, Process implementation, Designing Automation Framework according to Project needs, identifying the next steps in automation and guiding the team to implement the same.
• Experienced in preparation of Procedural Instruction Documents on script execution.
• Possess functional knowledge in multiple applications or client implementations sufficient to lead testing for cross-functional initiatives effecting those areas.
• Proficient in writing Test cases by using test case design technique.
• Experienced in Test Execution Process, Defect Life Cycle, and Test Plan.
• Detecting bugs & classifying them based on severity and priority.
• Flexibility in adapting various domains (Telecom, Health Insurance, property insurance, Retail) and roles (Tester, Test Analyst, QA, UAT, Developer, DBA) based on project requirements and Quick learner.
• Involved in Account level activities and acted as SPOC for IPMS activities.
• Completed all Project Management Competencies.
• Good Knowledge of white box testing(internal level analysis) and Black box testing(functionality)
• Smoke testing on critical or basic feature of an application. (major functions of software before carrying out formal testing)
• Functional testing on eachand every component of an application.
• Integration testing based on business transaction scenarios.(extension of unit testing)
• System testing whether end feature is working or not.(testing conducted on a complete integrated system to evaluate the system's compliance wif its specified requirements)
• Regression testing after fixing bugs and verified dat the fixes didn’t create problems elsewhere.
• Compatibility testing for different platform specifications.(evaluate the application's compatibility wif the computing)
• Usability testing whether application is user friendliness or not.
• Involved in Agile, Acceptance (if the requirements of a specification or contract are met) and Performance testing.
• Frequent Appreciations and recognition from Clients and managers.

PROFESSIONAL EXPERIENCE:

Confidential

ETL/QA Tester

Responsibilities:

• Worked wif both Onsite and Offshore teams.
• Performed data validation using SQL scripts and stored procedures.
• Responsible for ETL testing and Report testing wif huge data.
• Used HP ALM to writetestcases,maintaining the test repository, bug tracking and reporting.
• Written and executed test cases and test scenarios and collected evidences to support them.
• Dealt wif Dimensions and Fact tables in a Snowflake dimension model.
• Used SAP Business Object Data Services (SAP BODS) to run the jobs and monitoring jobs.
• Used Cognos to validate reports by running in Excel data/ CSV format.
• Making sure reports are generating as given in BRD and running queries in ETL and comparing wif reports.
• Providing signoff before going live wif all defects being closed.
• Testing initial data and incremental data.
• Tested incremental data wif SCD types, Type-1 and type -2.
• Used OLTP process and test daily incremental data.
• Comparing QA data/ Layout wif production reports.
• Comparing daily transactions incremental data wif application data like number of transactions made, Dates, Payments etc.
• Working on Functional, Regression, UAT testing.
• Test Estimation, Test Planning, Test Design, Test Execution, Defect Reporting, Tracking using JIRA andAzureDevOps.
• Used mocked data as well as production data for validations.
• Used Waterfall model.

Environment: SAP Data Services, Cognos, Azure, SQL server 2014, DB2, HP ALM, Web Application, Share Point, MS Excel, Microsoft Office, Internet Explorer7.0, WindowsNT4.0/2000, WinScp, Waterfall methodology.

Confidential

QA Engineer

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Experienced in QA Testing and front-end UI application testing
• Worked on Cloud Migration testing (AWS Services, EC2, S3)
• Experienced in dealing wif Diagnosis (Gap closure) and Claims data.
• Experienced in analyzing requirements and creating and executing test cases accordingly.
• Writing SQL Queries in MSSQL to validate data.
• Experienced in writing test scripts and automate them to execute on test cases.
• Automated testing to test web application using wield .
• Performing all kinds of data validations using positive and negative scenarios.
• Performed Integration testing, End-to-End testing and system testing
• Performed Functional Testing & Regression Testing
• Raised Non production defects and production defects using JIRA tool.
• Working experience wif defect tracking tools like Jira,AzureDevops, HP ALMandTFS (Team Foundation Server).
• Raised different levels of severity bugs and defects.
• Experienced in using configuration tables to control data.
• Performed App dev testing (web application)
• Experienced in using Jira tool for tracking purposes.
• Used Agile methodologies.
• Executing Stored procedures.
• Experienced in Creating tables,updating,inserting
• Used SSMS for running SQL scripts
• Experienced in creating and executing packages.

Environment: SSIS,.NET, SQL server 2014, DB2, Web Application, Rabbit MQ,Wield, Confluence, MS Excel, AWS, EC2,S3 Remedy, Microsoft Office, Azure, Internet Explorer7.0, WindowsNT4.0/2000, WinScp, Agile Methodology.

Confidential

QA Tester

Responsibilities:

• Involving in Functional Testing & Regression Testing
• Developing Automated Test Scripts to perform Functional Testing, Performance Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing, Regression Testing and Volume testing of the application using LoadRunner
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
• Experience assessing testing processes, creating and implementing testing strategies in UAT phase.
• Participate in diagnosis and de-bugging activities wif the development team. Utilize TFS/azure for all steps of the ongoing Software Testing Life Cycle (STLC). Maintain automation scripts in QA environment and assist UAT testing
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects
• Developed UNIX scripts to validate the flat files and to automate the manual test cases.
• Developing Test Matrix to give a better view of testing effort

Environment: Informatica, Teradata R15, SQL, Azure, DB2, Oracle, HP Quality Center, Rational Clear Case, Rational Clear Quest, Remedy, Microsoft Office, Internet Explorer7.0, WindowsNT4.0/2000, HP/Unix, Putty, WinScp.

Confidential

ETL/QA Tester

Responsibilities:

• Worked as part of ETL testing (Data warehouse testing).
• Worked as Teradata Tester for source (DB2, SYBASE, ORACLE, SQL Server) to target forklifting of data.
• Performing SOA web services Testing.
• Data grid validation (middleware data) and Analyzing Logs.
• Analysis of quality of Data.
• Used Informatica Powercenter Data Validation Option (DVO) tool to compare data sets together for testing and validation of Source and target data.
• Understanding the ETL workflows and preparing test cases and test plan accordingly.
• Creating and executing test cases and verifying test results on application using Informatica ETL tool.
• Coordinate wif the Customer on Issues / Queries and maintain Issue register up to date.
• Running through every mapping document to check if it meets the business requirement.
• Tested Source and Target data, Error handling techniques.
• Developed SQL queries executed and cross verified wif the Mapping Queries.
• Analysis of test results from the entire team on a daily basis.
• Prepared Metrics based on the test result from the team and shared wif the Customer every day.
• Tested on various environments including QA, INT, SOAK and UAT.
• Worked on Sprint releases as part of both waterfall and agile environment.
• Coordinated Onsite and offshore and created good visibility to client.
• Provided Requirement details, QDB metrix, Capacity planning, Scope commit and sprint/Release documentation and presented the same to the client Managers.

Environment: Oracle, DB2, Informatica, Parasoft 9.5, Putty, Winscp, ALM 11.0, TortoiseSVN, SQL Developer, JIRA

Confidential

ETL Tester

Responsibilities:

• Creation of stubs.
• Creation of Automation suite.
• Understanding functionalities of the various components.
• Performing SOA Web services Testing, Component level Testing, Functional and Non-functional Testing.
• Test cases and Test scenarios preparation.
• Optimizing test cases.
• Interacting wif the developers and troubleshooting the problems and Raising Defects.
• Monitoring DB and QA jobs.
• Automation of test cases for future and for future executions using SOAP UI.
• Usage of the testing tools like JMS Client, Sonic Systems, SOAP UI, Oracle DB, Jammy etc.

Environment: Putty, SOAP UI, JMS Test client, Jammy, Sonic Management Console, Oracle DB, Stub - o - Matic, Quality Centre 11.0, Case Runner tool

Confidential

ETL Tester

Responsibilities:

• Design, configuration and implementation of Databases both on cluster and non- cluster standalone system.
• Interacting wif the developers and troubleshooting the problems involved wif the stored procedures, triggers, data access, table structures, scalable queries, file groups and problems related to the privileges and user access credentials.
• Performance monitoring and troubleshooting databases using multiple tools including Performance Monitor, OEM etc.
• Designing, configuring and implementing backups which involve scheduling database backups to disk and recovery of the databases.
• Evaluates releases of SQL and its tools, and third party products to ensure dat the site is running the products dat are most appropriate and to ensure dat any new product usage or release upgrade takes place wif minimal impact.
• Implemented and enforced security for all SQL databases and will check whether desired standards are being maintained.
• Generating capacity planning and database performance report using various scripts and Disk utilization reports using custom scripts.
• Performance Tuning and Monitoring on various Database servers.

Environment: Microsoft SQL Server 2000/2005/2008, HP Service Manager, Putty, Winscp