AYUSH MANANDHAR

Professional Summary
Experienced Data Professional skilled in data analysis, reporting, and building scalable data pipelines with a focus on data governance. Proficient in leveraging Python, SQL, and Azure for ETL processes tailored to business need. Adept at collaborating with cross-functional teams to develop data-driven solutions through source system integration and data modeling using BI Tools to deliver actionable insights. Enthusiastic about contributing to impactful projects, continuously learning new technologies, and driving business growth through data solutions.


Experience

New York, NY | June 2022 - Present

- Engaged with stakeholders to understand business need and identify and design model for Critical Data Elements used across multiple systems, leveraging SQL to develop model that enhanced business intelligence through Power BI reports.
- Developed program to extract lineage information from ETL code in 100 SQL files for 6000 columns in Azure Synapse Warehouse that were used to create a database that provided visual insights into data origins and landscape.
- Integrated 15 core systems across the organization to develop a comprehensive Data Catalog Platform, enabling data stewards to access, manage and maintain high-quality data across the organization’s landscape.
- Managed and optimized Azure resources including VMs, Storage Accounts and Key Vaults, ensuring efficient support for data integration and governance actions.

- Engineered and automated Alteryx pipeline to process terabytes of data and generate Tableau dashboards reporting usage analytics for data assets leveraging REST APIs and Python, improving visibility and data-driven decision making.
- Designed and implemented workflows to automate data access processes, while integrating compliance checks and approval protocols to ensure adherence to privacy, security, and regulatory standards. This reduced manual effort and enhanced data governance by ensuring that all data access requests met stringent compliance and quality requirements.
- Led 2 teams to successfully deliver Proof of Concepts to enhance data privacy and governance using workflows and Business Intelligence. Engaged with stakeholders to define requirements and ensured the delivery of business value.

- Led the development of an ETL pipeline for web scraping and data integration from multiple college data sources, resulting in actionable insights through Tableau Dashboards for Marketing and Recruitment.
- Completed four-month intensive professional training program, gaining hands-on experience with industry-leading tools and methodologies to develop professional and technical expertise.

Rome, NY | June 2021 - June 2022
- Developed and implemented a Visual Basic program that consolidated bibliometric records from five different sources into a unified database, performing deduplication and combining information to enable technical librarians to conduct landscape analysis and encourage collaboration among authors.
- Designed Tableau Dashboards to visualize shared articles between different bibliometric sources, providing valuable insights about intersections between different sources.
Education

Amherst, MA | September 2018 - May 2022
Bachelor of Science Mathematics and Physics [GPA 3.8]
Relevant Courses: Mathematical Modeling, Advanced Linear Algebra, Probability Statistics, Scientific Computing, Advanced Calculus
Certifications





Languages
- English
- Nepali