Ryan Mross Email & Phone Number

Calgary, AB, CA

Calgary, Alberta, Canada

• Quickly adapted to clients in energy, food service, manufacturing, automotive, financial, and technology sectors to achieve business intelligence, analytical, and data governance goals.
• Senior Spotfire developer and data engineering consultant
• Created a critical Spotfire dashboard for a food service client to analyze new menu items, locations, and pricing with Snowflake, Python and Spotfire.
• Developed a fund regression analysis tool for a financial client. Replaced an existing Jupyter notebook with Python integrated Spotfire dashboard.
• Designed a holistic oil well production analysis and forecasting tool with Databricks, Spotfire and R to analyze performance to budget, competitors, and create type curves for forecasting
• Administered numerous Spotfire and Tibco Data Virtualization environments. Performed upgrades, migrations, and routine troubleshooting tasks.

Calgary, Alberta, Canada

• Provided high school math and physics tutoring both in person and online, fostering strong relationships with students.
• Helped students achieve higher grades and increased confidence in test-taking through personalized tutoring sessions.

Calgary, Alberta, Canada

• Created holistic corporate reports through corporate merger of Cona and Strath resulting in no missed weekly reports through system upgrades and migrations in Power BI and Spotfire.
• Trained staff on asset management and business intelligence software increasing self-service and decreasing reliance on external consultants by over $50,000/year
• Created data entry tools in Spotfire to facilitate the collection of field data with validations, mandatory fields, and audibility. Saved 20+ hours/week of field staff time.
• Created a robust Environmental, Social, and Governance (ESG) report with optimized SQL queries to multiple source systems to ensure accurate and timely reporting. Saved 100+ hours/month across multiple business areas.

Calgary, Alberta, Canada

• Migrated enterprise asset management system and developed key metric reporting and business processes resulting in $100,000/year savings.
• Automated critical Excel reports in Spotfire, saving 80+ hours/month.
• Collaborated with accounting and asset management staff to create an automatic equipment transfer process in inforEAM, saving 80+ hours/month.
• Created holistic business development analysis tool in Spotfire used in $100M+ deals saving 100+ hours/deal of engineering and analysis effort.
• Collaborated with engineering and operations to ensure their data and analytical needs were met. Automated corporate and operational reports including production, financial, fleet, and asset management.

Calgary, Canada Area

• Collaborated with asset teams to develop excel-based water flood management and voidage replacement analytical tools. Historical production data was used to develop monthly injection targets and predict future pool.
• Created analytical tools with Vice President Development to understand competitor performance, and quantify potential business development opportunities.
• System administrator for enterprise asset management system. Was successful in reducing consulting costs by over $100,000/year through better collaboration with operations to uncover true needs, as well as learning the.

Calgary, Canada Area

• Onboarded as a part-time consultant while attending the University of Calgary
• Developed the first set of production visualization tools using pivot tables in excel to ensure understanding of pool and well performance.
• General administrative work including file organization, and creation of new drill well applications.