JAYRAJSINH SISODIYA

San Jose, ***** 669-***-****

adjaat@r.postjobfree.com

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