Olalekan Sanni

Project: Criminal Justice Information System (CJIS) Data Warehouse Migration Project

• Gathered, defined and refined requirements, led project design and oversaw implementation.
• Worked with various internal stakeholders, collaborating agencies, to define migration requirements and technology stack for projects
• Provided specialized consulting, analytical and technical support
• Defined the data architecture framework, standards, and principles
• Worked closely with infrastructure and cyber teams to ensure data is secure in transit and at rest
• Developed, implemented, and maintained the proposed architecture and pipelines for optimal data migration from various sources
• Ensured data security and compliance during the migration process by implementing Azure security best practices
• Documented data migration procedures, including data mapping, transformation rules, and validation processes
• Implemented CI/CD processes using Azure DevOps for efficient deployment and maintenance of data solutions
• Successfully migrated data to Azure Cloud, enabling enhanced scalability, reliability, and accessibility of data for the organization
• Conducted post-migration validation and testing to verify data integrity, consistency, and system functionality in the new environment
• Conducted data quality assessments and performed data cleansing and deduplication activities to enhance data accuracy and completeness during migration
• Designed and implemented data migration strategies, including data extraction, transformation, and loading (ETL) processes, to facilitate the transition to new systems effectively.

Project: Data Ecosystem Optimization Project

• Lead the architecture, design, and oversaw implementation of modular and scalable data ELT/ETL pipelines and data infrastructure utilizing Kubernetes for container orchestration for the wide range of data sources across the organization using Databricks
• Delivered regular updates to stakeholders regarding project status, milestones achieved, and potential roadblocks encountered.
• Designed curated common data models that offer an integrated, business-centric single source of truth for business intelligence, reporting, and downstream system use
• Worked closely with infrastructure and cyber teams to ensure data is secure in transit and at rest
• Created, guided, and enforced code templates for delivery of data pipelines and transformations for structured, semi-structured and unstructured data sets, using varying programming languages like Python, SQL and Scala
• Developed modeling guidelines that ensure model extensibility and reuse by employing industry standard disciplines for building facts, dimensions, bridge, aggregates, slowly changing dimensions, and other dimensional and fact optimizations
• Established standard database system fields, including primary and natural key combinations that optimize join performance in a multi-domain, multiple subject area physical (structured zone) and semantic model (curated zone)
• Ensured model extensibility by employing industry standard disciplines for building facts, dimensions, bridge, aggregates, slowly changing dimensions, and other dimensional and fact optimizations
• Transformed data and map to more valuable and understandable semantic layer sets for consumption, transitioning from system-centric language to business-centric language using Denodo
• Collaborated with business analysts, data scientists, data engineers, data analysts and solution architects to develop data pipelines to feed our data marketplace
• Introduced new technologies to the environment through research and POCs and prepared POC code designs that can be implemented and produced by developers
• Documented as-built architecture and designs within the product description
• Designed data solutions that enable batch, near-real-time, event-driven, and/or streaming approaches depending on business requirements
• Designed & advised on orchestration of data pipeline execution to ensure data products meet customer latency expectations, dependencies are managed, and datasets are as up to date as possible, with minimal disruption to end-customer use
• Developed workflows and processes following best practices and the cloud architecture
• Ensured that designs are implemented with proper attention to data security, access management, and data cataloging requirements
• Approved pull requests related to production deployments
• Assisted in troubleshooting issues for datasets produced by the team (Tier 3 support), on an as required basis
• Guided data modelers, business analysts and data scientists in the build of models optimized for KPI delivery, actionable feedback/writeback to operational systems and enhancing the predictability of machine learning models and experiments
• Designed and developed scalable web applications using Node.js, Express, and MongoDB, resulting in improved performance and user experience
• Implemented RESTful APIs and integrated third-party services to enhance application functionality and data processing capabilities
• Contributed to the development of microservices architecture and utilized Kubernetes for container orchestration to achieve scalability and reliability
• Actively participated in Agile development methodologies, including daily stand-ups, sprint planning, and retrospective meetings to ensure project alignment and progress tracking
• Stayed up to date with industry trends and technologies to ensure the best practices are implemented.

Project: Data Governance Implementation

