Omokhemi Ogude

Business Intelligence Analyst

Fort Worth, TX 76123

advav0@r.postjobfree.com

+1-682-***-****

Business Intelligence Analyst with experience in design of Entity relationship diagrams, data analysis, data visualization and reporting and Agile scrum methodology Authorized to work in the US for any employer

Work Experience

Business Intelligence Consultant

FDM Group - New York State

April 2022 to September 2022

Worked as a BI Analyst in an Agile Pod to develop a financial goal planner app called EZ-2-Plan.

• Designed swim lane process diagrams and entity relationship diagram (ERD)

• Made Power Point presentations to show the User Interface Flow Diagram (UI) of the EZ-2-Plan App to the Stakeholders

• Worked as Scrum Master Sprint 5 in the EZ-2-Plan development team.

• Sorted Data with Microsoft Excel (Pivot Tables, IF and aggregation functions, lookup functions)

• Used SQL to retrieve data from company database

• Used Tableau and Power BI to extract, transform and load data( ETL ) from multiple sources

• Use Dax language to create formulas in Power BI and created calculated fields in Tableau to manipulate data for data visualization

• Created interactive dashboards with Tableau and Power BI

• Collaborated with team members, stakeholders and Management on Jira QA Associate

Walmart Distribution Center, Sam’s Club - Fort Worth, TX August 2021 to March 2022

• Sort overages and return item to warehouse location in storage.

• Verified on dock receiving items, setting prime slots for received items and solving issues with Ti/Hi on prime slots.

• Executing SQL queries for data validation.

• Handled data extraction from external Microsoft Excel files and sorting same using advance functions like Pivot Tables, Vlookup, Hlookup etc. to present useful information

• Worked with Cross functional Team to develop tableau reports

• Worked on Agile - Scrum Testing Methodology and tested inhouse applications

• Audited gift cards leaving the warehouse cage to shipping.

• Performed audit and verified items in warehouse cage.

• Controlled inventory by monitoring and accounting for items leaving the cage, circle counting to make sure inventory records were correct and creating slots for new items brought into the warehouse cage.

• Prepared reports to management

Course Project

Pathstream - San Francisco, CA

October 2021 to January 2022

• Conducted an exploratory data analysis (EDA) to provide key stakeholders with data-based evidence of user success characteristics to make the business case for additional funding.

• Used Excel Pivot Tables and Charts to show insights and make data-driven recommendations to support company growth.

• Built a Tableau Story with interactive dashboards and dashboard objects to report insights to technical and non-technical stakeholder.

• Worked in an Agile Project Management system in which product backlogs, user stories, sprint backlogs and product release were performed

Course Project

Cornell University Remote - Ithaca, NY

May 2021 to September 2021

• Created and shared interactive data models

• Used prescriptive analytics in excel

• Made Predictions and forecast with data

• Visualized and communicated insights in excel using Pivot Tables and charts.

• Harvested spreadsheet data (data mining)

• Used Excel formatting to improve consistency and readability of information

• Used formulas and functions to calculate and analyze data with excel V-Lookups, index match and IF functions.

• Used the Concatenate and Find functions to join information

• Created a simple macro to reduce redundant tasks Warehouse Associate

Walmart Distribution Center - Fort Worth, TX

February 2020 to August 2021

· Audited and scanned online ordered items into the warehouse management system.

· Sealed, packed, labeled and affixed postage on packages to prepare materials for shipping, utilizing postage meters and sealing tools.

· Execute inventory counts to show discrepancies and returned items back to their warehouse location.

· Sorted overages and returned them to their location in the warehouse storage.

· Exceeded management goal expectations and was sent on several occasions to help in quality assurance and the pick tower.

· Received the DFW1 Award (putting a lid on damages) for Lowest damages in the building for Q1FY21. Education

certification in Business Analytics and Operations Pathstream - San Francisco, CA

October 2021 to January 2022

Certification in Data Analytics

Cornell University - Ithaca, NY

May 2021 to September 2021

Bachelor's degree in Sociology

Ambrose Ali University - Nigeria

September 1992 to November 1998

Skills

• SQL

• Tableau

• Google Sheets

• MS Excel

• Exploratory Data Analysis (EDA)

• Data Analytics

• Warehouse Management System

• supply Chain

• Warehouse

Distribution Experience

• Quality Assurance

• Data Visualization

• Business Analysis

• Pivot Tables

• Microsoft Power Point

• Microsoft Office

• Microsoft SQL Server

• Agile

• Power BI

• Business Intelligence

• Visio

Languages

• English - Fluent

Contact this candidate