Software Development Engineer in Test

KRANTHI BYREDDY

Senior Software Development Engineer in Test (SDET)

Email:******************@*****.***

Phone: 813-***-****

Professional Summary:

●An accomplished professional with more than 15 years of experience in IT industry.

●Experienced in leading a team in either a small or big project

●Extensive experience in all phases of Software Development Life Cycle, Software Test Life Cycle and Defect Life Cycle with Agile and Waterfall methodologies.

●Experience in developing applications using Ab Initio, Informatica ETL Tools, Peoplesoft and Mainframes.

●Experience in testing different applications developed in Oracle CRM, PEGA,.Net, Java, Mainframes, Delphi andPeoplesoft.

●Substantial Automation experience using following automation Tools – Selenium Web driver, Test Complete and QTP

●Worked on different kinds of Frameworks such as Hybrid Framework, TestNG and Cucumber

●Expertise in ETL Testing(Informatica), Black Box Testing, GUI testing, Functional testing, Regression testing, Web Testing, Database testing (SQL, PL/SQL).

●Experience creating Ab Initio graphs and scheduling them using Autosys.

●Worked closely with Product Management and Development personnel to ensure testing is comprehensive.

●Working knowledge in using code repository tools - Tortoise SVN and continuous integration tools-Jenkins.

●Extensive experience in defect tracking and reporting systems like Rally, JIRA and Quality Center

●Substantial experience in working in Insurance industry, Mortgage Industry and Federal Projects.

●Excellent analytical, problem solving and documentation skills.

●Good Team player and having excellent Communication skills with strong understanding of Software Life Cycles and Software Testing Methods.

●Personal skills include Excellent Communication, strong sense of Organization and effective time management and have the ability to work in a team as well as independently.

Technical Skills:

Automation and RelatedTools

:Test Complete 12.x, Selenium webdriver 3.x, QTP 10.0,9.x Quality Center 10.0, 9.x, Rational Clear Quest,

Programming Languages

: Java,COBOL, C, C++, XML, WSDL

Databases

: Oracle 8i/9i, SQL Server, Sybase, DB2

ETL Tools

: Ab Initio 3.1, Informatica Power Center 9,8/7.1.2, PL/SQL

Mainframe Technologies

CRM Technologies

: JCL, CICS, TSO/ISPF

: Oracle E-Business Suite, PEGA

Peoplesoft Technologies

: Peoplesoft HRMS 8.3, SQR, People tools

Other Tools

: QMS, Bugzilla, Visual Source Safe 6.0.1

Scripting Technologies

: Unix, Jscript, HTML and VB Script

Operating Systems

: Windows, UNIX

Professional Experience:

Client: USPTO

Senior Software Development Engineer in Test (SDET) May 2015 - Present

Alexandria, Virginia

United States Patents and Trademark Office is a federal agency for granting U.S. patents and registered trademarks. USPTO PE2E collects and maintains information from patent applications as part of patent submission process. The internal PE2E application supports the examine process of the patent application.

Responsibilities:

●Leading a team and report daily progress to manager.

●Project is using Agile Scrum Methodology as SDLC model.

●Automated the PTAB application using Test Complete automation tool

●Report daily status during the Sprint in daily sprint meeting to Scrum Master.

●Used Rally to access the requirements written by Business, prepare test cases, test plans and log defects.

●Used PL/SQL to develop the ETL jobs in PTAB Data project.

●Configure the automation job in CICM Jenkins for test complete project in SVN.

●Automated CEDR application using Selenium webdriver.

●Execute the automation job in Jenkins for test complete project.

●Performed different kinds of testing such as UI Testing, Regression Testing and Integration testing.

●Performed database backend testing by verifying the data in database using SQL queries.

●Report detailed test cases, documented test scripts and test procedures to Test Manager.

Environment: PL/SQL, Test Complete 12, Selenium Webdriver, Rally, RQM, Req pro, Clear Quest, Toad, SQL Plus, Web (HTTP/HTML), Jenkins

Client :Fannie Mae, Herndon, VA Oct2014 to May2015

ETL Developer

Project Title :GFAS Project

