MIKAIL KAYA

mkaya@kent.edu | analyticsautomation.net

Data Scientist  | Data Engineer | Alteryx and Tableau Developer | Automation Expert

​

TECHNICAL SKILLS

• Programming Languages: Python, SQL, VBA, Spark

• Data Tools: Alteryx Designer (Certified), Alteryx Server(Certified), Tableau (Certified), Tableau Server, Power BI, Salesforce Certified CRM Analytics and Einstein Discovery Consultant, Databricks, SPSS, Excel, Access, Rapid Miner, SAP Business Objects

• Databases: ORACLE SQL Server, Snowflake, AWS

• Libraries: NumPy, Pandas, Scikit-learn

• Predictive Modeling: Regression (Linear/Logistic), Classification, Clustering, Decision Trees, Random Forest, SVM, KNN, ARIMA, ETS, SARIMAX, PROPHET, LSTM

• Environments: Google Colab, Jupyter Notebook, Visual Studio Code, Sublime

• Core Skills: Machine Learning, Data Analytics, Data Mining, Statistical Methods, Time Series Forecasting, ETL Processes, Data Visualization, Business Intelligence

 

PROFESSIONAL EXPERIENCE

Senior Principal Data Analytics Consultant -| Egen.ai, VA | Oct 2022 to Aug 2024
(UnitedHealthcare Community & State | UHG · Contract)

• Utilized Alteryx, Tableau, and Einstein Discovery for data preparation, visualization, and predictive analysis.

• Extracted and processed data from ORACLE SQL Server and Snowflake.

• Led projects on SDOH, Housing & Homelessness, Health Program Evaluations, Gross Margin, and HEDIS Compliance.

• Developed data models and algorithms for complex healthcare datasets.

• Created interactive dashboards and reports for stakeholders.

• Conducted data quality assessments and implemented cleaning strategies.

• Maintained Tableau Server, ensuring timely data refreshes.

• Performed ad hoc analysis using Medicaid datasets.

• Provided accurate data for audits and supported encounter data claims projects.

• Documented automated reporting processes and kept records up to date.

• Leveraged data to inform decision-making and optimize healthcare outcomes.

 

Data Analyst: Supply Chain | Logistics, Tractor Supply Company, Nashville, TN, Oct 2020 to Oct 2022

• In my past experiences, I have applied advanced techniques such as Regression, ARIMA, ETS, SARIMAX, PROPHET, and LSTM for forecasting and data analysis.

• In my work, I implemented Alteryx and Python libraries, including TensorFlow, Keras, NumPy, Pandas, and Skitlearn.

• Developed automated KPI dashboards and scheduled workflows, including Distribution Centers Dashboard, International Transload Center Dashboard, and Shipment from Store Dashboard in my past experiences.

• I implemented Alteryx for data preparation and connected it to databases, as well as designed and developed ETL workflows and datasets based on my past experiences.

• I developed Tableau visualizations and reports and designed and deployed high-level, rich dashboards from my past experiences.

• I have queried data from Snowflake, SAP, and Business Objects using SQL in my past experiences.

• Demonstrated ability to work remotely and collaborate effectively in a professional manner in my past experiences.

 

Data Analyst-- Supply Chain, Signet Jewelers, Akron, OH, Dec 2019 to Jul 2020

• I have implemented automated KPI Dashboard using Alteryx and Tableau, resulting in a 20% reduction in staff hours and zero errors.

• Utilized quantitative methods to analyze and improve supply chain processes.

• Developed techniques for data collection and analysis to identify areas of improvement.

• Led and executed supply chain optimization projects.

• Advised executives on data-driven decision-making.

 

Data Analyst Consultant-- Supply Chain, ASC Industries, North Canton, OH, Mar 2019–Aug 2019

• I have implemented an automated and interactive Suppliers’ Scorecard, which has reduced staff hours by 40%.

• I have developed interactive KPI Dashboards for spending, transportation, and suppliers’ performance.

• Extracted data from ORACLE Database (Oracle eBusiness Suite) and performed analysis.

• Collected and analyzed sourcing data, planned inventory, and calculated quotes.

 

Strategic Sourcing Analyst, Perfect Suppliers, Stow, OH, Feb 2017 – Feb 2019

• Implemented supply chain optimization initiatives resulting in significant cost savings

• Managed vendor relationships and sourcing processes

• Utilized data analysis to optimize inventory and negotiate with suppliers

• Developed and maintained procurement standards and tracked performance KPIs

• Recommended improvements to boost performance and reduce costs.

 

Principal Researcher, TNPA University, Turkey, Aug 2013– Jan 2016

• Secured funding for two grant projects from the European Union

• Conducted workforce analysis to improve organizational effectiveness and job satisfaction

• Collected, analyzed, and reported on research findings.

 

Research Assistant, Spalding University, Louisville, KY, Aug 2009–Jun 2013

• Assisted in research project(s) execution through data analysis and interpretation.

• Conducted research on organizational justice, employee assessment, performance, and customer perception.

• Synthesized and analyzed data to support research objectives and conclusions.

 

Team Lead of Recruitment - HR Analyst, United Nations, Liberia, Apr 2008–Apr 2009

• Expertise in creating and delivering specialized ad-hoc analyses/reports to address specific areas of HR expertise, following UN standards.

• Managed and supervised a diverse team, providing guidance and training to enhance performance.

• Proactively identified and rectified errors and inefficiencies in processes and received official recognition for outstanding performance in the form of the UN Peacekeeping Medal.

 

PEER-REVIEWED PUBLICATIONS

• “The Impact of Ethical Leadership on Employees’ Code of Silence and Integrity” International Journal of Public Administration, 37:9, 529-541, DOI: 10.1080/01900692.2013.865649

  • Method: Structural equation modeling (SEM), multivariate analysis technique

  • Tool: AMOS

• Doctorate Dissertation: “The Effects of Perceived Organizational Justice on Employee Job Satisfaction, Job Involvement, and Job Stress” May 2013, Spalding University, Louisville, KY

  • Method: Multiple regression analysis

  • Tool: SPSS

​

TEACHING EXPERIENCE

Teaching Experience, TNPA University, Turkey

• IT Technologies

• Customer Service

 

EDUCATION

Master of Science in Digital Science, Concentration: Data Science

• Kent State University, Kent, OH – 2020

PhD in Organizational Leadership

• Spalding University, Louisville, KY – 2013