Danish Alam

DANISH ALAM Mobile No: - | Email:-| Lucknow, India https://www.linkedin.com/in/danishalam26/ Tools: Python, Excel, SQL (MySQL, Postgres, T-SQL, Bigquery), SPSS, Tableau, Amplitude, Google Data Studio Cloud: AWS (S3, Glue, Athena, Lambda, EC2, Redshift) Familiarity: Apache Spark, Hadoop Ecosystem, Mongo DB, GCP, Neo4j Work Experience Lead Data Analyst (Send Australia - Noida, UP) Sept 2021 — Present ● Leading the analytics team at Australian start-up Send 10-min, and delivering analytical solutions to Operations, Marketing, CS & Product verticals ● Multiple SKU’s forecasting using GBM / weekly orders at store level & orders per hour forecasting using AR, MA, ARIMA ● BG/NBD probabilistic model for CLV prediction ● Regression models to predict weekly sales while considering various geo parameters of Sydney like temperature, windspeed, sunshine and humidity ● Product analytics using Amplitude, cohort/ funnel analysis to monitor customer behavior and feature performance ● Performing A/B testing for feature improvement and statistical test on promotions and discounts to select best value ● Classification models, RFM, basket analysis to deliver critical marketing insight ● Introduced AOV threshold for delivery fee implementation using prescriptive methods like Jens natural break ● Inventory Analysis to minimize wastage cost based on demand classification model, ABC XYZ analysis ● Demand Simulation and Price Optimization ● Managing Tableau site admin/creator role along with preparation for ad-hoc and live production dashboards. ● Performing ad-hoc ETL / data modeling jobs on AWS involving S3/Crawler/Athena/Glue/Redshift ● On demand ad-hoc analysis, build and automated daily & weekly reports, sending critical investor reports ● Team hiring, training with regular feedback. Direct reporting to Founder & Co-Founder ● Currently, learning Graph database (Neo4j) for fraud analytics and building company first recommendation system Freelancer (HubStaff Talent, Lucknow) Oct 2020 — Aug 2021 ● Optimization - Supplier selection analytics / Transportation Cost analytics / Warehouse location models ● Marketing & Customer Analytics – Market Basket / RFM / Demand Estimation / Sensitivity Analysis / Evaluating Pricing Strategies ● Inventory Management / Safety Stock & Re-order level / Continuous & Periodic review system ● Demand Forecasting / Multiple SKU’s Forecasting / Time-series models ● Simulation – Six Sigma & Queuing in coordination / Measuring degree of coordination ● Supply Network Design - Risk Analytics ● Supplier Selection Analysis ● Statistical Modeling ● Regression models – Simple /Multiple /Logistics ● Decision Trees / Text Analytics / Random Forest ● Unsupervised models – K-Means Clustering Danish 1 Lead Analyst (in3corp - Boulder, CO; Lucknow) May 2009 — May 2017 ● Managed and delivered multiple Supply Chain projects ranging from Demand Planning, Forecasting, Inventory Analysis, Account Reconciliation, Contractual/Compliance audits, Transaction Level Accounts Payable review and PO level Purchase Price Variance Analysis, Freight analysis. ● Initiating and managing project and data requirements with global clients. ● Performing sample-based analysis to identify project scope, timeline, goals and deliverables. ● Worked directly with stakeholders to obtain desired results and close the projects within stipulated deadline. ● Created and presented multiple project reports to C-level executive of Fortune 500 companies. ● Delivered domain specific recommendations to improve business process. ● Performing ETL operation on data gathered in various forms (Excel, CSV, Jason etc). ● SQL schema designing. ● Data cleaning and modeling. ● Performing EDA, and business specific analysis using SQL, Excel, and Access. ● Team development via training & mentoring, conducting performance evaluation, and delegating tasks based on individual skill sets. Education Bachelor of Commerce (National PG College, Lucknow) Jul 2000 — Apr 2003 ● Statistics● Marketing ● Economics Certifications (Online) ● Predictive Analytics (IIM – Banglore) ● Modeling & Analytics, Supply Chain (IIT - Kharagpur) ● Supply Chain Analytics (IIT - Roorkee) ● Data Engineering & Machine Learning (GCP) ● Data to Insight (BigQuery GCP) ● Google Data Studio (Google Analytics Academy) ● Data Analysis with Python (Jovian) ● Big Data with Hadoop & Spark (CloudxLab) Interests ● Cooking ● Reading Languages ● English ● Hindi ● Urdu Danish 2