Ryan Lewis Email & Phone Number

Chicago, IL, US

Chicago, Illinois, United States

Chicago, Illinois, United States

• Cultivate a culture of excellence and mentorship, investing significant effort into mentoring other consultants. Exhibit strong leadership by modeling desired behaviors, driving team performance, and dedicating time to.
• Designed and led delivery of ETL pipeline refactor from AWS Glue + Airflow to use dbt-athena + step functions, improving load times by 20x and reducing costs by 50x
• Create a financial forecasting application for a client using Streamlit. The application uses time-series forecasting models and allows for managerial overrides and what-if analyses, improving existing process by.
• Refactor cloud-based AI Go application to use an on-premise Yugabyte database instead of GCP’s GDS. I was an individual contributor on this project, one of 13 developers, and my contributions were recognized as a.
• Lead teams of consultants, managing the day-to-day workflows across strategy, data engineering, application development, and reporting, ensuring project success and client satisfaction
• Develop a corps of "fanatical" (not my word!) mentees through dedicated leadership and training, contributing significantly to their professional growth

Chicago, Illinois, United States

• Manage the delivery of an end-to-end analytics platform implementation. Oversee the development of a custom Python ingestion application, transformations in dbt, data warehouse and business model in Snowflake, and.
• Help executives make informed, strategic technology decisions through both qualitative and quantitative analysis, ensuring alignment with short- and long-term business needs
• Help clients with analytics and data science strategy

Chicago, Illinois, United States

• Design and implement the ETL of a scalable BI platform using Azure, dbt, and Snowflake for a fast-growing startup, which has supported the company's 10x growth in the years that followed, from $100MM to > $1B, and.
• Develop firm’s DataOps CI/CD framework, applying software engineering best practices to data pipelines for enhanced reliability and efficiency
• Design and implement custom serverless data extraction applications in Python using AWS Lambda and AWS Step Functions for pulling data from a variety of sources, including APIs (REST and SOAP) and databases (NoSQL and.
• Model data into scalable star/snowflake schemas for reporting and BI tools, incorporating snapshot and slowly-changing tables where necessary

Chicago, Illinois, United States

• Demonstrate exceptional capabilities as a strong individual contributor, quickly acquiring skills in ETL, AWS, Snowflake, Docker, and others. Own key workflows, establishing a reputation for reliability and the ability.
• Gather requirements and document data needs from source-to-target, creating roadmaps to meet clients' business needs

Scottsdale, Arizona

• Design, maintain, and document SAS processes to create financial reports including expense, tax, EPS dilution, 10-K disclosure, etc., as well as future forecasts, that detail the impact from clients' equity.
• Analyze and review monthly reports, identify the drivers of changes in reporting metrics, note impacts to future reports, and ensure that solutions are consistent with the terms of clients' compensation plans and.
• Identify and develop flexible macros to address common firm-wide process pain points and needs.
• Re-engineer existing algorithms to increase efficiency and minimize risks.
• Support clients and their auditors with report recalculations and other requests.

Logan, Utah

• Develop trade strategies for Adam’s Investment Management portfolios using a combination of fundamental and technical analysis and leveraging a variety of tools including Excel, FactSet, and R.
• Create dashboards and KPIs for firm portfolio investments
• Create marketing materials including portfolio factsheets, presentations, handouts, etc.
• Manage the firm’s IT needs

Boise, Idaho

• Produce hundreds of custom, high quality, mobile responsive content using HTML5/CSS3.
• Recode the entire Bodybuilding.com store product catalog (approximately 6,000 pages) as well as the top 1,500 nutritional supplement and workout advice articles as a member of a small team of developers.

Boise, Idaho

Master'S Degree, Data Science, 4.0

Analytics and Modeling Specialization Capstone: Cost Optimization of Databases using time-series forecasting for investment banking client.

Bachelor’S Degree, Economics, 4.0

Activities and Societies: Econ & Finance Club

Associate’S Degree, Business