Information Systems, Power Bi, MS Excel, SQL, Python

Kartar Singh Kohli

+91-966**-***** kkohli ****@******.*** linkedin.com/in/kartar-singh-kohli

Education

Thapar University Patiala, Punjab

Bachelor of Technology in Electrical and Computer Engineering (GPA-7.6) Expected May 2026 Experience

Managing Information Systems (MIS) Intern June 2024 – July 2024 Ericsson Cable Industries Delhi, India

• Assisted in developing real-time KPI tracking workflows in Google Sheets, enabling faster decision making across manufacturing departments

• Enhanced data organization and reporting efficiency by 30% through data cleaning and structuring in Google Sheets

• Monitored and maintained system data integrity, ensuring smooth cross-departmental operations through consistent data validation

Corporate Alliance Managing Intern May 2023 – May 2023 Suns Reality Group Remote

• Researched different markets and competitors in detail to better understand customer needs and suggested ways that could help improve outreach efforts and strengthen the brand image

• Reviewed and compared partnership options by looking at data and industry trends, which supported the team in building meaningful collaborations and contributed towards overall business growth Position of Responsibility

Joint Secretary, Economics Club TIET Aug. 2024 – Present

• Drove club expansion by mentoring 150+ members in event planning and execution, leading to a promotion to Joint Secretary for demonstrated leadership and initiative Core Member, Economics Club TIET Aug. 2023 – Present

• Appointed Overall Event Coordinator (OEC) for the flagship event ”Wolf of Dalal Street”—spearheaded event planning, strategized execution, and achieved a 40% increase in attendance and 25% higher sponsor engagement

• Directed 150+ members across 10 departments to deliver a large-scale event with 1000+ registrations, optimizing workflows and communication to ensure seamless execution Member, Economics Club TIET Nov. 2022 – Present

• Appointed to lead and manage a team of 30+ members in the first year, fostering collaboration and accountability within the team to drive successful project outcomes

• Initiated and managed sponsor outreach, utilizing emails, calls, and meetings to establish partnerships, and delivered tailored sponsorship pitches that contributed to securing key sponsors Projects

OLA Data Analysis PostgreSQL, Power BI, Excel

• Engineered and cleaned a 40,000+ row ride dataset, applying normalization and validation techniques to ensure high data quality for downstream analysis

• Designed and executed advanced SQL queries to uncover actionable insights—identifying top-performing customers, analyzing cancellation patterns, and evaluating booking trends and revenue drivers

• Built a comprehensive Power BI dashboard featuring interactive visualizations on ride volume, rating distributions, cancellation breakdowns, and revenue by payment method—enhancing data accessibility for decision-makers Netflix Data Analysis PostgreSQL, Excel

• Spearheaded the design and execution of advanced SQL queries on a dataset of 8000+ titles, uncovering key content, genre, and rating trends that informed content strategy

• Generated insights for audience targeting and strategic decision-making through keyword filtering Technical Skills

Languages: Python, SQL, C/C++

Tools and Technologies: MS Excel, Google Sheets, MS Power BI, Looker Studio Databases: PostgreSQL, MySQL, Microsoft SQL

Contact this candidate