Ifeoma Dafikpaku, MSc

• Work with data engineering team to migrate third party client's data unit to the cloud (AWS).
• Develop and maintain complex dashboards using Tableau Dashboards to show sales and performance data.
• Conversion of old excel based reports to Tableau reports for sales and tracking stakeholders.
• Shadow lead data engineer while creating dimensional model for data warehouse implementation.
• Involved in developing POC to switch some dashboards to Power BI
• Create materialized views to optimize dashboard performance.
• Help stakeholders convert requirements to runnable queries against data marts created using materialized views.
• Optimize SQL query performance by writing more efficient queries.
• Analyze complex data to prepare forecasts and identify trends and opportunities for analysis projects.
• Retrieval and synthesis of large data sets into actionable insights, and making recommendations for enhanced decision making.

Major Skills Employed: SQL, AWS Redshift, Tableau, Power BI, Excel, Dimensional modelling, Data Visualization, ERD.

• Designed and implemented a sales and inventory management system using excel intelligent features.
• Created and managed weekly analytics reports containing sales and performance metrics and visualization per stock.
• Generated monthly sales performance reports for management.
• Designed a stock management system using excel.
• Provided daily stock inventory report.

Key analytics skills employed: MS Excel, Data Modelling, Data Visualization.

• Performed data management roles, including updating records and databases for personnel, financial and legal information.
• Supervised administrative staff, designed office workflow.
• provided staff assessment and feedback to improve internal performance.
• Created staff performance reports showing metrics and trend visualizations using excel.
• Created procedure manuals and contracts for clients.

Key analytics skills employed: MS Excel, Data Modelling, Data Visualization.

• Ascertained trends affecting maintenance, service and production processes to inform continuous improvement initiatives.
• Analyzed performance reports and devised action plans for remedial repairs.
• Produced detailed field service reports on daily work data.
• Performed on-site installation including upgrade works, modification and maintenance of systems and equipment in oil and gas installations to increase production output.
• Collected and organized operations data for use in decision-making activities.
• Managed maintenance data records and tracked operating information for on-site reference.
• Carried out scheduled services on installations for preventive maintenance and calibration works.
• Managed field activities and organized and carried out site visits to clients' facilities for diagnosis and repair duties.
• Supervised on-site crew, works and ensured proper maintenance of onsite equipment.
• Organized and managed team building sessions for the field engineering departments and produced reports for improvement of work ethics and enhanced productivity.

• Provided progress reports for all on-going and completed projects carried out by the field engineering department.
• Scheduled and facilitated meetings between the project engineers and contractors (clients) on projects executed.
• Worked with field engineers to deliver on-site projects involving the upgrade of Flowstation and Gas plant facilities to increase production capacity/output.
• Involved in and facilitated processes leading to contractor selection and the implementation of a major oil and gas pipeline replacement project.
• Managed team meetings which included presentations and troubleshooting/brainstorming sessions for on-going projects.
• Conducted site inspections and supervision of crews on site during equipment installations.
• Managed field activities, including implementation of engineering designs.