Wei J. Email & Phone Number

Toronto, ON, CA

• Achievements: 1. Lead the team to deliver the project on time within budget 2. Polish and complete the BA template to reduce the configuration time by 50% 3. Coordinate and collaborate with business in the process of.
• Work in an Agile scrum team to design and deliver web applications
• Design workflows using tools such as Visio
• Work closely with the business team to gather requirements and convert them into documentation, eg. Story Maps, Jira and Confluence
• Provide optimal solutions to prioritize deliverables with effective sprint planning
• Maintain a good working relationship with the Business and other project team members to be a strategic partner

• Achievements: 1. Improve Excel functions and VBA to cover all possible scenarios in report templates 2. Optimize 12 periodic reports SAS scripts to reduce running time and assure data integrity
• Deliver monthly and Quarterly reports with 100% accuracy on time
• Work closely with internal stakeholders to convert business requirements into documentation
• Investigate and analyze problems that affect the final result in order to recommend solutions
• Optimize report automation to reduce run time and minimize the occurrence of errors
• Assess capability for implementation from business requirements, identify gaps, and recommend solutions

• Achievements: Communicate effectively with stakeholders to design reports that suit their needs
• Use Excel to manipulate data and build models to forecast funding allocations to support senior management decision making
• Participate in “Disease Pathway Maps: Measuring Costs and Outcomes” research project to manipulate data and generate statistical analysis to turn the data into meaningful reports
• Design user-friendly reports and educate users with written instructions
• Communicate effectively with internal stakeholders on ad-hoc requirements and workbooks to investigate the best solutions to suit their needs

• Achievements: Assured that the forms were distributed to stakeholders with 100% accuracy on GUI and calculations. Created documentation on tracking and updating and holding training sessions on the FAAB website to.
• Modify changes periodically on Oracle Hyperion Planning by using both Web form and Excel smart view
• Record and integrate the data as requested by Statistics Canada
• Lead the team to create documentation on tracking file updates of the Financial Analysis and Accountability Branch website (over 50 new files come in on a daily basis)
• Train two groups of employees on maintaining the website by using Dream Weaver and FileZilla

• Project: 1. Correlation relations between waiting time and patient volumes in each hospital 2. Emergency room waiting time Trending report consolidation Mock-upsAchievements: Automated the report generation process.
• Use Excel Data analysis “Regression” to see the correlations between various variables along the year trend by each month for each Hospital (in total 128 Hospitals). I.e. Correlation between Median of ER length of Stay.
• Use Excel functions (V-lookup, Index, match, if) VBA and macros to design new user-friendly templates of Emergency Room wait time reports which are distributed to the Ministry and Hospitals
• Manage complex combinations, functions and selections inside the excel file without any bugs in macro or VBA
• Best reduced the size of the file and running time by half
• Quality Assure data on the Ministry website each month before it goes out to the public