SUMMARY

• Having 12 years of professional experience in IT industry with emphasis on Development, Manual Testing and Automation Testing.
• Solid Expertise in BI Testing (ETL Testing, Cube Testing and Report Testing), Functional Testing and Integration Testing.
• 10 years of experience in (BI Testing, ETL Testing, Reports Testing, Performance testing and automation testing), 2 years of experience in Reports Development using Crystal reports, SSRS and reports integration to web application developed in ASP.Net and C#. Net environments.
• Around 48 months of experience in working as QA Lead.
• Have good experience in record and playback the test cases using VSTS 2010 Coded UI.
• Extensive experience in Quality Assurance using Functional Testing, System Testing including Integration, Performance, Stress, Load and Regression Testing of Web and Client/Server based applications.
• Experienced in Environment setup, Requirement Gathering, Test Planning, Test Cases, Test Data Setup, Manual and Automation Testing, Defect Tracking and Project Coordination.
• Have Good Knowledge in Data ware housing Concepts, star, snow flake schemas and OOPS Concepts.
• Good Experience in methodologies Agile/Scrum and Waterfall.
• Have very good knowledge in writing SQL scripts in SQL server, PostgreSQL, MySQL, Teradata.
• Have good knowledge in automation testing using Coded UI, Selenium Web Driver.
• Done Performance testing of web applications using VSTS 2010.
• Experience in testing applications in Healthcare and Law sectors.
• Have knowledge on Teradata concepts and architecture.
• Working knowledge of Agile/Scrum and Waterfall development models as part of Quality Assurance team in various projects and also created test cases based on black box and use case testing methodologies.
• Extensively worked on Windows Azure and Windows Service bus.
• Good experience on SOAP UI Web Services, RESTful Web Services.
• Have knowledge on HP ALM (Application Life Management) and HP quality center.
• Good Experience in bug tracking, Root cause analysis and Defect Prevention activities.
• Good experience in working with versioning tools VSS, TFS, GITHUB and SVN.
• Have knowledge in doing migration from DTS 2000 to SSIS 2008.
• Extensively used Bug tracking tools TFS, Mantis, JIRA and Rally.
• Good Knowledge on PyUnit Frameworks, HTMLTestRunner which is useful to generate reports nicely.
• Good experience in creating Requirements Traceability Matrix (RTM).
• Developed crystal reports and SSRS Reports and Integrated to web application which was developed in ASP. Net and C#.Net.
• Developed ETL Packages using SSIS (SQL Server Integration Services) 2008 and done Cube testing which are developed in SSAS (SQL Server Analysis Services) 2008.
• Good Experience in Testing ETL Packages which are developed in Talend and Informatica.
• Excellent Interpersonal skills, Communication skills, Documentation Skills, problem solving ability, Analytical and Programming skills in High speed, Quality conscious and Multitasked environment.

TECHNICAL SKILLS

Operating Systems: Windows XP/2000/NT, CentOS(Unix Flavor)

Languages: C, C++, C#.Net and ASP.Net, Python 2.7, 3.4

Databases: SQL Server 2005/2008, MySQL 5.5,PostgreSQL 9.2, Teradata 15.10IDE: Microsoft Visual Studio, Business Intelligence Development Studio 2008, PyCharm, WinSQL, TOAD, SQL Developer

ETL Tool(s): SQL Server Integration Services 2008,Snap Logic, Talend, Informatica 10.2

Reporting Tools: SQL Server Reporting tools, Crystal Reports

Analytic Services: SQL Server Analysis Services

Defect Tracking Tools: Mantis, TFS, JIRA, MTM, HP ALM

Query Languages: T - SQL, PL/SQL

Version tools: VSS,TFS 2010,GIT HUB, SVN

Performance/Automation tool: VSTS 2010, Selenium Web driver, Coded UI, SoapUI, Selenium

PROFESSIONAL EXPERIENCE

Confidential

Lead Test Engineer

Environment: Abinitio, Files, Postgres, JIRA, Oracle, Google Cloud Storage (Big query)

Responsibilities:

