Ravi Katakam

Cell: 540-***-****

Email: ad0dj2@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 16 + years of experience in the IT industry with extensive skill set dedicated to QA Testing in

Excellent understanding of methodologies like Agile, SCRUM.

Proficient in Manual, Automated, Load/Performance/Stress & Volume testing, Data migration testing.

Develop Master Test Strategy and Detailed Test Strategy based upon the Business/System Requirements.

Device System and UAT Plans and co-ordinate with other functional groups and user groups to execute the tests, gather the results and generate reports.

Excellent skills in Automation Testing, especially using QTP, Selenium, Quality Center, Load Runner

5+ years in Test Development and/or Test Automation roles

Two years of testing experience in MuleSoft Any point Platform

Extensive knowledge of developing and implementing test plans, protocols, and strategies for Mobile App testing and Web testing

Experience in testing RAML based APIs using Any point API Platform.

API testing (REST /JSON), API mocking (SoapUI), SoapUI assertions,

Good exposure to Continuous Integration and Delivery tools surrounding Any point Platform. Used CI/CD tools like Jenkins, GitHub, Maven Any point Runtime Manager.

Experience in testing complex Mule Flows, Scopes, Error Handling strategies, Message Filters, Validation, Transformation, Message Enricher and Flow Controls. Good understanding of Core Java and Object-Oriented Programming (OOPs) concepts and Experience in designing, developing, enhancing automated test scripts for Selenium using Java.

Expertise in designing and implementing Selenium Automation Frameworks using Data Driven, Keyword Driven, Hybrid, Object repository, Page Object Model (POM).

Experienced using web debugging tool like Fire Path and Firebug to locate web elements.

Experience in testing both SOAP and REST services using SOAP UI, Postman and Tested both XML and JSON formats.

Experience in automation testing using Selenium WebDriver/RC/IDE/Grid, JUnit/ TestNG, ANT, Maven and Jenkins.

Have extensive experience in implementation of Workflow Rules, Role based Page Layouts, Record Types, Approvals and Assignment Rules.

Strong testing skills in Salesforce1 Mobile App, Salesforce standard object, custom objects, custom fields, page layouts, custom Tabs, Reports and various other components as per application requirements.

Written Behavioral Data Driven/Keyword Driven Frameworks using Cucumber.

Proven communication skills and the ability to troubleshoot and solve complex networking issues

Skilled in providing support in various networking testing activities to provide effective support

Highly Experienced in Defect Management using Clear Quest, Quality Center (formerly Test Director).

Highly experienced in creating requirements using Doors, Requite Pro, and Quality Center.

Skilled in analyzing business context and requirements for UAT testing purposes

Proficient in different types of Testing Proficient in software applications testing procedures for System, Regression, Integration, Interface, Database, Load, Performance, Stress & Volume, UAT testing, Functional, Integration and Regression during Black Box testing, White Box testing.

Good in RDBMS concepts and experience in testing Stored Procedures, Functions and Triggers using SQL and PL/SQL.

Good experience in writing UNIX Shell, Perl, AWK and TCL

Experience using QTP/UFT and Selenium for Automated regression test suite creation and execution.

Very good understanding of Data warehouse (ETL process) and testing using Ab Initio (ETL tool), MSBI (SSIS, SSRS).

Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role.

Provide the required assistance to the higher management to define future quality goals.

Technical Skills:

Operating Systems

Win9X, 2000, XP, NT, Solaris 8.0, Linux, HP-UX

Languages

J2EE, Java, XML, C, C++, Java Script & Shell Script, PERL, SQL, PL/SQL

Databases

Oracle 9i/10g, SQL Server, Sybase & MS Access, Rapid SQL

App/Web Servers/IPs

Web logic, HTTP, TCP/IP & FTP

Automation Testing Tools

Load Runner 7.x, Win Runner 7.x, Quick Test Pro, Ruby Cucumber, Selenium, Quality Center, Clear quest

Testing Procedures

Performance/Load/Stress/Volume, System, Regression & Integration, 508 Compliance Testing,

Defect Trackers

Test Director 7.x, Clear Quest, Rational test manager, JIRA, ALM

Salesforce

Apex Language, Apex Classes, Apex Triggers, SOQL, SOSL, Visual Force (Pages, Components & Controllers), S-Controls, Apex Web Services, Apex Data Loader, Force.com Apex Explorer, AJAX, Dashboards, Reports, Analytic Snapshots, Custom Objects, Force.com, Eclipse IDE Plug-in

