Livecareer-Resume
Jessica Claire
Montgomery Street, San Francisco, CA 94105
Home: (555) 432-1000 - Cell: - resumesample@example.com - -
Summary
Proficient knowledge in Statistics, SQL, Python and Microsoft Excel *Outstanding ability in understanding Business Operations and Analytics tools for effective analysis of data. *Expertise in Statistical Analysis, Data Extraction, Data Mining *Ability to generate new reports and dashboards using BI tools like Tableau and Power BI *Data analyst with hands on project experience in data mining, data warehousing, data analysis and business modelling
Skills
  • Microsoft SQL server 2014, MySQL, Microsoft Access
  • Analytical Tools: Tableau, IBM Watson Analytics, Power BI
  • Programming Skills: SQL, Object Oriented Programming, Core Java, R programming, Python
  • Statistical tools: Microsoft Excel (VBA, PivotTables, Macros), SPSS, XL Miner, MEXL, Forecast Pro
  • Conceptual Knowledge: Big Data, Pig, Hive, Map Reduce, Hadoop, SAS
  • Modeling/Statistical Analysis: Linear Programming, Regression Analysis, Prediction, Classification, Clustering, Hypothesis Testing, ANOVA,
  • Relevant Coursework: Statistics, Decision Models, Data Mining, Business Intelligence, Data Warehousing, Marketing Analytics, Business Forecasting, Business Modelling Effectively organizing, analyzing and presenting information using Microsoft Excel
  • Generate outputs with macros, goal seek, solver, simulation and data tables in operation, production, marketing and finance
  • Employed macros, Vba and other excel formulas to determine best location for any business model
Technical Skills
Accomplishments
Experience
01/2017 to 03/2017
, ,
  • Forecasted the sales of red table wine for the upcoming year by applying and comparing various exponential smoothing methods using Forecast Pro.
  • Analyzed the fit, accuracy of the models and performed Auto correlation function to discover trend, patterns in the data.
  • Created forecasts using historic data of monthly wine sales.
  • Achieved 95% accuracy using Winters exponential smoothing model and made recommendations on selling excess wine to increase revenues and reduce wastage Business databases and intelligence- Airbnb San Francisco.
08/2016 to 12/2016
Bickford Senior Living , ,
  • Extracted and aggregated S&P 500 share values from two years and predicted the company's stock price for the upcoming year using cluster analysis.
  • Performed data pre- processing to clean, eliminate outliers in the data and conducted data exploration to detect correlation, trends and patterns in the data.
  • Data analysis using modelling techniques like Association, Logistic regression, classification trees (CART), K-nearest Neighbor and visualization to compare the accuracy and error rate of the output using XL Miner.
  • Developed best Predictive model to predict the companies share value for the upcoming year and created visualization charts for action insights using Tableau Business modelling using spreadsheets - Location analysis.
08/2016 to 12/2016
, ,
01/2016 to 05/2016
, ,
  • Led a team of 5 members to leverage Airbnb San Francisco customer data set and analyzed trends in customer behavior and transformed the data using traditional BI technologies like Tableau to gain valuable insights.
  • Prepared data for analysis by extracting and cleaning data with SQL programming.
  • Wrote complex queries in Microsoft SQL server to discover the highest bookings and turnover rates and made recommendations on marketing strategies to increase the revenues.
06/2014 to 08/2015
Data Analyst Bickford Senior Living , ,
  • Imported the state loan data files, created functions to read and join the files and generated data visualizations of state wise statistics of the data using Python.
  • Conducted cluster analysis to classify customers based on different variables.
  • Interpreted the interest rates of different customers using SQL queries and Conducted regression to check the effectiveness of variables in regard with interest rates.
  • Successfully discovered trends and insights about the loan market through Excel and BI tools to make recommendations on customers Academic Projects California State University Business forecasting -Northern Napa Valley Winery.
Education and Training
Expected in May 2017
Master of Science: Information System and Decision Science Concentration- Business
California State University - Fullerton, CA
GPA:
Information System and Decision Science Concentration- Business 3.86
Expected in May 2014
Bachelor of Engineering: Electronics and communications
Manipal University - ,
GPA:
Electronics and communications 3.63
Skills
Academic, Big Data, BI, Business Intelligence, charts, Clustering, Data analysis, Data Mining, databases, Database, Data Warehousing, finance, Forecasting, IBM, Java, Macros, marketing strategies, marketing, market, Microsoft Access, Microsoft Excel, Excel, Modeling, MySQL, Object Oriented Programming, organizing, predict, presenting, Programming, Python, read, selling, sales, San, SAS, simulation, spreadsheets, SPSS, Microsoft SQL server, SQL, Statistical Analysis, Statistics, Tableau, tables, trend, VBA, wise

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Disclaimer

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • California State University
  • Manipal University

Job Titles Held:

  • Data Analyst

Degrees

  • Master of Science
  • Bachelor of Engineering

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: