SUMMARY:

• Over fifteen years of IT experience including both testing and ETL development experience.
• Experience for thirteen years of Functional testing, GUI testing, System Testing, Regression testing and test automation of Window based, back - end/database and Web based applications.
• Analysis, design, development and implementation of software applications in data warehousing and client/server environment using IBM Data Stage for two years and server/PX (designer, director, manager and administrator).
• Acquired in depth knowledge of SDLC (Software Development Life Cycle), Agile Methodologies, QA Methodologies, Business Analysis, database management and research information.
• Expert in writing test plans, defining test cases developing and maintaining test scripts and test procedures, analyzing bugs and interacting with team members in fixing the errors as per the specifications and requirements.
• Hands-on expertise in a wide range of testing and QA Tools like Selenium Webdriver, Junit, TestNG, JMeter, Gatling and Quality Center ALM and JIRA.
• Strong experience in the Quality Assurance Manual and automated testing of Web based and client-servers.
• Tested applications using HP Suite (Quality Center, QTP) and Selenium Web Driver.
• Familiar in creating TDD and BDD test automation frameworks.
• Oracle database development experience using SQL*Plus, SQL*Loader and Developer 2000.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Used SQL, PL/SQL to program Stored Procedures, Functions and database Triggers, Cursors to enforce complex integrity constraints and for auditing purposes.
• Good experience in databases like DB2, Oracle, Tera Data and SQL Server 2005.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment, change data capture.
• Programming experience using Unix Shell Programming, C, Perl, HTML, DHTML and Sun Solaris.
• Strong analytical, presentation, problem solving and excellent interpersonal communication skills and flexibility to learn new technologies in the IT industry towards the company’s success.

TECHNICAL SKILLS:

Testing Tools: Quality Center 10.0/11.0, QTP 9.2/10.0, Test Manager, Selenium Webdriver, JunitTestNG, JMeter, Gatling, SoapUI.

ETL Tools: Data Stage 7.5/7.1/6.0 (Designer, Director, Manager, and Administrator), Informatica.

Reporting Tools: Developer 2000, Business Objects

Databases: Oracle 9i/10g, SQL Server 2000/7.0, IBM DB2 7.2, Terra data, MS Access 2000Sybase, VSAM

Operating Systems: Windows 2000/NT, UNIX, Sun Solaris 2.6/7/8, AIX 5.2/7.2, OS/390

Tools: Eclipse, JIRA, Jenkins, JAWS, GIT, SonarQube, Docker, Rally, JAMS, Clear Case/Clear Quest, Autosys, smart scheduler, SQL*Loader, Rapid SQL, Toad and SQL Navigator

Languages: C, C++, JCL, UNIX Shell Programming, Perl, SQL, PL/SQL, COBOL, VB6

EXPERIENCE:

Sr Test Automation Engineer

Confidential, Reston, VA

Responsibilities:

• Participated in daily stand ups, sprint planning, grooming and retrospective meeting after every sprint.
• Created and maintained test scenarios, test cases and test results in HP ALM.
• Analyzed existing Confidential test automation framework(vTAF) and implemented that framework into CMS project.
• Involved in enhancing or adding more features to the library of the test automation framework.
• Used maven to maintain the dependencies used in the framework and build the jar files.
• All the automation code is pushed into GIT and all the versions are maintained in GIT.
• Jenkins is integrated with GIT and used to build the automation code. Builds are scheduled thru Jenkins.
• Created a liberary or utility package to maintain common function related to waits/ fill drop downs/ fill fields/ clicks, data entry and get texts.
• Performed cross browser tesing in three browsers IE, Firefox and Chrome using automation script.
• Used Rest Assure to do REST and web services testing.
• Reports are generated using ReportNG. Screenshots are also captured for failures or errors.
• Used SonarQube to scan the test automation code to find if any security vulenerabilities exist in the code.
• Use Docker to setup the Selenium Grid and node containers to execute the test cases parallelly.
• Involved in doing 508 testing using JAWS software tool.
• Created & maintained user stories and defects in JIRA. Used dashboard for daily stand ups.

Environment: HP ALM 13, Oracle 11g, Informatica, OBIEE, JAWS, Java, Selenium WebDriver 3.05, TestNG, Sikuli, Maven, ReportNG, GITHUB, Jenkins, SoapUI, JIRA, Docker, MongoDB, SonarQube, Kafka.

SDET

Confidential, Herndon, VA

Responsibilities:

