Derek Daniels Email & Phone Number

Lynnwood, Wa, Us

(Engagement through TEKsystems)Tier 3 support for Azure Data Center Consumption for EA customers.

Hanover, Md, Us

Fayetteville, Us

Kirkland, Washington, Us

Practices include: Data Engineering, Cloud Services

Everett, Wa, Us

Everett, Wa, Us

Fire CommissionersAuthority of the Fire Commissioner is established by the Washington Legislature under the direction and restrictions of state law. Responsibilities include, but are not limited to:Establishes and maintains policy for the district; Manages and conducts the business affairs of the district; Makes and executes all necessary contracts; Employs any necessary services; Performs all acts necessary to carry out the goals and mission of the fire district; Employs a fire chief to carry out the daily functions of the fire department; Serves on one or more committees which deal with specific functions of the fire department.The board runs the District through the Fire Chief (“CEO”) individual commissioners do not, and should not, attempt to run the District.Appointments• Sno911 • Finance (Chair: DeMarco, Everett Fire Chief)

Everett, Washington, Us

Primary voting member of the Large Fire Caucus. A member of the Finance subcommittee.

Us

(Engagement through Unify Consulting)The role is the with the RESO organization. Tasked with consolidating disparate systems housing clinical engineering asset information. The data is being funneled into Nuvolo data system to be added onto Service Now (SNOW). • Leveraged Azure Data Factory (ADF) to migrate flat files (.csv & .xlsx) into SQL Server 2019• Leveraged Power BI Service Premium to upload dashboards & datasets (tabular models) to be the Single Source of Truth for Excel Pivot Tables.

Bellevue, Wa, Us

(Engagement through Unify Consulting)The role is the Digital Transformation Office (DTO) nested under the T-Mobile for Business (TFB) Organization. I was brought on as the Microsoft SQL Server Developer to support the Power BI Developer via coding/scripting complex business logic for the frontend dashboard UI; B3 or B4 max.Responsibilities include developing backend data integrations to feed front-end dashboards for non-standard initiative workstream dynamics trending and more complex portfolio delivery health tracking. Where data integration means stitching together data sources through complex coding/scripting for custom business logic to support Power BI data visualizations.• Sped up data processing time to 30 minutes (was over an hour with a high failure rate) • Simplified data integration process (from C# to ADF Pipelines) • Simplified data transformation process (simpler stored procedures)• Created a custom table for PowerApps to write back to

(Engagement through Unify Consulting)Tasked with getting business requirements and building out custom Unidash (internal data visualization tool) reports, and other ad hoc requests as needed. Presto SQL was used to pull data, Python was used for nightly data imports

Redmond, Washington, Us

(Engagement Through Unify Consulting)Was tasked with creating a low maintenance end-to-end self-serve cloud BI solution by the Commercial Cloud Strategy and Licensing team within the MS Marketing Org. The solution pulls leaf-level data together from various sources (structured & non-structured) into Azure Synapse Analytics (Azure SQL DW Gen. 2) via Integration (Data Factory with SSIS, PySpark, Scala) through ADLS Gen 2 as Parquet files. To later be consumed by Azure Analysis Services to be their single source of truth for their BI Reporting needs (Power BI, or Excel).This scalable quantitative BI solution allows team members to assess the impact of transition of customers and partners from legacy business programs to new offers, sales motions and go-to-markets. With leaf-level data points better demand driven insights can be obtained. These newly discovered insights will help create new KPIs to assist in sales motion tracking. Which will lead to easier identification of opportunities to enhance customer acquisition, retention and consumption results. Ultimately, this allows the business team members to leverage the cube (tabular model), and no longer rely to SQL to develop and communicate business insights to inform strategic decisions on transition sequencing, requirements prioritization and sales scenarios.

Bellevue, Washington, Us

Mount Angel, Oregon, Us

(Engagement Through Neal Analytics)Created an Azure end to end single source of truth reporting solution.

(Engagement Through Neal Analytics)The role was on the team that's involved with the Data Center Demand Forecasting. Was primarily tasked with maintaining their current BI reporting environment (Azure Data Warehouse, Azure Analysis Services, Power BI dashboards, Azure Automation Runbook) for their big data environment. Assisted in building out and implementing a new efficient cube structure that used surrogate keys (integers), instead of natural keys (alpha-numeric). That change allowed for two cubes that were over 30 gigabytes each, to be reduced to just 5 gigabytes (approximately %90 size reduction), it also reduced processing time of the two cubes from nearly 9 hours to less than an hour (approximately %90 processing time reduction); DAX and filters responded quicker too. Assisted in migrating data from Azure Data Lake Storage to Azure Data Warehouse, and into Azure Analysis Services. Assisted with creating Azure Automation Runbook (via PowerShell) to refresh tabular model (cube) partitions, and on error call another Runbook to record in an Azure SQL DB table, for proper SLA escalation. Wrote Kusto (Azure Data Explorer) queries to extract tabular model usage stats.

Everett, Wa, Us

(Engagement Through Seaway LLC)The Fluke Global Materials Linearity project engagement began as a straight forward BI Developer role (building out a relational database from scratch), to import data and write back to the Oracle transactional source system (Oracle writeback doesn’t occur elsewhere within Fluke). However, as time elapsed it morphed into a lot more. With the desired outcome (roadmap) including Microsoft PowerBI and advanced analytics (e.g. internet of things (IoT), and machine learning (ML)) within the Azure Stack , it naturally turned into an Azure Architect role. The new solution was to have everything in Azure to take advantage of GeoReplication, and the ease of adding advanced analytics with minimal hardware dependencies. The high level ETL data flow is as follows: 1) Import data (i.e. Oracle, CSV) into Azure DW from both Azure Data Factory (ADF), and Azure LogicApps (scans Outlook for refresh email, then calls an ADF Pipeline).a. Created an O365 Service Account (SA) was created to automate communication of failures and success to downstream users2) Transform ingested data in Azure Data Warehouse (ADW) to take advantage of mass parallel processing (MPL)a. Azure EventHub (IoT & ML) data will flow into ADW3) Export transformed data to Azure Database to accommodate a larger volume of concurrent users as well as GeoReplication.a. A component of the project Plan for Every Part (PFEP) tool for planners to view sizing data in Excel, and write relevant changes to the relational database (capture and store these changes).b. Similar process was requested for PSI (production sales inventory) tool.4) Data was then imported into Azure Analysis Services to become the single source of truth for reports (Microsoft PowerBI, and Microsoft Excel)

