Oladimeji Olaoye
Richmond,United States
Summary
Twenty years of experience in IT business Support, Data Analytics, translating long and short-term goals into business solutions such as data modeling and design, data architecture design, process automation flow, data ingestion and migration, data warehousing, data lake, business intelligence, data quality to drive optimal operation processes for seamless data batch flow efficiency using Agile and Scrum framework. Solutions are deployed in a premise and cloud-based environment for cost-saving, availability, reliability, and manageability-a passionate researcher and learner.
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
21
21
years of professional experience
1
1
Certification
Work History
Data Analyst
Emdeda Consulting, Texas
Richmond, TX
06.2011 - Current
- Coordinated statistical data analysis, design and information flow.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Participated in requirements meetings and data mapping sessions to understand business needs.
- Responsible for cross functional business requirements capture and translating them into data models to drive key operational, risk management and CRM models.
- Responsible for data discovery, ETL processes from RDBMS to data lakes and bulk insert big data into RDBMS.
- Developed reports on business position management, billing, forecast, operational exceptions.
- Currently th IT interface for various department in setting up reports, modifying, rebuilding, optimizing, subscribe user existing reports in Power BI, Tableau and SSRS.
- Designed, monitor data validation checks to ensure consistence between source and destination pre and post load.
- Work with cross-functional to scale and optimize cloud solutions in production systems.
- Using cost explorer, compute optimizer to advice engineering team on resizing and providing cost visibility.
- Work with engineering team on the best approach to optimally size their production system, considering impacts and complexities.
- Liaises with key management to drive optimization cost within the organization.
- Working with engineering team to adequate provision low and complex resources such as s3, ec2 instance in non-production environment.
- Injecting Cloud Watch logs and metrics through API calls into data lake s3 for KPI reporting, on various AWS resources for cost tracking and optimization.
- Curate enterprise to create different LOB semantic layers/materialized views and Communicate findings to the stakeholders through standard and ad hoc reports.
- Work with cloud engineering Team and Cloud Core on the identified cost-savings opportunities as well as propose new ones
- Developed a Power BI/Tableau application reports for various sections of the business for decision making.
- Work with the software development team to understand their various data model requirements, develop, test and deployed.
- Design, document, develop, test, and deploy of various business intelligence applications, dashboards, and reports for risk evaluation on gross margin, forecasting and customer analytics reports.
- Curate data using MS Excel to create Pivot Tables, VLOOKUP joins and other advanced functions for ad hoc reports.
- Worked with multiple databases servers such as MySQL, SQL Server, Oracle, Snowflake for creating various data model.
- Designed, developed, and maintained 360 customer profile snapshot enterprise active, new, existing, and inactive contacts.
- Transformed project data requirements into project data models.
- Trained employees on software to improve data management, monitored use and suggested improvements.
- Evaluated trends to understand competitive environments and assess current strategies.
- Updated organizational systems and subsystems to improve and streamline data collection.
- Compiled, evaluated and reviewed engineered data for internal system.
- Managed setting up multiple connection driver between data sources and analytics engine - Tableau.
- Profile new data for quality assurance purposes
- Perform preliminary analysis and cleanup of M&A master data before handing over to the business for further review and cleanup.
- Assist with determining the appropriate hierarchy when bringing in Account Master Data from an acquired company.
- Analyze data in existing systems to identify quality and completeness issues and to aid with cleanup.
- Identify duplicate Account and Contact data across systems and within systems.
- Transform data into required format for ingestion into various systems.
- Perform ETL operations on new (M&A) or existing data sources Develops, designs, and optimizes complex SQL/T-SQL queries in data analysis and transformation.
- Perform analysis on data from 3rd party providers that will ultimately be used for data enrichment.
- Understand business definitions, rules, and processes around master data to establish data analysis processes that ensure meaningful data.
- Provide support to the MDM Architect on other data related activities as needed.
- Contribute to the data catalog.
- Share administration/configuration duties on the Metadata Management Platform (Collibra).
- Collaborate with the MDM Lead and Global Data Steward on the business side to provide data support.
- Communicate status updates and open issues to both technical and business resources in a manner that can be clearly understood.
- Analyzed SAP transactions to build logical business intelligence model for real-time reporting needs.
- Designed and developed schema data models.
- Built library of models and reusable knowledge-base assets to produce consistent and streamlined business intelligence results.
- Executing projects in an Agile environment
Business Intelligence Analyst
Crack Rich Oil Field Services
Ikeja, Lagos, Nigeria
01.2001 - 05.2011
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Designed customized data collection models for specific visualization tasks.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Maintained proficiency with latest database technologies.
- Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
- Created data analysis tools to allow teams to query acquired information for unique details.
- Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
- Collected data from wide-ranging sources.
- Optimized BI reporting capabilities for secure server environment.
- Responded to specific BI requests from personnel, creating data packets with requested information in easily understandable formats.
- Handled massive quantities of business intelligence data, personally managing as much as 2 terabytes.
- Mapped current business and operational processes and recommended areas for improvement.
- Reviewed files, records and other documents to obtain business information and key data informing responses to development requests.
- Created workflow diagrams and Gantt charts to clearly demonstrate processes and timelines.
- Mapped process activities to identify shortfalls and propose options to rectify operational inefficiencies.
- Collaborated with departments to respond to questions and concerns regarding project details.
- Researched and compiled tailored monthly analytics and reports for senior management with.
- Optimized system and platform performance capabilities in most efficient, practical way possible.
- Diminished process gaps and encouraged optimal productivity by closely supervising workflow of claims analysts and mail clerks.
- Developed metrics derived from raw company data to track improvements in organizational efficiency.
- Increased annual revenue by 10% by recommending improvements in efficiency.
- Established online configuration knowledge base to support functionality by developing robust system application overview.
Education
Ph.D. - Cybersecurity
Northcentral University
San Diego, CA05.2024
Master of Science - Mechanical Engineering
University of Ibadan
Ibadan, Nigeria12.2000
Bachelor of Science - Mechanical Engineering
Obafemi Awolowo University, Ile-Ife.
Ile-Ife, Nigeria.12.1997
Skills
- Query Tools
- Data Synthesizing
- Financial and Economic Data
- Analyzing and ingesting data from CSV and other delimited file formats
- large datasets
- Experience working directly with key business stakeholders
- Experience in collaboration and communication with both technical and business resources
- learning and documenting business definitions, rules, and processed
- Ability to take initiative and work under limited supervision
- XML and JSON
- Data modeling
- Exposure to Metadata Management, Business Glossary, Cataloging, Lineage
- Experience with a Metadata Management Platform (Collibra)
- Experience in executing projects in an Agile environment
- New Market Identification
- Microsoft Excel
- SSRS, Power BI, Tableau
- Requirements Definition
- SQL, Python, MySQL
- Data Modelling
- Data Warehouse - Snowflake, Oracle
- Hardware troubleshooting
- AWS Services
- JIRA for backlog management
- V Lookup, Pivot Tables, X Lookup
- ETL, ELT Operations
- Data Lake Engine – Dremio
- Data Science with R Programming
- Systems Analysis
- Simulation Modeling
- Reusable Knowledge Assets
- Spreadsheet Development
- Compiling Data
- Data Mapping
- Customer Monitoring
- Data Visualization and Presentations
- Variance Analysis
- Statistics and SAS
- Data Integrity Validation
Certification
Scrum Master
Lean SIX-Sigma
Cyber Awareness
Business and Financial Data Modeling
Descriptive Data Analysis
Inferential and Predictive Data Analysis
Experimental Design
Enterprise Decision Making
Timeline
Data Analyst
Emdeda Consulting, Texas
06.2011 - Current
Business Intelligence Analyst
Crack Rich Oil Field Services
01.2001 - 05.2011
Ph.D. - Cybersecurity
Northcentral University
Master of Science - Mechanical Engineering
University of Ibadan
Bachelor of Science - Mechanical Engineering
Obafemi Awolowo University, Ile-Ife.
Similar Profiles
Steven VillarrealSteven Villarreal
Managing Partner at Texas Consulting & DevelopmentManaging Partner at Texas Consulting & Development
NAVARDO BROWNNAVARDO BROWN
Sales Agent at Texas Global ConsultingSales Agent at Texas Global Consulting
Yolanda MejiaYolanda Mejia
Account Manager at Texas Global ConsultingAccount Manager at Texas Global Consulting
Jose TorresJose Torres
Director of Membership Sales at The Club at Falcon PointDirector of Membership Sales at The Club at Falcon Point
Jasmine PrestonJasmine Preston
FC Associate at Amazon Fulfillment Center RICFC Associate at Amazon Fulfillment Center RIC