Data Analyst Research Assistant

Dickens Molo

+1-848-***-**** adrnwi@r.postjobfree.com

**** ******** ***** ***** ********* NJ 08902

PROFESSIONAL SUMMARY

Over 5+ years broad based experience in IT. Research Design, Econometrics, statistical modeling, Financial and Business Data mining, cleaning, processing, analysis, visualization and presentations of solution and reports using various analytical and Microsoft tools like excel, power point and power BI, Tableau and R.

Expert in Using statistical tools to analyze and interpret data sets, paying particular attention to trends, patterns, KPI which are valuable for diagnostic and predictive analytics efforts based on the end user requirement.

TECHNICAL SKILLS

Database: Microsoft SQL server, Azure SQL,

Expert in Microsoft Office Excel (queries, pivot), SQL, Python,

R and STATA, DAX and SPSS

BI Tools- Power BI, Tableau

Statistical and Economic modeling

SDLC Spatial Data Analysis: ArcGIS, GIS, and Remote Sensing

WORK EXPERIENCE

UX Researcher Data Quality Analyst META via Contract with Experis - PA February 2022 – Current

Review media of participants making variance facial and eye movement/user expressions for a large-scale data collection to develop machine learning algorithms that work well across a diverse population as part of Meta UX Research.

Perform quality checks to ensure consistency, integrity, and robustness of the collected data before submission to the Meta team.

Data Scientist & Power BI developer Charter -Spectrum - CT August 2021 – February 2022

Expertise in installing and upgrading wide multi node self-servicing BI Platform like Tableau server and power BI report server with high availability

Expertise in Setting up Tableau online sites and Power BI service

Creation and automated a weekly and monthly Net gain, penetration, projection, MoM and YoY report analysis for videos, mobile, and Internet products for SCS Spectrum

Conducted complex data analysis and developed documents for data definitions, business rules and data quality requirements.

Transformed raw data to usable model. Mining, Cleaning, Processing, Analyzing, Presenting, and creating simple visual publishable reports.

Created and produced forecasts, reports, ad hoc requests, and dashboards by extracting data from multiple sources including salesforce.

Provide insights to determine operational impact, retention, trends and opportunities through detailed data interpretation manipulation and results analysis in SQL, Tableau and excel.

Develop reports and deliverables, creating specifications based on business requests for senior leadership to leverage while collaborating with other team members of Spectrum.

Enhance efficiency by creating and maintaining report forms and formats, information dashboards, data generators, canned reports and other end-user information portals or resources.

Develop new strategies to improve business performance by utilizing knowledge of mathematical modeling to perform quantitative and qualitative data analyses.

Data Analyst & Power BI Developer Skybarrel IT Agency -MD March 2020 – April 2021

Developed dashboards and ad-hoc reports using MS Power BI and SSRS that provided insight for management team and sales department, per different area for product.

Using SSIS Package identified the Up-streams and imported the required tables into intake-database, Store Procedures are created in staging database using the intake-database tables & views.

Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2016.

Participated in authoring the SQL queries for report creation, extraction, and various transformations of data.

Identified and tested key indicators for analysis and creation of dashboards and reports. Including the sites wide monthly sales trend, sales decline by customers, top sales by product, Increase or decrease by customers’ gender. Seasonal analysis including holidays and other indicators.

Research Assistant University of Connecticut – CT August 2018 – June 2020

Created workflow process, timeline, and design for my graduate school project.

Identified Problem, designed the research project, collected, and extracted data from different databases, analyze and interpreted the data results, created tables, graphs and valuable visual presentations for the results.

Collected and Extracted world bank data on household survey, cleaned and formatted using STATA.

Performed quality checks to ensure consistency, integrity, and robustness of data before analysis.

Performed several Statistical and Econometric analyses and used various econometric model to analyze various variables and metrics to determine technical and technological efficiency for small scale farmers. (Thesis)

Calculated project investment summaries/ Cost Benefit analysis and variance analysis for the management in another project for my Principal Investigated.

Performed geo mapping and GIS python scripting and modelling on spatial data.

Supported federally funded project leads in preparing Connecticut Physical Climate Science Assessment Report (PCSAR).

Analyzed project mean precipitation and temperature extremes. Created tables, graphs, report, and script for publication based on the results for Connecticut State Annual Environmental and Resource report.

Teaching assistant for undergraduate students on Natural Resource Measurement and laboratory protocols. Course code: NRE 2010.

Supported principal investigators during research on Economics estimation of corn production. Analyzed data and drafted the report including manuscript for publication.

Program Coordinator The UNESCO Chair in Comparative Human Rights Storrs, CT Aug 2013-May 2016

Organized, coordinated, and facilitated International Human rights programs in partnership and collaboration with different Institutions/ Government/ NGOs in 12 Countries in Asia, Africa, Latin America, and Europe.

Compiled and developed reports for the forums and presented the report to the UNESCO Chair office.

Coordinated and organized activities for UNESCO Chair Student ambassadors for human rights in various Universities.

Developed proposal and review budget for the international forum for UNESCO.

EDUCATION BACKGROUND

Master of Science: Natural Resource and Environment / University of Connecticut/ 2018 to 2020.

Master Of Science: Applied Economics / University of Connecticut/ 2013 to 2016.

Bachelor of Science: Food Nutrition and Dietetics/ Egerton University in Kenya

Contact this candidate