Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Tapan Patel

Ajax,ON

Summary

Data analytics professional with expertise in business consultation, market research, and strategic analysis. Skilled in data analytics, data modeling, and visualization, as well as executing go-to-market strategies. Proficient in MS Excel, MS Powerpoint, MS Access, Python, R, SQL, Power BI, and Tableau. Seeking to leverage analytical expertise to drive strategic growth and organizational success.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Assistant Operations Manager

Kered Cable & Contracting
02.2023 - Current
  • Oversaw 10+ telecom infrastructure projects monthly, ensuring precision, regulatory compliance, and 0% deviation in design specifications.
  • Coordinated cross-functional teams, enhancing supply chain efficiency and cutting project completion time by 15% through improved scheduling and logistics.
  • Orchestrated and optimized project schedules, achieving 95% on-time delivery, and maximizing resource utilization.
  • Formulated project quotations, accounting for materials, labor, and overhead costs, contributing to 5% cost reductions in budgeting processes.
  • Implemented process enhancements, boosting productivity by 10% and generating $50K in annual savings.
  • Liaised with warehouse manager, optimizing supply chain operations and inventory control, reducing excess inventory by 10%.
  • Managed paperwork, administration, project designs and the internal change management system of Rogers for project tickets.

Freelance Contractor

The Smart Cube
06.2022 - 02.2023
  • Project 1: Conducted a comprehensive Supplier Intelligence report for a leading UK-based procurement client, identifying 5 top suppliers and providing insights into pricing trends, leading to a 15% improvement in supplier negotiations
  • Project 2: Led a study for a multinational credit card company on post-Covid workcation and staycation trends, resulting in a 7-10% revenue growth in B2B partnerships
  • Project 3: Spearheaded a Value Chain study across 9 niche industries for a financial services firm, optimizing operations and improving profitability through detailed product flow analysis, resulting in a 10% operational efficiency increase
  • Project 4: Directed a Market Intelligence project for a US-based investment firm, identifying 3 key technology investment opportunities, contributing to a 5% increase in ROI for the client.

Senior Business Analyst

The Smart Cube
05.2020 - 06.2022
  • Led an 8 analyst in a 3-phase business development study for a top insurance company, expanding their digital healthcare offerings and uncovering 5+ market opportunities.
  • Executed market assessments across diverse industries, such as autonomous vehicles, HD mapping, and rare chemicals, analyzing 10+ value chains and evaluating competitors to deliver strategic recommendations.
  • Conducted market opportunity assessments and competitive analysis, identifying key trends and providing actionable recommendations that led to 5-10% operational efficiency improvements.
  • Developed actionable insights by leveraging sources such as Capital IQ and Nexis, interviewing 15+ SBMs, and producing client-ready deliverables.
  • Led 5+ Go-to-Market studies for a UK-based financial services firm, increasing credit card acceptance by 15-25% in retail segments and securing annual full-time equivalent (FTE) business.
  • Trained and mentored junior analysts, in handling open-ended requests and creating scope and methodology to meet client objectives, improving team productivity by 20%.

Management Intern

Steel Authority of India (SAIL)
04.2019 - 06.2019
  • Conducted a comprehensive analysis of import logistics for containerized cargo, identifying 14 major cost factors from 20 yrs of EXIM data.
  • Collaborated with stakeholders to propose process improvements and designed 9 optimized inbound logistics routes, potentially reducing overall costs by 10-15%.
  • Automated solution using MS Excel and VBA to streamline the generation of trade documents, integrating various Letter of Credits (LC) with SAP data management tools, enhancing efficiency in export logistics.

Civil Engineer

LD Construction
06.2017 - 06.2018
  • Supervised civil works for 4+ large-scale projects valued at $500K+, ensuring 100% compliance with design specifications and timelines.
  • Provided budget oversight and developed cost estimates, optimizing budgets by 5% and securing 8% savings through strategic supplier negotiations.
  • Anticipated material needs and streamlined procurement, reducing delays by 10% and enhancing quality by 15% to improve overall project efficiency by 20%.
  • Organized daily work schedules and enforced quality control during concrete work, prioritizing safety and boosting team productivity by 20% while achieving 100% on-time delivery and zero safety violations.

Education

MBA - Operation & Marketing

Institute of Management, Nirma University
Ahmedabad, India
04.2020

Bachelor of Technology - Civil engineering

Vellore Institute of Technology (VIT University)
Vellore, India
05.2017

Skills

  • Python (Advanced)
  • R (Intermediate)
  • SQL (Advanced)
  • Microsoft Excel, Power Point and Word (Advanced)
  • Data Analytics
  • Power BI (Advanced)
  • Tableau (Advanced)
  • SAS (Begineer)
  • Market Analysis
  • Competitive Benchmarking
  • Supplier Intelligence
  • White Space Analysis
  • Project Management

Certification

  • Certified Green Belt - Lean Six Sigma professional by KPMG.
  • Confederation of Indian Industry (CII) certified Supply Chain Management Professional (SCM EXE).
  • Certificate of Completion of Excel Analytics: Linear Regression Analysis in MS Excel, by Udemy
  • Certificate of Training on ‘Advance EXCEL’ from NIIT.
  • Life License Qualification Program (LLQP).
  • Certifications/training in Tableau, R, Data Analytics, SQL, Python and Power BI

Accomplishments

  • Awarded High Honors at The Smart Cube for outstanding performance in 2021, recognizing excellence among 31 team members.
  • Received the Best Debutant Award at The Smart Cube for exceptional performance among 60 campus analysts in September 2020.
  • Achieved 4 Kudos (monthly recognitions) during a 2-year tenure at The Smart Cube for consistently outstanding contributions.
  • Led a team of 18 people and covered 108 companies in 6 days for campus recruitment efforts as a placement coordinator, IMNU
  • Directed initiatives for student affairs as a member of Student Welfare Committee, IMNU

Timeline

Assistant Operations Manager

Kered Cable & Contracting
02.2023 - Current

Freelance Contractor

The Smart Cube
06.2022 - 02.2023

Senior Business Analyst

The Smart Cube
05.2020 - 06.2022

Management Intern

Steel Authority of India (SAIL)
04.2019 - 06.2019

Civil Engineer

LD Construction
06.2017 - 06.2018

MBA - Operation & Marketing

Institute of Management, Nirma University

Bachelor of Technology - Civil engineering

Vellore Institute of Technology (VIT University)
Tapan Patel