Arumugavela Muthiah Email & Phone Number

New Zealand

Auckland, New Zealand

• Monitored and ensured data accuracy and integrity within client management systems.• Analysed complex data, converts it into insights and translate these into information that is accessible to various audiences within the organisation.• Provided business intelligence tool training to key information users. • Generated monthly and quarterly reports of HR data for various organizations supported by PSN in Excel and Power BI. • Ran ACC billing queries in SQL Server using Stored Procedure for claim and also ran the queries for back dates with the modified rates for back claim.• Analysed Payroll data ambiguity and prepared report accordingly for a certain period.

Auckland, New Zealand

Project: Property Analysis of New Zealand and Australia property data setWorked on a cloud-based Property Investment and Management Platform, specifically targeting the data integration of Australia property data. Our team was responsible for the data integration and analysis of Australian property data.Responsibilities:o My responsibilities in MVP Studio were standardized the complex dataset given in different formats mostly in Excel, CSV or Word Doc.o Cleaned the data sets using Power Query to make it easy for analyses and visualizations. o Integrated property data from multiple government data sources to build a complete data set.o Also Created database and tables in SQL Server to store the data and used Stored Procedures and SQL queries to get the relevant data. Used Kimball model to design Data Warehouse in SQL Server and transferred the data into Data Warehouse through ETL for easy and fast access. o And used Power BI, DAX and Power Query to access, analyse and interpret data to deliver easy to consume and actionable insights for the business with a dashboard report .o Created paginated reports through SSRS.Skills used:- Proficient use of MSSQL Server, SSIS, Power Query, SSRS , advanced Excel knowledge and Power BI to develop the solution.- Creation and Optimization of SQL Queries to implement medium to complex business logic for reporting and analysis purposes.

Auckland, New Zealand

• Explained the menus to the patients according to their diet codes, taking orders electronically and uploading the data to the menu processor for further processing.• Collaborated with the team to plan for all tasks to be completed on time, communicating who would be taking different responsibilities.• Handled queries from patients, nurses, doctors, and other stakeholders.• Making sure the stocks were updated properly for everyday needs.• Followed health and safety according to the ADHB standards.• Reported day to day activities to the management and system.Skills: Time Management skills, Problem Solving skills, worked in a fast paced and multi diverse environment.

Manama, Kingdom Of Bahrain

Responsibilities:• Involved in various activities like requirement gathering, designing, coding,testing and implementing the project.• Coded using VB.NET, ASP.NET and Oracle Forms and Reports• Database management in SQL Server and Oracle.Application Data Support Specialist in Ministry of Interior, Customs Affairs Responsibilities:• Analysed the data using T-SQL queries and prepared monthly and fortnightly Reports in Excel sheets using Stored Procedures.• Managed Customers inbound and outbound calls.• Maintained the Database by taking regular backup, recovery and clean-up to make the system work faster.• Coordinated with both the Hitech and the Customs Affairs IT Teams for ongoing modifications and maintenance. Skills: Oracle, VB.NET, SQL Server and Excel

Master Of Computer Applications (M.C.A.), Computer Science

Business Intelligence

Advanced level of SQL, Data warehousing, SSAS,SSIS, SSRS and ETL . Data Visualization using Power BI, Power Query and DAX Language

Level 4, Certificate In Computing, Level 4

Certificate Of Completion, Oracle Database 10G: Pl/Sql Fundamentals, First

Activities and Societies: Oracle Database 10g: PL/SQL Fundamentals Awarding Body Address Oracle Workforce Development Program Oracle.

Certificate Of Completion, Specialisation Microsoft Dot Net Packages, First

Activities and Societies: Specialisation Microsoft Dot Net Packages Awarding Body Address Global Institue for Management Science.