Steven Jonas Email & Phone Number

Portland, Or, Us

Portland, Oregon Metropolitan Area

Designed and implemented an analytics environment from scratch for the Business Operations group within Nike’s Data and AI division, laying the foundation for scalable data analysis and reporting. Leveraged Power Query for ETL processes, Power BI for visualizations and Microsoft Fabric for hosting and deployment pipelines.Gathered requirements from stakeholders to design a robust semantic model that combined data from four systems to be a source of truth for reporting.Designed and built dashboards and reports that were used to manage a $90 million budget for headcount and strategic resource allocation, with an audience of 100+, including VP and directors.Designed and standardized reporting templates, establishing a cohesive visual identity for all analytics reports.Implemented a CI/CD pipeline, optimizing the deployment process for analytics tools and dashboards.Pioneered the use of Jira in our group to track issues and plan sprints for development.Automated the generation and distribution of exception and consistency reports, ensuring data integrity across platforms.

Portland, Oregon, United States

With an expert-level Excel proficiency, aided electric utility projects by building advanced analytical tools that utilized Power Pivot for building data models, Power Query for performing ETL processes on data from multiple sources, and thoughtfully designed pivot tables that aided data exploration for team members. All projects involved defining, analyzing, and documenting the requirements for the project.Developed workflows for tracking the completion of training modules by subject matter experts and for documenting all of the tasks, questions, and decisions that arise during the course of an electric utility project.Helped plan the architecture for training dozens of staff on new systems. Built and owned the Sharepoint site that organized and provided training materials. Worked to integrate these assets with the learning management system. Provided ongoing support.Designed process for employees to ask questions and provide feedback through a discussion board hosted on Sharepoint site. Helped build notification workflows so that questions are assigned and answered.Improved the function of several Power BI reports by fixing longstanding problems through a deep knowledge of how the software operates and close analysis of how the report was initially designed. Product owner was elated because problems that I fixed were said to be "impossible" by expensive consultants. Tested my changes and went through a version control process to move new reports to production.Expert-level proficiency at Excel. Power user of all other MS Office applications. Advanced proficiency with Power BI and writing queries with SQL Management Studio.

Designed and built Filemaker database to store all business data, used for internal business processes and as a backend for a public-facing website. Integrated with multiple services such as Eventbrite, Meetup, and Vimeo.Gathered requirements, designed and implemented the user interface and workflows for the team to use for day-to-day business functions.Created dashboards with KPI's for managing ticket sales and program development in Power BI.Integrated the database to interact with multiple, such as Eventbrite, Meetup, and Vimeo, and serve as a backend to a public-facing website.Performed regular and ad-hoc data analysis writing SQL queries to retrieve data and using Power BI and Tableau for analysis and visualization.Co-wrote the book "Personal Science: Learning to Observe", due to be published in 2022, on how to glean insights from one's personal data. Co-written with Gary Wolf, contributing editor at Wired Magazine.Produced over 10 public health symposia and conferences, bringing together public health officials and toolmakers from all over the world to learn how to use personal data to improve patient outcomes. Collaborated with Robert Wood Johnson Foundation and Abbott.Emceed sessions and gave talks to audiences as large as 600 people in three countries.Edited over 300 personal data talks with speakers of all levels of public speaking experience (from college students to CEO's). Pioneered and perfected the format for the personal science Show&Tell talk. Flown to Stockholm for the 2019 Spetspatient conference to help diabetes patients put together talks for an audience of doctors and public health officials.

Portland, Oregon, United States

Responsible for data quality for the Industrial sector's project database and administering the team's Sharepoint sites.Received seven straight quarters of perfect audit scores. Provided monthly forecasting reports, initially querying against SQL databases with MS Access and later SQL Server Management Studio.Provided data analysis for the organization’s quarterly reports as well as annual analysis of program performance, for an audience that included the executive team and public utility commission.Designed how new initiatives were going to be tracked and reported in proprietary project tracking software and in Sharepoint. Revamped the presentation of data by clearing out chart clutter, improving aesthetics, and focusing on a story to tell, based on principles from Edward Tufte.Consulted on the data-structure design (ERM) for new CRM (contact relationship manager) and drafted business rules around its use. Provided routine and ad-hoc analysis, querying a SQL database using SQL Management Studio, and using Excel, PowerBI, SSRS and BI from BusinessObjects for analysis and visualization. Directed the work of contractors and mentored interns.Completed the Project Management Certificate program from Portland State University

Portland, Oregon, United States

Managed user accounts in Active Directory. Helped configure and deploy enterprise software including MS Sharepoint. Troubleshooted and resolved user issues and managed desktops in a Windows environment. Gave orientation and security protocol training to new users. Trained and delegated work to Help Desk contractors.

New York, United States

Nominated for a Sports Emmy in the category of "Outstanding Achievement in Content For Non-Traditional Delivery Platform" for a video on Bill Mazeroski's game-winning home run in Game 7 of the 1960 World Series.