• Participated in a comprehensive data governance Initiative focusing on establishing and enforcing data policies, standards, and processes across the organization to ensure data quality, integrity, and compliance with regulatory requirements
• Collaborated with key stakeholders from various departments to define data governance principles, roles, and responsibilities, fostering a data-driven culture and accountability for data assets
• Implemented data quality frameworks and data profiling techniques to assess data accuracy, completeness, and consistency, enabling proactive data management practices and decision-making
• Developed and implemented role-based access controls and encryption techniques to enforce data security measures, restrict unauthorized access, and protect sensitive information in compliance with data privacy regulations
• Prepared notebooks and complex SQL views and stored procedures using Databricks
• Conducted thorough analysis and comparison of logical and physical data architectures to validate alignment with enterprise data architecture standards and identify areas for improvement
• Led the development and execution of data architecture action plans to address inconsistencies and enhance data structure alignment across information systems and databases
• Provided expert guidance and support to solution architects, technical architects, business architects, data stewards, and project teams on data governance best practices, data modeling standards, and data management strategies
• Mentored and coached data modelers, business specialists, development specialists, and database specialists on effective data modeling techniques, tools, and standards to ensure consistency and quality in data governance practices
• Evaluated external vendor products and services to assess their compatibility with the organization's data architecture requirements and support data governance initiatives effectively
• Engaged in daily support and maintenance activities for existing application systems and databases to ensure data integrity, performance optimization, and system reliability in alignment with data governance standards and processes.
• Designed internal process improvements to automate repetitive tasks, shortening data delivery times.

Project: AML Data Warehouse Project

• Spearheaded the design, development, and optimization of a scalable data warehouse solution for anti-money laundering initiatives using Snowflake
• Utilized dbt as the primary transformation tool to automate and streamline data modeling, ETL processes, and data quality checks
• Worked collaboratively with various teck digital systems, teams to deliver a stable and highly available analytics’ reporting platform targeted at Power BI
• Demonstrated advanced experience in gathering data requirements for relational and dimensional data models
• Designed/build and managed Power BI dashboards and reports to be used internally and externally by the agency
• Investigates and resolves production support issues within the scope of Power BI reporting and dashboards
• Built solutions that are supportable, scalable to achieve organization’s aspiration of common assets using Power BI
• Displayed expertise in using advanced-level calculations on the data set using SQL, DAX and M Query
• Involvement in data analysis, including data profiling
• Established role-based access controls and data encryption techniques to restrict user permissions and protect sensitive information
• Participated in the comparison of the logical and physical data architecture to validate conformance of an Information System with the enterprise data architecture
• Prepared action plan to address data architecture inconsistency that may occur in comparison analysis of the logical and physical data architecture
• Participated in Unit Testing, Integration Testing, Performance Testing, User Acceptance Testing of Cooperate Procurement Analytics application
• Provided data architectural support and expertise to Solution Architects, Technical Architects, Business Architects, Data Stewards, and diverse project teams
• Implemented data encryption techniques and enforced secure access controls using Kubernetes to enhance data security measures during the migration process
• Estimated work effort, duration, resources, and cost for data architectural activities
• Guide and mentor data modelers, business specialists, development specialists, and database specialists on data modeling standards, techniques, and tools
• Participated in analyzing, understanding, and assessment of external vendor's products or services to determine their applicability in either applications or enterprise-wide support of the data architecture
• Provided daily support and maintenance of the existing application systems and databases
• Stayed up to date with industry trends and technologies to ensure the best practices are implemented.

Project: Liquor Distribution Data Warehouse Project Snowflakes

• Designed and implemented a cutting-edge data architecture using Snowflake, the cloud data platform, for liquor distribution data warehouse project
• Leveraged snowflake's scalable architecture and performance capabilities to optimize data processing and analytics for the distribution industry
• Implemented robust data security measures within Snowflake to ensure the protection of sensitive information related to liquor distribution
• Developed data models and schema structures in Snowflake to facilitate efficient data storage, retrieval, and analysis for decision-making.

Project: Well Services Streaming Analytics Project

• Spearheaded the implementation of a cutting-edge well service streaming analytics project, utilizing Kubernetes for container orchestration to enhance real-time data analysis and decision-making processes
• Actively participated in the implementation of a cutting-edge Well Service Streaming Analytics project, utilizing Apama by Software AG, SQLstream, and SSRS to enhance real-time data analysis and decision-making processes for well service operations
• Designed and implemented a scalable and efficient data architecture using Apama and SQLstream to capture, process, and analyze streaming data from well service operations, ensuring high performance and real-time insights
• Utilized Tableau to develop customized reports and dashboards that provided stakeholders with actionable insights and visualizations based on real-time streaming data
• Implemented master data management practices to ensure data accuracy and consistency across the organization, aligning with data governance initiatives and best practices
• Conducted performance optimization and tuning of the streaming analytics platform, leveraging the capabilities of Apama and SQLstream to enhance data processing speed and efficiency
• Provided mentorship and guidance to junior team members on the utilization of Apama, SQLstream, and Tableau for streaming analytics projects, fostering a culture of innovation and knowledge sharing within the organization
• Conducted regular data quality assessments and audits to identify and address data inconsistencies, anomalies, and discrepancies in the streaming analytics data sets
• Participated in Unit Testing, Integration Testing, Performance Testing, User Acceptance Testing of Well Services Streaming Solution
• Actively participated in the definition of data governance policies and procedures to support data quality and compliance requirements, ensuring alignment with industry standards and regulations
• Implemented data security measures and access controls to protect sensitive data within the streaming analytics platform, ensuring data privacy and confidentiality
• Collaborated with stakeholders to define key performance indicators (KPIs) and metrics for monitoring and evaluating the success of the streaming analytics project, providing actionable insights for decision-making
• Presented findings and insights from the streaming analytics project to senior management and key stakeholders, highlighting the impact on operational efficiency and business performance
• Evaluated emerging technologies and trends in the streaming analytics space to identify opportunities for innovation and continuous improvement within the organization.