Fannie Mae is one of the leading Mortgage companies. This is an ETL application maintaining the accounts of the Mortgage application. Ab initio is used for business logic implementation

Responsibilities:

● Developed and supported the extraction, transformation and load process (ETL) for the Data Warehouse from heterogeneous source systems using Ab Initio.

●Used Ab Initio GDE to generate complex graphs for the ETL process using Join, Rollup and Reformat transform components and executed using Co>Operating System.

●Scheduled Ab Initio graphs usingAutosys

●Used InformaticaPowercenter for creating mapping in LAI application which is source to GFAS.

●Made sure data coming from Informatica mapping is being consumed by Ab Initio graphs without any issues.

●Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions. Capacity of designing solutions around Ab Initio, with advanced skills in high performance in Ab Initio.

●Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Component like Filter by Expression, Partition by Expression, Partition by round robin, reformat, rollup, join, scan, normalize, gather, replicate, merge etc

●Involved in development of the transformations (Filters, de-duping, Joins, Reformat etc) using Ab Initio ETL

●Worked as production support for the GFAS application and supported the monthly execution cycle by looking into issues arising during the run.

●Supporting Business users by resolving their questions after verifying the code.

●Analysed and documented the complete Monthly cycle job flow and components.

●Worked on Autosys and Oracle upgrade.

●Performed the tuning of ETL process by means of maximizing the use of MFS, using lookup file instead of join if possible, removing unnecessary phasing, removing unnecessary components, making use of the indexes on the tables, etc. and thus to achieve an exceptional reduction of the total process time.

●Analyze business requirements and developed metadata mappings and Ab Initio DMLs.

●Able to interact effectively with other members of the Business Engineering, Quality Assurance, users and other teams involved with the System Development Life cycle.

●Involved in setting up of sandboxes and maintaining sandbox parameters.

●Unit testing and end-to-end system testing of the entire application.

●Support for user acceptance testing.

●Production migration and production support.

Environment: AbInitio 3.1, InformaticaPowercenter 9.5,9.1, EME, UNIX, Oracle 11g, Autosys 4.5

Client :Asurion

Senior Test Engineer

Sterling, VA Nov 2010 – Sep2014

Asurion delivers innovative extended service plans, also known as extended warranties, and customizable lifecycle solutions for the entire consumer ownership. It provides customer support solutions for retail and other clients mostly for electronics products.

Responsibilities:

●Worked on ADT, CG and ASM projects.

●Performed Data Analysis for ADT project by testing the data extracted using Informatica.

●Developed ETL Informatica mappings and other ETL Processes (DW Testing).

●Analyzed and tested Informatica Mappings with OLTP source data, staging and target data.

●Automated Servicebench application using Selenium Webdriver.

●Worked as a single point of contact for all Testing activities includes Functional testing, Integration Testing, System Testing for ASM project.

●Performed extensive webservice testing using SOAP UI and Fiddler.

●Performed integration testing extensively between 5 different systems.

●Interacted with business for BRD reviews and requirement clarification.

●Manual testing of Oracle E-Business Suite application and PEGA application which are used as main business tools of NEWcorp.

●Participated in Requirement gathering, review and analyze the requirements and design

●Wrote and executed test cases for System testing, UAT testing for enhancements in Oracle CRM and PEGA applications

●Wrote and executed test cases to test the interface and data transaction between Pega and Servicebench applications

●Wrote and executed test cases to test the interface and data transaction between Oracale CRM and Servicebench applications

●Track and report day to day activity/progress of testing progress to Manager

Environment: Seleniu,Informatica,Oracle CRM, Pega, JIRA, Oracle db

Client :Progressive Insurance Co.

Cleveland,OH Aug’ 2008 to Oct 2010

Senior Test Engineer

Project Title :PolicyPro

Project Description:

Progressive Insurance is one of the top 5 auto insurance providers in United States. It is mainly based into providing Auto insurance. Progressive insurance is developing an application called PolicyPro to provide better services to its consumers by totally replacing its legacy Mainframe system. I am part of the development of the project and currently working in production support for Tennessee state implementation.

