SUMMARY

• 11 years of work experiencein IT in the roles of ETL Test Lead / Sr. Software Test Engineer of Client - Server Technology, Web applications, and Data warehousing/ Business Intelligence.
• Expertise in Manual Testing, Automation Testing, Hadoop Testing, ETL Testing, Database Testing and Webservices Testing.
• Expertise in Automation Testing using tools Selenium, HP UFT/QTP, Silk and MTM.
• Expertise in ETL testing by using the tools Informatica, SSIS, Datastage and Abnitio.
• Expertise in Report testing using the tools Cognos, Qlikview, SSRS and Tableau.
• Expertise in VB and Java scripting.
• Expertise in testing applications built on .Net, Java and Mainframe technologies.
• Proficient on Automation tools like Selenium WebDriver (Functional & Regression Testing), TestNG, Junit, ANT, Maven, Jenkins and SOAP UI Pro for testing Web based Applications.
• Sound knowledge on Object Oriented Programming (OOP) concepts. Extensively used Java for test case automation.
• Expertise in building Keyword driven, Data driven and Hybrid driven frameworks using Selenium WebDriver.
• Hands on experience in Page Object Model design pattern using Selenium WebDriver.
• Experienced in designing test scripts with Selenium WebDriver using TestNG framework.
• Expertise in performance testing using Loadrunner
• Experience in implementing SDLC methodologies including waterfall, v-model and agile methodology.
• Expertise with Black box Test design Techniques like Boundary value analysis, Equivalence partitioning, Decision Table Testing, State transition Testing and Error guessing techniques, Smoke, Functional, Regression, Beta testing, Database and Integration testing.
• In depth understanding/knowledge ofHadoopArchitecture and various components such as HDFS, JobTracker, TaskTracker, NameNode, DataNode. Experience on data imports and exports from relational database to Hadoop and vice versa.
• Experience on debugging and testing MapReduce code.
• Experience on testing data processing in Bigdata technologies of HDFS, Hbase, Pig, Hive OOZIE & Spark.
• Experience on NOSQL Databases of Hbase and Mango DB
• Experience in working with Multiple Relational Databases Teradata, Oracle, SQL Server, DB2, MS Access, XML and Flat Files.
• Expertise in validating the data by writing SQL queries and using Informatica DVO
• Expertise in designing and developing test strategy, test plan, test cases and generating test reports, defect reports.
• Expertise in Problem solving and Bug Reports using Defect Tracking Tools like Quality Center/ALM, JIRA, and Rational Clear Quest.
• Possess business knowledge on Finance, Energy, Insurance, Industrial Products, Biometric, Healthcare and Retail.
• Experience with GAP Analysis to analysis enterprise data.
• Expertise in performing the e2e testing, preparing the positive and negative test scenarios.
• Experience on Testing web application servers Apache Tomcat and MS IIS
• In depth understanding the functionality of AWS and Netflix OSS

TECHNICAL SKILLS

Big Data: Hadoop, Map Reduce, Hive, HBase, Sqoop, Pig, Zookeeper, Flume and Spark

Testing Tools: QTP, MTM, VSTS, Selenium, QC, Clear Quest and Jira

ETL Tools: Informatica, Datastage and SSIS

Database: Teradata, Oracle, SQL Server and DB2

OS: UNIX, Windows

Programming: Cobol, JCL, Core Java, C#, VB and Scala

Reporting Tools: Qlikview, Spotfire, Tableau, Cognosand SSRS

PROFESSIONAL EXPERIENCE

Confidential, Stamford, CT

Test Lead

Responsibilities:

• Preparing detailed test plan, test scripts and test cases by understanding the business logic and user requirements.
• Analyzing transformation rules, rating the complexities and preparing the estimations.
• Understanding the data nature from different OLTP systems and testing the insertion processes for HDFS
• Testing the data models in Hive, Pig and Hbase.
• Creating and debugging the UDF’s written in Java and integrating with Hive.
• Validation of Hive, Hbase schemas in cluster environment.
• Verified standalone non-mapreduce Java jobs that run on a Hadoop cluster to ensure that all the work must be platform portable across clusters
• Working with data management team and BA team for managing the test data creation from various source systems and escalating any issues to Management.
• Writing the SQL queries for backend testing and validated database, comparing the Data.
• Expertise testing the application on data driven testing to test the application functionality on UI.
• Written test cases for positive and negative test scenarios.
• Performed smoke, functional, integration, E2E and regression testing.
• Reported the defect in QC and interacted with the Development team to resolving the issues.

