EXPERIENCE SUMMARY:

• 9 years of experience in Software Quality Testing and Quality Assurance in teh technologies such as Data warehousing(ETL/BI) Testing, Big Data Testing and Web Services Testing
• International Software Testing Qualification Board (ISTQB) Certified Software Tester.
• Skilled in all aspects of Test Planning, Scenario and Test Case development, Test Execution, Defect Reporting and Tracking.
• Involved in various stages of Software Development Life Cycle (SDLC) implementing Waterfall, V - Model and Agile/Iteration/Scrum methodologies
• Experienced in Manual and Automation of Data Warehouse testing and Web Application testing.
• Expertise in preparing Master Test Strategy/Test Plan for testing projects.
• Experienced in writing Automation tests using Ruby.
• Design and execute features of ATDD (Acceptance Test Driven Development)/BDD using Cucumber and Ruby.
• Develop and configure testautomationframeworks and execute tests.
• Knowledge of Jenkins continuous integration (CI) tool.
• Experience in Pair Programming wif Developer/Tester interchanging teh roles during teh coding/testing.
• Knowledge of Data Warehousing concepts. Worked on Teradata, Oracle and NoSQL Marklogic databases.
• Good Experience in testing and working wif various Big Data technologies in Hadoop Ecosystem like HDFS, Apache HBase, Solr, Spark, Kakfa and Cloudera applications.
• Mentor team members around teh development of technical skills and practices.
• Involve in software design to guarantee adherence of test coverage for meeting end user requirements.
• Having excellent problem solving and analytical skills wif experience of processes throughout teh life cycle of a project from specification reviews through to user acceptance.
• Consistently demonstrated analytical skills in resolving issues or defects, often called upon to consult on problems that has eluded resolution by others.

TECHNICAL SKILLS:

Languages: Ruby, SQL, PL/SQL, XQuery, Unix

Database: NoSQL Marklogic, Teradata 14, Oracle (9i, 10g, 11g)

Big Data: HDFS, YARN, Cloudera Manager, Apache Hbase, Hadoop, Apache Solr, Kafka

ETL Tools: Teradata SQL Assistant, Informatica Power Center 9.5/9.6, Oracle SQL Developer, Oracle Data Integrator, OBIEE, Toad 11

Web Services: REST Client, SOAP UI, Postman, Advanced Rest Client

CI Tools: Hudson, Jenkins

FTP Tools: Win SCP, Putty, Pageant, PuttyGen

Utilities: Git hub, Gerrit, Jira, Confluence, HP ALM, SVN, HP Quality Center

Service skills: Data Warehousing, Business Intelligence, Test Automation

Business areas: Insurance, Retail

PROFESSIONAL EXPERIENCE

Automation Developer/Tester

Confidential, Columbus, Ohio

Contributions:

• Enhance Ruby test framework and developautomatedtests using Ruby TestAutomationTool
• Responsible to validate teh data in teh Hadoop ecosystem of Cloudera Data Hub where teh daily feeds are processed through Spark and stored in teh HDFS and HBase.
• Wrote Gherkin test scenarios to validate functionalities implemented across various big data technologies and develop automated tests using Ruby and Cucumber.
• Developed automated tests to compare source and target XML data in NoSQL Marklogic database using Ruby.
• Wrote XQuery to retrieve data for validating various business transformations of data.
• Implemented automated validation tests for real-time incremental big data streams while getting processed in teh hub.
• Developed Ruby tests for validating teh data on Apache Solr search engine generated.
• Executed Web Service testing to ensure accuracy of data transfer across interfaces.

Environment:vRuby, Cucumber, Gherkin, Apache Solr, Marklogic NoSQL Database, Apache Hbase, Cloudera Manager, HDFS, Apache Hadoop, XML, JSON, Xquery, Jenkins, Groovy, GitHub, Jira, Confluence, Postman.

Test Lead

Confidential, Columbus, Ohio

Responsibilities:

