Summary

8 Years of diverse experience in Information Technology with emphasis on Developer and Testing in Client/Server and Web based applications. Proficient in Manual and Automation testing using Mercury tools (QTP, Win Runner, Quality Center/Test Director, Load Runner) and Rational Tools (Clear case, Clear Quest) on Windows, Mainframe (IMS) and Unix/Linux Environment.

• Experience in Manual and Automation (Load and Performance) testing of Web and client/server applications on UNIX and Windows environment.
• Good understanding of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Bug Life Cycle (BLC)
• Involved in Stress testing, performance testing and Load testing using Mercury Tool Load Runner
• Expertise in RDBMS backend testing for data validation and data integrity using SQL Queries on DB2, Oracle and SQL Server and using stored procedures in PL/SQL, Executed negative and positive test cases to test application functionality against user requirements
• Excellent Reporting and Presentation skills using MS Excel and MS PowerPoint.
• Experienced in software analysis, Requirements Management, Quality Assurance, Modeling and Configuration Management.
• Extensive knowledge in implementing Structured Methodologies test plans, test cases, test scenarios and test deliverables
• Knowledge of protocols, FIX, VOIP, TCP/IP, FTP and HTTP.
• Proficient indesigningand executingtest cases – both manual and automated. Involved in developing and maintaining automation test scripts.
• Experienced in various types of testing like, Black box, White box, Functional test, Integration test, System test, User Acceptance test, Regression test, and Performance Testing.
• Proficient in Oracle9i, PL/SQL, Unix, Linux, Cobol
• Expertise in review and documentation of system Test plans and creating Test cases on the basis of products releases features, client\'s requirements and related technical document.
• Enthusiastic team oriented member with good communication skills. Ability to work in tight schedules and on different applications concurrently.

Technical skills

Programming Languages : J2EE, .Net, C, C++, VB and COBOL.
Database : SQL, Oracle 9i.MYSQL
Web : HTML, XML, VB Script, Java Script, Apache,  Web Logic
Operating System : Windows 95/98/2K/XP/NT, UNIX, Linux.
Testing Tools : Win runner, Load Runner, Test director, QTP8.0, Quality Center
Test Strategies : Manual, Integration (System), Regression, User Acceptance (Beta), Functional, Compatibility, Product Verification.
Version Control : Rational Clear Case, Requisite Pro, SVN, CVS, Mercator.
Bug Tracking Tools : Rational Clear Quest, Heat, BugZilla, Dragnet,  Jira, Testdirector, Quality Center, Trac, Test Track

Project Details

Client: Confidential, Brea, CA May 09 to Present 
Role: ETL and OBIEE Testing Lead

Confidential. is a leading manufacturer of biomedical testing instrument systems, tests and supplies that simplify and automate laboratory processes. The project is to build and maintain the enterprise level data warehouse.

Job Responsibilities:

• Understand the Functional and Design Requirements.
• Under standing the software development life cycle (SDLC)
• Create the Test Plan, Test Scripts using Business rule from mapping document
• Using SQL Query Compare each customized column from Target and Source.
• Create the SQL Scripts for Table count, Null Values, Zero’s and Row_wid’s.
• Involved in ETL testing Initial and Incremental load of each cycle in different schemas
• Create the test result of each cycle and upload the client internal site share point.
• Participate the test status meeting weekly and update the status to QA Director.
• Involved in repository testing.
• Performs data quality analysis using advanced SQL skills.
• Tracks defects to ensure appropriate management and escalation of defects. Coordinate defect resolution and retesting.
• Involved all modules(Service,SCM,HR,Comm Aps and Finance) of ETL testing
• Tested all modules of reports data and validate the data against Oracle EBS source system
• Involved in Different type of testing Like Security testing, Regression testing.
• Using UPK tool create Report documents and publish for UAT Testing.
• Participates in root cause analysis for defects and provides process improvement suggestions to eliminate future occurrences of similar defects.
• Interact with Offshore team update their status to Client team.
• Able to work in tight dead lines, as well as independently.
• Performed Regression testing with QTP by executing the automation test scripts

