SUMMARY:

• Around 7 years of diverse experience in the field of Information Technology with emphasis on Software Quality Assurance and testing experience in a wide variety of environments. Experience with different life cycle (SDLC) methodologies (water fall, V-model, Agile).
• Highly motivated, Goal-Oriented, self motivated Professional with excellent Problem Solving skills, Communication Skills verbal and written as well, trouble shooter, and strong drive to exceed customer expectations.
• Experience in Business Analysis by gathering requirements and understanding the process.
• Identifying test data towards End to End test plan.
• Experience in creating and analyzing System test plans, defining test cases both manual and automated using Standard QA methodologies in all aspects of testing types unit testing, functional testing (GUI), Integration Testing, Regression Testing, System Testing.
• Data Analysis using SQL and PL/SQL.
• Experience in creating and testing OBIEE (Oracle Business Intelligence Enterprise Edition) reports and in verification and validation of data.
• Supported and participated in UAT testing in staging environment to production.
• Expertise in Bug Reports using Bug tracking Tools.
• Expertise in preparing project plan with MS VISIO and MS Office suite products.

Educational Qualifications:
Masters in Business Administration (MBA) - Major in HR & Computer Science.

TECHNOLIGIES:

Tools: Quality Center, QTP, OBIEE, SQL Developer, TOAD, MS Office, MS Visio Defect

Tracking Tools: Clear quest , Quality Center. Testing

Methodologies: Unit testing, Integration testing, Regression testing, System testing, UAT.

Languages: SQL, PL/SQL, VB, .net, ASP, Java, XML, HTML, Shell script, VB Script

Operating System: Windows 95/98/2000/ME, NT/XP,UNIX,LINUX.
Network Protocols: HTTP,TCP/IP,SMTP and Telnet
RDBMS/Database: Oracle 9i/10g,TOAD,SQL Developer, SQL plus. MS Access. DB2.

WORK EXPERIENCE:

Confidential

Irving ,TX Feb\'11-Present.
Sr.QA Engineer.
ADT and Verizon entered into a partnership agreement. ADT will provide Home Security Systems in support of Verizon\'s connected home product offering. ADT will provide initial order processing and installation related activities for the Verizon Connected Home product line when Home Security is requested component. ADT will provide security monitoring and customer support of home security system components installed in a Verizon customer home using mutually agreed upon processes.

Responsibilities:

• QA engineer of Finance work stream for Verizon-ADT project. The goal was to use existing feeds to accommodate Verizon customers.
• Analyzed high level business requirements and gathered necessary details to understand the process and created test plan.
• Communicated with team leads and Business Analyst/Project Manger to gather the necessary information.
• Prepared test plan, test scenarios, test cases and identified test data in perspective of job costing, financial Reporting. Met dead lines.
• Finance work stream is responsible to validate job costing and reporting process. As a part of this I have gathered and analyzed requirements.
• Verified all Verizon jobs comes under predefined Master job numbers. Install jobs are created in Telemar(internal application used to create quote) and Service jobs are created in Mastermind.
• Verified and validated data of install orders created in Telemar has sent to Mastermind. Wrote and executed SQL queries to populate data from these two.
• Mastermind is used to create service jobs and assign jobs to Verizon certified technicians.
• Material installation and time are considered as job costs. Monthly monitoring costs, Commissions, referral fees, etc are considered as program cost. Verified and validated all these costs are incurred.
• Materials used by technicians will be entered into Mastermind(internal application).Verified the master job numbers are assigned to this material(part numbers).
• Verified that after the completion of installation parts are depleted from inventory(Oracle Inventory).Wrote SQL queries to verify and validate the parts are depleted from inventory. To simplify this process created SQL procedure.
• Wrote and executed SQL queries to find out the status flags in ADT Inventory transaction tables before and after depletion process.
• Tech hours are entered into OTM(Oracle Time Management) and eTime
• Verified the jobs created in Telemar and mastermind have same master job number.
• Verified all jobs created by upstream process will be shown in OTM and eTime and grouped under master job numbers so that all costs on this will go to designated SSO(sales service office).
• Verified and validated the revenue captured in Informix(billing application).
• Verified and validated costs incurred by SSO will receive revenue to same SSO.
• Verified and validated various reports and dashboards to monitor profits.
• Used quality center to run test cases and track defects.

