Photo

Olatunde Ola Senior BI and Data Analytics Consultant

Lagos Nigeria
hivePython – 3 years HadoopSpark – 3 Years Team Management – 12 Years Leadership and mentorship – 12 Years Project Management – 6 YearsSQL

Resume
Olatunde OLA
Senior BI and Data Analytics Consultant
Unit 22 Fountain View, 14th Road, Midrand, Johannesburg.
Tel: +27 78 442 8292, +234 818 100 0016
Email: [email protected]

Career Summary
I am an ICT professional with more than 18 years of Technical and Management experience in Technology, Telecommunication and financial Industries in database development, solution architecture, data analytics, Data warehousing, Business Intelligence, Data Governance and Solution Delivery.
I have over 10 years’ hand-on experience delivering Business Intelligence, Data Warehouse, Data Modelling, ETL and Data Analytics and 7+ years demonstrated experience building, inspiring, leading and managing high performing teams as well as working with stakeholders to mine, analyze and identify opportunities for leveraging data to drive business solutions, optimization and improvement in product development, marketing techniques and business strategies and decisions .
Skills
 Data Analytics
 Data Architecture
 Data warehousing
 Solution Architecture (TOGAF)
 Business Intelligence
 Big Data Hadoop
 Data Visualization
 Master Data Management
 Data Mining
 ETL/ELT Development
 Data Integration
 Data Quality
 Unix & PERL scripting
 Scala , Python, Java/J2EE
 Data Governance  Oracle PL/SQL
 MS SQL Server
 Oracle Database Dev
 Machine Learning
 Hadoop, Hive, Spark
 Advanced Analytics
 Team Management
 Leadership & Mentorship
 Project Management

Work Experience
Company : PBT Group (Nigeria) Location: Lagos, Nigeria
Job Title: BI Technical Lead/Solution Architect Period: May 2017 – Date
Duties;
 Translating business requirements into Business Intelligence Reporting ,Analytic methods and building analytic models, automating and maintaining Business Intelligence Processing and Modelling as part of Data Management Operations tasks
 Provide Business Intelligence and Analytics expertise with end-to-end delivery responsibility to generate information and provide analysis that support customer management, planning and activities to meet MTN strategic requirements
 Identify key trends in large datasets and interact with business to understand the impact of these trends and identify possible courses of action to mitigate / take advantage of the trends identified
 Provide business intelligence and Data Analytics services by utilizing various tools and drawing on proven proficiency/ experience (including all aspects of the architecture of cube/report design, creation, storage and access).
 Manage all aspects of the data extraction, BI Reporting, Data Modelling whilst identifying new initiatives and/or making recommendations for channel growth and new opportunities.
 Design and implement ETL/ELT technologies and the integration with BI and big data Platforms
 Develop, implement and manage the processes for metadata (i.e. data about data) associated with the data on the BI platform. Develop and implement the end-to-end governance framework and model for creating, controlling and enhancing metadata on the BI platform.
 Provide Technical leadership to entire BI processes of both structured and unstructured data to team members and consultants
 Provide technical guidance and mentoring to junior consultants in best practices in Business Intelligence
 Develop, implement and manage the processes to assess data quality and diagnose and report issues for correction. Using data profiling and data quality monitoring & reporting tools, measure completeness, timeliness, accuracy, consistency, relevance and integrity, ensuring data is fit for its intended uses on the BI platform
 Champion data quality, integrity and reliability throughout the department by designing and promoting best practices
Company : Triversa Solutions Limited Location: Lagos, Nigeria
Job Title: Lead Solution Architect – BI and Data Analytics Period: Oct 2015 – May 2017
Duties;
 Develop physical data management architectures, policies, and practices and oversee the execution of procedures to manage data across its lifecycle on the BI platform from acquisition to consumption
 Create architecture and technical design documents to communicate BI solutions and Analytical Models that will be implemented by the development team.
 Translating business requirements into Business Intelligence Reporting ,Analytic methods and building analytic models, automating and maintaining Business Intelligence Processing and Modelling as part of Data Management Operations tasks
 Develop strategies and programs to collect, store, analyze and visualize data from various sources for specific SAS Solutions projects i.e. Financial Crime, Anti-money laundering (AML) , SAS GRC Solution, KYC, Customer Due Diligence etc.
 Plan and run workshops and meetings, to clarify business drivers, requirements, and establish
