Farhan Munir Email and Phone Number

• Data Analysis: Executed time-series analysis in Python on order fulfillment data, identifying bottlenecks and implementing targeted process improvements, leading to a 20% increase in on-time deliveries.• Supply Chain Modeling: Optimized supply chain transportation through linear programming and network optimization modeling techniques, achieving a 27% reduction in operational costs (SQL, Excel).• Network Analysis: Facilitated transportation visibility by creating interactive dashboards in Tableau, showcasing delivery times, transportation routes, and shipment tracking, reducing data reporting time by 1.5 hours.• Data Transformation: Engineered ETL processes to build a data mart, combining 3+ data sources to a SQL framework for ~1M+ records, ensuring data mapping and reducing data retrieval time from 25 min to 1 min.• Hypothesis Testing: Employed data mining and hypothesis testing to perform credit risk assessment of the firm’s clients, and predict credit card approval rate in Python, achieving an 82% prediction accuracy.• Mentoring: Trained students on the fundamentals of databases in MySQL, boosting class performance by 23%.

Co-founded the startup and focused on the analytics side, helping small retail businesses analyze sales data, customer behavior, and inventory management to optimize pricing, product selection, and supply chain efficiency.• Inventory Optimization: Utilized ABC analysis and EOQ (Economics Order Quantity) model for inventory management, optimizing stock levels of clients, and minimizing excess inventory by 20%.• Demand Planning: Advocated Supplier Relationship Management (SRM) practices and implemented risk management strategies to mitigate supply chain disruptions, enhancing demand planning accuracy, and reducing lead times by 11%.• Automation: Improved data accuracy of order processing systems by automating data extraction and workflows, enhancing data quality, and reducing manual data handling times (SQL, Macros, Python).• Data Reporting: Collected business insights and functional requirements from stakeholders and built robust quality control reporting systems for monitoring KPIs in Tableau for 40+ clients.• Optimization: Leveraged SQL, Macros, and pivot tables to conduct inventory analysis, identifying optimal stock levels, optimizing costs, improving productivity, and reducing operational costs by 20%.• Market Research: Managed ad-hoc requests, analyzed 20+ market surveys, ensured timely submission of deliverables, and fostered client relations, acquiring 13 clients in 2 months.

• Trend Analysis: Implemented a feature engineering pipeline, leveraging CRM database in MySQL Server to analyze customer churn patterns, achieving an 8% increase in customer retention rate in A/B testing.• Data Modeling: Developed and deployed Python classification models, intelligently pairing inbound callers with call center agents based on customer behavioral patterns and demographic data, generating quarterly revenue of $1.13M.• Collaboration: Collaborated with cross-functional teams, including data scientists and business analysts, to develop a KPI-driven agent ranking system, reducing the Average Handle Time (AHT) of inbound calls by 17 minutes.• Hypothesis Testing: Conducted A/B testing analysis to measure the impact of changes in call routing strategies, discovering a 3% increase in successful interactions in production monitoring.• Reporting: Presented weekly actionable insights to stakeholders, driving a 15% surge in the adoption of strategic recommendations.

• Managed the work timelines of 34 high school students in Mathematics and Physics, and helped them identify their goals by implementing the SMART strategy (Specific, Measurable, Attainable, Relevant, Time-bound)• Organized weekly course meetings, overviewed performance, and mentored students for career advancement goals• Delivered lectures in an easy-to-understand manner to the students, helping students understand complex topics.• Travelled 30 miles every day on a bike to teach students in the comfort of their homes, showcasing my dedication, hard work, and enthusiasm to impart knowledge and educate others.

• Assisted the professor for 3 consecutive semesters in course planning, assignment grading, and preparing student performance reports.• Presented and clarified the course objectives to a class of 54 students and reporting back to the professor• Arranged weekly problem-solving sessions during office hours to strengthen the fundamentals of students.