Aayush Sharma Giri
Transforming Data into Actionable Insights
Based in Toronto,CA
About
Experienced analytics engineer with a strong background in crafting robust data solutions to power informed decision-making. Over the course of 3+ years, I've specialized in architecting data pipelines, optimizing data models, and automating processes to transform raw data into actionable insights.
Skills
Projects
Experience
2018-2021
Business Intelligence Developer at Logic Information Systems
- Developed and maintained business intelligence (BI) solutions, including data lakes, data pipelines, dashboards, and reports, using tools such as MicroStrategy, OBIEE, Power BI and SSIS. - Accelerated time-to-market by 66% through Python-based automated code translation from bash scripts, successfully modeling an enterprise data warehouse. - Collaborated in the implementation of an ETL pipeline in Snowflake and Azure for 3 major clients, performing integration tests for successful deployment. - Developed deep technical understanding of job automation, batch processing and monitoring for ETL/ELT tasks in multiple OLAP databases with platforms like MS SQL, Oracle, Teradata etc. - Led quality assurance efforts by writing test plans, cases, bug reports, and traceability matrix.
2019-2021
Data Consultant at Yantrashala
- Consulted with 10+ clients and developed tailored data driven solutions based on user requirements, increasing client satisfaction and revenue. - Designed and developed data models for 5+ applications, resulting in improved performance in data retrieval and data integrity. - Developed a well-prioritized product backlog, resulting in 15% increase in development efficiency and a 30% reduction in time to market for new features. - Used Excel, SQL and Tableau/PowerBI for data analysis and visualization to report valuable KPIs that reduced manual reporting work by 10+ hours weekly utilizing DAX functions. - Received, cleaned, and prepped 10+ datasets from clients with 1.7M+ records using Python, SQL, and Excel to streamline automated reporting and compliance.
2022-2023
Research/Teaching Assistant at Brock University
- Taught statistical forecasting using advanced MS Excel (VBA) and database management (MS Access) to 120 students. - Collaborated in 4+ research papers, performing exploratory data analysis, feature engineering and advanced analytics, employing problem solving skills and analytical thinking. - Utilized software tools like R, SPSS, SAS, and Python libraries for exploratory and quantitative data analysis. - Developed deep understanding of machine learning algorithms and their implementation in Python (numpy, pandas, scikit learn, seaborn) - Successfully negotiated with data vendors and stakeholders to reduce costs by 50% and reduced service delays by 3 weeks.
Education
2014-2018
Computer Science at Tribhuvan University
Completed my bachelors degree with thesis on Nepal Stock Exchange Price Prediction with VADER Sentiment Analysis (Linear Regression, Sentiment Analysis)
2021-2023
Msc Management (Operations and Information Systems) at Brock University
Completed my master’s degree in management with specialization in information and operations management with thesis on E-Commerce Supply Chain Risk Mitigation and Online Sales Performance (Multiple Linear Regression, Logistics Regression, Clustering).