Nilesh Patel
Data Analyst @Codertroop
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @Codertroop
CA
Forecast call volumes and staffing by analyzing historical and real-time data across multi-channel contact centers.• Build SQL and Excel-based forecast models to guide budget and headcount planning.• Collaborate with marketing and ops teams for scenario modeling and client-driven forecast updates.• Design Power BI dashboards visualizing KPIs, call volume, and attrition trends.• Clean and validate high-volume call data using Python (Pandas, NumPy).• Support WFM teams with real-time shift allocation recommendations.• Conduct R-based statistical analysis to improve forecasting accuracy.• Lead ETL processes in SQL for cross-functional reporting pipelines.
EDUCATION
The Maharaja Sayajirao University of Baroda
Masters of Business Administration
Hemchandracharya North Gujarat University
Bachelor of Engineering
ABOUT NILESH PATEL
Data Analyst with over 5 years of experience in forecasting, workforce planning, and contact center analytics. I specialize in analyzing historical and real-time data, building forecast models, and optimizing staffing across 24/7 operations. My technical toolkit includes SQL (MySQL, SQL Server), Power BI, Excel (advanced functions/macros), Python (Pandas, NumPy), and R. I’ve developed dashboards, reduced operational costs, and supported real-time decisions for contact centers by aligning analytics with business strategy. I’m passionate about turning raw data into valuable insights and enjoy collaborating with cross-functional teams to solve business problems with clarity and precision.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.