SUMMARY:

• I have been able to successfully deliver Business Intelligence (BI), Data Warehouse (DW), ETL, data migration, and data modelling project milestones with input from my significant knowledge in tools and technologies including Python, T - SQL, SQL Server 2000/2005/2008/2012/2016, Microsoft Azure database\s, cube and dimensions development and maintenance, PL/SQL, Oracle 8i/9i/10g, UML, Extract Transform and Load (ETL) Processes, SSIS, DTS, SSAS, MDX, SSRS, PL/SQL and T-SQL scripting. I also have vast experience in data transfer between systems, data migration processes and the use of XML and MS Excel VBA. Though this is no longer the core tasks I do, in the past, I have successfully managed databases and I have knowledge of database cloning processes, database maintenance and support and performance monitoring/reviews. I achieved the Microsoft Certified Information Technology Professional (MCITP) - Designing a Business Intelligence Infrastructure, the Microsoft Certified Technology Specialist (MCTS): SQL Server Business Intelligence Development and Maintenance, the Microsoft Certified Technology Specialist (MCTS): SQL Server Implementation and Maintenance. I have also attended a course on The Open Group Architecture Framework (TOGAF 9) in addition to the Integrated Architecture Framework (IAF) that I got from Capgemini University, France. I attended the Cloudera Developer for Apache Hadoop boot camp courses on Big Data (BigData) development from a Cloudera certified vendor - ExitCertified Canada. The course covered working with MapReduce jobs, Impala, Hive (including HiveQL), and Pig (including Pig Latin). The relevant Cloudera exams are in view.
• Over the years, I have built up IT project management experience and do have knowledge of the PRINCE2 and PMP project management methodologies. I have successfully delivered or was a part of the delivery of multi-million dollars projects within controlled environments. I have achieved the PMP status and the PRINCE2 foundation and practitioner levels. I’m well versed in IT service management and once achieved the ITIL Foundation . As part of my continuing, I attended the intensive course on successful change management in the University of Oxford, UK. I also attended the intensive course on advanced project, programme and portfolio management in the same University. Later, I attended the course on Negotiation and Dispute Resolution for Project Managers and the course on Making Projects Work in the Confidential . I have a good working knowledge of the Microsoft Project and Microsoft Visio Software. Recently, I attended the PMI Seminars World course titled “Measuring the Performance of Projects Initiatives: An Important Step in Benefits Realization”. I consider myself to be a self-dependent worker, with superb and coordinated problem investigation skills - I have been able to resolve intricate and controversial challenges and provide leadership and strategic vision.

PROFESSIONAL EXPERIENCE:

Confidential

IT Director

Responsibilities:

• Specialties: IT/IS Management, IT/IS Project Management, Business Intelligence and reporting solutions implementation, cloud solutions implementation and management.
• Managing the IT department and reporting to the Chief Operating Officer. I setup a formal IT department for the fast-growing organization; they didn’t have an IT department before my arrival.
• Performing data migration, data modelling and software development related tasks.
• Leading the organizations technology projects initiative that comprises of over 9 IT related implementation projects. A consultant/project manager and some tech staff support me on these projects. The details of the projects are as follows:
• Setup of Microsoft Azure server. Migrated data to Microsoft Azure data and SQL server. Build and maintain database solutions on the SQL Azure server. These includes development and maintenance of data models, T-SQL scripts and procedures and the integration of the Azure platforms in applications that use the Azure database. We also make data available from Azure to SAS desktop apps for analysis. All cloud integrations solutions built uses the Azure SQL for data staging.
• Worked on the Canvas (Learning Management System) to Salesforce (ERP) integration project. This project required the build of an ETL process that extracts data from Canvas cloud solution, transforms the data and load it into the Salesforce cloud solution and vice versa.
• Managed the project to integrate the systems used by the finance department. This includes the integration of Expensify and Financial Edge and the integration of eShow with Financial Edge. Each integration created a one-way data flow between the systems. These ETLs were built using a combination of T-SQL scripts and SSIS packages. Php was used to build the solution that interacted with the APIs from the different cloud solutions. I was actively involved in this technical implementation.
• Managed several other data integration projects between various cloud software solutions for the finance department. I did a lot of hands on SQL, SSIS and API related coding on this project.
• Managing the Canvas implementation project as it will replace Blackboard as the Learning Management System
• Managed the implementation of ADP as the human resource and payroll solution now in use in the organization.
• Managed the implementation of Confidential SurePay and some other Confidential solutions that is now used by the finance department. This allows the finance department automate the issuance of cheques and it also allows the organization send cheque details to the bank as soon as the cheques are issued. Checks that does not go to the bank through this auto.
• Reviewed of the use of Salesforce as the Enterprise Management System (ERP)
• Oversee some enhancement projects aimed at modifying the Salesforce implementation to satisfy some business needs
• Oversee the migration project from GSuite to Office 365. The project also included the rollout of a SharePoint based Intranet. The organization now uses Office 365.
• Managed the project to do an organization wide review of software and services in use with the aim of consolidating all software solutions
• Managed a software project that uses Python to search for specific strings in over 300,000 documents. I did some hands on Python coding in this project.
• Managed a project that successfully integrated the technology of a new organization with our IT department after an acquisition of the organization.
• Contractor and supplier management as part of the IT/IS implementation projects. Some contractors were remote in other parts of the USA, Europe and India.

