LAKSHMI NEKKANTI
******************@*****.***
Cell phone: 647-***-****
Professional Summary:
Six plus years of experience in testing various software applications with major emphasis on Software Quality Assurance, Software Development Life Cycle, Validation & Verification in Windows, J2EE, Mainframes and Unix Environments.Expertise in Planning, Execution, Analysis and Reporting of test cycle.Experience in leading a team of testers being a good facilitator to them.Extensive experience in analyzing technical and business documentation, developing test strategies, Environmental setup and testing preparations.Experience in the creation and maintenance of Master Test Plans, Performance plan, Test cases, Test strategies, Test procedures and Test Scripts.Experience in Unit, Functional, Regression, Integration, System, GUI, Backend, Performance and UAT.Proficient in Manual and Automated testing using Structured Testing Methodologies.Very good experience in developing WinRunner, Quick Test Pro, Rational Functional Tester, Compuware QArun automated scripts of regression testing. Performed testing on Web based J2EE Business, Client/Server, Mainframe, Custom software products and Standalone applications.Handful of experience with Mercury Interactive tools WinRunner, LoadRunner, Test Director, QuickTest Pro, Quality Center and Rational tools like Rational Robot, Rational Functional Tester, Rational Performance Tester, Test Manager, Clear Quest and Compuware tools like QARun, QALoad, QADirectorStrong Knowledge of Data Warehousing and Data modeling Concepts.Performed testing on full life cycle Extraction, Transformation and Loading of Data Warehousing applications. Expertise in composing Complex Queries in SQL for retrieving data from various databases.Experience in describing the problems and issues found, compiling test result, monitoring all fixes, and proofreading documentation prior to release.Good experience in maintaining Defect Tracking System Clear Quest to track and close fixed Defects.Active involvement in project status meetings with developing team, business teams and Clients.Proven ability to support multiple projects under tight deadlines often with competing priorities & complexities.Performed well under little or no supervision. Clear and concise written and verbal communications and Strong analytical, conflict management, team management and problem solving skills.
Technical Skills:
Software Methodologies:
Water Fall/Linear Sequential Model, Spiral Model, Agile Methodology Model, Top Down, Bottom up Methodology, Solutions Delivery Methodology, RUP
Automation Tools:
Test & Defect Management Tools:
Mercury Quality Center, Test Director, Rational Test Manager, Rational Clear Quest, Compuware QADirector
Functional Testing Tools:
Rational Robot, Rational Manual Tester, Rational Functional Tester, WinRunner, LoadRunner, Quick Test Pro, Compuware QARun
Reporting Tools:
Rational SODA
Configuration Management Tools:
Rational Clear Case, MS VSS, MS Sharepoint
SQL Tools:
Toad, PL SQL Developer, SQL Navigator
Other Tools:
DOORS, Rational Requisite Pro, MS-Office, MS - Project, Ab Initio, Adobe – PDF, MS Visio.
Quality Standards:
CMMI, ISO, Six Sigma
Programming Languages:
C, C++, JAVA, SQL, PL-SQL, VB
Test Scripting Languages:
TSL, SQA Basic, VBScript
Web Technologies:
HTML, XML, JavaScript, VBScript, JSP
Web Servers:
Apache Tomcat 4.1, IIS, Web Logic 7.0,Web sphere
Databases:
Oracle, DB2, MS Access, SQL Server6.5,7.0and 2000.
Operating System:
UNIX, Linux, Windows 95/98/XP/NT4.0/2000.AIX
Mainframes:
Attachmate Enterprise 2000, RUMBA, File Aid, MVS, RMS and IMS
Applications:
Financial, Credit Reporting, Insurance, Telecom, Wealth Management and Banking
Summary of Projects:
Client: BELL Canada
Line of Business :Telecom Oct ’08– Till date
Role: Senior QA Analyst
Description: Bell Mobility and Bell residential services application Provided broadband internet and TV Home phone and Mobility and many other services. The project was designed as an interface billing modules and Customer Profiles between Customer Service Representatives and customers. This has interconnectivity with different modules like Customer service, new connection Rate Plan changes and Features changes and Device changes
Responsibilities:
Analyzed system requirements, created and executed detailed Test plan, developed Test cases, Test scripts.Involved in mentoring a QA Team of Four members, managing and scheduling resources and activities for successful completion of project. Involved in developing the Test Plan, Test Cases and Test Scenarios.Performed Data Integration Testing, System Integration Testing, Regression Testing and User Acceptance Testing. Used Quality Center to invoke the scripts and initially performed the baseline testing and organized all the scripts systematically and generated reports. Used Team Foundation server (TFS) for defect Tracking and Uploading Test cases in Test manager and Mapping to defects Performed Regression Testing for Various versions and rectified the defects. Executed SQL statements manually to validate data from Database.Performed Functional and Regression testing on Support.bell.ca and My Bell sitesUsed SOAP UI for testing of Web service functionality and data validationCreated Business User profiles and linked them to the accounts from AMSS using SOAP UI 3.6.1Created Consumer Personal accounts in Amdocs NM1 Customer service Management system Created test data (Consumer Personal) accounts in AMDOCS CSM systemWorked alongside with Business (client), Business analyst, Project Managers and developers to provide regular status updates following the project timelinesAttended walkthrough sessions of test plans and test cases with both the Business and the IT teams to know their thoughts on the testing scopeReviewed project documents and provided team leads and managers my input or raised concernsMaintained a library of test cases using Quality Centre 10.0, Executed test cases in SIT and UAT environments with business participantsWrote the Test cases to cover all the functionalities of the application in scope and executed test cases with the help of businessUsed Quality centre 10.0 for defect management, test case management and QTP 10.0 for execution of automated test scripts.Created automation test scripts using VB and executed automation test cases using QTP 10.0
Environment: TFS, Quality Center, Test Manager, ASP.Net HTML,XML.SOAP,Windows7, MS SQL, UNIX, Oracle11g, CSM, Web services,QTP10.0,Sharepoint
Client: Dundee Wealth Management, Toronto, ON Oct ’08– Aug’10
Line of Business: Wealth management
Role: Senior QA Analyst
Description: Existing mainframes financial planning application was migrated and into java based web version. The new web application supports asset allocation and goal based plan along with other various financial planning instruments like mutual funds, hedge funds including personal, non personal, registered and non registered funds and also wealth management team in planning financial services like RRSP, RESP and RRIF. The project also involves a data warehouse initiative wherein the data elements in source databases of multiple applications are loaded into data warehouse. A business intelligence tool OBIEE is used to generate various reports from the data warehouse.
Responsibilities:
Analyzed and reviewed the software requirements, functional specifications and design documents.Analyzed system requirements, created and executed detailed Test plan, developed Test cases, Test scripts.Prepared test cases for positive and negative test scenarios.Involved in mentoring a QA Team of five members, managing and scheduling resources and activities for successful completion of project. Extensively used VSS as Version Management and Change Management Tool. Involved in developing the Test Plan, Test Cases and Test Scenarios.Performed System Testing, Integration Testing, Regression Testing and User Acceptance Testing. Used Quality Center to invoke the scripts and initially performed the baseline testing and organized all the scripts systematically and generated reports. Performed Regression Testing for Various versions and rectified the defects. Performed Data Driven Testing and Parameterization using QTP. Involved in using Recovery Object Manager when ever certain objects are not recognized by the QTP.Performed Load Testing using Load Runner. Customized Load Scripts in Vu Gen.Involved in creating a Performance Strategy for the application.Customized and Enhanced the Scripts in QTP and Load Runner accordingly. Integrated QTP scripts in Quality Center to invoke these scripts automatically while testing. Performed Backend Testing using SQL Advantage.Extensively used ETL Tool (Informatica) to test the Extract, Transform and Load process from the DB to the Data warehouse.Worked with Micro strategy to test business intelligence reports.Managed requirements, test cases using Quality Center.Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL.Transferring data from DB2 Operational Data Store (ODS) to Test Data Store (TDS).Executed test cases manually. Compared and analyzed actual with expected results and reported all deviations to the appropriate individual(s) for resolution.Documented, and tracked test plans, test results, test analysis and reported the defects using Test Director.Identified, classified, reviewed and resolved defects in consultation with lead and other team members.Reviewed computer logs and reports to identify application processing errors and possible improvements.Executed UNIX shell scripts for various operations.Extensively used SQL Queries for interacting with the Oracle database.Executed SQL statements manually to validate data from Database.Conducted User Acceptance testing for the application.Helped in the improvement process of Quality Assurance.
Environment: QTP, Load Runner, Quality Center, Informatica, Visual Source Safe (VSS), Java/J2EE, PERL, HTML, SQL, UNIX, Oracle9i, DB2, Mainframes, OBIEE.
Client: Manulife Bank of Canada, Toronto, ON May’ 07 – Sep’ 08
Line of Business: Banking, Mutual Funds, Mortgage Solutions
Role: Lead QA Analyst
Description: Online Personal Banking application provides the solutions to automate branch (platform, teller and lending) and Internet banking with Mutual Funds Trading Solution and Total Mortgage Solution. The system performs banking transaction such as checking/savings accounts check facility, deposits & withdrawals, calculating interest of accounts and customer inquiries. The system also generates various reports for both the customers and banking personnel of Manulife Bank. The application is integrated to mutual funds and mortgage applications.
Responsibilities: Analyzed the requirements thoroughly with the business and testing teams.Involved in Scope Analysis of the requirements by reviewing Use Cases from RequisitePro.Worked closely with Business team in identifying the defects in the Use Cases.Determined whether the requirements are testable, identified the clarity and gap in the requirements.Performed well with strict deadlines in various subsystems sharing different requirements.In the process of analyzing the requirements and creating a test plan, conducted reviews with other subsystems, business and team.Worked with Rational Functional Tester for GUI, functional, integration and regression tests and worked with Rational Performance Tester for performance, load, stress and volume testing. Responsible for creating the high level scenarios using Rational Test Manager based on the Path Analysis.Generated Test Suite reports using Rational SODA.Conducted Test Suite Reviews with Stakeholders to get a sign-off on the high level scenarios.Prepared documentation and presentation for the reviews held with Business Stakeholders for ease of understanding the scenarios and test coverage.Worked closely with the team members in allocating the work based on the scope matrix.Responsible for reviewing detail test cases with proper verification points embedded with test steps.Conducted Internal and External Test Case reviews within the team, with Business & Developers.Created ‘Requirements Traceability Matrix’ and traced the requirements to test cases using Rational Test Manager.Implemented the test cases in the Rational Test Manager and configured the required Test Set properties.Generated Test Plan and Test Case Detail Reports using Rational Test Manager.Responsible in performing the Test Data preparation and Data Conversion for huge Products related enhancements.Prepared Expected results required for few of the Use cases.Executed the various phases of tests in various Environments like Smoke, Functional, End to End and Regression from code drop to Production Roll out.Facilitated the project through out the release.Found and logged many defects in Clear Quest with the respective severity.Analyzed, Reviewed and Tracked many defects.The Builds were validated and if successful the Defect was closed.Coordinated QA Activities between various subsystems, Team, Development and Business teams.Coordinated Change Management teams for data request and code drops in various regions for testing purposes.Complete Backend Testing was performed using UNIX Scripts and SQL queries to verify the Integrity of the database.Extensively developed SQL Queries using Rapid SQL to test business process of financial Modules in the application. Compared the results on the presentation layer to the results retrieved from the backend.Created Data Mapping and Data Flow graphs for the data transfers from various sources.Integrated the individual Test scripts to the whole project while facilitating the creation of Automation Framework.Supported the Regression test team in executing the process.Worked actively with Business team in User Acceptance testing for project releases.Involved completely and solely in the Production Support for the latest release.Interacted with the Business, Development and Configuration teams for resolving the issues.Responsible for supporting all the environments and other subsystem in subsequent releases.Maintained Version control and Version related data in the Clear case.
Environment: Rational Functional Tester, Rational Performance Tester, Rational Test Manager, Rational Clear Quest, Rational Clear Case, Rational RequisitePro, Oracle9i, PL /SQL.
Client: IA Clarington Investments, Toronto, ON June’ 06 - Apr’ 07
Line of Business: Investment Banking, Capital Markets, Securities, Portfolio Management
Role: Senior QA Analyst.
Description: Worked as a Senior QA Analyst for the QA Test activity on a Web application called Broker Portal, the application was used by Investment Advisors of IA Clarington investments to manage securities, lending and margin finance; Broker Portal application allows users to access sales, trades, investment products, cash management and online FX trading. FIX protocols are used for communication with stock exchanges for equity trading.
Responsibilities:Primary coordinator for all quality assurance activities for any project or enhancement that covers finance application and systems or platforms. Organized brain storming session with business and design team in the process of requirements and design documents assessment. Responsible for quality assurance test management, execution and oversight of Functional, System and Regression testing for conversion. Responsible for communicating other supporting groups to complete testing activity, this includes Change Management, Release Management, Test Automation, Test Environment setup, Accounting and Finance.Reviewed requirement assessment with Vendor, Business and customer’s teams to determine adequacy of Requirements and guarantee that they are testable and resolved any requirement insufficiency. Created Master Test Plan and facilitated Project members and got sign-off from team. Incorporated proposed updates and maintained through out the testing effort. Created Conceptual and detailed test cases based on detailed design docs, Functional Design docs and Business and System requirements. Responsible for reviewing the test cases with business and customers and make sure complete test coverage. Compiled all the test cases and loaded into Test director with proper naming convention and created test sets for execution of various scenarios.Executed Functional, Regression, Smoke and Backed test using WinRunner Automation test scripts.Created Quick Test Pro scripts to test web components in the finance applications.Created test data requirements and coordinated and communicated with data team to load required test data in the Test, QA, and UAT regions. Created test entrance and test exit criteria checklists and got sign-off from project and vender teams. Responsible for mentor and complete test processes documentation and test execution.Responsible for determining which Test Environment to utilize and communicate requirements and expectations to performers in Configuration and development teams.Created, maintained and updated WinRunner and QTP Regression suites for different types of application.Scheduled mainframes scripts runs in test and UAT regions to execute various scenarios of testing. Validated business process, functionality and out put reports for various scenarios of test runs.Verify and validated various daily and monthly interface files and reports coming out of Unisys RMS. Created a SQL statement to extract data, to call stored proc to perform set-based data processing. Tested the parallel runs and lookup functions, used joins to connect the input of one table to another immediately.Implemented the parameters over wrappers scripts to tune the performance.Performed backend process verification and validation on Mainframes application. Actively assisted Business team with planning, coordinate and execution, User Acceptance Testing (UAT). Responsible for coordinating any Automation updates/changes with test automation team.Responsible for participating in the review of change management, release contents and schedule. Responsible for attending Change Central Unit and Defect Assessment Unit meetings actively.Responsible for log, track and maintain all test defects, issues and change management in ClearQuest.
Environment: WinRunner, QTP, LoadRunner, Test Director, Clear Quest, XML, HTML, JavaScript, Windows XP, Win2K, Mainframes, DB2, Oracle9i, PL /SQL, Ab Initio and Unix.
Academics
Post graduate diploma in computer applicationBrain bench certified software tester.HP Mercury Interactive trained in QTP. Trained in Software Quality Assurance & Implementation of CMMI.