Andrew Udolisa

• Strong Knowledge and hands-on experience in BI/DW - Data Analysis & Architecture, Data Modelling, Database Design & Development, ETL, MDM, Business Intelligence Reporting and Enterprise Architecture (Erwin, Oracle Designer, Enterprise Architect, Toad Data Modeler, Visio, etc.)
• Expertise in Data Warehousing, Data Vault Modelling, Dimensional Data Modelling, Star & Snow-flake schema design, ETL (Extract/Transform/Load), Data Analysis, Data Conversion/Transformation, Database Design, Data Warehouse Optimization, Data Mart Development, and Enterprise Data Warehouse Maintenance and Support etc.
• Knowledge of (Master Data Store and Master Data Management implementation)
• Knowledge of Hortonworks Hadoop HDP 2.2 and 2.1
• Knowledge of both relational (Oracle/SQL Server – OLTP/OLAP), Cloudera Hadoop and non-relational databases (MongoDB etc)
• Strong Linux/UNIX skills and good scripting ability (bash/ksh/awk/ PowerShell, Python, flexLM)
• JIRA, GIT, Bitbucket, Confluence knowledge
• Knowledge of Ansible
• Good understanding of GeoSpatial / Geodetics data implementation
• Apache Web server configuration
• SQL Development Skills (TSQL, PL/SQL, MySQL, NoSQL)
• ITIL (IT service delivery and Support/SM7/Remedy)

Optimize and update logical and physical data models to support new and existing projects.
Worked on Details design/ETL Architect documents.
Designed LLD and High-level documentation, Models.
PoC for new Challenge data format (JSON, XML) and new source system analysis.
Azure/AWS transformations/services.
Used SQL, Kafka, Python, Java, Talend Data Integration, Talend data mapper and Routes, Redshift, Snowflake, Oracle, Denodo, and PowerBI to transform/report data.
Worked in Agile ways of working (scrum).
Used ServiceNow for incident, problem, and change management.
Coached and motivated staff for a better understanding of the project and for business continuity.
Involved in batch and stream data processing strategy formulation.
Involved in data modelling and data matrix mapping (source domain/destination domains).

Optimize and update logical and physical data models to support new and existing projects.
Worked on Details design/ETL documents.
Delivered high-level solution/documentation.
Used SQL, Python, ADF, Snowflake (streams and other capabilities), PowerBI, Autoline, and AS400 to transform/report data.
Worked in Agile ways of working (scrum).
Coached and motivated staff for a better understanding of the project and for business continuity.
Involved in batch data processing strategy formulation.

Actively involved/hands-on in the planning of data transformation strategy, modelling, implementation, and support of new HR data mart deployment (HRDC2 project – proof of concept).
Understood the data from Customer perspective.
Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
Prepared the logical and physical data mapping document.
Synced up the data models to Enterprise Industry standard models.
Performed gap analysis with business process and technical user stories.
Developed scripts (Azure Data Factory, SQL, VBA etc) to enable excel front-end capability.
Performed ETL development/management/strategy (ADF, Talend data Integration/data preparation, Azure SQL Server, on-premises Access).
Responsible for data modelling/lineage (Conceptual, Logical, and Physical) and data mapping (source/destination).
Worked in Agile ways of working (scrum).
Optimized and updated logical and physical data models to support new and existing projects.

Leading infrastructure Risk Assessment, Risk Management, Risk Evaluation and Risk Reporting.
Conducting landscape assessments to address risks within the domains Planning, Support, Implementation and Monitoring.
Responsible/accountable for the adoption of LOI risk management frameworks and policies.
Performed reverse engineering of physical data models from databases and SQL scripts.
Prepared the understanding and mapping documents (HLD).
Developed the ELT code based on the requirement, unit test and delivery of the code.
Analysed complex risk data from various sources.
Involved in weekly reviews of all active tasks.
Governance and oversight of data models ensuring they conform to agreed principles and standards.
Nurturing a data culture and promoting of data model usage.
Assisting with implementing data models into the change and governance frameworks.
Produced PowerBI weekly reports to the Leadership team to showcase risk management progress.

