Simon Jiang Email & Phone Number

Calgary, Ab, Ca

Calgary, Alberta, Ca

- Scout and evaluate new technologies to solve business problems- Focus on advanced analytics and big data

Calgary, Alberta, Ca

Leadership• Team managemento Lead corporate Business Intelligence initiatives and supporto Assign projects and tasks to team members according to their expertise and prioritieso Write annual performance reviews and provide feedback for their growtho Present employee recognition in IS group meetings for project achievements• Budgetingo Budget annual projects and enhancements for BI initiativeso Estimate annual license purchase costs and reconcile costs on a quarterly basis• Stakeholders managemento Manage stakeholder expectations with various business areaso Facilitate bi-weekly stakeholders meetings with project statuseso Organize large internal quarterly Tableau/Power BI user group meetingso Organize quarterly user lunch & Learn sessions to demonstrate new technologies and best practices • Project managemento Planned projects such as Tableau/Power BI/SSRS/Informatica upgrades, enhancements and ETL projects (such as E1 Financial Data, CMS projects)o Wrote Statement of Work or decision summary and solicited project approvals from IS management committeeo Built project teams and implement projects such as annual Tableau upgrades• Coaching/Mentoringo Mentored junior team members with internal processes and technical skillso Coached/cross-trained team members with technical techniques and step-by-step solutions such as Informatica 10.2 Implementation• Hiringo Wrote job descriptions to hire BI developers and studentso Worked with HR recruiters to conduct interviews• Partnershipo Maintain relationships with BI/ETL tools vendors, such as Tableau, Microsoft Power Bi, Snowflake

Calgary, Alberta, Ca

Analytical• Setup BI governance framework with new policies and processeso Created Naming convention standardso Created projects/documents repository standardso Established software request processeso Created and maintained License management processeso Created dashboard development and deployment processes o Setup security standards o Setup user permissions management processeso Setup internal user group meetingso Setup training processeso Defined RACI matrix for BI support team, Ops team and business area support teams• Setup BI infrastructure guidance and implementationo Built optimal and cost-effective server architecture for Tableau and Power BI o Created backup/recovery strategy and processes at ESX box level o Created dashboard administration processes and repository structure o Enabled external mobile access infrastructure (Proxy) for field users and contractors• Author reports and dashboardso Created various dashboard and report drafts for business userso Helped BI users pass learning curveo Troubleshot challenging issues and calculations on a daily basis• Build ETL processeso Helped customers build ETL processes for new BI projects• Support and troubleshootingo Monitored Service Desk queues for BI requestso Troubleshot issues via support tickets, phone calls and emailso Resolved technical analytical issues when neededo Worked with vendors to resolve software issues• Train new userso Setup training contracts with 3rd party professional trainerso Pre-planned and setup corporate training schedules and trained customers with BI/ETL toolsTechnical• Built architecture of enterprise BI solutions such as Tableau, Power BI, SSRS• Planned and executed BI/ETL systems installation and upgrade projects such as Tableau 2018.3, Power BI March 2019, SSRS 2017, Informatica 10.2• Coordinated and developed ETL projects such as ETL financial data from Oracle JDE to CODS• Developed and managed various in-house applications

Th

• Worked with business users, designed and developed 14 Windows and web based projects using C#.NET, VB.NET, ASP.NET, AJAX, Web Service, Crystal Reports, SQL Reporting, Active Reports, Power Designer, SQL Server 2000/2005• Designed and developed 16 widely used InfoPath forms• Worked with Human Resources on projects such as Employee Exiting, Employee Attendance Tracking, Employee Bonus Calculation, Employee Benefit Package Entry, Employee Recognition Tracking and various Employee forms• Worked closely with customers to gather user requirements• Worked on MS Great Plains customizations and worked as a SharePoint administrator• Served customers when helpdesk tickets assigned• Conducted interviews to hire new application developers

• Supervised junior developers• Gathered and analyzed customer requirements for BCSJ Department Store Management System (MIS)• Analyzed and designed Client/Server system architecture of MIS systems• Designed Suppliers Management, Inventory, Membership Management, Point Of Sale and Reporting modules• Designed test plans and test cases• Developed modules like POS, Inventory Control • Developed hardware drivers for POS • Maintained old versions of MIS• Wrote user guides and trained end users

• Designed components of locomotive bogie (AutoCAD)• Designed fixtures• Designed machining processes for locomotive components• Wrote CNC Machine programs