Data Analyst Sales
Resume:
JAYRAJSINH SISODIYA
San Jose, ***** 669-***-****
********************@*****.***
CAREER SUMMARY:
Curious, data-driven and detail-oriented professional with more than 3 years of experience in the analytics & operations field. I am eager to make positive impact with data by leveraging analytical, technical and problem-solving skills combined with a strong cross-functional understanding of business acumen, financial and information technology.
TECHNICAL SKILLS:
Languages and Database Tools: Python, R, SQL, SAS, Hadoop, SQL Loader, MS Access, MS SQL Server
Statistical and Analytical Tools: Jupyter Notebook, Pandas, Numpy, Scipy, SPSS, SSRS, Crystal Reports, MicroStrategy
Data Visualization Tools: Tableau, MS Power BI, Google Analytics, matplotlib, seaborn, ggplot2
Technologies: Salesforce, Clari, MS Project, Jira, SharePoint, Oracle EBS, SAP ERP, JMP, MS office applications
Algorithms: Regression, Classification, Decision Tree, Clustering (KNN, K-means), Deep Learning (CNN, LSTM)
WORK EXPERIENCE:
Business Data Analyst – Strategic Planning at Spring Group Saratoga, CA 08/2020 – Present
Utilizing tools such as Salesforce CRM, Adaptive Insights, Tableau, MS SQL Server to develop and implement data analysis, data collection and validation, and data warehouse strategies that optimize statistical efficiency.
Executing reporting process for the Strategic Planning & Analysis team by creating, maintaining and reviewing a variety of reports including sales, forecast, business trend, and financial position that reduced process time by 90%.
Customized ETL pipelines to manage data warehouse using combination of Python and Snowflake’s SnowSQL.
Developed enrollment forecasting models using deep learning techniques such as CNN, LSTM with 85 % accuracy.
Automated sales analytics dashboards & reporting using Python Libraries such as Numpy, SciPy, pandas for data manipulation and data mapping purpose saving my team + stakeholders couple of hours daily.
Business Analyst - Analytics at McAfee Santa Clara, CA 02/2020 – 05/2020
Created automated ETL pipelines for product and sales performance analysis via HQL/SQL from Hadoop.
Conducted marketing analysis to manage competitive dashboard of McAfee and competitor historical pricing and provided key insights of pricing changes using SFDC, Tableau that resulted in turnaround time to issue price.
Communicated and provided insights effectively and compellingly across multiple department of the organization.
Data Analyst - Business Development Intern at Nutanix San Jose, CA 06/2019 – 12/2019
Built self-service business intelligence dashboards in Tableau for the team with 100+ users/week saving of hundreds of hours of external reporting. Designed dashboards for 30+ technological alliance partners of Nutanix.
Generated descriptive/predictive marketing intelligence for Partner Marketing division using Excel, Salesforce, R.
Created and automated 90+ dashboards in SFDC, Tableau for campaign intelligence to partner reps using Python.
Led Partner Marketing Salesforce contact database to maintained data integrity for 3,000+ accounts in SFDC.
Performed linear/logistic regression analysis to analyze campaign effectiveness, textual analytics on partner emails.
Data Analyst Intern at Cube Engineering Ahmedabad, India 01/2016 – 05/2017
Managed database system using MS Access, MS SQL to build ad hoc reports and analyses to the management.
Communicated findings on monthly basis for higher management using interactive charts developed on Tableau.
Saved 40% time by generating the monthly report and by developing an auto report generator using VBA.
KEY ACHIEVEMENTS:
Developed and maintained sales analytics reports/dashboards using Salesforce, Tableau to provide actionable insights that help inform data-driven business decisions. Identified a bottleneck generating 3 % loss of revenue.
Stored SQL procedures to integrate data and conducted data-mapping to join the Salesforce Database (160,000 rows) to the HR Insights Database (70,000 rows) using MS SQL, MS Access, MS Excel saving approximately $1.5 M.
Spearheaded data analysis to build a predictive model that can identify sales opportunities outcome using "machine learning algorithms" with an accuracy of 75 %. The model increased sales productivity by 10 %.
Performed data analysis to analyze trends for predictive modelling for employee churn rate using time-series forecasting methods. The model has an accuracy of 81% and provided KPIs that have affected the churn rate.
EDUCATION:
San Jose State University San Jose, CA 12/2019
Master of Science Engineering Management Specialization – Data Analytics GPA = 3.60
Pandit Deendayal Petroleum University Gandhinagar, India 05/2017
Bachelor of Technology Engineering
PROFESSIONAL CERTIFICATES:
IBM Certified Data Science Professional
Google Analytics Certified Professional
Six Sigma Green Belt
CORE SKILLS:
Statistical Analysis
Machine Learning
Database Management
Data Visualization & Dashboards
Data Analysis & Exploration
Business Intelligence
Statistical Programming
Agile Project Management
Demand Planning
Documentation
ACADEMIC PROJECTS:
Regression: Air Quality Index Prediction
Performed web scraping to collect data from multiple sources such as using Beautiful Soup and Selenium.
Applied regression algorithms for prediction and concluded that XGBoost algorithm has the least MSE of 17.95 %.
Business Case Modelling
Researched and analyzed corporate data (financial position, strategy, vision, and leadership) to tap potential international markets and to design and deliver technology solutions to satisfy business needs.
Tools utilized: SWOT Analysis, 5Ps, Market Research & Analysis
Canvas: Learning Management System
Developed a scrum project by building Project Charter, Product Backlog, Product Release Plan, Sprint Planning, implementing in Jira and Confluence and preparing Gantt chart in MS Project for each activity.
Statistical Analysis using MS Excel
Evaluated sample dataset using outlier analysis, boxplots, V-lookup, Pivot tables, Normal and T-distribution.
Contact this candidate