OLUWAFEMI IBITOYE

● Create business functional requirement documents and Identify general data sources in profiling data, base on the business requirement and document data flows, including the development of mapping rules to standardize implementing of business solution such as (Stake holder matrix, bus matrix and source to target mapping) ● Designed and maintained scalable data pipelines to support reporting, modeling, and decision-making across the ministry ● Built data migration workflows from on-premises to the cloud using Azure Data Factory, leveraging Parquet files for efficient storage and processing ● Created automated triggers to orchestrate and schedule daily pipeline executions ● Established secure data handshakes between Azure Data Lake and Snowflake, using external stages to ingest files as Snowflake tables ● Developed robust transformation logic using dbt, including use of macros to implement dimensional modeling and automate fact table creation ● Applied dimensional modeling principles, SCD strategies, and surrogate key implementations within enterprise data warehouse environments ● Built CI/CD pipelines using Git (via Ubuntu), managing feature branches and commits integrated with DataHub for metadata tracking ● Containerized dbt transformations using Docker, and scheduled deployments using cron (scontab) for automated workflows ● Implemented data quality checks, profiling, and governance strategies for sensitive data in a public-sector context ● Collaborated with cross-functional teams to deliver centralized, maintainable, and auditable data infrastructure solutions ● Utilized ER/Studio for data modeling and metadata management, ensuring alignment with business requirements and standards

● End to end building enterprise data warehousing (EDW) using both relational, dimensional and snowflake modeling ● Design and develop T-SQL queries and SQL Server stored procedures, functions, views and triggers to be used during the ETL process. ● Designed, built, and maintained ETL processes to support data extraction, transformation, and loading from various sources. ● Developed and implemented physical database structures and operational data stores based on logical data models. ● Utilized programming and scripting languages such as T-SQL for data manipulation and analysis. ● Supported the creation and maintenance of database systems and data structures (Data patches) ● Provided technical support and troubleshooting/investigation for data-related issues in data warehouse. ● Designed and maintained data pipelines using Azure Data Factory (ADF) to transform and load data from disparate systems into centralized data warehouses. ● Utilize Azure DevOps as well as Microsoft Tasks to manage user feedback and track new and ongoing work. ● Created and optimized SQL queries for data extraction, transformation, and analysis, improving data accuracy and reporting speed. ● Built and maintained data pipelines on the MS Azure platform, enabling the seamless consumption of structured and unstructured data from various sources using Azure Data Factory and Databricks. ● Building data transformation rules base on the source to target mapping and the creation of SSIS packages ● Develop, design, tune and maintain SSIS packages to perform ETL processes. ● Leveraged data warehouse concepts including Star schema, Snowflake schema, and Slowly Changing Dimensions (SCD) Types to ensure efficient and effective data storage and retrieval.

● Designed, built, and maintained ETL processes to support data extraction, transformation, and loading from various sources. ● Created and optimized data pipelines and data sets to enhance data quality and efficiency. ● Developed and implemented physical database structures and operational data stores based on logical data models. ● Utilized programming and scripting languages such as T-SQL for data manipulation and analysis. ● Collaborated with cross-functional teams in an agile environment to support and improve data-related projects. ● Conducted analyses on internal and external data to identify opportunities for data quality improvement. ● Assisted in the development and optimization of ETL processes and data pipelines. ● Supported the creation and maintenance of database systems and data structures (Data patches) ● Participated in team meetings and contributed to project planning and execution. ● Provided technical support and troubleshooting/investigation for data-related issues in data warehouse. ● Build Reports and Visualization in (SSRS)

