Ahamed Shamly Anvar Mackey Email & Phone Number

Colorado, United States

Completed over 50 unique projects for clients, from a range of different industries, looking for data based solutions. Below are a few tools and topics that I employed to successfully solve these problems:Tools► R► SPSS► SAS► Python► SQL► Tableau► Microsoft Power Bi► Microsoft ExcelTopics► Data Visualization► Predictive Analytics► Descriptive Statistics► Probability► Statistical tests► Regression analysis► Analysis of Variance► Time Series Analysis► K-Nearest Neighbors ► Decision Trees ► Random Forests► K-Means Clustering► Dimensionality Reduction► Statistical Modeling ► Research summaries

United States

Assisted professors to conduct research, while aiming to have publishable research papers in one of the FT 50 journals. Most of the research conducted was based on predictive analytics and natural language processing.

Prepared over 400+ students to critically think and solve business problems using Microsoft Excel. The students were required to complete the MO-200: Microsoft Excel (Excel and Excel 2019) certification (an exam prepared by Microsoft). More than 92% of my students successfully were Excel certified, by the time they completed my class.

Denton, Texas

Was assigned tutor for 6 different subjects for undergraduate students.

United States

Utilized Microsoft Power Bi, R, Shell Scripting, SQL, and JSON to accomplish the results below: ● Enabled the company to save more than a million dollars by creating a tool that identifies opportunities to save, which is now used by the executives of the company ● Constructed a report that informs the percentage completed for a specific task, which increased the completion of task from an average of 10% to 80% ● Built a streaming data set using PowerShell which enabled Power Bi to receive live data and show the performance of the plant at any given time ● Experimented with multivariable regression analysis in R to find significant variables that are not considered as strongly in the cheese making process

United States

Created a model that predicts the price of Resin for a year with an accuracy rate of more than 98.5%. The model utilized multiple concepts such as autocorrelation, autoregressive integrated moving averages, and lags. The model was constructed with the use of the R statistical programming language and 3 different test sets were used to verify the model accuracy. The mean absolute percent error (MAPE) and the mean absolute scaled error (MASE) were used to compare performance between different models that were constructed and tested.

Vermillion, South Dakota

The position includes the employee to be responsible and knowledgeable of:- Data collection and transformation of Students and Providers- Analyzing the collected data using R, Tableau, Python or SAS- Creating and maintaining a database- Designing a User Interface through which the database can be accessed- Multiple complex dynamic SQL query designs- Proficiency in Visual Basic Application- Audio and Video editingThe dynamic dashboard tool that I created for anyone to use can be found published by the University of South Dakota in the URL below:https://www.usd.edu/gc/study-abroad/study-abroad-data

United Kingdom

Skills acquired and polished:● Java – Created a library management system● Android application – Developed an automated office car park management system● Firebase – Utilized service to sync live data from car park system to the firebase database● WordPress – Constructed two responsive websites

Vermillion, Sd

Event Programming and Clerical

Sri Lanka

Skills acquired and polished:● Shell Scripting – Worked on UNIX systems and was required to create various scripts● Spring MVC – Integrated Spring MVC to JSP files● Tomcat – Created and launched servers to deploy JSP files● Bootstrap(HTML) – Used as the front-end framework for projects● Databases – Linked databases (Mongo DB and MySQL) to JSP

Master Of Science - Ms, Multi/Interdisciplinary Studies

The Master of Science in Interdisciplinary Studies included components from disciplines such as Computer Science, Decision Science.

Master Of Science - Ms, Business Analytics, 4.0

Activities and Societies: Beta Gamma Sigma: International Business Honor Society, Golden Key International Honor Society

Bachelor'S Degree, Computer Science

Activities and Societies: Association for Computing and Machinery (ACM), Network and Security Club, Code Club