At JayConsulting, we partner with our customers, share our experience and knowledge, and grow together. We only have one common goal, which is to make us a better us than who we were yesterday.We believe data is an essential ingredient to all organisations. Through data, businesses can better understand their customers, provide better service, and better products to fulfill their needs etc.Specializing in providing data/BI solutions for Microsoft Dynamics 365, we build a strong partnership with our customers to shape data strategy, architect enterprise data assets into valuable insights and help businesses to get better with what we do.Things we do:* Data cleanse and preparation* Data extract and transformation* Data integration and migration* Data warehouse and BI architecture* Machine learning and AI* Application development and enhancement* SQL performance tuningAnd all these services are primarily based on Microsoft/Azure technology stack, including:Application stack:* Microsoft Dynamics AX 2012* Microsoft Dynamics 365 FinOps, CE etc...Data storage stack:* Microsoft SQL Server* Microsoft SQL Server Analytics Services* Microsoft Azure Data Lake* Microsoft Azure SQL Server/DatabaseData orchestration stack:* Microsoft SQL Server Integration Services* Microsoft Azure DevOps* Microsoft Azure Databrick (SparkR, SparkSQL, Structured Streaming)* Microsoft Azure Data Factory* Microsoft Azure Machine Learning (R coding)* Azure Synapse* WhereScape RedPresentation/Visualization stack:* Microsoft PowerBI* Microsoft SQL Server Reporting ServicesMicrostrategy Apart from Microsoft platforms, JayConsulting can also offer end to end solution design and implementation with Microstrategy product suite, including activities like* Environment provision* Data/Cube modelling* Report/Document/Dashboard/Hyper-intelligent developmenthttps://jayconsulting.co.nz/

Projects Involved: • Capitation Based Funding (CBF) Program, Care-Plus, Diabetes etc• Implement and develop New Funding Program databases • Maintain and facilitate Dashboards• 24HRs surgery financial data reportingCurrent Work Involved: • ETL data accurately from appropriate sources, involving database backup and restore process • Develop and implement SSAS, SSIS and SSRS tools• Participate in the development of new reporting data warehouse, includes fact tables and dimension tables design• Process and populate data warehouse, OLAP_CUBE etc• Develop of statistical model to provide information and support for forecasting purpose• Responsible for making high accuracy monthly payments CBF payment to 94 GPs within Canterbury region Clawback referral adjustment Miscellaneous Claims for Practice Referrals • Active involvement with operational staff• Exposure to other health agencies such as the DHB/MOH• Provide financial reports and monitors on regular basis

Start as an Electrician in the company, target in Residential and Commercial Electrical works. Taking up a challenge to managing small to medium projects for the company, in terms of coordinating trade men from different areas.Developed: - efficient time management skill - project/financial budget management knowledges - social skill- health and safety thinking in a project manager perspective

Working in a effective and dynamic production line environment. Collate with sales team and dispatch team. Manage to deliver high accuracy and quality product to meet sale's orders. Developed: - capacity working under pressure and deadline approach- knowledge of production line structure- team bonding activity- factory health and safety requirement

Work as part-time in a busy kitchen environment. Provide customer services and orders.Developed:- communication skill