DADJA ADILI

DATA ANALYST

CONTACT

adrfjy@r.postjobfree.com

813-***-****

Tampa, FL

public.tableau.com/app/profile/adili

LinkedIn

EDUCATION

bacherlor

Accounting, Control, Audit

University of Lome

September 2007 - July 2014

Lome TG

SKILLS

Tableau Desktop, Tableau Server

SQL (Postgres, MySQL)

PL/SQL

Triggers, stored procedures, views

MS Excel

Data Visualization: Tableau, Excel,

Google Sheets

Programming: SQL

IBM AS400

WORK EXPERIENCE

Data Analyst/Tableau Developer

A-Plus Moving Solutions

July 2020 - current / Tampa Fl

· Use data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their Data

· Developed several operational reports using SSRS.

· Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.

· Worked with clients to understand business needs and translate those needs into actionable reports in Tableau, saving 16 hours of manual work each week

· Built operational reporting in Tableau to find areas of improvement for contractors resulting in $125K in annual incremental revenue

· Built out the data and reporting infrastructure from the ground up using Tableau and SQL to provide real-time insights into the product, marketing funnels, and business KPIs

· Created interactive cohort analysis report in Tableau Server for the product team with global filters and parameters that helped improve monthly retention by 15% for a specific target

· Built and published 20+ customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server

· Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts)

Co-founder/ Data Analyst and Tableau Developer

ADSL-FORMATION

April 2012 - current / Remote

· Written complex SQL queries and optimized queries for performance tuning.

· Built and published 30+ interactive dashboards on Tableau Server, resulting in a 23% increase in revenue

· Work with client and team members to understand and clarify visualization requirements

· Implemented long-term pricing experiment that improved customer value by 25%

· Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering with Erwin tool.

· Automated a report for the sales team using filters, parameters, and calculated sets that automatically qualified sales leads, improving conversion rate by 17%

· Implemented security guidelines by using user filters and row-level security, reducing private data exposure by 65%

· Initiate high school students to SQL server management studio fundamentals A1C

US AIR Force

January 2020 - April 2020 / TEXAS

· Graduated from US Air Force Basic Military Training SQL Data Analyst/Tableau Developer

Gondrand Logistic France

August 2018 - January 2020 / remote

· Reported data and visualization efforts on the EDW to senior developers

· Built 50+ Tableau reports, dashboards, and metrics in EDW, resulting in a 25% improvement in efficiency

· Worked with clients to understand business needs and translate those needs into actionable reports in Tableau, saving 12 hours of manual work each week

· Utilized C++ to process large streaming datasets, and improved ingestion and processing speed of that data by 65%

· Built basic ETL that ingested transactional and event data from a web app with 10,000 daily active users that saved over Euro 75K annually in external vendor costs

· Formed hypotheses, and tested ideas to determine viability of operation outcomes

· Created interactive cohort analysis report in Tableau Server for the product team with global filters and parameters that helped improve monthly retention by 17% for a specific target

· Partnered directly with the executive team as the first data hire to formulate and report on KPIs across their web properties that received 225M visitors annually using SQL and Google Sheets

· Identified procedural areas of improvement through customer data, using SQL to help improve the profitability of a nationwide retention program by 10%

· Discovered new storage and tracking method of live data, and wrote and directed SOPs for analyst team

Sql Data Analyst

African Institute of Informatics

Apr 2013 - Jun 2017 / Lome TG

· Developed and owned reporting for a nationwide retention program with SQL, and Excel, saving ~90 hours of monthly labor

· Developed and deployed reports to provide operational and analytical information to administration, interpret data, analyze results, and construct ongoing reports by using SAS.

· Wrote complex SQL queries using advanced SQL concepts like Aggregate functions

· Used stored procedures, triggers, and views to provide structured data to business units by combining millions of rows of data from over 12 disparate data sources

· Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Cast, CTE’s and table expressions against SQL server database and oracle

· Built forecasting using parameters, trend lines, and reference lines saving 60 hours of manual work each quarter

· Discovered new storage and tracking method of live data, and wrote and directed SOPs for analyst team

· Students data consolidation, developed store procedure, troubleshooting students access issues and provide support to student and teacher

Contact this candidate