Data Analyst

Ashish K. Maheshwari

***.******@*****.*** 806-***-**** Github linkedin.com/in/ashishkmaheshwari/ EDUCATION

Texas Tech University – Rawls College of Business Lubbock, TX Master of Science, Data Science May 2020

Visvesvaraya Technological University Bangalore, India Bachelor of Engineering, Industrial Engineering & Management June 2014 EXPERIENCE

iSmile Technologies Lubbock, TX

AI/Data Science Researcher July 2020– Present

Deployed a machine learning in GCP to predict user engagement in context to a Dating App using Agile methodology

Integrated the model with the organizations internal application for real time data collection and model improvement Narnolia Financial Advisors Kolkata, India

Data Analyst Apr. 2018 – May 2019

Headed entire CRM project lifecycle, including client teleconferencing, requirement gathering, knowledge transfer sessions, data analysis and reporting, increasing client satisfaction level from “Low” to “High”

Utilized Python libraries NumPy, Pandas & Matplotlib for data cleaning, EDA, visualization, and automation of daily transactional data reporting to the CEO and COO, increasing revenue through improved client insights

Designed and developed 35+ graphical reports across 10 dashboards to visualize transactions using Tableau and Advanced Excel, reducing man hours by 25%

Modeled data and integrated the database using Advanced SQL queries to interact with multiple APIs to reduce data redundancies and improve data movement across systems, producing results in 1 hour that previously took 1 day Yash Flexipack Kolkata, India

Marketing Data Analyst May 2017 – Mar. 2018

Built customer acquisition strategy to produce consistent monthly growth of 10%+ using SQLand Advanced Excel

Expanded client base from ~37 to ~75 and overall sales from ~$5M to ~7.5M through one-on-one client visits & marketing

Implemented A/B testing to increase SEO/SEM traffic by performing in-depth keyword and content analysis, improving overall sales by 35% and doubling the customer acquisition for the year Sastasundar.com Kolkata, India

Business Analyst/Franchisee Head June 2016 – Apr. 2017

Managed all e-commerce store verticals including sales, marketing, operations, finance and customer service to reduce cost

Increased monthly sales from $5k to $13k through Excel data analysis, door-to-door sales, cold calling and events Decathlon Bangalore, India

Supply Chain Analyst Mar. 2015 – May 2016

Pioneered and automated general terms-of-delivery project by developing and implementing SOPs, eliminating bottlenecks and ensuring efficient process flow

Trained 60+ QA employees in legal retail compliance, reducing waste by 6% and legal spend by 13%

Optimized in-house Custom Clearance processes with 3rd-party logistics companies, yielding $3M savings in Custom Duties

Collaborated with top suppliers responsible for €76M of €110M transportation spend for 2015-16 to reduce benchmark cost by 17% while increasing shipment acceptance rate by 20%, on-time delivery by 8% and improving vendor relations

Created unique forecasting model using R to estimate future cost per shipment load on individual lanes and improve scheduling efficiency by 14%

ACADEMIC PROJECTS

Dietary Composition of Different Countries(R, Tableau)

Performed analysis of regional diets and drew insights on correlation between consumption habits and health to provide additional research data for future projects aiming to determine causes of regional diseases US School Districts Database (SQL)

Designed and implemented a relational/dimensional database usingcomplex SQL queries to insert, manipulate and update the data in MySQL workbench for US schooldistrict data over a 7-year period SKILLS

Programming: Python, R, SQL, Shell Scripting ETL & Databases: MySQL, MS SQL, PostgreSQL, MS Access, BigQuery Business Intelligence: Tableau, MS Excel, VBA, PowerBI, Bokeh, Seaborn, Pandas, Numpy, Matplotlib Machine Learning: Regression, Classification, Clustering, Time Series Analysis, Text Mining, Scikit-Learn Statistics: Correlation, Chi-square, ANOVA, A/B Testing Tools: Anaconda, R-Studio, SQL developer, PyCharm Others: Operations Research, Monte Carlo Markov Chains, Data Modeling, Project Management, Agile, Scrum, Google Cloud Platform, Azure DevOps LEADERSHIP

Raised, matched and realized 192 international student intern exchanges from 27 countries as Vice President of AIESEC Bangalore (2011-12); led team of 25 and worked with 48 NGOs

Contact this candidate