Rafat Olunloyo

The objective of this role is to provide expert advice and assist with integrating data from multiple systems into 1 database to create fully automated Power BI Reports.

• Design and develop new DI (Data Integration) processes
• Generated 85% performance gain for enterprise BI systems by strengthening OLAP database systems.
• Ensure that the design meets key functional and non-functional requirements and will allow the operational and through-life scenarios required for the solution to be satisfied.
• Deliver a business intelligence function, which enables better capture, analysis, mapping, and reporting of data to inform strategic decision-making and allow for robust measurement.
• Providing technical leadership, coordinating, supporting, and managing the development team in implementation, testing, and end-user adoption.
• Generating data quality control reports to document adherence to study protocols and assist with resolving data inconsistencies.
• Develop standards and methodologies for benchmarking, performance, evaluation, testing, data security, and data privacy
• Lead the team in managing the data pipelines and their robustness and scalability
• Created innovative data capabilities and product features
• Lead data modeling, storage, and design of data maps (ETL/ELT).

During the course of this project, I owned the design and implementation of an integrated data strategy to migrate the procurement function from Tableau to Power BI while translating various other business needs into data requirements which brought in new technology to fine-tune ‘BAU' and other processes.

• Gather and analyze data to develop architectural requirements at the project level.
• Developed solution architecture for the CRM capability of the company, decreasing the delay in data availability by 80% and boosting data availability by 100%.
• Set goals for unified data management practices such as governance, provenance management, meta-data management, stewardship, data quality, and management of lifecycle.
• Improved data integrity with rigorous auditing and cleansing.
• Automated data processing and migration using data bricks and data factory to boost productivity.
• Performed impact analysis, performance tuning, and capacity planning for the enterprise data warehouse and its infrastructure as source systems are added and new integration business rules and logic are introduced
• Established and enforced policies, procedures, standards, methodologies, and metrics for data quality, metadata management, and master data management.
• Migrated data from multiple ERP systems.
• Designed and developed ETL, replication schemes, and query optimization techniques that supported -varied (structured, semi-structured, and unstructured) and high-velocity (near real-time) data processing and delivery
• Ensured the data architecture is optimized for large dataset acquisition, analysis, storage, cleansing, transformation, and reclamation
• Developed and automated Power BI dashboards to provide key business insights and ad-hoc needs.
• Full implementation of cloud (Azure SQL Database, Datafactory, Databricks, Azure DevOps).
• Develop and update technical documentation.
• Providing technical assistance and advice to non-technical stakeholders and colleagues in the wider team.
• Advanced SQL, Excel, and Power BI user.

• The key objective of this role is to support the development of new apps, enhance existing reports and processes for better insight and analysis
• An understanding of the NHS and national policy initiatives to ensure my daily inputs are directed accordingly
• Working knowledge of health service terminology and information requirements
• Knowledge of accessibility standards (W3C) www.w3.org
• Examine data quality to optimize the quality of data collected, resolve data quality problems, and liaise with database developers on data and database designs.
• Using Power BI to create, automate, and maintain COVID-19 dashboards used for essential senior management decisions
• Performed security testing using results to identify and fix vulnerable areas.
• Identify project trends, and provide guidance about patterns to prevent potential failures or delays.
• Worked closely with multiple teams to ensure key KPIs are met on time
• Create Monthly reports and updates packs for public Health England
• Wrote functional specifications for systems developers and completed regular updates to incorporate changes.
• Drive process improvements and standards to reduce downtime and inefficiencies
• Liaise with other teams to improve the use of technology and self-serve reports around teams.
• Process documentation and mapping.
• Data analysis and interpretation to ensure key stakeholders are well-equipped to make life-saving decisions.

• Mainly Responsible for churning data into insights to assist business decisions at the senior level, while analysing campaigns to maximize customer participation
• Used SQL to Cleanse and analyse large data sets to produce meaningful reports and actions to further the business objectives
• Created several self-service dashboards using Power BI and Business Objects to showcase KPIs and performance trends
• Managed the review of promotional spending at William Hill Betting, identifying potential improvements and necessary efficiencies
• Developed and maintain an econometrics model to predict future activities and customer behaviors
• Monitored the daily performance of campaigns and investigated the impact on the core KPIs of the business
• Proactive evaluation and participation of campaign performance during the full run time to ensure targets are met while making live changes as and when required
• Working with CRM teams to help plan campaigns, including setting realistic targets based on previous trends
• Working closely with Fraud, Play Integrity, and AML teams to reduce the use of promotions by abusers, while reviewing all forms of fraudulent activity that may be impacting the organization
• Observe and analyse player behavior and life cycles to be able to send tailored campaigns and optimize the user experience
• Keeping up to date with market trends, competitor behavior, and industry-wide innovations.
• Used Row-level Security to manage data governance.

• Mainly Responsible for keeping a big picture view of trends in the entire EU chain, while evaluating what products to sell, in what shops and when, with the ultimate goal of long-term opportunities and competitive advantage
• Created various data-driven visualization (Power BI),web pages to give better visibility of data to non-technical teams and managers which facilitated better informed decisions at both macro and micro level
• Monitoring the timing and scope of seasonal changes while maintaining the desired inventory levels and assortments
• Used GMROI to develop supply strategies that minimises stockouts while maximising inventory turns
• Lead, Analysed, interpreted and modeled data from a variety of sources to provide analytical solutions to complex business problems
• Managing and prioritizing multiple projects simultaneously with exceptional attention to detail within the team.

• Responsible for managing and deploying £110M in payroll budget to ensure the right colleague was available at every business hour to meet customer and sales demand in Halfords Retail UK and Ireland
• Developed payroll deployment strategies, taking into account constraints and inputs within the business needs saving £5M/year
• Worked with other departments within the business to resolve constraints that impacted working flow to ensure productivity
• Used features of MS Excel, Access and SQL to import and create detailed, interactive reports from a variety of sources for directors
• Oversee multiple data feeds, to ensure highly organised data handling for balanced and error free deadlines
• Transformed large amounts of raw data from a variety of sources (Internal and external) into searchable databases for all stakeholders on timely basis consistently attaining 96-99 % availability goal
• Created artifacts for projects, which include specification documents, data mapping and data analysis documents.