Lakshmi rani | RemoteHub

Experience

Department of Buildings ,Newyork

Jul 2018 – Present

Newyork

QA Lead

DOB NOW is the Department’s self-service online tool that will enable Owners, Design Professionals, Licensees, and Filing Representatives to do all business with the Department online. It allows customers to submit applications, make payments, schedule appointments, check the status of an application or inspection, pull permits, and make renewals.DOB NOW has four parts: DOB NOW: Inspections, Build, Safety, Licensing. Responsibilities: • Prepared Test plans and test strategies. Created test scripts with the help of Test coverage documents. • Understanding business requirement documents and FRD documents to identify the expected behavior of the system. • Involved in creating test scripts for PL/SP/SD work Types and for CRANES Project. • Creating and tracking defects through Team Foundation Server (TFS). Prepared Status reports to keep the track of Team progress. • Working as a POC with all stakeholders to insure the smoothness of the flow of information. • Executing test scripts manually and reporting defects. Performed Integration Testing. • Working with developers and keeping track about new builds and releases. • Leading the End to End testing. Working closely with Business Analysts to plan test strategies. • Working in small sprints in a fast paced agile system, Performed Data Migration Testing. • Exposure to daily scrum meetings and agile process. • Maintaining the requirements traceability matrix and reviewing frequently to ensure that test cases appropriately translated and mapped to requirements. Build: Plumbing/standpipe/Sprinklers: went Live Cranes—working on this project Appointments Project-went Live

JPMC

Jun 2017 – Mar 2018

Wilmington,DE

ETL QA

The AUTO BCBS sustainability Compliance is an enhancement in the existing application with in Auto Finance. This new data model has more Flexible framework along with a sustainable information platform that enables to Auto risk business users to leverage standardized and certified business information. Additionally the users will have the ability to perform their business more effectively. Responsibilities • Validated the Auto Finance Data Ware House data for Risk Execution. • Involved in validating and reviewing the data model (Logical &Physical). • Reviewed source to Target data mappings and validated against Target data. • Validate Database/Table Structure and mapping(s) based on business Requirements/DEM documents. Developed Test Cases and executed in JIRA. • Performed detailed data Analysis at attribute level and also at table Level • Using custom Queries. • Participated in Sprint Reviews and Scrum stand up meetings. • Preformed Data profiling to analyze Data Inconsistencies. • Reviewed and Validated IT QA Documentation. Environment: Jira, Teradata, Data Migration, BCBS Compliance Documentation,SQL Server.

Ferring Pharmaceuticals

Apr 2017 – May 2017

parsippany,NJ

ETL Tester

The project involved design and development of Enterprise-wise sales and marking data mart. The scope of that project was to maintain present and historical data of the client and create intelligent data to support client's business process, to enable Higher Management to take intelligent & better decisions. • Worked with Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer Informatica Repository Manager and Informatica Workflow Manager. • Developed data Mappings between source systems and warehouse components using Mapping Designer. • Exported Manual Test Cases from MS Excel template directly to ALM11 and executed the Test Cases with Pass/Fail/Blocked status. • Experience in ETL Data Warehousing, database testing using Informatica for job process. Environment: Informatica PowerCenter9.6.1. (Repository Manager, Designer, Workflow Monitor), SQL Server 2014,ALM.

JPMC.WILMINGTON

Mar 2015 – Oct 2015

WILMINGTON,DE

UAT Lead/Business Analyst

JPMorgan Chase & Co is an American multinational banking and financial services holding company. It is the largest bank in the United States, with total assets of US$ 2.6 trillion. • Lead and worked with team members with their day to day activities from a business perspective. Responsible for estimating, planning and leading the testing effort for the project. • Responsible for test design, Test execution and Defect management. Coordinate with the Onsite Test lead for the tasks and update the project status. • Performed the detailed analysis of the requirements for designing of the UAT test cases and any ambiguities in the requirements/documents were resolved with the BA and SMEs. • Reviewing the requirements and Screens, Artifacts and Use cases. • Performed gap analysis between the screens, use cases and requirements. • Prepared and modified Use cases as per the requirements. • Prepared Test scenarios for the requirements for UAT. • Reviewed functional specifications documents, design comps in order to find the gaps between the functional specifications to screens. • Created data characteristics for the screens. • Performed Reconciliations process. • Participated in status update meetings and prepared Status reports. • Actively participant of Agile training. • Created Wire frames using MS Visio. • Participated in cross-functional team meetings. Interacted with Business stakeholders. • Created Scenarios for E2E testing. • Tested IVR Systems as per the requirements. Environment: Excel, Power Point, Microsoft Share Point, Visio, ALM 11.,Oracle 9g

Salliemae

Aug 2014 – Feb 2015

Newark,Delaware

Lead tester

