Pushpinder Singh Email and Phone Number

• Participates and provides input into the design, redesign, and development of technology products and applications• Contributes and often leads the specification and software design phases of the software development life-cycle.• Leads and manages the design and implementation of new software development and enhancement efforts, and coordinates systems installation and software testing with other technologists.• Assists users with the isolation and resolution of software issues by leading root-cause analysis providing options for resolution and recommendations.• Serving as SME around telematics capabilities.• Work with telematics vendor Geotab and Navman to set standards around how we evaluate telematics data quality.• Lead change management processes with telematics vendor and internal stakeholders to manage tech upgrades.• Develop mechanisms to track telematics data quality and integrity.• Develop and manage on-ground testing processes to audit data quality and reporting accuracy.• Work with the offshore team and guide them for the remediation process.• Manage request intake process from stakeholders on data validation. • Partners with the business to establish long-term strategic business and systems objectives.• Addresses day-to-day production support fixes.• Works with team members (technical and basis) and subject matter experts (end users) to produce requirements and design documents. Documents all specifications and requirements for implementation and develop Business Process Procedures (BPPs).• Provides support for functional testing to ensure that business requirements are being met while following technical standards.• Acts as project manager for the complete life-cycle of projects as well as for minor enhancements.• Reviews current functionality and processes and recommends process and system improvement, • Participates in support packages, enhancements, and system upgrades as needed.

• Analyze user requirements to design and develop sound and effective solutions for Ryde smart Application.• Worked on SQL server Migration from 2008 to 2016.• Worked on SSIS package migration from 2008 to 2016.• Worked on Windows application server migration from 2008 to 2019.• Root cause analysis using Lean Six sigma tools.• Designed and developed views, stored procedures, triggers, and functions using T-SQL.• Performance tuning of SQL store procedures.• Design and develop SSIS packages to import data and send reports to businesses.• Supporting Business user with their day-to-day activity.• Subject-matter expert in the capturing and analysis of Unified Estimator enhancements.• Responsible for Support of Rydesmart Application.• Subject Matter Expert for different applicatins CPM, Estimator, SMO.• Subject Matter Expert for Geotab Application and Database.• Work with Biztalk and DBA team to make sure integration is working fine.• Responsible for the management and maintenance of ASP.NET web applications hosted on the company's intranet site using Visual studio.• Participated in business and production support activities including troubleshooting software issues, diagnosing root causes of performance degradation, monitoring system logs, and analyzing intricate business processes.• Worked in conjunction with database administrators in database performance tuning and optimization activities.• Integration and Unit testing using POSTMAN.

• Oversee all activities of the QA testing teams within the organization. • Lead a large group of QA professionals embedded within different project teams in multiple geographic locations onshore and offshore.• Lead the work of a large software testing team, provide support regarding day-to-day issues, and liaison with business customers with a complete, end-to-end understanding of the technologies and business functions.• Mentor and grow a team of quality assurance professionals by providing insights on workflows and best practices to ensure their development.• Utilize data to provide insights and recommended action plans to improve the QA program by setting quarterly strategy and goals.• Work on strategic projects to help launch and integrate quality for new products, policies, and support sites.• Act to resolve issues that prevent the team from working effectively.• Coach others, recognize their strengths and encourage them to take ownership of their personal development.• Lead internal defect triage calls, ensuring successful resolution of found defects• Help user determine UAT approach and strategy• Proactively uncover project risks, apply appropriate mitigation approaches, and escalate to management when needed• Track the progress of test assignments, validate full test coverage of requirements, evaluate the defects volume/trends, and spot-check test results.• Provide leadership and vision for automated testing, including the development of a roadmap to regression test automation, and the implementation of tools and processes in support of test automation.• Research test tools, methodologies, trends, and update existing practices and processes.• Communicates quality standards and parameters to the QA team, product development team, and product management team.• Works with technology leaders and PMO to develop project schedules and resource allocations.

• Analyze user requirements to design and develop sound and effective solutions.• Designed and developed views, stored procedures, triggers, and functions using T-SQL.• Design script for integration testing of mobile Maintenance Application.• Designed and implemented functional tests for SOAP and REST APIs through the use of SOAP UI.• Technologies used to support applications include Microsoft SQL Server and Microsoft .NET• Subject-matter expert in the capturing and analysis of Unified Estimator enhancements.• Responsible for Support and enhancement of Unified estimator.• Subject Matter Expert for Central part Master Application and Database.• Responsible for maintaining and enhancing application functionality.• Responsible for the management and maintenance of ASP.NET web applications hosted on the company's intranet site.• Participated in business and production support activities including troubleshooting software issues, diagnosing root causes of performance degradation, monitoring system logs, and analyzing intricate business processes• Worked in conjunction with database administrators in database performance tuning and optimization activities• Code reviews with the team to enforce clean coding standards, best practices, and proper application of design patterns• Designed and created the necessary databases needed to host business data, including tables, stored procedures, functions, triggers, and views in MS SQL Server 2008.• Interact with users to gather requirements, analyze requirements to design and develop sound and effective solutions, test the solutions, deploy the solutions to the live environment for general use, and develop documentation to facilitate the ongoing maintenance and support of these applications.• Integration and Unit testing using POSTMAN.• Creating and Unit Testing Store procedure for Mobile Maintenance application.• .Generated and ran functional test cases vital to the proper functioning of the website.

Lead the QA engineering effort by establishing the QA process. Contributed to the UI design and flow of application, Reviewed available documentation, specifications, and use cases to develop both a test plan as well as test cases , Facilitated the creation of the QA and development agreementWorked very closely with developers , Conducted manual testing of the mobile client (iPad, iPhone, Android) as well as cross browser testing on web client. (Safari, Internet Explorer, Chrome, Firefox) Responsible for finding, raising, triaging and assigning bugs as well as ensuring a satisfactory resolution, MS SQL Server Management Studio (SSMS) 2005, 2008, Building tables, views and stored procedures in SQL Server, Queried SQL databases obtain sample data for billing verification.

Responsible for third-level support for all server related issues. Participated in complete system builds, upgrades, migrations, code deployments and patch management. Implemented security policy and virus protection. Administered change management related to server upgrades and software installation.Prepared and maintained documentation of technologies, standards and procedures. Managed user accounts, groups, print queues and controlling access rights using Active Directory. Responsible for managing Citrix Server 4.0 and configuring Citrix clients. Installed, configured, performed troubleshooting and deployed SP1 for Windows 2003 Servers. Performed day-to-day administration functions, backup and restoration, file server maintenance. Supported all remote offices and home-based users using NetMeeting, VNC and Cisco VPN. Created images for various divisions for all desktops and laptops using Ghost.Solely responsible for all IT decision making, support and administration at a site of more than 200 ‘demanding users’ in a fast paced architectural and engineering environment. Implemented a new in-house printing solution that includes Xerox multi-functional copier, printers, scanners and wide format printer.