Environment: Windows XP,Test Director,QTP9.0SQL Server, MS- Office ,Core-FTP, Unix,CITRIX,Oracle BI Interactive Dashboards, Answers, UAT Environment , Share Point ,Security Testing ,Test Track, Source(GCX/GCT) and Target Systems (DWH),Oracle 11i, Oracle Applications(Financial, HR, Service and Supply Chain Management, Commercial Apps), Informatica 8.1.1, TOAD 8.0, DAC, Business Objects, OBIEE, IIS, Windows XP Client and UNIX Server, UPK Client.

Client: Confidential, Chicago, IL Feb 08 to Apr 09.

Project: Access Direct.
Role: Performance QA Lead

Access Direct is a banking application that is designed to handle the sending and processing of large volumes of payment/collection instructions and multi-bank reporting information by direct electronic communication. Moreover, AD generates status acknowledgements as well as routes the status acknowledgements received from the various partner banks or back offices back to the customers. All the processes that take place in AD are for the functioning of these basic flows (Payments, Acks, and Reports).

Job Responsibilities:

• Understand the Functional and Design Requirements.
• Under standing the software development life cycle (SDLC)
• Create the RTM’s (Requirement Traceability Matrix) and wrote the test cases based on the functional document.
• Create the payment files like different formats ( BELI,DTA,PEXR,CLIOP,NORMA,BTL91
• FLAT FILE, EDIFACT (PAYMUL & DIREDEB), XML, X12, LSV, SEPA)
• Process the payment files thru different channels like FTP, AO, File Act, File Handler and GXS.
• Process the payment files thru Different Security Mechanisms like Entrust, AUTACK,TD Access ,SAFEX.
• Good Exposure in the Intersystem Cache.
• Verify the complete payment, ack and report flows using the TOAD and Access Direct.
• Create the customer , ack and report routing setups and process the payment files and verify the recreate formats
• Log the project-related issues on test management tool Test Director update the test case result in TD.
• Analyzing results, identifying solutions that may improve application performance or system capacity
• Manually tested web application using Adobe flex.
• Completely involved manual regression cycle on different environments like SIT ,UAT, Pre-Prod
• Involved in the Performance testing and High Availability testing on UAT and Preprod Environments
• Verify the payment files Access direct UI monitor.
• Verification, Extraction and Loading of test data into DB by using ETL tools
• Coordinate with other team members and update the test status to test manager on daily basis
• Tested on UAT and Production Tickets and immediate support to customers.
• Involved the GPL (Global Payment Link) Formats ISO8583, Bankline IAT, Bank line HVP, Royal line IAT and GPL end to end testing.
• Involved User Acceptance testing web based application of Access direct
• Write and executing SQL Queries for complete payment process
• Create the Payment, ack and report files for different customers and account numbers.
• Involved the customer migration and create the customer and account setup in both databases and upload the payment files and verify the database payment successfully loaded
• Verify Forward mechanism in Payments, Acks and Reports on both databases.
• Report the problems and interact with Access online team on regular basis.
• Migrate customers and roll back the same customers and verify the data on Access Direct Using the Web Monitor.
• Tested extensively the new Link (GXS) to Access Direct ABNAMRO Payment Gateway that replaces the existing FTP.
• Understanding and Testing of RBS legacy formats to process Payments and Acknowledgements using Access Direct Payment Gateway.
• Testing of Reports, supporting RBS specific SWIFT ADDRESSSES via ACCESS DIRECT Payment gateway.
• Learning and executing Automation Regression of various RBS legacy Payment formats using Win Runner
• Experience with performance testing on Web sphere commerce and Web Sphere Commerce Server
• Tested extensively the New Production environment built by RBS to support Access Direct Payment Gateway.

