Test Cases Manager

Kalyan Chakravarthy Dandangi

Summary:

Ï** years of professional experience in the Software Analysis, Design, Quality Assurance and Testing (Manual & Automated) of Web Based, Stand alone and Client-Server Applications.

ÏExperience with Automation Tools Winrunner, SilkTest, QA Load & RationalRobot, RQM/RTC, HP Quality Center & Quick Test Professional, Cucumber, Gherkin & Ruby, Microsoft - TFS - Test Manager (MTM), Micro Focus - Test Partner, QA Load.

ÏExperience in testing Accounting/Auditing/Finance/Banking, HRMS, Telecom, Insurance, Retail Chain and enterprise solutions under Windows & Unix environments.

ÏExpert in all QA related activities, designing Test Framework, writing Test Plans, Test Scenarios, Test Cases and Test Scripts.

ÏLead the Testing and Upgrade efforts of Oracle Financials from R10 to R12. Worked with all concerned Business users for adequate test coverage.

ÏExtensive working experience in Functional, Regression, System, User Acceptance Testing.

ÏExperience with MS SQL, Oracle, Netezza, Vertica and Teradata for Database Testing with emphasis on Extraction, Transformation and Loading of data into Data warehouses.

ÏExperience with Software Development life cycle and Quality Standards.

ÏExperienced in preparing the Test Data based on Test scenarios and the Expected Results.

ÏExperience with executing and debugging Unix/Shell/Perl scripts.

ÏFamiliar with Software Development Life Cycle and SEI-CMM, ISO Standards.

ÏUnderstand new ideas and technical concepts quickly, converting them into meaningful results.

ÏExcellent communication and documentation skills.

ÏA skilled problem-solver and an efficient team player.

ÏAbility to Mentor and Lead the team members towards achieving the organizational goals.

Technical Skill set:

Environment : Windows NT/95/2K/2K3/XP, Windows 7, Sun Solaris 7 and UNIX.

Languages : Java, C, HTML, SQL, XML, TSL, 4TL, Ruby.

Web/App Servers : Web Logic 5.0/7.x/8.1, Apache Tomcat 3.x/4.1, Websphere 4.x/5.x

Databases : Oracle 7.x/8/8i/9i, MS-SQL Server 2000/2008, Redgate SQL Compare 6, SQL Data Compare 5, Netezza, Teradata, Vertica.

ETL Tools : Business Objects 5.0/6.0, Informatica Powercenter 8.1.1, Pentaho.

Testing Tools : Winrunner4.5/5, SilkTest 5.0/6.0, Rational Robot, Rational Test Manager, Test Director, QA Load & Astra Quick Test, HP- Quality Center, QTP, Rubymine, Cucumber, Gherkin, Microsoft - Test Manager (MTM), Micro Focus - Test Partner, QA Load.

Other Tools : MS-Office, MS-Project Plan, Groove Virtual Office V 3.1a, GAAIT (Global Auditing and Accounting Information Tool V3.7), MS-Sharepoint, Norton Ghost, OpenOffice, VMWare, FileZilla, XML Spy3.5/2004, CVS, VSS, SVN Tortoise, WinSQL, Webfocus, ILOG 6.7.3 /7.0 (RTS/RES), Rational ClearCase, DB Visualizer, Toad, Oracle SQL developer, Visual Studio 2010/2012, Team Foundation Server, Cognos.IBM Rational Suite.

Bug Tracking tools : Serena TeamTrack, Rational ClearQuest, Scarab, RITS, Bugzilla, Track Record, HP-Quality Center, MS-TFS (Team Foundation Server), RQM/RTC

Education:

Bachelors in Technology (Mechanical Engineering)

Masters in Business Administration

Advanced Diploma in Computer Applications and Programming

Professional Experience:

#2 State of Ohio (Department of Administrative Services for ODM) Columbus, OH Feb 2016 till date

#1 State of Ohio (Bureau of Workers’ Compensation) Columbus, OH

QA Architect – Sr. Consultant May 2012 – Jan 2016

IT Enterprise Solutions Management (ESM)

