Divija ChowdaryVemana

Summary:

• Over 8 plus years of experience in software testing which includes Test Plans, Test Scripts, Test Cases, Test Scenarios, test Execution based on business requirements and functional requirements for both Manual and Automated Testing
• Experience working in Banking and Financial, Insurance , Health Care Domains
• Worked in an Onsite and Offshore model
• Familiar with Agile Methodology - Scrum, V Model
• Expertise in testing Distributed Web-Based Applications, Client-Server, .NET applications and FICO modules, Service Oriented architecture (SOA)
• Involved in Complete Software Development Lifecycle (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation
• Expertise in UML through the software development that includes Use Case diagrams, sequence diagrams, class diagrams, activity diagram etc.
• Experience in testing on Enterprise wide applications with multiple databases
• Testing of Client-Server and database projects on Windows and UNIX Operating Systems
• Ability to understand and reviewing the Functional and Software Requirements Specification documents.
• Extensive experience in developing Test Traceability Matrix and Gap Analysis
• Sound knowledge of  Regression, System, Integration, Functionality and User Acceptance Testing
• Excellent working experience with Mercury Win Runner, QTP, Load Runner, HP -Performance Center, Rational Functional Tester, Rational Performance Tester
• Working experience with DB2, Oracle, MS SQL Server, etc.

·        Expertisein writing and executing SQL – DDL, DML statements for checking the validityand integrity of the data in various databases such as Oracle 9i/10g/11g,MySQL, Microsoft SQL Server etc. to perform back-end-testing.

• Expert in Using Quality Center(Test Director) as repository for maintaining test cases, execution and tracking the defects
• Extensive experience in Team Foundation Server
• Experience in defect tracking tools like Quality Center (Test Director), Clear Quest, Bugzilla.
• Well versed in analyzing test management analyzing test results bug tracking reports on various testing activities
• Good knowledge on test coverage analysis and Ability to mentor teams to meet the deadlines
• Efficient in interacting with developers and other team members to ensure high quality software is delivered. Ability to work efficiently as Individual and in a Team.
• Committed, and Result Oriented with a quest and zeal to learn new technologies and undertake challenging tasks.
• Excellent ability to manage resources in mission critical, high-pressure projects.
• Excellent communication and interpersonal skills.

Technical Skills:

Testing Tools                            :QTP, Load Runner, HP- Performance Center, Rational   Functional Tester,

                                                 Rational Performance Tester, Win-Runner,

Bug Reporting Tools                 : Quality Center (Test Director), Bugzilla, RationalClear Quest.    

Programming Languages           : C, C++, VB Script, Win Forms, ADO.NET, Java,

Platforms                                  :Windows 2003 Server/98/2000/NT/XP/Vista, Red Hat Linux 3.0, MS-DOS

Database                                  :Oracle 10g /9i / 8.x, MS-SQL Server 2008/2005 MS Access 

Web Technologies                     : VBScript, HTML, XML

Web/Application Servers           : Apache, BEA Web Logic

Network Protocols                     : TCP/IP, FTP, HTTP, SMTP, UDP

Other Tools                               : TOAD, MS -Office Suite, MS- Visio,VMware Workstation, UML, Putty.

CardinalHealth, Ohio, USA                                                                           Jun’11-Nov’11

Offshore/onsitecoordinator/ Senior QA Analyst

Providehospital customers a cohesive acute care ordering solution tailored to theirunique needs which include: Google-like search capabilities, category browsing,linked item recommendations, vendor portlets, order tracking, routedelay/outage notifications, improved product availability information, enhancedback order management, improved inventory management and better integrationwith 3rd party hospital applications.

Specificallyfor the mobile space the requirement is provide hospital customers a mobileaccess to key Order Express functionalities from a mobile device includingrugged devices (MC 55/MC75), Smartphone’s (Android and iOS) and Tablets(Android and iOS); users should have access to the following capability:Ordering, Shelf Labeling, Receiving, Inventory

Responsibilities:

•         Ihave been the point of contact for the R&S GUI team for all issues onTesting.

•         CreatedData driven tests, reviewed and executed test cases in QC.

•         Developedand executed different SQL Queries and retrieved data’s from the NLR Databaseto prepare the Evidence files.

•         Involvedin Requirement Analysis, Developed Test Cases and Scenarios in QC. 

•         SupportedSystem, Integration and Deployment Test Planning and Test Execution for alldevelopment efforts.

•         Responsiblefor maintaining document template libraries and internal project documentation.

•         Interactingwith all levels of the organization.

•         Managesverification and validation activities for all Production modificationsincluding projects, releases, and changes. Assessment of quality based results verification and validation andmaking appropriate recommendations.

•         Functionalresponsibilities included performing Smoke Testing, GUI Testing, Systemtesting, Database testing, Usability testing, IST Testing, Security testing,Interface testing and Regression Testing.

•         Attendedthe meetings and walkthroughs with CMS, development team and BA’s for theapplication work flows issues, new release and updates. 

•         Designedand developed SQL queries to test back end

•         Involvedand Integration Testing of Informatica jobs, Batches and the Target Data

•         Verifiedand validated transformations in ETL mapping

•         Preparedand executed scripts for process automation and system logging &monitoring.

•         Providedmanagement with metrics, reports, and schedules and was responsible forentering, tracking bugs.

•         VerifiedTracked and Reported defects and classified based on Severity and Priority.

•         Reviewedcomputer logs (UNIX logs & Shell Scripts), reported program processingerrors.

 Environment: Quick Test Pro 9.5,  Oracle, Quality Center 9.0, TFS, VisualBasic.NET, Java     Script, Java, J2EE,JSP, Servlets, JDBC, EJB, .Net, C++, Java Script, HTML, DHTML, XMLJava/J2EE  Win API, ASP.NET 2005, WindowsNT/2000 & DB2, Unix, TOAD.

FifthThird Bank, Cincinnati, Ohio, USA                                                                           Jun’11-Nov’11

Offshore/onsitecoordinator/ Senior QA Analyst

FifthThird Bank is one of the best financial banks in USA and is well known for itssuperior services in multiple fields.

UPSand the COD processor will be required to exchange data and information thatwill be integrated into various platforms. File deliveries will have schedules and SLAs defined with a potentialprocess improvement item to implement acknowledgment file processing. Fifththird bank is working with UPS to deliver Transaction flow of the cheques andPayments and also tracking   the shipperdetails in the Data Base and also manage the process of the flow from CODProcessor, Vector sort and Direct Lock Box to the UPS Driver Notifications forthe End of the day processing data for UPS

Responsibilities:

•         Ihave been the point of contact for the R&S GUI team for all issues onTesting.

•         CreatedData driven tests, reviewed and executed test cases in QC.

•         Developedand executed different SQL Queries and retrieved data’s from the NLR Databaseto prepare the Evidence files.

•         Involvedin Requirement Analysis, Developed Test Cases and Scenarios in QC. 

•         SupportedSystem, Integration and Deployment Test Planning and Test Execution for alldevelopment efforts.

•         Responsiblefor maintaining document template libraries and internal project documentation.

•         Interactingwith all levels of the organization.

•         Managesverification and validation activities for all Production modificationsincluding projects, releases, and changes. Assessment of quality based results verification and validation andmaking appropriate recommendations.

•         Functionalresponsibilities included performing Smoke Testing, GUI Testing, Systemtesting, Database testing, Usability testing, IST Testing, Security testing,Interface testing and Regression Testing.

•         Attendedthe meetings and walkthroughs with CMS, development team and BA’s for theapplication work flows issues, new release and updates.

•         Validatedthe Metadata changes and database schema changes during production roll-out.

•         SupportedQA Team engaged in all facets of quality control within demanding 24x7Environment.

•         Ihave been the main point of contact for the entire Development team for allissues on Testing.

•         Participatedin daily scrum to triage the defect tracking process and tracked defects.

•         Involvedin Requirement Analysis and Requirement entering in QC.

•         Developmentof Test cases and Scenarios.

•         SupportedSystem, Integration and Deployment Test Planning and Test Execution for alldevelopment efforts.

•         PrepareLOE, Test Environment requirements, identify resource/skills and test schedulefor all three project worked so far.

•         Creationof Requirement Document based on the Application.

•         DevelopedSQL Queries to query the database to test the back end process of theapplication

•         VerifiedTracked and Reported defects and classified based on Severity and Priority.

•         Createdthe performance scripts to load the test data manually

Environment:Quick Test Pro 9.5,  Oracle, QualityCenter 9.0, TFS, Visual Basic.NET, Java    Script, Java, J2EE, JSP, Servlets, JDBC, EJB, .Net, C++, Java Script,HTML, DHTML, XML Java/J2EE  Win API,ASP.NET 2005, Windows NT/2000 & DB2, Unix, AQT.

OldNational Bank, Carbondale, IL                                                                                 Feb’10 – Dec'10      Senior QA Analyst

OldNational Bank is one of the biggest financial organizations offering variety offinancial products ranging from Credit Cards, Mortgages, Brokerage, PersonalBanking and Loans. Project focus was on web-based application for brokerage andcredit cards. Second phase of the project was to implement the process forverification of Check-acceptance according to the User accounts using the checkprocessing software of Old National bank.

Responsibilities:

•         Analyzedsystem requirement specifications and developed test plans, test cases to coveroverall QA System Testing.

•         AnalyzedPortfolio Management, Investment Planning, Financial Planning, Customer Supportand Investment Strategy Tools and processes.

•         Prepareddetailed test plan and test strategy for Performance testing for Bank AccessOnline

•         DevelopedTest Plan that included the scope of the release, entrance and exit criteriaand overall test strategy

•         Createddetailed Test Cases and Test sets and executed them manually and also byautomation tool.

•         Definedtest strategies, planned and managed all testing activities includingfunctional, UAT, and regression testing.

•         UsedQuality center to document the requirements, Test Plan and created traceabilitymatrices for the requirements.

•         Developingbuild stage Data stage Parallel Jobs using Data Stage Designer to developprocesses for extracting, cleansing, transforming, integrating, and loadingdata into data warehouse.

•         Responsiblefor source system analysis, data transformation, data loading and datavalidation from source systems to Transactional Data system and WarehouseSystem

•         Workedon Extracting Data from DB2 and load the data into Teradata

•         Createdthe Deployment notes along with the Local SCM team and released the Deploymentinstructions to Application Support

•         ExecutedSQL queries to validate the data before and after data conversion process

•         UsedSQL scripts to verify the integrity of the database particularly whilevalidating the Session store and Profile Store records.

•         Designedand developed SQL queries to test back end

•         Involvedand Integration Testing of Informatica jobs, Batches and the Target Data

•         Verifiedand validated transformations in ETL mapping

•         Preparedand executed scripts for process automation and system logging &monitoring.

•         Providedmanagement with metrics, reports, and schedules and was responsible forentering, tracking bugs.

•         VerifiedTracked and Reported defects and classified based on Severity and Priority.

•         Reviewedcomputer logs (UNIX logs & Shell Scripts), reported program processingerrors.

Environment:  Windows 2000/XP, UNIX, UML, Quality Center,Microsoft Excel VBA

CharterOne Bank, Cleveland OH                                                                                   Dec '08 - Jan' 10

QALead

Theapplication developed  to provide thecustomers to access Account details like the Checking and Saving Account ,create and update mortgage, loan, insurance and personal information; can makethe payments directly from the checking or saving accounts, perform moneytransfer, schedule bill pay facility, get credit scores, enroll for credit,theft and identity protection plans, enjoy the spend tool analyzer. They couldalso view details, Loan history, Tax and interest information, and order theMortgage documents on-line. The Account number or Social Security Number andPIN number enabled the customer to get connected to their account informationand enabled the customer to perform these tasks

Responsibilities:

•         Reviewedthe business requirement document (BRD) and the functional requirement document(FRD) and formulated the test plan.

•         UsedRecovery Scenario manager to handle unpredictable events and generic errorhandling.

•         Analyzeddata requirements along with database administrators.

•         Createdsmoke test cases for the end to end test process of the successful and failurepath.

•         Designs,creates, modifies and validating ETL mappings incorporating business rules.

•         Validatedall the ETL code according to the business rules and relational datarequirements.

•         Wroteand executed complex SQL queries, procedures and triggers to validate back-enddata.

•         Testedthe integration of data such as customers, employees, relationships with HoganSystems for all applications.

•         Enteredthe bugs in Quality Center and kept a constant trail of the bugs.

•         Performedmanual and automated testing of the functionality of different components ofthe product which involves reading of registry entries, file objects etc.

•         Developedand executed UNIX shell scripts to determine the reports generated and theirformats.

•         Validatethat the ETL process runs multiple times, against the same data set ensuringthat it will produce same result.

Environment:Java, Quality Center, MS SQL Server, XML, Internet Explorer, UNIX, MS-Office,Clear Quest

BostonMedical Center, Boston, MA                                                                                 July’06-Nov’08                                       Sr.QAAnalyst

BostonMedical Center is one of the best hospitals in USA and is well known for itssuperior services in multiple fields. The project, Easy Chart was an EHRapplication which allows the user to handle tasks like storing and editing thepaper documents in digital format, maintain patient charts (Medicine history,FMHX, PMHX, Routine Medications, and Insurance etc.), integrate Lab resultswith patient’s diagnosis reports and provide real time updating of centralserver database. The software also handles various healthcare plans,efficiently adopts the changes made in those plans and handles healthcareclaims. It was a client-server application which encrypts the communication toavoid VPN. It has Care Tree which records encounters (patient progresshistory), tests and other records.

Responsibilities:

•         CreatedTraceability metrics mapping Functional and Business Requirements with TestCases.

•         DevelopedSystem Test Cases to Testing Checklist Requirement and delegation of modulewise system testing

•         DevelopedStrategic Plan documents, Project Management Policies, Standard Engineeringprocess and Metrics Implementation guide.

•         DevelopedQA methodologies by coordinating with QA Lead.

•         Conductedwalkthroughs and reviews with designers and developers

•         Prioritizedand coordinated the testing activities with other QAs.

•         Developedthe Consumer portal of a banking website that allows users to interact with thesystem. Website was written in VB.NET / C# and consumes both SQL storedprocedures and web service calls in order to communicate with back-end systems

•         Reviewedthe requirements and use case diagrams to write test cases and test plan.Developed System Integration test plan, test scripts using business, functionaland system requirement documents.

•         DesignedIntroduced the Agile SCRUM process for the Risk Data team and utilizedMicrosoft Team Foundation Server (TFS) to manage the team's softwaredevelopment

•         Dthe test cases for the various like Patient Profile management module which isa Java based application and its integration.

•         PerformedFunctional and Integration testing (manual and automated) for modules andconducted Regression testing.

•         Performedthe Smoke, Functional and Regression Testing for modules using QTP scripts.

•         Wroteautomation scripts in VBScript to check the updating of the Medicareinformation database and Healthcare Spending Accounts.

•         Performedthe compatibility testing for different operating systems and operatingenvironments.

•         Experienceon backend testing with TOAD Tool for SQL Queries

•         WroteSQL Statements to extract Data from Tables and to verify the output Data of thereports.

•         WroteSQL queries and ran SQL tracings to debug stored procedures and DatabaseIntegrity Testing.

•         Documented,tracked and communicated test plans, test results, analysis and unresolved problems.

•         Plannedthe load using Task distribution diagram, Transaction profile and consideringcurrent and future customer base (input from SME) of the hospital.

•         Reviewedcomputer logs and reports to identify application processing errors andpossible improvements.

•         Responsiblefor entering and tracking the bugs in Rational Clear Quest to resolve the bugsin timely manner.

Environment:Java, Rational Clear Case, MS Office, UML, Risotto Facets, Windows, RationalClear Quest, Marcos , Linux, Load Runner 9.0, Oracle 10g, Team Foundation Server, QTP, QC, VB.Net

RichterAssociates, Beachwood, OH                                                                                          May'05-June'06

Sr.Quality Engineer / Off-Shore Team Coordinator        

RichterAssociates financial software is implemented to effectively manage the financeslike paying bills, invoicing customers, tracking sales tax and more. In thisversion, Richter Associates Information Centers was implemented to summarizekey information about the customers, vendors and provides facility to link allthe financial information and provides Query interface from customer or vendorname to orders, invoices, payments and even shipment information. 

Responsibilities

•         Asa Quality Test Engineer was responsible for creating Test Plans, TestProcedures, Use cases and Test cases with reference to Business Requirements,Design Specifications and Functional Requirements.

•         Managedand Coordinated Off-Shore Testing Team involving various Testing phases of theProduct Development.

•         Workedclosely with SQA Leads in compliance to CMM Process Model.

•         Involvedin performance testing, security testing and database integrity testing byexecuting SQL statements.

•         Analyzedproduct requirements, functional specifications and technical specificationsfor accuracy and feasibility.

•         Performedthe Smoke, Functional and Regression Testing for modules using QTP scripts

•         Extensivelyused Output and Checkpoint for verifying the UI properties and values using QTPVB scripting

•         WroteSQL Statements to extract Data from Tables and to verify the output Data of thereports.

•         WroteSQL queries and ran SQL tracings to debug stored procedures and DatabaseIntegrity Testing.

•         ExecutedSQL queries to validate the data before and after data conversion process.

•         PerformedGUI, Functionality, Security, Integration and System testing of the applicationand investigated software defects discovered during the test cycle and managedtest case development and execution using Team track Testing Tool.

•         Createdextensive test plans detailing environments, variables, controls, exitcriteria, objectives, dependencies and overall test strategy on

•         Tooklead role in all change, design, usability, and specification reviews.

•         Executedall Test cases involving functional, positive, negative, load, stress asoutlined in the test plan.

Environment:Windows 2000, Red Hat Linux 7.2, Mac OS, JAVA, J2EE, XML, PL/SQL, UNIX ShellScript, BEA’s Web logic Server 9.2, Tomcat 4.1, XML Spy, Toad, Safari Browser,Rational Rose, Oracle 9i, QTP, Team track, ClearDDTS, Selenium, , RationalClear case 4.2

Nortel,Inc., Richardson, TX                                                                                                Mar'04 - Apr'05

Sr.QAEngineer

Nortelis a leader in delivering communications capabilities that enhance the humanexperience, and is involved in developing next-generation technologies, forservice providers and enterprises, span access and core networks, supportmultimedia and business critical applications, and help simplifying the networkand connecting people with information.

Involvedin the Digital Home solution project which provides residential usersintegrated multimedia services over the existing infrastructure helping thesubscribers to build a state of the art, intelligent and entertaining digitalhome poised to change their lifestyle. The Solution provides a softwareplatform that needs to be customized and integrated on Digital Home Devices.The solution also works seamlessly with Service Partners and is developed inSOA framework that can seamlessly work with Service Partners that expose theirAPI’s.

Responsibilities

•                     Reviewedthe Business Requirements Document and Technical Specifications.

•                     Involvedin development and execution of test cases.

•                     Involvedin performing different types of testing, such as GUI, Functionality,Regression and User Acceptance Testing during the Testing Life Cycle.

•                     Performedthe Smoke, Functional and Regression Testing for modules using QTP scripts

•                     Extensivelyused Output and Checkpoint for verifying the UI properties and values using QTPVB scripting

•                     Performedmanual testing of the application GUI with regard to layout, usability andboundary conditions.

•                     Successfullytested Personal Media Manager which allows consumers to stream and share theirmedia regardless of source or location and its interaction with digital mediaplayer applications such as iTunes and WMP 

•                     Validateds/w builds for external delivery including the preparation of release noteswith the assistance of development team                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          

•                     Extensivelytested the Media and Sharing functionality of Digital Home Solution

•                     Involvedin testing different services available on Digital Home Solution such as VoD,Internet Radio Service and Home Surveillance etc.

•                     Trackeddefects and reported them using QC

Environment:HTML, ASP.NET, C#, Web Services, Test Director, Windows XP, MySQL, Win Runner,UNIX, Shell Scripting

Vibrant5Inc., San Ramon, CA                                                                                                    Aug'02- Feb'04

QAEngineer

 Vibrant5 is a customer focused, peopleoriented & process centric company is on developing vertical specific andbusiness centric applications.Vibrant5 is based in San Ramon, California.Working as a QA Engineer for the product Deals2Scan a Deals Engine. Thisproduct Delas2Scan emphasis on passing the benefits either to client orconsumer. Having understood and seen how various products in the market weren’table to fill in direct consumer/customer need.

•         Responsiblefor writing Test Plan, Test cases, for product optimization and productitemization for the Deals Engine and analyze requirements

•         UsedTest Director to write and execute test cases and reporting defects.

•         PerformedPerformance/Load tests and analyzed performance with Load Runner.

•         Analyzingtests using Test Director pertaining to the test scenarios on the transactionbased tests and the environments.

•         Involvedin modifying scripts and working with web enabled user interface componentslike Registration Web Templates association of applets with web templates

•         AutomatedIntegration tests using Win Runner extensively for the purpose of GUI andFunctionality testing

•         Involvedin the whole Planning of Test Conditions, Test Data and expected results forRegression, Integration, Stress and User Acceptance Testing.

•         UsedClear Case as Version Controller.

•         Wroteand modified VB scripts for Regression Testing with Win RUNNER

•         PerformedGUI check, Bitmap Check and Text validation Checks with Win Runner.

Environment:Test Director, QTP, SQL Server, Oracle, Windows 2000 server.

Bachelor of Technology

Electronics andControl Engineering, JNTU University, India                          Jun2003