Data Analyst

Adewale (Wale) Ademokunla

Phoenix Arizona 347-***-**** *******.**********@*****.***

PROFILE

Analytical and motivated self-starter with skills in business data analysis, stakeholder management, business Intelligence, Reporting and database development. I work with a sense of determination and purpose to help drive business growth and success. I have worked on data projects, utilizing my strong knowledge of business operations to monitor, measure and appraise sales, marketing and operational performance; I have built reports that have influenced strategic business decisions leading to decent return on investment.

Core Competencies

Business Intelligence Analyst with vast experience in data modeling, SQL programming, data analysis and reporting.

Years of experience in database technologies and SQL; Adept in data modelling techniques

Data analysis and reporting professional experience across multiple disciplines – Aviation, Health and Technology

Working data analysis and reporting experience using PowerBI and Excel

Expert - Level experience using Excel formulas and functionalities e.g. V-Lookups, Pivot Tables, Index and Match

Excellent customer (internal and external) service skills, thrive in both independent and collaborative work environments.

Good leadership, organizational, oral/written communication, interpersonal, analytical, and problem-solving skills.

Area of expertise

T-SQL

Data modelling

Microsoft Excel (Advanced)

DAX

PowerBI

SCRUM

Professional Experience

Mesa Airlines Phoenix, AZ April 2018 – Present

Flight Data Analyst

Worked with other members of the analytics team to build business performance models for revenue and profit estimation using Excel and PowerBI

Built multiple Excel based reports and dashboards that provided actionable insights into flight operations data; applied medium to complex excel formulas and functions Like VLOOKUP, INDEX/MATCH, IFS and others to cleanse and aggregate data across multiple disparate data sources

Built complex data models in PowerBI leveraging multiple data sources like CSV, MS Access and SQL server data sources; applied complex transforms using Power Query and built visually appealing and functional reports to present flight data

Created complex database queries using functionalities like joins, views, built-in functions, set operators and others to retrieve pertinent flight data for SQL Server database for reporting purposes

Performed root cause analysis on flight data discrepancies and wrote SQL queries to correct data issues

Updating & maintaining Avionics data bus traffic and/or Post Code Modulation (PCM) format definition files/databases for use in data recording & processing

Cape Air Hyannis, MA Mar 2017 – Mar 2018

Flight Dispatch Analyst

Built a complex Excel solution to compute the amount of fuel required for the safe completion of flight according to aircraft type, distance of flight, maintenance limitation, weather conditions and minimum fuel requirements prescribed by federal aviation regulations.

Developed reports that displayed flight plans containing information such as maximum allowable takeoff and landing weights, weather report, field conditions, NOTAMS and many other informational components required for the safe operation and completion of flight.

Built company’s daily flight schedule dashboard using Microsoft Excel

Built an Excel model using data from relational database and created relationships between entities to allow slicing and dicing across multiple tables; This model was used for analytical and reporting purposes

Oversaw the safe operation of the daily company flight schedule, monitor and ensure accuracy of FLIFO

Assisted team members when a higher than expected workload is encountered due to weather, delays, mechanical irregularities or other disruptions, with communications, coordination and other duties in order to make situation more manageable.

Mount Sinai Hospital NY Feb 2016 – Feb 2017

Business Analyst

Acted as a liaison between Cancer treatment group and IT technical team by communicating clearly and concisely to both parties.

Resolved the conflicts between stakeholders by clearly defining the process and getting consensus on how patient routing should be performed going forward.

Led the Joint Application Design (JAD) sessions that involved, business stakeholders, technical leads, developers, architects. Deliverables included a BRD and a technical design document.

Used Visio to clearly document the appointment and patient routing processes for different services provided by Mt. Sinai Hospital

Conducted domain and product training session for the team. Acted as a Product specialist for answering any queries raised by product team. Mapped customer’s requirement in the form of use cases, functional flow charts and data flow charts.

Arik Air NY Jan 2015 – Jan 2016

Flight Operations Analyst

Analyzed and evaluated meteorological information to determine potential hazards to safety of flight and to select the most desirable and economic route of flight using Microsoft Excel

As part of a team, worked with internal and external customers to develop and document data analysis requirements to satisfy business operation objectives

Liaised with the Software Development Team and customers on the continuous improvement and development of the Flight Data reporting and analytics

Generated and maintained daily, weekly and monthly flight data Excel reports and ensured report delivery to business users using macros and programming techniques

Provided routine safety and maintenance analysis of downloaded flight data

Prepared monthly budgets using excel; analyzed and monitored data for discrepancies in flight operations data

Education

Certificate, FAA Aircraft Dispatch Institute of Flight Operations and Dispatch (IFOD) Houston, TX 2017

MBA, Marketing Management Ladoke Akintola University of Technology Nigeria 2011

B. Sc, Mass Communication Covenant University Nigeria 2008

Diploma, Computer Science Lagos City Computer College Nigeria 2003

Contact this candidate