Azure Data Platform Transformation.
Proof of concept project to migrate on-prem Data mart to Azure.
Reuse of existing artifacts, creating new artifacts (Conceptual, Logical and Physical model design).
Participation in Design Discussion, Code Review and Documentation.
Used Databricks, Hue (impala/Hive), and ServiceNow.

Supporting the Resource One Service and PetroSigns applications on a global level for Shell ITSO.
Actively involved in the planning, implementation/deployment, and support of new version application deployments globally.
Configuring/Working with a variety of proprietary data/file formats and utilities on the UNIX and Windows Server OS platforms.
Stakeholder/Vendor management to meet project deadlines on Shell Global Application Service project, Data Domain change updates and implementation.
Developed PowerShell, Bash, and DOS scripts.
Managing/supporting deployment databases (SQL Server, Visual Studio, Spotfire, PowerBI, Mongo DB).
SQL and report development - TSQL (SQL server management studio).
Develop/edit/reconfigure batch scripts (PowerShell, bash etc) to automate processes.
ETL Development/Management – SSIS/Stored Procedures.
Facilitate/assist PetroSigns, Recall seismic/GIS(ESRI) Flow cloud deployment (Azure).
Utilising approved tools/utilities for day-to-day tasks (Leostream, HP RGS, RHNS, DRA etc).
Used ServiceNow for Incident, Change, Asset and Problem management.
Worked in Agile/Scrum ways of working.
Performing administrative application tasks.
Presented and involved in train-the-trainer sessions on IT architecture for PetroSigns Flow.
Involved in CI/CD (VSTS, CARA).

Data/Information Architecture implementation - model driven approach.
Data Design (Data Vault Methodology).
Data Cleanse/Data profile/Data Quality Management.
TSQL development (data transformation/manipulation).
Migration of Data Landscape/Data Visualisation and Business Intelligence tools (Talend/Tableau).
Data Ingestion/Migration of Very Large Data sets (Vertica, SQL Server, MySQL).
Catalogue, ETL Templates and Big Data Concepts (Hortonworks Hadoop).
Worked in Agile working environment.

Data / Information Architecture implementation - model driven approach.
Data Cleanse – Fuzzy Lookup etc.
Developed PowerShell, Bash, and DOS scripts.
TSQL development (data transformation/manipulation).
Migration of Data Landscape/Cube development/Reporting - SSIS, SSAS, SSRS/Talend, GIS data.
Data Platform - SQL Server, Oracle (PL/SQL).
Data Ingestion/Migration of Very Large Data sets.
Catalogue, ETL Templates and Big Data Concepts (Hortonworks Hadoop).
Information Analysis.

Supporting the Recall Service and SUMO application on a global level for Shell TLS.
Actively involved in the planning, implementation, and support of new version application deployments globally.
Configuring/Working with a variety of other Subsurface applications (OpenWorks, Techlog etc) and utilities on the UNIX and Windows Server OS platforms (IIS etc).
Performing Flexlm license administration tasks.
Develop/edit/reconfigure Unix scripts to automate processes (bash/sed/awk).
Stakeholder/Vendor management to meet project deadlines on Shell Global Recall Service project, Data Domain change updates implementation.
SQL Development in TSQL and PL/SQL (TOAD, SQuirreL, SQLplus, Oracle developer etc).
Identifying risks and ensuring data loading procedures and policy is adhered to.

Data Modelling and Development for Production and UAT/Staging Environment implementation for Oracle, SQL Server (2008).
Supporting all the Sub-Surface applications (Openworks (2003 and R5000), Rokdoc, etc).
Working with TOAD, SQuirreL and SQLplus to manage both relational and non-relational databases.
Proof of Concept Business Use Cases (involving Hadoop Big Data development and implementation Hadoop Clusters, Ambari, HDFS, Hive, Pig, MapReduce, Storm, Hbase, etc).
Stakeholder/Vendor engagement and management.
SQL Development in TSQL and PL/SQL.
Developed PowerShell, Bash, DOS scripts.
Provide QC service of Seismic data for Users.
Performing Flexlm license administration tasks.
Working with Landmark technologies and utilities on the UNIX and Windows platforms.
Develop Unix scripts to automate processes (bash, sed/awk).
2D & 3D seismic data administration: Project creation/deletion, CRS management, Storage administration and project support for R5000 upgrade project.
Performing loading, integration and analysis of UKOOA, 2D/3D seismic data and other industry data formats to Petrobank, Openworks (2003 and R5000).
SQL Development in TSQL, PL/SQL.
Stakeholder/Vendor engagement and management.

