ram prasad somaraju

I am a recent Master's graduate in Data Analytics (TUS) and Stamp 1G visa holder, brimming with enthusiasm and expertise in SQL, Python, and Power BI, and a thirst for continuous learning. I have a proven track record of leveraging data to unlock actionable insights within retail environments, resulting in quantifiable achievements like a 20% improvement in data accuracy and a 15% increase in average basket value. Skilled in collaborating effectively with cross-functional teams and communicating complex findings to diverse audiences. Eager to contribute to company success by uncovering performance optimization opportunities and driving informed decision-making through data-powered insights.

1. Automated Lane Detection and Traffic Sign Recognition for Improved Road Safety  – Thesis  – Ireland, IE ,9/2023

• Enhanced road safety with real-time AI: Implemented real-time lane detection (96% accuracy, CNN) and traffic sign recognition (93.13% mAP, YOLOv5) for proactive accident prevention.
• Robust performance in diverse conditions: Ensured efficient and accurate operation in variable weather and lighting, demonstrating the system's reliability in real-world scenarios.
• Optimized data processing: Leveraged efficient algorithms and techniques to process large amounts of sensor data in real-time, ensuring minimal latency and high computational efficiency.

2. Business 360 - Brick & mortar and e-commerce – Internship Project – Ireland, IE, 06/2023

• Scoped and Deployed a Power BI Solution: Defined development objectives, collaborated with stakeholders, and deployed a Power BI solution across 5 departments, aligning with strategic small goals.
• Transformed and Validated Data: Utilized Power Query for data preparation and validation, achieving a 20% improvement in data accuracy.Managed problem-solving in data flow across multiple systems.
• Engaged Stakeholders with Power BI: Communicated insights via developed dashboards to senior management, refining solutions from feedback and boosting user satisfaction by 30%.

3. A Strategic Deep Dive into Sales & Financial Excellence – Internship Project – Ireland, IE, 05/2023

• Crafted and presented 10+ KPIs in Excel and PowerPoint presentations to align with strategic goals, driving data-backed decision-making, resulting in a 20% increase in sales and a 15% reduction in costs.
• Demonstrated innovation by designing a scenario analysis tool in Excel for project management, reducing downtime by 20%.
• Streamlined Data Analysis to visualize sales and financial data in 3+ reports, communicating innovative insights to stakeholders.

4. Real-time EDA of JCDecaux portable bikes in Dublin – Personal Project – Ireland, IE, 11/2022

• Implemented a data pipeline for predictive analysis of Dublin bikes, generating actionable insights that led to a 15% ridership.
• Scripted and used REST API codes to Scrape real-time bike data of +50K rows from JCDecaux.
• Conducted successful EDA analysis between both cities on Usage percent and usage trend with Python.

• Programming for Everybody (Getting Started with Python)
• KPMG Data Analytics Consulting virtual internship
• Excel: Mother of Business Intelligence
• PowerBI Real-world projects
• Tableau introduction