Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Giovanni Barragan

Oak Lawn,IL

Summary

Detail-oriented and hard-working individual who enjoys retrieving data to share with internal and external stakeholders along with actionable insights.

Overview

3
3
years of professional experience

Work History

Sr. Data Analyst - Group Retiree Solutions

Blue Cross Blue Shield of Illinois
04.2023 - Current
  • Led the team with anything Salesforce related. Met with external and internal stakeholders regularly to improve the data and functionalities our team had available.
  • Worked closely with the Group Medicare VP, providing data on an ad hoc basis. Always readily available for quick turnarounds needed.
  • Spearheaded a Salesforce Enhancements project, with an effort to improve the capabilities we all had within the application, and create a far more efficient/accurate data environment.
  • Ran a weekly report which our VP and leadership would view in a meeting to track the progress of our potential clients
  • Most data requests consisted of leveraging Salesforce to create a report, export to Excel, and manipulate the data in Excel.
  • Held multiple training sessions per month with our Sales and Account Management teams, in an effort to teach each team how to use Salesforce and what each team is responsible for.
  • Skills/Tools: Tableau, Power BI, Excel, Salesforce, PPT, VLOOKUPS, PivotTables

Sr. Data Analyst - Customer Value and Analytics

Walgreens
08.2022 - 04.2023
  • Created an automated Power BI Dashboard for the team to leverage and receive real-time data
  • Ran annual Forecasting and Budgeting reports, which consisted of leveraging a complex usage of VLOOKUPS and data manipulation within Excel to map data from separate files in SharePoint
  • Met with external team BCG (Boston Consultancy Group) regularly, to support them in standing up a tool the team was working on
  • New tool was the primary focus, as it would be able to supply the teams with instant data outputs, with the simple entry of some parameters
  • Leveraged Microsoft SQL Server to run some queries on Forecasting at a monthly basis, for BCG to utilize in the creation of the tool

Data Analyst - CRM Strategy and Analytics

Walgreens
02.2022 - 08.2022
  • Utilized a plethora of programs and applications such as: Jupyter Notebook, Hadoop, Excel, Power BI, Teradata, Putty, Microsoft Teams, Ambarri, Filezilla, Azure Databricks, Azure DevOps, Unica, Sharepoint and Powerpoint
  • Ran queries daily using SQL through Jupyter Notebook and Azure Databricks
  • Met with Principal Data Scientists to pick their brains on the creation of the clusters our team would be using within Azure Databricks
  • Executed Python code to put SQL query results into dataframe when dealing with excessively large dataset
  • Pulled data to gather engagement data, sales conversion data, and worked with team to build logic for other ways of calculating conversion
  • Part of the UAT process when migrating databases
  • Worked on queries with run-times as long as 12 hours
  • Our team served as a liaison between Retail and Pharmacy, typically providing data to each time individually, but occasionally providing data which included both sides in the same output

Education

Bachelor of Science - Computer And Information Sciences

University of Illinois At Chicago
Chicago, IL
05.2021

Skills

  • Problem-Solving
  • Advanced Excel
  • Python Programming
  • Advanced analytics
  • KPI Tracking
  • Data Mapping
  • Advanced SQL
  • Power BI
  • Tableau
  • Critical Thinking
  • Detail-Oriented

Languages

Spanish
Native or Bilingual

Timeline

Sr. Data Analyst - Group Retiree Solutions

Blue Cross Blue Shield of Illinois
04.2023 - Current

Sr. Data Analyst - Customer Value and Analytics

Walgreens
08.2022 - 04.2023

Data Analyst - CRM Strategy and Analytics

Walgreens
02.2022 - 08.2022

Bachelor of Science - Computer And Information Sciences

University of Illinois At Chicago

Similar Profiles

CREATE PROFILE
Giovanni Barragan