Data Analysis

HEALTHCARE PATIENT EXPERIENCE

• Completed entire project using Excel, PostgreSQL, Power BI and Python (Jupyter Notebooks).
• Analyzed patient experience metrics including Net Promoter Score (NPS) and survey data needed for improving patient care and satisfaction in healthcare facilities across United States.

BIKING ACCESSORIES ANALYSIS

• Using MS-Excel and PowerBI for analysis and data visualization.
• Developed interactive dashboards with Power BI to monitor global sales and revenue trends for biking equipment.

BRIEF REPORT: THE GREAT RECESSION

• I built this brief report using PowerBI
• This report highlights the sharp increase in bank closures during the early 2000s and 2008-2013 Great Recession, showing the financial crisis's impact.

FIFA WORLD CUP INSIGHTS

• I built this project using Excel, PostgreSQL and Tableau.
• Imported initial datasets from Excel into PostgreSQL for SQL querying and statistical analysis.
• Used Tableau to create data stories and dashboards to visually communicate insights.

DATA EXPLORATION IN SQL

Exploring and analysing data in various database management systems including MySQL and PostgreSQL. I also executed SQL queries to gain insights from databases.

PYTHON PROJECTS

Analyzing data using Python, mainly with Jupyter Notebooks.

TABLEAU PROJECTS

Analyzing data using Python, mainly with Jupyter Notebooks.

Data Engineering

WORK IN PROGRESS...


									Project Links
									- Azure Data Engineering with T-SQL
								

Currently, I am utilizing my growing expertise in different domains of data and cloud engineering while exploring the world of data-driven insights to build a stronger foundation in the field.

Experience