Ohio’s workers’ compensation system is made up of two parts: BWC, which is the administrative and insurance arm of the system, and the Industrial Commission of Ohio (IC), which is the claims adjudicative arm. The IC hears and decides contested workers’ compensation claims and issues. The governor appoints the three-member commission and the Ohio Senate confirms those appointments. One member represents labor, one represents employers and one represents the public. BWC provides insurance to about two-thirds of Ohio's workforce. The remaining workers receive coverage directly through their employers. These companies are part of a self-insurance program for large and financially stable employers who meet strict qualifications set by BWC. ESM is the department which develops and maintains all the It products & tools required for BWC to perform all its IT functions.

Responsibilities:

ÏTook active part in Release & Test planning meetings, weekly departmental meetings, and requirement gathering sessions, Estimation meetings.

ÏReviewing Requirements & Functional specifications and approving them.

ÏMaintenance of test repository with test scripts, test data/files, and scenarios.

ÏDocumenting and translating high level test scenarios into test cases.

ÏLogging, Maintaining and reporting the test execution results, to analyze & generate reports.

ÏExtended Production support for all BWC applications.

ÏLogging, Maintenance and reporting of Defect life cycle in TFS/MTM.

ÏExtended Production support for all BWC applications. Lead QA efforts for Oracle Financials upgrade from R10 to R12. Performed system testing and facilitate UAT with Business users.

ÏFacilitated meetings and brain storming sessions and User Acceptance testing with Business partners Customers for Web, Safety & Hygiene, Video Library, Medical Billing, Claims & Policy subject areas.

ÏLead & Designed QA processes for Core Reporting Project and Facilitated UAT with Business users/Customers for Reporting Project.

ÏDocumenting and reporting the QA & Testing procedures to ensure quick resolution of issues.

ÏCoordinating the testing efforts with several financial business sources.

ÏUsed and maintained the test scripts in MS Test Manager & Micro Focus Test Partner.

ÏTook active part in developing Coded UI scripts in Visual Studio/TFS and execute them in MTM.

Environment: VB.Net, Microsoft Team Foundation Server (TFS), MS Visual Studio 2010/2012, Micro Focus Test Partner, Microsoft Test Manager (MTM), Oracle, Oracle Financials R10/R12, SQL, MS SQL Server 2008, Trello, Test Partner, QA Load, VM Ware, Hyperion reports, Pentaho, Cognos10.0.2, Vertica.

Nationwide Inc. Columbus, OH

Sr. QA / Lead Test Analyst Sep 10 – Apr 12

Projects: DCDirect (Retirement Plans - Public Sector)

Keynote (Retirement Plans – Private Sector)

The DCdirect program has been positioned to deliver competitive advantage, operational efficiency and reduced expenses through a new integrated Retirement Plans platform that will better support plan sponsors, participants, plan administrators and internal operations of Nationwide Financial.The DCdirect program is a multi-year effort focused on the consolidation of major record keeping systems within the Retirement Plans business with major benefits coming from cost reduction, cost avoidance and plan retention Several key public sector plans today are demanding new record keeping solutions and have included DCdirect technology commitments in recent contract renewals. Key capability within our current legacy platforms is less than our competition.

DCdirect will not only accomplish consolidation benefits for Nationwide Financial, it will offer new capability for customers through the Internet and in call centers.

Lean software development organization recognized as one of the first to achieve CMMI®Level 3 while leveraging Agile/Lean practices, and within a six months period.

Responsibilities:

ÏParticipated in Iteration planning meetings, Daily stand up meetings, JAD sessions, Estimation meetings, Release planning meetings, Paired programming, Show and tells, and Retrospectives.

ÏReviewing Requirements & Functional specifications and approving them.

ÏMaintenance of test repository with test scripts, test data/files, and scenarios.

ÏUpdating and Converting the existing test scripts into Cucumber/Gherkin format.

ÏLogging, Maintaining and Reporting the test execution results, to analyze & review reports.

ÏMaintenance of Defect life cycle in Quality Center.

ÏPerformed extensive backend testing on Oracle databases.

ÏMentoring the team and leads tests of software to ensure proper operation free from defects.

ÏDocumenting the QA & Testing procedures to ensure timely resolution of complex problems.

ÏCoordinating the testing efforts with several financial business sources.

ÏUsed and maintained the test scripts in QTP and Ruby.

