Post Job Free

Resume

Sign in

Data Analyst

Location:
Tampa, FL
Posted:
March 18, 2021

Contact this candidate

Resume:

SUMMARY

Sagar Prakash Hubballi

Tampa, FL-***** adk0mp@r.postjobfree.com 813-***-**** Linkedln

• Certified Tableau Desktop Specialist with over 18 months of professional experience focused on Data analytics, multi- dimensional reporting and data visualization

• Extensive hands-on experience in data mining, data warehousing, data visualization, documenting functional and business requirements and designing process flow diagrams with client facing roles necessary to uncover enterprise insights and drive results

• Proficient in data cleansing, exploratory analysis, statistical tools, predictive data modeling, business intelligence, demand planning, logistics and supply chain operation

EDUCATION

• Master of Science in Industrial Management and Systems Engineering Aug 2019 - May 2021 University of South Florida –Tampa, Florida

Courses – Statistical Design Models, Engineering Analytics – I, Engineering the Supply Chain, Engineering Analytics – II, Optimization in Operations Research, Probabilistic Operations Research, Cyber Analytics, Creativity in Technology, Human Relations

• Bachelor of Engineering (BE) in Mechanical Engineering Aug 2014 – July 2018 Visvesvaraya Technological University – Karnataka, India WORK EXPERIENCE

Data Analyst: Sai Service India July 2018 –June 2019

• Performed data extraction using Advanced SQL from multiple sources such as Microsoft SQL Server, Amazon S3 and flat files

• Developed dashboards using Tableau & Excel to showcase the success metric reports for sales analysis

• Led cross-team co-ordinations and document the business requirements to ensure timely completion of the projects

• Developed monthly budget, financial and ad-hoc reports and interpret result conveyed to stake holders

• Construct, track and analyze KPI reports to identify and reach the company’s targets Data Analyst Intern: Sai Service India Jan 2018 – July 2018

• Analyzed customer behavior to increase subscription revenues by 6% & acquisition rate by 4% using personalized segmented offers

• Built machine learning models to predict customer churn using ensemble methods in Python and achieved a true positive rate

(recall) of 86% for customer retention and acquisition campaigns

• Automated data pipelines using ETL tools such as Microsoft SSIS (SQL Server Integration Services)

• Developed Key Performance Indicators and scorecards to monitor product sales and operations of vendors and fulfillment centers ACADEMIC PROJECTS Aug 2018 – Dec 2020

• ASHRAE-Great Energy Predictor 3 (R Tableau): Performed data cleaning, mining, visualization and regression analysis of over 20 million data points from 2,380 energy meters collected for 16 different sources and computed the prediction of about 41 million private and public data points

• Finance Classification: (Logistic Regression Random Forest Support Vector Classifier)- Performed Descriptive Analysis to understand the skewness and correlativity between predictors, further did dimensionality reduction using PCA and finally logistic regression, support vector classifier and random forest models were fitted and analyzed on the basis of ROC and AUC

• Supply Chain Management (MS-Excel):

a. Designing the production network at Cool Wipes- Computation of transportation costs, setup costs, operational costs considering multiple scenarios and deciding on the most optimized model meeting the demands using MS-Excel tool b. Sourcing Decision for a 2-year period at Forever Young- Computation of expected Profits and Net Present Value of expected profits for an uncertain condition of demand and fluctuating currency using decision trees. Additionally, finding out various business opportunities were figured out after considering flow of production from different suppliers

• Big Data Technologies: Black Friday Sales Predictions (HDFS Pyspark)- Performed data cleaning, EDA, encoding and regression analysis on a dataset to classify transqyactions made in retail stores during Black Friday sales using Cloudera platform

• Prediction of CVSS (Cyber Analytics Python): Performed Feature Extraction, Data visualization, Data Preprocessing and built multiple linear models namely Linear Regression, Random Forest Regression, Decision Tree regression, Ridge Regression, XGboost regression and achieved 0.136 MSE on the unseen dataset using Random Forest model

• Lean Six Sigma: Improved picking time of products by 54% (from 1min 34secs to 51secs) in the pantry at USF Hub dining using Lean methods like value stream mapping. Conducted process mapping and root cause analysis

• Warehouse Operations Management: (MS-Excel)- Applied operations and warehouse management techniques to reduce investments in operations and growth. Evaluated the costs involved in operating multiple warehouses as compared to current single warehouse. Proposed the optimum supply chain network and new regulations to control overstocking

TECHNICAL SKILLS

Programming SQL, Python, R, C, MS-Excel VBA

Tools/Cloud Anaconda (Jupyter, Spyder), SAS Enterprise Miner, RStudio, Visual Studio, MS Excel, Power Point, R-Shiny, LaTex

Databases Oracle, MS SQL Server, PostgreSQL, HBase Visualization/BI Tableau, Python (Seaborn, bokeh, plotly, matplotlib), Power BI, MS-Excel (V-lookup, Pivot) Machine Learning Linear and Logistic Regression, Classification, Clustering, Neural Networks, NLP Statistical Techniques ANOVA, Hypothesis Testing, ANOVA, Advanced Excel (pivot table, Macros and VBA) INTERNATIONAL PAPER PUBLICATIONS

• ‘A Review on Introduction, Classification and Application of Smart Materials ’ with ISBN:978-93- 97793-46-0 at 2nd International Conference on Emerging Trends in Science, Engineering & Technology

• ‘Development and Fabrication of Portable Foldable Hybrid Crutch’ with (ISSN: 2454-5031) at International Journal of Latest Research in Engineering & Technology



Contact this candidate