Data Analyst

Victor Momodu

Data Analyst

Location: Lagos, Nigeria E-mail: *************@*****.*** Phone: +234(0)809-***-**** LinkedIn: linkedin.com/in/victor-momodu-55215610a

Technical Aptitudes

Programming: SQL, R, Python

Relational Database(s): Microsoft SQL Server, MySQL, Oracle, Sybase ETL Tools: Microsoft-SQL Server Integration Services (SSIS), Talend Data Visualization: Power BI, Thinkcell, Tableau

Data Science Packages/Libraries: Pandas, Numpy, Pycaret, KNIME, Tidyverse, dplyr, ggplot2 Microsoft Office Suite: Microsoft Excel, PowerPoint, Word Other Skills: Data Warehousing, Database Design, Data Cleaning, Research and Analytics, Report writing & Presentation, Creativity & Problem-solving, Planning & Organization, Time management & Scheduling Clients Worked With: eTranzact (Fintech), FCMB (Bank), Coronation Merchant Bank (Financial Institution), EFInA (Research Organizations)

Work Experience

Data Analyst (Graduate Trainee)

Octave Analytics and Insights Limited

January 2020 – Date

• Translate business goals and research questions into data discovery analysis, results, and prototype modelling output.

• Increased revenue in previous month by about 5% and 10.3% for the banks/fintech respectively by building Advanced Analytics dashboard which include Customer segmentation, Customer Portfolio Analysis, Consumer Demographic Analysis with Power BI. This aided the client in understanding the type of user engagement to place customers.

• Automated ETL processes which improved reporting and analytics by 75%.

• Collaborating with stakeholders to identify opportunities for process improvements, recommend system modifications, and develop policies for data governance.

• Designing and maintaining data systems and databases; this includes fixing coding errors and other data-related problems.

• ETL process from the source system to the data warehouse using SSIS. Also, ETL/BI testing of constructed data architectures to ensure it aligns with the business requirements.

• Using statistical tools to interpret data sets, paying particular attention to trends and patterns that are valuable for diagnostic and predictive analytics efforts.

• Creating appropriate documentation (Data Dictionary and Data Architecture) that allows stakeholders to understand the data warehouse design and steps of the data analysis process Operation Engineer (Intern)

Millenium Oil & Gas Company Limited

March 2018 – August 2018

• Performed Data Analysis on the daily volume trend of oil and water produced from different wells and proffered possible solutions to minimize water production and maximize oil production.

• Analyzed the daily production report from the field supervisors and developed a graphical representation in plots to monitor the performance of the well.

• Represented the Company in Technical Presentations to the Department of Petroleum Resources (DPR). Information Technology Intern

MTech Communications PLC

June 2015 – July 2015

• Involved in a mini- project of building a website for searching Nigerian Universities based on Rankings.

• Designed a web based CGPA calculator.

Project Experience

Data4Governance Hackathon Challenge February 2020 Project Experience Dashboard Team finished in Top 5% in the nation-wide hackathon challenge

• Project Goal: To provide logical solutions to how the government will use the insights from geospatial data to accelerate the application of data for effective decision making in delivering better public services in Nigeria with special reference to Health, Education, Transportation and Civic Engagement.

• Project Outcome: Only 38% of the health care facilities are functional. From the analysis, specific locations were recommended for provision of health care facilities across Nigeria (Health care). The population of children in financially excluded regions was 10 times more than the primary schools available. Specific locations were recommended for provision of primary schools across Nigeria considering the population to primary school ratio

(Education). Predicted the number of buses that should be deployed per location thorough major routes in Lagos, Nigeria (Transportation). Proposed an android app for citizen engagement which allows direct feedback from citizens on community projects by the government (Civic Engagement).

• Project Methods: Data Gathering, Data Wrangling and Manipulation, Model Building (Python), Mobile & Web App Development, Data Visualization (Power BI), SQL, Android Studio. Taxi-Out Time Prediction January 2020 Project Documentation Dashboard

• Project Goal: To predict the expected Taxi-out time of a scheduled flight four hours before departure and help improve airline logistics and flight management.

• Project Outcome: The Linear regression model performs best on predicting taxi-out time with a root mean square error of approximately 1.42 which is saying that any of our taxi-out prediction is permissible with an error of 1.42 minutes. To achieve better performance in terms of taxi-out time prediction, some other features and factors can also be considered in terms of processes as related to distinct airports such as construction activities within the airport, runway pattern and size per airport, infrastructures and terminal concourse and so many other factors that were not available in the flight data history provided.

• Project Methods: Data Gathering, Data Wrangling and Manipulation (SQL, Microsoft Excel, Python), Model Building (Microsoft Azure).

Education

Covenant University, Nigeria

Bachelor of Engineering (B.Eng.) in Petroleum Engineering (First Class Honors CGPA 4.52 out of 5.00) August 2014 - July 2019

Leadership Experience

• Vice Chairman, Student Council (Sept. 2018 - July 2019)

- Served as an intermediary between the management and students thus fostering a good relationship between them. Represented overall interest of student’s welfare by creating a campus public opinion system by which healthy student views are expressed. Organized crowdfunding campaigns and events to aid 20 financially challenged students pay fees. Participated in the training and selection of the next generation of student leaders.

• President/Lead Speaker, The Success Congress International (August 2018 - July 2019)

- A voluntary organization aimed at inspiring a culture of excellence in its members Honors/Awards

- College of Engineering Hooding Event - Award of Excellence as a First-Class Honors Petroleum Engineering Graduate at the 14th Convocation Ceremony, The Wings Award 2.0 – Student Leader of the Year (2019) in recognition of outstanding accomplishments and excellence, Honorary Award for Impact, Consistency & Excellence in special recognition of exemplary leadership skills displayed, a heart for people and the impact made through the Success Congress.

Certifications

• Associate Big Data Analyst (ABDA) Credential by Data Science Council of America (In View)

Contact this candidate