ÏRetesting production issues and extending the production support to the build & run teams.

Environment: Java, Rational Team Concert, Rational Clear Quest, Clear Case, HP Quality Center, QTP, Rational Test Manager, Oracle, SQL, Exceed, Toad, Ruby/Cucumber/Gherkin, WebSphere reports.

Nationwide Finance, Nationwide Inc. Columbus, OH

Sr. QA Lead Jul 08 – Sep 10

Projects: FIBO & FIL/FIRM

FIBO Finance Integrated Back Office is a suite of ETL process which follows several logical steps until Data Loaded to the financial data warehouse & data mart from multiple sources

FIRM/FIL Financial Integrated Rules Management / Finance Integration Layer is a large project which is part of the Framing Controllership program. Cafe is Finance IT's business rules engine. This system stores and processes through all the business rules for the Nationwide Financial and Insurance subsidiaries. This business rule engine contains two sets of rules, Set of common rules implied for all interfaces/subsidiaries and Set of interface specific rules implied to individual interface/ subsidiary.

Responsibilities:

ÏAnalysis, Requirements gathering & Functional specifications review.

ÏMaintenance of test repository with test scripts, test files, and scenarios.

ÏPerforming System, Integration Testing and Performance Testing.

ÏFacilitating and Coordinating the User Acceptance testing with several business partners.

ÏLogging, Maintaining and Reporting the test execution results, to analyze & review reports.

ÏDocumenting and reporting weekly progress and defect summary report.

ÏExecuting shell and perl scripts to invoke all the informatica logical steps (load jobs).

ÏVerify Unix logs between each load jobs.

ÏInterface data files were manipulated and moved within various Unix environments.

ÏMaintenance of Defect life cycle in Quality Center.

ÏExecuted extensive ETL processes to load data into ERP/Peoplesoft modules and validate them on backend layer Teradata.

ÏPerformed backend testing on Oracle & Teradata databases.

ÏExtensively used queries and data manipulation for testing various scenarios.

ÏMentoring the team and leads tests of software to ensure proper operation free from defects.

ÏDocumenting the QA & Testing procedures to ensure timely resolution of complex problems.

ÏReports progress on problem resolution to management.

ÏCoordinating the testing efforts with several financial business sources.

ÏAutomated and maintained the test scripts in Quick Test Professional.

ÏExecutes and coordinating test configuration management activities for complex work efforts.

ÏRetesting production issues and extending the production support to the build & run teams.

Environment: Java, Agile methodologies, Ilog 6.7.3 / 7.0, Quick Test Professional, Oracle, SQL, Teradata, Unix/Shell/Perl, Peoplesoft, Hyperion, Informatcia, Exceed.

Nationwide Better Health, Nationwide Inc. Columbus, OH

Configuration Manager & Test Coordinator Oct 07 – Jun 08

Project: Data Foundation – Data Analytics & Reporting

Description: Nationwide Better Health is seeking a partner for the development and population of the Common Information Model and Data Warehouse. Nationwide Better Health Data Foundation Project is aimed at providing consolidated data to support analytical reporting over a wide range of disparate systems and applications with the help of an enterprise data warehouse. The first phase of this project will require ETL processes to be designed, developed and tested for defined subject areas.

Responsibilities:

ÏInvolved in Reviewing Requirement artifacts to come up with Test Conditions/Scenarios for both Data warehouse and Reporting components of Data Foundation Project.

ÏPlayed the role of Configuration Manager and coordinated the Build and Release process.

ÏDesigned and implemented CM Plan, CR forms and Transmittal forms as part of Configuration Management Processes.

ÏInvolved in Code Deployment process and Code Deployment testing.

ÏDefects reporting and Validation is handled through Track Record tool.

ÏExtensive utilization of queries to perform back end testing on Netezza and oracle databases.

ÏPeer reviewed strategy documents for Development and Testing before signing off on them.

ÏDaily and Weekly metrics summary reporting to management teams.

ÏPlayed a significant role in Configuration Management with CVS administration.

ÏCoordinated and Managed the Test team in data warehouse and reporting testing efforts.

ÏWorked closely with Development / SAs in Identifying, replicating and resolving the issues.