Woodland Hills, Ca, Us

Small business owner licensed to sell property (home/ fire, auto) & casualty (life & disability) Insurance, for both personal and business.

Everett, Washington, Us

(Engagement Through Neal Analytics & Tiny Lizard)Built out their Premier Procurement Department Enterprise Data Warehouse (EDW) and analytic (Tabular Cube, Power BI Dashboard) solution from the beginning (ground zero). The new back-end architecture for their reporting needs (i.e. monthly scorecards) was previously handled through a series of Microsoft Access databases. This process used to take days to complete, now it takes a couple of hours. Scorecard Metric inquires used to take several days to answer have now been streamlined to literally take minutes to research.* Upgraded their monthly SSRS based Excel scorecard to being dynamic from SSAS Tabular.

Bellevue, Washington, Us

Issaquah, Wa, Us

(Engagement Through Neal Analytics)Skills used include:• Requirements Gathering• Relational Database (Transact SQL)• Extraction, Transformation and Loading (ETL) (Microsoft SSIS)• Data Warehouse / Solution Design• Dimensional Modeling (Kimball Methodology)• Analytics / Tabular OLAP Cube Development (Microsoft SSAS,MDX, DAX)• Excel Reporting (Cube Value Functions)• Communicate sprint releases to relevant stakeholders

Redmond, Washington, Us

(Engagement through 425 Consulting)This engagement is for the O365 Consumer Marketing Team.Tasked with owning the SSAS Tabular Cube Process. Included importing data into the cubes, creating DAX calculations as needed, and producing reports Excel. While maintaining five production cubes.• Created Power BI.com reports for data visualization• Created reports for POC to business partners• Work with Project Managers & Stakeholders to gather requirements and create reports• Use cutting edge technology to create Data Visualization with Power View and Power BI (https://www.powerbi.com/)

Redmond, Washington, Us

(Engagement through CompuCom)Was brought on to assist with the FY14 MYR process, and to help transition MS Cloud Reporting from one team to another team (US Finance BI umbrella). The MS Cloud Reporting project has allowed me to acquire deep knowledge of the Microsoft BI Semantic Model (BISM) and Tabular Modeling. Successfully published a SQL White Paper around using DAX to create a Rolling 12 (Trailing Twelve Month) Dimension.Tools used: SSMS 2012 (SQL, MDX), Excel PowerPivot (DAX) & PowerView, SharePoint 2012.

Redmond, Washington, Us

(engagements through Mactus Group)Able to exude strong leadership skills and is an influencer while being a ‘doer’ at the individual Analyst and individual contributor level. Possesses hands on experience with the various systems within GMO and is able to do whatever it takes and go wide with his skillset. For what knowledge he doesn't have on a concept, tool, report, or technology he figures it out on his own. He collaborates with other colleagues, teams, and SMEs. All while Driving, maintaining, operationalizing, and documenting reporting for Partner RM, MRP Reporting, and MBP.• Created and augmented BRDs, can storyboard and partner with UI Teams, driving offshore projects with the designated TPM, able to step in as a TPM• Performed lightweight PM work, managing milestones while projecting his confidence levels on each deliverable. • Created reporting POCs, operationalizing dashboards, and help standardize and optimize new and existing reporting.

Redmond, Washington, Us

(engagements through Daves + Associates) Projects managed include automating data integrity audits against various servers and databases, and updating SSIS ETL processes. Learned how to use Report Builder 3.0 (lighter version of SSRS). Assisted client with FY13 Mid-Year Review process by creating a large data pack in Excel, which included PowerPivot Reports with complex DAX Scripts and PowerView Reports.• Performed requirements gathering for process documentation • Included flow diagram, entity relationship diagram (ERD))• Created Web Reports using MS Report Builder 3.0 for PAM World Class Selling (WCS) Profile of Excellence• Report is used routinely in the field (worldwide)

