.jpg)
I have a passion for leveraging technology to help businesses meet their needs and better serve their customers. I bring a deep understanding of business analysis, data architecture, and data modeling with a focus in developing reporting solutions to drive business insights and actions.
I believe continuous learning is critical to remaining relevant in technology and have completed degrees in both Finance and Business Information Systems. I have also completed certifications in AWS and Snowflake.
Born and raised in Oregon and currently living in Taiwan, I enjoy any opportunity to explore the outdoors and am passionate about travel and exploring the world.
Deep experience in business analysis, data architecture, and data modeling
Developed dashboards using Tableau and PowerBI
Developed data pipelines using Apache Airflow, Apache Spark, and Snowflake
Migrated Nike Digital Global Ops BI to Snowflake
Experience streaming and transforming application data in Kafka and Snowflake
Led analysis and development of KPIs in both healthcare and Nike digital
Platform: Amazon Web Services, Snowflake, Databricks
Databases: RedShift, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Teradata, DynamoDB
Data Tools: Airflow, Spark, Hive, Hadoop, SSIS, Tableau, Jupyter Notebook
Software: Git, Lucid Charts, Visio, MockFlow, Splunk, Confluence, JIRA
Languages: SQL, Python (Pandas, Numby, SQL, Alchemy, PySpark,Matplotlib), C#
AWS Services: EMR, Athena, Aurora, Lambda, Glue, CloudFormation, IAM, S3, EC2
Data Engineering | Business Intelligence | Requirements Analysis
Data-driven, analytical leader with expertise in all facets of data visualization, business analysis, and data warehousing and architecture.
Adept at bridging the divide between business and engineering functions to unlock the full potential of data while driving rapid business growth.
Skilled in aligning business goals with data solutions that drive process improvements. Proven track record of success with numerous systems.
Knowledgeable professional, continually focused on delivering successful, large-scale projects, implementing cloud-based data solutions at scale.
Accomplished communicator skilled in building and strengthening relationships across functions to drive cohesive, strategic operations.
Communicated with business stakeholders to define reporting requirements and data needs to ensure project success.
Developed Python and Spark tool set to streamline development of data pipelines and Snowflake data ingestion, enhancing code standardization and reduced time to delivery of data products from days to hours.
Successfully integrated ETL to process relational and semi-structured data in data pipelines using AWS EMR, PySpark, Airflow, and Snowflake.
Pioneered the creation and deployment of team Github and CI/CD pipelines to enable faster, repeatable deployment.
Leveraged Apache Kafka to stream product data to Snowflake to enable seasonal planning for Nike by You.
Created and implemented automated reporting process to eliminate manual reporting for global business partners to drive efficiency, allowing reporting to scale from 1x per week to 3x per day.
Instrumental in assisting the Data Architect with the development of new data model and governance structure to support reporting integration across 7 enterprise platforms.
Delivered high-quality consulting and freelance data engineering and business intelligence services to a wide range of customers, overseeing and executing projects in alignment with customer needs.
Coordinated with a local physical therapy company to build and integrate a chatbot using AWS Lex and Lambda to gather potential new client information and assist with scheduling.
Constructed Tableau dashboards for a variety of clients across healthcare and digital commerce industries.
Pioneered and fostered the development of new Snowflake environment, unlocking historical analysis and launched Key Performance Indicator (KPI) program.
Lead development on COVID response, leading to an additional $50M in revenue for North America by pivoting non-digitally planned products to digital platforms.
Developed operational reporting to facilitate seasonal planning, allowing Nike Digital to release over 15K products each season.
Coordinated with stakeholders to understand business processes and define reporting requirements.
Architected and developed Snowflake based reporting solutions for Nike Direct Global Digital Operations.
Successfully migrated existing reporting from MySQL to new Snowflake environment and created documentation describing report purpose and functionality for non-technical users.
Key role in constructing Tableau dashboards to visualize operations and marketing data for 1,500+ users.
Utilized analysis tools and techniques to successfully implement educational software in agile environment.
Collaborated with a diverse audience of business, technical, and educational stakeholders to gather, document, and validate business and technical requirements; ensured solutions aligned with customer needs.
Key member of cross-functional team, developing requirements for reporting solutions using AWS and APIs.
Supported implementation of big data reporting solution designed to reduce transfer times and cost by leveraging AWS Lambda, AWS Kinesis, AWS EMR, AWS Redshift, and Hive.
Documented architecture and requirements for big data reporting solutions to reduce transfer time and cost in new student testing system.
Developed Tableau dashboards leveraging filters, parameters, calculations, groups, data blending, and sets.
Designed SQL database to store and structure data using tables, views, stored procedures, functions, and triggers; implemented automated reporting processes utilizing SQL Server database and ETL in SSIS.
Reviewed program performance and identified improvements by analyzing quantitative and qualitative data.
Promoted from Associate Product Manager to Data Analyst in 2016; served as product expert and supported training, implementation, and operation of telehealth programs and products.
Portland, OR - USA | danstorms1@gmail.com
linkedin.com/in/danstorms1