Environments:
Mastermind, Informix, Oracle, OTM-Oracle time management, eTime, Quality center Version.10.0,QTP Version 10.0,SQL developer, MS Office, MS Visio.COBOL (Mainframes-CIS), Rational Clear Quest, DB2, MS Access.

Confidential, Aug'10-Feb\'11
Irving, TX
Quality Analyst / Business Analyst.

VFRAME-Verizon Financial Reporting & Analysis Management Environment:
Vframe was developed to provide analysts and management the ability to access standardized financial & managerial information from a single source.
Utilize enhanced tool sets and web based delivery mechanisms for more effective reporting.
DRM One Organizational Hierarchy:
This is a multi faceted project that includes implementing a standard hierarchy which will be fed from OSS to DRM/Wire line to PeopleSoft to VFREAME

Responsibilities:

• Gathered, Analyzed requirements and designed DRM one Organizational Hierarchy Project test plan.
• Assigned responsibilities to respective Implementers.
• Created test Scenarios. Based on these scenarios I have written test cases and generated steps in quality center.
• Created test scenarios, test cases for OBIEE reports and ran test cases according to the scenarios.
• Created SQL scripts to validate data. Evaluated and executed the conversion scripts.
• Prepared Test Plan for Oracle BI Answers to find all subject areas and their user permissions and filter conditions.
• Conducted both UI and data testing.
• Prepared test cases to test Dashboard pages.
• As part of UI testing verified all objects in Dashboard for all different users and found defects which are making performance slow.
• Prepares test cases to test Dashboard pages. Here I have conducted UI testing.
• Tested all objects of dashboard for many users manually.
• Conducted research on existing tables which are subjected to change as per the business requirements.
• Gathered necessary information about the lob_ key changes and prepared document for further reference.
• Created OBIEE reports and verified the data.
• Verified the access to the subject areas by logging in as that particular user.
• Verified and validated data in OBIEE reports.
• Verified the Join conditions in rpd (ODS Schema).
• Prepared the documents what needs to be tested in SIT (testing phase).
• Verified OBIEE filters and compared the results to the data base.
• Wrote SQL queries to find whether the data exists after 2008 and prepared list of tables to be converted or deleted.
• Identified issues to leads and provided possible solutions.

Environment: OBIEE, ORACLE 10g, Windows, UNIX,MS Office, MS VISIO, Quality Center 10.0, SQL Developer, TOAD.

Confidential, Feb '07 - July\'10
Fort worth, TX
QA Analyst/Lead

I. Online Specimen Collection & Tracking System:
PharmChem developed a Website for Online Specimen Collection from manual to automated process. Based on existing forms and future requirements, new systems were defined and developed. The objective was to retrieve existing customer data from legacy systems, capture new data related to Accounts and/or, Customers and connect to Pharm Chem Databank, and propose different options for Test Panel selection. Because of this application, the data entry functionality was shifted from Pharm Chem to Specimen Collector(s) and it reduced the operating cost from $23 to $15 per Specimen.

Responsibilities:

• Gatheredand analyzed requirements, detailed design, and formulated test plan for the functional testing of the application.
• Documented the gathered requirements using MSWord, MS Visio, Excel and PowerPoint.
• Used MS Project for project management and planning
• Performed Black Box testing for whole application
• Conducted web testing from functionality to security testing.
• Analyzed business requirements and functional specification documents to write test cases
• Interacted with developers and Business Analyst team to discuss the design and testing scenarios of the application
• Entered all test requirements into Quality center requirement module and based on this wrote test cases in test plan module.
• Performed GUI testing in applications user interface to determine application and user interaction. Typically tested keyboard and mouse interactions and how it displays screen text, images, buttons menus, dialog boxes etc.
• For regression testing I have created automated test scripts using QTP. These test cases we have used in different stages.
• Conducted back end testing using SQL queries to validate data. Created SQL procedures and used existing functions.
• Created SQL stored procedures to automate the testing process by creating shell scripts in Unix.
• Wrote reusable test cases.
• Extensively used Recovery Scenarios while doing the regression testing.
• Performed IST (Integrated System Testing), regression on different operating system and browsers.
• Participated in all aspects of web testing. In the Functional web testing I have tested all links in web pages, database connections used in web pages for submitting or getting information from user. This application\'s main purpose is to get all sensitive information from customers and types of lab work ordered for them. In Interface testing, I have verified Web server(IIS), Application server and Database interactions.
• Tested Web Services by changing parameter values in the application and verified SOAP request and responses.
• Tested XML responses for those web service functions.
• In Usability testing I have conducted testing for navigation to see how user surfs the web pages, different control buttons and in content checking I have verified common accepted standards that are used for web page building.
• Used Quality Center to report and track defects. Ensured that the severity level for the bugs was assigned properly and the highest severity bugs were resolved immediately so interacted with developers to resolve any defects and issues.
• Participated in End to End testing.
• Used XML editor, XML schema for data validation and verification.
• Responsible for weekly status, attend the meetings showing progress and future testing efforts