Redmond, Washington, Us

(engagement through Murphy & Associates)Projects managed include automating data integrity audits against various servers and databases. These servers and databases comprise the reporting platform for the transaction data warehouse, or the repository for the multi-billion dollar business and supports internal and external financial (and business intelligence) reporting. • Performed requirements gathering to develop automated data integrity audits based on feedback from stakeholders• As a part of the Control and Monitoring process, audit outputs send regular emails (success and/ or failure)• Performed requirements gathering to develop migration plan to migrate the team server to data center• Created Team Report Validation Log documentation, as well as helped maintain and improve other team documents• Testing and data validation of Fiscal Year roll hierarchy changes• Worked with partners to automate importing their data into our company wide report (SQL Jobs & SSIS Packages)• Email is sent when data is ready to be uploaded into the production environment, or if there are any data integrity issues

Redmond, Washington, Us

(engagement through Rylem)Created and refresh weekly and monthly canned reports to team SharePoint site for the sales field. Created ad hoc reports in SQL Server and Excel (pivot tables). • Enhanced Daily RevSum Data Pull from 12 hours to 1hour and a half (90 minutes) • Created SQL Job to Execute 2 SSIS Packages & DB Mail on failures & successful completion • Created Metrics via Visual Studios 2010 • Created and maintained SMS&P Distributor and Large Approved Resellers (LAR) Lists in MS Sales (MSRA) • Created a dynamic dashboard that filters data from multiple pivot tables in MS Sales for Small Med. Business (SMB) • Documented Mid-Year Review (MYR) Process for department wide distribution • Created/ updated documentation for monthly reports processes • Created: Business Rules Document (BRD) & Technical Specifications (Tech Spec) Document • Made the SMB Reach, Frequency, Yield (RFY) report more stream-lined and efficient

Redmond, Washington, Us

(engagement through Rylem)Created and implemented Scorecards for various Rhythm of the Business (ROB) and Business Groups (BGs), and maintaining the data integrity during the Fiscal Year for the Data Management team. Performed similar tasks for the Mid Year Review (MYR) Scorecard Process for ROB and BGs. • Analyze operational processes, work with data partners to develop and implement solutions. Contributed documenting and ensuring the solutions resolve the issues• Created Key Performance Indicators (KPIs) and their applicable Metrics with applicable backend calculations for SharePoint Scorecard and dash boards• Wrote rules for the Business Rules Engine (BRE) to extract automated data from MS Sales and MARS• Wrote Stored Procedures for data quality audits which included reports sent via email• Worked closely with the Product Managers and occasionally with the Data Partners to create their KPIs accurately• Participated in functional stress testing of new department software• Created procedural documentation of processes being performed

Portland, Oregon, Us

(Formerly Sterling Savings Bank) Successfully accomplished improving the monthly Treasury Department Profitability Process analysis; by updating current documentation and processes, creating new documentation, and streamlining the process using SQL Server 2000. In addition, created the Monthly Retail Branch and Loan Officer Score Cards to be distributed to both the Senior Executive Management of the bank and to the Retail Branches. Maintained and updated/ improved the documentation of this process.• Analyze, trend, forecast, and problem solve operational processes. Report analysis and results to the Banks Treasurer and Chief Financial Officer• Collected reports from other departments to merge and create the Profitability Process analysis and dashboards

Minneapolis, Mn, Us

Counted Money.

Washington, Dc, Us

Processed counterfeit US Treasury Notes for the Seattle Field Office

Ba, Business Administration

Aa, Criminal Justice

Education record