Monik Modi Email & Phone Number

Mississauga, Ontario, Canada

Vancouver, British Columbia, Canada

Research and Analysis:Conducting extensive research on resources and data points specializing in real estate domain, thereby facilitating a comprehensive analysis with an aim to help investor make better data driven decisions.Leveraging analytical acumen to extract meaningful insights from intricate datasets.Cloud Platform Proficiency (Google Cloud Platform - GCP):Implementing cloud functions within GCP to automate the complexities inherent in data ingestion processes.Setting up and supervising notifications via Pub/Sub in Google Cloud to guarantee efficient communication within the system.Data Transformation and Analysis:Implementing advanced data transformation techniques, incorporating dimension reduction methods such as PCA (Principal Component Analysis).Undertaking meticulous data analysis to unveil discernible patterns, trends, and correlations.Data Management Tools:Leveraging Snowflake for streamlined data transformation and storage processes.Demonstrating partial proficiency with dbt for the management of data pipelines, ensuring seamless and reliable data flows.Data Marketplace Listings:Diligently preparing and optimizing data for data offering listings to augment the company's visibility and working on monetizing the data.Ensuring data accuracy and relevance to attract potential clients and partners.Stakeholder Engagement:Actively engaging with external stakeholders to collect feedback and insights conducive to product enhancement.Collaborating with various teams to synchronize data strategies with overarching business goals.

Halifax, Nova Scotia, Canada

Halifax, Nova Scotia, Canada

Developed and implemented a sophisticated management board using Microsoft Excel and Visual Basic for Applications (VBA), tailored for managerial oversight of the excise duty division. This tool streamlined the supervision of daily operations, facilitating a more efficient workflow.Leveraged MS Excel's Power Query to amalgamate data from multiple sources into a cohesive, integrated view. This innovative approach significantly improved data accessibility and reliability, resulting in a 50% increase in departmental efficiency.Skillfully utilized advanced Excel features such as pivot tables, VLOOKUP, INDIRECT functions, data validation, and conditional formatting to conduct comprehensive data cleaning and analysis. This meticulous process ensured high data quality and accuracy.Designed and executed a dynamic dashboard and routine metrics for management, employing extensive operational and ad-hoc reporting. This initiative provided critical insights and supported informed decision-making, enhancing overall strategic planning.Employed my knowledge of VBA to automate repetitive tasks and customize Excel functionalities, which significantly reduced manual effort and increased productivity.Continuously sought to improve processes and systems, showcasing a proactive approach to problem-solving and a commitment to excellence.Collaborated effectively with cross-functional teams to align data analysis efforts with organizational goals, ensuring a coherent and unified approach to data management.

Dartmouth, Nova Scotia, Canada

Responsibilities Developed and implemented advanced T-SQL scripts for workflow automation, significantly enhancing workflow efficiency.Crafted and optimized stored procedures for database reconciliation, ensuring data integrity and consistency.Conducted detailed technical analysis to identify and implement effective adjustments for data visualization tools, maximizing data accessibility and comprehensibility.Analyzed the company's revenue streams using Power BI, focusing on fuel surcharge contributions, and providing critical insights for financial decision-making.Collaborated with cross-functional teams to align data analysis efforts with organizational goals, ensuring data-driven decision-making.Presented complex technical findings and insights clearly and understandably to non-technical stakeholders, facilitating informed decision-making.T-SQL, MS PowerBI, Data Analysis, Agile

Halifax, Nova Scotia, Canada