Other Software

MS Office, TOAD 7.2, Exceed, Putty, DB Artisan, Ab Initio, SAS Tool, Humming Bird, Check free recon plus tool, Clear case, HP Open View, Mule Soft 4.0

PROFESSIONAL EXPERIENCE:

Fox Coomunications Los Angles Apr’21–Current

Playbook Automation ETL Test Lead

Fox is the global leader in real life entertainment, serving passionate fans around the world with content that inspires, informs and entertains. Fox delivers over 8,000 hours of original programming each year across deeply loved content genres Available in 220 countries and territories and 50 languages, Fox is a platform innovator, reaching viewers on all screens and services, from linear, free-to-air and pay–TV channels to digital products and streaming services, to social and mobile-first content and formats. Fox’s portfolio of premium brands includes Fox Channel, HGTV, Food Network, TLC, Investigation Fox, Travel Channel, Turbo/Velocity, Animal Planet, and Science Channel, as well as OWN: Oprah Winfrey Network in the U.S., Fox Kids in Latin America, and Eurosport, the leading provider of locally relevant, premium sports and Home of the Olympic Games across Europe.

PLAYBOOK is an internal Fox system that provides the tools to manage the content lifecycle from program proposal and greenlight, through delivery of programs and related assets. The systems support a variety of functions such as program proposal submission, deal workflow, inventory creation, production company/vendor/talent, program deliverables/schedules and inventory, airing and DMC Media.

Role & Responsibilities:

Involved in grooming the User Stories and adding Acceptance Criteria for Mobile app and web application interfaces.

Assigned stories to team members based on severity of stories and bandwidth of resource

Interacted with Product owners and business stake holders to understand the requirements

Written Test plans and stored them in Box folder and Service Now test manager.

Reviewed Test cases (Automated/Manual), and Test scenarios prepared by team before presenting with business stake holders

Tested REST APIs developed by MuleSoft Any point API Platform.

Tested Database and HTTP connectors to implement API Methods to read and write data to Media scheduling System.

Implemented webservices testing for Salesforce Object APIS.

Attended Leads meeting and addressed potential issues of story grooming and risk of adding stories in mid of the sprint

Tested several connectors like HTTP, Database, File and SFTP

Involve in API design sessions to decide various resources within each API, message schemas, message formats and authentication for testing same.

Conducted Retrospective meetings and collected feedback from BA, Dev, QA teams and identified action items to complete before next sprint retrospective.

Identified high-risk factors before sending product to user acceptance testing (UAT), communicating with management to determine which risks were acceptable.

Used CI / CD tools like Jenkins, Maven and GitHub during the Testing.

Involved in Soap and Restful Web Services Testing.

Automated RESTful web services using SoapUI Pro

Performed Web testing to ensure no issues with usability, compatibility, security and links.

Developed Automation framework using Selenium WebDriver, Cucumber, Eclipse, Junit, and Java and Extended TestNG Framework by adding some helper classes and methods.

Developed re-usable function using Junit for the Test Automation.

Utilized TestNG new feature (TestNG Reporting, I Reporter Interface and Screenshot), Soft Assertion, to capture multiple failures of the test case instead of stopping at the first failure.

Created Cucumber Feature Files comprising of various Test Scenarios and Step Definitions for BDD (Behavior Driven Development).

Used Firebug for inspecting web pages and to locate Web Elements.

Wrote CSS Selector and XPath manually to work on dynamic Web Elements.

Tested the mobile application functionality like email, push notifications and responsive using emulators.

Track the work progress and ensure the timely delivery of work products.

Deployed SQL Test code into testing environment using Toad tool and send status to Management and Team.

Log Defect, Track to the Closure and Triage Management.

Developed complex SQL queries for querying data against different data bases for data verification process.

Prepared the Test Plan and Testing Strategies for Data Warehousing Application

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.

Written Shell scripts to validate the logs and other data files.

Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts.

Tested several complex ETL mappings, mapplets and reusable transformations for daily data loads.

Creating test cases for ETL mappings and design documents for production support

Provided Daily testing status metrics to higher management.

Written Functional Test Cases for various modules to validate the customizations made to the reconciliation to suit the business needs.

Verified bug fixes and tested all impacted modules in application.

Ensure Requirements Coverage with Traceability Matrices.