Performing loading, integration, and analysis of UKOOA, 2D/3D seismic data and other industry data formats to Petrobank, Openworks.
Data Modelling and Development (bespoke client applications).
Stakeholder engagement and management.
SQL Development in TSQL, PL/SQL.
Working with TOAD to manage both relational and non-relational databases.
Provide QC service of Seismic data for Clients.
Working with Landmark technologies and utilities on the UNIX and Windows platforms.
Managing Spatial databases for data management team.
Develop Unix scripts to automate processes (sed /awk).
Developed PowerShell, Bash, DOS scripts.
Perform tape transcription on SEG-Y and SEG-D Seismic data.
Utilizing Tivoli Storage Manager (IBM) and Library for tape tasks.
2D & 3D data administration: Project creation/deletion, CRS management, Storage administration.
Performing TSM admin and back-up tasks.

Provide Support administration services to Service Works Global customers and Authorized Resellers via telephone, email and remote support methods.
Provide Support/development for QFM (Facilities, Property & Performance Management Software) in Windows, UNIX, Web, Citrix and .Net Environments.
Performing Installation of software, upgrades and configuration of software to specification.
Performing data back-up, data manipulation and migration tasks.
Provide Support/development for SQL server 2000, SQL server 2005, SSIS, SSRS, Crystal reports.
Performing root cause analysis, replicating defects reported by users, log with Test Director and involved with resolution.
Provide incident and problem management services in-line with SLAs.
Take ownership of calls and enquiries logged with Application Support and update the clients/users on a regular basis.
Train users where appropriate to improve their skill base.

Support for Windows 2000, Windows XP, MS Office 2000, MS Office 2003, AD, Exchange/Outlook, and bespoke applications.
Provide Mobile Telephony support services (Blackberry, Windows Mobile etc).
Performing Database Management jobs Microsoft Access and Oracle based systems and stock management.
Deliver sales reports and proposing sales level improvement strategies.
Delivery of Quality needs analysis as a Qualified Microsoft Mobile Specialist.

Manage project delivery for client projects on development of solutions to meet stipulated client requirements, cost and time scale.
Involved in application development projects utilising tools like SQL Server, SSIS, SSRS, SSAS, IIS and Coldfusion.
Using Prince2 methodology, maintain project resource management, plan and estimate time and costs of a project.
Draft Prince2 project documents such as project initiation documents (PID), stage plans, end stage report and report writing.
Schedule structured meetings to monitor and track projects including timelines and tasks.
Ensured all project conforms to best practices and high standards of quality.
Collated the project Risk, Daily and Issue logs in order to co-ordinate resources for project risk and issue management.
Assisted the Project Managers with the control of projects using the agreed standard project methodology (PRINCE 2).
Maintained project plans and produced various view by gathering progress information and updating regularly using MS Project 2003 and Excel.
Facilitated good planning on project by liaising with the work streams' project planners, analysing plans submitted, discussing findings and escalating issues as required to ensure good planning.
Also worked in capacity as the Project Manager.
Responsible for the corresponding with other IT consultants, Performance reviews and objectives setting, Team and Priority Management.

Designing Target Domain models.
Development work using IBM InfoSphere Enterprise Suite (including DataStage/QualityStage, Information Governance Catalog, DB2 / Oracle 11.2/12, Director, Operations Manager, MetaData Asset Manager, BigInsights, etc).
Implemented Data Vault methodology and Architecture (hub, link, Satellite).
Creating New/Migrating previous PL/SQL code developed for ETL into SSIS packages (to conform to core architecture principles).
Generating xsd and json files used by web services.
Hortonworks Hadoop HDP 2.2 and 2.1 Big Data development and implementation including Hadoop Clusters, Ambari, HDFS, Hive, Pig, MapReduce, Storm, Hbase, etc.
Implementation of Business Glossary Catalog, Data Staging, Information Ingestion, Information Warehouse, Deep Data, Infrastructure setup for Data Lake.
Working according to SCRUM principles (daily stand-ups etc).