Environment: Informatica 8.1.1, WinSQL 6.0, Unix/Perl, WebFocus, MS-Sharepoint, MS-Office, MS-Project Plan, XML, Netezza Performance Server, CVS, Win-Merge, Track Record, HP-Quality Center.

Ernst & Young Cleveland, OH

Sr. QA Lead / Analyst Jun 06 – Sep 07

Project #1: GAMx (Global Audit Methodology Execution) Jun 06 – May 07

Description: GAMx is the next iteration of software to aid and streamline the firm’s Service Delivery Process. GAMx will aid in documenting the audit process in accordance with the firm’s Global Audit Methodology (GAM). This tool is intended to be operable in both the connected and disconnected states and is intended to be a significant upgrade from existing tools utilized by the audit professionals.

Responsibilities:

ÏReviewed and Analyzed Requirement artifacts to write Test Conditions/Scenarios for both LOB (Line of Business-Client App) and ELM (Engagement Life Cycle Management-Web Portal).

ÏRepresented QA team in Design Review meetings and JAD sessions.

ÏInvolved in Weekly Build Acceptance testing, Functional and Regression testing cycles.

ÏDefects reporting and Validation is handled through TeamTrack tool.

ÏWriting, Peer reviewing, Approving and Executing the test scripts.

ÏDaily and Weekly metrics summary reporting to management.

ÏBeen a significant part of Configuration Management team and Signoff for GAMx v3.0.

ÏValidated the GALRT scenarios and Assisted in Performance testing for GWAN team.

ÏWorked closely with Development / SAs in replicating and resolving the issues.

ÏPerformed patch testing for the V1.0 and V3.0 releases, Regression for V3.1 release.

Environment: Asp.Net, MS-Sharepoint, MS-Office, MS-Project Plan, XML, XSL, Groove Virtual Office 3.1a, GAAIT 3.7, Oracle, SQL Server 2000, Norton Ghost, TeamTrack 6.0

Project #2: Global JE Analysis v1.2 Jun 07 – Sep 07

Description: The Journal Entry (JE) Analysis Global Solution has been created to assist audit teams in meeting the needs of the E&Y Global Audit Methodology (GAM) and international/U.S. auditing standards (e.g., ISA 240 and SAS 99) relating to General Ledger (GL) journal entry testing. The JE Analysis Global Solution defines a standard E&Y approach to testing and analyzing GL journal entries. This solution has become increasingly critical to the business and plays a significant role in supporting the audit staff in the field.

Responsibilities:

ÏReviewed and Analyzed Requirement artifacts with BAs to write Test Conditions & Scenarios.

ÏRepresented QA team in Design, Change Control and Enhancements sessions.

ÏPerformed Bi-weekly Build Acceptance testing, Functional and Regression testing cycles.

ÏDefects reporting and Validation is handled through Serena’s TeamTrack tool.

ÏWriting, Peer reviewing, Approving and Executing the test scripts for v1.2.

ÏCollection of Daily and Weekly metrics to prepare Exit Summary and reports to management.

ÏWorked closely with Development team in replicating and resolving the issues.

ÏInvolved in Configuring machines for the Performance Testing lab with Rational Robot.

ÏPerformed performance testing to setup a baseline for 20, 30 & 50 Mil line items.

Environment: C#, .Net, MS-Sharepoint, MS-Office, XML, XSL, Oracle, SQL Server 2000, SQL Server Management Studio Express, TeamTrack 6.0, Red Gate SQL Compare 6.

Authoria Waltham, MA / Bangalore, India

Quality Assurance Lead / Test Manager May 05 - May 06

Project: Employee Advisor 4.3

Description: Authoria Employee Advisor (formerly Authoria HR) delivers a strategic approach to effective employee communication including benefits, total compensation statements, and human resource policy information. It provides a powerful self-service experience to your employees and managers.

Responsibilities:

ÏAnalyzed Functional Specifications to write the test cases For EA 4.3/4.3.0.1.

ÏCoordinated and reviewed the Scenario based test cases by understanding the business logic and user requirements for manual testing.

ÏCoordinated with the OnSite-Offshore teams.

ÏHandled Customer Escalations & Performed Patch testing and release the patch.

ÏTesting the Sub-sequent Service Packs for the product releases.

