Ares Chen, Mba Email & Phone Number

Mississauga, Ontario, Canada

• Develop complex SQL queries to synthesize large amounts of data into insightful reports and interactive KPI dashboards in Cognos and Power BI to support evidence-based decision making and operational improvement while ensuring sound methodology and technical specifications.• Design, optimize and maintain SSIS packages for ETL implementation in existing data warehouse, investigate data anomalies and propose resolutions to ensure data is accurate and reliable.• Leverage BI tools to… Show more • Develop complex SQL queries to synthesize large amounts of data into insightful reports and interactive KPI dashboards in Cognos and Power BI to support evidence-based decision making and operational improvement while ensuring sound methodology and technical specifications.• Design, optimize and maintain SSIS packages for ETL implementation in existing data warehouse, investigate data anomalies and propose resolutions to ensure data is accurate and reliable.• Leverage BI tools to automate standard internal and external reporting, proactively identify trends, patterns and relationships and then interpret findings, make recommendations to maximize performance and resource utilization across the organization.• Communicate with non-technical stakeholders routinely to answer questions, collect feedback on data related deliverables, and gather new data requests, maintain existing report documentation. Show less

Markham, On, Canada

• Perform ad-hoc SQL queries on real-time and historical data including sales leads, customer profiles and service tickets to identify differences in customer needs, behaviours or preferences then produce analytical reporting to effectively enhance marketing strategies from customer acquisition, retention and satisfaction perspective. • Develop automation in data collection from various sources such as social media, customer feedback and competitor data, then conduct data exploration… Show more • Perform ad-hoc SQL queries on real-time and historical data including sales leads, customer profiles and service tickets to identify differences in customer needs, behaviours or preferences then produce analytical reporting to effectively enhance marketing strategies from customer acquisition, retention and satisfaction perspective. • Develop automation in data collection from various sources such as social media, customer feedback and competitor data, then conduct data exploration, cleansing, manipulation and validation in Python to support a variety of demands on departmental data.• Build and maintain a standard ETL pipeline for the department-wide data warehouse to integrate internal and external data; Create a first-ever user interactive sales dashboard in Power BI to monitor sales KPIs of various products, sales channels and customer segments, identify areas of internal process improvements, marketing campaign optimization and business opportunities. Show less

Markham, On, Canada

• Responded to inquiries for walk-in and call-in customers and processed customer requests regarding sales, billing and account issues in the back-office system with professional etiquette. • Handled escalation service tickets to resolve customer complaints by providing appropriate solutions, coordinated with other teams to follow up with customers, collected feedback, filed accurate records and proactively provided weekly reports to supervisors. • Collaborated closely with different… Show more • Responded to inquiries for walk-in and call-in customers and processed customer requests regarding sales, billing and account issues in the back-office system with professional etiquette. • Handled escalation service tickets to resolve customer complaints by providing appropriate solutions, coordinated with other teams to follow up with customers, collected feedback, filed accurate records and proactively provided weekly reports to supervisors. • Collaborated closely with different departments to report critical issues in SOP, and actively engaged in team brainstorm sessions to make suggestions for enhancing the customer experience. Show less

Master Of Business Administration (Mba), Business Analytics, Gpa 3.3/4.0

Bachelor Of Arts (B.A.), Accounting, Gpa 3.0/4.0

Bachelor Of Arts (B.A.), Finance - Investments And Securities, Gpa 3.2/4.0

Activities and Societies: Youth Volunteers Service Center