Karthik Daripally

**** ****** *** ****, *** ***, Falls Church, VA, 22043

Mobile No.979-***-****

Email: adbn5j@r.postjobfree.com

Experience Summary

10.2 years of strong experience in Functional, Automation(UI, Database and Rest API), Database (Backend), Web services, ETL feeds, Data Migration, Data ware House Testing.

Extensively used automation tools like Selenium for Functional and regression testing.

Good knowledge on developing automation framework using Selenium web driver.

Developed Data driven Automation frameworks for Reports Generation, web applications and Database using Selenium Java.

Experience in Agile(Scrum), Water fall and V-model methodologies.

Created and Maintained automation framework architecture and technical documentation.

Prepared Cucumber feature files and designed step definitions for various business user stories.

Well versed with handling elements in Selenium web driver, writing test cases using element locators, web driver methods, Java programming features and annotations.

Good knowledge on SQL Query Creation, Execution and verifying the results in the data base.

Expertise in designing Test cases based on Requirement specifications.

Well acquainted with all phases of SDLC and STLC.

Good experience in build and configuration tools like Maven and continuous integration tools like Jenkins.

Good knowledge on version control tools like Subversion and GIT repo.

Expertise in testing REST API using Soap UI and postman tools.

Strong knowledge on NOSQL databases like mongo DB.

Have good Core Java programming and debugging skills.

Involved in Requirement discussions, Test Planning and estimations, Metrics and status reporting

Excellent Communicator with the ability to analyze issues with precision & accuracy, test results and reporting the defects.

Good knowledge on PL/SQL scripting, Unix commands.

Possessing problem solving with good interpersonal skills.

Expertise in testing BI reporting tools like Micro Strategy.

Education and Certifications

Title of the Degree

College/University

Year of Passing

Bachelors of Engineering (Electronics & Communications)

Diploma in Electronics and communication Engg.

SSC

Chaitanya Bharathi Institute of Technology, Hyderabad

Govt Polytechnic, Masab tank

St. Donalds High School, Hyd.

2009

2006

2003

Technical Skills

Technology

Functional Testing, Database Testing, Web Services Testing, Dataware House Testing, Selenium Java

Programming Languages

C, SQL, PL/SQL, Core Java, Gherkin

Databases/Tools

Selenium, Maven, Cucumber, Jenkins, Sub version, IBM DB2, MS-Access, Oracle SQL Developer, Toad, PL/SQL Developer, Squirrel client, Rapid SQL, Eclipse, Doors, Mongo DB, GIT Eye, SonarQube, Soap UI, Postman

Domain

Banking & Finance Services (Cards and payments, Financial Advisory, Community Banking Technology, Mortgage), Communications, Information Media and Entertainment.

External Tools

Rational Clear Quest, HP Application Lifecycle management, Quality Center, SOAP UI, Putty, Rational Integration Tester, Actional Team Server, Winscp, Doors

Certifications

ISTQB Foundation Level 0– Indian Testing board External certified Professional.

Relevant Project Experience

ORGANIZATION: COGNIZANT TECHNOLOGY SOLUTIONS US CORP

Projects #1

Title eGRC Bwise

Client Freddie Mac(Onsite)

Project Type Automation testing

Operating System Windows XP

Tools Application Life Cycle Management, Doors, RapidSQL, Winscp, Putty, Doors, Oracle SQL developer, SnagIt, Eclipse, Maven, Jenkins, selenium, Java, Postman

Team Size 2

Role Team Lead (Onsite)

Period May 2019 – Till date

Project Objective

