Mauricio
Data Analyst + Business Intelligence
About Me
Hello! Hello! I'm Mauricio Vargas, a Data Analyst at AIG, where I build Power BI dashboards and Python-driven tools to streamline claims operations, reduce fraud risks, and unlock cost savings. With a B.S. in Business Analytics and a minor in Logic & Computation from Carnegie Mellon University paired with hands-on experience in financial analysis and economic research, I bridge data, strategy, and sustainability. I’m passionate about using Python, SQL, and DAX to turn data into decisions—whether optimizing workflows or advancing climate-conscious business practices.
Resume
Here is my work experience, education, & some skills I've got.
Experience
AIG
Data Analyst
Current Since September 2024
Transformed claims analytics at AIG by developing Python-powered data pipelines and interactive Power BI dashboards, automating reporting and uncovering actionable insights—boosting operational efficiency by 30% and enabling data-driven decision-making across teams.
Oriental Bank
Financial Analysis Intern
May 2022 - July 2022
Produced impactful FP&A reports and detailed 5-year forecasts using advanced Excel techniques and Adaptive Planning software, significantly improving reporting efficiency and providing valuable insights for strategic planning.
Education
Carnegie Mellon University
BS in Business Administration
May 2024
Obtained a B.S. in Business Administration, concentrating in Business Analytics and minoring in Logic & Computation. Held leadership roles in student organizations and completed coursework in Data Mining for Business Analytics, Advanced Data Management, and End to End Business Analytics.
Carnegie Mellon University
Undergraduate Academic Research
May 2021 - July 2021
Revealed significant effects of money supply on US inflation through linear regression analysis in R Studio during COVID-19. Utilized FRED tools to collect and compile Federal Reserve data, and documented and presented findings, showcasing advanced analytical and data analysis skills.
Skills & Expertise
Selected Projects
Selected Projects I Have Worked On.
Climate Change
Analyzed climate change data to uncover key trends and insights using Python and Streamlit for an interactive dashboard.
HR Dashboard
Developed an HR dashboard in Tableau to visualize and summarize key human resources metrics and trends.
Electric Vehicle Sales
Conducted a comprehensive electric vehicle data analysis using Tableau to uncover key industry trends and insights. Guided by online tutorial
CRM Sales Python Dashboard
Python exploratory data analysis and dashboard. B2B sales pipeline data from a fictitious company that sells computer hardware.