Chris Sun Email and Phone Number
PROFESSIONAL SUMMARY A results-driven data manager with 10+ years of leadership experiences in project management including business requirement gathering and understanding, communication and relationship maintenance with clients and stakeholders, project planning and strategy, people management, task management, time management, innovation insights contribution, result validation and delivery. Significant expertise in Big and Complex Data Analysis, Data Cleansing, Data Calculation, Database development, ETL processes, Data Warehousing, Data Migration, Data Modeling, Data Mining, Data Governance, Data Management, Data Mapping and BI Reporting.Strong proficiency in programming languages including T-SQL, SSIS, SSRS, Python, Excel (VBA), VBS, SAS. Strong Financial, Accounting, Tax, and business background. Ability to translate business objectives into actionable technical operations and communicate effectively and clearly with technical and non-technical staff respectively to ensure smooth running of projects. Proven project and team management skills via initialization, execution, and delivery of projects involving multiple stakeholders.SKILLS DATABASE/CLOUD/PLATFORMS: MySQL, SQLite, SSMS (SQL Server), Azure, AWS, Hadoop, Spark, Hive, Snowflake, DatabricksPROGRAMMING SKILLS: SQL, Python (Pandas, NumPy, Scikit-Learn), Excel/Access VBA, VBS, SAS, R, JavaScript, Csharp, C++SYSTEMS/ TOOLS: Alteryx, ERP (Oracle, SAP, Salesforce, NetSuite, JD Edward, Great Plains), GitHub, Visio, Informatica, SWIFTDATA ANALYSIS: Tableau, Power BI, SSRS, SSIS, OLAP, OLTP, Excel/Google sheets, Google Analytics, Data Visualization & Reporting, Data Manipulation/ETL, Data Profiling, Data Quality Validation, Data Lineage, Data Attestation, A/B Testing, MDMBUSINESS KNOWLEDGE: Canadian Tax, Indirect Tax, Accounting Standard and Rules, Financial Product, Financial Reporting,Risk Management, IFRS, CRM, UAT, Financial Analysis, Business Analysis, Reporting Analysis, Agile Methodology (Jira and Confluence), Wealth Management, Portfolio Management, Operational risk, Regulatory Compliance Risk, AML/ATF Risk, Capital Management, Model Validation and Governance, Compliance and Audit, Credit Risk, Stress TestingDATA MODELING: Linear Regression, Logistic Regression, Decision Trees, PD, LGD, EAD, ECLSOFT SKILLS: Leadership Skills, Decision Making, Strategic Planning, Time Management, Adaptability, Business Requirement Collection, Critical & Analytical Thinking, Multitasking & Prioritizing, Attention to detail, Problem Solving, Project Management.
-
Data Manager - Indirect Tax Recovery TeamEy Apr 2019 - PresentToronto, Canada Area● Lead a team to conduct data quality assessments of model input data, making sure data is complete, accurate and well balanced. Implement ongoing monitoring using machine learning techniques and generate alerts if there is any data loading concern.● Heavily involve in communication with external client’s departments including IT department, financial department, and operation department to guide them deliver correct data through either front end or back end of their ERP system (Oracle, SAP, Salesforce, NetSuite, JD Edward, Great Plains). ● Provide final decision and guidance for all external data loading, data transformation and data cleaning. Guide internal team developing ETL solutions to process external client data, making it suitable for integration with our tax audit modules.● Review team’s queries and procedures (SQL, Excel VBA, VBS, Python), and provide recommendations and guidance to make sure the ending result is accurate and meets business requirements.● Develop new data cleansing strategies by Excel VBA or VB Scripts to analyze and assess any missing data values, removing irrelevant or redundant data, removing outliers, and resolving missing data to ensure more consistent and organized information is stored in the data warehouse. ● Present model performance reports to senior executives, identifying issues and potential gaps in existing tax audit modules and optimizing the modules to suit various clients’ business cases.● Lead a team to provide Ad-hoc data analysis and calculations to internal stakeholders for customized tax audit services.● Establish an end-to-end data management function from the ground up, building a high-performing team responsible for data procurement & client management, data advisory, data quality monitoring & operations, and data governance.● Create Stored procedures, User defined functions, SQL scripting using complex joins, sub queries, window functions, cursors, CTEs for complex business reporting. -
Python & Vba Lecturer (Part Time)Savvypro Education Ltd. Apr 2017 - Dec 2019• Taught Python courses including Python module and function define, logic priority.• Taught VBA courses including VBA functions, VBA mapping strategy and VBA project.
-
Revenue Assurance And Reporting AnalystEnercare Inc. Jan 2017 - Apr 201980 Allstate Parkway● Responsible for coding individual programs from specific requirement using T-SQL, extensively used joins, sub queries, correlated queries, and aggregated functions to perform logical transformation on data. Developed Stored procedures, user defined functions and views to enhance, transform data for datamining, data cleansing, data quality and report generation. ● Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter plots in Power BI. Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for data cleansing and data massaging. Created reports utilizing Excel services, Power BI and deploy them to SharePoint Server for business perusal. ● Significantly improved business unit reporting and analysis process. Examples include fully automated payroll process from data mining to reporting export (including more than one hundred of excel reports and 2 CSV data exports) using Excel VBA, SSIS package and SQL, saving more than eight working hours per week. Built full package of reports to meet all financial and accounting needs after fully understood company’s new project - smarter home. ● Transferred data from multiple data sources/ business systems like Oracle, SAP including Excel, Flat Files etc. to SQL Server using various ETL data flows to transform data for analysis. ● Performed data quality checks such as handling missing values and removing invalid data to ensure the requirements accurately match with the project design and build.● Specialized in analytical solutions that provided timely and insightful information to support corporate goals and objectives. Focused on data analytics in the data mining, data cleaning, report automation, data visualization, statistical sampling, business process improvements, and project management. -
Accounting AnalystDowntown Automotive Group Aug 2015 - Dec 2016Toronto, Canada Area● Built financial statement and account automotive reconciliation system using Excel VBA as per CFO’s request; improved reconciliation accuracy and efficiency by saving 90% of business time from manual process. ● Designed and improved production and ad-hoc reporting processes. Identified and resolved data issues, through the interaction with operations, business users and data providers, with the goal of improving process and data quality. ● Troubleshot data elements that had changed or were incorrect in the system. Performed data checking and data cross checking. ● Developed and delivered executive-level reports and analysis using Excel VBA. -
Reporting AnalystJinan Ring Expressway Jan 2012 - Aug 2012• Led a team of developers and business analysts to build data solutions and maintained responsibility for accurate and timely preparation of regular scheduled reports that drove business decisions.• Specialized in analytical solutions that provided timely and insightful information to support corporate goals and objectives. Focused on data analytics in the data mining, data cleaning, report automation, data visualization, statistical sampling, business process improvements, and project management. • Specialized in analyzing and testing data conversions to ensure accuracy and completeness.
-
Campus Sale Representative LeaderChina Mobile Limited Oct 2008 - Mar 2009Jinan, Shandong, China• Coordinated and arranged all important aspects of the team• Led team to achieve No. 1 in sales volume of Jinan in winter, 2008
Chris Sun Education Details
-
Brock University82/100 -
Shandong University Of Finance And Economics85/100
-
Cpa In ProgressAccounting
Frequently Asked Questions about Chris Sun
What company does Chris Sun work for?
Chris Sun works for Ey
What is Chris Sun's role at the current company?
Chris Sun's current role is Data Manager - Ernst & Young.
What schools did Chris Sun attend?
Chris Sun attended Brock University, Shandong University Of Finance And Economics, Cpa In Progress.
Who are Chris Sun's colleagues?
Chris Sun's colleagues are Suvankar Roy Fca, Ismaele Bassani, Mrugesh Gorane, Leonardo Di Molfetta, Vera Kong, Sherin K George, Pradeepkumar Deva.
Not the Chris Sun you were looking for?
-
2spglobal.com, alumni.utoronto.ca
-
2live.ca, ibm.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial