Docstoc

Narendra

Document Sample
Narendra Powered By Docstoc
					                                                  Narendra Kumar Reddy
            narendrakumarredd@gmail.com                                            954-317-7637

       ________________________________________________________________________________

PROFESSIONAL SUMMARY

      Over 8 years of Software Quality Assurance experience in data warehousing, client server, Web-based applications.
      Experience assessing testing processes, creating, implementing test strategies and SQA strategies using Agile
       testing methodology.
      Good Experience on performance testing
      Manual and Automation Testing experience using Mercury Quality Center, Test Director, Quick Test Pro, Win
       Runner, Load Runner and Clear Quest.
      Proficient in usage of Abinitio, Informatica and Business Objects.
      Experience working with high volume, real-time database systems and applications using Oracle, Teradata, SQL
       Server, Sybase and DB2.
      Experience in Functional Testing, System Testing, Integration Testing, Regression Testing, Performance Testing
       and User Acceptance Testing.
      Experience in writing UNIX shell scripts, PERL scripts, Data validation scripts, SQL, PL/SQL Stored Procedures,
       Functions, Packages and Triggers.
      Knowledge of Software Development Life Cycle and Test methodologies.
      Knowledge of CMMI and Sarbanes-Oxley process improvement practices.
      Knowledge of Banking, Healthcare, Tele communication domain.
      Effective team player, self-motivated, capable of adapting to new technologies.
      Excellent analytical, Problem solving, verbal, written and inter-personal communication skills.
      Tested the target data against source data by developing PL/SQL procedures.
      Developed SQL queries, Triggers, Procedures and compared SQL results with Application results using TOAD

EXPERIENCE SUMMARY

      7 years of database experience using Oracle, Teradata, SQL Server, Sybase and DB2.
      8 years of software manual and automation testing experience using Quality Center, Test Director and Clear Quest.
      5 Years of data warehouse experience using Abinitio, Informatica, Business Objects and Crystal Reports.
      7 years of experience using UNIX, Solaris, Linux and Windows NT/2000/XP.

Education:
  M.C.A from Osmania University (India) - 2001
TECHNICAL SKILLS

Operating Systems      : Sun Solaris 8, IBM AIX, UNIX, Linux, Windows XP/2000/NT, DOS
Languages              : Java, C, C++, VB, SQL, PL/SQL, TSL, JCL
Databases              : Oracle 11i/10g/9i, SQL Server 7.0, Teradata 12.0/v2r5/v2r4,
                    Sybase, DB2
Web Technology         : XML, HTML, Java Script, VB Script, VB.NET, ASP.NET ,J2EE
Testing Tools          : Quality Center 10.0/9.0, Test Director 8.0, Win Runner 8.2
ETL Tools              : Abinitio (GDE 1.15/1.14), Informatica 7.0, SAS
Reporting Tools        : Business Objects XIR2/6.0, Micro Strategy
Application Servers    : Web Logic 8.1/7.2/6.0, Web Sphere 5.0, Tomcat 4.0
Application Tools      : Rational Clear Case, Clear Quest, Erwin, Rational Rose, CVS, TOAD, MS Office,
                          DB Visualizer, Rational Manual Tester, Rational Test Manager
Others                 : Knowledge of SDLC, Agile Methods


PROFESSIONAL EXPERIENCE

QA Analyst
DTE Energy –Detroit, MI                                                                  Nov 2011 –Feb 2012

DTEEnergy is Electrical company to provide the power distribution in Michigan. Advancing Meter infrastructure is
process the Billing details and Meter related information. For processing complex data AMI to PI. It touches the each
individual component in the entire flow.
Responsibilities:
    Prepared Test Strategy Document and Test Case Document, Requirements Traceability Matrix to map the
      requirements with their respective test cases.
    Designed and developed detailed Test Plans and Test cases which specify testing overview and testing approach
      depending on the Business and Technical Requirements.
    Validated the data loaded into the target Teradata database which extracted from multiple operational data
      sources DB2, Oracle, SQL Server, flat files.
    Analyzed tables and indexes for performance tuning, optimizing database objects and streamlining applications.
    Executed the Test Scripts on different releases and validated the actual results against the expected results.
    Experience in validating data mapping, selection criteria, aggregations, sorting, lookups, transformations, data
      loads
    Prepared test status reports during test execution process. Documented the testing process, Test Evaluation
      Summary.
    Provided assistance to developers to maximize coding efforts, support development, QA and production
      environments
    information
    Session objects were used to store the state of the user.
    Assisted in the creation of Stored Procedures for performing repetitive tasks in updating related tables.
    Involved in User Acceptance Testing by providing test data for users and by testing UAT defects in test
      environment before, the new code gets moved to UAT environment
    Developed Test Plan, executed the test cases using Test Director, logged and maintained defects using Clear
      Quest.
    Validated Extraction, Transformation and Loading (ETL) graphs where data is extracted from Sybase, Oracle,
      DB2, SQL Server, Flat files data sources and loaded into Target Teradata database tables.
    Using rational manual tester and Execute the test results and mapped the test scripts to the corresponding test
      cases in Test Manager to do the test coverage.
   