• Being an individual contributor from quality assurance team.
• Responsible for analyzing the requirements and creating test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Involved in spring grooming sessions to understand the requirements better.
• Validating the counts and data from source to target tables after successful job completion by connecting to different databases Oracle and Postgres.
• Comparing the data between source (.dat file) and target table.
• Validated the data between different layers by validating the applied transformations are correct and as per the requirement.
• Worked on storing the data in google cloud and querying the data in big query.
• Raising risks at the initial stage(s) of the sprint.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with developers and business analyst for understating mappings and involved in review sessions.
• Providing the timely Status to the stakeholders and management and instill confidence about the work being done.
• Automated the process to load the test data in QA environment for the testing purpose.
• Making sure that we have the data available in appropriate tables to start QA activities.
• Involving in the team decisions to decide the load type of the table and giving the inputs for the meeting.
• Giving demos to the business on the work being done in the last sprint.
• Worked closely with end user to understand the requirements and the issues.
• Validating the data once the stories are deployed to production.
• Supporting Production deployment team for all the deployments and worked on the issues on high priority during deployment stage.
• Worked on JIRA to track the issues/ tickets raised by end user team.

Confidential, Charlotte, NC

Lead Test Engineer

Environment: Informatica 10.2.0, Teradata 15.10, WinSQL, TOAD, SVN, HP ALM, Oracle, Informix, Selenium Webdriver, Perfaware, One Automation, SQL Server

Responsibilities:

• Responsible for analyzing the requirements and creating test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Validating the counts and data from source to target tables after successful job completion by connecting to different databases Oracle, SQL Server, Informix and Teradata.
• Comparing the data between source and .dat file created by Informatica.
• Validated the data between different layers by validating the applied transformations are correct and as per the mapping document.
• Executing the jobs using One Automation scheduler by scheduling the jobs as production and monitoring the test execution.
• Monitoring Informatica jobs execution and modify the mapping and workflows to set the correct delimiter and assign the correct environment variable. Creating the ODBC connections and assign the connection string to workflows.
• Automated the SQL scripts using shell scripts.
• Giving the head ups at the initial stage in case there any risks are foreseen.
• Monitoring the test progress during the testing cycle by constantly assessing the work assignment to each of the resources and re-balance or reallocate them as required.
• Worked extensively on SOAP UI web services.
• Extensively worked with flat files.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with developers and business analyst for understating mappings and involved in mapping review sessions.
• Automated the test scripts using Selenium Webdriver.
• Communicating if there are any delays in achieving the schedule and hold discussions with the team to figure it out the issue.
• Providing the timely Status to the stakeholders and management and instill confidence about the work being done.
• Making sure that we have the data available in appropriate tables to start QA activities.
• Analyzing requirements and assisting offshore team about the tasks.
• Involving in the team decisions to decide the load type of the table and giving the inputs for the meeting.
• Worked closely with end user to understand the requirements and the issues.
• Supporting Production deployment team for all the deployments and worked on the issues on high priority during deployment stage.
• Worked on JIRA to track the issues/ tickets raised by end user team.

Confidential

Data Quality Analyst

Environment: Netezza, SQL Server, Query Surge, FileZilla, Aqua Data Studio 17.0.3, JIRA, TIDAL, Talend

Responsibilities:

• Responsible for analyzing the requirements and creating test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Validating the counts and data from source to target tables after successful job completion by connecting to different databases Netezza and SQL Server.
• Comparing the data between Old and New systems using Query Surge tool by implementing the logic developed.
• Executing the jobs using TIDAL scheduler by scheduling the jobs as production and monitoring the test execution.
• Compare the data with source flat file (get the source file from remote location using FileZilla) in case of any discrepancies found between the OLD and New Systems.
• Giving the head ups at the initial stage in case there any risks are foreseen.
• Monitoring the test progress during the testing cycle by constantly assessing the work assignment to each of the resources and re-balance or reallocate them as required.
• Extensively worked with flat files and excel sheet data sources.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts.
• Communicating if there are any delays in achieving the schedule and hold discussions with the team to figure it out the issue.
• Providing the timely Status to the stakeholders and management and instill confidence about the work being done.
• Understanding the Business Requirements and system design.
• Performing exhaustive functional testing and regression testing.
• Making sure that we have test data available in appropriate tables to start QA activities.
• Analyzing requirements and assisting offshore team about the tasks.
• Involving in the team decisions to decide the load type of the table and giving the inputs for the meeting.
• Executing the test Cases developed in Test Plan and performing Adhoc testing.
• Working in Agile Methodology and using JIRA to log the hours, updating the task status, creating new sprints and maintain the backlog.
• Working closely with Development team and Business Requirements team to get the clarification on the business requirements.