• Assessed & analysed user stories and participated in Sprint planning, Review Sessions & Scrum Meetings and developed Test scenarios, Test cases, Test data, Test procedures, Test reports.
• Involved in implementation of Test Automation Framework build using Selenium WebDriver, JUnit and Maven technologies under Java platform using Spring Tool Suite.
• Automated the entire Web application using BDD Framework with Page Object Model..
• Extensively used Java, Cucumber, Selenium 2.53 and Junit.
• Developed the utilities module in the framework for re-usability
• Wrote feature files using Gherkin language in Cucumber for BDD.
• Used Cucumber Features, Step Definitions, Scenarios and Scenario Outlines.
• Auto-generated the feature files with the existing backend data.
• Ran test cases using Selenium Grid hub and node simultaneously on multiple platforms.
• Developed the automation scripts and made changes sprint wise to adopt to the changes in the web application.
• Managed Maven project dependencies by creating parent-child relationships between projects.
• Jenkins is used as a continuous integration tool for automation of daily process.
• Performed functional testing of SOAP and Restful Web Services using SOAP UI Tool.
• Involved in Web services testing using SOAPUI Tool. Validated request and response XML.Added assertions to validate the XML in Web services SOAP and Restful service.
• Scheduled jobs through Jenkins for the automation scripts to run daily for regression and shakeouts.
• Running the test automation suite against new builds to confirm their stability and functionality.
• Used Sauce Labs to perform cross browser compatibility testing.
• Analyzing and developed test script, test cases and performed Manual and Automation Testing like Positive Testing and Negative Testing.
• Used Rally to log the defects found in the testing, User stories are logged in the Rally in Gherkin format and Rally is used as a daily scrum board in daily stand ups.
• Generated the Cucumber JVM reports through Jenkins.
• Used HP ALM to maintain the test cases and maintain the test results.

Environment: HP ALM 13, Java, Selenium WebDriver, Cucumber, Junit, FirePath, FireBug, Oracle, SOAP UI, Rally, SVN, Angular JS, Maven, Jenkins, Jmeter, STS(Spring Tool Suite).

QA Lead

Confidential, Rockville, MD

Responsibilities:

• Participated in requirement walk thrus and performed ambiguity analysis.
• Provided key suggestions and comments on different aspects of testing to increase the effectiveness of the testing approach.
• Created and executed test automated scripts developed with Java and Selenium Webdriver framework.
• Xpath was used in the test scripts to identify the objects in the application.
• Application is tested against multiple browsers like Firefox, Chrome, Internet Explorer, safari in the Selenium WebDriver framework using Sauce Labs interface.
• Performed load, stress testing using open source tools like JMeter and Gatling.
• Maintain automation suite built in Quick Test Pro later migrated to the Selenium WebDriver framework.
• Maintain regression suite consisting of manual and automated test cases
• Identify test scenarios for each enhancement and evolve a test strategy for the release.
• Involved in debugging the code when any defects or Issues are found in the QC environment.
• Involve in design review meetings to identify the scope of testing for the release.
• Created Test Cases and Test Plans for functional, GUI and regression testing according to System specifications using Quality Center.
• Involved in creating new QTP scripts for new functionality in each release and add to regression suite as applicable.
• Assisted Off-shore testers with issues related to QTP Automation Scripts and other System Testing Issues.
• Prepared a test strategy and test procedure to test the application in a given timeline.
• Responsible for performing GUI testing for all web frameworks.
• Responsible for testing various batch jobs with interface’s with different systems.
• Loaded data received from different Broker Dealers into CSV/Excel files for various data fixing/manipulation operations.
• Directed and Assisted Off-shore testers in Regression Testing for all Applications.
• Involved in the various stages of data/server migration.
• Used TOAD and SQL Developer for back-end testing.
• Conducted positive and negative testing for data integrity.
• Conducted defect review meetings and coordinate issues to the Project Management
• Supervised System Testing and Regression Testing for each release
• Maintained Defect Life Cycle in StarTeam
• Worked with Development team after defects were identified to explain the test scenario and assisted them in reproducing the problem.
• Performed functional test of the application for each release to make sure that the specified functionality is intact.
• Scheduled UAT deployment and assisted end-users during Acceptance Testing
• Assisted Development Team during production deployment by conducting smoke test analysis of the application.
• Provided a detailed Test Execution Report to Project Management at the end of each release.
• Used Star Team for version control and later migrated to TFS.

Environment: Quality Center 10/ALM, QTP 10.0, Oracle 10g/11g, SQL Server 2000/2005, TOAD, SQL developer, Star Team TFS, ASP.NET, Visual Studio 2005/2008/2013 , .NET Framework 2.0/4.0, Sun Linux, Microsoft Windows Server 2003/2007, JIRA, Jenkins, JAMS, Selenium WebDriver, Junit, JMeter, Gatling

QA Analyst

Confidential, McLean, VA

Responsibilities:

