Keith Yrisarri Stateson

Keith Yrisarri Stateson Email and Phone Number

Data Analyst and BI Analyst @ USDA @ USDA
washington, district of columbia, united states
Keith Yrisarri Stateson's Location
San Francisco Bay Area, United States
About Keith Yrisarri Stateson

I’m a creative techie and Army Veteran specializing in data visualization, artificial intelligence/machine learning, and automation. I am detail-oriented, blending analytical and technical skills with unique artistic abilities to develop solutions. On a more creative note, I’m an Artist and Writer who loves to create works of art.Technical Skills» Programming Languages: Python, SQL, DAX, M, Visual Basic for Applications» Data Visualization: Tableau, Power BI, Power Query Editor, Data Storytelling» Web Technologies: HTML, UNIX, JavaScript, Wix» Development Tools: Jupyter Notebook, Visual Studio Code, PyCharm, Git, GitHub» Software and Platforms: Generative AI, Microsoft 365, Google Workspace, Adobe Creative Cloud» Multimedia Production: Logic Pro, Cubase, ProTools, GarageBand, Final Cut, iMovie, Sibelius, Finale» Business and Market Analysis: IBISWorld, Google Analytics, Statista

Keith Yrisarri Stateson's Current Company Details
USDA

Usda

View
Data Analyst and BI Analyst @ USDA
washington, district of columbia, united states
Website:
usda.gov
Employees:
17414
Keith Yrisarri Stateson Work Experience Details
  • Usda
    Data Analyst
    Usda Apr 2023 - Present
    San Francisco, California
    Child Nutrition Meal Earning Projections | May 2023-Aug 2024Designed an automated projection tool that accurately projects over $20 billion in child nutrition (CN) meal earnings. Enhanced the allocation of CN grants to US states and territories. Collaborated with SMEs to understand the data and align the tool with stakeholder requirements and objectives. Utilized and compared multiple Python modules, using matplotlib to visualize the comparisons and validate the tool's accuracy against… Show more Child Nutrition Meal Earning Projections | May 2023-Aug 2024Designed an automated projection tool that accurately projects over $20 billion in child nutrition (CN) meal earnings. Enhanced the allocation of CN grants to US states and territories. Collaborated with SMEs to understand the data and align the tool with stakeholder requirements and objectives. Utilized and compared multiple Python modules, using matplotlib to visualize the comparisons and validate the tool's accuracy against customized calculations.SAE Reallocation Analysis | Jan-Feb 2024Developed and updated code to analyze financial data, facilitating the recovery of federal funds and enhancing financial stewardship. Collaborated with SMEs to understand the data and ensure alignment with stakeholder needs and objectives, improving overall financial oversight and accountability. Developed instructions. Additionally, provided detailed directions for users to ensure the effective use of the analysis tools and promote user autonomy, as well as for future developers to modify the program as needed.DACI CN Phrase Finder | Jul 2023-Nov 2023Collaborated to develop a program to search, highlight, and link specific phrases in Food Service Management contracts. Project increased regulation oversight and compliance, saved 100s of man-hours annually, and increased performance reviews by 25%.Child Nutrition Meal Count Analysis | Jul-Dec 2023Added anomaly detection of monthly meal counts and created new features like tolerance levels in old code. Performed testing and debugging.SNAP QC Review Tools | Jul-Aug 2023Added and fixed macros to existing code and improved automated formulas for the SNAP QC analysis reports, which increased productivity by 12%.DACI Project Tracker | Jul-Aug 2023Designed an automated project tracker for multiple DACI workgroups. Tracker increased efficiency of project management. Show less
  • Usda
    Business Intelligence Analyst
    Usda Apr 2023 - Present
    San Francisco, California
    Child Nutrition Meal Earning Projections | Aug-Sep 2024Developed an interactive and dynamic Tableau dashboard and an Excel version for projecting accurate multi-billion dollar child nutrition (CN) meal earnings, facilitating enhanced data-driven decision-making for the allocation of CN grants to state agencies.Disaster D-SNAP Analysis | May 2024Developed a Tableau Mapping Dashboard and performed Trend Analysis of hurricane-impacted counties in the United States, significantly… Show more Child Nutrition Meal Earning Projections | Aug-Sep 2024Developed an interactive and dynamic Tableau dashboard and an Excel version for projecting accurate multi-billion dollar child nutrition (CN) meal earnings, facilitating enhanced data-driven decision-making for the allocation of CN grants to state agencies.Disaster D-SNAP Analysis | May 2024Developed a Tableau Mapping Dashboard and performed Trend Analysis of hurricane-impacted counties in the United States, significantly enhancing household participation and financial issuance assessments.SNAP Food Costs and Participation | Mar 2024Created a Dashboard to monitor SNAP participation and financial data for several state agencies utilizing Power BI, PQE, and DAX.Finding and Observation Reports | Jan-Mar 2024Created complex, customized interactive data visualizations leveraging custom calculations, hosted on SharePoint. Provided actionable insights into financial management and management evaluation reviews spanning multiple nutrition programs and briefed C-Suite.Budget Analysis | Jan 2024Developed visualizations of multiple budget scenarios for CNMI, providing critical insights to stakeholders on optimizing budget allocations in alignment with current and future grant funding.SNAP Participation Visualizations | Nov-Dec 2023Developed Tableau and Power BI desktop and mobile data visualizations in compliance with Section 508 to show SNAP participation, eligibility, and benefit trends to the WRO C-Suite. Show less
  • Usda
    Financial Analyst
    Usda Apr 2023 - Present
    San Francisco, California
    Bluesheet Reports | Oct 2023-PresentConducted monthly validations of multibillion-dollar grants spanning multiple nutrition programs, identifying crucial discrepancies.Financial Management Reviews | May 2023-PresentAnalyzed financial data for multimillion-dollar state nutrition programs. Applied data analytic tools and statistical methods to identify anomalies and outliers, and to select auditing samples.
  • Sing Fighter
    Artist
    Sing Fighter Jan 2024 - Present
    San Francisco Bay Area, California
    Children's MusicComposed and performed original children's songs with a focus on educational and entertaining content. Wrote versatile lyrics across multiple genres, demonstrating a wide range of musical styles. Collaborated with artists and educators to enhance and enrich music projects.Military-Themed Multimedia ProjectsComposed and produced music for military-themed multimedia projects, including In the Midst of Battle, Here to Fight, and USA Global Peace Force.
  • Enduring Writer
    Creative Writer
    Enduring Writer Feb 2019 - Mar 2023
    San Antonio, Texas
    Educational and Entertaining Content DevelopmentCreated and developed educational and entertaining content that blends real-life challenges with imaginative elements and fictional personification, catering to all age groups. Authored children's books, short stories, and poems, enriching the lives of young readers. Composed lyrics across various genres and styles, including pop, rock, hip-hop, dance, comedy, educational, fitness, love, patriotic, and storytelling.Creative… Show more Educational and Entertaining Content DevelopmentCreated and developed educational and entertaining content that blends real-life challenges with imaginative elements and fictional personification, catering to all age groups. Authored children's books, short stories, and poems, enriching the lives of young readers. Composed lyrics across various genres and styles, including pop, rock, hip-hop, dance, comedy, educational, fitness, love, patriotic, and storytelling.Creative Collaborations and Multimedia ProjectsDeveloped scripts for illustrations, enhancing visual storytelling. Wrote advertising copy for military-themed multimedia projects. Collaborated with creatives from diverse cultures and nationalities to produce music that reaches a global audience. Oversaw creative projects, driving creativity and ensuring artistic quality and direction. Show less
  • Enduring Writer
    Business Specialist And Analyst
    Enduring Writer Nov 2021 - Jul 2022
    San Antonio, Texas
    Forecasts in Book/Music Publishing Industries and Market Analysis in US EntertainmentDeveloped strategic multimedia production scaling and forecasted financial and production projections across two creative agencies. Innovated and directed product development. Researched and analyzed industry data and tracked KPIs to ensure successful product launch and adoption. Analyzed key trends and conducted SWOT analysis for risk mitigation and product exploitation.
  • Texas Army National Guard
    Texas Army National Guard
    Texas Army National Guard Sep 2019 - Sep 2022
    Grand Prairie, Texas
    Facilitated with the logistical movement of organizational equipment.
  • University Of North Texas
    Media Assistant
    University Of North Texas Jan 2015 - Dec 2015
    Denton, Texas
    Assisted in the production of the UNT Talent Show and the recording of lectures.
  • United States Army
    Chemical Officer, Logistics Officer, Usr Officer, Paying Agent
    United States Army Feb 2008 - Aug 2011
    San Antonio, Texas
    Unit Status Report Officer, OperationsCompiled and analyzed intelligence for wartime readiness for 2-4 IN Battalion. Created monthly dashboards to brief the battalion commander. Maintained data confidentiality of personnel, equipment, and supplies.Unit Movement Officer, LogisticsCoordinated international logistical operations for sensitive equipment. Key team member to create metrics to maximize shipping efficiency and load planning process, improving logistical cost efficiency… Show more Unit Status Report Officer, OperationsCompiled and analyzed intelligence for wartime readiness for 2-4 IN Battalion. Created monthly dashboards to brief the battalion commander. Maintained data confidentiality of personnel, equipment, and supplies.Unit Movement Officer, LogisticsCoordinated international logistical operations for sensitive equipment. Key team member to create metrics to maximize shipping efficiency and load planning process, improving logistical cost efficiency by over $100,000.Media Assistant, Chemical CorpsAssisted in producing a World War II documentary. Created a multimedia presentation for the Chemical Corps Hall of Fame. Created a tribute of the 83rd Chemical Battalion.Paying Agent, Public AffairsFinanced 46 agricultural, civil, economic, and educational projects with a 91% success rate in community and economic development. Disbursed 42,916,750 AFN banknotes to multiple contractors with 0% balance error.Chemical OfficerManaged inspection of hazardous material and equipment for 2-4 IN Battalion.Battle CaptainConducted battlefield operations and reported battle update briefings. Show less
  • Texas State University
    Chemistry Laboratory Instructor
    Texas State University Aug 2006 - Jan 2008
    Supervised general, organic, and advanced inorganic chemistry laboratorycourses. Developed an organic II laboratory manual. Designed and managedTSU’s Chemistry Club website and served as historian.

Keith Yrisarri Stateson Education Details

Frequently Asked Questions about Keith Yrisarri Stateson

What company does Keith Yrisarri Stateson work for?

Keith Yrisarri Stateson works for Usda

What is Keith Yrisarri Stateson's role at the current company?

Keith Yrisarri Stateson's current role is Data Analyst and BI Analyst @ USDA.

What schools did Keith Yrisarri Stateson attend?

Keith Yrisarri Stateson attended Texas A&m University, University Of North Texas, Diablo Valley College, Codeup, Michigan State University College Of Law.

Who are Keith Yrisarri Stateson's colleagues?

Keith Yrisarri Stateson's colleagues are Matthew Richter, Mba, Jonathan Neubauer, Thomas Schwindeman, Walid Ahmad, Jeremy Adams, Matthew Maratea, Jc Kruse.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.