Ayaz Ahmed

WORK HISTORY

EDUCATION

ABOUT AYAZ AHMED

Around 3+ years of expertise as a Data Analyst in data analysis, database management, and data visualization, with proficiency in programming languages such as Python and SQL and data visualization tools such as Tableau and Power BI• Experienced in using VBA scripting to automate tasks in Excel, such as data cleaning and manipulation, report generation, and Data Visualization• Experienced in working with complex formulas, pivot tables, and advanced functions to analyze large datasets and create insightful reports• Proficient in SAS for data analysis, report generation, and data visualization using SAS to manage and manipulate large datasets, perform statistical analysis, and create dashboards• Skilled in creating macros to automate tasks in Excel and other applications, improving efficiency and streamlining workflows and writing VBA code to create macros for repetitive tasks• Qualified in designing and implementing data pipelines using Azure services, such as Azure Data Factory, to extract, transform, and load data from various sources, manage and store large datasets• Proficient in creating Macros to automate repetitive tasks and streamline workflows and using Python for data manipulation, analysis, and Visualization• Mastered the use of Tableau for data visualization and analysis, creating interactive dashboards, charts, and graphs to communicate insights to stakeholders• Proficient in using Power BI for data visualization and analysis creating dashboards, reports, and charts to communicate insights to stakeholders, manipulating and transforming data using Power Query• Experienced in using Azure for cloud-based data storage and processing Azure services, such as Azure SQL Database and Azure Blob Storage, to manage and store large datasets• Experienced in using DAX (Data Analysis Expressions) to create and manipulate formulas in Power BI and Excel performing complex calculations and analysis on large datasets• Proven track record of providing data-driven recommendations to stakeholders, meeting project deadlines, and collaborating effectively with cross-functional teams in an Agile environment• Proficient in using Jira for project management and issue tracking, by tracking tasks, bugs, and issues, and collaborating with cross-functional teams• Expert in working with Azure Data Lake to manage and store large datasets, ensuring data integrity and accessibility• Competent in designing and implementing data models using Azure services, improving data accuracy and accessibility