Marian Valle

Data Analyst

 

vallemarian14@gmail.com                       520-332-3378                                  Sahuarita, AZ

LinkedIn

https://www.linkedin.com/in/marian-valle-41374b139/

 

Portfolio

https://vallemarian14.wixsite.com/marianvalle

 

 

Summary

Google certified data analyst with 2+ years of experience improving business systems with data. Seeking to increase data efficiency and improve business decisions. Well versed with finding data trends and patterns of historical data to assist stakeholders in strategy planning. I am in love with data and using visualization to show you the world of analytics. 

 

 

WORK EXPERIENCE

Bayer Corp. -Data Analyst

12/2022 - Present

Marana, AZ

• Deliver data by creating reports and visualizations in PowerBI and Tibco Spotfire and publish regionally through various electronic visual systems

• Work with large, complex datasets

• Work independently and with developers to automate data extraction from multiple enterprise and 3 rd party systems

• Research analysis and visualization best practices for plant breeding data and product development pipeline management. Each visualization must meet the site's unique needs while integrating with existing enterprise tools

Contribute technical requirements with new software tools such as Power Apps and Power automate.

​

Pima Pain Center -Data Analyst

03/2020 - 06/2022                                                                                                                                                                       Tucson, AZ

• Used Power BI to provide data driven recommendations for taking patient information and staying in compliance with all HIPPA security.

• Helped automate ETL processes for our Billing and Authorization departments making it easier to gather financial data and reducing time by as much as 35%.

• Preformed SQL querying, data mining and data cleanings for our patient data. To improve business system and patient care.

• Analyzed the data of 10k+ patients using SQL to identify patterns in insurance claims, leading to a 60% decrease in overhead cost.

• Developed team action plans to break down long-term objectives into weekly goals and carry out any pending issues. This new team exercise increased productivity by 20%.

• Used R- studio to create monthly analytical reports and visuals for management to review financial performances. Communicated data syntheses by organizing priority information for relevant decision making.

 

Colorado Pain Care –Clinical Data Analyst

12/2018 - 02/2020                                                                                                                                                                       Denver, CO

• Created weekly financial report using Excel pivot tables and presented this information to stakeholders monthly.

• Analyzed complex data sets using Excel and created Tableau dashboards to identify key metrics and transform raw data into meaningful, actionable information.

• Managed data flow for patient information on a EHR system, minimizing errors by 17%.

• Designed data organizational solutions for computer files, business, financial, and medical records, improving efficiency by 38%.

• Preformed medical data auditing and troubleshooting to ensure that all patient information was clean and verified correctly.

 

American Furniture Warehouse – Lead Floor Associate

04/2016 - 09/2018                                                                                                                                                                       Denver, CO

• Developed opening and closing procedures and daily store operations, including cash handling, inventory count, deposits, crisis management, and shift procedures to improve efficiency by 8%.

• Preformed daily audits and vault balance, which exceeded $20,000 daily.

• Developed novel analytics to qualitatively deduce and draw conclusions from customer behavior data that directly influenced show room design and retention of our customers.

• Provided strategic insight to partners and leadership with Excel about our retail data to optimize our products.

 

 

PROJECTS                                                        

 

Bellabeat Case Study                                                           January 2022

• Excel cleaning and formation.

• R-Studios data analysis and creation of R Markdown report.

 

Game Sales Case Study                                                      July 2022

• SQL data cleaning and analysis

• Tableau visualization

 

 Top Twitch Accounts                                                          August 2022

• SQL data cleaning and analysis

• Tableau visualization

​

Global COVID-19                                                                September 2022

• SQL data cleaning and analysis

• Tableau Visualization

 

Data Professional Survey                                             September 2022

• Data was analyzed, and cleaned with Power BI

• Dashboard was created with Power BI

​

​

EDUCATION

 

Arapahoe Community College –Business Administration

May 2018           Denver, CO

Awards

• Vice Presidents list

Coursera - Google Data Analytics Professional Certificate

 

SKILLS

 

Tech Skills 

• SQL 

• Tableau

• R Studio

• Excel

• Power BI

• Power Apps

• Power Automate

• SharePoint

• Google Sheets

• Microsoft Word

• Microsoft Power Point