💡Basics First💡

Complexity Later

Great Code Starts with the Right Basics

Simplify Complexity with Strong Fundamentals

Coding Mastery Begins with the Basics

🌟Career Milestones🌟

VIAAN - PYTHON BI DEVELOPER

TRUTRIP - BI DEVELOPER INTERN

TRUTRIP.IN SR. DATA ANALYST

VRCS - DATA ANALYST

VRCS - DATA ANALYST INTERN

VIAAN LLC
Python BI Developer (Dec 2023 – Present)

  • Designed interactive Power BI and Tableau dashboards for data visualization.

  • Improved real-time analytics for executive decision-making, reducing reporting delays by 40%.

  • Built Python-based ETL processes using Apache Airflow, Pandas, and SQLAlchemy.

  • Reduced data processing time by 50%, ensuring seamless data flow.

  • Connected PMS data with BI tools for real-time performance tracking.

  • Increased operational efficiency in hospitality businesses by 30%.

  • Migrated legacy data to Google BigQuery and AWS Redshift for faster query execution.

  • Improved data retrieval speeds by 3x.

  • Used Scikit-Learn and TensorFlow to forecast hospitality industry trends.

  • Improved occupancy rate predictions by 20%, enhancing pricing strategies.

  • Developed Python and SQL scripts to clean and standardize large datasets.

  • Reduced data inconsistencies by 35%, improving analysis accuracy.

  • Developed REST API connectors for integrating third-party travel and motel data.

  • Enabled real-time updates for pricing and availability, reducing outdated data by 90%.

  • Built machine learning models to optimize pricing strategies for internal franchise brands.

  • Increased revenue per available room (RevPAR) by 10%.

  • Set up scheduled Power BI and Tableau reports, reducing manual reporting efforts by 60%.

  • Built customer segmentation models using K-Means Clustering.

  • Enabled personalized guest offers, increasing guest satisfaction by 25%.

  • Used PyCaret and Scikit-Learn to detect anomalies in guest behavior and booking patterns.

  • Reduced energy costs by 12% through automated resource management.

  • Used Natural Language Processing (NLP) to analyze guest reviews and feedback.

  • Improved customer sentiment tracking, leading to 10% higher positive reviews.

  • Created key performance metric (KPI) dashboards for hotel managers using SQL and Tableau.

  • Improved operational efficiency and reduced check-in delays by 30%.

  • Conducted SQL performance tuning for PMS databases, reducing query execution time by 30%.

  • Enhanced data-driven decision-making for hotel management teams.

Trutrip LLC
BI Developer Intern (Mar 2023 – Aug 2023)

  • Created Customized Power BI reports for enterprise travel expense monitoring.

  • Automated data ingestion from GCP and AWS S3 using Python and Apache Airflow.

  • Built SQL-driven dashboards for corporate customers, reducing dependency on manual reporting.

  • Leveraged AI analytics tools to predict travel demand, improving operational efficiency by 20%.

  • Integrated live travel data APIs with in-house BI systems, improving real-time visibility.

  • Optimized PostgreSQL queries, reducing data lag by 25%.

  • Analyzed historical travel data using Python and Tableau for predictive pricing models.

  • Set up Power BI and Tableau server automations, reducing manual report generation by 50%.

  • Built business intelligence dashboards that identified cost-saving opportunities for corporate clients.

  • Implemented anomaly detection algorithms to identify fraudulent transactions in corporate bookings.

  • Rebuilt manual Excel-based reports as interactive dashboards in Tableau.

  • Reduced API latency by 50% using optimized Python API scripts.

  • Analyzed pricing model changes using statistical testing, improving conversion rates by 18%.

  • Enabled real-time visa status updates in Power BI dashboards, improving customer satisfaction.

  • Built data cleansing workflows using Python and SQL to maintain 99.9% data accuracy.

