Aravinda Raj R

Aravinda Raj R

Power BI, Tableau Data Analyst with Expertise in Data Visualization and Analytics - Aravinda Raj R
India
Tamil, English

About Me

Dedicated and detail-oriented Data Analyst with 4 years of experience in
extracting, analyzing, and visualizing data to drive strategic decisions.
Proficient in SQL, Python, and advanced data visualization tools like T…

Experience

Project - 3 | E - Commerce | American Apparel

WEBTREESM IT SOLUTIONS PRIVATE LIMITED, Chennai
Sep 2020 - Present · 5 years 10 months

Conducted in-depth data analysis for American Apparel in the E-Commerce domain, focusing on customer behavior, sales trends, and inventory management. Developed data-driven insights that optimized marketing strategies and enhanced decision-making processes. Automated reporting dashboards to track key performance metrics, leading to improved operational efficiency and increased sales conversions.

Data Analyst

WEBTREESM IT SOLUTIONS PRIVATE LIMITED, Chennai
Sep 2020 - Present · 5 years 10 months

Created interactive and visually appealing dashboards and reports using Power BI Desktop and Tableau, delivering actionable insights that enhanced data-driven decision-making for business stakeholders.
Utilized Power Query and SSIS (SQL Server Integration Services) for efficient ETL processes, extracting, transforming, and loading data from various sources into a centralized data warehouse, ensuring data consistency and reliability.
Managed and optimized MySQL databases, writing complex SQL queries for data extraction and analysis, and enhancing query performance and data retrieval efficiency.
Designed and implemented business intelligence solutions with Power BI and Tableau to analyze key performance indicators (KPIs), track business metrics, and generate comprehensive reports for financial analysis.
Developed and maintained data warehouse solutions, ensuring seamless data integration from multiple sources and optimizing data storage and retrieval processes to support robust analytics and reporting.
Integrate Python scripts for advanced analytics within the Power BI environment to enhance the depth of analysis.
Applied advanced analytical techniques and statistical methods to large datasets, uncovering trends and generating insights that supported strategic decision-making and risk management in the banking sector.
Collaborated with cross-functional teams, including finance, risk management, and IT, to gather requirements, deliver customized reporting solutions, and present data findings to senior management for strategic planning.

Data Analyst

WEBTREESM IT SOLUTIONS PRIVATE LIMITED, Chennai
Sep 2020 - Present · 5 years 10 months

Proficient in leveraging Power BI and Tableau for comprehensive data visualization, presenting complex data in clear and actionable formats. Skilled in Python programming for data analysis and automation, integrating Python scripts with BI tools for enhanced data manipulation and reporting. Familiar with ETL frameworks for managing data pipelines and ensuring data integrity across systems. Skilled in using statistical methods and tools for analyzing data trends and patterns, providing valuable insights for business stakeholders. Experienced in conducting data research and mining activities to discover hidden patterns and correlations within datasets. Committed to continuous learning and adopting best practices in data analysis to deliver accurate and impactful insights for organizational success.

Project - 2 | Banking | EverBank

WEBTREESM IT SOLUTIONS PRIVATE LIMITED, Chennai
Jan 2022 - Apr 2023 · 1 year 3 months

Created interactive and dynamic dashboards using Power BI Desktop and Tableau to visualize key performance metrics and trends, enabling data-driven decision-making for banking operations.
Utilized Power Query and ETL frameworks to extract, transform, and load data from various sources into MySQL databases, ensuring accurate and timely data for analysis and reporting.
Designed and maintained complex MySQL queries and database structures to support data analysis, optimize performance, and ensure data integrity across banking datasets.
Employed Tableau and Power BI to build advanced data visualizations and reports, translating complex data sets into actionable insights for stakeholders in the banking domain.
Streamlined and automated routine reporting processes through the integration of ETL workflows, reducing manual effort and improving the accuracy of financial and operational reports.
Worked closely with business analysts, IT teams, and financial managers to gather requirements, understand business needs, and deliver tailored data solutions that support strategic initiatives.
Conducted thorough data quality assessments and validation checks to ensure the accuracy and reliability of financial data, leveraging Power Query and MySQL to identify and rectify discrepancies.

Project - 1 |Healthcare |Crozer Health

WEBTREESM IT SOLUTIONS PRIVATE LIMITED, Chennai
Sep 2020 - Dec 2021 · 1 year 3 months

Conducted in-depth data research and mining to extract actionable insights, contributing to strategic decision-making processes within the banking sector.
Utilized Power Query extensively to cleanse, transform, and integrate complex datasets from multiple sources, ensuring data accuracy and consistency for analytical purposes.
Implemented an ETL Framework to automate data extraction, transformation, and loading processes, improving data processing efficiency.
Developed data models to represent business entities and relationships, facilitating accurate reporting and analysis.
Translated complex financial data into visual insights using data visualization techniques, aiding financial planning and analysis.
Conducted statistical analysis on customer behavior data to identify key trends and inform marketing strategies.
Performed data research and mining to uncover hidden insights from large datasets, enhancing business intelligence capabilities.
Leveraged HTML to create an intuitive web interface for accessing and interacting with business analytics dashboards.

Skills

Python Structured Query Language (SQL) Data Modeling Data Warehouse SQL Server Integration Services (SSIS) Data Visualization Power BI Statistical Analysis Tableau MySQL HTML
Report this Profile?