Data Analyst

SIDDARTH SHESHAGIRI

(+*) 469-***-****

Email: ********.**********@*****.***

GitHub: https://github.com/Siddarthshe

EDUCATION

The University of Texas at Dallas May 2020 M.S in Business Analytics. (New Dean's Excellence Scholarship) GPA: 3.2/4

PES(People’s Education Society’s) Institute of technology May 2015 Bachelors in Electrical and Electronics Engineering. GPA: 7.66/10

TECHNICAL SKILLS

Programming: Python, R, MATLAB, SAS, C#, Javascript.

Tools: Tableau, PowerBI, MS Excel, MS Office, SAP BusinessObjects BI, SIEBEL CRM.

Databases: MS SQL, SQL-Server, MongoDB.

Deep Learning: Tensorflow, Keras.

Distributed Computing: Hadoop, Hive, Spark.

Cloud: AWS.

Web: Javascript,HTML, RestAPI, JSON, XML, Adobe Analytics, Google Analytics.

BI Tools: SSRS, SSIS, Visual Studio, Crystal Reports, SAP Lumira.

Presentation: MS PowerPoint, MS Office Suite.

Mathematical Skills: Linear Algebra, Time Series, regression models, splines, confidence intervals, principal component analysis and Dimensionality Reduction, bootstrapping, A/B testing.

Other: Data Structures and Algorithms, REST API, EDA, Data Analysis, Data Science, Machine learning, Data Visualization, Data warehousing, ETL.

BUSINESS EXPERIENCE

SPOTLIGHT ENERGY LLC, Houston, Texas, USA. August 2019 – September 2020

Programmer/Natural Gas Analyst.

Developed, maintained and improved the internal dashboard built in R to improve business intelligence efforts and process.

Built analytics database and processes of daily scheduled scripts being updated properly with daily settlements and other data.

Defined, designed, prototyped, and implemented complex exploratory analyses mathematically within the business context.

Developed demand forecasting models for transport and storage optimization.

Worked with the Director of Risk on predictive modelling projects as needed to provide effective company-wide risk management tools.

Performed model validation, testing and optimization.

Developed statistical, machine learning models using Python

Provided support across all departments, including trade floor, scheduling, accounting and actualization, such as sourcing data from pipeline EBB websites, assisting with automation of data into/from spreadsheets, creating spreadsheets, etc.

Automated daily P&L information and developed tools to improve the current process.

Maintained documentation on data sources, scoring and decisioning processes.

Developed a process to track the estimated P&L versus the final P&L by book and identify reasons for discrepancies; offer solutions to reduce the errors.

Analyzed statistical data and pipeline EBB information and build tools to acquire the data

Managed the daily maintenance requirements of ETRM system. Developed, maintained and pulled reports from MySQL database as needed.

Worked with other analysts on team to develop statistical models and optimization algorithms.

Worked with other analysts on team to update, maintain and improve the existing trading optimization programs built in R

Primary contact working with external IT vendor for most IT needs.

TATA CONSULTANCY SERVICES PVT LTD, Bangalore, India August 2015 – May2017 Assistant System Engineer

Analysis of business requirements of the KPIs (Key performance Indicators) and understand their representation of the product usage and user interaction real time.

Performed data extraction, manipulation, cleaning, analysis, modeling and data mining using Python.

Augmented company's machine learning and statistical modeling effort including building predictive models and generate data products to support customer segmentation, product recommendation and allocation planning, prototyping and experimenting ML algorithms and integrating into production for different business needs

Performed Data Cleaning, features scaling, features engineering using pandas and numpy packages in python and build models using deep learning frameworks.

Used classification techniques including Random Forest and Logistic Regression to quantify the likelihood of each user referring

Designed and implemented end-to-end systems for Data Analytics and Automation, integrating custom visualization tools using R, Tableau, Power BI.

T.I.M.E, Hubli, Karnataka, India. June 2017 – January2018

Data Analyst.

Created and analyzed quotes and bids according to Sales and customer needs, competitive information and company objectives.

Developed customer specific pricing structures based on multiple criteria including market, competition, product mix and margin guidelines.

Generated comprehensive analytical reports by running SQL Queries against current databases to conduct data analysis.

Experienced in developing business reports by writing complex SQL queries using views, volatile tables.

Designed, developed and maintained daily and monthly summary, trending and benchmark reports in Tableau Desktop

ACADEMIC PROJECT

Google G Store.

• Cleaned and Analyzed data of G store by taking data from Kaggle.

• Designed a database model to fit the G store data and its requirements.

• Run SQL queries to retrieve data required for fitting models and analysis.

Hotel Expedia Project.

Cleaned and performed exploratory analysis of the Kaggle competition dataset.

Implemented unsupervised and supervised machine learning models in R and Python.

Predicted whether a customer will or will not book the hotel based on his search and search

Contact this candidate