AKSHAY APPANI
Data Analyst
Parsippany,NJ
Summary
Data analyst with proficiency in SQL, Python, and statistical analysis. competent in database management and data visualization with programs
like Tableau and Power BI. Outstanding communicator with experience in explaining complicated research to a range of stakeholders. In search
of a dynamic, growth-oriented firm where I can contribute my analytical talents and data-driven insights.
Overview
6
6
years of professional experience
5
5
years of post-secondary education
Work History
Data Analyst
T-Mobile
Parsippany, New Jersey
09.2022 - Current
- Attained a detailed analysis of Network transactional and customer sales data and developed clustering models to identify similar outlets
- Created interactive Tableau dashboards to compare outlet performances and evaluated the impact of introducing an online order facility
- These efforts resulted in a market share increase of 3% for the company
- Utilized Time Series forecasting techniques to predict revenue for the upcoming months and identified days with higher order volumes using ARIMA, contributing to a 1.5% faster growth rate for the company
- Conducted root cause analysis of production defects, reported by business stakeholders
- Developed and executed strategic plans with the team to address these issues, significantly enhancing user experience and system reliability
- Manipulating, cleansing & processing data using Microsoft Excel and Power Query
- Managing huge data through Microsoft Excel
- Supporting Data Scientists/Managers/TLs in the documentation of task-wise issues for references using Microsoft Power BI and Excel
- Creation of ETL packages and moving data from source systems to Data marts, Designing ELT Workflows
- Created various stored procedures to load the data from multiple sources to a single destination
- Created Drill-down, Sub reports, Linked Reports, Snapshot Reports, Drill Through reports
- Power BI Admin Roles, Creating VMs, Failover VM, Gateway cluster setup, Creating Workspaces, Tenant Settings, Scheduling refresh, subscription for daily alerts, etc.
- Proven ability to learn quickly and adapt to new situations.
Data Engineer
Bharat Petroleum Corporation Ltd
Bangaluru, India
06.2019 - 02.2022
- Assisted Engineering and Civil dept (Telangana) in performing detailed analysis on the roads/pathway data, designed ETL processes, and automated scripts in Python to extract, transform, and load data from multiple data sources to Databricks, saving ~40% time and minimizing human intervention
- Supported data projects of 2 teams through various phases of the Data Science Life Cycle
- Constructed Naive Bayes, Random Forest, and SVM models and automated the classification of monthly reports
- Integrity, boosting the accuracy by 43%, established KPI, and structured large datasets to find usable information
- A rigorous EDA was performed to analyze the data, extract valuable insights, and evaluate the model's performance.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Developed custom algorithms to optimize data mining, increasing the effectiveness of analytical insights.
- Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
Data Analyst Intern
Systamatrix infotech private limited
Bengaluru, india
03.2018 - 05.2019
- Identified trends and patterns in complex datasets through exploratory data analysis, leading to actionable insights.
- Assisted management in making informed decisions by presenting clear and concise reports detailing analytical findings.
- Proficiently communicate discovered data and insights to both technical and non-technical stakeholders.
- Employ PowerPoint to articulate analytical outcomes clearly and accessibly in team meetings or presentations.
- Leverage pivot tables in Microsoft Excel for distilling actionable insights from extensive datasets.
- Monitored and controlled data upload, checking for successful data import and quality.
Education
Master of Science - Business Analytics
Trine University
Angola, IN Mar.2022 - Dec.2023
SR university - Computer Science
Jawaharlal Nehru Institute of Technology
Jun.2015 - May.2018
Skills
- Languages: Python (NumPy, Pandas, Matplotlib, Seaborn, Scikit-Learn, Flask, Django, TensorFlow), R, SQL, C, HTML
- Tools & Databases: Tableau, Stream lit, Git, Power BI, MS Excel, Jupyter Notebook, Spark, MySQL, PostgreSQL, MongoDB
- Machine Learning Theory: Linear & Logistic Regression, Decision Trees, Random Forest, KNN, Clustering, XG Boost, CNN’s
- Data Science Skills: Data Preprocessing, Data Transformation, Data Modelling, Data Analysis, Data Visualization, NLP
- Cloud Services: AWS Glue, S3, Redshift, Athena, Sage maker, IAM, Databricks, AWS EC2, Redshift, Lambda
Additional Information
- Worked on the NLP problem of Language Identification having a dataset consisting of 6,872,356 sentences and 328 unique languages to identify. Performed preprocessing on the large dataset of sentences and converted them to character-n grams to reduce the feature space and provide inputs to the Neural Networks as well as the models.
- Attempted to solve this NLP problem using a variety of methods including Naïve Bayes (giving accuracy-83.6%), Neural networks (accuracy-97.21%), and the BERT Multilingual base model(accuracy-99.2%).
- AI-Guest Profiling Proposal in New Jersey: -
- A processed large and complex dataset consisting of 14 physical attributes of Hotel Guests. Employed Logistics Regression algorithm to create a classification model for predicting the customer information and last review's attributes.
- Applied Multiple Linear Regression, Random Forest Regression, and Decision Tree Regression and compared these models based on accuracy, AIC values, and significant variables and even built a Stream Lit application for the Predictor.
- Develop a machine learning model that predicts whether a new user's initial details on website will be fraudulent or not. To prevent data leaking during hyper-parameter adjustment, use ensemble approaches combined with several sampling techniques in a pipeline.
Timeline
Data Analyst
T-Mobile
09.2022 - Current
Master of Science - Business Analytics
Trine University
Mar.2022 - Dec.2023
Data Engineer
Bharat Petroleum Corporation Ltd
06.2019 - 02.2022
Data Analyst Intern
Systamatrix infotech private limited
03.2018 - 05.2019
SR university - Computer Science
Jawaharlal Nehru Institute of Technology
Jun.2015 - May.2018