Ningye (Emerson) Pan, Mba Email & Phone Number

Toronto, Ontario, Canada

Toronto, Ontario, Canada

Toronto, Ontario, Canada

Toronto, Ontario, Canada

• Chosen for a newly created coach role because of the top performance. Led and coached 10+ team members with increased responsibility for project management, people management, and process re-engineering since May 2017
• Engaged in designing and planning Project 34 as the lead of the Billing translation working stream
• Achieved the go-live milestone as planned by leading and coaching 10+ team members
• Collaborated with internal and external IT partners to outline a new data model… Show more Chosen for a newly created coach role because of the top performance. Led and coached 10+ team members with increased.
• Collaborated with internal and external IT partners to outline a new data model for optimizing North American business operational system and process
• Estimated and monitored the project deliverables by analyzing various scenarios including internal and external stakeholders’ requirements, business objectives and resources allocation

Toronto, Canada Area

• Analyzed customer data, registration data and results to target potential customers, and enhance operational efficiency
• Prepared monthly reports with KPIs to managers in analyzing client successful rate and project status and performance using Excel and SQL
• Utilized CRM system to manage milestones, timelines, to-do lists and efficiently track and update the progress in career consulting projects
• Maintained client databases; conducted data quality and data integrity checks
• … Show more
• Assisted with creation of projects, communication reports, and evaluating resultsTools Used: CRM system, Excel, VBA, SQL, PowerPoint Show less

Ontario, Canada

• Collected and analyzed customer data from SAP using SQL and Excel
• Cleansed, corrected raw data by using effective data ETL skills including Merge, Join, Hash Table, Macro, Sort, Formats, Array and conditional logics
• Designed and implemented an issue tracking spreadsheet using VBA macros and advanced Excel functions (VLookup, HLookup, If, Countifs, D-Count, Index, Match, Pivot Table)
• Improved the accuracy of billing and metering process resulting in increased customer… Show more
• Improved the accuracy of billing and metering process resulting in increased customer satisfaction
• Provided progress and performance reports to managers

Guiyang, Guizhou, China

• Resolved customer issues in a friendly and timely manner; achieved 100% customer satisfaction
• Helped manager in marketing research, customers acquisition, and customer segmentation

Haerbin, Heilongjiang, China

• Conducted a statistical analysis on historical census data using Excel and SPSS
• Proposed policy adjustments to lead to the sustainable development of the region
• Published the results in “The Commerce and Economy Post”Tools Used: Excel, VBA, SPSS

Master Of Business Administration (M.B.A.), Finance, A

Bachelor Of Management, Business Administration And Management, General, A

Activities and Societies: Research Assistant, Arts and Cultural Society of University