Edem Duke

Skills: Stakeholder Management · Leadership · Teamwork · Big Data Analytics · Azure DevOps Server · Microsoft Power BI · Python · Data Governance · Data Strategies

- Instrumental in the development and implementation of the DAMA Data Governance framework for global analytics infrastructure, building policies, data quality test and carrying out POC for data management softwares. - Conducted design thinking and change management workshops for projects including Negotiation Tracker for commercial excellence teams, Forecasting and Budgeting processes for finance and sales teams, and global data governance initiatives. - Documented data quality standards, business processes, and IT project lifecycles, supporting onboarding of new data team members. - Ensured consistency of reports across visualization tools, data warehouses, and source systems (Talend, SQL, Power BI, Oracle DB, DBeaver). - Involved with recruitment and led onboarding of Data Engineering and Data Analyst profiles, improving team autonomy and productivity.

- Developed an Automated Business Review for the CS Ops team using Tableau Cloud , in order to improve customer success processes for client analysis. - Developed metrics for different pillars of the Product team. (SQL and requirement gathering) - Troubleshooting and debugging of Tableau ad-hoc request from entire organisation. (EMEA, AMERICAS, & Australia) - Providing data extracts for Finance teams and assisting with predictive models in SQL. - Database and Reports Optimisation. (AWS, GITHUB, SQL, Tableau) - Documentation of Analytics projects for the BI team and other stakeholders. - Training of intern on data analysis. (SQL, Excel, Tableau, Requirement gathering)

• Provided assistance with data analysis recommendations on various topics.

• Dashboarding - creating visibility and helping to answer pm questions and ad hoc requests on Google Data Studio & Quciksight. • Documentation - building a readme to help have easy understanding of data. • SQL data engineering - building datasets/tables & dataflows with queries on Google BigQuery and Redshift. • Trouble shooting - helping to identify root cause of problematics and find solutions/recommendations. • Data Tracking Needs - Making sure the tracking is implemented & tested properly (web and app assets). • Database/Dashboard Optimization - Reducing cost and improving efficiency on Google BigQuery & Google Data Studio. • Analytics: Responsible for Google Analytics, Google Tag Manager, Google Big Query assets; (maintanance, support & debugging ) • Team Work: Worked with frontend, backend developers, data scientist & engineering, Project Managers and UX/UI professionals on various topics to drive project objectives.

• Building self-service dashboards to track and monitor metrics for business needs with Tableau. • Building scheduled queries with SQL for ETL to dashboard process, assisted in database management. • Data cleaning, analysis and visualizations with Python and SQL.

Green Panda Games (GPG - Ubisoft subsidiary) • Developed One-Pager visualizations using Tableau to provide a general overview of the company’s most important KPI’s (UA, Product, Monetary metrics) to assist project managers, the product team and high-level management in quick decision making and prioritization. • Built Data Flow pipelines using advanced SQL functions to create datasets, tables and views used on Google BigQuery which were then used to feed Tableau and make necessary visualizations depending on the data needs or specific analysis for the product team. • Performed frequent ad-hoc debugging and troubleshooting of SQL code used to create key metrics and Tableau visualizations for the product team. • Performed funnel analysis for several A/B tests to better understand user behaviours. • Worked in a team of four (4) analysts, to provide the analysis and engineering needs of all other teams in the company. • Instrumental in the process of defining key metrics to be tracked and monitored for project analysis success.

• Worked with large datasets in a range of 5million to 16million+ rows on Google Big Query using SQL to extract data needed to create tables and Datamart’s to answer ad­hoc reports. • Collected business needs from the User Product Team to build several dashboards using Tableau for visualization, and SQL to query the database and manipulate the data to fit the needs. These were used to support decision making and monitoring of the Loyalty Email and Push Notification Campaigns. • As the analyst on duty, I was tasked with responding to ad­hoc request from all departments in Paris as well as regional parts of the organization (Americas, LATAM and APAC) for the duration of my internship. • Built dashboards with Google data studio to monitor important Revenue, Engagement & Loyalty KPIs. • Worked in diverse, multicultural teams with up to five (5) people, using Agile and Lean methods to deliver effective and actionable insights on projects. • Lead data analyst on an A/B test for market research. I carried out a pre­ analysis using a modifiable python Jupiter notebook script and the post­analysis with SQL and Amplitude to understand the impact of the test. • Created presentations for projects I had worked on to share my findings with the team as well as give recommendations.

- Worked for the International Students Department to better improve their strategy in attracting international students to the various top tier programs offered at the University. - Gathering stakeholder requirements and translating into self-service analytics - Executed the entire data lifecycle, collecting, cleaning, performing analysis and creating selfservice visualisations using micro strategy and Excel

•Worked on a Consumer Complaint Management System project for 7 months and was tasked with building the database on Oracle Servers and testing with Java and SQL for accuracy. •Created Presentations to display my advancements in an agile workflow, on a weekly and monthly basis. •Responded to daily ad-hoc requests for the Applications Management Division Team. •Built several self-service dashboards with Tableau for managerial decision making based off priority and recommendations. •Debugging and writing tested Java and SQL code on Oracle Cloud Platform for several AMD systems.