Confidential

Executive Consultant

Responsibilities:

• Specialties: Data Warehouse, Business Intelligence, IT/IS Management, Database Administration of Data Warehouse/BI databases, Data Modelling, DW/BI Project Management, Big Data, Hadoop, Cloudera
• Responsible for overseeing the jobs done by the technology consultants
• Leading a company initiative to develop an online e-commerce portal
• Executing projects for SoftSkan. Some of the projects I’ve been involved in are detailed below.
• Responsible for noSQL (MongoDB) database related tasks for clients.
• See below for projects executed during this role:

Confidential

Lead Consultant/Project Manager - Data Warehouse and Reporting

Responsibilities:

• The two trusts implemented a new Confidential t Administrative System (called Millennium, supplied by Cerner. Cerner is a US based company) and I led the team that successfully implemented the backend data warehouse and reporting solution for this new PAS. The data warehouses were on the Microsoft Business Intelligence technology stack with Business Objects 4.1 and Qlikview as the front-end reporting tool. I also worked in hand with the project manager that led the data migration project. As part of this delivery, I also provide a lot of technical input to support all Data modellers, Microsoft T-SQL and SSIS developers working on the project.

Confidential

Deployment Data Migration, Testing and Cutover Lead Consultant/Project Manager and Data Warehouse Consultant

Responsibilities:

• The trust implemented a new Confidential t Administrative System (called SystmOne, supplied by TPP) and I was involved in and led all tasks relating to migration of data from the legacy systems to SystmOne. The data includes over 1 million Confidential t records and over 200GB of clinical documents. I also led the testing of the new system. As part of this role, I provided a lot of technical advice on the new data warehouse implementation developed for the trust with the support of Microsoft UK - I had worked in this trust before as the data warehouse manager. Business Objects and QlikView are the key reporting tools that were used to deliver the reporting requirements for this implementation.

Confidential

Data Migration Lead Consultant

Responsibilities:

• The trust implemented a new Confidential t Administrative System (called Millennium, supplied by Cerner) and I led the technical implementation of all tasks relating to migration of data from the legacy systems to Millennium. This involved a lot of data modelling and data validation tasks.

Confidential

Technology Consultant

Responsibilities:

• I was involved in the switch over of the reporting feeds that feeds the legacy reporting data warehouses from the legacy PAS system to the new PAS system. With one other consultant from Confidential, we were able to build new data load mechanisms that loads data files into the data warehouse. In addition to this, we did some data modelling to come up with an architecture (design) and created a unified community reporting database solution by merging three separate instances of RiO (RiO is a Confidential t administrative system used by the hospital trust) into one and produced automated processes that updated this new reporting database daily from the backups of the respective live RiO instances. In addition to the 3 RiO instances, data feeds from some other community health related systems were merged into the unified reporting database solution. A unified Commissioning Data Set (CDS) extract from the three instances was also done. Technologies used here include SQL Server 2008, TSQL, Visual Basic and MS Access.
• QlikView and MS Excel spreadsheets are the key reporting tools that were used to deliver the reporting requirements for this implementation.

Confidential

Data Warehouse Designer (Architect) and Project Manager

Responsibilities:

• Confidential (BHT) was created on 1 April 2012, bringing together three hospital trusts: Barts and The London Confidential, Newham University Hospital Confidential and Whipps Cross University Hospital Confidential . The trust is one of the largest healthcare trusts in the UK, with a turnover in excess of £1.25 billion and a workforce of over 15,000 staff.
• Following the merger, a project was launched to upgrade the legacy data warehouse form each trust that merged to form BHT. The upgrade included the procurement of a new data warehouse server and the upgrade of legacy data warehouses from older versions of SQL Server to SQL Server 2012. A unified reporting solution was also to be built as part of this project. As the designer and project manager, I was responsible for the design and modelling of the new system whilst providing project management services to the project. The design included tuning the new system for optimal performance.

Confidential

Business Intelligence (BI) Architect

Responsibilities:

• Confidential London was the Strategic Health Authority (SHA) for the whole of the Greater London area. They provide strategic leadership for the capital's healthcare and make sure the 13 billion GB pounds annual investment in staff and services delivers the best possible care and support for the public and Confidential ts. Confidential London had overall responsibility for the performance of 31 primary care trusts (PCTs) - who operated in five clusters, 16 acute trusts, three mental health trusts and the London Ambulance Service. A further 18 Trusts in London are foundation trusts and regulated by Monitor.
• As the BI Architect, I was able to resolve pending issues with existing non-functional data warehouse setup and propelled it to go-live. This solution took over as the business as usual system. In this role, I provided hands on technical expertise on multiple technologies to support the Business Intelligence and Information Services unit. With ease, I trained other technical staff and supported them through a move to new technologies. The technologies used by the department included the Microsoft SQL 2008 BI stack. Other technologies are SharePoint and InfoPath web forms for data collection. I also debugged and corrected ETL solutions and optimised the performance of data warehouse and BI systems. In addition, I provided guidance to analysts who are new to SQL Server technologies. I also provided relevant technical advice on the transferring of legacy files (Excel, Access) into a data warehouse, data modelling, star schema development and the development of cubes. BI reporting was done using Tableau and my QlikView Software experience was an advantage for this role.

Confidential

DBA and Applications Performance Improvement Consultant

Responsibilities:

• This role largely involved legacy system optimisation. I Investigated all issues with the existing database and software applications - issues includes database locking, application time-outs as a result of un-optimised and non responsive databases. Within 3 days, I was able to detect all the major problems that plagued the databases on the database server and over another two weeks, four change requests I passed were implemented and thereafter the database server became stable - this was the first time the system became stable in years. Before then, there has been no reported incident of locks and timeouts or non responsive databases. In addition to eliminating locks, time outs and server/application/query hanging, the changes implemented also reduced total daily data processing execution time from circa 220 minutes to circa 70 minutes. All these s were made in less than a third of the projected contractor hours the trust estimated for these to be resolved.
• I developed SSIS ETL packages to automation processes and finance reports generation. This reduced the time to extract the finance files from circa 5 hours to less than 80 minutes and freed up over half a day of a senior analyst’s time for other work.
• Conversion of a Visual Basic 6.0 data processing application to SSIS 2008
• I setup and administered a new SQL Server 2008 server box that will serve as a replacement for the outdated SQL Server 2000 box. I administered and performance tuned the legacy SQL Server 2000 server and was actively engaged with the optimisation of all processes that runs on the SQL Servers. I drafted a strategy for the migration of data and processes such as reporting processes from SQL Server 2000 to SQL Server 2008 and the development of a data warehouse. Business Objects and QlikView are the key reporting tools that were used to deliver the reporting requirements for this implementation.
• I did data modelling related tasks in this role.

Confidential

Data Migration and Reporting Consultant/Project Manager

Responsibilities:

