Rajkiran Murugan
Perth,WA
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Assistant Manager
OTR Retail
06.2022 - Current
- Collaborated in collection and analysis of data from different sources ensuring detailed data integration for analysis.
- Performed an extensive ETL processes across Web APIs, SQL server and cloud services to gather the data and perform an analysis for actionable insights.
- Developed a sales performance dashboard using DAX and M query in Power BI to track the real time sales metrics and view their performances and forecast for the month and reported to the manager.
- Collaborated in developing a HR dashboard to monitor the employee wages and ensure that the rostered hours are matching the budgeted hours to perform cost analysis.
- Managed Power BI Workspaces, Automated data refresh process, User access and Data governance to guarantee efficient utilization of Power BI resources.
- Created a visually appealing and insightful dashboards and reports using Power BI, integrating data from various sources like sales, inventory, and customer data.
- Performed Inventory analysis using Power BI to gain clarity on the stock control and stock movement.
Data Analyst
XR Technica Pty. Ltd
08.2019 - 05.2022
- Collecting information from different sources such as databases, spreadsheets, and APIs to create a insightful dashboard.
- Refining and converting data for accuracy, entirety, and uniformity
- Conducting Exploratory Data Analysis (EDA) to discover patterns, trends, and anomalies within the data
- Producing visual representations (such as graphs, charts, and dashboards) to convey findings efficiently.
- Writing SQL queries to extract and manipulate data from relational databases
- Collaborating with team members and departments to support decision-making based on data and reach company objectives.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Analyzed data to identify root causes of problems and recommend corrective actions.
Customer Service Team member
Coles
03.2017 - 08.2019
- Provide timely and friendly customer service
- Ensure our stores are clean, safe and inviting for our customers
- Maintain store presentation by replenishing and rotating stock
- General housekeeping of the forecourt, store and amenities
- Working through a daily checklist of cleaning task across all departments and store
- Using different types of equipment and products to scrub and buff the floors.
Service Desk Technician
Verve Innovation
03.2016 - 02.2017
- Provide first point of contact to clients through emails and telephone to meet the agreed Service Level Agreements
- Analyze, troubleshoot and document the client issues
- Customer focus and solve their problems
- Troubleshoot basic computer issues for internal clients
- Administer network, applications and user accounts
- Internship
- Samsung heavy industry pvt ltd
Intern At Samsung
Samsung Pty Ltd
12.2012 - 12.2012
- Good knowledge of R&D and how it works
- Working of silicon conductors
- Electronic devices and the use in Samsung.
Education
Graduate Diploma - Management
Lonsdale Institute
Melbourne, VIC11.2023
Advanced Diploma - Leadership And Management
ANGAD Australian Institute Of Technology
Melbourne, VIC11.2021
Master's Degree - Telecommunication And Network Engineering
La Trobe University
Melbourne, VIC01.2017
Bachelor’s Degree - Electronics And Communications Engineering
Sri Venkateshwara College of Engineering
Chennai, India01.2014
Skills
- Data Analytics
- Data Visualization and Presentations
- ETL processes
- Microsoft office
- Microsoft Power BI
- DAX
Additional Information
- Activities and societies: Member of IEEE, Rapid developments in global telecommunication and network technologies made me choose telecommunication and network engineer course. I work with industry recognized hardware and software with lot of laboratory experiences. The course is also strongly focused in aspects of network and computer security using both theoretical studies and practical examples., Activities and societies:
- Member of LEO club.
- Member of IEEE.
- Organized a symposium for electronics and communication. Team member of college cricket team., Electronic communications underpin everyday technologies, from text messaging and air travel to TV and radio. In communication engineering, you’ll develop the knowledge and skills to use electronic, photonics and electromagnetic devices to exchange information among locations on earth and in space., Activities and societies:
- Member of school cricket team
- Participated in blood donation camp, Successfully completed courses in computer science and Mathematics, achieving high grades in both subjects., Participated in science talent hunt conducted by school., Sports Captain AT school., Player in school cricket team and participated in athletics.
Certification
Microsoft Certified: Power BI Data Analyst Associate
Credential ID: 8ADC0F7B45C6C5C7
Microsoft Certified: Azure Data Fundamentals
Credential I: 996391010
Timeline
Assistant Manager
OTR Retail
06.2022 - Current
Data Analyst
XR Technica Pty. Ltd
08.2019 - 05.2022
Customer Service Team member
Coles
03.2017 - 08.2019
Service Desk Technician
Verve Innovation
03.2016 - 02.2017
Intern At Samsung
Samsung Pty Ltd
12.2012 - 12.2012
Graduate Diploma - Management
Lonsdale Institute
Advanced Diploma - Leadership And Management
ANGAD Australian Institute Of Technology
Master's Degree - Telecommunication And Network Engineering
La Trobe University
Bachelor’s Degree - Electronics And Communications Engineering
Sri Venkateshwara College of Engineering
Similar Profiles
Joanna Chow, ASAJoanna Chow, ASA
Finance Accounting Lead at Viva Energy Retail / OTRFinance Accounting Lead at Viva Energy Retail / OTR
Rushita SavaliyaRushita Savaliya
Console Operator at OTRConsole Operator at OTR
Savio RajuSavio Raju
Team Member at OTRTeam Member at OTR
MUSFIKA BINTE ZAMANMUSFIKA BINTE ZAMAN
Project Support Officer at Anjia Property SettlementProject Support Officer at Anjia Property Settlement
Joseph WalkerJoseph Walker
Software Engineer at Self EmployedSoftware Engineer at Self Employed