Summary

Over 4+ years of experience in Performance testing, Monitoring and Analysis with expertise in Load Runner, QALOAD, Rational Performance Tester, Wily Introscope, Mercury BAC, BMC Patrol, Symantec Precise, Statspack/AWR (performance testing and monitoring tools) and Worked as a Oracle DBA & PLSQL developer using TOAD and ORACLE EM database control. I am currently working as a Lead Performance Analyst(J2EE application and Oracle DB) in “Light Speed Performance Engineering” for ATT.

Experience Summary

• Currently working with Confidential as a Associate Consultant. I have 23 months (Till date) of onsite experience working with ATT, US.

Academics

B.Tech(Information Technology)

HSC

SSLC

Technical Summary:

Languages

C, C++, JAVA, VB, UNIX, PL/SQL, HTML, ASP.NET(C#/VB.NET).

Technologies

Light Speed, BT VISION, Basics in ASP.NET.

Oracle 9i /Oracle10G,SQL Server 2000, MS Access 7.0

Operating Systems

Windows 2000, Windows 2003, Windows XP, Unix, Linux

Testing&Monitoring Tools

Load Runner, Mercury Performance Centre, QALoad, Wily Introscope,Statspack/AWR,Precise(Symantec i3),NMON,Mercury BAC, BMC Patrol, Perceiver, Rational Performance Tester,Measureware(OVPA),Glance

Test Management Tools

Test Director, Mercury Quality centre, WinCVS

Work Experience

Confidential

Project #1

BT VISION(Nevis) Performance Testing

Description

The Nevis project aims to deliver a range of interactive television based services over BTs broadband network. These include Content on Demand and time-shifted Television, as well as communication services.

Platform

Java, Microsoft SQL server 2005, Microsoft .Net, Unix, Microsoft Windows

Duration

19 months

Team Size

6

Tools

QALoad, RDP&VOD Bashers, Test Director, X-RAY, Perfmon, IEwatch, Iostat, Vmstat, Mpstat, Prstat

Roles & Responsibilities

Bronze, Silver, SP2 Test Execution:

• Study of the system architecture and call flows
• Identify Key performance scenarios based on business requirements
• Client interaction for requirement and test scenario freezing
• Prepare Performance Test Strategy, RDD and Test Design documents
• Installation of load testing tools and Configuration of Monitoring tools.
• Script development, test data preparation and test execution of identified performance scenarios for NSP,NevOSS and SSS using QALoad.
• Gather performance statistics and prepare summary report with root cause analysis and recommendations.
• Defect tracking & test management and Coordinating with various other teams and third party to resolve the defects
• Prepare presentation to client with performance testing results

Project #2

BT Wholesale Monitoring using Wily

Description

The main objective of this project is to monitor the performance of all java applications launched in BT Wholesale portal as well as resource utilization of all servers and identify the critical component & slowest responding transactions which lead to performance degrade of portal and provide recommendations to improve the performance of BT Wholesale portal.

Platform

Java, Microsoft Windows

Duration

3 months

Team Size

3

Tools

Wily Introscope 7.0

Roles & Responsibilities

• Requirement gathering and understanding of performance requirements
• Involve in preparation of report template for daily and weekly reports based on requirements.
• Gather performance statistics using Wily Introscope and calculate baselines for transactions
• Analyze the performance results and highlight the critical components and transactions.
• Prepare the daily and weekly reports with bottleneck components and recommendations.

Project #3

Light Speed Performance Engineering

Description

Light Speed (Uverse) program is meant to deliver HSIA, Video, CVoIP, Wireless (Quadruple play technology) to ATT end users.

Platform

Clarify CRM, Amdocs Billing, J2EE, Oracle 9i/10G, DB2, Perl,Java/Html,Tuxedo

Duration

27 months

Team Size

15

Tools

Load Runner, Wily Introscope 8.0, Mercury BAC, BMC Patrol, Perceiver, Statspack/AWR, Precise, Oracle EM, NMON, Measureware(OVPA), Glance, TOAD, Eclipse (BIRT), Windows services for Unix.

Roles & Responsibilities

• Understand Light Speed architecture (Components involved, Internal & external interfaces, Communication protocols, business and process flows for all critical processes)
• Collect information from Specification team on Critical business processes, applications involved and its response time(SLA).
• Record script with required number of action blocks and transactions for all identified business processes of Lightspeed applications(HTTP/HTML, Web Services).
• Playback the script and correlate all dynamic values within the script
• Prepare test data and parameterize the script with required parameters.
• Add text/content check required to check text/content from server.
• Create required user defined functions to eliminate duplication in script & keep the dll in loadrunner library and add library file in script.
• Identify Performance scenarios based on business requirements(NFR) and setup scenario in Performance center with total Vusers, Rampup, Rampdown, Phasing, Iterations, think time, Scenario type, Run mode,Ect
• Setup and configure monitoring components based on requirement
• Run the scenarion and collect the results for analysis.
• Analyze the loadrunner results and identify the problematic transactions for root cause analysis.
• Collect performance statistics for all servers,Applications involved in test execution using Introscope, BMC Patrol, Statspack & Precise and find out Application/DB components & System resources lead to performance degradation(High response time/Failures).
• Prepare runtime and detailed analysis report with root cause analysis and recommendations to improve performance and handling the report delivery to Amdocs testing team during test execution.
• Involve in PDB file creation for custom classes/methods and PBD file deployment in all required servers
• Configure Wily Introscope agent in Websphere and Weblogic application servers
• Create management modules with all metric groupings required to consolidate group of metrics required for performance analysis.
• Create dashboards which show server health, JVM health and J2EE application components performance
• Run transaction trace to find out J2EE components invoked for identified business critical processes
• Work as a SPOC for monitoring team and participated in all relevant calls from onsite
• Involve in preparation of report template for Run time, Detailed analysis and Defect management based on requirements from Amdocs testing team.
• Onsite Coordinator for monitoring team and resolve the issues by contacting concerned people
• Install Oracle 10g Server software & create database for Analytics application.
• Create required tablespaces, users, roles, tables, indexes, views, triggers and administration of database.
• Export and import data into analytics DB from remote DB using database link and schema/database import/export using data pump import/export utility.
• Analyze the database performance using AWR/ADDM and advisors (segment, Undo, Memory, SQL access and SQL tuning)) statistics and tune the database to improve performance.
• Schedule level0 and incremental backup using RMAN and perform recovery to restore the whole database or selected objects, If required.
• Created stored procedures to automate the data import, data manipulation & performance analysis for Analytics and canary analysis.
• Created macro for Analytics to consolidate data from Introscope into required destination table format
• Modified the Hardware and Software reports using Eclipse(BIRT)in Analytics application(Java/Html)
• Convert Perl and Shell scripts into Oracle stored procedures for canary analysis
• Created shell scripts to automate the Tuxedo services and Q utilization statistics collection process.

Training and Certifications:

Completed Oracle OCA-SQL Fundamentals I(1Z1-051) certification with 98.18%
Completed HP0-M18 HP LoadRunner Software Exam with 100%
Completed HP0-M19 HP Virtual User Generator Software Exam with 98%
Got valuable team player award for the year 2008.