Somya Mishra
Data Analyst | Software Engineer | AI and Prompt Engineer | Python | SQL | Power BI | Advanced Excel | Turning Data into Actionable Insights
- Role
- Ai Engineer at Soul Ai
- Location
- Indore, MP, IN
- LinkedIn followers
- 500 followers
About Somya Mishra
As a passionate and detail-oriented professional, I hold a Bachelor\'s degree in Computer Science and have gained hands-on experience working as a Software Engineer and Data Analyst intern. With a strong foundation in SQL, Excel, Python, Power BI, and Looker Studio, I enjoy exploring datasets, identifying trends, and converting them into clear, actionable insights. My background includes working on real-world business data, dashboard development, and research-based analysis, helping me develop both technical depth and a problem-solving mindset.Some of my key projects includes:SQL – Zomato Sales Analysis:Designed and executed 15+ advanced SQL queries to simulate Zomato\'s sales data analysis. Explored customer behavior, restaurant performance, average delivery times, and payment preferences. Generated actionable insights like identifying best-performing restaurants, analyzing refund trends, and recognizing top revenue zones, closely mimicking real business intelligence workflows.Power BI – Work Order Analytics Dashboard:Built a comprehensive dashboard to visualize and monitor service operations. Analyzed technician-wise performance, revenue vs. cost metrics, and warranty breakdowns. Used DAX to implement dynamic KPIs, custom metrics, and time-based slicers, enabling decision-makers to assess field efficiency and financial health at a glance.Python – Logistics & Reporting Automation:Developed a logistics cost optimization solution by merging multiple Excel datasets (orders, product weights, courier invoices, rate charts). Used Pandas and functional programming to calculate total delivery weight, map zones, and apply a custom cost formula. Also automated repetitive Excel reporting tasks to streamline operations and reduce manual effort.I am currently open to work opportunities as a Data Analyst and eager to contribute to organizations where I can apply my skills, learn continuously, and solve real-world business challenges. If you\'re looking for a committed, analytical, and enthusiastic data professional, I\'d love to connect!
Experience
Ai Engineer
Jan 2025 — Present
Education
NJS Hr Sec School Damoh
Higher Education, Mathematics
2018 — 2020
Medicaps University
Bachelor of Technology - BTech, Computer Science
2020 — 2024
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.