Aaron Stinson Email & Phone Number

Vancouver, Wa, Us

Pembroke, Massachusetts, United States

RSI is a technology company that develops and implements Tax Processing software for various state and local municipalities.• Developed ETL/Data Quality processes using SSIS and T-SQL for Tax Refunds, Corp Tax, Sales & Use Tax and Audit• Troubleshot several procedures with performance and memory issues• Documented and developed test queries to help team perform QA after conversion runs• Completed work for State of Kentucky Integration & Compliance Teams• Completed online training for Tax Processing Systems and RSI’s solutions

Portland, Oregon Metropolitan Area

Cambia provides BlueCross BlueShield health insurance in OR, WA, AK.• Developed ETL processes using Alteryx, T-SQL and Python• Created Data Quality processes using T-SQL• Designed and created Data Marts to support reporting of internal IT performance metrics• Created KPI visualizations w Power BI, Tableau and reporting w SSRS• Connected to several data sources using API services: AWS Cost Mgmt, Clarity ERP/ECM, SCCM, Brinqa• Active member of company’s Alteryx User Group helping to define best practices

Vancouver, Wa

BBSI is a co-employment, payroll processing and business services company with 57 offices in the US.• Designed and created SQL Server Data Warehouse to support reporting of HR, Payroll and PEO Billing data• Developed ETL processes using T-SQL, Alteryx and Warescape• Created Data Quality and Data Validation processes• Setup database partitioning and indexing to optimize performance

Portland, Or

Moda provides medical and dental insurance and exchanges information with several trading partners including healthcare providers, state and federal agencies. • Designed and developed insurance enrollment and claims integrations using SSIS and T-SQL to accommodate the then new Affordable Care Act requirements• Developed custom T-SQL stored procedures• Used PilotFish services to convert EDI X12 documents• Created and maintained several SSRS reports.• Mitigated T-SQL code in SQL Server upgrade project

Vancouver, Wa

• Designed and built a Business Intelligence solution from the ground up - from installing SQL Server to presenting finished Tableau dashboards to C-Level• Performed analysis of Epicor ERP and MRP functions to include Finance, Sales & Inventory Management data• Designed and built a Data Warehouse and SSAS cubes.• Built ETL processes using T-SQL and SSIS.• Built Tableau dashboards and worksheets with drill-downs and filters.• Also created and maintained several SSRS reports.

Vancouver, Wa

Papa Murphy's, rated the #1 pizza chain by Zagat in 2010 and 2011, franchises over 1300 locations in the US and Canada and collects 420m in revenue.• Several key integrations with Microsoft Dynamics ERP, Aloha point-of-sale, Menulink food cost system and more using SSIS, T-SQL and API calls• Designed and implemented a data warehousing architecture using ETL to populate staging, star schemas and cubes.• Created several SSRS reports showing insight into the business and distributed via SharePoint integration• Designed and created SSAS cubes that enable ad-hoc analysis of financial and store performance via PowerPivot and Power View• Used Visio Enterprise Architect to document and forward engineer database designs• Managed several projects and small team responsible for delivering business intelligence solutions

Golden, Co

Designed and developed web applications and databases for Dept of Energy to calculate and collaborate on how policy changes would likely affect energy consumption and CO2 emissions. Applications utilized an XML web services architecture and a rich user interface using jQuery and HighCharts. Created several complex T-SQL stored procedures and functions to support 3-tiered architecture.

Boulder, Co

Rally is a B2B SaaS provider of Agile Project Management software with about 100m in sales. Responsible for all aspects of Rally's web properties (www.rallydev.com, agileuniversity.com and agilecommons.org).• Redesigned the Products, Services and Events sections of the website.• Used Javascript, jQuery and AJAX to create rich interfaces with active graphics and enhanced tooltips.• Created web content management system using custom MySQL and Drupal to enable management of Events, Download Resources, Press Releases, and News. Implemented advanced features like Google Maps integration, Calendar views, AJAX forms, and custom module development. • Performed SEO activities and created web analytics dashboard in Google Analytics using visitor segmentation, funnels and site goals.• Performed day-to-day content updates, maintenance and administration of web properties.

Denver, Co

• Supported a diverse environment including SQL Server 2008r2, Oracle 10g and MySQL.• Designed and created business intelligence solutions using an Oracle data warehouse and data visualization through several methods including a custom web-based PHP front-end. • Designed and developed several key integrations and ETL processes using DTS, T-SQL and PL/SQL• Created several reports using SSRS, Report Builder 2.0 and Oracle Reports• Redesigned all web properties with advanced Drupal themes, location finders and Google Maps integration.• Built corporate intranet using PHP and Drupal to include searchable user-maintainable document library for training materials, marketing materials, and policies & procedures