Environment:Quality Center 10.0, Cobol, Mainframes, EMIT Analyzer, Windows 2000, JSP, HTML, DHTML, CSS,IIS, MS Visio, MS Project, UNIX, QTP.

II. Automated Testing & Laboratory Analysis System (ATLAS):
PharmChem developed an automated Laboratory Information System (LIS) called ATLAS. It is developed to automate the Laboratory process in various departments like SRD, EMIT, GCMS,DR, STORAGE, and CUSTOMER SERVICES.

Responsibilities:

• Coordinating with teams like business, brokers, and external customers, which are involved in the interfacing of the application
• Gathered requirements through general meetings, study design document & conference calls and documented the requirements
• Participated in the Business review meetings and developed Test plan for System using the Business Specifications.
• Manually performed the functionally testing and also was responsible completing the regression testing
• Conducted the System integration testing of the application manually for different Modules.
• Performing queries to the database using \'SQL\' to check successful Transaction & to create particular test cases
• Presentation of the QA Status report and the Defect Status reports in the weekly meeting.
• Developed the Automated scripts using QTP for Regression and system testing.
• Worked very closely with the Business Team, Development team and Management.
• Point of contact for both onshore and offshore for testing related activities
• Interacting with Development and QA Teams to ensure overall quality of the software
• Involved in Logging defects, Monitoring their status and tracking them to closure using Quality Center.
• Participated in the Weekly status meetings with the users.
• Developed various reports to communicate testing issues to the project manager.

Environment: Quality Center 9.0, Clear quest, ASP.Net, EMIT Analyzer, Windows NT/2000, Unix, QTP 9.5, SQL Scripts, PL/SQL, SQL*Plus.

Confidential, Feb\'04-Nov\'06
Irving, TX
QualityAnalyst

eRegistration:
Confidential, customers are encouraged to register online to receive information through emails and have access to Bill View and Bill Pay applications. A temporary user_id and password being generated and printed on monthly bill and asked customers to go online and register their information and create permanent user_id and password. Customers who registered online will have access to view their Bill and full access to all the information. Also provide access Bill Pay application to pay online securely. This application (eRegistration) encourages the customers to register online and provides all the required information to the customer. It also encourages the customers to sign up with different products that are in promotion online. This application not only cut down the cost and also promotes the business thru online advertisement.

Responsibilities:

• Involved in reviewing functional design specifications, developing test strategies and specification as well as test plan and reports.
• Created Test cases for the manual testing of the application.
• Involved in Regression testing, Functional testing, Integration testing and System testing.
• Involved in analyzing the test results and identifying and solving the bottlenecks, and documenting the test results.
• Performed the System integration testing of the application manually for different Modules
• Involved in coordinating the test plan development, test cases and tests execution.
• Developed SQL queries to perform Database Testing. Created shell scripts to automate testing
• Documented test cases according to the test scenarios and wrote automated test scripts using QTP.
• Participated in User Acceptance Testing (UAT), coordinated and dealt with users for maintaining better quality standards. Created UAT test scripts knowing the expected outcomes based on User requirements.
• Interaction with developers and Business Analyst team to discuss the design and testing scenarios of the application.
• Retested the defects that are in Test status and updated the defect-tracking sheet.
  Participated in status meetings to report issues.
• Analyzed, documented and maintained Test Results and Test Logs.
• Defects were tracked and reported using Test Director.
• Responsible for providing regular test reports to the management.

Environment:Test Director 6.0,QTP, HTML, ASP.NET, JavaScript, Oracle, PL/SQL, Windows NT, Solaris, UNIX.