Data Power

ARNAUD MARTIAL CHEKAP MENGOUO

Summary:

• A Dynamic Technical Business, Data/Reporting Analyst with experience in data management, data visualization and analysis role in a fast-paced environment. Experienced in, SQL writing, business requirements gathering and process improvement in telecommunications and healthcare industries. Used Power BI and Excel for reporting/visualization. Advanced knowledge of relational and dimensional database modeling concepts. Proficient t in report writing and query optimization for better database response and accuracy.

• Data Management using MS Access and MS SQL (Structured Query Language)

• Design CRF, Data cleaning and Analysis using MS EXCEL, R and SAS

• Run python script in power BI to create visualization and evoke the pandas library for data analysis used for importing data from Excel spreadsheets to processing sets for time-series analysis.

Core Competences:

• Relational and Dimensional databases SQL

• Requirement gathering Business ow modeling

• Database backups and recovery

• MS SSDT (SSIS and SSRS Building) SDLC (Agile and waterfall approaches) Data pro ling and cleansing

• Data management Data mapping

• Power BI (Data Visualization/Analysis) Database design and architecture

• MS Excel - Pivot table, charts/trend lines for visualization(charts) Data Modeling and Creating Schemas

• Data warehousing (Fact and Dimension Tables) and ETL Processes OLAP and OLTP concepts Technical Skills:

• RDBMS: Microsoft SQL Server (2005), MS Access

• Querying/BI Tools: SQL Server Management Studio

• Requirement Management Tool/Data software: Excel, MS Access PowerPoint, Outlook, Latex Ticketing Systems: Remedy, Service Now

• Reports Development/Visualization/ETL: Power BI, Tableau, MS SSIS SSRS (MS SSDT 2015)

• Database Languages: Advanced SQL Amazon Web Service

• Web Solution: Java EE

• IT Law: Data Protection

• Statistical Analysis: SAS, R programming, Winbugs, python

• Operating Systems: Windows, Linux

Professional Experience:

Petroleum Certification Consulting, Ghent-Belgium Jul 2018 – Jul 2019 Business Intelligence Specialist

• Database query using Power BI and Excel (Import, Direct and life Connection queries).

• Create visualization in Excel (Power BI Publish Package) and publish using Power BI service. Data Mapping.

• Give presentations to work groups and leadership on findings using data visualization tools to tell a story through data and examples.

• Design and develop the SQL, or ETL process(es) to gather required data elements. Perform best practices and guidelines in testing ETL processes.

• Responsible for dashboard development process, including creating data definitions, validating data, retrieving data from systems, maintaining technical documentation, and dashboard creation.

• Manage and produce ad hoc reports, recurring reporting needs, and presentations that provide data-based insights for solutions to business questions.

• Support our new data governance model and statistical plan strategy through research, collection of data elements, development and maintenance of the data dictionary, quality control, reporting.

• Identify and resolve data anomalies by writing SQL queries and performing root-cause analysis. Ensure timely, accurate and complete reporting of the data.

• Review submitted data to detect accuracy problems and anomalies and help departments correct data: both current and historical.

University Of Hasselt, Diepenbeek-Belgium Jun 2016 – Sep 2018 M.Sc. Biostatistician Graduate student

• Data Management using MS Access and MS SQL (Structured Query Language)

• Design CRF, Data cleaning and Analysis using MS EXCEL, R and SAS

• Report write-up on LaTex environment, Qualitative and Quantitative Data Collection Techniques, Development and validation of questionnaires (Census and Survey Processing System), Designing Household Survey.

Panel Africa, Douala-Cameroon Jan 2016 – Aug 2016

Junior Research Engineer

• Participates in the methodological reflection, the conception and the realization of the studies and projects of the institute

• Participates in the collection and analysis of project data of the institute; Participates in the drafting of the studies and projects report

• Participates in the coordination of field actions; Administration of Geographic Information System. Education:

• M.Sc. Courses in Computer science and Information Technology.SUPINFO University, Brussels Sep 2018 - May 2019

• M.Sc. Courses in Biostatistics University of Hasselt, Diepenbeek Sep 2016 – Sep 2018

• Bachelor of Science, Mathematics with minor in Computer Science. University of Buea, Buea Oct 2009 - Oct 2013

Contact this candidate