Confidential

ETL QA Lead

Environment: Info sphere Data replicator, Rally, WinSQL, SVN, SQL Server, SSIS, HP ALM, Oracle, Informix, Perfaware, TIDAL

Responsibilities:

• Responsible for analyzing the requirements and creating test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Giving the head ups at the initial stage in case there any risks are foreseen.
• Communicating if there are any delays in achieving the schedule and hold discussions with the team to figure it out the issue.
• Monitoring the test progress during the testing cycle by constantly assessing the work assignment to each of the resources and re-balance or reallocate them as required.
• Communicating with database modeling team to migrate the objects from DEV to QA environment.
• Assigning the tasks to offshore team and knowledge transfer to the offshore team about tasks and implementation.
• Providing the timely Status to the stakeholders and management and instill confidence about the work being done.
• Providing the valuable inputs while designing the table by doing data profiling activities for various sources.
• Creating Data Model Request for new tables to be created as per the business requirement and communicating with data modeler for any changes required.
• Estimating QA tasks for the sprints and participating in sprint planning meetings.
• Involving in different ceremonies of sprint (Sprint Planning, Refinement sessions, Technology Stakeholder meetings, etc.,) and giving inputs from Quality Assurance team.
• Understanding the Business Requirements and system design.
• Communicating with vendors on issues about Info sphere tool and providing them the inputs /data required to resolve the issues.
• Responsible for creating the subscriptions in Info sphere Data Replicator tool and validate them in QA post creation as per the requirements.
• Responsible for deploying SSIS ETL package in QA Environment and Validation. Making sure the build is proper by doing Sanity Testing.
• Migrating the TIDAL jobs from Dev Environment to QA environment and validating the jobs post migration.
• Monitoring the data load to Stage tables from source through IBM Info sphere as part of ETL Process and validating it against the source.
• Executing SSIS job through TIDAL window and monitor it through Standard Reports under Integration service Catalogs.
• Responsible for going back to previous version of the ETL job post unsuccessful job run.
• Validating the counts and data from source to stage tables after successful job completion by connecting to different sources Oracle, DB2, Informix.
• Executing the jobs using TIDAL scheduler by scheduling the jobs as production and monitoring the test execution.
• Performing exhaustive functional testing and regression testing.
• Making sure that we have test data available in appropriate tables to start QA activities.
• Analyzing requirements and assisting offshore team about the tasks.
• Involving in the team decisions to decide the load type of the table and giving the inputs for the meeting.
• Preparing ETL Test Scripts using STM (Source to Target Mapping) document and DM (Database Model) document.
• Start QA validations using RM (Release Manual) and report bugs if anything is missing.
• Executing the test Cases developed in Test Plan and performing Adhoc testing.
• Writing complex incremental load test scenarios and giving walk through to the whole team.
• Attending peer review meetings to get the test plan reviewed and giving the inputs while others are giving.
• Working in Agile Methodology and using RALLY tool (Agile Development Software) to log the hours, updating the task status, creating new sprints and maintain the product backlog.
• Making sure that no data loss during the ETL data load process.
• Identified Test Scripts which can be automated and used Perfaware automation tool developed by Infosys as per the requirements and feasibility.
• Using SVN (Sub-versioning) as Versioning control and documents Repository.
• Working closely with Development team and Business Requirements team.
• Playing Scrum master role in the absence of scrum master and assisting the team if require any details on QA activities.
• Performing Integration, End-to-End, system testing.
• Used JIRA for application life cycle and test management.
• Using HP ALM for requirements management and defect management.
• Supporting prod-ops team for QA to Prod migration activities and post migration activities.
• Walking through the Release Manual for Prod Ops team for migrating the objects from QA environment to production environment.
• Monitoring the ETL jobs execution in production for couple of days post deployment and supporting Prod ops team if any assistance required.

