R

Ramkumar Bannalle

About

Detail

Karnataka, India

Timeline

work
Job
school
Education
folder
Project

Résumé

Jobs verified_user 0% verified
  • Algae Services
    SQLAssociate Developer
    Algae Services
    Jan 2025 - Current (1 year 6 months)
    Developed and optimized SQL queries to extract, transform, and load (ETL) data from Excel sheets into relational databases. Analyzed and mapped database schemas, ensuring seamless integration and integrity of structured datasets. Streamlined and optimized SQL query operations, successfully reducing processing times by over 50%, thus enhancing overall database efficiency and response times for business-critical operations. Identified and resolved data discrepancies, improving accuracy and reporting capabilities. Optimized data validation processes in SQL Server by implementing stored procedures, triggers, and data integrity constraints, increasing operational efficiency by 25%. Conducted ad-hoc analysis by writing SQL queries to address spec
  • A
    Junior Data Engineer
    Amnet Digital
    Jul 2022 - Nov 2023 (1 year 5 months)
    Proven experience in writing SQL queries to analyze clickstream data and generate weekly reports. Conducted preliminary analysis to understand Clickstream data. Extracted KPI metrics such as Action Item Conversion Rate, Epen/Orderpen, Shipment Tracking, Order Tracking, Bounce Rate and Gross Merchandise Metric (MoM, YoY Values) to monitor business performance monthly. Conducted ad-hoc analysis by writing SQL queries to address specific business questions. Identified and analyzed missing data in target tables by cross-referencing source databases. Validated data accuracy by comparing query results with Adobe Analytics reports. Adobe Analytics: Created and managed Adobe Analytics dashboards using Dimensions, Metrics, eVars, and Props. Conducte
Education verified_user 0% verified
  • B
    By Simply Learn Certification Data_Analytics_Essentials | Introduction to Data Analytics
    Jan 2025 - Feb 2025 (2 months)
  • G
    Bachelor of Engineering
    Guru Nanak Dev Engineering College Bidar - VTU
    Jun 2017 - Aug 2021 (4 years 3 months)
Projects (professional or personal) verified_user 0% verified
  • D
    Data Analysis Using Python
    Jan 2024 - Feb 2025 (1 year 2 months)
    Developed a Python-based system to analyze and visualize YouTube data for performance tracking. Automated data collection using APIs, reducing manual efforts by 40%. Implemented data cleaning techniques using Pandas to ensure high data quality. Built interactive dashboards using Matplotlib & Seaborn to present insights.