● Create business functional requirement documents and Identify general data sources in profiling data, base on the business requirement and document data flows, including the development of mapping rules to standardize implementing of business solution such as (Stake holder matrix, bus matrix and source to target mapping) ● Designs, develops and Implement Relational Data warehousing with conceptual, logical and physical Modeling ● End to end building enterprise data warehousing (EDW) using both relational, dimensional and snowflake modeling ● Data verse which includes building data transformation rules base on the source to target mapping and the creation of SSIS packages ● Create and manage Pipelines to deploy SSIS projects to SQL Server instances ● Manage the run of SSIS packages from a job scheduler through agent server ● Design and develop large and complex data warehouse architecture including sourcing of new data sources, develop and test extraction, transformation, and load (ETL) processes to ensure delivery of source system data to the data warehouse in the appropriate format ● Create reports and dashboards to communicate key metrics and insights to stakeholders. ● Participate in reverse-engineer by profiling source system structures for EDW using source to target mapping ● Development of a data warehouse and a data lake for structured and unstructured data respectively. ● Responsible for data modeling, system and data analysis, design and development for applications, data marts & semantic layer to support analytics and reporting needs. ● Oversee end-to-end ownership of data projects and independently collaborate with engineering, product and business stakeholders in an agile environment to solve business problems using stakes holder matrix ● Analyze complex data sets, identify trends, and communicate insights to stakeholders

● Understanding and Identify business processes and business requirements ● Translates customer requirements into functional requirements in a clear and concise manner using conceptual, bubble chart or white board ● Analyze source systems to understand both the business domain environment that the systems support and the technical environment in which they operate ● Identify general data sources and document data flows, including the development of mapping rules to standardize such as Stake holder matrix, bus matrix and source to target mapping) in implementing business solution ● End to end building enterprise data warehousing (EDW) using both relational and dimensional modeling ● Develop and test extraction, transformation, and load (ETL) processes. Deliver source system data to the data warehouse in the appropriate format. ● Design and develop T-SQL queries and SQL Server stored procedures, functions, views and triggers to be used during the ETL process. ● Data verse which includes building data transformation rules base on the source to target mapping and the creation of SSIS packages ● Create and manage Pipelines to deploy SSIS projects to SQL Server instances ● Develop, design, tune and maintain SSIS packages to perform ETL processes. ● Troubleshoot performance issues such as evaluating execution plans, indexing and provide technical leadership and recommendations ● Write scripts for automated testing of data quality, data completeness and business logic. ● Provide insights and direction to field representatives, management, and executives. ● Develop and implement systems and tools to support and enable leaders and key stakeholders to take strategic action in a dynamic competitive retail environment. ● Lead all enterprise retail analytic initiatives, from performance metric definition to reporting implementation, to attract and retain customers. ● Translate technical data into user-friendly language for stakeholders at all levels.

● Led the development of a reporting solution suite containing 16 Power BI reports for Globacom using Microsoft's latest in-memory database technology. ● Developed complex SQL queries using 14 procedures, including Common Table Expression (CTE), to support Power BI and SSRS reports. ● Provided continued maintenance and development of bug fixes for existing and new Power BI reports twice a month for 2 years. ● Investigated applying 11 intelligent decision-support systems to facilitate management decision-making. ● Utilized data mining, OLAP, and statistical analysis software to determine 35 market trends

 Proper implementation of VAP3; which implies visibility through branding materials, availability of product in the dealer’s, sub-dealer’s and retailer’s outlet within the territory. Promotion, placement and pricing to enhance sales and revenue in the assigned cluster.  Increase the number of Data partners/ Dealers from seven to twelve  Grow regional revenue from 216 Million in Dec 2018 to 405 Million in Aug 2019 (187% Growth)  Maintained network hygiene within the region through proactive network escalation to appropriate channel and thereby resolving bottleneck on the network  Monitor market/industry trends and communicate relevant items to the Executive Committee and other relevant personnel  Ensure the company’s corporate image is maintained, and best interests are served, at events such as open houses, facility tours, presentations, tradeshows, conferences, etc.  Identify opportunities to up-see and cross-sell  Ensuring constant delivery of monthly KPIs  Prospect and generate new business in new markets and territories  Provide regular forecasting and sales pipeline updates in the (Customer Relationship Management)  Qualify opportunities quickly and control and close sales  Build and maintain ongoing awareness of new products and services, competitor activities, and other research.

Task Performed: • Help in preparation of MEMO. • Participate in selection of new intakes. • Help to generate matriculation number for the new intakes. • Help to prepare the budget for the unit. • Help to dispatch the outgoing MEMO. • Help to manage/organize the students file. • Help in attending to those that came for Admission enquiry.