Post Job Free

Resume

Sign in

Data Analyst Entry

Location:
Indianapolis, IN, 46204
Posted:
November 19, 2022

Contact this candidate

Resume:

*

DAVID KATUTA NDOLO

401-***-**** adtl0d@r.postjobfree.com LinkedIn: david.katuta

ECONOMICS AND STATISTICAL RESEARCH

• Practicing economics with experience in both quantitative and qualitative aspects of economics academically and professionally. I have versed experience in data collection and analysis, statistical evaluation, report writing and presentation, data analysis, literature survey, research support and critical. I have over 5 years research projects applied economics in teaching and experimenting economics and statistical knowledge in experimental studies. My computer skills include STATA, Excel, SPSS, MATLAB and PowerPoint. I have interest in learning and using other programs like R and Python Zotero. ECONOMETRICS AND MODELING

• I have undertaken both advanced Econometrics and Econometric impact Evaluation courses at advanced level in my career. In addition, I have versed in econometric modeling (theoretical econometrics and applied econometrics), designs and development from economics to financial modeling, evaluation of economic and social programs. I am an expert in statistical and mathematical modeling techniques, data mining, quantitative analysis and interpretation, supporting research, analysis of economic relationships and real-world applications, trends and forecasting, constructing and maintaining databases. For data visualization I have expertise in using Tableau, Python and Microsoft Power BI for commercial consultancy and academic projects.

• I am currently learning and practicing Cloud Computing as a way of accessing technology services, such as computing power, storage, and databases, on an as-needed basis from a cloud provider like Amazon Web Services (AWS), Structured Query Language (SQL) and My Structured Query Language (MySQL). EDUCATION

Tufts University, Medford, MA September 2021 — May 2022 Master of Science, Economics (Science-based)-Quantitative Economics and Econometrics

• Teaching Assistant/Grader in Intermediate Microeconomics

• Studied SQL, MySQL and Python as supplementary classes University of Nairobi, Nairobi, Kenya. September 2011 — September 2014 Master of Art Economics

University of Nairobi, Nairobi, Kenya. September 2011 — September 2014

• Bachelor of Economics and Statistics (Second class, upper-division)

• Certificate in Data Analysis Softwares, R-QUI, Stata, SPSS, Advanced Excel, MATLAB RELEVANT PUBLICATIONS AND UPCOMING WORK

Year Title

2020 Determinants of Foreign Direct Investments in Kenya 2022 Firm Productivity and Matching Frictions in the Labor Markets. Is this unending Curse to Employers? (Ongoing work)

2022 Impact of Cash Transfers Programme on Agricultural Production in Kenya: Focus on The Orphans and Vulnerable Children

2022 Bank Performance and Insurance Uptake Nexus: An Empirical Analysis of Kenya (Under-review, co-author)

2022 Financial Literacy and Household Savings in Kenya (Under-review, co-author) 2022 Effects of Uncertainty on Domestic Private Investments in Kenya (Under-review, co-author) AWARDS AND HONORS

Jan ‘s Mission Scholarship, Jan’s Mission to pursue my Bachelor’s degree, 2011 Jan’s Mission and Bill Kring Scholarship to pursue Masters of arts in,2015Economics Chartered Financial Analyst (CFA) scholarship but deferred it, CFA, 2017 2

Full tuition scholarship to study at MS Economics, Tufts University,2021 Varkey Family Fellowship worth USD 5000, Varkey Family,2021 Honos Civicus Certificate for exceptional commitment to community service and civic engagement,2022. PROFESSIONAL EXPERIENCE

Malc Group of Companies, Kansas

Financial Research Analyst July 2022 — Current

• Creates innovative ways to report and tell a story with data

• Ability to manipulate global data sets into standard reports

• Ensures contracts and quotes are accurately maintained on a weekly and monthly basis

• Creates purchase orders and place orders for items and services based on approved procurement procedures

• Prepares report on current contract positions, pricing and global spend in a timely and efficient manner

• Maintains accuracy with purchase order and sales data for three different firms

• Analyzes financial data and provide forecasting support to the management