Email: [email protected] Tel: +27 78 442 8292, +234 818 100 0016 Page: 3
overall business environment for the solution.
 Extract data from a variety of relational databases, manipulate, explore data using quantitative, statistical and visualization tools (SAS Visual Analytics)
 Inform the selection of appropriate modeling techniques to ensure that predictive models are developed using rigorous statistical processes
 Motivate for new requirements for the data environment and the coordination of projects in conjunction with the Project Office in terms of scoping, planning, and prioritizing.
 Maintain accountability for supporting the Data Architecture vision and championing efforts to reach that vision.
 Provide Data framework, governance and roadmap to attain the enterprise data vision.
 Collaborating across business segments to both find opportunities for and showcase ideas in the Innovation and emerging business pipeline
 Evaluate and present information that will facilitate effective and timely decision-making through written and oral communication materials that effectively summarize findings with recommendations.
 develop and execute an analytical roadmap that includes: Key Metric, scorecard and dashboard development; Customer Segmentation and profiling using SAS Analytics tool
Company : Tritech Technologies Limited Location: Lagos, Nigeria
Job Title: Senior Solutions Architect Period: Dec. 2012 – May 2017
Duties;
 Responsible for translating business requirements into specific systems, applications or process designs for very large complex IT solutions and integrating architecture
 Define and lead appropriate Enterprise Architecture, Business Intelligence, process innovation, and data management interventions.
 Accountable for integration of the IT Infrastructure Architecture and roadmaps to align and synchronize with application architecture roadmaps
 Provides pre-sales support to Sales team focusing on mid-size and enterprise accounts in areas including but not limited to:
o Technical solution design and validation
o RFP & RFI response
o Professional Service Statements of Work creation
 Translate business requirements into technical specifications for development and support purposes
 Provides direction for design activities, using deep experience in enterprise-class IT infrastructure engineering in Server, virtualization, network, storage , Application and Database Grid
 Manage all aspects of the data sourcing, migration, modelling and implementation and identify new initiatives and recommendations for database growth and integration.
 Establish and coordinate a data Task Force with regular feedback or communication to senior management on profess and future pipeline work.
 Participate as a key technical resource during project implementations, and provide authoritative technical guidance to the customer and project team.
 Developing strong working relationships with clients at all level to ensure overall project satisfaction and to manage expectations regarding functionality and deliverables.
 Help define, manage, drive and meet project milestones and deadlines, with emphasis on
Email: [email protected] Tel: +27 78 442 8292, +234 818 100 0016 Page: 4
avoiding over-runs.
 Drive implementation issue resolution as reported by the project team and customer, by providing hands-on troubleshooting support.
 Lead transition activities to ensure that all resources assigned to the project are appropriately prepared.
 Define relevant test scenarios to thoroughly vet the ability of the solution to meet its intended requirements.
Company : Emagine International Pty Location: Sydney, Australia
Job Title: Senior Technical Operations Consultant Period: June, 2010 – Dec 2012
Duties;
 Responsible for supporting and managing Emagine Closed-Loop Marketing Suite (Campaign Management and Loyalty System) as well as applications’ database system.
 Working closely with Customer Value Management Team to develop, prioritize and execute a roadmap for reporting and analytics (including dashboards, customer segmentation and profiling).
 Develop, test & implement ETL job logic and complex ETL packages and ensure that operational delivery of system outputs are met
 Identify and recommend campaign opportunities to Customer Value Management Team and ensure the campaign-to-market process is managed to a high standard and within SLA
 Ensures & monitors that processes are in place to pro-actively protect consistent service quality through rigorous management of change control & acceptance into service procedures in line with Company Service Delivery
 Provides expert problem management support to difficult, high profile customer issues and ensures root- cause analysis is conducted and a corrective action plan
 Design and implement solutions for campaign requirements using Emagine Closed-Loop Marketing Suite (Campaign Management and Loyalty System)
 Develop guidelines for database administration duties within IT based on industry’s best practices
 design and development using Oracle, PL/SQL code and hands on Unix/Perl scripting
 Design dashboards and ad hoc reports for analyzing and interpreting campaign outcomes
 Writing/Tuning data ingestion procedures from external suppliers and partners using PL/SQL, SQL loader, 3rd party tools
Company : Globacom Limited Location: Lagos, Nigeria
Job Title: Senior. Applications Specialist Period: Mar, 2006 – June 2010
Duties;
 Responsible for supporting and leading cross-functional teams in the development, implementation, and maintenance of Customer Care Applications as well as applications database system
 Provide technical leadership in Oracle Database Administration to the DBA team and the Development Team as well
 Develop custom applications components to meet functional requirements using PL/SQL and Unix scripting
 Responsible for designing and implementing an Enterprise Integration Solution to facilitate
