Hello! I'm Akash
I'm currently working as a Senior Business Intelligence Engineer @ Amazon in the Logistics Dept.
I manage Driver analytics pertaining to Warehouse operations. In addition to this, I also collaborate with Finance and Product Teams for any data requests and other custom projects.
Prior to this, I pursued Masters in Business Analytics from the University of Texas at Dallas with a GPA of 3.8 on a 4 point scale. I have a strong acumen for leadership and analytical problems. I love exploring the business side of every technical project I undertake. I love automating tasks that can help improve one's productivity. I am a keen learner, open to Full-Time opportunities in the Data/Business Analytics domain.
Akash Gupta
( Data Storyteller)
Open to Full-TimeRoles
Masters in Business Analytics Graduate
|SQL Certified | Python | Looker Dev |
| Tableau Desktop Specialist |
IBM Certified Data Science Professional
Phone: 214-206-5080 | Email: guptakash96@gmail.com |
Location: Dallas,Texas
Traveling is my passion. I’ve been to 5 countries so far, and I’m not done yet! I love learning and adapting to new cultures, finding commonalities between people everywhere, and just trying a bunch of new foods. There’s a real magic to communication in that so much of it is nonverbal, and I’ve learned to pick up on body language and read the room, even if I can’t always read the menu.
EXPERIENCE
20 MAY 2019-AUG 16 2019
Data Analyst Intern
JUNE 2017-MARCH 2018
Data Analyst Intern
Singhal Ashok K. Associates, India
-
Analyzed last subscription data using Tableau in order to increase customer retention.
-
Derived meaningful operational metrics to help drive performance and identified key areas of redundant spending and saved $17000 per year.
-
Automated tasks such as balance sheet creation using Java which resulted in reducing the processing time by 19% and increasing 7% efficiency.
2017-2018
Software Developer Intern
Defense Research and Development Organization, India
-
Collaborated with team to research density based clustering algorithms- DB Scan and Optics to determine applicability in forecasting weather.
-
Applied comparison on parameters such as complexity, run time and implementation ease
-
Implemented approaches namely Density Based Spatial Clustering Algorithm and Optics Algorithm and used Dendogram to plot the clusters for visualization of results and evaluated their efficiencies.
EDUCATION
Aug 2018- May 2020
Master's Degree
University Of Texas at Dallas,USA
Masters in Business Analytics
March 2014-July 2018
Bachelor's Degree
Amity School Of Engineering and Technology,Noida, INDIA
Bachelor's in Technology Computer Science
2002-2014
High School
Mount Carmel School, Dwarka, India
25 APRIL 2022 - Present
Senior Business Intelligence Engineer
Amazon, Jersey City NJ
-
Coming Soon
Scalable Press, Coppell
-
• Identified and resolved operational data issues minimizing impact on stakeholder’s decision making.
• Onboarded various new incoming data analysts and maintained service level of 100% for BI requests/tickets
• Created and improved Gross Margin reports for different brands within the co.
• Maintained Print, Product & Customer Service ratings to co.’s standards & tackling issues via sentiment analysis.
• Created Live dashboards for third-party vendor order volume monitoring using Looker using optimization techniques like persistent derived tables, aggregate tables, incremental persistent derived tables for faster data processing.s.
1 JUNE 2021 - 22 APRIL 2022
Senior Data Analyst
1 June 2020 - 31 May 2021
Data Analyst
Scalable Press, Coppell
-
Maintained & managed warehouse ops PostgreSQL database & created master tables for 8% faster & efficient queries.
-
Created highly analytical reports for leadership based on different use cases and potential in the data.
-
Presented reports to leadership based on Customer Reviews using sentiment analysis and Topic Modelling, identified 3 areas of improvement based on insights from the data.
-
Built Schema for DTG(Direct to Garment) Printer Analysis using PostgreSQL Database and maintained the Database.
-
Worked as a Project lead to collect & analyze data from DTG printers to make meaningful decisions in areas like operations, maintenance & ink consumption and managed a team of 5.
-
Built a UI to input data and maintained a PostgreSQL Database for organization’s process auditing purposes.
-
Built meaningful dashboards based on leadership’s needs and worked on operations KPI’s.
19 AUG 2019 - 13 DEC 2019
Research Analyst Intern
Parks Associates, Addison
-
Statistically analyzed consumer survey results using significance testing and contributed to published research reports on findings, performed chi-square tests, Turf analysis and removed outliers as part of data cleaning.
-
Ensured and maintained the projected service level of 95% or better in the form of the estimated time of arrival of Research and delivering comprehensive analysis to the client.
-
Statistically analyzed US Broadband Household datasets based on custom research in Q Research and SPSS, interpreted consumer data, assessed logical findings increasing client-side efficiency by 14 %.
-
Produced publication-quality research and illustrated findings using MS Excel, Tableau and PowerPoint.
-
Tested complex questionnaires, managed multiple short-term and long-term projects simultaneously.
20 MAY 2019-AUG 16 2019
Data Analyst Intern
Apilation, Dallas
-
Created visually impactful dashboards in Edge and Tableau for data reporting to Client side .
-
Extracted, Enriched, Feature Engineered, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information increasing data quality by 30%.
-
Derived meaningful operational metrics for our clients using R, Python, Java-Script Notation (JSON), MongoDB
-
Implemented pipeline creation using huge collections on edge and JSonar and further visualized data for client understanding using NoSQL.
-
Implemented predictive algorithms to recommend products to customers increasing client side sales by 12%.
JUNE 2017-MARCH 2018
Data Analyst Intern
Singhal Ashok K. Associates, India
-
Analyzed last subscription data using Tableau in order to increase customer retention.
-
Derived meaningful operational metrics to help drive performance and identified key areas of redundant spending and saved $17000 per year.
-
Automated tasks such as balance sheet creation using Java which resulted in reducing the processing time by 19% and increasing 7% efficiency.
2017-2018
Software Developer Intern
Defense Research and Development Organization, India
-
Collaborated with team to research density based clustering algorithms- DB Scan and Optics to determine applicability in forecasting weather.
-
Applied comparison on parameters such as complexity, run time and implementation ease
-
Implemented approaches namely Density Based Spatial Clustering Algorithm and Optics Algorithm and used Dendogram to plot the clusters for visualization of results and evaluated their efficiencies.
EDUCATION
MY ORGANIZATION
I am the Committee Chair of Intelligence Analytics Society and also the SOC Head of Intelligence Analytics Society at The University Of Texas At Dallas. I have been a very active part of this organization as it has helped me build lucrative skills which I will always cherish.
SKILLS
Python
SAS Basics
Q Research
Microsoft ExCel - Advanced
Advanced SQL
R STUDIO
SPSS,MINITAB,STATA
Tableau
SQL FOR DATA SCIENCE- University Of California Davis:
This course taught me Data Manipulation,Data Retrieval, Subqueries, Joins, common operators and how to combine the data. I used case statements and concepts like data governance and profiling. This course helped me interpret the structure, meaning, and relationships in source data and use SQL as a professional to shape your data for targeted analysis purposes.
Working on Yelp reviews dataset as a project also helped me analyze the data with an analysts eye and implement the various workflows going on in the process. Playing the role of a real-world data scientist and working on the project helped me enhance my skills and understand the data just like a data scientist would.
Fundamentals of Visualization with Tableau- University Of California Davis:
This course has taught me the skill of storytelling using Tableau. Creating interactive dashboards and sheets, importing data from various sources according to the needs at hand, using the right visualization for particular scenarios and presenting what is required keeping your audience in mind.
I have learned how to assess the What How and Who of storytelling.
IBM Data Science Professional- IBM
This course is a collection of 9 Courses:
COURSE 1:
What is Data Science?
COURSE 2:
Open Source tools for Data Science
COURSE 3:
Data Science Methodology
COURSE 4:
Python for Data Science
COURSE 5:
Databases and SQL for Data Science
COURSE 6:
Data Analysis with Python
COURSE 7:
Data Visualization with Python
COURSE 8:
Machine Learning with Python
COURSE 9:
Applied Data Science Capstone
