Etl/database Tester Resume
Leesburg, VA
SUMMARY
- Software Test Engineer with around 8 years of diverse experience in Software Development Life Cycle (SDLC) in Requirements gathering, Analysis, Design, Documentation, Development, Testing (Manual and automation) using Agile Scrum and Waterfall methodologies.
- Over 6 years of Extensive experience in Software Testing, Quality Assurance of commercial applications using automation tools and manual testing.
- 2 years of experience in coding and testing business rules management system using ILOG’s JRules.
- Over 1 years of web application development and testing using ASP.NET/MVC.
- Performed automation testing using Selenium IDE, WebDriver and Unit Testing using TestNG and JUnit.
- Highly proficient in working with Manual Testing as well as Automated Testing using Mercury Interactive
- Strong skills in writing SQL Queries for backend testing and Data warehouse/ETL testing using Informatica.
- Web Services testing for Rest API using JMeter & PostMan, Soap based XML testing using SoapUI.
- Good exposure testing XML documents using XPath, Xquery, XSD for validation XML documents.
- Able to effectively communicate with wide range of clients and coworkers.
- Good team player, self - starter, Proactive, quick learner with ability to work independently in time sensitive environment.
TECHNICAL SKILLS
Languages: ASP.NET, ADO.NET, C#, VB.NET, Java
Web Technologies: HTML5, XML, XSD, XQuery, Xpath, JavaScript, CSS3, JQuery
Databases /ETL: Oracle, SQL Server 2008/12, Informatica, MS-Access
Operating Systems: Windows, Ubuntu Linux, Mac, UNIX.
Automation Tools: Selenium IDE, Selenium WebDriver, TestNG, Junit, QTP, Winrunner.
Load/Performance Tools: Visual Studio Test Suite, Load Runner.
Test Management/Bug: Tracking Quality Center/ALM, JIRA, Assembla, Test Director.
Web services/: SOA Testing RestAPI, JMeter, PostMan, Chrome Developer Tool, FireBug, SOAP, WSDL
Version Control Visual: Source Safe 6.0, TFS.
Application: Server Web logic 8.1 server.
Business: Rules Engine ILOG-JRules
IDE: JDeveloper 10g, Visual Studio 2013/10 Test Suite, Eclipse,Notepad++, XMLSpy
PROFESSIONAL EXPERIENCE
Confidential, Leesburg VA
ETL/Database Tester
Responsibilities:
- Data testinginvolving comparingdaily automated feedsfrom multiple websites.
- PerformData Structure, data validation, ETL testing using Informatica, SQL Queries.
- Verified data content in target database matches source system using data mapping
- Validated External and user internal report against various tables and data structures.
- Identify duplicatedatabetween multiple sites and report them.
- Tested out of market autos are still displayed by analyzing archive tables weekly.
- Tested forbrowser compatibilityin Chrome, Safari, Firefox and Internet Explorer.
- Testeddevice compatibilityand responsiveness(by width) for phones/tablets, like iPad, iPhone, android and windows devices, nook, kindle
- Tested for duplicate autos in a given zip code and verified its relevance by distance.
- Tested teh UI functionalitykeyword search and search filters by year, price, distance by zipcode filter and reported bugs in JIRA.
- Performed RestAPI webservices testing for JSON/XML using JMeter, PostMan, Chrome Dev tools and FireBug.
- Designed and developed detailed test procedure specifications under Agile/scrum framework based on Stand-up Meetings and Scrum Meetings.
- Used chrome developer tools to identify and extract XPath and used for Selenium scripts/ Rest API testing.
- XML data feeds were validated with XSD using Notepad++/XMLSpy and reported issues.
- Worked on querying XML data types in SQL tables using XQuery.
- Performed Web testing and Load testing using webpagetest.org and Visual Studio 2013 Test Suite.
Environment:Selenium WebDriver, ETL(Informatica) TestNG, JUnit, QTP, ASP.NET/MVC, XML,Notepad++,XSD, XPath, Xquery, XML Spy, JIRA, Quality Center/ALM,, RestAPI, JMeter, PostMan, Chrome Developer Tools, Firebug, WebPageTest, SQL Server 2012/08/05,Jquery, Visual Studio Test Suite.
Confidential, Chantilly VA
Software QA Analyst
Responsibilities:
- Tested landing pages, data uploads needed to support business, podcasts, 3rd party implementations, new courses.
- Participated in daily scrum/ agile planning for status updates and estimation and worked with teams across teh organization (Front end, Backend, ERP, Business, End users) to support business.
- Performed regression and automation testing using Selenium IDE, webdriver and Junit.
- Worked with mobile apps team for testing UI and RestAPI functionalities used by Android and Apple devices.
- Did Integration testing using tealium, split testing, STO for sales tax calculations needed for ecommerce checkout and Integrated Bazzarvoice rating and review, question and answers features on websites.
- Tested download section that uses Akamai download manager for course downloads.
- Tested Brightcove players used for audio and video streaming needed for websites and apps
- Tested Restful web services that are consumed by external vendors like Verascape to search against ERP Microsoft Dynamics database.
- Reported bugs in Assembla for projects involving teams across companies and offshore teams.
- XML files were validated and tested using Notepad++ and worked with XML data in SQL tables.
- Tested Rest APIs(Get and Post) methods to support Android and Apple mobile apps using Xpath, JMeter & PostMan.
- Tested Chase Orbital gateway that uses profile id for credit card transactions replacing existing implementations.
Environment: ASP.NET, ASP.NET MVC, C#, API, Rest API, SQL Server 2008, Visual Studio2013/12/08, C#, CSS-3,HTML5, JavaScript, XML, SQL Server, Chase-PaymentTech, JIRA, Notepad++, JMeter,XPath, Xquery, XSD, Assembla, Eclipse, Selenium Web Driver, Test NG, JUNit,TFS.
Confidential, Arlington VA
Software Tester
Responsibilities:
- Responsible for testing http: // multimedia . verizon . com / SmartPark and http: // www . ncnetwork . net / smartpark /
- http: // investor . verizon . Com /, https: // brandportal . vzmultimedia . com .
- Involved in teh testing process of teh complete re-designed version of Verizon’s Brand portal for around 100 pages.
- Worked on developing automation scripts using Selenium IDE and Webdriver
- Created new test cases, modifying teh selenium scripts in Eclipse and writing test suites using TestNG.
- Created Test plan, Test cases, other QA related documents and automation test scripts for different pages using QTP and later started to use Selenium IDE/ WebDriver.
- Creating, Storing, Organizing and managing Test Automation Resources in QC/ALM.
- Tested teh Integrated Google maps in teh Smartpark web pages.
- Performed Back end Testing using SQL queries in SQL Server databases.
- Tested SOAP requests and responses using SoapUI.
- Created reports, authored documentation, and facilitated software reviews as well as contributing to Scrum sessions to keep teh testing effort on schedule.
- Coordinating with team members and Development team in order to solve issues.
Environment: Selenium WebDriver, TestNG, JUnit, QTP, ASP.NET, XML, Quality Center/ALM,, RestAPI, JMeter, PostMan, Chrome Developer Tools, Firebug, WebPageTest, SQL Server 2012/08/05, VB Script, Visual Studio Test Suite.
Confidential, CA
Software Developer/Tester
Responsibilities:
- Designed, developed, tested and implemented Ajax based web application using Ajax Control tool kit, Master Pages, HTML, CSS, JavaScript and other server controls
- Extensively used AJAX enabled ASP.NET web controls, JavaScript and CSS for client side validations effects.
- Created images for teh website using Photoshop cs3/Gimp-2 effects using Flash 8.0.
- Created custom web controls using tables for fund progress slider and implemented many user controls.
- Created 2 column, 3 column master page layouts and common CSS classes for styling and JavaScript menus.
- Prepared and executed Test Cases with different Test Sets for different objectives based on teh Business. /Functional requirements using QTP.
- Involved in browser compatibility testing using different browsers like IE, Safari, Chrome etc
Environment: ASP.NET, HTML, CSS, JavaScript, C#, SQL Server, Visual Studio 2008, JIRA, MS Excel, Photoshop, Gimp2.
Confidential
Business Rules Tester
Responsibilities:
- Performed Business Rules analysis and designing teh modules
- Created, designed, tested and verified ILOG Repository, Rule Flow and analyzed XML Schema.
- Completed documentation of low level design before implementation using class diagrams and flow diagrams.
- Identified end to end scenarios and modularity of teh application
- Modified teh automated and manual test scripts for different modules using QTP.
- Executed automated test scripts, analyzed teh results and reported bugs in Test Director.
- Prepared test data, test cases and executed them with different Test Sets based on teh Business/Functional requirements
- Debugging Tests and fixing errors and executing teh scripts.
- Defect Reporting, Tracking and Reporting.
Environment: JAVA, ILOG Jrules (BRMS), XML, Oracle 9i, Weblogic8.1, Test Director, QTP