Prerana Lonkar
Austin
Summary
Highly skilled Staff QA Engineer with over 14 years of experience. Exceptional technical ability and deep understanding of software debugging and testing. Extensive knowledge and experience in Quality Analysis, coupled with familiarity with different phases of the SDLC. Delivers top-notch results. Highly responsive to client needs and adept at adapting to changing software requirements. Excellent communication, organizational, and time-management skills enhance ability to excel in this role.
Overview
15
15
years of professional experience
Work History
Staff software Quality Engineer
Service-Now
06.2022 - Current
- Engineered innovative QE tools using JavaScript on the ServiceNow platform, driving efficiency and process improvement
- Diagnosed and troubleshot performance and platform issues, logging defects for continuous improvement
- Experienced in configuring, querying, and maintaining MySQL, Oracle, and PostgreSQL databases for ServiceNow applications
- Delivered proactive and timely support for platform-related issues while engaging directly with customers in the Outside-In Program
Senior software QA Engineer
Mitchell International
01.2017 - 06.2022
- Worked on developing automation framework using selenium, TestNG, Maven and Jenkins
- Setup the remote selenium grid in order to speed up automation
- Used Eclipse IDE for integration of Selenium Web Driver, TestNG and Maven and created selenium automation scripts in Java
- Automated the application, database and tableau deployment process through Jenkins
- Automated SSRS reporting deployment using VB scripts
- Worked on manual testing of web-based applications and micro-services/web-services
- Deployment of JBoss and Spring Boot application
- Involved in manual testing of SSRS and tableau reports
- Validated report data against warehouse data using SQL
- Excellent knowledge of executing and testing SSIS packages/ETL job and validating data between OLTP vs data warehouse
- Worked as full stack QA
- Helped find the root cause of the issue
- Worked on extracting data from OLTP to JSON file, uploading the files to S3 bucket using Jenkins’s job and loading JSON files into Snowflake ODS
- ODS Vs OLTP data comparison using SQL scripts
- Worked on testing of snowflake EDW and tableau reports connecting to EDW
- Used version control tools like git and TFS
- Consistently recognized for excellent problem-solving and analytical skills by Programmers, project managers and supervisors
Consultant/Test Lead
Infosys
12.2015 - 01.2017
- Developed Agile Automation Test Strategy, estimated the testing to be done and negotiated with management to acquire the necessary resources, followed end to end Scrum process i.e
- Agile Scrum Framework and delivered in sprints
- Used Eclipse IDE for integration of Selenium Web Driver, JUnit, Eclipse and created selenium automation scripts in Java
- Used web-debugging tools like Firebug, Firepath and Fiddler
- Used ANT as the build tool, GIT for version control, Jenkins for Continuous Integration
- Back end Database Testing with MS SQL by SQL queries
- Coordinate with Business Analyst to decide the business process and Specifications
- Analyze business requirements, Software requirement specifications to create test plan and test cases for manual and automation testing using Selenium Web Driver
- Test case creation, Execution, Defect Tracking & reporting through HP Quality Center/ALM
- Creating and Assign the defects to development team and verify the defects in JIRA
- Interact with development team and the system administrators to Resolve Performance Issues
- Generate reports, analyze and interpret the results with Business Analysts and System Architect
- Task Allocation and monitoring the progress of sprint backlog and review the test results
QA Analyst
Tata Consultancy Services
11.2014 - 12.2015
- Interacted with BAs and developers for requirement analysis, design discussion and defect discussion
- Worked as onsite coordinator, assigned testing responsibilities to offshore team, assisting team with requirement understanding, followed up test completion and reported status to client
- Built good trust and relation with client by communicating testing progress and issues on time, meeting product SLAs
- Always volunteered testing support in case of major PROD release
- Created/updated the QTP VB scripts for regression and executed it as a part of regression for each release
- Involved in web services testing using SOAPUI web services testing tool
- Validated integration of SNOW application with salesforce, Netcool
- Executed Test cases, defect logging & tracking through ALM
- Maintained common tracker in order to track status of requirements and defects for a release
- Involved in Functional & Regression Testing and PROD release sanity tests
- Sent daily status report to stakeholders and Prepared QM sign-off for PROD release
QA Analyst
Tata Consultancy Services
02.2010 - 11.2014
- Understood Requirement in coordination with client/Developers/BAs, Prepared Test Plan, designed and Prioritized Test scripts
- Participated in team meetings to discuss requirement issues, testing progress and defects
- Created QTP scripts to automate desktop-based applications using created Keyword Driven framework and its integration with HP QC
- Used Apache POI to perform different Excel read/write operations using selenium web driver
- Executed Test cases and tracked defects through QC/ALM
- Ran autosys jobs to load data and wrote SQL queries in DB2 for Data Validation, using Unix commands to handle flat files saved at server location
- Involved in Functional & Regression Testing of web based and .net based front-end applications
- Built the test environment - database setup and jils creation, set up Apache-Tomcat servers
- Worked on ETL processing - receive positional data, apply correct transformation and load all the market data in normalized table
- Verified exposure, Capital and Var data using production benchmark
- Worked on loading Data warehouse data and verifying data load using pivot cube functionality
- Trained for Big data technology – Apache Hadoop, HDFS, MapReduce
Education
Bachelor of Science - Information Technology
Walchand College of Engineering, Sangli
Maharashtra, India06-2009
Skills
- Quality assurance
- Automation testing
- Database management
- Selenium framework
- Strategic planning
Timeline
Staff software Quality Engineer
Service-Now
06.2022 - Current
Senior software QA Engineer
Mitchell International
01.2017 - 06.2022
Consultant/Test Lead
Infosys
12.2015 - 01.2017
QA Analyst
Tata Consultancy Services
11.2014 - 12.2015
QA Analyst
Tata Consultancy Services
02.2010 - 11.2014
Bachelor of Science - Information Technology
Walchand College of Engineering, Sangli
Similar Profiles
MARIA "HEIDI" SIPINMARIA "HEIDI" SIPIN
Dental Residency Director, AEGD at U.S. Public Health Service/Indian Health ServiceDental Residency Director, AEGD at U.S. Public Health Service/Indian Health Service
Vidianand LutchmeparsadVidianand Lutchmeparsad
Chairperson at Public Service Commission & Disciplined Forces Service CommissionChairperson at Public Service Commission & Disciplined Forces Service Commission
SAMUEL OSEI BONSUSAMUEL OSEI BONSU
Statistician at Local Government Service/Ghana Statistical ServiceStatistician at Local Government Service/Ghana Statistical Service