About Me
Hello! I'm Rohan, a dedicated professional with about 3.5 years of analytics experience under my belt. Graduated with an MS in Management Information Systems from Texas A&M University, complemented by a Bachelor’s in Computer Science and Engineering, I aim to integrate technical expertise with strategic business insights to foster organizational growth. I'm your go-to person for creative problem-solving, seamless communication, and collaborative teamwork. Whether it's crunching data or brainstorming ideas, I bring a can-do attitude to every project.
Data Visionary
Fueled by an ambition to translate complex datasets into actionable business insights, I aspire to excel as a data professional. I aim to illuminate paths to success for organizations by analyzing data and crafting compelling stories. Currently, I am seeking full-time opportunities to apply my comprehensive skill set and contribute to data-driven decision-making in dynamic environments.
Skills
Throughout my academic and professional journey, I have developed a diverse set of skills that position me to thrive in the data domain. My hands-on experience with a range of analytical tools and technologies enable me to extract, refine, interpret, and visualize data, ensuring informed business decisions. Following are some of my key proficiencies -
75%
75%
85%
80%
90%
70%
90%
Libraries
80%
75%
75%
80%
Portfolio
Explore my projects where I apply my technical skills to develop practical solutions. I aim to showcase my ability to implement innovative solutions and drive tangible results. These experiences empower me to tackle complex real-world challenges effectively.
Achievements
Demonstrating my commitment to continuous learning, I have attained notable certifications and accomplishments that highlight my dedication to excellence in the field of data. I actively pursue opportunities to enhance my knowledge, ensuring I stay at the forefront of data-driven innovations.
Datacamp - Data Analyst
Salesforce AI Associate
SQL (Advanced) HackerRank
SQL 50 LeetCode
Power BI Fundamentals
Azure Fundamentals
Robotic Process Automation
Professional Scrum Master I
Background
I bring a strong combination of academic rigor from esteemed institutions and hands-on expertise gained through diverse professional roles. Delve into my journey below to discover the breadth of my skills, knowledge, and experience.
Experience
Business Analyst Intern : May 2024 - Aug 2024
Dallas, TX, USA
- Eliminated schedule variance for the Burn project by integrating Project Web App (PWA) with Power BI, deriving valuable insights to re-baseline the project & enabling data modeling with increased customization capabilities using DAX & Power Query
- Amplified stakeholder engagement by optimizing the PWA dashboard and orchestrating cross-functional collaboration. Led a comprehensive training session to onboard functional leads, facilitating effective project tracking and resource management
- Achieved significant cost savings for the Diabetic Foot Ulcer project by identifying critical budget discrepancies across various teams using Excel pivot tables for effective cost analysis; also performing budget forecasting to anticipate future financial variances
Reporting Data Analyst : Aug 2020 - May 2023
Bangalore, KA, India
Amadeus
Look to Book Reports
- Revamped marketing strategies and customer engagement by developing the look-to-book ratio KPI and analyzing extensive shopping and booking records using advanced SQL and data aggregation techniques
- Increased booking conversion rates by developing a predictive logistic regression model in Python, forecasting reservation likelihood using efficient feature engineering
- Boosted annual revenue and forged strong relationships with top hospitality brands by automating KPI tracking & providing insightful business reports through real-time model performance monitoring & interactive tableau dashboards
- Reduced incident backlog significantly by spearheading a root cause analysis initiative as the problem-tracking sheriff
- Identified numerous erroneous records in the reporting-reservation tables by executing optimized SQL queries with refined filters
- Automated data transformation process by crafting Python scripts to convert raw data into UIDs based on rate plan & price grid object types. Used the resync tool to synchronize UIDs for reliable customer report generation, promoting data-driven decision-making
Data Analytics Intern : Dec 2018 - Jun 2019
New Delhi, India
- Mitigated risk of battery failure through accurate anomaly detection, leveraging Python for Exploratory Data Analysis (EDA)
- Fueled stakeholder growth using Tableau reports for fleet management, allowing key insights into e-vehicle & driver metrics
- Minimized manual effort by streamlining 24h diagnostic reports with a Python script, enabling leaders to address defective batteries
Education
MS Management Information Systems
2023 - 2025
College Station, TX, USA
GPA: 4.0/4.0
Relevant coursesData Management, Data Analytics & Machine Learning, Data Warehousing, Statistical Foundation of Data Science
Roles and Responsibilities- Graduate Teaching Assistant (Aug 2024 - May 2025) - Advanced System Analysis and Design, MS Excel, MS Access, HTML
- Data Management Specialist (Jan 2024 - May 2024) - Technology Services
- Student Assistant (Sep 2023 - Jan 2024) - Office of Admissions
B.Tech Computer Science & Engineering
Punjab Engineering College, Chandigarh
2016 - 2020
Chandigarh, India
GPA: 3.4/4.0
Relevant coursesDatabase Management Systems, Big Data Analytics, Object Oriented Programming, Project Management
Roles and Responsibilities- Joint Secretary (Aug 2016 - May 2020) - Dramatics Club
Get in Touch
Whether you have questions or just want to chat about exciting opportunities, I’m all ears. Let's connect and make great things happen together!
