Nate Hamilton Email & Phone Number

La Pine, OR, US

Redmond, Washington, US

Our team owns the daily metrics for Azure Consumed Revenue and Partner/Service/Marketplace Influence attribution. Team domain champion for security and SOX compliance; driving team efforts to ensure our data services align to and continue to meet or exceed requirements for supporting SOX audit, GDPR, EUDB and other data privacy, security and infrastructure.

Redmond, Washington, US

Supporting DevOps and data model automation for the Azure Cloud Data Science team.Design and build compliant Cloud infrastructure for automation covering data acquisition, model processing and publishing using Azure Synapse.

Portland, Oregon, US

Enabled standardized, target specific, generation of procedures + views to support Fact + Dim upsert processing, using metadata, configurations, mapping and templates to customize code based on auditcolumns and keys present.

Redmond, Washington, US

• Our team Usage Data Platform owns on-boarding and processing for usage telemetry of all Office application users and devices.
• Key stakeholder to drive an 85% reduction in streams availability using lambda pattern to enable near real-time (sub 24h availability) with over 99% completeness vs existing static 6day SLAs for each of 50+ workloads.
• Enabled a $1.4M / 72% reduction in yearly Azure COGs by identifying and purging redundant / unused resources, backups and storage.

Redmond, Washington, US

• Created automation for Cloud Managed MAD and Modern Consumer Device Activation metric for FY21 Target setting.
• Refactor and re-architect reporting silos for month end com/con device activation metrics to unified base daily reporting process.
• Reduced team COGS by 35% through consolidation and elimination of redundant legacy infrastructure.

Redmond, Washington, US

• Lead efforts for metric specific data silos consolidation covering: EMS, O365 and M365 score card and field metrics within a single common data model.
• Primary stakeholder for larger scale efforts to drive for group wide common key mapping across business groups.

Redmond, Washington, US

Managed end to end curation of data stream snapshots required to enable reporting of active User/Tenant consumption metrics for SLT and field sales compensation covering for the Enterprise Mobile Security (now SCIM) services: AADP, AIP, ATP, Intune and MCAS.

Redmond, Washington, US

• Standardized data object model + queries for historic Subscription + Offer vs Billing vs Usage/Resources vs Customer.
• Created data model and solution to capture all Azure Subscription Resource Usage summary, ranking, and normalized MoM deltas over six Customer key grains.
• Enabled migration of 2000+ user objects between 2 SQL DW instances in under 2 weeks via metadata driven code.Managed CGA team’s Azure data platform infrastructure growth.
• Reduced costs by migrating to ARM objects / template.
• Moved regions / resized as needed to maximize resources vs cost.

Redmond, Washington, US

• Owned producing streams for Azure Utilization reporting Partners across the Cloud and Enterprise organization.
• Enabled utilization reporting for hybrid Azure usage scenarios: Suites, Azure-In-Open, Cloud Service Providers.
• Evolved a monthly Consumption based Incentives report for field sales use.
• Key driver in migrating monthly Azure Utilization reporting to new data model and SQLDW distribution.

Redmond, Washington, US

• Azure Operations - Data acquisition, delivery, analysis and insights.
• 50% process time / 80% memory reduction while extending history in primary tabular cube.
• Improved data quality across data sources through data freshness indicators and monitoring.

Redmond, Washington, US

• Collaborated cross business group to develop and evolve a product agnostic BI data model to track hardware genealogy throughout the manufacturing, consumer and repair lifecycles. Evangelized new BI feature potential.
• Demonstrated potential $15M overage on Cost of Repair (COR) estimates during New Product Ramp Up. Provided high grain datasets showing top contributors to yield loss across the factory during previous generations.
• Reduced request lead time for hardware genealogy data by 80% during new product launch with standardized templates and datasets. Captured holistic view of BI requirements to support future launch cycles.
• Collaborated cross business unit, driving upstream feature changes to manufacturing data system, with incremental updates to BI objects and reporting suite and deep analysis with customers.
• Enabled self-service BI reporting for daily fallout tracking of Critical to Quality Components across build weeks and during supplier part revisions.
• Streamlined development efforts and reduced operational costs an estimated $150k / year. Designed and deployed server environment for team development and test utilizing virtualization and NAS storage.

Seattle, WA, US

• Automated database administrative and monitoring tasks through metadata driven processes. Drove consolidation and upgrade of database server hardware and software.
• Influenced sponsorship of several Data Warehouse projects to convert on demand data extracts for financial recovery analysis in to standardized snapshots.
• Automated the refresh of the Dev or QA database from production backups.
• Developed automated reports for Failed Jobs, Object Creation, Database and Table Growth Tracking.
• Collaborated with stake holders to document requirements covering entire business processes. Drove efforts to analysis, translate and consolidate requirements to technical estimates.

Seattle, WA, US

• Established team’s Coding Standards for T-SQL and Integration Services. Performed all database design and data integration reviews, lead all other code reviews for SSRS, SSIS, SSAS and T-SQL. Mentored team members to.
• Created standardized reporting suite for Accounts Receivables department; enabling on-demand generation, data consistency and improving performance.
• Developed a configurable data load framework, with standardized file templates. Enabled data quality and validation rules to be conditionally applied. Reduced lead time for new client data onboarding from weeks to days.
• Created standardized utility functions for logging, error message formatting, time difference, first of month, end of month and date without time.
• Developed metadata logging process to capture any object changes in all databases. Added security overrides to conditionally block alterations to the data or data objects as necessary.
• Created XML data integrations to 3rd party Accounts Receivables application. Enabled automated validation, posting and reconciliation of scanned remittances. Provided reporting suite, Great Plains transfers between.

Worked on Crystal Reports for a variety of third party companies until the company was bought and chopped.

Started as a Crystal Reports developer, worked part time as a PowerBuilder programmer and ended up on the Custom Solutions team.

Certificate, Business Intelligence: Building The Data Warehouse

Associate'S Degree, Technology: Computer Programming

Chemistry