Digital Marketing Data

MADHU KAUSHIK **** Atherton Avenue Apt**,San Jose, CA 95130 669-***-**** adchc0@r.postjobfree.com Summary

Graduate student possessing a multi-disciplinary background spanning Engineering and Business Analytics, with a focus on data driven approach to problem solving and ability of turning data findings into actionable plans. Education

SAN FRANCISCO STATE UNIVERSITY- College of Business Expected DEC 2020 Masters of Science in Business Analytics (MSBA) (4.0/4.0 GPA) San Jose City College MAY 2019

Statistics (4.0/4.0 GPA) and Financial Accounting (3.0/4.0 GPA) Uttar Pradesh Technical University, India JUNE 2015 Bachelor of Technology, Electrical and Electronics Engineering (3.0/4 GPA) Technical Skills

● Python,SQL, Machine Learning, Data Analysis, Big Data Technologies(Hadoop, Apache Kafka, Spark, Flume)

● Data Visualization(Tableau, Power BI), MS Excel,Software Testing,Data Mining, Trend Analysis, Data Modeling Work Experience

Swiggy - Hyderabad, India

Sales Analysis Manager May 2017 -May 2018

-Performed statistical analysis on large, complex data sets to develop business strategy covering sales, promotions, revenue and agreed targets which in return increased the city profit by 12%.

-Effectively used Power BI to monitor the metrics against the given business goal and predictive model to forecast key business metrics for designing the sales strategy that increased the target achievement rate by 7%.

-Analyzed trend in sales data, impact of different marketing promotions - pre and post promotional lifts to forecast the revenue that can be generated and select promotions which can best work to achieve the forecasted number.

-Manipulated data for performance reporting, streamlining processes and strategic expansion of market share.

-Stipulated recommendation on capitalizing on opportunities by doing competitor analysis and converting researched data into effective sales strategy which reduced the market penetration of competitor by 9%.

-Bagged a project of OYO Kitchens(New Vertical of OYO) for its expansion in the city, analyzed data to make effective strategies for market penetration, expansion and revenue generation and started making profit of 5%. Cognizant Technology Solutions - Chennai, India

Programmer Analyst Trainee (Engineer Trainee) March 2016- December 2016

-Worked on a java based project in retail vertical which involved Software Testing.

-Created a test plan for the project, conceiving of the testing strategy and approach.

-Developed test documents such as test cases, test data, test summary reports, and bug reports. Grofers- Gurgaon, India

Operations Executive August 2015-March 2016

-Operations management: From receiving of order to dispatching and delivery of order.

-Based on performance, I was asked to train a team of 10 executives for Delhi region.

-Process management- based on data, prepared a report to add and remove merchants to increase the operations and order fulfillment efficiency by 17%.

-Preparing Inventory Replenishment Report based on data of specific geographical area allocated to reduce the cancellation of order by 20%.

PROJECTS

Digital Marketing project: Worked with a client (restaurant) in Burlingame, understanding his requirements and aligning it with the project requirement. Link: http://caffeilpiccolo.com/. Components of project: Building website and content for marketing, used Google AdWords and Facebook to derive traffic, used Google Analytics to measure the website marketing performance,SEO, MailChimp. Python Data Analysis Project: https://github.com/mkaushik1993 Data Set: Kaggle - Heart Disease UCI Analyzed how different health factors impact the odds of having a heart disease. Components: data extraction, data cleaning, data analysis, visualization, data modeling and model validation. Statistics Project: Used cross validation, non-linear weighted regression and data manipulation to determine the optimal level of aggregation (Global, Division, Department) to be used for forecasting retail demand promotional lifts. Financial Accounting Project: Analyzed Annual Report( Income Statement,Cash Flow Statement,Statement of changes in stockholder's Equity Notes, footnotes, disclosures, and supporting schedules to the financial,Receivable as a percentage of total assets,Accounts receivable turnover,Average collection period in days,Debt to Asset ratio) of Southwest and Alaska Airlines to understand which company is more profitable, which company stock one should purchase and why, also the Final Analysis.

Contact this candidate