Identified the Risks, Quantify and Prioritize and mitigate them to minimize the impact.

Environment:

Fannie Mae, VA

Project Name

Role

Duration

Uniform Closing Dataset (UCD)

Sr. Salesforce QA Tester (UAT)

Sep’16-Mar’21

Loan Accounting Initiative

ETL tester

Jan’13-Jan2015

FMIS, FDW, ADW

Data Migration tester(UAT)

Jun’10-Nov’11

Guarantee Business System (GBS)

Data conversion (UAT)

Dec’06-Aug’07

Role & Responsibilities:

Validated Data security and Sharing rules in Salesforce. Tested Users, Profiles, Role hierarches and Permission sets as per user profile and Public group.

Validated hundreds of reports and tested dashboard bases on roles and role hierarchies.

Tested salesforce standard objects (Campaign, Accounts, Contacts, Opportunity) and custom objects, page layouts, fields validations and its access to the user based on defined profile.

Validated workflow rules, approval processes, and validation rules.

Used Data Loader to insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.

Tested lookup and master- detail relationships on the objects and created junction objects to establish connectivity among objects.

Worked on Data migration from lower environment to higher environment and validation the data.

Created Test scripts, Test cases, executed Test cases and logged the defects in QC environment.

Performed GUI, Functional, Regression, Retesting, Usability, Acceptance, Smoke testing

Good interacted with QA team members, Developers, Project Managers and Clients to resolve issues

Regularly participated in Technical and Use Case review meetings for various functionalities in the application.

Involved in User Acceptance Testing.

Involved in reviews for functional requirements and Test case scenario and Test case designing.

Sent out daily status reports to the QA managers, QA team members and Developer teams.

Coordinated with onsite/offshore teams, conducted necessary KTs and provided full support whenever it was required.

transactions using SOAP UI

Worked on agile scrum-based methods for BDD

Ensuring that the Pre-UAT activity is performed accurately and efficiently

Developing UAT test process and monitoring SIT execution phases

Validated data between Prod and QA environment.

Used Selenium tool (Selenium IDE is a plug-in for Firefox) to record and playback tests and then export the recorded test in other language e.g. html, Java. The Exported test can be run in any browser and any platform.

Regression test cases were written and automated using Selenium WebDriver.

Used Xpath and POM to work with dynamic and static objects in Selenium.

Performed Data Quality checks validation before data consumed by down streams.

Performed different types of Testing: Exploratory, Functional, Integration and Regression during Black Box testing.

Performed User Acceptance Testing using different test methodologies like Risk Based, Scenario based.

Ensure test systems availability to be able to execute test suite on nightly basis

Developed Cucumber Test Automation scripts; maintain and control via HP ALM.

Mapped the test scripts to the functional requirements in Quality Center 10.0 and HP ALM.

Reported bugs, reviewed bugs created by Team and Analyzing bugs in Clear Quest.

Track the work progress and ensure the timely delivery of work products.

Deployed SQL Test code into testing environment using Toad tool and send status to Management and Team.

Log Defect, Track to the Closure and Triage Management.

Provided Daily testing status metrics to higher management

Verified bug fixes and tested all impacted modules in application.

Identified the Risks, Quantify and Prioritize and mitigate them to minimize the impact.

Environment: Force.com, Apex Data Loader, HP - Quality Centre 11.5, UNIX, Toad, ETL, SOQL, Windows 7, Salesforce.com Platform, Apex, Visualforce (Pages, Component & Controllers) Pages, Data Loader, HTML, Workflow & Approvals, Reports, Quality Center, Java/J2EE, SQL Server, QTP/UFT, Web Services, Cucumber, Jira, UNIX, SOAP UI tool. Windows, Selenium Eclipse, MS Word, Excel, JSP, HTML, XML, Selenium Web driver

Capital One, Mclean, VA Jan’15 –Aug’ 16

GFIT ETL Test Lead

As per Federal mandate all banks need to provide Liquidity coverage ratio on daily basis and monthly basis to assess bank cash reserves risk. To provide this information Capital one started application called GFIT by using Oracle Financial tool OFSAA.

Role & Responsibilities:

Developed Test Plans, test scripts and executed the test scripts for FedEx Freight – OPM DW Project.

Throughout the project in various iterations/Sprints – conducted system testing, integration testing, functional testing and integration testing.

Developed complex SQL queries for querying data against different data bases for data verification process.