ÏDesigned and executed EA 4.3 test cases for Smoke, Functionality, Installation and Regression testing and logged the Test Reports in ClearQuest.

ÏAutomated the smoke testing using SilkTest 7.0.

ÏImplementation of Authoria Apps(EA4.2.2 to 4.3 & 4.3.0.1) with SqlServer 2000.

ÏInvolved in Resource planning and Effort estimation.

ÏDefect followup and Defect fix verification.

Environment: VB, VC++, Asp.Net, Java / JSP, XML, XSL, Oracle 9i/Oracle 10g, SQL Server 2000, SilkTest 7.0, SilkMeter 2.5.2, Rational ClearQuest, VMWare.

Realm Inc Dallas, Texas / Bangalore, India

Sr Quality Assurance Analyst/ QA Lead Mar 04 – Apr 05

Project: Financial & Portfolio Analysis on Argus & Dyna

Description: Realm provides software and services that enables better management of the financial and operational performance of their real estate portfolio. Realm products help real estate companies improve financial and operational performance across their entire portfolio by optimizing four key workflows that are critical to the real estate industry, asset valuation, budgeting & forecasting, operations, and cash flow.

Responsibilities:

ÏAutomating the Insight Datawarehouse.

ÏInvolved in of the Time and Effort estimation for various activities.

ÏWriting & Reviewing the Test cases for Insight for PAY, ARGUS & DYNA

ÏPrepared the Test Design for Insight for PAY, ARGUS & CTI and DYNA & CTI integration.

ÏCreation & generation of DYNA models & reXMLs, uploading to INSIGHT Data warehouse.

ÏVerification of the database tables for the data uploaded by ReXML files.

ÏCoordination with the team in accomplishing the other testing activities, Handled Product Training sessions and involved in Test Execution & Tracking the defects in RITS.

Environment: Java (J2SE 1.4.2), Java - WSDP 1.3(JAXB1.0.1 Included), Castor XML 0.9.5.2, XML Beans, MS-SQL Server with SQL Database, XML SPY 3.5, Business Objects 6.0. DYNA 11.4, ARGUS 11.1, RITS (Realm Issue Tracking System), Rational Test Suite, Mercury - Winrunner.

Wysdom Inc Toronto, Canada/Bangalore, India

QA Lead Engineer/ Test Manager Oct 03 – Feb 04

Project: Application Management Console on MAPOS and Location Services

Description: Wysdom is one of the leading Toronto based companies that has a niche in Telecom domain. A Mobile Network Operating System such as Wysdom's MAP-OS is developed for the telecom operators which can offer a wide range of value added services and helps the developer by providing a single, consistent API for multiple wireless networks.

Responsibilities:

ÏAnalyzing and Understanding various inputs documents and the user requirements and then determining the scope of the enhancement / new development requested.

ÏEffort estimation, Test Planning, Test case Template design.

ÏDeveloping Test Scenarios and Test Cases based on the Technical Requirement Documents, PowerPoint Presentations, Test plans for Functionality testing

ÏReviewing Test cases & Execution of test cases.

ÏCross platform testing performed on Unix servers and verified Unix logs for accuracy.

ÏDefect Analysis and Reporting using Bugzilla.

ÏFunctional Regression testing.

Environment: Windows 2000, J2EE, JSP, HTML, Unix/Sun Solaris 5.8 server, VPN client, Bugzilla,

Servlets, BEA Web logic 7.0, Oracle 8.0

MATALAN Skelmersdale, UK

Sr Quality Assurance Engineer Jun 03 – Sep 03

Project: Portfolio Merchandise Management (PMM)

Description: Matalan is one of the UK's leading clothing and home ware retailers. PMM (Portfolio Merchandise Management) is their merchandise management system and it covers all functional areas of Retail Supply Chain Management.

Responsibilities:

ÏCustomer interaction and Requirements review.

ÏDeveloping Test cases for various testing phases such as, Functional Testing, System Testing, Modification Testing and Integration Testing.

ÏAutomation of the test cases using Silk 6.0 and Execution of Functional and System Test cases.

ÏFacilitated User Acceptance Testing.

ÏDefect Logging and Tracking using the tool Scarab.

