نبذة عني
Around 3 years of Industry experience as a Data Analyst with Good understanding of Business Requirements Gathering, Data warehousing, Data Modelling, Evaluating Data Sources, Translating Requirements into Specifications,…
Around 3 years of Industry experience as a Data Analyst with Good understanding of Business Requirements Gathering, Data warehousing, Data Modelling, Evaluating Data Sources, Translating Requirements into Specifications, Application Design. Experience working in all phases of Software Development Life Cycle using methodologies like Waterfall and Agile. Solid working experience with SQL including MS SQL. Strongly skilled in writing stored procedures triggers and complex queries containing multiple joins, sub queries and window functions to create reports and perform analysis. Expert in analysis, design, development, testing, and production rollover of reporting and analysis projects. Experienced in Administering user, user groups, and scheduled updates for reports in Tableau Server. Knowledge in developing different Statistical Analysis, Text Analytics, Data Mining solutions to various business generating and problems data visualizations using SQL. A solid experience and understanding of architecting, designing and operationalization of large-scale data and analytics solutions on Cloud Data Warehouse is a must. Effective communication skills and exceptional team player with a great attitude to work. Good experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse. Ability to write and optimize diverse SQL queries, working knowledge of RDBMS like MS SQL Server and MS Access. Strong skills in SQL, MS SQL packages, functions, stored procedures, triggers, and materialized views to implement business logic in database.
الخبرة
Data Analyst
Managed and modeled data across diverse databases, resulting in a percentage improvement in data consistency.
Optimized database queries and structures, leading to a percentage increase in data retrieval speed.
Quantified the impact of data modeling on database performance, presenting results in terms of percentage
improvements.
Leveraged NumPy and Pandas for efficient data manipulation, resulting in a percentage increase in data processing
speed.
Utilized Sci-Kit, Matplotlib, and Seaborn for advanced analytics and visualization, leading to a percentage improvement
in data insights.
Conducted exploratory data analysis using Python, SQL, and R, resulting in a percentage enhancement of data-driven
decision-making.
Developed impactful presentations in PowerPoint to communicate findings, leading to a percentage increase in
stakeholder engagement.
Utilized SharePoint for streamlined project management, leading to a percentage improvement in project delivery.
Quantified the impact of Microsoft Office Suite tools on overall data analysis and presentation, presenting results in
terms of percentage improvements.
Created interactive dashboards and reports using Tableau & Power BI resulting in a percentage improvement in data
visualization.
Presented insights through compelling visualizations, leading to a percentage increase in stakeholder understanding.
Enhanced team communication through Microsoft Teams leading to a percentage increase in collaborative success.
Managed and optimized Azure Storage Containers, leading to a percentage increase in data storage efficiency.
Designed and implemented data pipelines in Azure Data Factory, resulting in a percentage improvement in data
integration efficiency.
Utilized Azure services for enhanced data storage, resulting in a percentage improvement in accessibility.
Data Analyst (Remote) Intern
Utilize Python, SQL & R for data extraction, cleaning, and analysis in the context of healthcare datasets.
Develop and implement Data Analysis Expressions (DAX) for evaluating and analyzing data in Power BI.
Use NumPy and Pandas for data manipulation and analysis tasks.
Apply Sci-Kit, Matplotlib, and Seaborn for advanced analytics and visualization.
Work with a variety of databases including MS SQL Server, PostgreSQL and MySQL in the healthcare domain.
Utilize advanced features of Microsoft Excel, including V-Lookup, Pivot Tables, VBA, and Macros for data analysis and reporting.
Create impactful presentations and collaborate on documents using Microsoft PowerPoint and SharePoint.
Utilize Microsoft Office Suite and Outlook for day-to-day communication and collaboration within the healthcare company.
Guided Agile teams on how to self-manage & plan working to enabling features & stories a long product increments & Sprints.
Performed statistical analysis such as hypothesis testing, regression analysis, confidence interval & P-value calculation using R.
Consistent in publishing multiple interactive dashboards, and workbooks from Tableau Desktop to Tableau Servers.
Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
Manipulated date and calculated key metric for reporting using MS SQL Server queries (window function, subqueries) and MS Access.
Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI.
Utilize Azure services for data storage, machine learning, and data integration.
Visualized data from MS SQL and MS Access using Tableau Dashboard to monitor email performance, connected to MS SQL database using R package.
Performed exploratory data analysis (EDA) to find insight such as difference efficiency among different devices using ggplot2 in R.
Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues electively.
Data Analyst
Managed and modeled data across diverse databases, resulting in a percentage improvement in data consistency.
Optimized database queries and structures, leading to a percentage increase in data retrieval speed.
Quantified the impact of data modeling on database performance, presenting results in terms of percentage improvements.
Leveraged NumPy and Pandas for efficient data manipulation, resulting in a percentage increase in data processing speed.
Utilized Sci-Kit, Matplotlib, and Seaborn for advanced analytics and visualization, leading to a percentage improvement in data insights.
Conducted exploratory data analysis using Python, SQL, and R, resulting in a percentage enhancement of data-driven decision-making.
Developed impactful presentations in PowerPoint to communicate findings, leading to a percentage increase in stakeholder engagement.
Utilized SharePoint for streamlined project management, leading to a percentage improvement in project delivery.
Quantified the impact of Microsoft Office Suite tools on overall data analysis and presentation, presenting results in terms of percentage improvements.
Created interactive dashboards and reports using Tableau & Power BI resulting in a percentage improvement in data visualization.
Presented insights through compelling visualizations, leading to a percentage increase in stakeholder understanding.
Enhanced team communication through Microsoft Teams leading to a percentage increase in collaborative success.
Managed and optimized Azure Storage Containers, leading to a percentage increase in data storage efficiency.
Designed and implemented data pipelines in Azure Data Factory, resulting in a percentage improvement in data integration efficiency.
Utilized Azure services for enhanced data storage, resulting in a percentage improvement in accessibility.