Alexis Dymphina Michael

ALEXIS MICHAEL DATA ANALYTICS/ DATA ENGINEER PROFILE CONTACT --Alexis Michael Alexis Github SKILLS Python, Pyspark, SQL, JSON Cloud Platform & Tools Data handling & ETL Data Pipeline Orchestration Database Management APIs Linux Hadoop, Spark Devops & CI/CD Dashboard Development Machine Learning Shell Scripting Data Security & Governance Virtualisation Network Security Blockchain Technology Problem Solving & Debugging Agile Method & Documentation Communication and Presentation A solution oriented, self motivated and proactive high performer with 10 years of professional experience and 3 years in IT field (data analyst and software engineer). Currently a data engineer designing and building real time data pipelines. Analytical and detail-oriented with ability to solve complex business problems, using a range of tools and technologies (SQL, Python, PowerBI, AWS and ETL tools). A collaborative professional who is result-oriented and identifies opportunities for process improvement. Thrives in team environments with the ability to work under pressure and tight deadlines WORK EXPERIENCE Consultant at Bank of Ireland Data Engineer - QA JULY 2024 - PRESENT Designed and implemented automated scripts using Python and JSON to validate and test data processes, resulting in a 70% increase in task efficiency. Developed Dashboard showing the orchestration performance and metrics of each deployment version and reported insights effectively to senior stakeholders. Utilized tools such as AWS, Cloudera, Jenkins, and JFrog Artifactory, Postman, Control-m, to manage data pipelines and streamline workflows Conducted rigorous quality assurance testing on data engineering workflows, increasing the accuracy and error-free operations by 20%. Explored and analysed large datasets using pyspark databricks with focus on accuracy and detail, optimizing data processing and scalability. And transformed complex data into clear and actionable insights for stakeholders. Alliance Automotive Group Data/Pricing Analyst AUGUST 2023 - NOVEMBER 2023 Increased company’s product sales and profit margin by 10% by identifying opportunities for optimizing price and implementing strategic discounts. Automated a stock management reporting process which reduced time waste, management cost and error by 45%. Extracted data from multiple sources using SQL queries and organized the data in a database. Created engaging reports using public dashboard based on data exploration findings. Data Glaciers Data Science/Machine Learning JANUARY 2023 - JULY 2023 Developed a model using Python which improved the accuracy and performance of the prediction of drug persistency as per a physician’s prescription by 35% Created interactive dashboards with key performance indicators and score cards using Tableau to communicate insights effectively, enabling stakeholders easily grasp relevant findings. Worked alongside team members to analyse and explore clinical data, researched, brainstormed and implemented best solutions to maximizing data to improve model. JP Morgan Work Experience Enterprise Software Development Internship JULY 2022 - JANUARY 2023 Automated a manual process by designing a comprehensive appointment booking web app and mobile app using Laravel, JavaScript, and React Native. This improved the efficiency and accuracy of the booking process, cutting down cost of business operation by 60%. FRAMEWORKS & TOOLS Pytest, Airflow, Automation & CI/CD Hadoop, Phoenix, Ansible, AWS, Powershell, version control using git, Cloudera Data Science Workbench, Jenkins PROJECTS Automated Extraction of pipeline name, job ID, configuration, and each pipeline module runtime data for analysis Clean, transformed and queried UN Tobacco import and export raw data, UN gender inequality raw data using pyspark in databricks Analysed the effect of gender inequality to societal wellbeing and making recommendations to improve it. Development and design of dashboard to showcase orchestration metrics and performance of each pipeline deployment version and recommendations of performance improvement Write expectation tests for nulls, invalid data format, schema checks for quality checks on data. Credit Card Fraud Detection using Machine Learning Mobile device data extraction and analysis for digital forensic Jenkins Misconfiguration Exploit Simulation and credential leakage LANGUAGES English (Fluent) Worked as a valuable member of the team, communicating, collaborating and ensuring deadlines were met while effectively collaborating with stakeholder on business requirements, making recommendations and ensuring that need is met. Adhered to software development cycle practices, used agile/ scrum method which ensured a flexible and adaptive approach during the design of the application. Nigeria Hydrological Service Agency, Abuja Geophysicist/ Analyst APRIL 2013 - JULY 2018 Integrate geophysical data with hydrological, geological, remote sensing and GIS data to generate aquifer models and water resources map Analysed and interpreted geophysical datasets i.e., seismic, resistivity, GPR, magnetic datasets. Assist field teams in planning and designing of geophysical survey for site investigations, well sittings and ground water recharge assessment Collaborate with hydrologist, hydrogeologists, and environmental engineers to support project goals. EDUCATION SEPTEMBER 2023 - AUGUST 2024 Postgraduate Diploma in Cybersecurity at National College Ireland (LEVEL 9) SEPTEMBER 2007 - SEPTEMBER 2012 Bachelor of Science in Geophysics at Federal University of Technology, Owerri – Nigeria CERTIFICATES Masterschool: Data Analysis (Recipient of Academic and Leadership Award) – 05/2023 Code First Girls – UK/Ireland: SQL and Data (MySQL) – 04/2023 Google: Data Analytics Professional Certificate – 05/2022 IBAT College – Dublin: Advanced Diploma in Computer Programming with Java – 10/2021 IACT Dublin – Foundation in programming –10/2019 ACCOMPLISHMENTS Partnered with a data engineer to create python script that automated, data validation tests, transformation tests which reduced task duration from hours to 2 - 5 mins, also automated the extraction of performance metrics of pipelines metrics. Developed and designed interactive dashboard connected to live data, enabling the team to gain clearer insights on orchestration performance metrics, performance of each pipeline deployment version, and made recommendations which improved the pipeline runtime and performance by 80%