Web Developer at Quad Source Canada Inc

Developed and maintained the company’s e-commerce website and client portal, ensuring seamless user experience across desktop and mobile platforms. Integrated SQL-based inventory and order systems with the web interface using RESTful APIs and server-side scripts (Python, PHP). Collaborated with cross-functional teams to ensure real-time data flow between the backend databases and the frontend interface. Implemented form validation, user authentication, and role-based access control to enhance platform security. Optimized frontend performance by streamlining HTML/CSS, minimizing JavaScript payloads, and applying lazy loading for media content. Created interactive dashboards using Power BI embedded reports to display real-time KPIs on the internal admin portal. Ensured website accessibility and cross-browser compatibility in compliance with WCAG standards.

Data Analyst at Toronto and Region Conservation Authority (TRCA)

Collaborated with cross-functional teams to provide implementation support for the new Planning Application Review and Enforcement System (PARES), focusing on accurate and efficient data migration. Contributed to the Planning and Enforcement Datamart Project, integrating data from non-relational sources into a new SQL Server using SSMS; designed ETL processes with FME for 16+ data sources, and developed SQL queries & stored procedures to enhance data accessibility for planners, enforcement officers, and government services. Leveraged advanced GIS tools and utilized ArcPy for scripting and automation of geospatial analyses. Configured Power BI to pull real-time data from various sources including SQL Server, APIs, and ArcGIS Online; created interactive dashboards with custom visuals. Developed and automated Power BI reports and dashboards, utilizing DAX, Power Query M, and Power BI Service administration. Designed and optimized data warehouse structures ensuring efficiency and scalabili

Data Analyst Intern at Zenvnodata

Assisted in mapping critical data elements across multiple financial systems, ensuring alignment with enterprise data governance standards. Built predictive models using time-series and machine learning algorithms, employing feature engineering to identify variables influencing portfolio performance. Analyzed data from 50,000+ rides and performed EDA in Python to identify patterns affecting driver metrics. Prepared analytical reports and visualizations to communicate insights to stakeholders. Utilized SQL and Excel to validate and reconcile large datasets. Conducted financial data analysis for a banking client, focusing on data quality assessment and remediation. Built Power BI dashboards analyzing customer transaction patterns and financial performance. Conducted data extraction and automation using SQL, Excel VBA, and Power Query. Developed modular Python scripts and optimized SQL in Snowflake to automate ETL pipelines, reducing processing time by 60%. Redesigned Snowflake schemas an

Risk Analyst Intern at Bohai Bank | Tianjin Branch, China

Conducted risk assessments on new and existing client accounts by analyzing transaction patterns and identifying potential fraud or compliance issues. Performed KYC/AML due diligence, verified customer documentation, and escalated high-risk cases to compliance. Monitored daily transaction logs for anomalies, maintained risk-event registers, and produced summary reports for senior officers. Collaborated with audit and compliance to ensure adherence to policies and regulations. Developed and maintained risk-monitoring dashboards tracking key metrics. Prepared risk-analysis briefs and presented findings, reinforcing risk-awareness among front-line staff.

Data Management Specialist at Quad Source Canada Inc

Enhanced real-time sales tracking and inventory accuracy by 25% by designing and implementing end-to-end data visualization dashboards using Power BI, Tableau, and Excel, leveraging SQL queries for dynamic reporting of KPIs and operational metrics. Reduced data synchronization errors by 30% by developing Python and JavaScript automation solutions that streamlined data integration and reporting workflows across AWS QuickSight, SAP, and SharePoint. Improved incident response time by 40% by utilizing ServiceNow and Excel to automate incident tracking, facilitate root cause analysis, and deliver actionable insights for operational efficiency. Strengthened platform security and compliance with audit requirements by implementing user authentication, role-based access control, and automated Power BI embedded reports while maintaining audit-ready inventory records in SharePoint. Increased stakeholder engagement and data transparency by communicating analytical findings and presenting data-driv

Data Analyst at Toronto and Region Conservation Authority (TRCA)

Increased operational efficiency by 25% by designing scalable data warehouse structures and automating Power BI reports, enabling scheduled refreshes and interactive dashboards to support timely decision-making and data analytics initiatives. Enhanced data integrity for financial and operational reporting by developing robust ETL processes for 16+ data sources and reconciling CAPEX-related datasets, ensuring reliable asset data for audits and inventory management. Streamlined asset tracking and reduced manual errors by 30% by leading accurate data migration and process improvements during the implementation of the Planning Application Review and Enforcement System (PARES), applying data analytics for inventory management best practices. Improved transparency and compliance in IT asset management by managing SharePoint repositories and creating technical documentation, user manuals, and SOPs to support process transparency and ongoing compliance. Supported continuous process enhancement

Data Analyst Intern at Zenvnodata

Increased reporting efficiency by 40% by designing and implementing automated tools with SQL, Excel VBA, and Power Query to streamline data extraction, validation, and reconciliation for financial systems. Reduced ETL processing time by 60% by developing modular Python scripts and optimizing SQL queries in Snowflake for automated Bloomberg and SimCorp data ingestion. Improved self-service analytics by 40% by creating interactive Power BI dashboards and Python-based visualizations for over 12 trading lifecycle metrics, empowering stakeholders with actionable insights. Captured 95% of data exceptions before load and saved 20 man-hours per month by deploying an automated data-validation framework with anomaly detection for ETL processes. Enhanced data quality and ensured regulatory compliance by conducting comprehensive data quality assessment, remediation, and metadata management in alignment with enterprise data governance standards.