Project: Corporate Credit Card Reporting and Dashboards

• Produced project plan, cost estimate and implementation strategy to stakeholders
• Facilitated requirements gathering and brainstorming sessions with stakeholders
• Managed the end-to-end development cycle of Power BI reports from concept to deployment
• Processed and managed large quantities of data through Python, SQL, DAX, and other languages to support the back-end data needs for our business intelligence applications
• Designed, developed, and implemented Corporate Procurement warehouse Dashboards
• Continually enhanced the usability and performance of our Power BI dashboards and reporting solutions
• Wrote optimized Python and SQL queries, data extraction scripts across multiple data sources (Lawson, Oracle Peoplesoft, SAP ERP, SQL Server)
• Developed and updated technical documentation for BI/Power BI solutions
• Liaised with SAP team, Stakeholders to identify Source to Target Mapping of data, data extraction and transformation for the realization of the project
• Continuously enhanced the usability and performance of Power BI dashboards and reporting solutions using Kubernetes for efficient deployment and maintenance
• Conducted training for business users on the use of Power BI and Tableau Dashboards
• Implemented data security measures to protect sensitive financial data and ensure compliance with industry regulations.

Project: Material Management Analytics Database

• Actively participated in requirements gathering and brainstorming sessions for realization of business loan document processing system
• Translated complex functional and technical requirements into detailed design, and high performing end to end data pipelines
• Participated in analyzing, designing, and implementation of MMA data warehouse from conceptual stage to production stage using Ralph Kimball design approach
• Analyzed, designed, and created de-normalized dimension tables, fact tables and entity-relationship using SQL Server database diagram, star and snowflake schema dimensional modeling approach
• Documented and maintained all material management related business processes and procedures
• Created database objects for MMA with strong understanding of data modeling and entity relationship modelling
• Implemented advanced data security protocols to protect critical inventory data and prevent unauthorized access
• Maintained data models as well as metadata and documentation such as data glossaries and catalogs, data mappings, data lineage and data classifications
• Performed data integration to Microsoft Azure Cloud using Microsoft Azure Data Factory Integration Runtime with SSIS package
• Contributed to iterative testing and Quality Assurance
• Investigated unused or new SAP functionality and recommended enhancements or process improvements as appropriate
• Acted as a link between SAP Material Management Users and Information Technology team or external consultants on enhancements, new reports, queries, printed forms, interfaces, etc
• Conducted performance tuning, maintenance, support and backup for MS SQL Server databases and Oracle DB
• Provided daily support and maintenance of the existing application systems and databases
• Stayed up to date with industry trends and technologies to ensure the best practices are implemented.

Project: Data Insight Evolution Initiative

• Facilitated requirements gathering and brainstorming sessions with stakeholders
• Conducted solution analysis and recommendations projects to advise different business areas on the best reporting solutions
• Presented findings and recommendations to business stakeholders, driving informed decision-making and improving reporting efficiency
• Demonstrated expertise in evaluating reporting tools and technologies to identify the most suitable solutions for specific business use cases
• Led the migration project to transition reporting solutions from SSRS to Tableau, resulting in enhanced data insights and user engagement
• Successfully converted SSRS reports to Tableau reports, improving data visualization and interactivity for end users
• Contributed to the development of standardized reporting practices and guidelines to ensure consistency and accuracy in reporting across the organization
• Collaborated with team members to develop Tableau solutions that meet business requirements and drive data-driven decision-making
• Participated in training sessions or workshops to enhance Tableau skills and stay updated on new features and functionalities.

Project: Implementation of Applications Processing/Cost Monitoring Analysis (APCM) Data Warehouse