ÏRetesting the application for consistency in its performance and Reporting discrepancies if any.

Environment: Uniface Interface, Citrix server, DHTML, ActiveX, SilkTest, Windows, UNIX, Oracle 8.1

Osscar Infotech Visakhapatnam, India

QA Lead / Manager May 02 – May 03

Project: Web Apps Suite

Responsibilities:

ÏReviewed Design specifications and designed test plans and test cases to ensure Test Coverage.

ÏTest scheduling and Test Tracking using Traceability Matrix.

ÏPerforming Black Box, Acceptance and Regression testing.

ÏMentored and monitored the Team in execution of Test Cases manually and used Silk automated tool for generating test data in some cases.

ÏPerformed System Testing for complete application cycle.

ÏUsed TestDirector to maintain Manual and Automated testscripts, Defect management.

Environment: Java, JSP, Silk, HTML, and Oracle 8.1, Test Director.

TechnocratSolutions Canoga Park, CA

Sr. QA Engineer Jul 01 – Mar 02

Project: Global Funds Exchanger

Description: Global Funds Exchanger software automates the domestic wire transfer process, allowing banks of any size to offer the same kind of comprehensive services that were, until now, only available to large banks that could afford a sizeable investment in equipment, software and personnel.

Responsibilities:

ÏRequirements analysis and Drawing Test Scenarios.

ÏInvolved in developing automated test scripts using Silk.

ÏPreparation and execution of test plans, manual test cases for applications functionality during all stages of product life cycle.

ÏTested software changes thoroughly to ensure that they are bug free and stable.

ÏProvided additional information & analysis as needed to Developers for bug resolution.

ÏParticipated in daily status meetings to discuss defects with developers & managers.

Environment: Java, JSP, Silk QA Partner, Oracle 8.0, JDK1.2, and Windows NT/2000.

Electron Economy Cupertino, CA

Sr. QA Engineer Jul 00 – Jul 01

Project: Supply Network Transaction Management Portal

Description: Electron Economy, Inc. is an innovative software vendor delivering inter-enterprise software products that address today's market need for real-time Supply Network Transaction Management (SNTM). The product solution software platforms, development tools, and configurable applications to help helps Internet stores and e-commerce companies manage logistics and back-ends is Electron Economy's main product focus.

Responsibilities:

ÏAnalyzing and reviewing the functional specifications, documents as per the QA standards.

ÏDevelop and implement the Test plans in Test Cases and Test Tracking.

ÏPerforming Black Box, Integration and Regression testing.

ÏExecuted the Test Cases manually and used Silktest for generating test data.

ÏBug tracking and maintenance of bugs using Bugzilla Bug tracking tool.

ÏPerformed Build Verification Testing and Black box testing of complete application cycle.

Environment: Java, JSP, JavaScript, HTML, Apache Tomcat 4.x, Oracle 8i, BugZilla.

Technocrat Solutions Canoga Park, CA

QA / Test Engineer Jan 00 – Jun 00

Project: Resources Management System

Responsibilities:

ÏConducted black box testing for various builds of entire application in QE environment.

ÏCreated a detailed System Test cases for System Testing.

ÏDeveloped test cases and test scripts using Silk for Functionality and Regression Testing.

ÏResponsible for weekly status updated showing the progress of the automation testing effort and open issues to be resolved.

Environment: ASP, HTML, Oracle, Windows NT, Silktest and Manual Testing.

Axcess Software Tech Visakhapatnam, India

Test Engineer May 98 – Dec 99

Projects: #1 Java Software Management Tool, #2 Herbal Health, #3 Bananastuff.com

Responsibilities:

ÏAnalyzed Systems design specifications & business Requirements to write test cases to cover all features.

ÏPerformed GUI, Functional, System, Integration and Regression Testing.

ÏDeveloped reports and Graphs to present the stress test results to the management.

ÏPrepared & Executed test scripts and test cases using WinRunner.

ÏPerformed Cross platform testing.

ÏDocumenting & Analyzing the defects and logging the test results for tracking.

ÏInvolved in Design & Development of the application.

Environment: Winrunner 4.5, JDK 1.2, JDBC, Oracle, Windows NT and Manual Testing.

Contact this candidate