Aparna S P
Kollam
Summary
Results-driven Data Analyst with a proven track record at Way Dot Com, optimizing database performance and automating reports. Skilled in Tableau, I excel in analytical thinking and collaboration, having successfully identified revenue opportunities and streamlined processes, enhancing decision-making and operational efficiency.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data Analyst
Way Dot Com
TVM
01.2024 - Current
- Led a collaborative project to optimize database performance by analyzing and managing 400+ tables across Dev, QA, and Staging environments
- Partnered with service teams to identify and delete 84 obsolete tables out of 111 while ensuring critical address, vehicle, and lookup tables remained intact due to production and service dependencies
- Coordinated the segmentation of 313 tables into targeted ranges, identified 62 standalone tables with 3 having no service dependencies, and initiated feature-based ERD creation for vertical-specific insights
- Created interactive dashboards in Tableau, managing data refresh schedules, and ensuring smooth database integration
- Analyzed data to identify revenue improvement opportunities and provided cancellation data insights to business stakeholders, aiding in performance improvements
- Familiar with end-to-end Power BI workflows, including data import, SQL connections, Power Query Editor, Power Pivot, and using star schema in Model Viewer
- Successfully automated email reports as requested by Bill and Sharada, enabling better business insights and improved decision-making (Appreciation Email Received)
- Developed a map visualization for the top 5 cities in the US, allowing stakeholders to compare Way's inventory with scrapped data in a clear, pictorial format
- Stabilized the Carwash vertical by streamlining Tableau reports and automating emails, reducing ad-hoc requests and enabling more in-depth analysis
- Provided Carwash revenue analysis to Carwash Operations Team, including key hypotheses and insights on top-performing locations, helping explore potential vendor partnerships and business growth opportunities
- Transitioned from intern to Data Analyst, mastering tools like Tableau, MySQL Workbench, Visual Studio, Excel, Python, Snowflake, MongoDB Compass, DB Viewer, ArcGIS, Power BI, and PostgreSQL, while creating detailed documentation to streamline processes and improve data accessibility
Substitution Trainer
English Mitra
02.2023 - 02.2024
- Trained students of all age groups to build confidence in speaking English
- Guided students with innovative learning methods, focusing on listening, reading, speaking, and writing
- Recognized as the best substitution trainer
Intern
TechHub
TVM
10.2023 - 01.2024
- Developed Python programs using Visual Studio, Jupyter – Anaconda, Google Colab, and Tkinter
- Built a banking program handling bank accounts, deposits, withdrawals, bank fees, and display functions
- Gained experience in machine learning techniques like clustering, regression, and classification
Junior Artificial Intelligence Developer
WebJyor Infotech
TVM
02.2022 - 08.2022
- Researched statistics and machine learning concepts for web development projects
- Contributed to a government-based project for rain predictions by collecting and analyzing rainfall data
Process Expert
Maersk
05.2021 - 08.2022
- Managed documentation and shipping processes for clients like Dollarama, Lewis, Whirlpool, and Puma
- Handled international client communications, shipment tracking, and discrepancy resolution
- Built expertise in shipping processes and logistics
Assistant Team Leader
Wipro (BPO)
12.2018 - 04.2021
- Managed a team of 15 members, conducted daily huddles, monthly meetings, and training sessions
- Handled banking customers through calls and chats, processing loan approvals, payment requests, account/card blocking/unblocking, and handling escalations
- Delivered training on updated banking technologies
Education
MTech - Computer Science and Engineering
RIT, Govt. Engineering College
Kottayam01.2018
BTech - Computer Science and Engineering
College of Engineering Adoor
Adoor01.2016
Higher Secondary (+2) -
Sabarigiri Residential School
Anchal01.2012
SSLC (10th Grade) -
Sabarigiri Residential School
Anchal01.2010
Skills
Technical Skills: Power BI, Tableau, Google Sheets, MySQL, Snowflake,MongoDB, Python (Pandas, NumPy), Git, Excel, data cleaning, and normalization
Soft Skills: Enthusiastic, problem-solving, excellent interpersonal and organizational skills, team player, analytical thinking, adaptability, time management, communication skills, attention to detail, collaboration, leadership,You Tuber
Computer Skills: Data analytics, data visualization, social media management, Microsoft Office (Excel, Word, PowerPoint), spreadsheets, email communication, SQL, Python, Power BI, Tableau, Snowflake, MySQL, Google Sheets, Git, and database management
Volunteer Experience
- Student Coordinator, Social Service Club, 2010–2012
- Student Coordinator, NSS, 2012–2016, participated in seven-day camps
- Vice Chairperson, B.Tech College, 2014–2016
- Best Speaker, M.Tech College, 2017
Project Highlights
- Spearheaded a database optimization initiative, managing 400+ tables across Dev, QA, and Staging environments.
- Automated email reports, enhancing business insights and decision-making (Appreciation Email Received).
- Developed a map visualization for top US cities, comparing inventory with scrapped data for clearer analysis.
- Stabilized Carwash vertical by streamlining Tableau reports and automating emails, reducing ad-hoc requests.
- Provided revenue analysis for key carwash locations, supporting vendor partnerships and business growth.
Accomplishments
- Student Coordinator of the Social Service Club (2010–2012)
- Student Coordinator of NSS (2012–2016), and participated in seven-day camps
- Vice-Chairperson of B.Tech College (2014–2016)
- Awarded Best Speaker from M.Tech College in 2017
Certification
- Advance Tableau for Business Intelligence and Data Analysis from Udemy
- Data Science with Python from Tech E Hub
Languages
Malayalam
First Language
English
Proficient (C2)
C2
Tamil
Intermediate (B1)
B1
Hindi
Proficient (C2)
C2
Affiliations
As a YouTuber, I manage content creation, including promotional videos, editing, and video production, helping businesses reach their audience effectively.
Timeline
Data Analyst
Way Dot Com
01.2024 - Current
Intern
TechHub
10.2023 - 01.2024
Substitution Trainer
English Mitra
02.2023 - 02.2024
Junior Artificial Intelligence Developer
WebJyor Infotech
02.2022 - 08.2022
Process Expert
Maersk
05.2021 - 08.2022
Assistant Team Leader
Wipro (BPO)
12.2018 - 04.2021
MTech - Computer Science and Engineering
RIT, Govt. Engineering College
BTech - Computer Science and Engineering
College of Engineering Adoor
Higher Secondary (+2) -
Sabarigiri Residential School
SSLC (10th Grade) -
Sabarigiri Residential School
Similar Profiles
Vishnu PVishnu P
Senior Software Engineer at Way Dot ComSenior Software Engineer at Way Dot Com
Manu M PillaiManu M Pillai
Sr. Account Executive at Way Dot ComSr. Account Executive at Way Dot Com
Monica GonzalezMonica Gonzalez
Bartender at Dot Dot DotBartender at Dot Dot Dot