Flipkart

Data Analyst

KultureHire

Completed a data analytics internship at KultureHire, excelling in Excel, MySQL, and
 Power BI.
 Conducted data analysis on "Understanding Career Aspiration of GEN-Z," creating
 a Power BI Dashboard.
 Utilized Power BI for data visualization and MySQL for data extraction,
 transformation, and analysis.
 Executed complex MySQL queries to address critical business questions and extract
 actionable insights.
 Integrated datasets from MySQL, JSON, and Excel for comprehensive data analysis.
 Implemented data aggregation and transformation processes to enhance data
 visualization.
 Extracted and analyzed key insights from the GenZ dataset, providing valuable
 information for decision-making.
 Recognized as one of the top 5% interns for successfully completing the Project

Data Analytics Learntern

WNS Global Services

In my role at WNS Global Services, I worked all about shipping and logistics. My responsibilities Includes:

𝐁𝐢𝐥𝐥 𝐨𝐟 𝐋𝐚𝐝𝐢𝐧𝐠 𝐂𝐫𝐞𝐚𝐭𝐢𝐨𝐧:Created and updated Bill of Ladings using Opus software based on shipping instructions, ensuring accurate entry of booking numbers, customer names, ship numbers, container numbers, product details, CIEL numbers, costs, and freight charges.

𝐐𝐮𝐞𝐫𝐲 𝐑𝐞𝐬𝐨𝐥𝐮𝐭𝐢𝐨𝐧: Proactively resolved missing details by coordinating with customers and sales teams through email, ensuring all necessary information was updated in the system.


𝐒𝐚𝐥𝐞𝐬 𝐑𝐞𝐩𝐨𝐫𝐭𝐢𝐧𝐠:  Generated detailed sales reports using Excel, identifying bookings without charges, and communicated these to the sales team. Updated sales data in Google Sheets for easy access and collaboration.


𝐓𝐫𝐚𝐢𝐧𝐢𝐧𝐠 𝐚𝐧𝐝 𝐌𝐞𝐧𝐭𝐨𝐫𝐬𝐡𝐢𝐩: Trained new joiners on processes and procedures, conducted virtual meetings to resolve their queries, and ensured they understood the tasks.


𝐓𝐞𝐚𝐦 𝐌𝐞𝐞𝐭𝐢𝐧𝐠𝐬: Conducted daily team meetings to discuss workload, bill corrections, resolved queries, and set targets.

𝐖𝐨𝐫𝐤 𝐀𝐥𝐥𝐨𝐜𝐚𝐭𝐢𝐨𝐧: Assigned tasks to team members based on targets, monitored progress, and updated the status of pending work at the end of each day.


𝐏𝐫𝐨𝐜𝐞𝐬𝐬 𝐈𝐦𝐩𝐫𝐨𝐯𝐞𝐦𝐞𝐧𝐭: Maintained an error-free work environment by seeking guidance from leads, ensuring high accuracy in all tasks, and contributing to continuous process improvement.


𝐑𝐞𝐜𝐨𝐠𝐧𝐢𝐭𝐢𝐨𝐧: Awarded for best working performance in my team, reflecting my commitment to accuracy, efficiency, and continuous improvement.

Associate - Ops in Logistics

𝐌𝐲 𝐉𝐨𝐮𝐫𝐧𝐞𝐲 𝐢𝐧 𝐍𝐮𝐦𝐛𝐞𝐫𝐬 & 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬

Hi👋, I’m Varsha Chitikaneni, a data-driven professional with Almost 3 years of experience in operations and analytics, currently working at Flipkart as a Data Analyst (Supply Planning).

➡️ Supporting grocery supply operations across 35+ fulfillment centers
➡️ Managing planning data, building reports, and solving problems using Excel, SQL & Power BI
➡️ Coordinating with ground, central, and warehouse teams to ensure seamless execution

📦 Earlier at WNS Global Services (Logistics Domain)

➡️ Created Bills of Lading and handled data updates using Excel
➡️ Communicated with international clients via email and virtual meetings
➡️ Trained new joiners and led daily coordination with teams

📊 How I Entered the Data World

➡️ Developed deep interest in data while working at WNS
➡️ Completed a 6-month Data Science Bootcamp (Excel, Power BI, SQL, Python)
➡️ Completed internship at KultureHire, led the “Career Aspiration of GEN-Z” project using SQL + Power BI
➡️ Built real-time dashboards and solved project challenges (FP20, CodeBasics)
➡️ Created a MySQL hotel database and used DML/aggregate queries

🌱 I enjoy turning messy data into meaningful insights that support decisions.

 I’m continuously learning and excited to grow in the data analytics domain.

Let’s connect if you're working with data — or need someone who is! 😊

