SUMMARY

• 12+ years of work experience in Econometric modeling, quantitative analysis, and production of insightful dashboards and reports using STATA, SQL, SPSS, and MS Excel.
• 9+ years of experience in R, STATA and Tableau for data cleansing, data manipulation, data analysis and interpretation.
• 5+ years of experience of cross - sectional and time series data analysis using python, power BI, MYSQL Workbench and advanced excel (power query, power pivot, power view, pivot table, Index-Match and LOOKUP functions).
• Applied MS SharePoint 2013 to create lists and libraries, store documents, collaborate and share deliverables among teams
• 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

Languages: SQL, Python, R, STATA, C#, SAS

Python Libraries: Pandas, NumPy, matplotlib, statsmodels, sklearn, seaborn libraries, TensorFlow, Keras

BI: Power BI (Power Query, power Pivot and Power View), Qlik Sense, Qlik View, Tableau, RapidMiner, DAX, Qualtrics, KPIs, Data Mining

Database: SQL Server 2014/2012/2008 (Queries, Views, Functions, Stored Procedures, Triggers), Relational/Multidimensional Databases, MS Access 2007/2003, Spreadsheets, flat files/CSV

Web: HTML, CSS, Java Script, JSON, SharePoint 2013 Web Services

Tools: Visual Studio 2012/2010, Jupyter Notebook, PyCharm, SQL Server Profiler, SQL Server Data Tools 2012, SQL Server Management Studio (SSMS), MYSQL Workbench, Microsoft SharePoint Developer, Notepad++, RStudio, Python Notepad++

Platforms: Office 365, MS Windows Server 2016/2012/2008/2003/200/ NT, MS Windows 10/8/7/Vista/XP/2000/98/95, MS-DOS

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, Sterling VA

Senior Data Analyst

Responsibilities:

• Implemented advanced analytics/modelling projects, including data ingestion, data management, data extraction, and predictive modeling using power BI, DAX, and python;
• 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; and 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

Environment: Python, R, Power BI, DAX, Jupyter Notebook, MYSQL Workbench, SQL Server Management Studio, JSON, C#

Confidential, Ethiopia

Sr. Research, Monitoring & Evaluation Specialist

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 DataAnalysis andData Pre-Processing on fee waiver service framework using R, STATA and MS Excel;
• Extracted patterns in the structured and unstructuredDatasets and displayed them with interactive charts using ggplot2 and ggiraph packages 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;

Environment: R, Power BI Desktop, DAX, MYSQL Workbench, SQL Server Management Studio, STATA, Excel, SPSS, SAS, Tableau, RStudio, ggplot, ggigraph

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) forBusinessProcess 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;

Environment: MS Access, R, MS Excel, BI, ETL, SQL, SQL Server 2005, MYSQL Workbench, RStudio, STATA, SPSS, SAS