Confidential, NY

Test Lead

Responsibilities:

• Preparing detailed test plan, test scripts and test cases by understanding the business logic and user requirements.
• Analyzing transformation rules, rating the complexities and preparing the estimations.
• Understanding the data nature from different OLTP systems and testing the insertion processes for HDFSUsing Informatica 9.6 and Sqoop.
• Testing the data models in Hive, Pig and Hbase.
• Creating and debugging the UDF’s written in Java and integrating with Hive.
• Validation of Hive, Hbase schemas in cluster environment.
• Verified standalone non-mapreduce Java jobs that run on a Hadoop cluster to ensure that all the work must be platform portable across clusters
• Working with data management team and BA team for managing the test data creation from various source systems and escalating any issues to Management.
• Writing the SQL queries for backend testing and validated database, comparing the Data.
• Setup the Automation framework using Selenium WebDriver to run test cases in multiple browsers and platforms.
• Developed custom libraries for automation using JAVA & Selenium WebDriver.
• Involved in design and implementation of Selenium WebDriver automation framework for smoke and regression test suites (TestNG)
• Developed Automation framework using Selenium WebDriver (Java) and Test Execution using TestNG.
• Responsible for implementation of Hybrid Test Automation Framework build using Selenium WebDriver, TestNG and Maven technologies under Java platform utilizing industry leading harness design patterns and approaches.
• Handling the team and assigning testing responsibilities and follow up till test completion and reporting the status to Project Manager. Responsible for updating the weekly reports.
• Strong experience creating concise and clear reports for distribution and presentation to senior management on a weekly basis. Experience monitoring and tracking implementation plans.
• Expertise testing the application on data driven testing to test the application functionality on UI.
• Written test cases for positive and negative test scenarios.
• Performed smoke, functional, integration, E2E and regression testing.
• Reported the defect in QC and interacted with the Development team to resolving the issues.

Environment: /Tools: Informatica, Selenium, Hadoop, MapReduce, Hive, HBase, Sqoop, Pig, Zookeeper, Qlikview and Cognos.

Confidential, Houston TX

Test Lead

Responsibilities:

• Preparing detailed test plan, test scripts and test cases by understanding the business logic and user requirements.
• Pointing to the data sources and performing the data mining operations to understand the nature of the data.
• Analyzing transformation rules, rating the complexities and preparing the estimations.
• Preparing and executing E2E, Integration, functional, smoke test cases. Writing SQL queries for data validation.
• Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation.
• Improving specification and design documents through active review and feedback with developers.
• Integration of data across various sources in an ETL process, versioning, manual correction of tables, address correction.
• Monitoring execution of workflows, preparing the root cause analysis report by analyzing the data and logs if any failure.
• Writing the manual and data validation test cases to validate the reports in spotfire.
• Identify the feasible test cases to automate and preparing the automation frame work. (Keyword& Data driven)
• Automating the test scripts by using C# in VSTS.
• Executing the test scripts in batch mode and analyzing the results, if any failures identifying the root cause.
• Handling the team and assigning testing responsibilities and follow up till test completion and reporting the status to Project Manager. Responsible for updating the weekly reports.
• Preparing the Requirement traceability matrix in Quality Center and sending to project manager.
• Involving the defect triage meetings to discuss on defect complexity and priorities.

Environment: & Tools: SSIS, C#, MTM, VSTS, TFS, Tibco Spotfire, and SQL Server

Confidential, Seattle WA

Sr. Test Engineer

Responsibilities:

• Responsible for Creation of Test Plan and Test Estimations.
• Understanding the Business Requirements or Transformation Rules.
• Creation of Test Cases i.e. SQL Queries as per the Transformation Rules to evaluate the data.
• Execution of Source and Target Test Cases (SQL Queries) to test the workflows and to ensure the data Is Transfer as per the requirements is not.
• Performing the Daily, Backfill, Sanity(Duplicate checks, Null checks) Testing
• Performing the Root Cause Analysis Report if any failure occurs.
• Monitoring the data flows (workflows) in Informatica workflow monitor, if any failure occurs or if any records are rejects providing the initial analysis report
• Creating the Report Testing and Cube Test Cases (SQL Queries) as per the Business Rules
• Generating the Reports in the Cognos Reporting Toole.
• Execution of Report Test Cases and comparing Results with the Reporting Results to evaluate the data.
• Involved in Team Management activities and communicating with the clients.

