SUMMARY

• 12+ years of work experience in data fetching, data cleansing, data mining, econometric modeling, data analysis and results interpretation using STATA, SQL, SPSS, and MS Excel.
• 9+ years of experience in analyzing and reporting data using R, python, MYSQL and advanced excel.
• 5+ years of experience in developing insightful and interactive dashboards, visualizations and reports using power BI, Tableau and Excel.
• Expert in linear algebra, differential and integral calculus, statistics and differential equations,
• Excellent knowledge of algorithms and data structures
• Loves to work positively and effectively in a team and challenging environment.
• Excellent understanding of business operations and analytics tools for effective data analysis.

TECHNICAL SKILLS

Programing and scripting Languages: SQL, Python, R, STATA, SAS, C#

Python & R Libraries: Pandas, NumPy, matplotlib, stats models, sklearn, seaborn libraries, TensorFlow, Keras, dplyr, ggplot2, plotly, sqldf

BI: Power BI, Tableau, Excel, Qlik Sense, RapidMiner

Database: RDBMS, SQL, MYSQL, PostgreSQL

Tools: Jupyter Notebook, PyCharm, PostgreSQL, SQL Server Management Studio (SSMS), MYSQL Workbench, Microsoft SharePoint Developer, Notepad++, RStudio, Python Notepad++

ML Models: Multiple Linear Regression, Logistic Regression, Clustering (KNN, Dendrogram, Heatmap), Random forest, Data Preprocessing, Train - Test splitting Algorithms, Deep learning (NN, CNN)

Time Series: Hodrick Prescot filter, ETS decomposition, Exponentially Weighted Moving Average (EWMA), Holt-Winters Method, ARIMA model, ADF test for stationarity

PROFESSIONAL EXPERIENCE

Confidential, VA

Data Analyst

Responsibilities:

• Implemented advanced analytics/modelling projects, including data ingestion, data management, data extraction, and predictive modeling using python, power BI and DAX;
• Extracted, analyzed and interpreted raw data on products, services and customers to transform into meaningful and actionable information using excel, SQL, power BI and python;
• Created visually impactful dashboards in Excel, power BI and Tableau; provide feedback to top management to interact with manufacturers and third-party insurers;
• Analyzed time series data to show trends of monthly Key Performance Indicator results and forecast performance improvement factors using advanced excel what if analysis and python;
• Performed data pre-processing including data cleansing, data exploration and trend forecasting via which eliminated outliers, inappropriate data values, blank and missed values and invalid entries; detected correlation, regression and association of variables and identified patterns in data respectively using python;
• Collaborated with team on data analytics activities using SharePoint 2013 platform;
• Performed multivariate analysis, predictive analysis and cluster analysis using advanced statistical techniques using python, K-means clustering, power BI and advanced excel;
• Interpreted and translated analytic output into insightful dashboards and reports using excel, power BI and python (matplotlib and seaborn);
• Developed complex DAX queries on tabular model for Power BI and Excel Pivot consumption

Confidential, Ethiopia

Sr. Research & Data Analyst

Responsibilities:

• Conducted exploratory research and identified factors to consider during User Fee Revision and Setting using SPSS, Excel and Tableau;
• Explored predictors of provider - seeker behaviors in Private wing wards of Hospitals using R, advanced excel and STATA;
• Performed Exploratory Data Analysis and Data Pre-Processing on fee waiver service framework using R, STATA and MS Excel;
• Extracted patterns in the structured and unstructured Data sets and displayed them with interactive charts using ggplot2 package in R.
• Produced quarterly and yearly performance reports of implementation status of Health Care Financing Reform (HCFR) using SPSS, Excel and Tableau;
• Formulated Monitoring and Evaluation tools based on project goals to help monitor and evaluate accomplishments, track implementation status of performing units and identify success factors by using excel pivot tables, index-match functions, power BI and python;
• Prepared data collection tools for several action researches, rapid assessments, an HCF database and earmarked researches using excel, STATA, power BI and python;
• Created interactive dashboards and reports using Power BI Desktop and MS Excel and presented research outcomes for stakeholders;
• Designed SPSS, STATA and excel data entry views and encoded data;
• Utilized SPSS, MS excel and STATA for data cleaning, data presentation, data analysis and full-blown report writing;
• Used STATA to solve logistic regression, cobb Douglas production function and the CES econometric models in research analysis and interpretation HFG project data;
• Disseminated research results to various stakeholders both in print and via power point presentations at various events;
• Applied MS office products like MS publisher, MS excel and MS word to produce/customize prototype Health Service Delivery and Administration (HSDA) proclamation and regulation;
• Trained Facility Governance Bodies (FGBs) of health facilities on health financing and governance;

Confidential, Ethiopia

Coordinator of Research and Quality Assessment

Responsibilities:

• Prepared Theory of Change (TOC) diagrams, Fish Bone (FBD) diagrams, Sequence Diagrams (SD), Data Flow Diagrams (DFD), and Flow Charts (FC) for Business Process Modeling;
• Developed complex SQL queries in Microsoft SQL Server 2012 database;
• Produced Star Schema/Snowflake schema, FACT & Dimensions tables as well as Physical & logical data modeling;
• Independently wrote complex SQL queries in SQL server management studio and MYSQL workbench;
• Produced an article using SPSS and excel advanced formulae on the what, why and how of quality of higher education;
• Taught a wide range of courses in Mathematics, Economics and Statistics;
• Worked on Data Analysis, Data Validation and Data Cleansing on determinants of demand for ODL using SPSS, excel and STATA;