Ashray Silwal

About Ashray Silwal

I am a results-driven Analyst with over three years of professional experience leveraging data to drive business insights and streamline operations. My passion lies in solving complex problems, creating data-driven solutions, and transforming raw data into actionable insights that help businesses thrive. Outside of work, I enjoy staying active with activities like skiing and surfing.

Experience

1. Data Analyst

   All Star Directories

   Nov 2022 — Present

   Data Integration and Visualization: Leveraged complex SQL queries and Power BI to create comprehensive data reports by extracting, cleaning, and structuring data effectively.• Automation: Automated data acquisition and processing tasks through Python scripts and Microsoft Logic Apps, enabling efficient data entry and report generation.• Data Quality Assurance: Conducted investigative work to identify and resolve discrepancies in metrics and reporting, ensuring data accuracy.• API Utilization: Utilized APIs, such as Meta\'s and TikTok\'s, to collect and process marketing data, creating hourly breakdowns and automating the data transfer process.• Alerting and Thresholds: Implemented automated alerts through Slack channels based on predefined thresholds for specific data, enhancing data monitoring.• ETL Processes: Set up pipelines in Microsoft Azure Data Factory to efficiently move and merge data between various sources, ensuring data consistency and automating data transfers.• Data Extraction: Extracted data from various sources, including web scraping using Selenium for use in database and Power BI reports.• Project Management: Spearheaded cross-functional initiatives for Marketing, Sales, SEO, and other teams, breaking projects into actionable steps and consistently meeting tight deadlines.

Education

• University of Washington

  Bachelor's degree

  2017 — 2021