Skill set
Industry fields of expertise
Amir in a few words
Experienced Data Analyst with 9 years in Power BI, Excel, Power Query, DAX, Tableau, SQL, Looker, Snowflake, and Python familiarity. Expertise in transforming complex data into actionable insights to drive business growth. Strong problem-solving, communication, and collaboration skills. Committed to high-quality work and customer satisfaction. Eager to contribute—resume enclosed for review.
Experience
- Misr Radiology CenterSr. QA Manager & Data Analyst SpecialistFebruary 2022 - Today (3 years and 3 months)Cairo, Cairo Governorate, Egypt• Collect, organize and interpret statistical information and use it to make decisions.• Interpret data and analyze results using analytics, research methodologies, and statistical techniques.• Develop and implement data analysis, leverage data collection systems, and other strategies that optimize statistical efficiency and quality.• Act as a liaison between staff and management, analyzing and interpreting data involving company procedures, policies, and workflows.• Prepare, analyze, and summarize various weekly, monthly, and periodic operational results for use by various key stakeholders, creating reports, specifications, instructions, and flowcharts.• Conduct a complete life cycle of analytics projects, including pulling, manipulating, and exporting data from project requirements documentation to design and execution using SQL, Power BI, Excel and Python.• Evaluate key performance indicators, provide ongoing reports, and recommend business plan updates.• Monitoring, inspecting and proposing measures to correct or improve a Customer Experience and improve processes to meet established quality standards.• Prepare and implement quality assurance policies and procedures and perform routine inspections and quality tests.• Identify and resolve workflow and production issues and ensure that standards and safety regulations are observed.• Making recommendations for improvement and creating training materials.• Manipulating data using SQL Queries to Gather, Clean, Sort and Extract data.• Using Tableau and Power BI to Collect, integrate, Analyse, and Present business information by performing data analysis, data manipulation, and data visualization to make sense of business data and draw insights.• Reporting data analysis findings to management to inform business decisions and prioritize information system needs.• Keeping abreast of developments and trends in data quality analysis.
- InData Labs (Cyprus - Remote)Data Quality AnalystDecember 2022 - March 2023 (4 months)Mansoura, Mansoura Qism 2, El Mansoura, Dakahlia Governorate, Egypt• Performing statistical tests on large datasets to determine data quality and integrity.• Evaluating system performance and design, as well as its effect on data quality.• Collaborating with database developers to improve data collection and storage processes.• Running data queries to identify coding issues and data exceptions, as well as identifying and eliminating anomalies by means of data profiling and cleansing.• Extracting, Transforming, and Loading Data from a Retail Database to a Data Warehouse• Gathering data from primary or secondary data sources to identify and interpret trends.• Manipulating data using SQL Queries to Gather, Clean, Sort and Extract data.• Reporting data analysis findings to management to inform business decisions and prioritize information system needs.• Using Tableau and Power BI to Collect, integrate, Analyse, and Present business information by performing data analysis, data manipulation, and data visualization to make sense of business data and draw insights.• Working with colleagues to Analyse the Outcome and come up with a way to solve the issues of the System.• Documenting processes and maintaining data records.• Adhering to best practices in data analysis and collection.• Keeping abreast of developments and trends in data quality analysis.• Using Informatica to connect with datasets from other databases and confirm the quality of the datasets.• Working on Multiple Projects simultaneously and effectively.• Using Google BigQuery for data analysis and querying large datasets.• Leveraged SQL-like syntax to explore, clean, and transform data within BigQuery.• Visualized insights from BigQuery datasets using Looker Studio.
- FreelanceFreelance Data AnalystJanuary 2020 - February 2022 (2 years and 1 month)Mansoura, Mansoura Qism 2, El Mansoura, Dakahlia Governorate, Egypt• Interpret data, and analyze results using analytics, research methodologies, and statistical techniques.• Develop and implement data analysis, leverage data collection systems, and other strategies that optimize statistical efficiency and quality.• Act as a liaison between staff and management, analyzing and interpreting data involving company procedures, policies, and workflows.• Prepare, analyze, and summarize various weekly, monthly, and periodic operational results for use by various key stakeholders, creating reports, specifications, instructions, and flowcharts.• Conduct full life cycle of analytics projects, including pulling, manipulating, and exporting data from project requirements documentation to design and execution using SQL, Power BI and Excel.• Evaluate key performance indicators, provide ongoing reports, and recommend business plan updates.• Using Informatica to connect with datasets from other databases and confirm the quality of the datasets.• Manage a company's data storage systems.• Develop data warehousing systems using the Informatica ETL tool as below.• Plan and conduct Informatica ETL development and unit tests.• Develop, implement and test ETL components for business applications.• Create workflows for use cases.• Provide requirements analysis for projects.• Load and test data to ensure it works properly.• Using Google BigQuery for data analysis and querying large datasets.• Leveraged SQL-like syntax to explore, clean, and transform data within BigQuery.• Developed scalable data pipelines using tools like Dataform.• Visualized insights from BigQuery datasets using Connected Sheets and Looker Studio.• Familiar with the Snowflake cloud-based data platform.• Explored its features and capabilities for data warehousing and analytics.• Gained insights into Snowflake's architecture and query optimization.
Recommendations
Education
- Bachelor of AccountingMansoura University2019Bachelor of accounting and business Management