ARUN JAYARAJ
DATA ANALYST
Malappuram
Summary
Analytical and business-focused Data Analyst with 10 months of real-world experience transforming data into strategic insights through interactive dashboards, automation, and reporting solutions. Proven expertise in Power BI, SQL, and Excel to analyse trends, monitor performance, and support data-driven decision-making across departments, with foundational knowledge of Python for data analysis. Hands-on experience in building and managing Microsoft SharePoint sites and developing custom Power Apps to streamline workflows and enhance business processes. Known for solving problems with a data-first mindset, improving reporting efficiency, and delivering clear, actionable outcomes that align with business objectives.
Overview
2
2
years of professional experience
3
3
years of post-secondary education
3
3
Certificates
Work History
DATA ANALYST
PAYCORP SOLUTIONS PRIVATE LIMITED
07.2024 - Current
- Monthly Dashboard Development & Performance Analytics: Designed and automated monthly interactive Power BI dashboards and reports to track key KPIs such as mandate count, transaction volume, and revenue trends, leveraging Excel, SQL, and SharePoint for data integration and cleaning. Delivered forecasting, trend analysis, and real-time business insights to support cross-functional teams and reduced manual reporting time by 40%.
- Product & Customer Performance Dashboards: Developed and maintained product-wise and customer-wise Power BI dashboards to monitor daily and weekly growth, integrating data from SQL and SharePoint. Tracked each customer's usage of products, including status indicators such as Authorized, Unauthorized, and Pending, enabling the business to quickly identify onboarding issues, improve product adoption, and prioritize client support. Delivered a holistic view of product penetration and customer performance to support cross-functional decision-making.
- Revenue Trend Reporting & Customer Insights: Built automated Power BI reports to track expected vs. actual revenue, forecast future earnings, and identify deviations for timely action by finance and leadership teams. Integrated customer-wise revenue analysis to highlight top-performing and low-performing clients, uncover revenue contribution trends, and deliver actionable insights for targeted engagement and strategic planning.
- Power Apps and SharePoint Integration: Developed custom Power Apps for internal teams to streamline status tracking, data entry, and updates; managed SharePoint lists and document libraries for centralized reporting and collaboration.
Data Analyst Intern
AI VARIANT
06.2023 - 12.2023
- Performed data analysis on 50,000 employee’s datasets to gain insights into the factors influencing employee attrition and performance within the organization using data analysis tools like Excel, Power BI, SQL and Tableau.
- Identified the patterns, trends, correlations and potential areas for improvement that can help the organization better understand and manage employee attrition and performance. Enhanced decision-making processes through data driven insights.
- Identified reasons for employee attrition. Helped the organization to tailor retention strategies and Improve retention rates by providing the suggestions based on valuable insights.
- Designed and developed interactive dashboards in Power BI and Tableau to visualize attrition trends, performance metrics, and department-wise employee turnover, enabling leadership to make timely, informed HR decisions.
Education
Master of Science - PHYSICS
MES KVM College
Valanchery, Kerala 06.2019 - 11.2021
DATA ANALYTICS CORE PYTHON -
EXCELR Academy
Bangalore, Karnataka 06.2023 - 12.2023
Skills
Data Visualization: Power BI (Dashboards, DAX, Power Query), Tableau (basic)
Data Analysis: Excel (Pivot Tables, VLOOKUP, Power Query), SQL, DAX, Power Pivot
Programming: Python (Pandas, NumPy, Matplotlib)
Reporting Tools: Power BI, Excel, SQL (Databases), SharePoint, Power Query(ETL processes, Data transformation)
Tools & Platforms: Microsoft Power Apps, SharePoint
Data Management: Power Query, Power Pivot, SQL, SharePoint (Data management, Site creation, List management)
Soft Skills: Analytical Thinking, Communication, Problem Solving, Team Collaboration
Certification
ExcelR Solutions - Data Analyst, 16044/EXCELR/05102023
Timeline
DATA ANALYST
PAYCORP SOLUTIONS PRIVATE LIMITED
07.2024 - Current
Data Analyst Intern
AI VARIANT
06.2023 - 12.2023
DATA ANALYTICS CORE PYTHON -
EXCELR Academy
06.2023 - 12.2023
Master of Science - PHYSICS
MES KVM College
06.2019 - 11.2021