Ananthraman Dharmaraj

Experience

• 

  Mphasis

  Sept 2021 - now

  • I extracted, cleaned, and analyzed complex datasets to derive actionable insights, creating dashboard reports by utilizing Excel, SQL Server, and Python.• Proficient in leveraging Power BI Services by utilizing parameters and DAX functions to create interactive, insightful reports, and dashboards. • Developed interactive visualizations, managed data relationships, including row-level security, for precise data control, resulting in a 17% increase in data accessibility and an improved decision-making process. Show less

  • Data Analyst

    Oct 2022 - now

  • Project Management Analyst

    Sept 2021 - Oct 2022
• 

  JPMorgan Chase & Co.

  Jun 2023 - Jun 2023

  JP Morgan Chase & Co Excel skills Virtual Program

  * Acquired proficient command of Excel functionalities and data analysis techniques, including data cleansing, and manipulation, and conditional formatting techniques. * Acquired proficiency in automation by learning to record macros and script in Visual Basic for Applications (VBA), developing two functional macros integrated with buttons using account sales data. * Gained expertise in data visualization and storytelling using Excel and PowerPoint by creating impactful charts and interactive dashboards. Show less

• 

  PwC India

  Aug 2023 - Sept 2023

  PWC Power BI

  * Completed a job simulation where I strengthened my PowerBI skills to better understand clients and their data visualisation needs. * Demonstrated expertise in data visualization through the creation of Power BI dashboards that effectively conveyed KPIs, showcasing the ability to respond to client requests with well-designed solutions. * Strong communication skills reflected in the concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis. * Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at the executive management level, highlighting a commitment to data-driven decision-making. Show less

• 

  Accenture in India

  Jan 2024 - Feb 2024

  Accenture Data analytics and Visualisation

  * Completed a simulation focused on advising a hypothetical social media client as a Data Analyst at Accenture * Cleaned, modelled and analyzed 7 datasets to uncover insights into content trends to inform strategic decisions * Prepared a PowerPoint deck and video presentation to communicate key insights for the client and internal stakeholders