Dare R. Ayoade

Tucson, AZ ad2rkj@r.postjobfree.com 602-***-****

SUMMARY

Expertise in data modelling, database design, SQL programming, data analysis and business reporting

Ad Hoc analysis and reporting experience using Power BI and Excel.

Competent in writing DAX queries for Power BI reporting purposes

Multiple years of experience querying SQL Server databases and creating database objects like Views, Tables etc.

Experience using Excel formulas and functionalities e.g. V-Lookups, Pivot Tables, Index, Match etc.

Conversant in utilizing Python scripts to extract data from multiple sources.

D.O.D Clearance.

CERTIFICATIONS

Power BI: Dashboards – Microsoft Power BI

Python – Data Camp

Data Analysis: Graph Analytics -

Six Sigma Green Belt –Raytheon Technologies.

Six-Sigma (Green Belt) - Honeywell Aerospace.

Six-Sigma (Green Belt/Black belt) – Arizona State University. PROFESSIONAL EXPERIENCE

Raytheon Missiles System Tucson, AZ 2018 - Present Data Analyst

Developed weekly Ad Hoc reports that display Valor NPI & PCAT data.

Collect and analyze aerospace and defense data, including flight test data, sensor readings, maintenance logs, and operational data, to extract valuable insights and optimize performance.

Tracked intake, backlog, and sprints in JIRA; also kept track of stories and epics.

Transformed numerous Excel reports into Power BI dashboards for better insight, collaboration, and automation.

Assisted in analyzing and visualizing data from flight test campaigns to assess system performance and validate engineering models.

Developed automated data processing scripts using Python to streamline data analysis workflows.

Conducted performance tuning on SQL and DAX queries used in dashboards to ensure quick data load time.

Led efforts for creation of entity relationship models using data modeling and normalization methodologies.

As part of a team, performed conceptual, logical and physical modeling of transactional database platforms; These platforms store organizational data (Employee, Delivery, Consignment, and Financial Transactions).

Create interactive dashboards and reports using Tableau, providing stakeholders with real-time access to critical information and performance metrics.

Conducted ad-hoc analyses to support business decisions and answer questions from stakeholders.

Develop operational metrics using SQL and Power BI; these metrics are evaluated on a quarterly basis for enhancements.

Created and maintained excel solutions (Pivot table and Pivot charts) that reported and analyzed data across all multiple business processes for internal and external clients. Celestica Tucson, AZ 2017 - 2018

Analyst

Extracted data from MatLab and Simulink for dashboard development in Power BI and Tableau.

Built data models in Excel for self-service reporting purposes; extracted data from CSV files and SQL Server, created relationships, transformed data, and built standard measures for reporting purposes.

Built Excel based reports that performed automated root cause analysis of defects; these reports increased employee productivity by 70%.

Acted as Subject Matter Expert (SME) for coating chemistry and application (surface preparations, coating mixing, coating failures analysis and inspections instruments).

Used MyData M19 (Surface Mount Tech), Camalot 1818, Vitronics Soltec, and Accuflex for incorporating components into PCBs in accordance with IPC-A-610.

Led cross-functional group of process technicians to drive new product development.

Performed medium to complex data transformations and cleansing in excel using formulas like VLOOKUP, INDEX/MATCH, IFS, MID and array formulas.

Worked closely with internal and external clients to provide meaningful insights (Trends and patterns) into their data by developing data models using PowerPivot and establishing operational metrics and key performance indicators.

Extracted, transformed, and loaded data from disparate sources (Third party API based and in house generated Excel extract) into a normalized data model in SQL Server.

Create physical models by applying normalization methodologies; Created tables, keys, relationships, and constraints using SQL.

Honeywell Aerospace Tucson, AZ 2015 - 2017

Analyst

Applied DMAIC approach to research and understand the root cause failure and provided recommendations on corrective actions by pulling Quality Notifications (QNs) from various transaction codes off SAP.

Investigated and documented materials properties using FTIR, DSC and TGA per ASTM.

Used military and industrial specifications (ASTMD2000 & ASTM F104) to create material line call out.

Reviewed and approved alternate materials selection, engineering drawings, manufacturing processes, and material testing.

Transformed numerous Excel reports into Power BI dashboards for better insight, collaboration, and automation.

Collaborated with the inventory management team to optimize product inventory levels.

Wrote multiple queries that extracted data from SQL Server using concepts like JOINS, Sub Queries, Set Operators; Created SQL Server views that transformed data for reporting purposes.

Built complex SQL Logic (Views, functions, and Ad Hoc queries) to extract and transform transportation data used for reporting purposes.

Created Project Scheduling and performance dashboards using Power BI; implemented native functionalities like row level security, custom visuals and themes, data modeling, and data transformation using Power Query.

Implemented functionalities like row level security, bookmarks, and complex DAX measures in Power BI. EDUCATION

BSc., Chemical Engineering Arizona State University Tempe, AZ CONTINUING EDUCATION

Eklipse Consult Chandler, AZ

Training: Power Bi, Dax-Function, SQL, Python Basic

Contact this candidate