Jess Ramos ⚡️

Tech Stack: SQL, Power BI, Excel, Python, HubSpot

• Oversee all BI operations by delegating tasks to team, communicating expectations, and providing feedback.
• Identified and reconciled $100Ks in billing errors; optimized and redesigned client onboarding process to ensure accurate database logging and billing.
• Engineered billing tables and views in the database to improve data collection for the billing system.

• Provide weekly insights and updates on both a Sales and company-wide call in order to ignite strategic action.
• Provided essential data and compelling visuals on short notice over a 3-month period working with potential investors.
• Run and modify monthly billing queries as needed for all clients and partners for the Finance department.
• Design metrics, reports, and dashboards (in SQL and Power BI) relating to volumes, revenue, and software system performance for teammates… Show more

• Provide weekly insights and updates on both a Sales and company-wide call in order to ignite strategic action.
• Provided essential data and compelling visuals on short notice over a 3-month period working with potential investors.
• Run and modify monthly billing queries as needed for all clients and partners for the Finance department.
• Design metrics, reports, and dashboards (in SQL and Power BI) relating to volumes, revenue, and software system performance for teammates, partners, and clients. Show less

• Implemented robot process automation (RPA) software to send monthly client reports which reduced the monthly task time from days to just minutes.
• Designed a monthly client report in Power BI featuring useful metrics and visualizations to track performance and integrated the report into the RPA software.
• Construct queries in SQL and Power BI to filter, transform, and visualize desired data to be delivered internally and externally.
• Report on important metrics, craft dashboards… Show more

• Implemented robot process automation (RPA) software to send monthly client reports which reduced the monthly task time from days to just minutes.
• Designed a monthly client report in Power BI featuring useful metrics and visualizations to track performance and integrated the report into the RPA software.
• Construct queries in SQL and Power BI to filter, transform, and visualize desired data to be delivered internally and externally.
• Report on important metrics, craft dashboards, and query reports that provide meaningful insights into clients, prospects, and the company as a whole.
• Update and import data into Power BI from various sources (database, excel, Box, HubSpot), manage the data model (ERD) to ensure proper data relationships using primary/foreign keys, and transform the data for analysis. Show less

• Constructed queries in SQL to manipulate, filter, and extract desired data and delivered to team members.
• Created queries, measures, and visualizations in PowerBI in order to clean, transform, and visualize data.
• Reported on important metrics and crafted dashboards for several departments, many which were used in the company end-of-year meeting.
• Queryed reports for clients and integrations and set alerts for their corresponding FormFree representative.
• Assisted the… Show more

• Constructed queries in SQL to manipulate, filter, and extract desired data and delivered to team members.
• Created queries, measures, and visualizations in PowerBI in order to clean, transform, and visualize data.
• Reported on important metrics and crafted dashboards for several departments, many which were used in the company end-of-year meeting.
• Queryed reports for clients and integrations and set alerts for their corresponding FormFree representative.
• Assisted the Business Intelligence Manager in office with various analytic projects while also managing several individual projects remotely with minimal supervision. Show less

I worked on a data project to predict and improve enrollment at Berry College. I turned a ginormous, messy dataset of 113,000 observations into a usable asset for the Enrollment Management Office, and I learned the importance of data cleaning and transformation. I developed a passion for data, and this job led me to pursue a job in analytics.

I led an ESL classroom through Berry's ESL program. I was responsible for creating lesson plans, assisting students, and making a connection with the local Hispanic community. I helped them strive to do their best and improve their English skills one day at a time.

I tutored students in Berry's academic success center. I was responsible for assisting them with their questions and homework and maintaining a professional environment in the tutoring center.