Confidential, Seattle, WA

Senior ETL Test Engineer

Environment: Python, Talend, JIRA, Cassandra, PostgreSQL 9.2, CentOS (Unix Flavor), GITHUB, Selenium Wed Driver

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Understanding the system architecture and design.
• Analyzing requirements and creating and executing test cases.
• Prepared ETL Test Scripts using STM document and Done ETL process testing using Talend ETL tool.
• Executed the test Cases developed in excel and Adhoc testing.
• Written Data validation test scripts based on requirements.
• Involved in Functional Testing & Regression Testing.
• Used PyUnit Framework and HTMLTestRunner extension to generate nicely formatted reports.
• Implemented Database connection methods using Psycopg extensions for PostgreSQL.
• Worked on Scrum Methodology.
• Making sure that no data loss during the ETL data load process.
• Verified the Data base schema against the Source to Target Specification document.
• Developed 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.
• Identified Test Scripts which can be automated.
• Used PyCharm IDE to write automation test scripts using Python and Selenium Web Driver.
• Written ETL test scripts using STM (Source to Target) document for Data loading requirements where source is PostgreSQL and target is PostgreSQL.
• Used GITHUB as Versioning control and documents Repository.
• Worked on CentOS(Unix Flavor) for application testing, ETL Testing,
• Interacted with Development team, Manager and Business Requirements team.
• Performed Integration, End-to-End, system testing.
• Developed Automated Test Scripts to perform Data validation testing using Selenium and Python Programming Language.
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews.
• Performed data validation testing writing SQL queries.
• Used JIRA for application life cycle and test management and assisted the team on PostgreSQL.

Confidential

Senior Test Engineer

Environment: C# 4.0, WPF 4.0, WCF 4.0, Silverlight, SQL server 2008, SQL Server 2012, Windows Azure, VSTS 2010

Responsibilities:

• Analyzed the System Requirements and developed detailed Test Plans and Test Cases and provided the documentation.
• Understanding the system architecture and design.
• Developed Performance Test scripts using SQL and executed in SQL server 2008 to get the base time the application is consuming to execute 5000 employee.
• Validating the business rules during testing phase and delivering the product as per the requirement specification document.
• Done Performance Testing using DB scripts written in SQL Server and executed in both SQL server 2008 and SQL server 2012 to compare the results to improve the performance.
• Collecting Performance Counters which are generating from Sql scripts and creating test results reports from the counters.
• Done Ad hoc testing to break the system.
• Designed Manual testing strategy and performed Manual Testing of some of the modules/components of the application as per the requirements.
• Identified Performance tuning scenarios and developed Performance test scripts using VSTS2010.
• Involved in estimation and preparing the Test Plans.
• Environment set up for performance testing in physical systems and Windows Azure.
• Created Data Driven Automated Frameworks using Coded UI in Visual Studio Test Suite 2010.
• Created Traceability Matrix in Excel using requirements given by product owner in TFS 2010 and creating test suites in Microsoft Test Manager (MTM).
• Tested SOAP UI web services.
• Extensively used Load Testing and Performance testing features in VSTS for conducting Load and Stress testing.
• Collected Performance counters from VSTS performance testing and generated reports out of the test results and shared to the client.
• Reviewing the test cases created by the team members.
• Extensively used In-Memory and windows service Bus concepts in the project to improve the performance.
• Performed manual testing of web application developed in silver light.
• Identified .Net memory leak issues and resolved Leak issues in Portal applications.
• Interacted with developers, users and various members of the team to discuss issues, resolve defects and set priorities.
• Working in Agile methodologies and Used HP Quality Center for requirements management and test management.
• Prepared and participated in status meetings, conducted walkthroughs, documented proceedings.
• Used SQL Developer and Toad for some of the SQL activities.
• Assisted the team on Performance Testing using VSTS 2010.
• Reported the defects in the TFS 2010 and coordinated with the developers for defect tracking and resolution.