• Actively participated in requirements gathering and brainstorming sessions for realization of business loan document processing system
• Analyzed, designed, and implemented APCM data warehouse from conceptual stage to production stage using Ralph Kimball design approach
• Analyzed, designed, and created de-normalized dimension tables, fact tables and entity-relationship using SQL Server database diagram and star and snowflake schema dimensional modeling approach
• Created SQL Objects (Tables, Views, Store Procedures, Triggers, Functions, and Indexes) and T-SQL scripting
• Designed and implemented SCD type 1 and 2 on APCM dimension tables using slowly changing dimension using SSIS data flow transformation
• Spearheaded the implementation of a robust data architecture for a banking loan application project, ensuring efficient data management and security protocols
• Developed and implemented data security measures to safeguard sensitive customer information and comply with regulatory requirements
• Created, scheduled, and monitored SQL Server agent jobs for APCM SSIS packages and T-SQL scripts
• Performed data integration to Microsoft Azure Cloud using Microsoft Azure Data Factory Integration Runtime with SSIS package
• Created hierarchies and attributes relationship on dimensions, and perspectives on cubes using SSAS
• Developed and delivered a robust Business Analytics framework, using DAX, SSAS Tabular model and well aligned with the company’s long-term strategic goals for data architecture vision
• Performed Data integration to Microsoft Azure Cloud using Microsoft Azure Data Factory Integration Runtime with SSIS package
• Conducted performance tuning, maintenance, support and backup for MS SQL Server databases and Oracle DB
• Constantly ensuring that reporting and business analytics strategies and architectures are in regulatory compliance
• Developed and produced Standard System Test documents for Control framework
• Participated in Unit Testing, Integration Testing, Performance Testing, User Acceptance Testing of APCM
• Provided technical assistance and support to the Project Team and End Users
• Collected and presented the KPI data to CEO, Directors, and managers on a quarterly basis, using Power BI.

Project: Implementation of Business Loan Processing System

• Initiated and lead requirements gathering and brainstorming sessions for realization of Business Loan Document Processing System Project
• Designed, developed, implemented, and installed defined Microsoft SQL Server database systems and maintained enterprise level database systems in a multi-server environment
• Designed, developed, adapted, and maintained data warehouse architecture and relational databases that supported data mining
• Analyzed and produced software requirements specifications, use cases, system prototypes, and functional specifications of Business Loan Document Processing System
• Designed and delivered automated report solutions that summarize and transform data from various data sources into understandable, actionable information, using MS SQL, T-SQL, SSIS, SSAS, SSRS, Tableau and POWER BI
• Designed and produced dimension and conformed dimension tables based on data warehouse bus matrix, and fact tables using star and snowflake schema dimensional modeling
• Designed and deployed Multidimensional cubes using SSAS, MDX and T-SQL
• Liaised with Change and Release Management teams in deployment and maintenance of application systems
• Test and Deployed 14 multidimensional analytic databases with over 75 calculated measures and dimensions using SSAS, MDX, T-SQL
• Design, developed, tested, and deployed Multidimensional Analytic Service Cancellation cubes with drill across to Dispatch measures using SSAS, MDX, T-SQL
• Participated in Unit Testing, Integration Testing, Performance Testing, User Acceptance Testing of Business Loan Processing System
• Developed, designed, and deployed complex and enhanced 28 dashboards with over 126 reports using SSRS, SSAS, Tableau, Power view, Power BI, Excel 2013 PowerPivot, T-SQL, SharePoint 2013
• Advised and assisted developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.)
• Applied data modeling techniques to ensure development and implementation efforts meet application integration, performance, and scalability expectation
• Provided daily support and maintenance of the existing application systems and databases
• Designed and Developed data models by sourcing data from various sources – On prem, Cloud, flat file etc., that can cater development of canned reports as well as self-serve reporting model, using Power BI
• Conceptualized business needs into insightful/interactive dashboards and reports in Power BI
• Stayed up to date with industry trends and technologies to ensure the best practices are implemented.

Project: Migration and Consolidation of Know Your Customer (KYC) Systems Data from 8,274 protected MSACCESS 97 Databases to MS SQL Server 2008 database

• Participated in requirements gathering and brainstorming sessions
• Participated in analyzing existing KYC policies, guidelines and procedures and proposed new KYC policies, guidelines and procedures that are consistent with the Nigeria government regulations
• Performed Gap Assessment of the required information that will be needed for customer accounts
• Documented the analysis outcome using workflow diagramming, use case analysis, process mapping and conceptual information and data modeling
• Actively participated in all phases of Software Development Lifecycle including requirement gathering, analysis, solution design, configuration, development, testing and support
• Maintained awareness of pertinent client information, future, payment performance and communicated client information that may affect company’s decisions to appropriate departments as needed
• Applied Agile change management process and tools to create a strategy to support adoption of the changes required by stakeholders
• Partnered with business and technology stakeholders to improve collaboration and overall alignment
• Created scope documents, wrote business requirement documents, and documented functional specifications in the form of user stories
• Liaised with technical users to assist with the translation of business requirements into technical solutions for those developing and supporting the new platform
• Participated in Unit Testing, Integration Testing, Performance Testing, User Acceptance Testing of Know Your Customer system
• Actively participated in user acceptance testing activities including defining approach, planning, coordination, and supporting business users to ensure deliverables meet business expectations
• Provided input, documented requirements, and supported the design and delivery of training programs
• Stayed up to date with industry trends and technologies to ensure the best practices are implemented.