EDUCATION AND CERTIFICATION

REFERENCES Available on request

Punjab Technical University,(PTU, India) 2004 - 2008 MS in Data Analytics

McDaniel College, Expected Graduation: 2023~2025

Exposure: Gretl, R, PYTHON, GITHUB, Kaggle,

PG Cert. in Data Science & Machine Learning

Indian Institute Of Technology(IIT, India), 2022 - 2023 Exposure: PYTHON, MYSQL, ML, Hadoop, Azure, Data Lakes, Neural networks, Google Labs, Databricks etc,

Cert. Lean Six-Sigma

American Society for Quality (ASQ, India), 2021

Exposure: Minitab

BE/B-TECH in Mechanical Engineering

I am a seasoned data professional with 15 years of experience who believes in maximizing productivity, profitability and competitiveness by processing huge datasets into informed business decisions. Data Analyst

ABHISHEK BHANDARI https://www.linkedin.com/in/abhishekbhandari07 Visa Status : F1 [2023-28]

ad1fgj@r.postjobfree.com

+1-984-***-****

295 Bear Tree Creek, Chapel Hill, NC, 27517

Manager - Cost Analyst/ NPD / GLOBAL EXPORT

India Yamaha Motor Pvt. Ltd

Senior Engineer Purchaser

TPS Infrastructure Ltd

2013 - 2023

Led cost analysis, model costing development, and cost reduction initiatives.

Budgeting, forecasting, and financial planning to support the finance department.

Prepared dashboards, managed MIS, and ensured control over all KPI’s. Presented project charters and achieved 100% QCD milestones. Defined KPIs and Department Functional Manual- Job procedures/rules for Export business and Costing division. Determining Freight On Board (FOB) and Shipping cost analysis. Project Management from Proto stage to SOP and running change control (revision).

EXPERIENCE

Achievement & Recognition

Secured 1st position at Hackathon, IIT, India [Jan 2023] Led Global Model Cost Analysis, IYM, India [Jan 2022] Data Visualization: POWER BI, Tableau, Excel

Machine Learning Tool: Scikit-Learn, Pandas, TensorFlow, Pytorch, NLTK, Matplotlib & Seaborn,

Data Science Processes: ETL, EDA, Train Mode-Supervised & Unsupervised learnings, Evaluation, Hyperparameter Tuning, Interpret. Programming: Python, R, SQL,

Statistics Tool: GRETL, MINITAB

Technical Skills

Self Motivated

Critical Thinking & Problem Solving

Attention to Details

Ability to work under pressure & Time Management

Negotiation & Conflict Resolution

Communication & Presentation

Soft Skills

Streamlined model cost report preparation, reducing it by 75% (from 4 wk.'s to 1 wk), by analyzing the flow of information and applying techniques using Linear Regression, Lean, advanced Excel, and PowerPoint. Designed real-time dashboards for cost analysis, budgeting, and proto management, ensuring 100% on-time KPI achievement. Leveraged Power BI and adv. Excel for quantitative and qualitative insights. Developed a DBMS for Proto, RFQ and Quotation management, slashing lead times by 72% (from 25 to 7 days) and eliminating non-productive activities. Employed MS Access and Lean methodology for efficiency. Efficiently streamlined cost analysis through a Simple Slim Speed method, analyzing two years of cost data, conducting ETL for user-friendly analysis, and reaching a 25% annual cost reduction goal with Logistic Regression, Power BI and Python.

Projects

Led Global Project Development, YMC, Japan [Mar 2018] Represented IYM for Project Management, YMDA/YMDBA, Brazil [Oct 2017] 2012 - 2013

Senior Engineer Purchaser

Case New Holland Fiat India Pvt

Vendor management and alt. sourcing for Hyd. parts & for RCV/ATV. Cost settlement, negotiation, price revision, & ensure delivery (QCD). 2011 - 2012

Senior Engineer Purchaser

International Tractors Limited (SONALIKA)

Purchased and developed casting parts under PPAP.

Built strong buyer-supplier relationships, created RFQs, and evaluated vendor bids.

Regulated SOB for production and generated cost-saving ideas. Optimized Tool Development Lead time by 20%, reducing the average lead time for raw material procurement from 2 to 1 month by forecasting (total tool development lead time to 6 months). Utilized Lean methods for advanced model forecasting.

Project

Purchased and developed casting, sheet metal, and forging parts. Insure QDC, RFQ prep., Quotation analysis and evaluated vendor . Regulated SOB for smooth production and generated cost-saving ideas.

2008 - 2011

Reduced casting part costs by 2-5% through a comprehensive analysis of wall thickness based on drawing specification examination and sampling. Project

Conducted a hypothesis test (ANOVA) on global YouTube data to identify global trends and channel earnings across different categories

Performed EDA on sales data, identifying opportunities for product category enhancements and customer-specific offers.

Built an E-commerce classification model using Python for fraud detection and customer segmentation. Run ETL and EDA to identified venerable customers, risk category, and followed by recommendations. [IIT]

Academic Projects

Built a multi-regression with Gretl to forecast earnings. [McDanieal] Built a sales prediction Random Forest model using Python to enhance decision- making and forecast sales more effectively. [IIT]

in

Professional Summery

Contact this candidate