This testing includes:
1. Testing of all the 3 flows Payment, Acknowledgements and Reports.
2. Testing of Access Direct Connectivity with other supporting Application like, Payment Router, Report Router and Access Online.

Environment: Windows XP, Test Director, Win runner, J2EE, XML, Oracle 9i, FIX,TOAD, Ultra-Edit, MS- Office ,Core-FTP, Unix,CITRIX, SQL, Access Direct, UAT and Pre-Prod Environment , WCS, Selenium, FLEX, Web Monitor ,ETL, IBM Web Sphere(Mercator), WTX ,Access Online ,File act(Swift Net),File Handler, Adobe flex, Load Runner, Entrust ,WATIR, Load Runner .

Client: Confidential, CT Aug 06– Jan 08.

Project: Online banking
Role: Performance engineer 
This application was developed for online services in Banking, Lending and investing. These services are broadly classified into personal and corporate. This site also provides the Up-to-date business news including checking & Saving, Home Mortgage, Insurance information and numerous other services.

Responsibilities:

• Prepare Software Test Plan, develop and review the Test cases & Test Scripts for System, Integration, Regression and User Acceptance testing.
• Analyze requirements during the requirements analysis phase of projects and escalate concerns
• Test Case Management using Mercury Quality center.
• Keep track of the new requirements & Change Requests for the Project.
• Forecast / Estimate the Project future requirements and ensure proper documentation of the same
• I was solely responsible for testing and generating reports for online Banking application.
• Performed Manual Testing on this Web based application and automated by using Win Runner.
• Arrange the Hardware and software requirement for the Test Setup.
• Escalate the issues about project requirements (Software, Hardware, Resources) to Project Manager
• Extensive knowledge of Equities and Options Trade Clearing systems required.
• Involved working on the FIX Analyzer tool which monitors and analyzes your FIX Trading flow, instantly reporting problems and important trading events and activities by monitoring the content and status of your message traffic in online/real time or offline mode.
• Organize meetings, Prepare agenda for the meetings including Weekly Team/Status meetings
• Attend regular status calls and update the client with weekly/daily status
• Act as the single point of contact/escalation between Dev team and Test team for Iterations, Testing and Deployment activities.
• Automation using Mercury QTP.
• Testing adobe and flex applications using adobe and flex addin in QTP
• Involved load testing, regression testing and system testing.
• Involved in performance and manual testing of Adobe Flex based web applications
• Managed a team of around 2 testers.
• Experience with performance testing on Web sphere commerce and Web Sphere Commerce Server.
• Track and report upon testing activities, including testing results & defects
• Ensure content and structure of all Testing documents / artifacts are documented and maintained.
• Wrote SQL Queries using TOAD to validate the data in Oracle database.
• Daily status check meetings with the team, review various reports prepared by Test engineers.
• Log project related issues in the defect tracking tool identified for the project (Rational ClearQuest)
• Check for timely delivery of different milestones, Identify Training requirements and forward it to the Project Manager (Technical and Soft skills).

Environment: Quality center, QTP 8.0, Java, J2EE, XML, Oracle 9i, ETL ,TOAD, Microsoft SQL Server – SQL Query Analyzer/Rapid SQL 7.4, FIX, Rational Clear Case, Clear Quest , Load Runner,WATIR XMLSPY 2004 Professional Edition, Microsoft Visual SourceSafe 6.0,Unix, shell scripting, SVN, Beyond Compare,

Client: Confidential, Cupertino CA Dec 04 to July06.

Project: Mobile Movie Times

Role : Sr QA Associate

Confidential is a Silicon Valley is a communications, telecom, consumer wireless, web services and enterprise software. Confidential makes over 50 dynamic mobile applications and widgets that work together and are based on mash-ups of web services. Around the globe, people use Confidential\'s applications to locate the hottest bars, call a cab, book a table at the latest restaurants and stay current with popular events like the Cricket World Cup - all with very few clicks and minimal or no data entry. 

Role and Responsibilities

