Business Analytics, Data Analytics, Power BI, Python, HTML

Amogh Koratpallikar

515-***-**** *******.*****@*****.*** 9624 Marnewood Dr., Johnston, IA 50131 Education

The University of Iowa Henry B. Tippie College of Business Iowa City, IA Anticipated May 2025 Bachelor of Business Administration: Business Analytics and Information Systems Cumulative GPA: 3.6/4.00 Projects and Certifications

Programs: Microsoft Excel, Microsoft Power Automate, RStudio, Power BI, Python, SQL, Azure DevOps Skills: Data Analysis, Pivot Tables, Organizational Skill, Forecasting New Leader Manufacturing Capstone Project Dec 2024

• Streamlined the cleaning of an 80-year-old dataset by selecting key fields to reduce complexity and address inconsistencies

• Collaborated with sponsors to create a Power BI report to display What-If scenarios for quantity demanded for specific parts

Tata Virtual Experience Program on Forage Mar 2023

• Used Excel Formulas to compute data into pivot tables to help prepare analytical strategies

• Constructed and presented data visualizations through Tableau to answer 4 analytical questions from CEO including revenue, seasonality, demand of products, and trends PwC Virtual Experience Program on Forage Mar 2023

• Presented mock clients with analytical trends created with Power BI through their data

• Created unique charts and graphs to illustrate their customer retention success and failures Internship Experience

Corteva Data and Reporting Analyst Johnston, IA May 2024 – Aug 2024

• Developed a Power BI report for stakeholders to optimize farm utilization and maximize profits for a 638- acre site

• Collaborated with stakeholders to gather requirements and presented “What-If” scenarios for crop pricing

• Designed and implemented a Canvas Power App to streamline data product management

• Analyzed, loaded, and transformed ONIT, Corteva’s legal and contract management application to build a data model

DLL Finance Credit Risk Intern Johnston, IA May 2023 – Aug 2023

• Aided credit underwriters in assessing new dealership loan applications to decide businesses and credit risk

• Collaborated with Account Managers to ensure applications adhered to company regulations in analyzing client’s creditworthiness

• Independently completed 100+ annual and interim reviews for two different finance departments Club Activity

Indian Student Alliance Treasurer Iowa City, IA Aug 2024 – May 2025

• Secured over $15k funding to ensure successful execution and financing of cultural events

• Developed and maintained relationships with local businesses to acquire sponsorships Volunteering

Silver Cord High School Volunteer Johnston, IA Aug 2018 – May 2021

• Assisted in coordinating between 20-25 events directed towards educating children

• Guided conventions by working with 50+ team members and administering interviews for team projects

• Accumulated 220 hours through time management and ability to improvise when needed Honors & Awards

BAIS Major Dean’s List Award University of Iowa 2024 University Dean’s List University of Iowa 2023 & 2024 Tippie College of Business Direct Admit University of Iowa 2021 Interests

Puzzles, Sports, Volunteering, Rubik’s Cube, Tennis, Atlanta Falcons

Contact this candidate