To automate Bwise application modules(eGRC regression, Internal Audit(CORE) and Bwise risk events using Selenium Java.

Role and Responsibilities

Involved in requirement and test Design analysis.

Prepared automation framework (Core Utilities) to test Bwise application using selenium Java.

Involved in Automation infrastructure development using selenium.

Created test cases using element locators and selenium web driver methods.

Enhancing the test scripts for global execution.

Prepared Cucumber feature files and step definitions for various Business flows.

Maintained code in GIT Repository and generated SonarQube report.

Performed functional and Database testing for web application using automation testing.

Provided continued maintenance and development of bug fixes and patch sets for automation framework.

Participated in automation test results review with Business and Project managers.

Projects #2

Title Investor Reporting Change Initiative(IRCI)

Client Freddie Mac(Onsite)

Project Type Functional, Automation, Database Backend Testing

Operating System Windows XP

Tools Application Life Cycle Management, Doors, RapidSQL, Winscp, Putty, Doors, Oracle SQL developer, SnagIt, UFT

Team Size 7

Role Team Member (Onsite)

Period May 2017 – April 2019

Project Objective

The current Single Family Investor reporting and loan buy out processes do not support requirements of the single Security initiative.

Freddie Mac has a long term strategic vision to move to an industry standard reporting and remittance process, to improve our competitive process, to support the Single Family Business objective to the Best Credit Guarantor, and to ensure we have identified a solution for Single security requirements.

In working towards this vision there will be opportunities to remove key pain points for services and Freddie Mac by making additional enhancements to reporting/accounting processes.

Role and Responsibilities

Involved in requirement analysis and requirements gathering phase.

Understand the requirements and identify static issues, requirement gaps and report to Business.

Involved in Automation environment setup using eclipse, selenium web driver jars and junit.

Developed automation scripts using Selenium java to automate reports generation and validations, financial accountings, file uploads and manual adjustments.

Prepared Cucumber feature files and step definitions for various Business flow.

Developed mail, excel, file upload utilities.

PL SQL Scripts for testing various Data migration related Business Rules and financial accounting processes.

Involved in Database migrations, Data restores and Environment migration testing.

Participated in UAT,End to End testing, one up one down testing.

Prepared WSR, Static defect metrics on weekly basis.

Involved in test design and test data preparation phases for Business Event Discovery processes, Accounting results calculations and Journalization processes.

Validated reconciliation, exception reports and gave suggestions to Business regarding inconsistent requirements.

Report issues to dev team, retest bug fixes after retesting.

Generating status reports and communicated Execution status to various teams.

Stood as SME for OSL modules.

Prepared Test artifacts such as Test summary results, Test results documentations and coordinated with offshore team, consolidated and shared the artifacts to stakeholders.

Participated in defect triage meetings with Development and integration team to bring defects to closure.

Supported UAT testing team and performed root cause analysis.

Got Best team member award for handling Data capture module individually and identifying key defects.

Performed Progression, regression, retesting and controls testing.

Projects #3

Title Hedge Accounting Management reporting

Client Freddie Mac(onsite)

Project Type Functional and Automation

Operating System Windows XP

Tools Application Life Cycle Management, Doors, RapidSQL, Winscp, Putty, Doors, Oracle SQL developer, Snag It

Team Size 3

Role Team Member (Onsite)

Period December 2016 – May 2017

Project Objective

To validate data from multi sourcing systems.

To validate reports and dash boards from 6 source systems.

To validate Data loads and Nonfunctional requirements.

Role and Responsibilities

Involved in Test design for Data loads (Daily and Monthly), Micro strategy and Nonfunctional requirements.

Validated Incremental loads for 2015 reports, Micro strategy reports (Including Adhoc capability).

Validated Micro Strategy Attributes, Metrics for 2015 monthly reports.

Participated in Design reviews and status meeting with IT and Business teams.

Validated Data from source systems in Micro strategy and reported discrepancies to Development team and MS team.

Validated data in the reports (Summary and Design views) using UFT.

Projects #4

Title Phoenix Loan Hedge Amortization Acct

Client Freddie Mac(Onsite)

Project Type Functional,Database Backend Testing

Operating System Windows XP

Tools Application Life Cycle Management, Doors, RapidSQL, Winscp, Putty, Doors, Oracle SQL developer, SnagIt

Team Size 7

Role Team Member(Onsite)

Period May 2016 – December 2016

Project Objective

To perform Data Integrity testing and validate data in PRDS, SFLOAM and SFTA Systems.

To validate contents of all the reports (Reconciliation, Exception and validation reports) and other functional modules.

To validate admin UI for PRDS, SFLOAM and OSL applications for all the processes added and their dependencies clean, pause, force start and retry options.

To validate role based access requirements.

To perform regression testing after progression testing is performed.

Role and Responsibilities

Involved in requirement analysis and requirements gathering phase.

Participated in Business meetings related to requirement changes.

Performed sanity testing for deployed build.

Test EP/ETLs and validate various Data Migration Business rules.

Involved in test design and test data preparation phases for Data capture, Admin UI, Reconciliation reports, Balance calculations modules.

Stood as key resource for Data capture module during the absence of my Lead.

Validated autosys batch jobs and Data ready notifications for various processes.

Validated reconciliation reports and gave suggestions to Business regarding inconsistent requirements.

Report issues to dev team, retest bug fixes after retesting.

Generating status reports and communicated Execution status to various teams.

Stood as SME for OSL modules.

Prepared Test artifacts such as Test summary results, Test results documentations and coordinated with offshore team, consolidated and shared the artifacts to stakeholders.

Participated in defect triage meetings with Development and integration team to bring defects to closure.

Supported UAT testing team and performed root cause analysis.

Got Best team member award for handling Data capture module individually and identifying key defects.

Performed Progression, regression, retesting and controls testing.

Projects #5

Title Retail Web Services(RWS)

Client Wells Fargo(Offshore)

Project Type Functional, Web Service& Database Testing

Operating System Windows XP

Tools Application Life Cycle Management, Clear Quest, Rational Integration Tester, Squirrel Client, Actional Team Server, Putty

Team Size 3

Role Team Member

Period May 2014–December 2015

Project Objective

To validate End User Forms (Customer Copy, Bank Copy).

To validate Products in Database (Data Loads and Product Extracts).

To validate Middleware Application Messages using Actional Team server and Rational Integration tester.

To Verify RWS Rates UI.

Role and Responsibilities

Involved in Test analysis/Requirement Analysis for Major and off releases.

Involved in Test reviews.

Performed Run Through Once (RTO),Smoke tests for builds.

Certification/ Enterprise Testing for all the projects.

Data Conditioning in Hogan.

Verify Client Applications, Retails Web services messages (RWS) and system Of Records (SOR).

Communication with Quality Assurance Analyst(QAA) and Business Analysts.

Delivered Test Items in certification period.

Involved in pre install activities.

Projects #6

Title Sales Portfolio

Client T-Mobiles Netherland(Offshore)

Project Type Functional, Web Service& Database Testing

Operating System Windows XP

Tools Quality center, Toad, PL/SQL Developer

Team Size 6

Role Team Lead

Period November 2012 - April 2014

Project Objective

To validate Data Model changes (Creation/updation of new tables, columns and views).

To validate back end changes. (Creation of procedures, Entities).

To validate front end changes HTML pages and Oracle fusion forms (Data configured in Database versus front end).

To validate XML Vs Database data and XML messages

To verify interface messages.

Role and Responsibilities

Involved in Test analysis/Requirement Analysis for individual Change Requests for particular Release.

Test Estimations and Release planning.

Test case design for individual CR's.

Preparation of SQL queries.

Creating Test data and proper stubbing for that Business flow.

Involved in system test for Change requests in various releases.

Prepare XML messages if required.

Improved client interacting skills through mail communication for getting clarifications and confirmations from SME.

Delivered Test Items with high quality without any slippage.

Projects #7

Title Golden source dataware house

Client AMERIPRISE FINANCIAL

Project Type Functional, ETL feeds, DWH & Database Testing

Operating System Windows XP

Tools Quality center, Toad, PL/SQL Developer, Informatica

Team Size 6

Role Team member

Period October 2010 – October 2012

Project Objective

To validate ETL Source and target feed files from various source systems.

To verify the transformation logics in the target feed files whether matching the mapping document.

To test the raw feed files from various source systems to standard file.

To validate DWH using queries and test whether Target feed file data is loaded into DWH.

To validate reports (Static & Dynamic) from GS DWH.

Role and Responsibilities

Involved in all the stages from the start of the project which include Requirement Analysis, Test case design, Test Execution.

Key resource in completing the test design for this critical project.

Validated Data Hub Source and Target files by verifying the transformation logics as per the Business requirements.

Validated the DWH reports using SQL queries and UI.

Prepare the SQL scripts and execute and verify the data.

Verified the Data Warehouse data through Golden Source UI interface.

Performed Smoke testing on ETL feed files.

Contact this candidate