Summary
Overview
Work History
Education
Skills
Educational Projects
Trainings Certificates
Accomplishments
Timeline
Generic
GANDHI SIRIVESHI

GANDHI SIRIVESHI

Hyderabad

Summary

Logical Data Analyst is skilled in requirement analysis, and database management. Self-directed and proactive professional with 2 years of vast experience collecting, cleaning, and interpreting data sets. Natural problem-solver possessing a strong cross-functional understanding of information technology and business processes. Skills in SQL, Python, Excel, Power BI, Azure Data Factory, Azure SQL Server.

Overview

5
5
years of professional experience

Work History

Data Analyst

PBI Analytics Private Limited
Remote
09.2023 - 02.2024
  • Developing the ELT/ETL pipelines
  • Ingesting the data from various sources like on-prem databases, and HTTP servers, files
  • Transforming the data into business needs using the data flow activities and following the data lake house architecture(medallion architecture)
  • Implementing the delta lake format
  • Loading the data into Azure SQL Server using the loading technique
  • Writing queries in SQL to extract data from the database
  • Implementing the SCD types to check the data changes in the databases
  • Implementing the Data Modelling using the Data Dictionary and Data mapping.
  • Designed automated ETL processes for efficient data extraction, transformation and loading in order to improve accuracy and reliability of reporting systems.
  • Leveraged SQL queries to extract, transform and load data into databases.

Sr Associate

Kfintech Private Limited
Hyderabad
06.2021 - 09.2023
  • Reconciliation for the transactions pending using MS Excel, while fetching transactional data from the data lake, liaising with relevant stakeholders for data correction, and data issues
  • Analyzed business requirements into technical requirements for reporting and visualizations using power bi.
  • Retrieving the data from the databases using SQL queries for analyzing data
  • Analysing the data to check whether the transactions are pending or processed
  • Used Excel to create Daily Reports, to be further shared with clients and senior management
  • Cross-team collaboration with internal and stakeholders, helping the clients in resolving corrections of customer details
  • Handling Escalations of NCT and Channel Partner queries.
  • Developed complex SQL queries to extract and analyze data from multiple sources.
  • Generated daily, monthly and annual reports to address short- or long-term business intelligence questions.

Tele Sales Officer

Reliance General Insurance
Hyderabad
07.2019 - 09.2020
  • Data Cleansing and Data Manipulation for customer leads data, uploading the cleaned data to the database, to be further consumed by various tools
  • Maintained daily, weekly and monthly reports in Excel, ensured the relevant stakeholders gets clearer picture of the customer leads status, calling agent status.
  • Developed MIS reports to track customer service performance and identify areas for improvement.
  • Created and updated user-friendly spreadsheets on daily basis.
  • Created dashboards and visualizations to present data insights in an easy-to-understand format.
  • Created tables, pivot reports, and charts for information tracking purposes.

Education

Bachelor's of Science -

Loyola Academy Degree And PG College
04-2019

12th Standard -

Sri Vijaya Sai Junior College
04-2016

10th Standard -

Indur Model School
04-2014

Skills

  • Programming Languages: Python, SQL
  • Data Science Technologies: Statistics, Visualization, numpy, pandas, matplotlib, seaborn, sklearn
  • Cloud Technology: Azure SQL Server, Azure Data Factory
  • Data Modeling
  • Reporting Tools
  • Data Visualization and Presentations
  • Python Programming
  • Tableau & Power BI
  • Data Analysis
  • Advanced Excel

Educational Projects

  • EDA on e-com Myntra Fashion Clothing: Performed data cleansing and manipulation on Myntra e-com dataset to perform Exploratory Data Analysis, to understand the customer buying behavior, Performed univariate and bivariate analysis on variables to bring out the correlation between different parameters, Top 3 factors affecting the purchasing behavior are Colour, Price and total number of product images, Used visualization to observe the effect of parameters such as number of images, price, primary color on overall data
  • Exploratory Data Analysis on Crop Production: The data is an open source dataset on State-wise Crop Production in India at kaggle for 1997 to 2015 having 246091 records and 7 variables, Evaluated and performed Exploratory Data Analysis to bring insights into Indian agriculture status: state-wise, district-wise, crop-wise, area-wise and levels of productions, Data Preparation and Data Cleaning using pandas and numpy library and Visualization using matplotlib and seaborn, Analyzed each variable, the trend and relationship among them, thus creating a number of problem statements to discover patterns and to spot anomalies
  • HR Business Intelligence Project (Power BI): Used Python to understand business parameters and factors affecting the attrition, identified ways to improve the business, Exploratory Data Analysis, in order to get the insights about the dataset having 1470 records., Extensive use of Python libraries such as pandas, and NumPy to perform univariate and bivariate analysis, to find out the correlation between different factors affecting the business, Top 3 factors affecting the attrition behaviors for the company - Life Sciences, age of 25-34, Count of Males, Analyzed each variable and explored the identified KBR's to get KPI's responsible to achieve the desired goal, Performed correlation analysis in Python on quantitative variables to understand the effect of one on the other

Trainings Certificates

  • Learning Path in Data Science | Board Infinity | 2021-22
  • Learning Path in Data Science | Almabetter | 2022-23
  • Participated in the Python Hackathon Organized By Board Infinity.
  • National Cadet Corps Army wing 2 (T)

Accomplishments

  • The Star Employee in Kfintech Private Limited in 2022.

Timeline

Data Analyst

PBI Analytics Private Limited
09.2023 - 02.2024

Sr Associate

Kfintech Private Limited
06.2021 - 09.2023

Tele Sales Officer

Reliance General Insurance
07.2019 - 09.2020

Bachelor's of Science -

Loyola Academy Degree And PG College

12th Standard -

Sri Vijaya Sai Junior College

10th Standard -

Indur Model School
GANDHI SIRIVESHI