Subbiah Cheranthian

Experience

• 

  Hexaware Technologies

  Dec 2014 - Mar 2015

  Software Engineer

  • Developed and maintained data models to ensure high data quality and uniformity for analytical purposes.• Analyzed disparate data subsets to extract and communicate meaningful conclusions using SQL.• Leveraged Tableau and Power BI to extract insights and communicate findings to stakeholders.• Displayed comprehension of CI/CD workflows and automated testing, ensuring data reliability.

• 

  Railway Mail Service

  Mar 2015 - Dec 2016

  Data Analyst

  • Produced and submitted daily reports, consolidating operational data for auditing purposes.• Boosted query execution speeds by 125% in various transactions by creating indices in tables.• Utilized sales performance analysis to drive informed decision-making and strategic-planning.

• 

  Axis Bank

  Sept 2018 - Aug 2021

  Data Analyst

  • Developed a dashboard using Tableau and SQL to identify high-transaction customers with substantial Monthly Average Balances, resulting in achieving 3 times the YTD target for Specific investment products within our cluster.• Improved customer acquisition strategies by building a customer 360* report using in-house reporting tool Branch Analytics by CRM data integration• Developed a customer segmentation dashboard using CRM Next and Tableau integration using SQL.• Identified high-net-worth individuals using visualization tools like Tableau and Excel Reports. Show less

• 

  CrowdDoing

  Jun 2023 - Mar 2024

  Data Analyst

  .• Analyzed 2020 and 2021 data to assess housing affordability, calculating the percentage of median income required for a median home in a specific county• Developed a Housing Market Dashboard using single-home family prices up to 2020 that shows average house price trends by zip code or city in California

• 

  Ascendion

  Mar 2024 - Jun 2024

  Data Engineer

  - Healthcare dataset analytics using GCP - BigQuery, Data Orchestration, Pyspark, Python frameworks, Cloud Composer, Airflow, DAG, Docker, etc.- Designed, implemented, and optimized data pipelines to efficiently handle the extraction, transformation, and loading.- Utilized cloud composer alongside a cluster of nodes to achieve the efficient management of data pipelines using DAG in Airflow.