Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Kumar vangapally by ZRA214

VIEWS: 5 PAGES: 7

									                                          Kumar
_____________________________________________________________________________


PROFESSIONAL EXPOSURE:

       Over six years of experience in Quality Assurance and Automation of Testing using
        Win Runner, Quick Test Pro and Load Runner in different applications.
       Good experience in different industries including Health-Care, E-Commerce,
        Insurance, Financial and Telecom
       Experience in Automated and Manual Testing of Client-Server and Web Applications.
       Good Knowledge in understanding of SDLC and QA Life Cycle.
       Strong experience in the development and testing of data warehouse, data mart and
        transactional models. Proficiently rendered services in Informatica (Power Mart and
        Power Center Tools), and Micro Soft Office Suite.
       Strong Data Warehousing concepts and capable in deriving Analytical, Logical, Physical,
        Dimensional and statistical Data Models.
       Extensive experience in Oracle concepts (SQL, PL/SQL) and UNIX Shell scripting.
       Involved in performing Manual, Functional, System, and Acceptance Tests.
       Well experienced in all kinds of testing including White-Box and Unit Testing.
       Performed Integration testing, System testing, Black Box functionality testing,
        Regression testing, back end testing and User Acceptance Testing.
       Diverse experience in Information Technology with emphasis on Quality Assurance,
        Manual Testing, Automated Testing.
       Experience with TSYS TS2, third party Credit Card Processor.
       Expert in testing Client/Server and Internet/Intranet based business applications
        including development and implementation of Test Plans, Test Cases and Test Scripts.
       Expertise in Problem solving and Bug Reports using Bug Tracking Tools like
       Test Director and Share point.
       Knowledge of software engineering standards like CMM (Capability Maturity Model)
        Strong problem solving skills, extremely reliable, quick learner and able to work
        independently as well as a team member.


Technical Skills:

Testing Tools                     : WinRunner, Load Runner, Mercury QTP 8.2.
Defect Tracking Tools            : Test Director, Clear quest, Mercury Quality Center.
Languages                        : C, C ++,VB, SQL, SQL, PL/SQL, HTML, TOAD, , XML
Databases                        : Oracle 8i/9i/10g, DB2, SQL Server7.0
Scripting                        : VB Script, UNIX Shell Script.
ETL                              : Informatica
Reports                          :Cognos, Business Objects.
Mainframes:                      : MVS, JCL, CICS, VSAM, DB2, TSO.




Professional Experience:
National City BANK OH                                                   Jan 2007 to Present
Position: QA Analyst
Project: Anti-Money Laundering
Description:
National City Corporation is one of the reputed banking firms located in Cleveland-Ohio-USA. They
have several branches across USA. Anti Money Laundering, Loans Application System with AML
technical team Onsite-Offshore. The nature of work involves the Maintenance and Production to
support NCC’s Loans applications. Banking Online Application where customer can login and view
current and past account information, account summary, view and edit personal profile, perform
various secure online activities. NCC provides many services to their customers, and also NCC
Implementing SOX Technology.
Loans application group has eight applications.
   Credit card system (CCH)
   Auto leasing (ALS)
   Mortgage Loans (MLA)
Responsibilities:
        Extensively used ETL methodology for supporting data extraction.
        Expertise writing queries in DB2.
        Worked On CICS Screens on Mainframes validate the Account ID’S , Customer ID’S,
        Wire Transactions, SWIFT Code Against the Warehouse Search Space Tool.
        Performed data validation testing after the ETL process Informatica.
        Proficient in Database Testing, Functional Testing, Integration Testing.
        Good Knowledge in UNIX.
        Performed Black box testing on the .Net application and wrote the test summary
            report.
        Prepared the Test strategy document with a detailed description of test
            objectives, Test scope, test phases, defect tracking and defect risk management.
        Analyzed system documentation like Requirements document, User Interface
            Specifications to develop and Execute Test scripts.
        Prepared Test requirements, Test plans and Test Cases using Test Manager.
        Executed Test cases manually to test Application functionality against user
            requirements for security.
        Part of Data preparation, Involved in Creating New Accounts, Minimum Payment,
            Fees, Finance Charges and Posted Transactions.
        was involved in functional and regression testing of Web application
        Created Test Plans, SQL scripts for verifying the Informatica process as part of the
            Enterprise Data Warehouse
        Performed data validation testing after the ETL process Informatica
        Created Test Cases based on the Application Use cases
        Created and Executed System Test cases and User Acceptance Test cases for the
            application.
        Used Clear Quest as the Defect-tracking tool to enter defects regarding the issues
            found during testing
        Generated reports using Crystal Reports.
        Detected bottleneck defects and implemented a plan to handling the bottlenecks.
        Regularly following up with Development Team to discuss discrepancies identified
            during testing meet the dead of the Schedule.
Environment: Rational Clear Quest, Rational Test Manager, Mainframes Cobol,Jcl,DB2,File-
aid,Green Screens, TSO/ISPF VB.NET,ASP.NET,Linux, DB Visulaiser, Windows NT/2000,
,ETL,SQL,Informatica, Business Objects,Cognos.



