CHARAN GANDHAM

Retail Specialist, Sales focused

Telstra•  May 2023 - August 2023•  WA

Utilized Salesforce and Siebel platforms to manage customer interactions, ensuring a seamless and personalized customer experience. Consistently exceeded sales targets through effective use of CRM tools, identifying opportunities for upselling and cross-selling. Analyzed customer data and sales trends to inform marketing strategies and improve customer satisfaction. Delivered exceptional customer service, handling inquiries, and complaints, and providing tailored solutions to meet customer needs. Trained new staff on the use of Salesforce and Siebel, enhancing team productivity and efficiency. Identified and implemented process improvements within the CRM systems to streamline operations and improve data accuracy.

Junior Business Intelligence Analyst

St. John Ambulances•  May 2023 - August 2023•  WA

Analyzed complex datasets to identify trends and insights, improving decision-making processes. Crafted reports utilizing Excel and PowerBI, dispatching them to over 50+ hospital departments in Perth. Utilized SQL for data extraction, manipulation, and analysis, ensuring accurate and timely reporting. Proficient in constructing interactive dashboards with tools like Excel & PowerBI to enhance data visualization and stream decision-making. Automated routine data tasks to streamline workflows and increase productivity. Worked closely with cross-functional teams to understand data needs and deliver actionable insights.

Jnr Data Analyst

Lexica Pvt Ltd•  January 2022 - October 2022•  NSW

Worked closely with the analytics manager to assess business requirements for a better solution by manipulating databases on premises. Managed large datasets with 35k observations using regular expressions and selecting key variables to build models for statistical logic. Performed Data cleaning and modeling by accessing information from more than 500+ customers in retail sector. Created dashboards using PowerBI to display 15+ KPIs related to internal operations and produced reports using SSRS and advanced Excel spreadsheet functions.

Data Analyst Intern

La Trobe CTI•  December 2019 - April 2020•  VIC

Worked on North Melbourne Smart Cities IOT project initiated by 5 major city councils in data collection and reporting unit. Collected large amounts of live streaming data from sensors such as people counting, air quality, bin fill level, water level, and asset tracking and deployed storage solutions in Azure data lakes using ETL Procedures. Researched and detected valuable data sources and automated collection processes.