Experience

Instaclick Inc.

• Canada
• Information Technology & Services
• 1 - 100 Employee

• Senior Data Analyst

  • Oct 2019 - Present

  Achievement: Identified and recommended process improvements that significantly increase billing throughput rate and reduced service cost • Analyzed billing data and created many reports to track key metrics, predict upcoming problems and future trends using MySQL, Excel, Python and GoStats • Worked with senior management team, internal and external stakeholders to provide root cause analysis for systems or data issues • Created ETLs to translate and structure data from MySQL database into GoStats data models • Automated existing programs and reports for performance enhancement using SQL and Shell • Performed data validation, troubleshooting and performance tuning on external and internal data to ensure data quality for integrity and accuracy • Performed testing on data integrity and documented business requirements/technical details in appropriate format • Provided training to new members and knowledge transfer to technical support team



Ethoca

• North York

• Data Analyst

  • Nov 2013 - Oct 2018

  Provider of collaboration-based technology that enables card issuers, ecommerce merchants and online businesses to increase transaction acceptance, stop more fraud, recover lost revenue and eliminate chargebacks from both fraud and customer service disputes. Achievement: Automated multiple standard reports and improved the process, resulting in 100% faster • Analyzed business requirements, extracted data structure, defined solution and translated into detail design for dashboard and key metrics rollout • Collaborated with sales team, marketing team and customer service team to identify opportunities and improve business process • Loaded data from external flat files and transactional data sources into reporting databases then performed data cleansing/ transformation using SAS, Python, SQL queries and HANA Studio • Designed and developed various dashboards using MS Excel, Python, SAP Design studio, and SAS • Created trend analysis and forecast reports to generate insights about variances between actual and planed results then provided recommendations on how to improve those variances • Provide technical assistance and cross training to internal users