Prepared the Test Plan and Testing Strategies for Data Warehousing Application

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.

Participated in regular project status meetings and QA status meetings.

Extensively used and developed SQL scripts/queries in backend testing of Databases.

Written test cases to test the application in Quality Center 9.0 and 11.0(ALM)

Defects identified in testing environment are communicated to the developers using Quality Center – Defects module.

Using Appium platform configured variety of mobile and tab devices and tested the application.

Perform cross browser testing in various device setups.

Prepared daily status reports with details of executed, passed, and failed test cases and defect status.

Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.

Creating test cases for ETL mappings and design documents for production support

Setting up, monitoring and using Job Control System in Development/QA/Prod

Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases,

Scheduling and automating jobs to be run in a batch process

Effectively communicate testing activities and findings in oral and written formats

Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts

Extracted data from various sources like Oracle, flat files and DB2 server.

Worked on issues with migration of Data from development to QA-Test Environment

Extensively tested several Business Objects Reports – Crystal’s reports and Dashboards to validate the reports the data and cosmetics of the report.

Environment: Oracle 10g/11g, Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor), SAP Business Objects 3.1 – Crystal Reports and Dashboard, HP QC 9.0/11.0, SQL developer, Appium, TOAD, SQL and PL/SQL, Web Services.

Tri Core solutions, Scranton, PA Dec ’11 –Dec’ 12

PSDW, RLDM ETL Tester

The Prudential Insurance Company of America (Prudential) wanted to better leverage the wealth of information being collected by their operational systems and to provide a more accessible way of providing information and enabling a more insightful customer-focused business decisions to improve sales and services for their Retirement Service Organization. RLDM and PSDW systems collect the all 401k information from various customers and transform the data in a way organization can use for various internal purposes.

Role & Responsibilities:

Work closely with software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle

Develop Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems

Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation

Writing test cases/scripts within PEGA PRPC and correct the according to the erroneous outcomes

Followed Pega Guardrails and implemented in the application.

Executed Test output bases on Test cases for Pega application

Verify and validate that all fields in Pega are populated in front end and backend as per the requirement based on the spreadsheet.

Analyze and understand the ETL workflows developed

Quality Management - Knowledge of quality management methods, tools and techniques

Create UNIX shell scripts to access and move data from production to development environment

Communicate- and manage expectations of the senior management team and affected stakeholders during the planning and roll out of project releases

Environment: Window NT, UNIX, SunOS, Perl, Sybase, Rapid SQL, SAS, SQL, Java, JSP, Oracle, MS Office, Clear Case, Clear Quest, Rational Test Manager, Quality Center Autosys, BI, Informatica, QTP, 508 Compliance Testing

Swift, Culpeper, VA Aug ’07 –May 2010

Tech Ops, Swift Net Sr. QA Analyst

Regression Test Bed (RTB)

S.W.I.F.T is the Society for Worldwide Interbank Financial Telecommunication. SWIFT enables its customers to automate and standardize financial transactions, thereby lowering costs, reducing operational risk and eliminating inefficiencies from their operations. SWIFT is solely a carrier of messages. It does not hold funds, nor does it manage accounts on behalf of customers, nor does it store financial information on an on-going basis. As a data carrier, SWIFT transports messages between two financial institutions. This activity involves the secure exchange of proprietary data while ensuring its confidentiality and integrity.

Role & Responsibilities:

Reviewed and referred Business requirements, functional Specifications, ICG, POG, to Identify Test Requirements, Test Plans, and Designed Test Cases, Test Scripts and Test Data.

Interacted with Customers, Developers, SME’s (Subject matter experts) and other departments for effective and reliable testing.

Written Test strategy document, Test plans, Test cases (Automated/Manual), and Test scenarios and stored them in rational test manager and live link.

Performed different types of Testing: Functional, Integration and Regression during Black Box testing, White Box testing.

Configured the network infrastructure on release basis to test the new and old functionality of the application.

Monitored network servers, activities, and updated user passwords.

Tested RTB client-servers, networks, and updated operating systems.

Performed User Acceptance Testing using different test methodologies like Risk Based, Scenario based.

Developed Shell & Perl scripts to validate the Existing and Enhanced functionality of application.

Created APIs &Modules using Perl and reused them to perform regression testing.

Developed Database connectivity scripts using Perl to connect cross platform databases and validate & verify the response and generate reports and send to management.