• Coordinated integration testing activities wif other data warehouse teams as Test Lead.
• Prepared Test Plan and coordinated wif Test Manager on Test strategy preparation.
• Led offshore teams on test execution activities.
• Developed Teradata SQL test scripts to validate data and do source and target data flow validations.
• Worked wif Business Analysts to define and design test scenarios and test data.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Prepared over all Test Plan/Strategy and Test Bed for teh Test environments.
• Worked on writing automated tests to validate data using RUBY in Agile development.
• Involved in highly collaborative work which includes Pair Programming wif Developer/Tester interchanging teh roles during teh coding/testing Test Driven Development.
• Involved in estimation of User Story cards (3 Amigos meeting) for development and testing and do teh review of teh test code once story card is done.
• Maintained and Monitored daily build runs on Continuous Integration Server Jenkins to make sure all tests are Green.
• Did Integration testing of teh applications data extracts using Ruby Automation tool/SOAP UI making Web Service SOAP calls which are sent to third party vendors as Flat Files, CSV, XML.
• Wrote and executed SQLs to do End to End System testing of teh data validation.
• Used Ruby Cucumber for writing Acceptance tests using Gherkin format which are easily understandable by business.

Environment: Teradata SQL Assistant, Informatica PowerCenter, RubyMine, Ruby, Cucumber, Gherkin, UNIX, SVN, HP QC, Putty, Jenkins, SOAP UI, Toad, CICS, ESP, Changeman, Pageant

Confidential

Sr. Test Analyst

Responsibilities:

• Was involved in teh project from requirements analysis phase, interacted wif customer as needed to get better understanding of reporting requirements and responsible for Planning of test execution based on priority of teh requirements for business.
• Involved in executing and monitoring teh ODI batch data processing through Appworx and verify data in target database.
• Updated teh corresponding metadata tables for batch dates, creation of partitions and other constraints to facilitate teh ODI batch to load data wifout errors.
• Tested teh relevant ODI Interfaces and procedures are loading teh data accurately wifout any data loss into error tables.
• Created data on Oracle Retail Management System (ORMS) and Oracle Retail Invoice Matching (OReIM) applications for Incremental Data testing.
• Generated BI reports through dashboards in Oracle Business Intelligence Enterprise Edition (OBIEE) and tested reports for drill down features and correctness of data.
• Performed Parallel Testing of Data load behavior wif ODI 10g and ODI 11g w.r.t functionality and data accuracy on two environments.
• Responsible for coordinating wif offshore team in timely closure of test prep and execution as per schedule.
• Coordinated wif Business Users during UAT and Hyper care test phases.

Environment: SQL Developer, SQL, PL/SQL, Oracle Data Integrator (ODI 10g and ODI 11g), OBIEEE, Appworx, WinSCP, MS Office

Confidential

Test Analyst

Responsibilities:

• Actively involved in System Testing events of GMACI CPS Testing which includes: Test Cases Preparation, Reviews, Test Case Execution, Defect Reporting (logging) and Defect Tracking.
• Responsible for understanding, developing and executing complex test scenarios.
• Has done Peer Reviews.
• Reported defects and participated in Development Team (Triage) on conflicting issues.
• Studied teh various types of data elements that teh front end utilized and developed realistic test data, ensuring that testing would be autantic and comprehensive.
• Wrote SQL statements to retrieve data from back-end to verify Test Results according to data entry in front end.
• Prepared execution test-flow documents (screen navigations) for teh critical functionalities ahead of teh schedule to ease teh execution process of team.
• Gave live meetings for explaining/reproduce teh execution issues to Onsite Team/ Dev Team/ Client. Maintained TEMPeffective coordination between Development Team and Testing Team.
• Worked in Onsite Client Confidential (United Kingdom) to support UAT and Go-Live activities.
• Conducted training session, mentoring, and troubleshooting for Peers and newly joined members into teh project.

Environment: Mercury Quality Center, SVN, SQL Developer, Text Pad, WinSCP, MS Office

Confidential

Project Engineer

Responsibilities:

• Involved in Integration and Functional Testing events of Farmers (EBPP) testing which includes: Test Cases Preparation, Reviews, Test case execution, Defect Reporting (logging) and Defect Tracking.
• Actively involved in test cases preparation which involves communication wif onsite contacts, Dev Team to get adequate knowledge/information about teh requirements.
• Participated in both Internal and External reviews meetings (wif client).
• Utilized QC TEMPeffectively in not only raising defect but also to monitor defects to get overall idea of teh application behavior.
• Was actively participated in Triage meetings to resolves teh issues, Communication gaps and understanding of teh requirements raise as a part of defect in QC.
• Has taken additional responsibilities includes contacting wif onsite on any open issues or clarification on work related, sending and reporting status to Onsite and Offshore PM.
• Has submitted a testing white paper to Wipro KM Repository wif teh knowledge acquired in dis project wif Title - ‘Basics of Electronic Bill Presentment and Payment'.

Environment: SAP FS-CD Functional, Mainframes, Mercury Quality Center, BEA Aqua Logic-XML, MS Office