Data Analyst / Scientist
CurrentInvestigated factors contributing to high rate of attrition from 5-year HR dataset to identify trends to and proposed solutions to improve employee retention• Utilized Excel Power Query to combine and transform HR data in spreadsheets and calculate aggregates• Created charts representative of the data (length of service relative to age, employee type, pay type and ethnicity) using PivotTable with Excel• Planned a designed dashboard with filters for management reviewAnalyzed sales data for a departmental store to track performance by location, forecast future sales & profit and identify high value customers• Imported and transformed raw data and built relational model with PowerBI• Calculated data aggregates and KPIs (sales, revenue, profit and returns) using Data Analysis Expression (DAX)• Designed an interactive dashboard to visualize data trendsBuilt machine learning models for a local retail store for• Sale optimization and determining promotional offers using Python code and association rule mining method• Timeseries forecasting to predict sales, profit and to guide decisions on expansion