• Imperial College Healthcare Confidential (ICHT) was created on October 1, 2007 by merging St Mary’s Confidential and Hammersmith Hospitals Confidential and integrating them with the faculty of medicine at Imperial College London. Now one of the largest Confidential trusts in the UK, ICHT have come together with the College to establish one of the UK’s first academic health science centres (AHSCs).
• As a result of the merger, ICHT has a number of different pathology laboratories that run on different and largely independent Laboratory Information Management Systems (LIMS). The trust decided to rationalize and merge all the different LIMS systems into one system.I was responsible for leading the Data Migration from the legacy LIMS systems into the new LIMS system supplied by Technidata UK and the building of a data repository for management reporting and legacy data storage. The legacy LIMS systems are Sunquest Copath, MiSys, iSoft Telepath and Technidata Blood Bank LIMS software.
• My role includes data migration scope identification, data migration planning, data migration strategy development, data repository/legacy data archiving needs analysis, data analysis, Extract Transform and Load (ETL) process development, development and documentation of T-SQL scripts, data migration testing, management reports specifications gathering, analysis and development, server hardware recommendation, purchase, and installation. The proper documentation of all technical work was also a part of my s. The new Technidata LIMS software uses runs on a SQL Server backend and all staging, data analysis and reporting tasks are accomplished on SQL Server 2008 Business Intelligence software - SSIS, SSRS and SSAS.

Confidential

Data Warehouse Manager

Responsibilities:

• I was responsible for the technical implementation of the circa £1m data warehouse and RiO migration project for the HPFT. The project involves building a data warehouse for business intelligence, performance management and reporting purposes; building from scratch, a data warehouse never existed before now. As part of this project, I also provided technical expertise for the migration of Confidential t data from about 6 Confidential t Administrative Systems (PAS) to a new PAS called RiO - RiO was supplied by British Telecom (BT). My work also covered other data warehouse/data migration tasks as directed by the head of the ICT Shared Services
• The data warehouse rests on a SQL Server 2005 cluster and I do some SQL Server DBA tasks in the absence of the resident DBA. I developed ETLs (using SSIS 2005 and 2008). Data modelling was done to create relevant ETLs and appropriate expansion of the data warehouse that was bought.

Confidential

IT Consultant

Responsibilities:

• Confidential is a company that develops software and business process improvement plans for utility companies and the client of theirs whose project I managed was a major energy retailer in the UK.
• Primarily responsible for the execution of the Data Warehouse development project.
• Data Warehouse architecture design and requirement specification. Capacity panning of the Data Warehouse and installation of all software required for the Data Warehouse development process. Recommended and installed software/Oracle technologies include Oracle Warehouse Builder, Oracle discoverer and Oracle streams amongst others. I also created documentations of the procedures to install/setup the required software/technology as it affects the company’s needs. Proper documentation of developed ETL processes and mapping was also done.
• Building of a data warehouse (DW) from scratch (this required modelling the new data warehouse); employing DW best practices and executing the DW build process; preparation of a backup strategy for the DW was not exempted. Oracle Warehouse Builder 10g release 2 (OWB 10gR2) was used to create facts, dimensions, cubes, mappings, process flows and other data warehouse objects.
• Development and testing and execution of Extract, Transform and Load (ETL) processes.

Confidential

Enterprise Data Warehouse (EDW) Developer

• MTN telecommunications is a telecommunications company specializing in GSM and land line technologies. They have the largest customer base in Nigeria, which is the biggest telecoms market in Africa. Most of the data handled in their Data Warehouse had to do with Call Data Records (CDRs) and the Oracle Business Intelligence stack were widely used in their Real Application Cluster (RAC) and SAN environment.
• Primary responsibilities included fine tuning of some existing PL/SQL procedures to optimize performance, modification of some PL/SQL procedures to exclude all human intervention during execution, and PL/SQL script writing to accomplish tasks. I developed, executed and monitored ETL processes.
• Responsible for other DBA tasks.

Confidential

IT Administrator / DBA

Responsibilities:

• Primarily responsible for database administration in all its implications in an ITIL environment; most database servers were SQL Servers. Problem identification, troubleshooting and performance tuning of the servers.
• Performed data integration tasks.
• Did database designs/models for new application development and plans for setup of acquired applications.
• Generation of reports and periodic refresh of reports dashboards for management’s use. Some reports were returned in MS Excel, while others were created with Crystal reports 8.5
• The team I led also managed about 500 PC users around the country. I led the setup of these PCs and the network around the country.

Confidential

Database Administrator, Team Leader

Responsibilities:

• Administered Oracle databases and other databases at various client locations. Generated business plans at various stages of information technology implementations
• Supervised the testing phase of the development of a credit card system for Intercontinental Bank (Nigeria).
• Designed and led the software development team that developed an Organizational Systems Manager TM (Includes HR, Pensions and Payroll Packages).
• Wrote several SQL scripts. Developed, Maintained and added functionality to several websites I did the data modelling for most software development projects.