Pavan Johal Email & Phone Number

El Sobrante, Ca, Us

Benicia, California, United States

- Updating product catalog using SQL from vendor-supplied data for both passenger and commercial vehicles. - Identify trends for high-maintenance cars to optimize warehouse stocking based on past sales data via SQL.- Providing assistance for franchises when navigating the product catalog via Salesforce Lightning. - Performing QA reviews for regular catalog and continuously improving product selection for passenger and commercial vehicles.

- Co-responsible for Quality Assurance for contracted drive test datasets (avg. 10 GB data file size) to optimize one of the nation’s largest 5G networks.- 100% on-time delivery for over 300+ data analysis reports in a 60-day period with 100% client satisfaction.- Provided data analysis expertise and context to field engineers and calibration teams to validate data and actionable insights.- Developed in-depth knowledge of radio frequencies (800 MHz, 2010 MHz, 3700 MHz) to verify site collections, licenses and provide necessary analysis.

- Advised upper management to re-prioritizing deliveries to local businesses in order to reduce package returns by 10%.- Analyzed data using Excel, presented to Upper Management key findings and insights to help implement new routes that improved productivity and delivery rates by at least 15% across all areas.