Ashray Silwal Email & Phone Number

• 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… Show more
• 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.

Seattle, Washington, United States

- Led the design and implementation of business-to-business integrated supply chain systems for several Fortune 500 companies, including Toyota, Gap, and Target.- Collaborated closely with development and operations teams, as well as clients, to identify and rectify operational challenges, thereby refining system design for enhanced performance..

Seattle, Washington, United States

- Presented various PowerBI reports with visualizations using SQL to gather the appropriate data.- Archived historical company data to clear space from the production database to ensure faster database job completion times.- Migrated multiple PowerBI reports originally written in a MySQL database to a SQL Server database.- Reattributed incorrect data in.

Bellevue, WA

Analyzed different construction companies and fix and flip companies loan data and marketed to them accordingly.

Seattle, WA

Researcher for Human Centered Design & Engineering directed research groups. Questioned how to manage traffic accident response times better in WA with the help of AWS Lambda and Rekognition.

Bellevue, WA

Helped keep the store running successfully at a fast pace and dealt with all customers issues.

Redmond, WA