Developed Shell & Perl scripts to validate the logs and other data files.

Performed 508 Compliance Testing against receiving and approving documents for MS-WORD, MS-OFFICE, PDF, MS-POWERPOINT.

Make sure all the documents gone through the 508-compliance testing process.

Ensures RTB system availability to be able to execute test suite on nightly basis

Written SQL scripts to validate the data in the database. Ran the PL/SQL batch process to handle bulk data at times.

Developed Test Automation scripts; maintain and control via Quality Center 9.0.

Developed various kinds test automated scripts to validate XML request and response.

Tested Web services securities like Authentication, retrieving the data, validating the conditions and file scanning.

Mapped the test scripts to the functional requirements in Quality Center 9.0.

Created Requirements in Req Pro and generated RTM (Requirement Traceability Matrix)

Reported bugs, reviewed bugs created by Team and Analyzing bugs in Atlas.

Involved in Defining, Reviewing, Monitoring and improving the internal QA process.

Track the work progress and ensure the timely delivery of work products.

Deployed SQL Test code into testing environment using ATS tool and send status to Management and Team.

Log Defect, Track to the Closure and Triage Management.

Written Data Conversion test cases to ensure Technical Requirements.

Written Functional Test Cases for various modules to validate the customizations made to the reconciliation to suit the business needs.

Verified bug fixes and tested all impacted modules in application.

Ensure Requirements Coverage with Traceability Matrices.

Identified the Risks, Quantify and Prioritize and mitigate them to minimize the impact.

Environment: Window NT, UNIX, SunOS, Perl, Sybase, Rapid SQL, SQL, SAS, Java, JSP, Oracle, MS Office, Clear Case Clear Quest, Rational Test Manager, Quality Center, 508 Compliance Testing, SOAP web services

Freddie Mac, Mc Lean, VA May ’05 –Nov’06

QA Tester

Auto Reconciliation System, STOR (Security and Treasury Ops Reconciliation), QA Tester

Risk Navigator, Corporate Tax Automation.

Freddie Mac is one of the top US recognized stockholder-owned corporations. Freddie Mac Supplies funds to Mortgage lenders, such as commercial banks, mortgage bankers, savings institutions and credit unions across the country. Freddie Mac purchases single-family and multifamily residential mortgages and mortgage-related securities, which it finances primarily by issuing mortgage pass through securities and debt instruments in the capital markets.

Role & Responsibilities:

Reviewed and referred Business requirements, functional Specifications, Solution design document to Identify Test Requirements, Test Plans, and Designed Test Cases, Test Scripts and Test Data.

Interacted with SME’s (Subject matter experts) for Effective and reliable testing.

Written test strategy document, test plans, test cases, test scenarios and stored them in rational test manager and Centralized LAN.

Performed different types of Testing: Functional, Integration and Regression during Black Box testing, White Box testing.

Written Shell scripts to validate the logs and other data files.

Worked on SAS tools to write queries and compare against expected results.

Developed an automated Regression Test Suite which includes the installation of the Oracle 10G in multi-platform (UNIX and Windows) through Perl & UNIX shell scripts

Performed 508 Compliance Testing against receiving and approving documents for MS-WORD, MS-OFFICE, PDF, MS-POWERPOINT.

Make sure all the documents gone through the 508-compliance testing process.

Written SQL scripts to validate the data in the database.

Reported bugs, reviewed bugs created by Team and Analyzing bugs in Clear Quest.

Involved in analyzing GAP analysis for the coverage of Functional Requirements.

Participated in peer and group reviews of test cases and of defects.

Wrote Data Conversion test cases to ensure Technical Requirements.

Wrote Functional Test Cases for various modules to validate the customizations made to the reconciliation to suit the business needs.

Drive bug triage meetings and meet with program management and developers to drive important issues to resolution.

Created & executed Test Scripts & GUI Maps during Regression Testing.

Identified the Risks, Quantify and Prioritize and mitigate them to minimize the impact.

Prepared System Test Acceptance Report (STAR).

Environment: Window NT, UNIX, SunOS, Perl, Sybase, Rapid SQL, SQL, Java, JSP, Oracle, MS Office, Clear Quest, Rational Test Manager, Check Free tool, SAS tool, 508 Compliance Testing.

Education

M.Sc. Master of Computer Science

B.Sc. Bachelor of Computer Sciences

Contact this candidate