Post Job Free

Resume

Sign in

Data Analyst

Location:
Houston, TX
Salary:
80000
Posted:
February 13, 2024

Contact this candidate

Resume:

Michael Adewoye

***** *********** **, ******* *****. Texas

Tel.: +1-281-***-**** Email: ad3k4g@r.postjobfree.com

LinkedIn: https//www.linkedin.com/in/michael-adewoye

Personal Profile

A proactive and self-motivated individual with 10 years of professional experience in IT, which includes work experience in business intelligence, Python & R Programming, Data Ethics, Data Analytics, Data Management, and Business Analysis. Strong Data Warehousing Concepts, Data modelling and Cloud Technologies knowledge with proven numerical and statistical skills for visualization and insights. Demonstrated good experience in the complete project life cycle, leading data management initiatives to ensure data governance and privacy compliance.

Work Experience

Merit Group Services Ltd, UK Data Analyst Mar 2023 – Till Date

Working with both internal and external stakeholder groups to elicit, prioritise and document business requirements for a new enterprise resource planning (ERP) system, ensuring alignment with organizational goals.

Working as part of a cross-functional team (developer, quality assurance, technical architect, user researcher, service designer and delivery manager) to ensure the requirements are implemented in line with the business value.

Understanding and documenting the as-is processes and the to-be processes for the different workflows and carrying out gap analysis to identify areas of bottlenecks and then proposed changes to enhance overall business performance maintaining effective communication with all stakeholders.

Built conceptual logical and physical data models that align with business requirements to ensure data consistency, integrity and performance to enable accurate and seamless real-time data reporting including data visualization.

Implemented MDM Strategies, master data models, taxonomies and hierarchies aligned with organizational goals and data governance principles.

Spearheaded a company-wide initiative, successfully validating and boosting the accuracy of company data by 30%. This significantly improved the reliability of the analysis.

Identified dataset inconsistencies; suggested strong validation methods for better data quality.

Played a pivotal role in automating monthly labour allocation reports, reducing manual effort by 80%

Developed and optimized complex SQL queries, and orchestrated dynamic views, stored procedures, and triggers to efficiently retrieve, manipulate, and manage large datasets, enhancing overall data analysis.

Led a team to develop a Data Governance and Management framework for the company. Conducted regular audits of data processing activities to identify and mitigate ethical risks, ensuring compliance with industry standards.

Completed end-to-end analytic projects by employing Agile technologies.

Design and Analysis of databases and Data Warehouse (Azure SQL DW)

Implemented ETL and data integration with Azure Data Factory and Synapse Analytics

Possesses strong analytical skills and can collect, clean, manipulate, and process large datasets.

Designed, developed, and maintained interactive Power BI dashboards, KPIs and reports to provide insightful data visualization for stakeholders using DAX, Power Query, and Data modelling. Executed data extraction, transformation, and loading (ETL) processes to ensure seamless data integration as a result, report generation time has been reduced by 20%. Collaborated closely with various teams to understand their unique data needs, tailoring dashboards accordingly.

Ensured the accuracy and reliability of presented data in Power BI dashboards, undertaking thorough data quality checks. Conducted training sessions for end-users and new starters, equipping them with the skills to effectively navigate and utilize the dashboards and reports.

Addressed and resolved data-related issues promptly, maintaining the integrity of the Power BI infrastructure. Kept abreast of the latest Power BI features, updates, and best practices, implementing them to enhance overall dashboard functionality.

St Oswald's Hospice, UK Business Intelligence (BI) Analyst Feb 2023 - June 2023

(Masters’ Work Experience Program in collaboration with the University of Sunderland)

Utilized API integration to import data into Power BI, facilitating real-time analysis and reporting.

Created visually impactful reports and dashboard visualizations using Power BI, effectively communicating key insights to stakeholders.

Successfully gathered requirements from diverse stakeholders, ensuring alignment with business objectives and driving actionable outcomes.

Leveraged Microsoft Forms for streamlined survey creation and harnessed Power BI visualizations to analyze valuable feedback.

Established a secure connection with the Golden dataset, enabling seamless extraction and analysis of essential data.

Effectively handled clinical data within the SystmOne and HL7 healthcare information and management systems platform, ensuring accurate and efficient data management.