Environment: Windows XP, Oracle 10g, DB2, Mercury Quality Center 10, Clear Quest, BEA Web Logic, Java, Toad,
Putty ,MIB,SoapUI , Rational Manual Tester , Rational Test Manager
QA Analyst
PNC Bank -- Cleveland, OH                                                        Aug 2010 – Nov2011
Project: CIF
PNC Bank is a diversified financial services company with operations around the world. CIF(customer information file is
maintain the customer side and Acoount side of PNC bank. Validate and verification of both accounts and new accounts
.And CIF works all other banks related information which PNC acquires other banks.
Responsibilities:
     Prepared Test Strategy Document and Test Case Document, Requirements Traceability Matrix to map the
        requirements with their respective test cases.
     Used Rational Functional Tester and Manual Tester for writing Automated and Manual Test Scripts
        and Scenarios by analyzing functional and business requirements.
     Designed and developed detailed Test Plans and Test cases which specify testing overview and testing approach
        depending on the Business and Technical Requirements.
     Performed Functional Testing, System Testing, Integration Testing, Regression Testing. Tracked and managed
        defects using Mercury Quality center.
     Used MS Excel to find out the string lengths, count, comparisons.
     Through MS Excel spreadsheet by using built in functions generated counter strings, validated business logic
        etc.
     Validated the data loaded into the target Teradata database which extracted from multiple operational data
        sources DB2, Oracle, SQL Server, flat files.
     Developed Ab Initio Graphs to generate test data using departition, partition, reformat, rollup, scan components.
     Created test plans, test cases, and other testing related documents using MS Excel.
     Involved in testing Unix Korn Shell wrappers to run various ETL Scripts to load the data into Target Data
        Warehouse.
     Developed and modified Unix Shell scripts to automate QA execution process in Test environment.
     Developed required SQL scripts for database testing and Performed Backend Testing, by executing the SQL
        queries. Wrote SQL Queries to extract data from the Tables.
     Analyzed tables and indexes for performance tuning, optimizing database objects and streamlining applications.
     Executed the Test Scripts on different releases and validated the actual results against the expected results.
       Performed Functional and Regression testing using Quick Test Professional.
       Recorded Test cases by inserting standard, page, table, bitmap, and database check points. Parameterized test
        cases by defining data table parameter.
    Verified the applications expected behavior at different stages by inserting Synchronization and checkpoints using
        Quick Test Pro.
    Involved in User Acceptance Testing by providing test data for users and by testing UAT defects in test
        environment before, the new code gets moved to UAT environment.
    Created test Execution Report, Test Completion Report for Test Sign Off, documented the testing process and
        Test evaluation summary.
    Involved in Code Review, Design Review, Test Case Review meetings with business analysts and developers.
Environment: Windows XP, Oracle 10g, DB2, Abinitio, Mercury Quality Center 10, Clear Quest, BEA Web Logic,
Java, Toad, Putty and Autosys 4.5.QTP 9.0, Rational Manual Tester , Rational Test Manager

Synapse, Stamford, CT                                                                    Feb 2009 to july 2010
Project: IPM (IVR Platform Modernization)
Sr.QA Analyst
 IPM (IVR Platform Modernization) is a middle tier technology where existing IVR system will be modernized by converting
the Web services to Stored Procedures. Around 50 web services has been identified which will be converted to Stored
Procedures. As a part of QA process we would be testing the complete functionality of the IVR application and we will also
be testing each and every Stored Procedures.
Responsibilities:
     Prepared Test Strategy Document and Test Case Document, Requirements Traceability Matrix to map the
         requirements with their respective test cases.
     Designed and developed detailed Test Plans and Test cases which specify testing overview and testing approach
         depending on the Business and Technical Requirements.
     Performed Functional Testing, System Testing, Integration Testing, Regression Testing. Tracked and managed
         defects using Mercury Quality center.
     Executed the Test Scripts on different releases and validated the actual results against the expected results.
     Extensively involved in performance testing.
     Verified various lookups and multi files in order to implement Data Parallelism using Ab Initio Partition and
         Departition components.
     Involved in User Acceptance Testing by providing test data for users and by testing UAT defects in test
         environment before, the new code gets moved to UAT environment.
     Created test Execution Report, Test Completion Report for Test Sign Off, documented the testing process and
         Test evaluation summary.
     Experience in validating data mapping, selection criteria, aggregations, sorting, lookups, transformations, data
         loads
     Extensively used SQL queries to retrieve data from Oracle database using Toad. Tested and modified PL/SQL
         Packages, Stored procedures and functions.
     Performed Security testing for unauthorized access of the web services with Positive and negative testing.
     Verifying the performance of the IVR System.
     Developed and recorded Test cases and Performed Regression testing using Quick Test Professional.
         Automated manual test scripts using Quick Test Pro.
     Extensively used Autosys for run the scheduling jobs.
     Prepared test status reports during test execution process. Documented the testing process, Test Evaluation
         Summary.
     Provided assistance to developers to maximize coding efforts, support development, QA and production
         environments
Environment: Ab Initio (GDE 1.15, Co-Op 2.14, EME 2.14), Windows XP, Oracle 10g, Teradata 12.0, DB2, Mercury
Quality Center 10, Clear Quest, BEA Web Logic, Java, unix,Toad, Putty and Autosys 4.5.QTP 9.0, Rational Manual
Tester , Rational Test Manager

Pfizer Inc. St. Louis, MO                                                            Dec 2008 – Feb 2009
Project: Science Education Outreach
Sr. QA Tester
Pfizer is the world’s largest pharmaceutical company and has a history of Science Outreach in their communities. The
main Idea of building this portal is to interact with the students and to receive the response quickly. Purpose of the site
is to provide schools with Pfizer’s programs and to collect the student’s information for enrolling. Every program has its
own sub site to describe and to provide students with Forms, Tasks, documents, link and announcements.
Responsibilities:
      Analyzed business requirements and Participated in business requirement walk through and design walk through
       meetings.
    Discovered and documented bugs with tools like Microsoft Excel.
    Created software testing templates using Microsoft Excel.
    Designed and developed detailed Test Plans and Test cases which specify testing overview and testing approach
       depending on the Business and Technical Requirements.
    Performed Functional Testing of different modules, System, Regression Testing on the entire application,
       Integration Testing of all the systems and end-to-end Testing using Mercury Quality Center.
    Involved in Regression testing various Ab Initio Data Flow Graphs with multistage components and analyzed the
       test results.
    Created test documentation slides using Power Point.
    Agile testing methodology was used to provide efforts estimate and coordinate test schedule in UAT phase.
    Verified various lookups and multi files in order to implement Data Parallelism using Ab Initio Partition and
       Departition components.
    Tested Java Messaging Services (JMS) Java Client Settings, queues and persistence. Verified Local and
       Integrated MQ Managers and associated MQ Services. Verified and validated Tokenization functionality and
       Configuration.
    Used Mercury Quality center for Defect Tracking, Test Management. Entered defects with error details, steps to
       reproduce the error, screen shots that explain the errors.
    Performed data validation testing by writing complex SQL queries. Implemented performance tuning techniques
       to test SQL and PL/SQL scripts used in ETL process.
    Developed SQL scripts for database testing and Performed Backend Testing, by executing the SQL queries.
       Wrote SQL Queries to extract data from the Tables.
    Compared SQL results with application results by writing complex SQL queries.
    Analyzed tables and indexes for performance tuning, optimizing database objects and streamlining applications.
       Developed Batch scripts for unattended testing.
    Involved in testing Unix Korn Shell wrappers to run various ETL Scripts in to load the data into Target Data
       Warehouse. Developed and modified Unix Shell scripts to automate QA execution process in Test environment.
    Validating new test regions which includes verification of configuration files, port values, tokenization values,
       import and export standards.
    Created Business Assurance Strategy, documented the testing process and Test evaluation summary.
    Supported Offshore Testing team in executing test cases and resolving environmental and other issues. Worked
       in an agile environment.
Environment: Ab Initio GDE 1.14, Co>Operating System 2.14, Linux, Windows XP, Oracle 9.2, Teradata 12.0, DB2,
Mercury Quality Center 9.2, Autosys, Java, QTP 9.0, XML, Web Logic 5.1, DB Visualizer, Putty.

Westfield Insurance, OH                                                   Sep 2007 – Nov 2008
QA Tester
Westfield Insurance is a leading insurance firm that provides insurance solutions for Business, Farm and agribusiness,
home and auto insurance. It’s an intranet portal designed for Claims Division Authorities. The main portal provided the
Authorities with customer details and provision to register a new Claim. The Sub sites were created for different property
types. The sub sites have the necessary insurance and claim details. Each Sub site had its Document Library, Tasks
and Announcement features.

Responsibilities:

       Analyzed the Project Requirement Document, Technical requirement Document and prepared Test Strategy
        Document (TSD) and Test Case Document (TCD) covering all the functional requirements.
       Created Requirements Traceability matrix, Test Plan, Test cases for System Testing, Integration Testing, and
        Regression Testing. Executed test cases using Mercury Quality Center. Tracked and logged bugs using home
        grown Bug Logging & Tracking Tool.
       Involved in testing various data flow graphs with check points at various stages, Ab Initio components like Rollup,
        Scan, Normalize, Reformat and Join.
       Verified and executed the Ab Initio jobs using Autosys on daily, weekly and monthly basis and to load data into
        target Oracle data warehouse tables.
       Involved in testing the Unix shell script that loads data from Netezza to Sybase and compared the results with the
        old script that loads data from Redbrick to Sybase.
       Developed and recorded Test cases and Performed Regression testing using Quick Test Professional.
        Automated manual test scripts using Quick Test Pro.
       Tested Universes and reports for data accuracy, formatting and functionality.
      Extensively used SQL queries to retrieve data from Oracle database using DB Visualizer. Tested and modified
       PL/SQL Packages, Stored procedures and functions.
    Performed Security testing for unauthorized access of the web application with Positive and negative testing.
       Tested Autosys stage and load job streams.
    Extensive knowledge on Star Schema, Snow Flake Schema, Data Marts, Dimension and Fact tables.
    Created the test environment and deployed the application.
    Attended Design, Code, Test reviews to finalize the open issues as part of AOL EDW architecture standards.
Environment: QTP, Ab Initio GDE 1.13.15, Sun Solaris 5.8, Windows XP, Oracle 9.2, Sybase 12.5, PeopleSoft,
Business Objects 6.0, BEA WebLogic 7.0, Mercury Quality Center, AutoSys 4.5, DB Visualizer, Putty.


Frost Bank, TX                                                                  Oct 2005 – Aug 2007
QA Tester
The Marketing Department had its data scattered in Email folders and personal computers in the form of Excel files,
Databases etc. It was very difficult and time consuming to locate previously authored documents and employees wasted
time and money finding the correct resources. A SharePoint solution has been implemented to address all these issues.
In addition to this the different business processes to apply for power have been streamlined and automated to a great
extent using the workflow capabilities of SharePoint server.
Responsibilities:
     Involved in analyzing and understanding the business requirements to develop the Test Strategy Document and
         Test Case Document.
     Involved in Functional, System, Integration, Regression Testing of Ab Initio graphs, Client Server and Web based
         Applications.
     Developed Test Plan, executed the test cases using Test Director, logged and maintained defects using Clear
         Quest.
     Validated Extraction, Transformation and Loading (ETL) graphs where data is extracted from Sybase, Oracle,
         DB2, SQL Server, Flat files data sources and loaded into Target Teradata database tables.
     Developed complex SQL queries to make sure that the data loaded in the corresponding tables is in accordance
         with the business rules defined in the data mapping.
     Involved in executing Automation Regression Jobs and analyzing the results.
     Performed Functional Testing and data validation by executing SQL queries and PL/SQL. Extensive experience
         in database testing on Oracle, DB2 and SQL servers.
     Developed Scripts in Test Script Language (TSL) to access dynamic Data pools, Creating GUI Check Points,
         Database Check Points, and Bitmap Check Points using Win Runner. Used Win Runner for Regression Testing.
     Created automated test scripts in context sensitive and analog mode as per the business requirements using Win
         Runner.
     Validated UNIX shell script that runs daily on FTP server converting different date formats of files into UNIX date
         format, checking the directory and its sub directories for the old files and deletes them after the specified no. of
         days.
     Prepared test status reports during test execution process. Documented the testing process, Test Evaluation
         Summary.
     Provided assistance to developers to maximize coding efforts, support development, QA and production
         environments.
Environment: WinRunner, Linux, Windows XP, MS SQL Server 7.0, Oracle 9i, DB2, Teradata, Test Director 8.0, SAS,
Clear Quest, ASP, SQL* Loader, Mainframes, IBM MQ Series, OS/390 COBOL, CICS, TSO/ISPF, JCL, MVS.


Qwest Communications, VA                                               Aug 2004 - Sep 2005
QA Tester
Qwest Communication offers a comprehensive range of wireless and wire line communications services. Order
processing system was developed, implemented for cellular phones and services. Once order is placed on-line, it
should go through different stages such as order confirmation, shipping, credit card charging and order completion
stage. This retrieves new orders, identifies the items placed for each order then sending order detail to vendors. The
project had a great impact on clientage, which was highly increased.
Responsibilities:
     Analyzed the system specification document, divided the application into different functions and then defined the
         Hierarchy of the whole application.
     Developed automated test scripts for functionality, GUI tests and executed automated scripts to perform
         Functional Testing and Regression Testing.
        Involved in developing Database Checkpoints, Destructive and Data Driven Test Scripts for all the projects using
         WinRunner.
     Recording with the help of either recording mode, context sensitive or analog, created Test Scripts. Test Scripts
         were synchronized and Bitmaps inserted for greater accuracy of testing.
     Involved in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews.
     Developed automated scripts for Performance, Stress testing and Load Balancing using Load Runner.
     Created performance testing scenarios in Load Runner controller and parameterized VUser scripts for dynamic
         values.
     Involved to creating and documenting Test Plans and Test Cases, executed the test cases and registered the
         expected results in Test Director.
     Reported and Tracking system defects and Bugs in Remedy User.
     Recorded Automation Test scripts in Rational Robot using SQA basic.
     Created requirement document using Requisite Pro, visual data models using Rational Rose, managed changes
         and tracked defects using Clear Quest, Clear case, executed and managed tests using Rational Robot and Test
         Manager.
     Designed the GUI Checklist for the application. Configured IIS-BEA plug-in.
     Involved to Test billing system and collection functionality on Mainframe and DB2 based client server Customer
         Billing System.
     Tested the target data against source data by developing PL/SQL procedures.
     Developed SQL queries, Triggers, Procedures and compared SQL results with Application results using TOAD.
     Executed some of automated Test Scripts using UNIX shell scripts.
     Involved in deploying different builds on testing environment using UNIX.
     Involved in Communicating with Application Developers, Project Manager and other Team Members on
         application testing status on an on-going basis.
Environment: Windows NT 4.0/2000, HP-Unix, Win Runner 7.5/7.0.1, Test Director 7.5, Load Runner, PVCS Tracker,
Visio, C, C++, Java, EJB, JavaScript, XML, HTML, Web Logic, Mainframe, JCL, MVS, TSO, IMS, DB2, COBAL,
Oracle8.0.5, Smalltalk, Rational Robot, Internet Explorer5.0, IIS Server.


InfoTech, India                                                      Jan 2004 – Jul 2004
Programmer
InfoTech is Software Developing Company in India. It was designing web and windows base application for Textile
Industry. They developed software and web for Financial Accounting System, Inventory Management, Payroll, and
Marketing Software etc. The basic work to develop accounting software for textile industry is to provide with Transaction
reports and Utilities.
Responsibilities:
    Involved in architecture and development of the application.
    Prepared the Detail Design Documents, Object identification according to the Design and fully developed & tested
       the code.
    Developed windows base user interface using ASP.NET.
    The Business Layer was developed in VB.NET
    Validation Control was used to perform validation of forms.
    Developed User Controls for Authentication and Navigation.
    Created tables, keys, stored procedures and triggers in the database.
       Developed data driven web pages using ASP and VBScript.
    Used stored procedures and triggers from SQL Server to retrieve information
    Session objects were used to store the state of the user.
    Assisted in the creation of Stored Procedures for performing repetitive tasks in updating related tables.
    Responsible for Manual Testing, Unit Testing, Integration Testing and System Testing for modules coded
    Involved in collecting software and performance requirement data.
Environment: ASP.NET, VB.NET, SQL Server 2000, Windows Server 2000, Visual Studio 2000, Classic ASP,
ADO.NET, T-SQL.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:8/24/2012
language:Unknown
pages:6