Software Engineer | POWER PLATFORM DEVELOPER
Meridian Port Services Ltd. | TEMA, GHANA

  • Developed a Work Permit software system for port safety and compliance, ensuring that workers and contractors comply with safety requirements and obtain approval from internal staff before commencing work within the terminal.
  • Integrate data from multiple systems, such as vessel schedules and container movements, to create dynamic visualizations that support the Operations Department in monitoring performance.
  • Designed and implemented a digital waybill system using Microsoft Power Apps to streamline the tracking of goods entry and removal across various departments within the port terminal, enhancing operational efficiency.
  • Data Analyst | Contract
    Gundersen Health Systems | Remote, USA

  • Collaborated with cross-functional teams in creating visualizations with Power BI and Excel that were used by stakeholders to make decisions on Patient Experience in various healthcare facilities.
  • Leveraged Workday reporting tools to analyze HR data that boosted ServiceNow dashboards utilization by 22% , second highest in IT Data Services as of Q4 2023.
  • Worked closely with stakeholders on a project to gather requirements and implement desired features for dashboard reports.
  • Delivered ad-hoc reports to various stakeholders with SQL and PowerBI Service for Patient Experience Analysis, backlog health metrics and OKR metrics among similar asks.
  • Established key operational data metrics with Data Engineering team to analyze the processing of high-volume data from NRC health platform into Azure Databricks.
  • Business Intelligence Intern
    Integral Ad Science | Remote, USA

  • Analyzed complex data sets to identify trends and patterns, resulting in findings that increased customer base by 14% in a new market segment.
  • Participated in ad-hoc Tableau training sessions organized by senior BI developers to enhance my understanding of various techniques and procedures.
  • Executed SQL queries to extract relevant data from advertising databases, ensuring clean datasets for Tableau reporting.
  • Experience of exploring data and creating visualizations with Jupyter Notebooks and R programming language.
  • Data Research Analyst
    Ghana-India Kofi Annan Centre of Excellence in ICT | Fulltime

  • Significantly aided in the 20% increase in revenue in the Q2 of 2022, by implementing a data collection system prior to a new project by the research department.
  • Leveraged PowerBI by building advanced dashboards and presenting them to executives, enabling data-driven decision making.
  • Delivered data-specific contents and instructions to diverse groups of students across different age ranges, covering concepts in Microsoft Excel, Visualization tools, Python and SQL databases.
  • Developed comprehensive curriculum for data analysis courses, covering topics such as data cleaning, statistical analysis and data visualization.
  • Collaborated with colleagues and industry partners to enhance the quality and relevance of the data analysis curriculum.
  • Data Science Intern
    Npontu Technologies Limited

  • Mastered fundamental Python skills along with key libraries like Pandas and Matplotlib, helping me to analyze and visualize data effectively.
  • Executed data cleaning procedures to ensure datasets are accurate and complete for further statistical analysis.
  • Documented data driven reports, store procedures, query optimization using SQL and PL/SQL knowledge.
  • Presented data insights periodically to senior Data Scientists.
  • Skills | CERTIFICATIONS

    RELEVANT SKILLS & TOOLS

    Data Analysis
    Statistical Analysis
    Visualization [Power Bi, Tableau, SPSS]
    Programming Skills [Python]
    SQL & Databases [PostgreSQL,MySQL, BigQuery]
    ETL Data Modeling [Azure Databricks]
    Data Cleaning & Transformation
    Data Manipulation [Pandas, Numpy, Matplotlib]
    Web Scraping
    DEV TOOLS [JUPYTER NOTEBOOK, GITHUB, VSCODE]
    Soft Skills [Communication, Critical Thinking]

    CERTIFICATIONS

    GOOGLE DATA ANALYTICS PROFESSIONAL

    DATACAMP ASSOCIATE DATA ANALYST

    Elements

    Text

    This is bold and this is strong. This is italic and this is emphasized. This is superscript text and this is subscript text. This is underlined and this is code: for (;;) { ... }. Finally, this is a link.


    Heading Level 2

    Heading Level 3

    Heading Level 4

    Heading Level 5
    Heading Level 6

    Blockquote

    Fringilla nisl. Donec accumsan interdum nisi, quis tincidunt felis sagittis eget tempus euismod. Vestibulum ante ipsum primis in faucibus vestibulum. Blandit adipiscing eu felis iaculis volutpat ac adipiscing accumsan faucibus. Vestibulum ante ipsum primis in faucibus lorem ipsum dolor sit amet nullam adipiscing eu felis.

    Preformatted

    i = 0;
    
    while (!deck.isInOrder()) {
        print 'Iteration ' + i;
        deck.shuffle();
        i++;
    }
    
    print 'It took ' + i + ' iterations to sort the deck.';

    Lists

    Unordered

    • Dolor pulvinar etiam.
    • Sagittis adipiscing.
    • Felis enim feugiat.

    Alternate

    • Dolor pulvinar etiam.
    • Sagittis adipiscing.
    • Felis enim feugiat.

    Ordered

    1. Dolor pulvinar etiam.
    2. Etiam vel felis viverra.
    3. Felis enim feugiat.
    4. Dolor pulvinar etiam.
    5. Etiam vel felis lorem.
    6. Felis enim et feugiat.

    Icons

    Actions

    Table

    Default

    Name Description Price
    Item One Ante turpis integer aliquet porttitor. 29.99
    Item Two Vis ac commodo adipiscing arcu aliquet. 19.99
    Item Three Morbi faucibus arcu accumsan lorem. 29.99
    Item Four Vitae integer tempus condimentum. 19.99
    Item Five Ante turpis integer aliquet porttitor. 29.99
    100.00

    Alternate

    Name Description Price
    Item One Ante turpis integer aliquet porttitor. 29.99
    Item Two Vis ac commodo adipiscing arcu aliquet. 19.99
    Item Three Morbi faucibus arcu accumsan lorem. 29.99
    Item Four Vitae integer tempus condimentum. 19.99
    Item Five Ante turpis integer aliquet porttitor. 29.99
    100.00

    Buttons

    • Disabled
    • Disabled

    Form

    Back to top