• Analyzes and Prepare reports and projections based on financial data for the companies

• Recommend individual and collections of investments, also known as portfolios.

• Evaluate current and previous financial data.

• Study business and economic trends.

• Determines changes of the company’s value by analyzing its financial statements. Tufts University, Medford, MA

Research Assistant and Teaching Assistant/Grader in Intermediate Microeconomics, September 2021 — May 2022

• Assisted the Professor Partridge with economic research projects involved in working on a variety of projects related to regional and urban economics

• Demonstrated research experience in a think tank university setting in conjunction with another team members

• Carried out Statistical estimation and model-building using econometrics and statistical software such as R, STATA, SAS, SPSS or EViews, Tableau and SQL for data visualization

• Experience in developing PowerPoint presentations and managing complex data with Excel spreadsheets, particularly related to chart creation and pivot tables

• Outstanding written and oral communication skills. Must be able to translate complex economic and financial issues for an educated lay audience

• Able to communicate and establish connections with external stakeholders

• Proficiency with additional data visualization software such as Power BI or Tableau • Familiarity with the heartland region economy and context

• Taught I worked for 8 hours a week,4 hours for grading weekly Intermediate Microeconomics assignments both the multiple choices, computational and short answer

• Taught recitations weekly with students for the critical questions as assigned by the professor Government of Kenya, Nairobi, Kenya

Policy Analyst, July 2018 — December 2019

• Evaluated existing fiscal policies on various projects implemented by the government to determine the economic impact

3

• Determined if policies are aligned with stated goals and objectives by the government

• Consulted with internal and external stakeholders to ensure relevant factors were included

• Identified benefits, disadvantages, and omissions in existing policy frameworks.

• Ensured that policies and policy amendments meet legal requirements.

• Provided reporting on findings and proposing new policies and amendments to existing policies.

• Participated in drafting new policies or amendments to policies and submitting proposals for review.

• Edited and finalized new policies or amendments as required.

• Documented processes and disseminating information to stakeholders. United Nations, Nairobi, Kenya

Research Assistant, Access to Government Procurement Opportunities, July 2017 — December 2017

• Evaluated Kenya’s Access to Government Procurement Opportunities program, which promotes government contracts for women, youth, and persons with disabilities, to identify factors limiting access to public procurement opportunities among target groups operating Small and Medium Enterprises

(SMEs)

• Conducted comprehensive literature review, quantitative analysis, and qualitative analysis using Stata, R-QUI and SPSS

• Authored narrative findings report and presentation documents, using statistical software for data presentation and citation management program

• Published study results on the COMESA website and Kenya's Ministry of Planning and National Bureau of Statistics websites

• Developed questionnaires (QD), collected data collection, Device Magic for pre-filling form data, Fulcrum for geolocation, FastField, JotForm and KoBoToolbox

• Wrote Reports and Presented written documents and the presented summary in slides.

• Learned research papers and grant proposals distinctions providing relevant literature and statistics data types.

• Presented research findings to the Economics Department to raise public awareness of the project amongst women and youths.

Skyda Consultancy Limited and CDCI

Economic Consultant July 2018 — December 2021 Dealt with various projects in partnership with other consulting firms involved in economic consultancy to successfully accomplish various projects. Was involved in various research baseline studies for various World Vision program.

• Provided economic consultancy and auditing experience, financial management systems

• Developed Academic and Business proposals, project management

• Developed Questionnaires, engaged more in data collection and cleaning, data analysis and report writing.

• Harmonized Quantitative data, statistical analyses, code documentation, data visualization and report writing in the out-of-school-time field.

• Trained in Statistical soft-wares such SPSS, Stata, R-Gui, Advanced Excel, Matlab.

• Carried out Data Analysis and visualization using Tableau, Python and Microsoft Power BI for commercial consultancy and academic projects.

• Created strategic plans for growth such as market research and forecasting trends

• Provided advisory regarding financial matters such as creating budgets and debts management

• Conducted research on current economic trends and industry developments to recommend changes that could positively impact a company’s performance

• Assisted on the implementing new technologies to improve efficiency and productivity

• Prepared reports, presentation and proposals for clients based on data analysis and forecasting models 4