• Understand Functional and Design Requirements.
• Wrote Test Strategy and coordinate with the development team, Project Manager and Product Manager on different Change Request and attended Kick Off meeting.
• Detecting bugs classify them based on the severity and reporting them and filed in Bugzilla.
• Install gateway files Start Tomcat and Jboss servers
• Involved load testing, regression testing and system testing.
• Prepared the test environment and maintain the build stages.
• Performed Regression testing with QTP by executing the automation test scripts
• Make a build with automation process deploy gateway. war and Movie times .war on Application server Jboss and Tomcat
• Create the databases and run the feed process on daily basis.
• Involved the database testing inserts, update tables and verify the movie show times and theater details.
• Interacted with the QA manager for the regular update of the project.
• Attended project meetings, release meetings, and QA status meetings
• Responsible and involved in executing the scenarios, monitoring the server response timings, monitoring the throughput, Hits/Sec, Trans/Sec.
• Tested the Web Services (SOAP), both Request and Response Messages.
• Verify the data front end and backend report the problems, discussing with data provided service.
• Deploy the Jad and Jar files on Linux server and make the necessary changes download the files in specified mobile verify and testing on mobile.
• Involved the porting exercise tested the application on different mobiles like Nokia, Motorola, Sony Ericsson, LG
• Logging the defects in defect tracking tool and generated defect reports on a day to-day basis

Environment: Windows XP, Unix, J2ME, MYSQL, Junit,Jboss4.0.3, Manual testing, QTP 8.0, Apache Tomcat 5.5.12, Load Runner, Win SCP, RUBY ,Adobe Acrobat, JMeter,MS Office, BugZilla, Soap, Trac, Weblogic server, XML, MVN, Excel, SVN.

Client : Confidential Jan 01 –Nov 04

Project : Best Value Routing (BVR 3.0)

Role : Developer and Tester 
Confidential. is a global software company that has pioneered a new class of technology called behavior detection that enables businesses to identify risk and opportunity -- often those which have never been found before. Confidential currently provide next-generation analytic applications powered with this technology to the global financial services market. The Confidential Behavior Detection Platform™ was named as "Best Compliance Solution" in Waters Magazine\'s 2003 Editorial Awards. The company has also been ranked as a leading compliance vendor in reports from TowerGroup, Celent Communications and Butler Group.

Best Value Routing (BVR) solution allows telecom carriers to automate call routing with the aim of obtaining the lowest cost and highest Quality of Service (QoS). It facilitated Network Providers to implement the business logic onto the switch and track the call routes accordingly. The software enabled automatic switch updates and elimination of errors on it. It gave an efficient and optimistic output in terms of the best value routing to the switch based on the different conditions and priorities.

Responsibilities

• Understand Functional and Design Requirements. Prepared test cases with expected inputs and outputs.
• Responsible for preparing system test environment by installing the test setups, and the test bed associated with the Databases (including Mediation module).
• Also responsible for duplicating Client Application Environment Setup to re-produce the bugs.
• Prepared the Database Installation Checklist. Responsible for running through this checklist after each installation.
• Executed the test cases and reported bugs using Rational Clear Quest. Tracking the execution through Requirements Traceability Matrix on a day-to-day basis.
• Tested the entire Mediation process (translating Partner’s Call Data Records (CDR) to the database).
• Developed CDR Generating Test Scripts on PL/SQL.
• Responsible and involved in executing the scenarios, monitoring the server response timings, monitoring the throughput, Hits/Sec, Trans/Sec.
• Prepared the System Test Reports and circulated the reports to the Director of Engineering.
• Root cause analysis of user-reported problems

Environment:WindowsXP,C,Solaris5.8,VB,.Net,Oracle,UNIX,PL/SQL,TCP/IP,Switches,Routers,Toad,SQL,Manual testing, Win runner, Perl, Shell scripting, Clear Case, Clear Quest, MS Office, FTP, VOIP, Heat, Beyond compare, Toad, Oracle enterprise manager.

Education

• B.E (Computer Science and Engineering)