• Designed and developed Business Requirements, Test Plans, Test Cases and Traceability Matrix documents for the projects using FTD templates and following Freddie Mac guidelines.
• Provided key suggestions and comments on different aspects of testing to increase the effectiveness of the testing approach after conducting system analysis.
• Met with the Business Analysts and Business Systems Analysts on a regular basis to discuss complex financial business processes and other issues related to the projects.
• Sourced data from Blackrock vendor which is in CSV file is loaded into tables in SYSBASE for testing purposes.
• Created Requirements Traceability Matrix mapping the test cases to the requirement.
• Prepared a test strategy and test procedures to best test the application in a given timeline.
• Involved in testing reports which were generated after each process.
• Performed database integrity testing by executing complex SQL queries to pull out data from the CDW database and Rapid SQL to pull data from Sybase and DB2 database.
• Was actively involved in and worked with other testers and developers to coordinate our efforts during the end to end and UAT testing of these projects.
• Interacted with the development teams to assure that all the defects are addressed in time.
• Created test cases and test plans according to the system specifications using Rational Test Manager.
• Used Rational ClearQuest to track and manage defects and change requests throughout the development and testing process.
• Conducted positive and negative testing for data integrity and testing purposes.
• Extensively used SQL tuning techniques to improve the database read performance.
• Involved in system testing, integration and performance testing of the jobs.
• Created Korn shell scripts for running the queries.
• Used ClearCase/ClearQuest for version control and migration.
• Created view, added new elements check-out and check-in in Clear Case.

Environment: Datastage 7.2 (Server/Parallel Extender), DB2 UDB 8.1.6 (EEE), DB2 SQL, SYBASE, Test Manager, UNIX Shell Scripting, Windows NT 4.0/2000, Clear Case/Clear Quest, IBM AIX 5.2, Autosys.

QA Analyst

Confidential, St Louis, MO

Responsibilities:

• Participated actively in gathering the requirements and analyzing the requirements and developed Test Cases to test the complete functionality of the applications.
• Developed comprehensive test plans and contributed to annual quality goals as described in the QA team objectives.
• Created Requirement Traceability Matrix in excel mapping test cases with business rules.
• Involved in understanding the business process and coordinatedwith the business-users to get specific user requirements to test the data marts.
• Conducted Functional, Regression, Integration and UAT Testing.
• Created UAT documentation and conducted presentations for the end users.
• Worked with the QA managers and project managers on testing team assignments.
• Tested data extracted from Oracle, IBM DB2 Mainframe and loaded them into Teradata target database using Informatica ETL Tools.
• Created and executed SQL queries to perform data integrity testing on different databases.
• Documented the test results and reported the defects to the data analyst’s and ETL developers.
• Sound knowledge of data-warehouse development using, data warehouse ETL (extract/transform/ load) Informatica Power Center Tools.
• Performed functional testing using QTP and created functions using VB script in QTP.
• Implemented Hybrid QTP Framework.
• Involved and responsible for creating weekly status reports regarding the progress of the testing process.
• Used the quality center for defect tracking and for logging, evaluating and reporting defects.
• Worked closely with the teams to discuss the design and testing aspects of the applications to design the test plans.

Environment: Informatica 8.0, Windows 2000, Clear Case, IBM AIX 5.1, Unix shell scripting, DB2 UDB, Oracle 8i, TerraData, SQL *Loader, PL/SQL, Business Objects, ASP.net, Visual Studio 2003. Framework 1.0.

ETL Developer

Confidential, Hartford, CT

Responsibilities:

• Involved in designing and development the data warehouse environments.
• Involved in logical andphysical modeling as per the business requirements.
• Implemented Star Schema and Snow Flake Schema for the data warehouse.
• Used datastage manager to import, created and edited the metadata.
• Used the datastage administrator for managing the users and privileges.
• Translated the business processes into datastage jobs for building data marts.
• Used datastage, designed and developed various jobs and performed data loads.
• Extensively used stages and transformed the datastage for various types of date conversions.
• Created and modified jobs according to the client’s requirements.
• Tested all the applications and run the jobs using datastage director.
• Data quality analysis to determine cleansing requirements.
• Extracted data from various data sources in Oracle and flat file format.
• Performed tuning of the repository and jobs for optimum performance.
• Created UNIX shell scripts using K shell for scheduling the jobs.
• Documented the jobs used in ETL process.
• Designed and developed Universe for reports generation using Business Oobjects designer and generated reports using Business Objects Reporter.
• Resolved Loop and Join problem by creating Aliases and contexts.
• Used the Broad Cast Agent server to schedule and monitor the reports.

Environment: Ascential DataStage 5.2(Designer, Director, manager, administrator), Orchestrate, Business Objects(Supervisor, Designer, BO reporter), Oracle 8i, DB2 mainframe, OS/390, Windows 2000, UNIX

Oracle Programmer/Analyst

Confidential

Responsibilities:

• The project was developed in the Oracle Relational Database Management Systems (RDBMS).
• Actively involved in the full System Development Life Cycle (SDLC) of the application.
• Extensively involved in the analysis, development and design of the database, ER Diagram and database composition with referential integrity constraints and Triggers to avoid duplication and to impose the business requirements.
• Defined and composed primary and foreign keys in the database normalization process.
• Developed and designed procedures and functions to provide additional authentication
• Wrote database and application Triggers to impose business rules and to provide excellent customer service through automated information and prepared SQL scripts.
• Designed GUI based friendly user screen with customized menu and messages by using Developer 2000 and provided user training for the new system.
• Generated reports from SQL* Plus and Oracle reports for marketing and the management staff. The application had a modular structure for easy maintenance and upgrading.

Environment: Windows 95, Oracle 8.0, SQL, PL/SQL 2.0, and Developer 2000