Responsibilities:

●As a QA Lead responsible for assigning the work and monitoring the progress of project and report to Project Manager on day to day basis.

●Responsible to create Test Plans.

●Implemented the project in Agile Scrum Methodology as SDLC model.

●Understand the application and the current business process.

●Automated the application using QTP 10.0 and Selenium automation tools.

●Performed different kinds of testing such as UI Testing, Regression Testing and Integration testing.

●Performed database backend testing by verifying the data in database using SQL queries.

●Also worked in Future Requirements team where in new requirements are being implemented into the system.

Environment: C#.NET, XML, WSDL, QTP 10.0, QC 10.0, Team Track, MS SQL Server 2008/2000, DB2

Client :SafeAuto Insurance Company

Columbus, OH Aug’ 2007 to Aug 2008

Project Title : Web Project for Quoting and Policy Management

Sr QA Analyst

Project Description:

SafeAuto Insurance company is a direct-to-consumer auto insurance company which provides low cost insurance to the customers.The current project enables the customers to get an insurance quote online from their website. Their previous process required the customer to give a call to get a quote. This new web application enables the user to easily get a quote from theSafeAuto website. Project also involved re skinning the current website to make it sync with the new website. Also worked on Automating the existing Delphi application which was used for Policy Management by internals.

Responsibilities:

●Responsible for preparing the Test Plan and Test Cases.

●As a QA lead, responsible for assigning work to my team of 3.

●Understand the existing Delphi application and the current business process.

●Analyze the requirements for the new web application.

●Automated the application using Test Complete Automation tool.

●Participated in project meetings involving developers, BA and QA.

●Participated in End-to-End functional and Regression testing.

●Worked on testing Webservices which are used in the Delphi application.

●Used Test Complete automation tool to automate the SFDC application.

●Participated in status review meetings for status reporting.

●Performed different kinds of testing such as Regression testing, Integration Testing and System Testing.

●Reviewed the work done by the team before giving any signoff.

Environment: Test Complete, Java, Delphi, XML, Safeproject

Capgemini (Formerly Kanbay), India June 2006 to April 2007

Project Title : HSBC Bank – Peoplesoft HRMS

Client : HSBC Bank, IL

Peoplesoft Developer

Project Description :

HSBC has implemented a suite of PeopleSoft HRMS products as the standard software to replace some 78 plus legacy systems worldwide. This system is targeted to streamline Human Resources operations, through reduced operational costs and increased efficiency while deploying best practices. It is a web enabled system.This system has been implemented in approximately 80 countries. With such a large implementation, the system had to be rigorously and extensively tested for its functional quality and stability. Team’s responsibility was to perform testing on the upgraded programs.

Environment:Peoplesoft HRMS 8.3, SQR, COBOL, TSO/ISPF, JCL, DB2

Responsibilities:

●Understand the system functionalities/features.

●Analyzed system requirements and Functionality.

●Worked on upgrading PeoplesoftHRMS to the new version.

●Worked with Onsite team and gather requirements to develop.

●Fixing the defects reported by testing team.

Keane India Ltd June 2004 TO June 2006

Client: CSX Corporation, Jacksonville, FL.

Role: Mainframe Developer

Project Description:

CSX Corporation, One of the largest railroad transporting companies in the USA, located at Jacksonville, Florida with several business applications to maintain its day-to-day business.Offshore development center does the maintenance of problems, enhancement work and also provide 7 x 24 and 5 x 24 production support of the systems being maintained by Keane India Ltd

Responsibilities:

●Handling the communications with the onsite personnel at Jacksonville, USA, for analysis and implementation of work requests

●As a Team Member involved in Analysis, Coding, Testing, Implementation and Documentation.

●Production Support: Working on 7 x 24 production support that impacts the regular business. Working on Break-fixes and suggest the customers.

●Working on Adhoc requests: Working on adhoc requests like downloading the messages, creating a new report and likewise.

●Conversion Project : Worked on COBOL to Enterprise COBOL conversion

Environment:IBM Mainframe, OS/390, IMS, DB2, COBOL, CICS and JCL.

Contact this candidate