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