Summary
Overview
Work History
Education
Skills
Skills
Timeline

Rajesh Sekar

Data Analyst
Chennai

Summary

Detail-oriented Data Analyst with 2 years of experience in the telecom industry, specializing in extracting actionable insights from large datasets to improve decision-making and optimize customer satisfaction. Proficient in statistical analysis, data visualization, and utilizing analytical tools to drive business growth. Adept at collaborating with cross-functional teams to streamline operations and enhance the customer experience.

Overview

2024
2024
years of professional experience
5
5
years of post-secondary education

Work History

Data analyst

Verizon
8 2022 - 10.2023
  • Company Overview: Telecom Customer Churn Analysis
  • Analyzed large datasets on network performance, customer satisfaction, and usage patterns to identify trends and provide actionable insights to improve service offerings
  • Developed customer churn prediction models using logistic regression and classification algorithms, contributing to a 15% decrease in churn rate over 12 months
  • Conducted billing analysis to identify discrepancies, optimize pricing strategies, and enhance revenue collection processes
  • Built and maintained Power BI dashboards for key stakeholders, allowing real-time tracking of network performance, customer behavior, and support response times
  • Improved data processing workflows, reducing data extraction and reporting time by 20%
  • Telecom Customer Churn Analysis

Data analyst

Allegis Services (India) Private Limited
01.2021 - 03.2022
  • Company Overview: Trade Finance Analytics Project in Power BI
  • Developed an interactive Trade Finance Dashboard in Power BI to monitor key trade metrics such as transaction volume, letters of credit usage, and payment term compliance
  • Analyzed trade finance data from multiple sources, including SQL databases, Excel sheets, and financial transaction logs, and transformed it using Power Query
  • Created custom DAX calculations to track risk exposure, payment delays, and trade flow trends over time
  • Implemented ETL processes to automate data extraction, transformation, and loading from transactional systems to Power BI for real-time analytics
  • Designed time-series analysis for monthly and quarterly trade volume, identifying seasonal trends and anomalies in transaction patterns
  • Utilized geographic heatmaps to display trade exposure by country, allowing the finance team to assess international trade risks and adjust credit limits accordingly
  • Improved reporting efficiency by 30%, reducing manual data extraction and presentation tasks through the use of automated dashboards and scheduled refreshes in Power BI
  • Collaborated with trade finance teams to identify KPIs and design custom dashboards for monitoring compliance, risk, and financial performance across different regions
  • Trade Finance Analytics Project in Power BI

Education

MBA - Finance

Rajalakshmi Engineering College
09.2011 - 05.2013

Bachelor of Computer Applications (BCA) - undefined

Indo-American College
07.2007 - 05.2010

Skills

Python

Skills

Python, SQL & NoSQL Databases (MySQL, Microsoft SQL Server, PostgreSQL), Data Analysis, Data Visualization

Timeline

Data analyst - Allegis Services (India) Private Limited
01.2021 - 03.2022
Rajalakshmi Engineering College - MBA, Finance
09.2011 - 05.2013
Indo-American College - Bachelor of Computer Applications (BCA),
07.2007 - 05.2010
Data analyst - Verizon
8 2022 - 10.2023
Rajesh SekarData Analyst