T

THOTA LALITHA

About

Detail

Telangana, India

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • Cactus Communications
    Business Intelligence Intern
    Cactus Communications
    Jul 2024 - Dec 2024 (6 months)
    ˆ Data Model Optimization: Migrated Tableau data models to Power BI, building relationships, calculated columns, and optimizing performance for large datasets. ˆ DAX Development: Converted complex Tableau calculations into DAX formulas, including conditional statements, aggregations, and date-based logic. ˆ Custom Visualizations: Replicated Tableau visual styles in Power BI to represent KPIs, trends, and summaries accurately. ˆ Data Transformation: Filtered, cleaned, and structured data using Power Query while implementing fiscal calendars and date hierarchies. ˆ Stakeholder Collaboration: Validated migrated reports with stakeholders, provided end-user training, and created transition documentation for Power BI adoption.
  • I
    Assistant Data Analyser
    India Post
    Oct 2018 - Jun 2024 (5 years 9 months)
    ˆ Analyzed customer deposit data across various account types (S.B, R.D, T.D) using advanced Excel functions like VLOOKUP, INDEX-MATCH, and PivotTables, providing detailed reports to superiors to enhance business performance. ˆ Recommended strategies for business improvement by analyzing and interpreting data, achieving targets of 1.5 lakh in policies, 500 new accounts annually, and 30k GAG policies to drive organizational growth. ˆ Actively engaged with customers to procure policies and improve account acquisition, contributing to the organization's financial targets. ˆ Led a project to revive 100% of IPPB accounts, elevating the branch office's performance to the top position in the subdivision.
Education verified_user 0% verified
  • Newton school
    Professional Certificate in Data Science
    Newton school
    May 2023
  • K
    Bachelor of Commerce
    Krishna University
    Jan 2013 - Jan 2017 (4 years 1 month)
  • S
    Intermediate (Class XII)
    S.V.L. KRANTHI JUNIOR COLLEGE
    Jan 2011 - Jan 2013 (2 years 1 month)
  • S
    Matriculation (Class X)
    S.K.R.M.GIRLS HIGH SCHOOL
    Jan 2010 - Jan 2011 (1 year 1 month)
Projects (professional or personal) verified_user 0% verified
  • H
    HR ANALYTICAL DASH BOARD
    ˆ Analyzed data of 1,470 employees with an attrition count of 237, and prepared a column for active employees and attrition counts by department, identifying R D as having the highest employee count. ˆ Created a matrix chart to visualize job satisfaction ratings across departments. ˆ Developed a donut chart to analyze department-wise performance, highlighting R D as the largest department.
  • I
    IMDB MOVIE ANALYSIS
    ˆ Analyzed movie dataset using SQL queries to provide valuable insights for global launch of Bollywood Movies. ˆ Explored movie release trends, production statistics, genre popularity, and rating analysis. ˆ Examined crew members and various aspects crucial for successful global expansion. ˆ Key Skills Used: MySQL, Data Analysis, Data cleaning, Data Interpretation.
  • C
    CREDIT CARD ANOMALY DETECTION
    ˆ Built a Power BI dashboard for detecting anomalies in credit card transactions to identify fraud and analyze patterns. ˆ Used DAX to find insights like average transaction amounts (161.50k ordinary, 881.59k fraudulent) and a maximum fraud amount of 10M, with 383 fraudulent vs. 631k normal transactions. ˆ Visualized anomalies using bar charts (top 10 merchants), scatter plots (old balance vs. transaction amounts), and line charts (CASH IN, CASH OUT, DEBIT, PAYMENT trends). ˆ Highlighted CASH OUT as the most frequent transaction type, with DEBIT transactions lower than CASH IN and CASH OUT.
  • R
    ROAD ACCIDENT ANALYSIS
    ˆ Analyzed road accident data from 2021 and 2022, including severity, location, road type, weather, and light conditions, using ETL tools for data cleaning and transformation. ˆ Created a Power BI dashboard with DAX functions to visualize accident trends, showing a 11.7% decrease in accidents and an 11.9% decrease in casualties in 2022 compared to 2021. ˆ Highlighted insights such as 73% of casualties occurring in daylight, 62% in urban areas, and most casualties (145k) due to single carriageway accidents; mapped casualty locations and used bar and donut charts for detailed visualizations. ˆ Presented data on casualties by vehicle type, showing the highest numbers from car-related incidents (155,804), and analyzed fatal (2,855), serious (27