Profile
Over ten years of diverse experience in Information Technology with emphasis on Quality Assurance.
Certification
MCSE: Microsoft Certified System Engineer (NT 4.0)
MCSA: Microsoft Certified System Administrator (Windows 2000)
CWNA: Certified Wireless Network Administrator
CCA: Citrix Certified Administrator
CPS: Certified Product Specialist (LoadRunner 8.0)
CCNA (OLD):
SPECIFIC EXPERTISE:
Developed Test Plans and created Test Cases
Excellent skills in manual testing as well as in automating tests using WinRunner, LoadRunner, Rational, Empirix, WebLoad and Test Director.
Good understanding of the Software testing Methodologies.
Expertise in Load, Stress and performance testing using LoadRunner.
Experienced in Parameterization of the test scripts.
Expertise in Analyzing LoadRunner Scenarios Results using online monitors.
Experience with SOAP testing and knowledge of WSDL.
Enhanced Vuser script by inserting toggle points, transaction points and Rendezvous points.
Expertise in Back End Testing using SQL queries and Shell Scripts.
Experience in writing, maintaining and updating Test Documentation for various stages of testing for reference and Auditing purposes.
Experienced in Managing Requirements, test cases, Bug Reporting and Defect tracking using Test Director.
Good team player and have ability to work independently
Possess excellent communication skills along with verbal and written skills.
SKILLS:
Testing tools WinRunner, LoadRunner, Rational, WebLoad
Programming Languages C, Visual C++, Java, ASP.NET
Databases Oracle, ACCESS
Web Technologies and Scripting Languages HTML, Java Script, PERL, SOAP, WINSOCK
Operating Systems Windows 95/98/XP, Windows NT/2000, Unix, Linux
Protocols TCP/IP, HTTP, FTP, ODBC, BGP, RIP, OSPF
Testing Language: Test Script Language (TSL), SQABasic
Bug Reporting Tools Test director, ClearQuest
EXPERIENCE:
College Board Oct 10 - To Date
Role: Sr. Performance Lead
Project Description: College Board is a not-for-profit membership organization committed to excellence and equity in education. College Board mission is to connect students to college success and opportunity.
Applications:
CQS ( Quick College Stat)
Profile (Domestic and International Students)
PSSS
Responsibilities:
Communication/ Leadership
• Involved in construction of Performance WLDM
• Gathered Performance Testing requirements and created performance test plans.
• Created templates for performance test report and analysis report.
WLDM /Data/ Script Creation/ Execution
• Developed WebLoad scripts using WebLoad IDE to conduct load, stress and endurance test
• Parameterized IDE Scripts in WebLoad using Java Script functions.
• Executed performance test scenarios using WebLoad Controller.
• Correlated and Parameterize vendor simulated test Agenda using WebLoad.
Monitoring/ Analysis
• Worked with the Capacity Planning team to publish the performance test report.
• UNIX monitoring and configuration
Environment: Windows XP/NT, UNIX, WebLoad, Rational ClearCase, Rational ClearQuest, Oracle, WebLogic, SiteScope
Freddie Mac Jan 09 – Oct 10
Role: Sr. Performance Lead
Project Description: Freddie Mac is US Federal Govt. Sponsored Enterprise, which buys mortgage in secondary market and sells them as mortgage-backed security to investors in open market. I was involved in performance testing of web-applications called selling system and pricing management application, which are one stop application for investor to sell and negotiate mortgages with Freddie Mac in accordance of the current Fixed and ARM Mortgage Rates in the Market.
Applications:
LP ( Loan Prospector)
Servicing Portal (MIDAS)
NPL Application
Workout Prospector
Home Steps
Expense Remittance System
LMWS (Loan Modification Workout)
HAMP WPII
Responsibilities:
Communication/ Leadership
• Involved in construction of Performance WLDM
• Gathered Performance Testing requirements and created performance test plans.
• Developed performance strategy and test data management plan and provided walkthrough for the same.
• Provided performance scope document with milestones
• Conducted daily status meetings and provided close out report
WLDM /Data/ Script Creation/ Execution
• Created and cloned the test data using LoadRunner Script for various performance tests.
• Developed LoadRunner scripts using VuGen to conduct load, stress and endurance test
• Parameterized VuGen Scripts to ensure real time load conditions in LoadRunner.
• Executed performance test scenarios using HP Performance Center
• Correlated and Parameterize vendor simulated test Agenda using LoadRunner.
• Developed scenarios based on WLDM
Monitoring/ Analysis
• Used Web logic admin consoles and introscope to monitor application health during various type of Performance
Test
• Analyzed web servers performance & framework logs to find out most time consuming code in the
Applications
• Worked with DBA team to set up and use DB monitoring and Query profiling to find out DB
Deadlocks, most time consuming queries and tuning of the time consuming queries.
• Documented Response time for login, Response time for individual pages, Throughput
Per transaction, total # of simulated users, Average web server queue length, Average Application
Server queuing.
• Monitored overall application server CPU utilization, Memory utilization of application servers,
Web servers and database servers and reported application scalability using UNIX monitoring
Utilities. (Vmstat, Iostat, Mpstat etc.)
Reporting
• Reported test defects in IBM Clear Quest and worked with concerned work group to resolve performance issues.
Environment: Windows XP/NT, UNIX, Mercury LoadRunner 9.52, Rational ClearCase, Rational ClearQuest, Oracle, WebLogic, Fuse, SEDA, JMS, Introscope
FEPOC, Washington DC Dec 07-Dec 08
Role: Sr. Performance Lead
(Care First Blue Cross Blue Shield Federal Employees Program)
The AIM of this project is to analyze the system functionality and list out the various services and their interdependency and common components in order to replace/come up with SOA (Service oriented Architecture). Supported claim enrollment and retrieval of the existing claims.
Responsibilities:
• Gathered performance requirements by interacting with the stakeholders and reviewing the manual test cases
• Prepared performance test plan and test data management plan
• Divided each script into a components to facilitate reusability
• Created scenarios for Baseline, Environment Shakeout Test, Benchmark, Load, Stress, Endurance and Fail over Recovery performance test types
• Executed Network Shakeout Tests to identify the Network Capability
• Ran Baseline, Environment Shakeout Test, Benchmark, Load, Stress, Endurance and Fail Over
• Recovery on the Staging and Beta Environments
• Identified bottlenecks related to Network and WebSphere Server
• Involved in Internal and External Load Testing
• Prepared performance test reports for all the performance test types
• Involved in UNIX monitor configuration
Environment: COBOL, JCL, CICS, VSAM, DB2, CHGMAN, Mercury Quality Center, LoadRunner
Freddie Mac Nov 06 – Dec 07
Sr. Performance Engineer
Freddie Mac, the leader in the secondary mortgage market performs many real estate financial services such as purchase of primary mortgages, packaging of loans into securities and sale of securities on the stock market. The activity of Freddie Mac in the secondary mortgage industry helps to keep the interest rates low, moderate the cyclical swings in the housing market, redistributes the flow of mortgage funds regionally throughout the U.S. and provides for the availability of mortgage funds at all times. The applications here are in HTTP/web protocol
Responsibilities:
• Created automated scripts in Rational VU recorder and Mercury Loadrunner
• Parameterized the scripts so that they can be run with different data
• Created custom designed functions in C in both Rational and Loadrunner to ease the parameterization, data mapping and pass/fail determination of test cases
• Created workload model to simulate actual production peak hour transactions
• Ran Performance test on the environment and monitored the different application and database servers
• Pulled in reports from the application and database servers to study the CPU Utilization, Heap information, memory used and other such criteria to determine whether the application is running as per Non-functional Requirements (NFR) set by the business users
• Performed backend testing on the DB2 database using SQL queries to ensure that the data populated was in the right format and status.
Projects:
Selling System: This is a web application designed for the acquisition of loans from the primary mortgage lenders, such as Wells Fargo, Farmer’s Bank etc.
Challenges
• The project was initially scripted in Rational and the scripts were really long and cumbersome
• Created Custom designed function in Rational to ease the method of scripting
• Up on acquisition of LoadRunner by the company, helped convert all the Rational Projects into LoadRunner projects and still maintain the same load scenario from that of Rational
• Created document for scripting standards in Rational for the selling system and also helped create a similar one for LoadRunner
Loan Quantum Replacement (LQR): Quantum is a legacy application used by the underwriters of Freddie Mac to review and underwrite loans that are brought into the company. The Visionet Vision Loan Review (VLR) is a Commercial Off The Shelf (COTS) product to be bought by Freddie Mac to replace the existing Quantum. The VLR is a .NET application. Prior to the purchase of the product the company conducted multiple test such as Performance, Product Acceptance testing, System Integration testing for the 90-day evaluation period. The database was a SQL Server.
Challenges:
• Took over the entire responsibility of the Performance testing
• Worked with vendors (Visionet Systems) and the business users to better understand the system
• Collected Non Functional Requirements for the Evaluation phase and helped drive the NFRs in the Customization phase
• Created a test plan document for the Performance testing
• Created Vuser scripts for protocols like HTTP, HTTPS, ODBC on VUGen of Load runner
• Inserted rendezvous point in the scripts to simulate concurrent users on the system.
• Captured up to 800,000 characters of session generated data to be used in the next request
• Created scenarios to simulate the effect of 20, 30 and 40 active users on the system
• Compared results from different scenarios to forecast results if there is an increase on the number of users.
• Prepared test results report and presented it to the LQR team
• Unix Server monitoring
Pricing Managing Adapter (PMA): PMA is a subsystem of the selling system that creates the Buy up/buy down grids, Gfee grids, which are then, used in the Selling system during the acquisition of contracts or individual loans from the Primary mortgage Lenders.
Challenges:
• Extremely short time of 2 weeks to test the projects
• Long use cases of up to 19 pages per use cases had to scripted, parameterized and session variables captured, in the short time frame
Performance Management System (PMS): PMS is a process monitoring system used by the Project managers and other officials higher up to monitor processes at any point of time. Indicators are also set up to monitor process so that warnings may be issued to the relevant people if the process sees any unexpected delays.
Challenges:
• Unexpected problems in the application caused delay in commencement of scripting and the Performance testing time frame was reduced from 5 weeks to 3 weeks
Environment: Windows XP/NT, UNIX, Rational Robot 2003, Mercury LoadRunner 8.1, Rational ClearCase, Rational ClearQuest, Tivoli Access manager, PERL, SQL Server
Nextel, VA June 2006 – Nov 2006
Sr. Performance Tester
Environment: Load Runner 7.8, Test Center 7.8, Performance Center 7.8, SiteScope, Web trends, Windows 2000, Oracle, TOAD, Peoplesoft, J2EE
During the 3rd quarter of 2005 Sprint Corporation and Nextel Communications merged to form a new company Sprint Nextel. This project addresses the consolidation of the HRMS systems of Sprint and Nextel. The strategic solution chosen for HR, Payroll and Benefits Administration is the Nextel PeopleSoft HRMS version 8.8. The project will deliver an operational PeopleSoft HRMS containing all of the legacy Nextel data plus all of the active employees and 2006 terminated employees. The active employees will be paid from this application
Responsibilities:
• Analyzed Business Requirement documents.
• Drafted Test strategies, Test cases and Test plans based on functional specification.
• Created test scripts for
Managers Direct Access (DA) – Hires, transfers, terminations, promotions and demotions are maintained and recorded
Payroll (PY) – Maintains employee salary and bonus information
Time and Labor (T&L) – Records and maintains employee time and its account coding
Benefits (BN) – Employees can register for and view their current benefits and plans
HR Administration (HR) – Human Resource employees track and approve new and current employee status changes
• Involved in capacity planning and tuning.
• Conducted performance testing using Performance center 7.8, SiteScope and Vugen.
• Monitored VUser, throughput, web server resources, web resources, transaction, hits per second, JVM, JDBC pool and server utilization graphs.
• Conducted Regression testing after every new build and version
• Conducted Load Testing using LoadRunner for response time monitoring
• Experienced With CVS (version control system)
• Managed test suite for each build in Change Synergy.
• Used Change Synergy to report defects and test results
Fannie Mae, DC Nov 2005 – June 2006
Sr. Performance Tester
Environment: Load Runner 7.8, Test Center 7.8, Performance Center 7.8, SiteScope, Web trends, Windows 2000, Oracle, TOAD, Peoplesoft, Web Emulator, J2EE
Loan Delivery (LD): System used by Fannie Mae customers, i.e. lenders, to deliver pools of MBS or cash loans (sold to Fannie Mae) by uploading and then submitting those loans to Fannie for processing. During upload and/or submission of pools, a data editing process takes place to verify the information uploaded in terms of formatting and business logic.
Document Certification (DC): Once pools of loans have been uploaded and submitted to Fannie Mae, the lenders submit pool and loans information to a document custodian (a 3-rd party) for certification. The custodian verifies that the information received by Fannie Mae via LD matches the information in the documents submitted by the lenders.
Additional Data Elements (ADE): System used by Fannie Mae customers, i.e. lenders, to upload and submit additional data associated with previously submitted pools via LD. An example of such data is Housing Goals data, i.e. fields.
• Interacted with the Development team throughout the entire Software Development Life Cycle (SDLC) to review and adjust the Test Plan/Test Cases as per changing requirements.
• Performed Manual Execution of several Test Cases from Test Director.
• Performed Functional testing, GUI testing and Database Integrity testing.
• Identifying Test Cases to be run for Regression Testing and creation of automated test scripts using Mercury QuickTestPro.
• Prepared Automation Regression Test Plan.
• Executed, maintained, logged and reported on test case execution using Test Director.
• Involved in Evaluation of structure and traceability of regression test suite
• Involved in Risk Assessment of various components of the application.
• Involved in setting up the QA environment in UNIX.
• Performed Batch Tests on the UNIX platform using Shell Scripting.
• Batch testing using UNIX shell scripts was performed to play back test against new, untested versions of the application to identify application defects.
• Performed Data Validation and Data Integration using SQL Queries.
• Performed Backend testing to test the validity of data using SQL Queries.
• Viewed, verified and, updated the test data in the database by using Toad.
• Executed UNIX Shell Scripts for Data Dump.
• Involved in preparation of Performance Test Plan
• Performance Testing was conducted using LoadRunner to measure System Response Time by exercising numerous functionality concurrently.
• Developed and enhanced various test scripts using LoadRunner VuGen.
• Involved in running UNIX Shell to back up daily test data and disk clean up.
• Created Test Scenario for Performance Benchmark Test.
• Used different Online Monitors and Analysis tool to analyze the performance of the application under test.
Nextel, VA Mar 2005 – Nov 2005
Sr. Performance Tester
Environment: Load Runner 7.8, Test Center 7.8, Performance Center 7.8, SiteScope, Web trends, Windows 2000, Oracle, TOAD, J2EE
• FAST: The Activation Service Tool (FAST) is a browser-based order processing system designed to service, fulfill, and activate phone and accessory orders generated by the different Nextel sales channels.
• TOES: TOES stands for Telemarketing Order Entry System and launched in June 2001. It is a web-based application developed to replace disparate, vendor-specific systems that are currently capturing customer and order information
• OVM/TMR: The Order Validation Module (OVM) is a NEXTEL gateway system for Online Authorized Resellers (OARs) to interface with Nextel’s Fulfillment Activation Service Tool (FAST).
• WIAT: WIAT is a tool used to add data, voice, Direct Connect and other offerings to Nextel units already in service. This is used by the Nextel Account Representatives to add services to existing Nextel units.
• PASS: The PASS application is being developed to provide a workflow tool for Care, Sales Support, and the Affinity Support Desk to support status, updates and inserts for Partner awards.
• OTM: The OTM – the Order Tracking Module is an integral part of the Order Processing environment at Nextel. The Order Tracking Module provides the ability to obtain real-time status of orders entered via Websales (Nextel.com), Custom Aisles, and Telesales channels from initial submission through activation (including accessory-only orders).
Worked as a senior performance tester for creating a test script and monitoring results.
Responsibilities:
• Analyzed Business Requirement documents.
• Drafted Test strategies, Test cases and Test plans based on functional specification.
• Collected data for Load model using Web trends.
• Used TOAD for creating test data.
• Conducted performance testing using Performance center 7.8, SiteScope and Vugen.
• Conducted load testing to generate the load on the server by creating VUser scripts in LoadRunner.
• Performed auto correlation testing for checking difference in two versions in LoadRunner.
• Monitored VUser, throughput, web server resources, web resources, transaction, hits per second, JVM, JDBC pool and server utilization graphs.
• Testing IP based products regarding Layer 2 and Layer 3 technology. Involved in testing routing and its associated protocols (BGP, RIP, OSPF), switch connectivity, VLANs, and VoIP.
• Conducted Regression testing after every new build and version
• Conducted Load Testing using LoadRunner for response time monitoring
• Experienced With CVS (version control system)
• Administrated user groups and their access in Test Director
• Managed test suite for each build in Test Director
• Used Test Director to report defects and test results
Merrill Lynch, NY Oct 2004 – Dec 2004
Programmer Analyst
Environment: Load Runner, Windows 2000, Oracle, Java, TestDirector, and ASP
Project Description: Merrill Lynch is leading financial company, which provides services in personal, small business and corporate accounts. I have worked on Merrily Lynch Benefits Online (BOL) web-based system. Benefits Online (BOL) system is designed to help participant to manage their Profile online. It helps the participant to exercise their stock options, 401(k) plan and other financial planning. I have worked on Withdrawal & Termination, Advice Access, Enrollments and ExSOP module of the system. I was involved in testing BOL application manually and using automated Tools like LoadRunner Team Test.
Responsibilities:
• Analyzed Business Requirement documents.
• Drafted Test strategies, Test cases and Test plans based on functional specification.
• Conducted parameterization in LoadRunner.
• Conducted performance testing using LoadRunner.
• Configured Multiple IP addresses for Load testing in LoadRunner.
• Conducted load testing to generate the load on the server by creating Vuser scripts in LoadRunner.
• Performed auto correlation testing for checking difference in two versions in LoadRunner.
• Monitored Vuser, throughput, web server resources, web resources, transaction, hits per second, pages downloaded per sec and network monitored group.
• Conducted Regression testing after every new build and version
• Involved in Configuration testing.
• Performed regression testing.
ENDFORCE, Columbus, OH Jul 2004 – Sep 2004
Programmer Analyst
Environment: Windows 2003, Active Directory, SQL 2000, ASP.NET, DHTML, IIS, IAS, WinRunner, SOAP, WSDL, LoadRunner and TestDirector.
ENDFORCE Enterprise enables business to integrate their existing best-of-bread network infrastructure, security software, and O/S patching into a single, coordinated endpoint defense. ENDFORCE technology completes millions of check each month, improving security policy checks each month, improving security compliance and reporting, and reducing the scope and cost of security intrusions.
This was a client-server application. The company’s website is developed in ASP.NET, DHTML and SQL 2000. It enables its customers to login and access their company accounts. I was involved in setting up IIS and IAS server configuration and testing policy, registration, reports harness and application server installation.
Responsibilities:
• Developed functional specification by meeting with the Project manager and development team.
• Responsible for writing detailed test plan in accordance with the business requirements
• Created and maintained test matrix and tractability matrix.
• Prepared test cases for Agent installation and AdminUI.
• Maintained Test matrix.
• Enhanced Vuser script by inserting toggle points, transaction points and Rendezvous points.
• Performed manual testing for report interface, register interface, policy interface, server installation and admin user interface.
• Testing IP based products regarding Layer 2 and Layer 3 technology. Involved in testing routing and its associated protocols (BGP, RIP, OSPF), switch connectivity, VLANs, and VoIP.
• Conducted testing using Policy harness, Report harness and Registration harness.
• Experience with SOAP testing and knowledge of WSDL.
• Performed gray box by changing code in XML file and fetch using report harness.
• Prepared stored procedures to create 100 to 10,000 users and register them using it and different groups.
• Installed WSE 2.0 for .NET
• Used TestDirector to report defects and test results
• Performed regression testing.
• Participated in weekly meeting and discussed modification request with management
Shyam, LLC Jan 2000 – Jul 2000
Sr. QA Engineer
Environment: LoadRunner, Test Director, Win NT, JSP, Java, SQL, Web Sphere, Oracle, ODBC, WinSock, Citrix
Bank of America is an emerging financial services provider on the Internet with online accounts, bill pay, online investment for equity loans, mortgages and many other services. Use of advanced information technology for costumer acquisition and costumer retention has been the major reasons for its success. The online banking system was developed for the easy access of the customers. The customer can access the savings and checking account information, transfer funds within both the accounts. Clients and customers can apply online for Credit cards, Mortgage and Loans and the application also facilitates with a convenient way to check the account information online.
Responsibilities:
• Acquired Requirements from the Business Analysts, Project Manager and Development teams.
• Responsible for writing detailed test plan in accordance with the business requirements
• Created and maintained test matrix and tractability matrix.
• Met with Project Manager and Development team to give inputs on Database Schema.
• Connected DSN using ODBC
• Used SQL queries to perform the Back-end testing on Oracle.
• Manually conducted Positive and Negative Testing
• Oversaw Manual testing for the front end GUI tests
• Responsible for batch Programming using Unix Shell Scripts.
• Conducted parameterization in LoadRunner.
• Conducted performance testing using LoadRunner.
• Enhanced Vuser script by inserting toggle points, transaction points and Rendezvous points.
• Configured Multiple IP addresses for Load testing in LoadRunner.
• Conducted load testing to generate the load on the server by creating Vuser scripts in LoadRunner.
• Performed auto correlation testing for checking difference in two versions in LoadRunner.
• Conducted Regression testing after every new build and version
• Conducted Load Testing using LoadRunner for response time monitoring
• Performed Front End testing
• Worked on Citrix platform
• Experience With CVS (version control system)
• Conducted UAT Testing.
• Used Test Director to report defects and test results
• Performed functionality, GUI, system and Regression testing of the web-based application using WinRunner.
• Intensive GUI Testing, Functionality and Data Driven Testing using WinRunner.
• Conducted Batch Testing and Regression Testing on the application using WinRunner.
• Conducted testing by inserting Synchronization checkpoint, Bitmap checkpoint and Database checkpoint from WinRunner.
.
EDUCATION:
Master of Science in Electrical Engineering
University of Texas, Arlington
Bachelor of Engineering in Electronics
University of Gujarat, INDIA