Hello #LinkedInFamily! 👋

𝐖𝐞𝐥𝐜𝐨𝐦𝐞 𝐭𝐨 𝐀𝐳𝐮𝐫𝐞 𝐒𝐞𝐫𝐢𝐞𝐬 𝐏𝐚𝐫𝐭 - 𝟒!

🔍 𝐓𝐨𝐝𝐚𝐲'𝐬 𝐂𝐨𝐧𝐭𝐞𝐧𝐭:
 ➡️ 𝐀𝐳𝐮𝐫𝐞 𝐅𝐮𝐧𝐝𝐚𝐦𝐞𝐧𝐭𝐚𝐥𝐬 (Part 4)
 🔹 𝐂𝐥𝐨𝐮𝐝 𝐒𝐞𝐫𝐯𝐢𝐜𝐞 𝐌𝐨𝐝𝐞𝐥𝐬
 ▪️ IaaS
 ▪️ PaaS
 ▪️ SaaS

Check the attached file for detailed insights.

I’m not a pro — but I strongly believe in learning together and sharing what I learn. I hope this will help beginners who want to start with 𝐀𝐳𝐮𝐫𝐞 and also those who want to get a basic understanding of cloud concepts.

Check the attached file to learn!

𝐈𝐭’𝐬 𝐚𝐥𝐰𝐚𝐲𝐬 𝐠𝐨𝐨𝐝 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐬𝐨𝐦𝐞 𝐜𝐥𝐨𝐮𝐝 𝐭𝐨 𝐬𝐭𝐚𝐧𝐝 𝐨𝐮𝐭 𝐢𝐧 𝐭𝐨𝐝𝐚𝐲’𝐬 𝐜𝐨𝐦𝐩𝐞𝐭𝐢𝐭𝐢𝐯𝐞 𝐰𝐨𝐫𝐥𝐝.

You can check my 𝐩𝐨𝐰𝐞𝐫 𝐛𝐢 𝐚𝐧𝐝 𝐬𝐪𝐥 𝐬𝐞𝐫𝐢𝐞𝐬 𝐥𝐢𝐧𝐤𝐬 in comment section.

Let's see the next part in the next posts.
Stay tuned! 

let’s keep learning, practicing, and growing together! 🙂

Feel free to connect with me, Varsha Chitikaneni 🙂

Varsha Chitikaneni

Azure series Part -4

Hello #LinkedInFamily! 👋

𝐖𝐞𝐥𝐜𝐨𝐦𝐞 𝐭𝐨 𝐀𝐳𝐮𝐫𝐞 𝐒𝐞𝐫𝐢𝐞𝐬 𝐏𝐚𝐫𝐭 - 𝟑!

🔍 𝐓𝐨𝐝𝐚𝐲'𝐬 𝐂𝐨𝐧𝐭𝐞𝐧𝐭:

 ➡️ 𝐀𝐳𝐮𝐫𝐞 𝐅𝐮𝐧𝐝𝐚𝐦𝐞𝐧𝐭𝐚𝐥𝐬 (Part 3)
 🔹 Public Cloud
 🔹 Private Cloud
 🔹 Hybrid Cloud

Check the attached file for detailed insights.

I’m not a professional, but I enjoy learning and sharing my knowledge in simple words. I hope this will help beginners who want to start learning Azure and also be useful as a quick guide for interview prep.

Let’s see the next part in upcoming posts.

Stay tuned!
Learn, practice, and grow.

Feel free to connect with me, Varsha Chitikaneni 🙂.



#Azure #CloudComputing #LearningAndDevelopment #KnowledgeSharing #MicrosoftAzure #Cloud #TechSkills #ProfessionalGrowth #CareerDevelopment #LearningTogether #CloudFundamentals #Myconnections

Azure series Part -3

Excited to start – “𝐌𝐲𝐒𝐐𝐋 𝐐𝐮𝐞𝐫𝐲 𝐨𝐟 𝐭𝐡𝐞 𝐃𝐚𝐲” 

Every day, I’ll share one SQL problem and explain it with simple logic.

 This will be super helpful if you’re a beginner trying to improve your SQL step by step.

Let’s start with one of my favorites 👇

🔹 𝐏𝐫𝐨𝐛𝐥𝐞𝐦:
𝐅𝐢𝐧𝐝 𝐭𝐡𝐞 𝟐𝐧𝐝 𝐡𝐢𝐠𝐡𝐞𝐬𝐭 𝐬𝐚𝐥𝐚𝐫𝐲 𝐟𝐫𝐨𝐦 𝐚𝐧 𝐞𝐦𝐩𝐥𝐨𝐲𝐞𝐞𝐬 𝐭𝐚𝐛𝐥𝐞 𝐰𝐢𝐭𝐡𝐨𝐮𝐭 𝐮𝐬𝐢𝐧𝐠 𝐋𝐈𝐌𝐈𝐓 𝐨𝐫 𝐓𝐎𝐏.

