Adedapo Ogun
About Me
I am an Associate Database Analyst at the United Nations, where I have been developing and managing a common geo-database for the Joint Mission Analysis Centre (JMAC) and the Joint Operations Centre (JOC) for over four years. My role involves ensuring data integrity and security, extracting, transforming, and loading data from various sources, and producing dashboards with business intelligence tools.
I have a strong background in geographic information systems (GIS), cloud technologies, SQL, Power BI, Tableau, and machine learning. I use these skills to identify, investigate, and explain trends and patterns in data, and to advise on the current security situation. I also hold certifications in ITIL 4 Foundation, Spatial Data Science, and Oracle Cloud Infrastructure Foundations. I am passionate about using data to support the UN’s mission and goals.
Education
Obafemi Awolowo University
Federal university of Technology Akure
10 ALYTICS
Work & Experience
Full Stack Data Scientist
10 Alytics
• Use advanced data analysis techniques to collect, process, and derive insights from large, complex datasets across multiple sources. • Employ data cleaning, transformation, and feature engineering techniques to ensure data accuracy and enhance data quality. • Build and deploy statistical models and algorithms that can uncover hidden patterns, trends, and correlations in data, and identify key drivers of business outcomes. • Communicate actionable insights and recommendations to stakeholders through data visualizations, dashboards, and reports, and leverage data storytelling techniques to bring insights to life. • Work closely with cross-functional teams to develop and execute data-driven solutions that solve complex business problems and deliver measurable results.
Database Analyst
United Nations
United Nations logo Associate Database Analyst (JMAC)Associate Database Analyst (JMAC) United Nations · Full-timeUnited Nations · Full-time Jul 2019 - Present · 4 yrs 3 mosJul 2019 - Present · 4 yrs 3 mos BamakoBamako • Develop a common Geo-database of the Joint Mission Analysis Centre (JMAC) • Extract,Transform and Load from Azure SQL Database and other sources to produce dashboards with Business Intelligence tools. • Responsible for Data Integrity and Database Security. /Joint Operations Centre (JOC) in close liaison with Communication and Information Technology System (CITS) • Manage and update the geo-database. • Identify, investigate and explain trends and patterns in data using data tools, platforms and analytical tool kits. • Use collated information to produce Daily incident Report and advice on current security situation. • Maintain non - structured database for internal coordination • Daily inputs into the JMAC IBM i2 intelligence database • Generate information tables, statistics, reports, analysis and maps with data extracted from the JMAC database. • Store/compile/link/produce information (reports) using Data visualization and infographics • Create content For Radio Mining Analysis
Security Support Associate (Database)
International Organization for Migration
Created and Maintained a security Database using MySQL and MS Access. • Maintained a standard Database of all Security incidents in North East Nigeria. • Created asset Management Database of all UN owned equipment. • Maintained an inventory of all fire equipment within the building with the corresponding expiry date and liaise with the logistics team on maintenance and replenishment/repair/replacement. • Maintained staff list to ensure all pertaining information to the staff member's addresses, contacts and dependents are recorded and regularly updated on daily basis to be shared with UNDSS and HR colleagues. • Spatial Analysis of Armed conflict groups with north East Nigeria.
Database Officer
Nigerian Army
• Created and Maintained SQL Database for 52 Divisional Signal Strength, asset and statistical returns. • Created and implemented database designs,data models for 52 Division Nigerian Army Signal. • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers. • Wrote and maintained technical and functional specifications to document database intentions and requirements. • Tested programs and databases to identify issues and make necessary modifications. • Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process. • Querying Database of Staff Records for Promotion and missing records. • Daily Data Entry and update of Classified documents. • Created Database Backups on multiple servers. • Responsible for Maintaining unstructured Databases. • Ensured data is secure and organized for easy access to information • Data Management and Data Control.