TRUTRIP.IN
Senior Data Analyst (Feb 2021 – Dec 2021)

  • Developed machine learning models using Scikit-Learn and TensorFlow to predict flight pricing trends.

  • Achieved a 10% revenue increase through optimized pricing strategies.

  • Designed Power BI dashboards for corporate clients, providing real-time insights into travel expenditures.

  • Enabled 30% faster decision-making with automated reporting.

  • Reduced manual reconciliation errors by 30%.

  • Automated ETL processes using Apache NiFi and Python (pandas, Airflow).

  • Improved data refresh speed by 50%.

  • Built AI-driven personalized travel suggestions using NLP and clustering algorithms.

  • Increased customer engagement by 25%.

  • Refactored MySQL and PostgreSQL queries, leading to 5x faster report generation.

  • Developed real-time visa tracking dashboards in Tableau, reducing inquiry response time by 35%.

  • Integrated travel risk analytics with real-time data feeds, enhancing traveler safety monitoring.

  • Established REST API integrations for dynamic flight/hotel pricing updates, reducing outdated pricing by 90%.

  • Implemented time-series forecasting models in Python to predict hotel demand fluctuations.

  • Leveraged Google BigQuery to analyze customer travel behaviors and optimize corporate travel programs.

  • Built fraud detection models using Python’s PyCaret and Scikit-learn, preventing $150K+ in fraudulent bookings.

  • Used AI-powered chatbots to automate responses, reducing support queries by 30%.

  • Shifted static Excel reports to interactive Tableau dashboards, improving user engagement by 40%.

  • Standardized KPIs and data governance practices for internal reporting and business decisions.

VIJAYA RATNA EDUCATIONAL SOCIETY
Data Analyst (Jul 2019 – Jan 2021)

  • Created BI reports to track student performance, faculty efficiency, and attendance trends.

  • Built Python models to forecast student dropout risks and provide early intervention.

  • Used data analytics to align syllabus coverage with exam preparation strategies.

  • Migrated student data to a structured SQL-based system, reducing redundancies.

  • Implemented NLP-based chatbot to assist students with queries on exams, schedules, and results.

  • Used Power BI to track teacher effectiveness based on student feedback and results.

  • Built a Python script for generating personalized performance reports for parents.

  • Provided students with customized study plans based on past performance analytics.

  • Built data models to suggest career paths based on academic trends and skill sets.

  • Used SQL and Power BI to streamline scholarship allocation based on merit and need.

  • Identified areas for teacher improvement based on student feedback and exam scores.

  • Built Python-based anomaly detection algorithms to flag irregularities in results.

  • Analyzed reading habits to suggest books based on student interests and academic needs.

  • Used sentiment analysis (NLP) to extract insights from student reviews and feedback.

  • Implemented SQL-based automatic backup systems to prevent data loss.

  • Created interactive Power BI and Tableau dashboards to track student progress.

  • Improved academic performance monitoring by 40%.

  • Developed Python-based automation scripts to record attendance from biometric systems.

  • Reduced manual entry errors by 30%.

  • Used SQL and Python (Pandas, NumPy) to clean and structure student data.

  • Improved data accuracy by 35%, reducing inconsistencies.

  • Analyzed JEE & NEET mock test data to identify student strengths and weaknesses.

  • Helped increase student scores by 20% through targeted preparation.

  • Created custom tracking tools in Excel and Tableau for monitoring syllabus coverage.

  • Developed SQL-based reporting systems for automatic report card generation.

  • Used statistical analysis techniques to identify anomalies in student test scores.

  • Connected data visualization tools with communication platforms for real-time updates.

VIJAYA RATNA EDUCATIONAL SOCIETY
Data Analyst Intern (Sep 2018 – Jun 2019)

Future Goals & Vision

Build cutting-edge Python-driven AI & BI solutions for smarter decision-making.
Enhance data automation & ETL pipelines to improve efficiency and scalability.
Develop predictive analytics models using Python, ML, and deep learning.
Optimize cloud-based data solutions with AWS, GCP, and big data technologies.
Advance API integrations & real-time data processing for seamless analytics.
Mentor and contribute to the Python developer community, fostering innovation.
Make data-driven insights more accessible, scalable, and impactful with Python.

🚀 Driving the future of AI & analytics with Python—one script at a time!