Joseph Siebert Email & Phone Number

Portland, Oregon, Us

Our team works on the “direct to consumer” side of Columbia’s business, both from an Ecommerce and Brick & Mortar perspective. My tasks range from quick one-off questions to deeper multi-month research projects leveraging data from ADW, the Azure Data Lake, up through local files.Some of the analysis themes I have worked on include:o Promotion Success- profitability, traffic impacts, conversions, click-through metrics, etc.o Market Basket- products being bought together, their frequencies, time trends, etc.o Weather Analytics- forecasting events that are statistical outliers for locations, machine learning predictive impacts to sales based on daily weather, etc.o Returns & Exchanges- highlighting consumer tendencies to reduce revenue losso Return Reserves- building machine learning experiments to forecast returns by segmentationSkills and Tools Leveraged:o PowerBI Desktop and Serviceo SQL querying and table managemento Python: PySpark and Pandaso Databricks Notebooks, Jobs and AutoML

Coventry, England, Gb

As part of a two person team, I partnered on strategy, design, building, testing, and maintaining all things data at a mid-sized manufacturing plant. Internal clients across all departments such as Engineering, the Executive Team, Supply Chain, and Finance came to us to provide insights into questions they have about their operations, etc. We then build Visualization tools using Tableau and all of the necessary data infrastructure to support it and maintain it. I brought strong technical experience in the following to support this role:o SQL querying and database design and constructiono Python scripting leveraging pandas for data manipulation, cleaning, and other ETLo Data mining and analysis into data holes / broken data toolso Data pipeline design and maintenance to build tools that are automated and will last after our team is goneo Tableau workbook design and constructiono Tableau server website tool expert

San Diego, California, Us

Engage Financial Technology is a fintech start-up that ranged from 25-70 employees while I worked there; it offers platform as a service (PAAS) and turnkey / custom products for banks and clients seeking financial management solutions for their employees or end users. As a key member of the project management team, I wore many hats that included responsibilities and accomplishments such as:Data Analysis related responsibilities:o Querying our databases to test our digital projectso Building development timelines considering data collection, cleaning, ETL, and testingo Collecting requirements from clients with considerations of data types, locality, error handling, data security, existing database structures, banking regulations, PII, etc.Senior BSA Responsibilities / Accomplishmentso Analyzed feature development to provide deeply technical tasks for development and testing both backend (logic, APIs, etc) and frontend UI (iOS, Android, and Web), while considering impacts on existing code bases, technical debt, developer skills, business requirements, regulatory requirements, and future product roadmapsAgile Champion Responsibilities / Accomplishmentso Developed and Implemented processes, milestones, and other software development techniques in consideration of pure agile practices, while methodically introducing only beneficial practices at an acceptable rate for the teams

San Diego, California, Us

Gb

Data Analysis related responsibilities:o Led the reporting workstream on a large ERP implementation for a fortune 200 energy company dealing with project data and primarily financial reportso Worked on a team of 2 building Power BI dashboards in partnership with the Machine Learning group in Technology StrategyManaged a release of new features developed for a Fortune 100 airline company’s software improvement program; the program was delivered using agile methodology, centered around their call center business with interdependencies on other departmentso Drove 7 development teams (56 resources), consisting of client staff and vendors both onshore and offshore, to meet project milestones and deadlineso Drove technology improvement initiatives with IT leadership, development teams, and the dev-ops team to improve program branching strategy, and TFS dashboards for improving development communication across departmentsWorked on a team of 40 to implement ERP solution: Dynamics AX 7 for 115 legal entities to a Fortune 200 energy company; the initiative encompassed the strategy phase all the way through the support phase, with accomplishments and responsibilities including:o Implemented 17 modules concentrating primarily on financials, such as Accounts Payable, Cash and Bank Management, Expense Management, Fixed Assets, General Ledger, Procurement and Sourcing, Project Management and Accounting, and TaxDiscovered and developed solutions to complex technical challenges dealing with Microsoft Azure, Azure Machine Learning, and Microsoft Power BI through internal initiativeso Built dynamic dashboards using Microsoft Power BI consuming information calculated by Microsoft Azure Machine Learning models

Armonk, New York, Ny, Us

• Designed and produced a digital document system for local Technical Exploration Center (TEC) events, saving the office $40,000 a year• Developed and deployed a remote imaging system to reduce shipping costs by $10,000 a year• Initiated and executed a project to analyze data sets regarding every sale over the last 5 years that utilized a TEC from one of 4 major locations to quantitatively show TEC effectiveness and profitability

Evanston, Il, Us

• Manipulated large data sets from career database using SQL, Microsoft Access, and Excel to analyze data trends identifying issues with and maximizing equal job opportunities for each engineering student demographic• Presented data insights to the heads of the career office to be concentrated and shown to the Dean of the school• Welcomed company recruiters to campus and provided information about the engineering school and its students

Evanston, Il, Us

• Managed design of a mobile, household solar-energy system to be mass produced and sold by a start-up in Nigeria• Developed and conducted market research plans for an urban low-output model and a client redesigned rural high-output model household solar-energy system• Analyzed basic economics of factory production in Nigeria considering component prices, size, warranty, and output

Caledonia, Mi, Us

Caledonia, Mi, Us

Bachelor'S Degree Of Science, Industrial Engineering

High School