Built with datascienceportfol.io

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).