Reporting Analyst Climate Change

Akshay Ahuja

Tableau Certified Desktop Specialist

SUMMARY:

Data science graduate student with 2+ years experience working as a data analyst with expertise in building data models for optimizing product performance. My education background and work experience align me perfectly for analytics roles which requires intensive data analytics, visualization and modeling EDUCATION:

Stevens Institute of Technology, Hoboken, NJ May 21 Master of Science in Data Science (GPA: 3.72/4.00) Student clubs: Graduate Student Council, Chess Club at Stevens, Peer Mentors Program NMIMS University, Mumbai, India May 18

Bachelor of Technology in Mechatronics Engineering SKILLS:

Languages: Python (Scikit-learn, Pandas, Numpy, Matplotlib), SQL, R, Matlab, SAS Databases: Oracle, MySQL, Microsoft Access, Postgres, Snowflake Tools and Frameworks: Tableau, PowerBI, Alteryx, Microsoft Excel (Vlookup, Pivot tables, Macros, VBA), Google Analytics, SAP Cloud Technologies: AWS (EC2, Redshift, EMR, S3), Azure Machine Learning: EDA, Classification, Regression, Natural Language processing Coursework: Data Warehousing, Business Intelligence, Marketing analytics, Data analytics, Big Data Technologies, Statistics, Relational Databases

WORK EXPERIENCE:

RA Solutions, New Brunswick, NJ March 21 - Present Data and Reporting Analyst (Freelancer)

• Created local database by extracting data from websites using Python and SQL reducing data reporting time by around 25%

• Designed dashboards on PowerBI for marketing team to evaluate marketing expenditure and orders

• Building Erasure reports on Microsoft Access for client to ensure data privacy Stevens Institute of Technology, Hoboken, NJ Feb 21 - Present Teaching Assistant (Web Mining)

• Organized weekly office hours to assist a class of 50 students with lab work and homework assignments

• Graded assessments, projects and aided professor for other administrative tasks Anya Exim Enterprises Private Limited, New Delhi, India May 18 - Sept 19 Data Analyst

• Conducted analysis using SQL and Excel to restructure production schedule based on product demand which resulted in 12% increment of yearly sales

• Communicated with clients to understand business needs and translated business needs into report on Microsoft excel

• Designed visual dashboards in Tableau for marketing department to help them analyze sales data Educhimp, New Delhi, India May 17 - Aug 17

Data analyst

• Developed ETL packages to transfer data from databases to data warehouse for further analyses and forming KPI’s

• Analyzed data collected from web engagement and boosted web traffic by 20%

• Combined computer science and statistics techniques to build a quantification model for forecasting future web traffic

• Utilized Analytics tools (Google Analytics) to inspect data collected during web engagement and reporting web sales to the marketing team which resulted in optimized marketing strategy and boosting web traffic by 20% ACADEMIC PROJECTS:

Indeed website Text Mining

• Achieved a prediction rate of 87% for a classification model that predicts Job titles based on selected job descriptions

• Created web crawler using Selenium and Beautiful soup in Python and scraped 15,000 scripts from indeed website database Climate change and its impact on health

• Performed data blending using Python and Tableau on disparate datasets

• Created dashboard using Tableau for understanding the impact of climate change and pollution on human health

• Led a team of 5 to forecast future temperature values based on the pollution levels using a clustering machine learning model Netflix Movie Recommendation System

• Developed a collaborative filtering based recommendation system in Python for 10 Million users and achieved 92% prediction accuracy

• Applied advanced NLP and cosine similarity to suggest recommendations to the users Foreign Direct Investments pattern

• Implemented statistical methods to find relations between different financial variables using R-Programming

• Developed interactive visualizations and KPI’s in PowerBI to find the investments patterns of FDI Email - *******@*******.***

LinkedIn - linkedin.com/in/akshayahuja13

Github - https://github.com/akshayahuja13

Hoboken, NJ 551-***-****

Contact this candidate