Marc Wong Email & Phone Number

Vancouver, British Columbia, Canada

Manage software development at the Onni Group. Work in the Enterprise Systems team to enhance existing software as well as developed many customized software for the Accounting department and other divisions with in the company. Worked with team of developers and report writers and technical support team to fulfill deployment and support of software at the Onni Group. Created many integrations systems from hospitality data retrievals to utility meters data retrievals to create invoices and reports. Continuing from my last role, I still write many business reports and dashboards.

Vancouver

Works in the Enterprise Application team with in the IT department. Implement Acumatica ERP, with customizations and API integration with external sources. Developed custom data extraction tools to sync from external sources such as hotel/Property management systems such as RSI, Lasso and SalesForce and Yardi into multiple SQL databases; Retrieve data for energy meters such as Audette meters and OnBoardData data meters to create live meter dashboards and billing invoices in our Accounting system. Design and implement interactive SSRS reports with webservices and Nintex Forms in SharePoint for create a live invoice approval system with multiple layers of approvers. Developed SharePoint solutions and workflows to move items from one list to another. Manage SQL Servers and provide SQL Server expertise from creating views, functions, stored procedures, optimizations, and schedule execution of scripts.

Develop applications, writing reports, support clients, and provide consulting services. Work with .Net development tools, Microsoft Office applications and development, SQL Server development and management and Sharepoint development.

Work on the development of Enterprise products, database tools and client support. • Implement & successfully delivered Argus Timberline SQL Warehouse (ATSW). ATSW extracts Timberline data from a slow Pervasive database in to a SQL database on an intelligent level. Speeds up reporting by leveraging against a fast SQL database. • Develop a web service license activation system. Develop a secure licensing algorithm for ATSW.• Consult and deploy SQL Server database and SQL Server Reporting Services (SSRS) for clients. • Troubleshoot SQL Server and SSRS issues• Primary report writer for converting Timberline reports into SSRS reports• Main implementer of SQL Server Reporting Service controls into Argus Enterprise Repertoire Reporting and Sensitivity Analysis in a client/server enterprise application• Wrote many SSRS financial reports. Maintain and wrote Crystal Reports for clients.etc...

Education record

Education record