Environment: & Tools: Informatica, Cognos, DB2, CQ

Confidential, Houston TX

Sr. QA Engineer

Responsibilities:

• Designing and Implementing the Automation frame work Approach.
• Responsible for design of test plan, test scenario and test cases.
• Identify the scope of automated testing and test cases eligible for automation.
• Develop, integrate and maintain Automation Test Suite.
• Responsible for maintain the inc declarations and changes.
• Documentation of technical aspects of Test Automation.
• Responsible for the preparing the automation builds.
• Execution of automated test suite on regular basis to perform the regression testing of the application
• Analysis of automation test results and bug reporting Issues using CQ.
• Effectively communicate issues in a written format, providing clear and concise information necessary to reproduce and explain the problem to developers to resolve issues.

Environment: & Tools: Silk Test,4GL and JIRA

Confidential, NY

Sr. QA Engineer

Responsibilities:

• Created Test Plans as per Functional and Business requirement.
• Responsible for performing Smoke testing, Integration testing, and system testing, Database Testing and user acceptance testing.
• Designed and executed test cases and verified actual results against expected results.
• Creation and restoring of the Database.
• Retrieved data from Database by writing SQL queries to check the correctness of data and to verify that data is coming from a correct table.
• Frequent status checks meetings with the Team.
• Prepare and deliver weekly status reports.
• Prepared test data for positive and negative test scenarios for functional testing
• Participated in the bug reviews and client meetings.
• Involved in regression testing after each build release of the application.
• Followed up development team for defect resolution.

Environment: & Tools: QTP, Oracle, JIRA, Tomcat Server, Hibernate 2.0/3.0, Spring, JSF, Servlets 2.5, XML, JavaScript, HTML, CVS, Log4J

Confidential, NJ

Sr. QA Engineer

Responsibilities:

• Created Test Plans as per Functional and Business requirement.
• Responsible for performing Smoke testing, Integration testing, and system testing and user acceptance testing.
• Designed and executed test cases and verified actual results against expected results.
• Performed both manual and automated testing of the Application.
• Creation and Restoring of the Database.
• Retrieved data from Database by writing SQL queries to check the correctness of data and to
• Verify that data is coming from a correct table.
• Frequent status checks meetings with the Team.
• Prepare and deliver weekly status reports.
• Prepared test data for positive and negative test scenarios for functional testing
• Participated in the bug reviews and client meetings.
• Involved in regression testing after each build release of the application.

Environment: & Tools: Windows 2003, Ajax, .Net 2.0 and SQL Server, Load runner

Confidential

Sr. QA Engineer

Responsibilities:

• Created Test Plans as per Functional and Business requirement.
• Responsible for performing Smoke testing, Integration testing, and system testing. Participating user acceptance testing.
• Designed and executed test cases and verified actual results against expected results.
• Performed both manual and automated testing of the Application.
• Retrieved data from Database by writing SQL queries to check the correctness of data and to Verify that data is coming from a correct table.
• Frequent status checks meetings with the Team.
• Prepare and deliver weekly status reports.
• Prepared test data for positive and negative test scenarios for functional testing
• Participated in the bug reviews and client meetings.
• Involved in regression testing after each build release of the application.
• Followed up development team for defect resolution.

Environment: & Tools: .Net, SharePoint, SQL Server, VSTS, TFS

Confidential

QA Engineer

Responsibilities:

• Identify the scope of automated testing and test cases eligible for automation
• Develop, integrate and maintain Automation Test Suite
• Designing and adding recovery scenarios to the automation framework for break-free execution of Automated Test Suite
• Attend the regular client call and discuss weekly status with client

Environment: & Tools: VB.Net, ASP.NET, SQL Server 2000, SQL Reporting Services

Confidential

QA Engineer

Responsibilities:

• Designed Test cases for New Enhancements to test the application based on the test requirements
• Creation of Test Machines on 14 localizations
• Deploying the build and doing the smoke testing
• Performed Smoke Testing, System Testing, Installation Testing, Functional Testing
• Created Different Scenarios and Tested the Performance of PMS.
• Reported the Incidents (Defects) Effetely Using Sydney Helpdesk

Environment: & Tools: ASP.Net, MS Server 2000, Confidential Operating Systems (Six Localized installations)Norton Ghost Utility, VMware, Sydney Helpdesk