Himanshu Gandhi
Data Architect @Adastra
Signup · Get unlimited contacts
WORK HISTORY
Data Architect @Adastra
Edmonton, AB, CA
Worked as a Data Architect and Product Owner across multiple enterprise data and analytics initiatives, supporting platform modernization and business-critical reporting.• Designed and implemented scalable dimensional data models using Medallion architecture to support analytics and reporting across Insurance, Investment, Inventory, Finance, and Sales.• Built transaction-level fact tables and conformed dimensions to enable standardized KPIs such as Deposits, Commissions, Net/Gross Sales, Inventory Reconciliation, and Sales Orders.• Led the design and delivery of Power BI dashboards, translating complex business requirements into actionable data structures and semantic models.• Collaborated with business stakeholders, SMEs, architects, and BI developers to define requirements, prioritize features, and align data models with enterprise goals.• Authored Source-to-Target Mapping (STM), lineage, and transformation documentation to ensure accuracy, traceability, and efficient development.• Developed clear visual data model diagrams (fact-dimension relationships, transformations, lineage) to support design reviews and stakeholder alignment.• Integrated data from multiple source systems using deduplication, lookup, and harmonization strategies to ensure consistency across advisors, regions, and products.• Addressed complex modeling scenarios including split advisor handling, combined product filtering, snapshot ingestion, and extract-based refresh strategies.• Maintained a collaborative approach, incorporating feedback to continuously refine model performance, usability, and reporting outcomes.• Contributed to data governance, solution design, and architecture discussions, ensuring alignment with enterprise standards and best practices.• Supported legacy-to-modern data platform transitions using structured modeling techniques for scalable analytics.
EDUCATION
Punjab Technical University
Bachelor's degree, Engineering
University of Alberta
Master's degree, Modeling, Data and Prediction
SKILLS
ABOUT HIMANSHU GANDHI
Himanshu is a seasoned professional with over 15 years of expertise spanning Technology Consulting, Data Analysis, Data Modeling, Product Development, Data Architecture, and Application Development. Holding a Master of Science in Mathematical and Statistical Sciences from the University of Alberta, specializing in Modeling, Data, and Prediction, he brings a strong academic foundation to his work. Himanshu has worked with leading consulting firms including PwC, EY, Accenture, IBM and Adastra, contributing to projects for prominent clients such as Lloyds Banking, Vodafone, National Australia Bank, Royal Bank of Scotland, and the Development Bank of Singapore. His diverse experience encompasses various domains, including Retail, Commercial, Banking, Market Risk, Credit Risk Assessment, and Liquidity Risk Management across regions including India, the United Kingdom, and North America. Leveraging his comprehensive skill set, Himanshu has effectively applied Data Science methodologies to drive insights and solutions across his projects.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.