Greater Toronto Area, Canada
Gained years of working experience in Data Analysis with extensive experience of SQL, python, Excel/VBA and Tableau to meet my designation requirements. Familiar with cloud-based technology, Agile Software Development Life Cycle (SDLC) methodology. Earned Master of Finance degree at Rotman School of Management at University of Toronto. Highly interested in the career of data analysis and eager to develop my career and skills in it.
● Gathered requirements for strategic customers’ inventory management needs, developed KPIs and PowerBI dashboards to measure stock status, performed and provided weekly reports and ensured accuracy of forecast data, strengthened strong customer relationship through effective communication and prompt service, kept implementing enhancement on dashboards and process, reducing preparation time up to 40% ● Collaborated with cross-functional teams to design and implement solutions using Alteryx to remedy backordered issues, and provide alternative or substituted products ● Provided real-time information of backordered items, substitution items, availability information, pricing and product attributes to sales representative, successfully helping them retaining the customers and expanding customer base ● Applied our analytical platform on both tactical and strategic initiatives on national-wide fees policy, ensuring alignment with the overall strategy, identifying revenue/saving opportunities though comprehensive analysis, real-time visualization results and approved solution implementation with actual policy change ● Led systems implementations and enhancements including migrating data from old system to new one, conducting usage and business case reviews with stakeholders from cross-functional partners, and working closely with IT departments to ensure smooth data transfer and data integrity on UAT (user acceptance testing) and Prod ● Developed and delivered training programs for onboarding new team members to ensure they are proficient in using all BI tools, knowledgeable about our business lines, and adhering to prescribed processes ● Provided ongoing assistance to address ad hoc requests and challenges related to system and processes from stakeholders and cross-functional partners on new and existing initiatives
• Cleaned depositor' data by imputing the missing data by linear regression, and smoothing the outliers • Developed segmentation strategies to improve the marketing effectiveness on selling personal loan products to existing liability customers • Analyzed client's characteristics, such as monthly credit card spending, and visualized the distribution of these features to identify highly potential customers