McGeorge Consulting Ltd Business Intelligence (BI) Analyst Dec 2019- Jan 2022

Boosted data quality by 60% via thorough assessment and cleansing with Excel, and Power BI.

Automated report creation provides immediate insights into customer data on dashboards.

Operated on SQL platforms like MS SQL Server, PostgreSQL, MySQL for various projects.

Constructed KPIs using Power BI to illustrate operational performance effectively.

Championed Agile Scrum for project delivery, enhancing overall process efficiency.

Leveraged extensive customer data to forecast future market trends.

Consolidated data from various sources to build comprehensive databases and reports using Power BI for strategic decisions.

Executed data modelling for optimized analysis and reporting outcomes.

Lead a team to carry out Data Protection Impact Assessment to ensure compliance.

Led the development and execution of data privacy policies and procedures, ensuring compliance with global data protection regulations.

Conducted privacy impact assessments for new projects and initiatives, addressing privacy concerns from the outset.

Established and maintained a robust data subject rights management system, facilitating streamlined responses to data access requests.

McGeorge Consulting Ltd Data Entry/Reporting Analyst Feb 2015- Dec 2019

Translated complex business requirements meticulously into developer-friendly technical specifications, driving efficient data transformation processes.

Adapted ETL processes proactively to accommodate changes in source systems and new business user requirements, ensuring seamless operations.

Masterfully used Excel's advanced tools, specifically Sort, Group, Count, V-Lookup & X-Lookup, to manage large volumes of data efficiently.

Monitored project progress, evaluating outcomes against objectives for continuous improvement.

Maintained reports diligently, guaranteeing their constant functionality and up-to-dateness.

Performed data administration tasks, including detailed data entry and cleansing in Excel.

Used SQL skills for precise database querying and relevant dataset extraction.

Conducted data quality cleansing and mapping for accurate datasets.

Soft Skills

Self-starter with a strong drive and is always ready to take up leadership roles.

Ability to build relationships with business clients and manage negotiation of sales contracts.

Efficient with Word processing; Spreadsheets; MS Windows; database and inventory control software

Persuasive and goal-driven team player with the ability to multi-task, prioritize, and manage time efficiently with excellent networking, oral and written communication, and presentation skills.

Excellent customer care and focus; ability to assess customers’ needs and provide correct answers for a positive customer experience.

Positive work attitude with excellent project management skills

Skills and Tools

Data cleaning and exploratory data analysis. Advanced Excel user.

Data Visualisation using Microsoft Power BI (Data Analysis Expressions (DAX) & Power Query) & Tableau

Programming: SQL, T-SQL, Python (Pandas, NumPy, Scikit-Learn) & R

Databases (MS SQL Server (SSMS, SSIS, SSAS, SSRS), MS Access & MySQL)

Machine Learning (ML) and Artificial Intelligence (AI)

Cloud Technologies (AWS, Google Cloud and MS Azure)

Data Ethics, Governance and Management (GDPR, DPA, HIPAA)

Data transformation/blending with Alteryx. DBT and GIT

Data Integration (Informatica)

Azure: ADF, Synapse Analytics, Databricks & Data Lake

Agile project management tools (SDLC, Trello, Jira, and Confluence) and methodology (Scrum/Kanban)

Education

University of Sunderland, Sunderland: Applied Data Science (MSc) Jan 2024

University of Lagos, Lagos: Business Administration (MBA)

University of Ilorin, Ilorin: BEng Electrical Engineering (Bachelor of Engineering)

Professional Certificates

CDMP (In view)

TOGAF (In view)

Scrum Master (In view)

CPHIMS (In view)

Microsoft Certified: Power BI Data Analyst Associate

Microsoft Certified: AI Fundamentals

Microsoft Certified: Data Fundamentals

Microsoft Certified: Security, Compliance, and Identity Fundamentals

Microsoft Certified: Azure Cloud Fundamentals

Dataleum: Certified Data Analyst

Simplilearn: Big Data and Hadoop Developer

Cognitive Class: Hadoop Fundamentals Certificate & Big Data Fundamentals Certificate

Cisco Certified Network Associate (CCNA 2.0)

Professional Membership

Member British Computer Society

Member Institute of Analytics

Member Healthcare Information & Systems Management Society



Contact this candidate