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 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 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• Tracked and reported project status and upcoming estimates weekly to management; escalated potential roadblocks to ensure on-time high-quality work • Presented training sessions to whole team on real-time project and business requirement changes------------------------------------------------------------------------------------------------------------• Implemented client-based data automated translation workflows to interpret Treaty agreements accurately along with the underlying insurance products reinsured• Be selected to engage in supporting and testing the end-to-end process for the Billing translation working stream of Project 34• Prepared data translation specifications based on business requirements by analyzing client dataand scripting coding logic• Built and maintained various data translation workflows of different working streams to ensureproviding accurate treaty-related data and statistics analysis to internal stakeholders andbusiness partners• Diagnosed error root causes and determined optimal resolutions by analyzing exception handlingreports• Executed a variety of reinsurance processes using SQL/MS Access databases and providedrecommendation to enhance existing reinsurance process management Show less

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 • 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• 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 • 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 satisfaction• Provided progress and performance reports to managers • Assisted in training new employees to effectively utilize the company’s SAP system Tools Used: SAP ERP, Excel, VBA, SQL, PowerPoint, SharePoint Show less

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