JP Morgan CHASE Willimington DE                                            July 06 to Dec 06
Position: QA Analyst
Description:
Chase is one of the nation's leading financial institutions. It provides complete banking services,
asset management and innovative products for customers. Chase provides 24 hours online web
access to its customers to login in to there account and perform various online activities like
check balance, transfer available funds from different accounts, etc. Worked on both TSYS Ts2
(Third Party Credit Card Processor) application and Banking Online Application where
customer can login and view current and past account information, account summary, view and
edit personal profile, perform various secure online activities. Chase provides many services to
its customers, which were implemented in this Application.
Responsibilities:

       Involved in analyzing the Business requirements documents (BRD’s), Functional
        Design Documents (FDD’s) and System specifications to understand the TSYS Ts2
        Mainframe Application.
       Involved in testing TCSF (The collector system financial ) Application which is retrieves
        litigatation accouts information of the customer .
       Involved in validating files and file formats of the transaction of the accouts which
        comes in daily bases
       Analyzed system documentation like Requirements document, User Interface
        Specifications to develop and Execute Test scripts.
       Prepared Test requirements, Test plans and Test Cases using Test Director.
       Executed Test cases manually to test Application functionality against user
        requirements for security .
       Involved in manual functional testing of TSYS TS2 Mainframe application.
       Executed Test cases related to Insurance Interface between TSYS TS2 and Vendor.
       Involved in testing various TS2 Screens.
       Part of Data preparation, Involved in Creating New Accounts, Minimum Payment, Fees,
        Finance Charges and Posted Transactions in TS2.
       Validated online application data against TSYS TS2 application.
       I was involved in functional and regression testing of Web application
       Prepared test status reports during test execution process.
       Created validation strategic Documents and Summary Report.
       Performed Positive and negative testing.
       Created and Executed System Test cases and User Acceptance Test cases for the
        application.
       Used Test Director as the defect-tracking tool to enter defects regarding the issues
        found during testing
       Detected bottleneck defects and implemented a plan to handling the bottlenecks.
       Regularly following up with Development Team to discuss discrepancies identified
        during testing and performance tuning.

Environment: Test Director 7.6, ASP, HTML,Java, VB, JavaScript, Oracle9i, IIS-Web
Server, Mainframe ,Linux, Windows NT.
MetLife, Hartford, CT                                                            Dec 05 – June06
Position: QA Analyst
Description:
MetLife is one of the nation's leading insurance institutions. MetLife Insurance in the United
States offer personal and institutional clients a broad array of Services in Insurance. The
project was to test both the Legacy Data Warehouse (LDW) and Enterprise Data Warehouse (
EDW ) integration in to the MetLife environment. The main goal of the project was to ensure
that the applications are running the same way as in the TLA environment without any bugs and
they are meeting the performance criteria Life, LCC, Fund Performance & Annuity Insurance
Company that provide online services to the company’s customers.

Responsibilities:

      Created test plans, SQL scripts for verifying the Informatica process as part of the
       Enterprise Data Warehouse
    Sound knowledge in SQL.
    Expertise writing queries in SQL Server
    Executed Test cases and verified actual results against expected results.
    Created test plans for verifying the Unix processes as part of the Legacy Data
       Warehouse
    Analyzed system Specifications and design document and involved in developing test
       plan in Mercury Quality Center.
    Created test templates, test cases and conditions using Test Director / Mercury
       Quality Center.
    Used Mercury Quality Center as a defect tracker.
    Involved in creating Reusable test scripts in Quick Test Professional.
    Executed Test cases and verified actual results against expected results.
    Executed the test plans for both LDW and EDW in Dev and INT regions.
    Created test cases for validating the table counts for LDW and EDW in both the
       environments.
    Tested Cognos reports in the new environment.
    Developed test scripts and check points for testing using Quick Test Professional.
    Interacted with Development and QA Teams to ensure overall quality of the software
    Developed various reports to communicate testing issues with the project manager.
    Performed data validation testing after the ETL process Informatica
    Close interaction with designers and software developers to understand application
       functionality and navigational flow.
Environment: Manual Testing, Mercury Quality Center 8.0, UNIX AIX 5, Windows NT/2000,
Oracle 9.2, Microsoft SQL Server, SQL, Informatica 7.1.2, Cognos 6.0.61.

BCBS of NC, Raleigh, NC                                                     Mar 05 to Oct 05.
Position: Software QA Tester
Description:
 BCBS of NC is the largest healthcare provider with various members providing healthcare,
Medicare services. Tested the Membership applications, Eligibility applications, Claims
processing applications. Tested the Implementation of Trizetto Facets.

Responsibilities:

       Developed Test Plan and Test cases for the Patches and Reports.
       Responsible for Quality Control and Manual testing of the Facets application
       Tested the Various Modules and Patches (Claims, Customer service & Membership).
       Involved in the Testing of Various extensions and Interfaces.
       Tested the various Ruby reports (Payments, COB and Claims).
      Validated the Batch Log files and compared with Database tables.
      Validated the reports in Facets 4.11 and 4.31.
      Expertise writing queries in SQL Server.
      Developed XML test files based on XML schema.
      Worked with SQL Queries bt uisng Toad to validate data From Source and Target.
      Tested various functionality like Membership & Eligibility, Customer Relationship
       Management, Claims Processing and Payment, Provider Credentialing and Benefits
       Packages
      Perform all types of testing of a hosted (ASP) enterprise B2B data quality application
       (Java/J2EE)
      Created test plans for verifying the Unix processes as part of the Legacy Data
       Warehouse
      Analyzed system Specifications and design document and involved in developing test
       plan in Testdirector.
      Used TestDirector as a defect Tracking Tool.
      Attended QA status call every day to discuss the status of the testing and resolution
       provided by Team Lead for defects that was logged before.
      Worked on data validation by accessing SQL tables by executing complex Quires.
      Tracked defects using Test Director Attended Bug-Review meetings.
      Reported the bugs, Email notifications to the developers using Quality Center.
      Worked on different tools like EOS Thin Client and COMPARE IT.

Environment: Facets 4.31 & Facets 4.11 (Trizetto), C#, V.B,.NET Java, XML, SQL*Plus, SQL
Server 2000,MS Access 2000, MS-Word, Ms-Excel, NT, Mainframes, Informatica 7.1.2,
Cognos, Mercury QTP , Test Director, EOS THIN CLIENT and COMPARE IT, PVCS Tracker.

State Farm Insurance, Houston, TX                                              Mar 03 – Jan 04
Position: QA Tester
Description:
State farm Insurance is one of the leading insurance companies in the United States. The aim of
the project is to help the customers to get a free online quote instantaneously. It also dealt
with property and casualty insurance of auto and homeowners. This application also enabled
the field agents/customer representative of the company to view prospective customer's data.

Responsibilities:
    Analyzed system Specifications and design document and involved in developing test
       plan in Test Director.
    Actively participated in requirement gathering and analysis
    Working closely with different team players to deliver a quality release per
       commitment
    And in a timely fashion and ensuring “no surprise” releases, learning from past issues
       and growth areas
    Prepared the test environment including setup of facilities, hardware and software
    Tested modules dealing with property and casualty insurance of auto and homeowners
    Created test templates, test cases and conditions using Test Director
    Used TestDirector to maintain test cases, test scripts and to analyze test results
    Used Test Director as a defect tracker
    Involved in preparation of Test Plan which specifies testing overview, testing approach,
       testing strategy, roles and responsibilities and scope of testing
    Executed different scenarios like compatibility, scalability, and load test to identify
       bottlenecks on every component of the system
    Developed GUI Map of the application using Win runner
    Developing Automated Test Scripts to perform Functional Testing, Integration
       Testing, System Testing, User Acceptance Testing, Regression Testing and
       Volume testing of the application using WinRunner.
      Performed Manual testing of the application before performing Automated testing
      Written SQL Queries and Procedures to perform database testing
      Developed Automation test scripts for Regression testing of the application
      Enhanced test scripts with TSL(Test Script Language) language of Win runner
      Executed test scenarios in different test environments
      Interacted with Business Analysts, Developers and QA team members in different
       defect raising situations
      Performing queries on the database using 'SQL' to check successful Transaction & to
       create particular test cases

Environment: Manual Testing, Win Runner, Test Director, C++, VB, HTML, Oracle, SQL,
Microsoft SQL Server and UNIX.




Verizon/Bell Atlantic Communications, India                            Nov 01 – Jan 03
Position: QA Analyst
Description:
The primary objective of the Network Metrics Platform project is to address the needs and
requirements of Verizon’s Wholesale Performance Assurance Organization. This is largely
necessitated by Verizon’s entry into the Long Distance market, which requires it to produce
and file periodic performance reports with State and Federal regulatory agencies.

Responsibilities:
    Performed Functional decomposition of the use cases.
    Involved in Developing and creating detailed test plans and test cases for the system
       covering design document, reviewing them with the developers and finalizing the test
       cases.
    Developed SQL scripts to validate the data loaded.
    Created and maintained a Central repository in Test Director and tracked the defects.
    Performed Regression testing of the intranet website using WinRunner.
    Performed data driven tests and tested the application by inserting verification points.
    Executed the test cases and analyzed the results.

Environment: VB, oracle, COBOL, Manual Testing, WinRunner, Test Director, HP UNIX

VISUALCOM Software Solutions, India                                           Feb 01- Sep 01
Position: Software Engineer.
Responsibilities:
     Designed and developed test automation scripts using WinRunner.
     Investigated software faults and interacted with developers to resolve technical issues.
     Bug reporting is done using Test Director.
     Modified, and tested EDI & XML maps
     Performed Integration, Performance and Configuration tests.
     Responsible for Black box testing of the application.
     Analyzed the response times of the business transactions under load. Developed reports
        and graphs to present the stress test results to the management.
     Generating and testing of customized reports for all maintenance related activities.
     Verifying data source, data integrity and server testing using SQL.
     60% of the project testing was done manually for documentation, remaining using
        WinRunner.

Environment: Manual Testing, WinRunner, LoadRunner, MS-OFFICE, Oracle 7.1, Visual Basic
               5.0, UNIX and Windows95.

								
To top