Ryan Metcalf

Ryan Metcalf Email and Phone Number

Delivering value with data driven decision making by bridging the gap between Analytics, Business, and IT. @ Ameren
Ryan Metcalf's Location
St Louis, Missouri, United States, United States
Ryan Metcalf's Contact Details

Ryan Metcalf work email

Ryan Metcalf personal email

n/a
About Ryan Metcalf

Possess a unique skillset of IT, data and analytics, business, process and strategy paired with excellent communication, organizational, and leadership skills. Effectively bridging the gap between Analytics, Business, and IT to identify, facilitate, and deliver value driven opportunities, craft solutions, make prioritized recommendations, and mentor individuals at all levels of an organization.

Ryan Metcalf's Current Company Details
Ameren

Ameren

View
Delivering value with data driven decision making by bridging the gap between Analytics, Business, and IT.
Ryan Metcalf Work Experience Details
  • Ameren
    Data Analytics Manager
    Ameren Apr 2022 - Present
    St. Louis, Mo, Us
    • Manage the identification, development and delivery of value based data analytics, business intelligence, and data science products in a scrum framework.• Responsible for: • The success, growth, and development of my teammates. • Self-Service Business Intelligence • Self-Service Data Science and Team Projects • Data Analytics Technical Development • Ameren Analytics University• Laying the foundation for Data Science and maturing the company into an enterprise Advanced Analytics platform and community.Platform Tools: Databricks, AWS, R, Python, Power BI, Jira
  • Unigroup
    Strategy And Innovation Principal
    Unigroup Aug 2020 - Apr 2022
    Fenton, Mo, Us
    Strategy and Innovation Principal (Apr. 2021 – Apr. 2022)• Primary responsibility: Identify, develop, mentor, and manage modernization opportunities for the Finance Department. Manage roadmap, delivery strategy, epics and stories prioritized by value and effort. Develop and conduct tool training sessions for finance department employees. Collaborate with finance management on long-term projects and deliver outcomes creating value and efficiency for the department.• Leader of Finance Modernization Project: Identify opportunities in finance analyst pain points, process improvements, tool effectiveness, and automation efficiencies. Compile results and make recommendations to senior finance and IT leadership for projects and implementations that deliver value from modernizing the finance department’s platform.• Taught 40 finance analysts, staff accountants, and operations analysts how to write SQL, and build repeatable and scalable reporting.• Taught 4 finance analysts and 2 operations analysts reporting and dashboarding in ThoughtSpot for executive consumption.• Lead delivery of automated reporting through in-house developed tool. Allowed for submission of SQL, parameters, and scheduling to automate repetitive finance and accounting data extracts.Used: Snowflake, ThoughtSpot, Planful, Jira, PythonFinance Data and Analytics Product Owner (Aug. 2020 – Apr. 2021) • Primary responsibility: Identify and receive, manage and develop data and analytics opportunities from the Finance Department. Manage roadmap, delivery strategy, epics and stories prioritized by value and effort. Develop and conduct tool training sessions for finance department employees. Collaborate with finance management on long-term projects and deliver outcomes creating value and efficiency for the department.Used: Snowflake, ThoughtSpot, Jira
  • Apex Systems
    Business Intelligence Data Warehouse Team Lead
    Apex Systems Jun 2019 - Jul 2020
    Glen Allen, Va, Us
    Business Empowerment Center of Excellence Lead (Jan. 2020 – July 2020) ● Business Empowerment Center of Excellence Lead: Responsible for administering UiPath platform, setting best practices, creating development patterns● Robotic Process Automation (RPA) Solution Architect: Responsible for technical requirements of automation projects and designing automation solutions● Robotic Process Automation (RPA) Developer: Responsible for developing automationsUsed: UiPath, TFSBusiness Intelligence Architect and Data Warehouse Team Lead (Jun. 2019 – Jan. 2020) ● Data Warehouse Support and Enhancements Team Lead: Lead team of up to 7 developers on ETL and Data Warehouse deliverables; responsible for resource, capacity, and prioritization decisions of the team● Change Management Process Leader: Implemented Agile methodology to improve delivery cycle and relationship with business stakeholders● Business Intelligence Architect: Responsible for Semantic Layer design, and Cube and Tableau architecture● Senior Business Intelligence Developer: Responsible for Tableau calculations and data source design Used: Vertica, Oracle, SQL, ERwin, Tableau, TFS, Agile, Scrum
  • Daugherty Business Solutions
    Data & Analytics Principal Consultant
    Daugherty Business Solutions Aug 2016 - May 2019
    St Louis, Missouri, Us
    Principal Consultant: Apr. 2019 – May 2019Senior Consultant: Apr. 2018 – Mar. 2019Consultant: Aug. 2016 - Mar. 2018Engagements● Monsanto: Senior Business Intelligence Developer, Spotfire dashboard development of global customer analytics identifying sales and market opportunities for company products● Anheuser-Busch: Lead Business Intelligence Developer, Qlik Sense dashboard development of operations analytics identifying training and operations opportunities on packaging lines● Express Scripts: Senior ETL and Business Intelligence Developer, Tableau dashboard development of operations analytics including identifying packing sorting inefficiencies resulting to faster throughputBranch Leadership Positions● Solutions Leader, Jan 2019 – May 2019● Data and Analytics Capability Leader, Feb 2019 - May 2019● Data and Analytics Business Development Leader, Sep. 2018 - Feb. 2019● Data Science Competency Leader, Mar. 2017 - Nov. 2018● Conduct data and analytics technical interviews, Apr 2018 - May 2019Business Development● Serve as subject matter expert to branch, corporate and executive leadership for proposals and presentations.● Co-Wrote and presented Tableau Business Intelligence Architecture and End User Strategy; resulting in engagement.● Contributor to data science spotters guide for account executive use.● Conference Speaker: Daugherty Business Solutions Annual Technology Summit, DevUp ConferenceTraining● Company Presenter: What Is Data Science, Data Science Platform Architecture, Making An Analytical App In R, How to Make a Strategic Proposal, Spotting and Acting on Business Development Opportunities.● Taught Course: R Programming● Completed Courses: Hadoop, Machine Learning and Neural Networks in Python, Tableau, Root Cause Analysis, Capability and Solution Crafting.Used: JIRA, Postgres, Historian, Ambari, Hadoop, Hive, Spark, Kafka, KSQL, Oracle, SQL Server, Talend, Spotfire, Qlik Sense, Tableau, R, Python
  • Schneider Electric
    Business Intelligence Lead Developer
    Schneider Electric Jan 2015 - Jul 2016
    Rueil Malmaison, Paris, Fr
    ● Primary responsibility: Lead developer of new analytical software, DTN Sense. Lead the evaluation, proof of concept and selection of BI software for Sense development. Developed and maintained the data model, materialized views and aggregations, interactive dashboards and reports. Participated in stakeholder and customer feedback on product roadmap and enhancements.● Wrote SQL queries to find customer, product and trend insights used in our business intelligence software and reports. Trend analysis focused on finding marginal changes in customer behavior related to buying patterns, categorical preferences and product loyalty.● Broke out stories and requirements for development from product team requests, and worked with team lead for sprint planning of Sense development.● Support ETL team as needed with data modeling and data mapping.Sense websites:● http://www.dtn.com/ag/agribusiness/sense/● http://www.croplife.com/equipment/dtn-launches-ag-retailer-focused-data-management-program/Used: MySQL, TIBCO JasperSoft, Atlassian JIRA, Talend
  • Foodessentials
    Data Quality Assurance Manager
    Foodessentials Sep 2014 - Nov 2014
    ● Prioritize throughput and accuracy objectives for weekly data acquisition processes, while coordinating with department managers to ensure their longer-term business objectives are met.● Establish and document data quality standards and accuracy measurements; use statistical analysis and computer programming to extract and interpret data, and report metrics to management.● Research repetitive data-entry errors, trends, and identify outliers using outlier detection methods with queries and distribution analysis. Based on results design solutions to continually improve data quality.● Gather requirements, create and document technical initiatives to improve data accuracy and throughput for data acquisition, and liaison with technology to ensure correct implementation.● Responsible for managing 6 data analysts who ensure the accuracy of data in various department roles.Used: MySQL, R
  • Enterprise Holdings
    Business Data Analyst
    Enterprise Holdings Nov 2012 - Sep 2014
    St. Louis, Missouri, Us
    ● Gathered requirements and analyzed data to determine validity of business problems for new reporting and data analytics initiatives.● Analyzed data using statistical methods which identified training opportunities to prevent stagnation of sales team performance● Researched events and anomalies in business processes, and analyzed supporting data to report causes and solutions.● Interpreted data and statistics, summarized results, and supported decision making with management.● Ensured the development and delivery of automated metrics reporting.● Team Lead on a team of 3, developed employees’ technical and project management skills.Used: SQL, Excel, Access, and VBA
  • Scout Investments & Insurance, Llc
    Independent Insurance And Financial Services Broker
    Scout Investments & Insurance, Llc Feb 2008 - Nov 2012
    ● Responsible for all aspects growing and managing a financial services business: marketing, calling on referrals, retaining and servicing current clients; mutual fund, investment account, and insurance policy selection; portfolio construction; and pairing client objectives and risk tolerances with the appropriate insurance or investment product.● Interactions with clients included educating them on how insurance and mutual funds worked. This helped them make decisions on choosing products that best suited their risk profile.● Over $2 million in assets under management.● Licenses held: Series 6, 7, 63; Life & Health, Property & Casualty.
  • Wells Fargo
    Risk Modeling Analyst
    Wells Fargo Aug 2006 - Feb 2008
    San Francisco, California, Us
    ● Ran predictive loan prepayment and default models to conduct analysis of forecasted results compared to actual results. Findings were shared with modeling team to improve forecasting accuracy.● Researched and analyzed trends and outliers of models, and summarized and reported results to data mining team.● Conducted exploratory data analysis on new datasets and input factors, and reported findings to modeling team for new inputs into existing models.● Automated reporting of prepayment, default, and interest rate risk metrics. ● Coordinated data and technical requests with data management team to support objectives.Used: Stata, SAS, Excel, Perl
  • Citi
    Operations Analyst
    Citi Dec 2004 - Aug 2006
    New York, New York, Us
    ● Developed operations models, generated reports and conducted analysis on the business’ loan processing capacity.● Forecasted short-term loan volume and built throughput metrics for day-to-day and strategic decision making on the business’ operations, processes, staffing, and capacity with exploratory statistical analysis and mean testing.● Interpreted data and statistics, summarized results, and supported decision making with management.● Automated the generation and distribution of operations analytical reporting.Used: SQL, Excel, Access, VBA and Perl
  • Bank Of America
    Quantitative Research Analyst
    Bank Of America Jan 2001 - Dec 2004
    Charlotte, Nc, Us
    ● Collected historical research to develop new and test existing investment strategies using FactSet, Bloomberg, MATLAB, and Excel. Interpreted data and statistics, summarized results, and supported decision making with management.● Developed predictive multivariate models using linear and transform regressions.● Developed portfolio constraint(s) methodologies for risk control and tracking error objectives.● Developed outlier detection for predictive reversion model, and implemented switching model to improve performance.● Managed department simulation system of investment strategies.● Ran, analyzed the results of, and reported on statistical modeling errors and simulations. ● Wrote computer programs for the collection, cleaning, normalization and organization of data; and the automation of research reporting and investment model performance analytics.● Wrote tax loss harvesting monte carlo simulation using C++ to estimate probable outcomes of tax efficient portfolio strategies. Simulated distribution was non-normal to ensure similar behavior as the stock market.Used: FactSet, Bloomberg, MATLAB, Excel, VBA, Perl, C++

Ryan Metcalf Education Details

  • University Of Missouri-Saint Louis
    University Of Missouri-Saint Louis
    Management Information Systems
  • University Of Missouri-Saint Louis
    University Of Missouri-Saint Louis
    Economics
  • University Of Missouri-Saint Louis
    University Of Missouri-Saint Louis
    Logistics And Operations Management

Frequently Asked Questions about Ryan Metcalf

What company does Ryan Metcalf work for?

Ryan Metcalf works for Ameren

What is Ryan Metcalf's role at the current company?

Ryan Metcalf's current role is Delivering value with data driven decision making by bridging the gap between Analytics, Business, and IT..

What is Ryan Metcalf's email address?

Ryan Metcalf's email address is rm****@****ren.com

What schools did Ryan Metcalf attend?

Ryan Metcalf attended University Of Missouri-Saint Louis, University Of Missouri-Saint Louis, University Of Missouri-Saint Louis.

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.