Venkatesh Malhotra

**** ******* **, *********, ** 92831 ac0ofo@r.postjobfree.com 669-***-****

https://linkedin.com/in/venkateshmalhotra https://github.com/venkateshmalhotra

Professional Summary:

Information Systems graduate with formal experience in analyzing, interpreting data in fast paced environment. Advanced proficiency in latest BI tools to provide strategic insights to company.

Tools/Languages: Salesforce, Tableau, SSRS, Access, SQL Server, Java, JavaScript, Excel, R, Python, SQL.

Core skills: Data/Statistical Analysis, Report Generation, Data Visualization, Project Management.

Education:

Master of Science, Information Systems, Concentration: Business Analytics May, 2017

California State University, Fullerton, United States

Bachelor of Engineering, Electronics and Communication Engineering Aug, 2013

Gujarat Tech University, Ahmedabad, India

Relevant Coursework:

Business Databases, Data Warehousing/Business Intelligence Basics, Object Oriented Programming (Java), Decision Models, System Analysis/Design, Visual Basic, C++, Data Mining for Managers, Marketing Analytics.

Professional Experience:

Herbalife- Sales Analyst Intern: -Los Angeles, CA May, 2016- Aug, 2016

Forecasting Event Ticket Sales:

Performed statistical analysis on the Event Ticket Sales data by integrating R programming language with Tableau.

Visualized the data using Tableau to identify trends and seasonality by building interactive maps and line graphs.

Developed a customized forecasting model to optimize budget for event promotion by examining historical data.

Worked extensively on Micro Strategy Web to perform Ad Hoc analysis on generated reports for ticket sales data using Advanced Metric objects. Presented the finding and got sign off from services management department.

Malhotra Cables Pvt Ltd– Business Analyst: - New Delhi, India July, 2013- May, 2014

Discovered potential market opportunities for copper cables by eliciting business requirements and strategizing campaigns using A/B and multivariate testing.

Analyzed customer trade monthly by creating transition planning matrix and macros in excel to market gap analysis.

Designed Use Case and Class diagrams using UML methodology in MS Visio to model static view of application.

Extrapolated Agile Methodologies using Scrum to emphasize collaboration between development teams and business stakeholders which increased throughput by 10 %.

Maintained a multidimensional database for generating automated reports using SSRS.

Won “Best performer of the year” award for showing distinguished skills and optimizing growth of the company.

Nanosoft- IT Intern: -Gandhinagar, India April, 2013- June, 2013

E-shopping Analytics with Python:

Built predictive models using Python’s Scikit Learn to determine products having higher probability of generating a sale based on consumer’s purchase history/product value.

Implemented advanced ETL processes using SSIS to structure data pertaining to customer’s purchase history.

Axio Biosolutions Pvt Ltd- Data Analyst Intern (Text Analytics): - Ahmedabad, India June, 2012- Sep, 2012

Predicted sales of high impact medical products by finding correlation between public sentiments and product sales.

Filtered, cleansed and stemmed 100,000 tweets utilizing Twitter’s streaming API and Python libraries (Pandas, Numpy) and classified them using Logistic Regression and SVM to achieve 65 % accuracy for bigrams.

Relevant Academic Projects:

Forecasting road services calls for American Automobile Association-Forecast Pro, Excel: Spring, 2017

Built a dynamic regression model to measure the effect of variables like rainfall and climate on emergency road service calls.

Marketing Analysis for Pacific Brands-ME-XL: Fall, 2016

Assessed digital marketing strategies for Pacific Brands by performing Segmenting on available data.

Aikidiko Association Rank Compliance Database-MS SQL Server, SQL: Fall, 2014

Queried database using SQL to measure effectiveness of teachers and speed of processing ranks.

Contact this candidate