Email: [email protected] Tel: +27 78 442 8292, +234 818 100 0016 Page: 5
bulk import of legacy data or other databases into Siebel CRM production databases
 Building custom reporting tool to execute database queries on Siebel CRM back-end oracle databases
 Manage all aspects of the data sourcing, migration, modelling and implementation and identify new initiatives and recommendations for database growth and integration
 Design and Develop extraction routines (ETL), builds, schemas and scripts for system data, delivered in a timely manner into application database system with minimal impact on the business users in line with industry standards
 Analyze and map business and IT processes into business requirements and Siebel system functionality
 Provide technical assistance to all levels of support team by providing specific application expertise
 Allocating system storage and planning future storage requirements for the database Systems
 problem diagnosis, performance tuning and capacity planning
 Design, develop, implement, and support the enterprise database management systems
 Translate Business and functional requirements into Siebel Technical Design (Detail Design / Low-Level Design)

Company : Phoenix of Nig. Assurance Plc Location: Lagos, Nigeria
Job Title: Manager, Management Information System Period: Mar, 1997– Jan, 2006
Duties;
 Coordinate and Manage the activities and staff responsible for application development, database Administration and Business Intelligence/reporting
 Manage data quality within the reporting environment
 Design and Develop subject specific Data Marts as part of the MIS Team
 Design and Develop Data Marts to comply with the reporting architecture and IT strategy assisting in the resolution of day-to-day Data warehouse and Business Intelligence application issues
 Design and Develop extraction routines, builds, schemas and scripts for system data, delivered in a timely manner, which will cause minimum impact on the business in line with industry standards
 Develop, test & implement ETL job logic and Ensure that operational delivery of system outputs are met
 Define IT strategy to support and sustain business growth, continuity, and productivity.
 Analyze business requirements and develop process Model for application development
 Responsible for all phases of Application development life cycle (SDLC), deployment and training of users.
 Develop and manage Client/server (Browser-based and Desktop) Application Software
 Design and development of Database structure for applications software and Database Administration
 Develops application and database specifications in consultation with users and other team members,
 Develop stored procedures/Triggers and implementation scripts (batch scripts) for applications or data migrations
 Developing query and report routines to meet specific needs, updating and maintaining corporate internet and intranet web sites

Company : Datalink Systems Limited Location: Lagos, Nigeria
Job Title: System Analyst and Programmer Period: June, 1996 – Mar 1997
Duties;
 Analyze business requirements and develop process model for application development
 Developing and managing applications for companies/clients
 Carry out Support services for companies. Services include application development, database design, networking, and technology support.
 Drive the delivery of solutions as agreed with our client;
 Develop detailed technical specifications from functional descriptions (design)
 Deliver development within agreed timelines
 Perform unit testing from a pre-defined test plan
 Update/amend test plans according to solution development to ensure coverage of all business requirements
Education
 Federal University of Technology, Akure, Ondo State
Master of Technology (M.Tech) in Computer Science, 2006
Postgraduate Diploma (PGD) in Computer Science, 1999
 Yaba College of Technology, Yaba Lagos
Higher National Diploma (HND) in Computer Science 1995
National Diploma (ND) in Computer Science 1991
 Comprehensive High School, Agidi, Ketu, Lagos
West African School Certificate Examination 1988
Professional Certification/ Membership
 Oracle 10g Real Application Clusters Certified Expert (OCE)
 Oracle 10g Certified Professional (OCP)
 Institute of Information Technology Professionals South Africa (IITPSA)
(Full Member) Credential ID O081289
 Project Management Professional (PMP) – In View
(Membership ID: 1541554 )
Projects
 Technical Lead, SAS Enterprise Case Management (ECM) deployment , configuration and administration at Zenith Bank (completed)
 Technical Lead, SAS Fraud and Compliance management and data integration with the core banking application in zenith bank(completed)
 Technical Lead, SAS Anti-Money Laundering Solution and data integration with the core banking application in zenith bank (completed)
 Technical Lead, SAS Anti-Money Laundering Upgrade from version 4.2 to 7.1 and data integration with the core banking application in Skye Bank (On-going)
 Technical Lead/Architect, Development of Failed Bank Database System (FBDS) application to manage liquidated Bank in NDIC Lagos (On-going).
 Lead Architect, Enterprise Architecture Maturity Assessment and EA Practice in FCMB Lagos
Email: [email protected] Tel: +27 78 442 8292, +234 818 100 0016 Page: 7
Languages
 English
Training
 Enterprise Architecture for Practitioners EAFP TOGAF , November 2016
 PMI Project Management Training, J K Michael Consulting, November 2012
 Oracle Database 10g: Real Application Clusters , November 2009
 Oracle Database 10g backup and Recovery , November 2009
 Oracle Database 11g Training , November 2009
 Siebel 8.0 CRM Essentials Course , October 2008
 Change Management Workshop , May 2005