Navdeep Mangat
Modesto,CA
Summary
Seasoned Senior Software Analyst with background in designing, testing, and maintaining complex software systems. Strengths include strong analytical skills, comprehensive understanding of various programming languages, and ability to troubleshoot technical issues effectively. Proven record of enhancing system efficiency and performance from previous positions.
Overview
16
16
years of professional experience
Work History
SENIOR SOFTWARE ANALYST
CITY OF MODESTO
Modesto, California
01.2025 - Current
- Evaluated business processes for city operations, identifying software needs and streamlining workflows for City of Modesto.
- Developed stored procedures, triggers, functions, views, indexes, and other database objects for the application.
- Monitored system performance, identifying and addressing potential issues or risks to ensure data integrity.
- Monitored system performance and data access controls. system performance, security access, and data integrity controls.
- Tested software updates and checked data accuracy in city systems.
- Prepared system procedures, user guides, and technical specifications.
- Tested, maintained and monitored computer programs and systems.
- Documented reports on system analysis findings and actionable recommendations for stakeholders.
SOFTWARE ANALYST
CITY OF MODESTO
Modesto, CA
08.2022 - 01.2025
- Generated immediate reports using complex SQL queries for departments including Engineering, Water, and Finance to support data-driven decision-making.
- Automated workflows and approval flows using Power Automate.
- Created and maintained reports in DB2 web query.
- Automated billing processes for Finance team, maintaining scripts in a go-anywhere tool to enhance accuracy and efficiency.
- Created technical and non-technical documentation for procedures and workflows.
- Automated public facing forms using civic plus and secure forms.
- Learned and using IBM i emulators to fix issues with server jobs.
- Applied updates daily (PTFs) to the IBM server.
- Conducted testing in a test environment prior to production updates for tools like NaviLine, RASWIN, and HDL to ensure system reliability.
QA ENGINEER
VEEVA SYSTEMS
Pleasanton, CA
08.2021 - 08.2022
- Writing Automation scripts using the cucumber framework in java.
- API testing using Postman.
- Performed Functional, Integration, regression, positive, negative and smoke testing.
- Performing Backend testing using SQL queries.
- Triaged and claimed AFT defects to ensure timely resolution and maintain software quality.
- Developed test plans for features to guide testing processes and ensure comprehensive coverage.
- Coordinated and communicated with offshore teams to streamline project workflows and enhance collaboration.
- Experience working with AWS instances.
SENIOR QA ENGINEER
AMERICAN MEDICAL RESPONSE
Modesto, CA
05.2017 - 08.2021
- Experience in testing and automating applications related to the Healthcare field (American Medical Response).
- Experience in testing clinical data.
- Performed Functional, Integration, regression, positive, negative and smoke testing.
- Performed security testing using the Fiddler tool.
- Performed mobile testing on physical devices and an emulator. Experience in maintaining and running mobile automation scripts.
- Executed smoke testing for UAT builds to verify functionality of test channels and test environment.
- Wrote and executed the test cases.
- Analyzed the Business Requirements Document and system specifications and identified the test requirements.
- Performing Regression test using automated testing tool Selenium.
- Automating End to End Testing using automation Tools.
- Helped in creating the automation framework SpecFlow for all applications.
- Creating automation scripts in c#.net
- Led team to achieve project goals, fostering collaboration and improving project outcomes.
- Conducted demos for end users and UAT team, facilitating feedback and ensuring alignment with requirements.
- Reported software defects in TFS and Jira, collaborating with developers to resolve technical issues and supporting debugging efforts.
- Experienced in working with Microsoft Test Manager (MTM) where test plans are stored and results are on Team Foundation Server (TFS).
QA ENGINEER
PADRONE TCHNOLOGIES PVT. LTD.
Chandigarh, India
03.2011 - 02.2015
- Developed automation framework for all applications, enhancing testing efficiency and consistency.
- Automating End to End Testing using automation Tools.
- Executed regression tests using the automated testing tool Selenium.
- Wrote and executed the test cases manually and automated.
- Analyzed the Business Requirements Document and system specifications and identified the test requirements.
- Performed Backend testing using SQL Plus, PL/SQL.
- Conducted stress and load testing to evaluate system performance under high traffic conditions.
- Creating Test Requirements Specification documents, Test plan and Test Result documentation.
- Contributed to SDLC and Agile processes, supporting business process design and implementation.
- Monitored test progress throughout project release cycle, delivering test results and detailed status reports to stakeholders.
QA ENGINEER
SASSYPUMA TECHNOLOGIES
Chandigarh, India
08.2010 - 02.2011
- Analyzed business and requirement specifications, designed test lab, and formulated test strategy and test plans, performing functional testing to identify critical points in the application and automated processes using Selenium webdriver.
- Worked on cucumber to write acceptance tests for a web application.
- Developed test frameworks in Selenium for UI regression test automation.
- Configured Selenium webdriver and developed Selenium automation scripts in Java using Junit for automated testing prior to agile release.
- Performed white box testing using testing for class, method, & web services testing.
- Executing the test plans on web and mobile (Apple & Android) as per requirements.
- Experienced in working with Microsoft Test Manager (MTM) where test plans are stored and results are on Team Foundation Server (TFS).
- Tested compatibility of the application for dynamic and static content under various cross browsers using HTML ids and XPATH in Selenium.
- Executed regression testing for new builds and modifications in the application using Selenium, ensuring application stability and performance.
- Used Selenium webdriver to run test cases in multiple browsers and Platforms.
- Tools and technologies used: Selenium webdriver, testing, Quality Center, Microsoft Test Manager (MTM), Firepath, Firebug, Eclipse, XPATH, Java, HTML, Android, SQL, and Oracle.
Education
Master's - Software engineering
North Dakota State University
Fargo, North Dakota12-2021
Bachelor's Degree - Computer Science
Punjab Technical University
India01-2010
Skills
- API testing
- Security Testing
- Workflow Automation
- Agile Project Management
- Frameworks: TestNG, Specflow, Cucumber framework
- Programming Languages: C, C, Java
- Scripting Languages: JavaScript
- Databases: SQL server, MySQL, DB2 WebQuery
- Web Debugging
- Technical Documentation
- Methodologies: Agile, Waterfall
Additional Info
Languages known: Fluent in writing, reading and speaking English, Hindi and Punjabi.
Timeline
SENIOR SOFTWARE ANALYST
CITY OF MODESTO
01.2025 - Current
SOFTWARE ANALYST
CITY OF MODESTO
08.2022 - 01.2025
QA ENGINEER
VEEVA SYSTEMS
08.2021 - 08.2022
SENIOR QA ENGINEER
AMERICAN MEDICAL RESPONSE
05.2017 - 08.2021
QA ENGINEER
PADRONE TCHNOLOGIES PVT. LTD.
03.2011 - 02.2015
QA ENGINEER
SASSYPUMA TECHNOLOGIES
08.2010 - 02.2011
Master's - Software engineering
North Dakota State University
Bachelor's Degree - Computer Science
Punjab Technical University