Data Test
Resume:
Lalithanjani Kancherla
(E)************.*@*****.*** (P)860-***-****
Summary
Software Quality Assurance Engineer with 8 years of experience in Software Testing of Web based and Client-Server applications. Expertise in writing and executing Test plans and Test cases in highly structured and loosely structured development environments and performing all types of testing (functional, regression, acceptance, and browser compatibility). A strong analytical and problem solving, interpersonal and communication skills, self-starter, quick learner and able to adopt new technologies as needed in rapidly changing IT environment.
Key areas of specialization:
Highly proficient in interacting with business users and gathering user requirements to develop necessary Test Plans, Test Cases and Test Scripts.
Extensive knowledge of Software Development Life Cycle such as Waterfall and Agile.
Expertise in conducting User Acceptance Testing (UAT).
Worked with ETL group for understanding Data Stage graphs for dimensions and facts.
Strong experience with ETL systems and having expertise with tools Informatica and Data stage.
Experience in Dimensional Data Modeling using Star and Snowflake Schema.
Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
Experience in maintaining Full and Incremental loads through ETL tools on different environments.
Experience in executing the ETL Jobs using CA ESP.
Good experience in writing SQL in order to validate data in migration as part of backend testing.
Good exposure with databases like Oracle, DB2, SQL Server.
Good expertise in using TOAD, SQL*Plus and Query Analyzer.
Worked with different data sources ranging from flat files, and DB2, oracle and SQL Server databases.
Performed Back End Testing manually and using automated testing tool by executing SQL queries.
Experienced in creating Test Matrix, Requirements Traceability Matrix and performing Gap Analysis.
Performed Functionality Testing and Regression testing using Selenium.
Familiar with executing the test automation jobs using Jenkins.
Experienced in testing Commercial Websites and business applications.
Participated in Daily check point meeting to understand requirements, status updates, and defect analysis discussions
Excellent communication skills for working independently and as a team member to deliver the goals of an organization in efficient manner.
Tools
Informatica Power Center 8.x
PLM software Teamcenter8 Rich-client with .net-based middle-tier facilitating over the web deployment through WebLogic server.
PLM software Teamcenter8 2-Tier Architecture
QA Reporting tool (QART) – a CGI-Perl based tool to track test case execution
WebTac – a bug tracking tool.
Jenkins – Automation job execution, CA ESP – ETL Job execution.
Professional Experience
CLAIMS REPORTING MANAGEMENT SYSTEM (CRMS)
CIGNA Healthcare
Apr 2018 – Till Date
Bloomfield, Connecticut
QA Lead Engineer
Claims Reporting Management System (CRMS) is a reporting data mart. It integrates eligibility, claims and expenses information received from various upstream systems. Several reports are generated from CRMS which business users use for analyzing the claims performance.
Responsibilities:
Preparation of Test Plan/Knowledge Acquisition documents for the related features.
Preparation of Test strategy document for the releases and conducting review meetings to fulfill sign off for the test plan.
Effective Test Cases designing in QC/Test Director using Test Plan, functional requirements specification, business requirement document and Knowledge acquisition document.
Execute ETL jobs in system and integration regions via CA ESP (Enterprise Systems Platform).
Responsible for reviewing Test Artifacts and Knowledge Acquisition documents.
Involved in creation of process documents, reporting specifications and templates.
Creation of Test Sets and executing Test Cases, Data Count, Data validation, Meta Data Checking, Keys checking, Naming Convention of tables and Initial, Incremental, Historical Load Testing.
Reporting defects in the Bug Tracking System through QC.
Captured Quality Metrics and Assessed the impact of various Risks identified and implemented Risk Management measures to mitigate these risks.
Preparation & execution of tests for System Integration testing.
Participate in periodic meetings with key stakeholders to provide progress report.
Identifying and analyzing the defects during Regression testing.
Provide support to UAT and Business teams during and after production.
Involved in Production checkouts during implementations.
ASML TC/NX Upgrade
Aug 2015 – June 2016
ASML, Eindhoven, Netherlands, Europe
QA Lead Analyst
ASML is currently using Teamcenter Engineering 9.1.3/NX3 as the platform for managing their Engineering Business Processes and product development activities across the sites Veldhof & co-developers in Netherlands, Wilton in USA and ACE in Taiwan. The business user community has challenges with the current Teamcenter/NX platform from functionality, scalability, performance and application support aspects. ASML has decided to upgrade their current Teamcenter/NX stack.
The overall scope of the project is to upgrade Teamcenter Engineering 9.1.3 to TC 8.3.2 and NX 3 to NX 7.5.4.
Responsibilities:
Testing of Upgraded Teamcenter 8.3.2 and NX 7.5.4.
Testing of Customizations of Teamcenter 8.3.2 and NX 7.5.4.
Analyzed business requirements and system specifications,
Formulated Test plan for the entire testing effort.
Prepared test data for positive and negative test scenarios as documented in the test plan.
Create Test Plan and test cases.
Verifying the ETL data in target database and source database.
Prepared and ran SQL queries to verify DIMENSIONAL and FACT tables to have correct computed values.
Management of the defects that arise out of the upgrade testing.
Performed backend testing using SQL. Performed data integrity and data validations.
Plan and organize User Acceptance Testing for real time business users
Coordinate with Offshore team regarding the testing activities.
B/E Aerospace
Aug 2014 – Aug 2015
B/E Aerospace Inc., Hyderabad, India
Test Lead
The Process Standardization Initiative (PSI) has been undertaken to improve business performance, increase process assurance and simplify future integrations. During Phase 1 evaluation significant business opportunities were identified by the PSI-PLM team to reduce labor and material costs through streamlining item and BOM threads from engineering through manufacturing and into product support.
Responsibilities:
Reviewed Business Requirements, Functional Specifications with Business Analyst and QA team to learn the functionality and business process.
Test Planning, Test design specifications depicting test coverage, Feature Stability test cases and Comprehensive feature verification test cases.
Performed Functional and Regression testing.
Performed GAP Analysis to make sure that all requirements were covered by test cases.
Used SQL Statements to extract Data from Tables to verify the output Data of the reports.
Performing GUI, Regression, Functional, UAT, Static, Backend and Database Verification testing using SQL queries
Test data preparation and Test execution.
Reporting defects in Issue Logger.
Presenting Weekly Status
TC Services for Meijer Off.
Feb 2014 – Aug 2014
Meijer, Hyderabad, India
Team Lead
This project is intended to customize the Tc SHF (Softlines, Hardlines and Footwear) to cater the requirements of Meijer.
The purpose of this PLM solution for the retail industry is to help the customers in the retail industry reduce the time for new product introduction, improve their supplier management capabilities and increase their profit margins.
Responsibilities:
Creating Schedule Templates, Workflow templates, Classification hierarchy, custom Queries, custom organization, bulk load utilities based on client real time scenarios.
Managing the Team activities
Preparing Quality Documents related to the Project.
Presenting Audits of the Project related to Business Health, Relationship Health, Process Health and Product Health.
Attending Status calls and Meetings with Onsite.
Installing Teamcenter Unified 2-tier and 4-tier set up.
SRS (Software Requirements Specifications) Review, FS (Functional Specifications) review, SDD (Software Design document) review
Test Planning, Test design specifications depicting test coverage, Feature Stability test cases and Comprehensive feature verification test cases.
Siemens Tc SHF, Quality Assurance
Feb 2013 – Jan 2014
SIEMENS (UGS), Hyderabad, India
Test Lead
This project is intended to address the requirements for creating a solution for the Softline, Hardline and Footwear (Tc SHF) segment of the retail industry.
The purpose of this PLM solution for the retail industry is to help the customers in the retail industry reduce the time for new product introduction, improve their supplier management capabilities and increase their profit margins.
Responsibilities:
SRS (Software Requirements Specifications) Review, FS (Functional Specifications) review, SDD (Software Design document) review
Test Planning, Test design specifications depicting test coverage, Feature Stability test cases and Comprehensive feature verification test cases.
Test environment setup, test data preparation and test execution.
Reporting defects PRs using the Bug tracking tool (WebTAC)
Test Status Reporting (Weekly)
Resource estimation for testing and QA planning.
oConducting Knowledge Sharing sessions and imparting training to new entrants
oTest Environment setup - Installation of Tc SHF product (both 2-Tier, 4-Tier) on different servers.
oUpgrading the environment for the next build and performing testing.
oPre-Sales Demos and Meetings.
Siemens Microsoft, Quality Assurance
Mar 2012 – Jan 2013
Siemens, Hyderabad, India
Team Member
The MSFT program is an initiative to integrate Teamcenter PLM software with Microsoft components and features to envisage user-friendly business operations management and data exchange between different collaborative partners in the manufacturing sector. As part of this of this around 8-9 projects are included with feature simplification requirements, functionality enhancement requirements and application interoperability. The Origin of the requirement is from MS E&D. Excel Import Project is a part of this Initiative. Excel Import Feature Enables Teamcenter to import (create/update/delete) a BOM structure from Contract Design Manufacturer (CDM) Excel file and also supports for Teamcenter to import (create/update/delete) Vendor data & Reference designators related data when a BOM is imported from a Contract Design Manufacturer (CDM) Excel file.
Responsibilities:
Involved in setting up the End-to-End testing with Optimal Trace to Review Requirements Documents and the Technical specifications in early stages of SDLC and designed baselines for testing activity to finalize the test plans and test cases
SRS (Software Requirements Specifications) Review, FS review, SDD (Software Design document) review
Test Planning, Test design specifications depicting test coverage, Feature Stability test cases and Comprehensive feature verification test cases.
Test environment setup, data preparation and test execution.
Reporting defects PRs using the Bug tracking tool (WebTAC).
Test Status Reporting (Weekly).
Data Migration to eMatrixEPIC (Enterprise Product Information Collaboration) Production Support for eMatrix
Dec 2010 – Jan 2012
Johnson Controls, Chennai, India
Team Member
ICE (Item Creation & Enrichment) Data Migration
To Load given Excel Spreadsheet Data into EPIC. To Troubleshoot and analyze if the loaded Data has any discrepancies.
To update attributes of existing Records as per requirement.
Develop TCL (Tool Command Language) Scripts to detect Bad Data and correct them.
To support the application, solve defects found by the business users, help business users utilize the application optimally.
Responsibilities:
Solving Production support tickets to meet SLA.
Developing TCL Scripts and Testing.
Converting and loading excel data into ICE (Item Creation & Enrichment) system.
Troubleshooting and Analysis of TCL Scripts.
Education
Bachelor of Technology (Mechanical Engineering), Jawaharlal Nehru Technological University, India
Accomplishments
Strategy and Planning
Conducted User Acceptance Testing for 40 users at the Client location Netherlands and achieved a successful sign-off.
Designed and executed an extensive User Acceptance test plan and streamlined the defect tracking procedures.
Leadership
Served as Test Lead for several projects with a team size of 2-10
Co-ordinated the offshore team as onsite coordinator.
Contact this candidate