Many of us first try something like:

𝐒𝐄𝐋𝐄𝐂𝐓 𝐬𝐚𝐥𝐚𝐫𝐲 
𝐅𝐑𝐎𝐌 𝐞𝐦𝐩𝐥𝐨𝐲𝐞𝐞𝐬 
𝐎𝐑𝐃𝐄𝐑 𝐁𝐘 𝐬𝐚𝐥𝐚𝐫𝐲 𝐃𝐄𝐒𝐂 
𝐋𝐈𝐌𝐈𝐓 𝟏 𝐎𝐅𝐅𝐒𝐄𝐓 𝟏;

But what if the interviewer says "Don’t use LIMIT"?
 We need another way.

🔹 Step-by-Step Thinking:
1️⃣ First, get the highest salary:

𝐒𝐄𝐋𝐄𝐂𝐓 𝐌𝐀𝐗(𝐬𝐚𝐥𝐚𝐫𝐲) 𝐅𝐑𝐎𝐌 𝐞𝐦𝐩𝐥𝐨𝐲𝐞𝐞𝐬;

𝐓𝐡𝐢𝐬 𝐠𝐢𝐯𝐞𝐬 𝐮𝐬 𝐭𝐡𝐞 𝐭𝐨𝐩 𝐬𝐚𝐥𝐚𝐫𝐲.

2️⃣ Now, the 2nd highest is simply the biggest salary that is less than the highest.

𝐒𝐄𝐋𝐄𝐂𝐓 𝐌𝐀𝐗(𝐬𝐚𝐥𝐚𝐫𝐲) 
𝐅𝐑𝐎𝐌 𝐞𝐦𝐩𝐥𝐨𝐲𝐞𝐞𝐬
𝐖𝐇𝐄𝐑𝐄 𝐬𝐚𝐥𝐚𝐫𝐲 < (𝐒𝐄𝐋𝐄𝐂𝐓 𝐌𝐀𝐗(𝐬𝐚𝐥𝐚𝐫𝐲) 𝐅𝐑𝐎𝐌 𝐞𝐦𝐩𝐥𝐨𝐲𝐞𝐞𝐬);

✅ Final Query:

𝐒𝐄𝐋𝐄𝐂𝐓 𝐌𝐀𝐗(𝐬𝐚𝐥𝐚𝐫𝐲) 𝐀𝐒 𝐒𝐞𝐜𝐨𝐧𝐝_𝐇𝐢𝐠𝐡𝐞𝐬𝐭_𝐒𝐚𝐥𝐚𝐫𝐲
𝐅𝐑𝐎𝐌 𝐞𝐦𝐩𝐥𝐨𝐲𝐞𝐞𝐬
𝐖𝐇𝐄𝐑𝐄 𝐬𝐚𝐥𝐚𝐫𝐲 < (𝐒𝐄𝐋𝐄𝐂𝐓 𝐌𝐀𝐗(𝐬𝐚𝐥𝐚𝐫𝐲) 𝐅𝐑𝐎𝐌 𝐞𝐦𝐩𝐥𝐨𝐲𝐞𝐞𝐬);

 👉 Break the problem: first find the maximum, then build logic around it.
 👉 This trick works for Nth highest salaries too.

let’s keep learning, practicing, and growing together! 

Feel free to connect with me, Varsha Chitikaneni 🙂


#sql #Myconnections #CBFR #Dataanalytics

Taplio

Varsha Chitikaneni's Linkedin Analytics

Varsha Chitikaneni

Performance ScoreVarsha Chitikaneni's LinkedIn Performance

Varsha Chitikaneni's Best Posts (last 30 days)

Ready to grow your LinkedIn presence?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Varsha Chitikaneni's Linkedin Analytics

Varsha Chitikaneni

Performance Score.css-goub6s{font-size:var(--chakra-fontSizes-md);font-weight:500;color:var(--chakra-colors-gray-600);display:block;margin-top:var(--chakra-space-1);}Varsha Chitikaneni's LinkedIn Performance

Varsha Chitikaneni's Best Posts .css-1emoo84{font-size:var(--chakra-fontSizes-md);font-weight:400;color:var(--chakra-colors-gray-600);}(last 30 days)

Ready to grow your LinkedIn presence?

Varsha Chitikaneni's Linkedin Analytics

Performance ScoreVarsha Chitikaneni's LinkedIn Performance

Varsha Chitikaneni's Best Posts (last 30 days)