• Provided advice to businesses regarding pricing strategies, advertising campaigns and marketing tactics

• Consulted with businesses on how to expand into new markets or introduce new products and services to existing markets

• Determined the feasibility of business plans based on research and analysis of current market conditions for data-based recommendations

Senior Data Analyst-Action Plan Research and CDCI June 2019 — December 2020 I worked as a Senior Data Analyst for the for the two-consulting firm as and engaged in the following roles:

• Mined data to acquire information from data sets and identify correlations and patterns for the data.

• Organized and transformed information into structures that was comprehensible

• Performed statistical analysis of data for ad hoc projects as assigned by the director of research

• Analyzed data using tools and techniques such as Tableau, Python and Microsoft Power BI to visualize data in easy-to-understand formats, such as diagrams and graphs

• Preparing reports and presenting these to management or clients consulting with the firm

• Identifying and recommending new ways to save money by streamlining business processes

• Monitoring data quality and removing irreverent data (data cleaning)

• Communicating with stakeholders to understand data content and business requirements Zenith Steel Fabricators, Nairobi, Kenya.

Program Officer January 2015-December 2015

• Liaised with all the staff for the company's meetings, programming monthly meetings for various departments.

• Scheduled meetings happen on time by appropriate slotting of company schedules.

• Coordinated the staff members to ensure weekly meetings are well planned in line with top management.

• Planned and facilitated site visits with cooperate clients in the overseas with the directorate for partnership in overseas.

Sales and Marketing Executive May 2014-December 2014

• Handled Exports and diversifying markets in East, Central and South Africa for various steel structure such as warehouses, steel tanks, beams and trailers.

• Experienced the growth in sales to of the company products structures in the export markets by 20%.

• Learned how to do quotations to clients, client follow up and close sales with clients for execution.

• Expanded export market more than 10 countries in Africa including Uganda, Tanzania, Rwanda, Zambia, Zimbabwe, DRC, Ethiopia, Sudan, South Sudan, Somalia, South Africa and Benin. Data Analyst -Market Analyst January 2016 –June 2016

• Data entry for the sales made and projected customers and advertised through print and visual media.

• Analyzed Finding the relationship between the advertisement and revenues earned

• Maintained stock inflows and outflows; giving appropriate recommendations on the restocking for various products on the basis of demand.

• Collected data and for the procurement and organizing it, presenting the data in terms of charts for the managerial decision making

• Gave insights on what the presented data implies for the company future growth prospects for the various departments.

• Generated scorecards with moderate data analysis from multiple sources.

• Assisting other business units with data analysis efforts such as the finance and research department

• Ensured customer service by proactively communicating information; responds to inquiries.

• Analyzed existing processes, methodologies to increase efficiency and effectiveness of operations by standardizing, improving the process improvement, simplifying and consolidation of tasks or other methods.

• Tasked to protect the reputation of the organization by keeping customer information confidential to improve on the services to customers

5

• Contributed to the team effort by accomplishing related results and participating on projects.

• Predicted trends in the customer base and the consumer population as a whole RELEVANT TEACHING EXPERIENCE

Machakos University, Machakos, Kenya. January 2019 — August 2021 Position: Part-time lecturer

• Econometric I, II and demographic Economics, Monetary Theory and Policy, Economics of Tourism

• Teaching the use of statistical packages: SPSS, STATA, R-GUI, ADVANCED EXCEL, MATLAB Mount Kenya University, Thika, Kenya January 2019 to Dec 2019

Position: Part-time lecturer

• Research Methods, Economic modeling and Simulation, Econometrics, Microeconomics Intermediate Microeconomics, Intermediate Macroeconomics, Economics of Public Finance and Mathematics for Economists

South Eastern Kenya University, Kitui, Kenya

Position: Part-time lecturer January 2021 to August 2021 Facilitating quantitative economic units and statistics in the school of business and administrative coordinator:

• History of Economic Thought, Poverty and Development and Quantitative Methods, Intermediate Microeconomics and Macroeconomics, Economics of Public Finance and Mathematics for Economists



Contact this candidate