Salliemae, Newark QA Analyst (UAT/Lead Tester) Aug’14-Feb'2015 SLM Corporation is publicly traded US Corporation, whose operations are originating, Servicing and collecting on Student Loans. • Lead the team with the UAT Process. • Manage user acceptance testing tasks by communicating across the development Team Finance QA Team, and Business/Reporting Team, organize meetings and support training efforts to ensure effectiveness of UAT initiatives. • Understanding the client requirements and product functionalities. • Prepared test data for developing the test scenarios and test cases. • Executed test cases to verify actual results against expected results. • Performed Functional testing, Integration testing, System testing and Regression testing. • Performed E2E testing. • Provides UAT support during Formal user acceptance testing. • Prepared test cases and executed, and logged defects using Application Lifecycle management11. • Involved in status meetings to notify the status and performance of the application. • Looked the source data in FDR/CLASS to pull borrower and cosigner Account information. • Performed Front-end and Backend Mainframe testing. • Conducted both Front-end and Backend on VDI and Citrix testing. • Prepared test summary reports for all the test folders. • Prepared test cases and executed and logged defects using Team Foundation Server 2012. Environment: Informatica, Aginity/Toad/SAS, OracleB1, Excel, ALM11, TFS2012, Main frame

Softsmith Infotech

May 2012 – Jun 2014

Newjersey

QA Analyst

The project was to develop an E-Commerce Web-based application that can be accessed by customers for different offerings. Test Strategy was developed for internal and external portal, online enrollment, workflow, file mgmt., image mgmt and web page layout as well as security. Also worked on claims policy holder benefits information submittal. It was integrated with a claim processing system to get the claims approved after closely inspecting and verifying the claims. By using this online application User and broker’s can edit his/her profile, register on the portal to create and retrieve car insurance quotations, create quotation for cars, pull saved quotation for cars Quotation. Responsibilities: • Involved and reviewed the Requirements and design documents and understood the system implementation, including process flows and screen layouts. • Involved in Preparing test plan, test Cases, test Scripts, and test Steps for all the modules and stored in quality Center. • Provided testing the GUI consistency against different browsers (running on windows) against various screen resolutions. • Performed backend testing using SQL to validate the outputs. • Provides UAT support during Formal user acceptance testing • Tracked software bugs using Quality Center and communicated the same to developers to resolve technical issues. • Involved in weekly status meetings to notify the status and performance of the application. Environment: QTP , Quality center , ASP.NET, SQL Server, UNIX,HTML, MS Windows NT/2000, MS Office Suite,SQL server.

Softsmith Infotech

Jul 2010 – Mar 2012

Qa Analyst

CRM Module helps in tracking the business needs end to end. Tracking of opportunities, generation of leads and creation of new accounts is done through this module. Facility to manage campaigns and giving Quotes to clients is possible. Maintenance of contracts and its extension’s are also done here. Responsibilities: • Understanding the client requirements and product functionalities. • Involved in parsing the requirements into scenarios. • Designed the test cases from the requirement documents to satisfy all the functions of the application. • Prepared test data for developing the test scenarios and test cases. • Involved in peer reviews to review the test cases. • Attended the Walkthroughs with the Technical Analysts and Developers. • Followed CRUD method to prepare the test scenarios. • Executed test cases to verify actual results against expected results. • Tested the application repeatedly in search of bugs. • Used QA Monitor for Defect tracking and produced detailed Defect Reports, Pass-Fail reports and Comparison Charts for QA Status meetings. • Involved in complete testing life cycle of the project. • Checked the navigation and the links of the entire application. • Performed browser compatibility testing using different browsers like IE, Fire Fox etc. • Interacted with developers regarding priority of bugs and update the status of bugs once they are fixed. • Performed Smoke testing, Functional testing, Integration testing, System testing and Regression testing. Environment: HTML, JS, CSS, JSP, Tomcat 6.0, My SQL 5.0, QA Monitor

Bestbuy

Jun 2009 – Mar 2010

QA Analyst

POS Reserve vendor inventory project is to enhance customer satisfaction, improve electronic items delivery execution, decrease on-hand stock inventories. This project directly calculates inventory from warehouse, store and to communicate with top electronic vendors to deliver items on time. During POS, if insurance is added to goods, that detailed file transmits to insurance vendors at the end of the day. Roles & Responsibilities: Analyzed product and insurance vendors’ requirements, delivery date and item allocation logic, and Point of Sale (POS) functional requirements and design documents. • Created test cases and prepared test data. Reviewed test cases with business analysts. • Actively involved in manual validation of multi batch reports for supplier performance application. • Involved in backend testing by using SQL queries for data validation. Environment: Quality center, Oracle, Toad, MS Office and Windows 2000, XML, Java Script, JSP.

PNC

Feb 2008 – Apr 2009

QA Analyst

Responsibilities: Assist entry-level tester(s) on reviewing requirement, preparing and executing test cases, and report software defects. • Performed Regression testing to verify various sections of the system to ensure that changes or fixes in the system not only work, but also do not adversely affect the remainder of the system. • Created and executed SQL queries to validate the data, and used data manipulation language (DML) to update the data in the database and verify with front end that application handles the changes correctly. • Involved in developing test cases and test scripts for the regression testing. • Involved in UAT testing. Interfaced with developers to resolve technical issues. • Documented the bugs found out during the process of testing and logged them in Quality center. Environment: Quality Center, SQL, Java, JavaScript, Oracle8i, and UNIX, Windows XP, NT4.0.

Education

Andhra University

Apr 1987 – Jun 1990

bachelor of Arts, Economics,History,Public Admin