microsoft > microsoft Employee Directory > Nate Hamilton
hamiltonnate
Last updated: Yesterday
Nate Hamilton's Personal Email and Phone Number
Find unlimited person contact information for free with noon.ai.
Nate Hamilton
Senior Data & Applied Scientist - Commercial Financial Services - Azure Consumed Revenue
Get email
(free lookup!)
Get phone #
(free lookup!)
Location: La Pine, Oregon, United StatesApprox. Years of Experience: 29
Nate Hamilton's Current Workplace
Microsoft
Company Size
2500+
Amount Raised
$1.0M
Every company has a mission. What's ours? To empower every person and every organization to achieve more. We believe technology can and should be a force for good and that meaningful innovation contributes to a brighter world in the future and today. Our culture doesn’t just encourage curiosity; it embraces it. Each day we make progress together by showing up as our authentic selves. We show up with a learn-it-all mentality. We show up cheering on others, knowing their success doesn't diminish our own. We show up every day open to learning our own biases, changing our behavior, and inviting in differences. Because impact matters. \n\nMicrosoft operates in 190 countries and is made up of approximately 228,000 passionate employees worldwide.
Show more
Notable Investors
Microsoft, KB Securities, Technology Venture Investors
Enterprise
Developer Platform
Enterprise Software
Experience
Microsoft
Jul 2022 - Present
Senior Data & Applied Scientist - Commercial Financial Services - Azure Consumed Revenue
Dec 2022 - Present
2 yrs 6 mos
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 compliance requirements. Lead for Azure Infrastructure design and architecture to enable and support explainability for day over day variances in Azure Consumed Revenue.
Senior Data Scientist - Customer Experience - Microsoft Cloud Data Science
Jul 2022 - Dec 2022
6 mos
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.
Senior Data Engineer
OmniData · Full-time
May 2022 - Jun 2022
2 mos
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.
Microsoft
Jul 2011 - Apr 2022
Senior Software Engineer - IDEAS - Usage Data Platform
Jun 2020 - Apr 2022
1 yr 11 mos
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 to the metric reporting layers. • Enabled a $1.4M / 72% reduction in yearly Azure COGs by identifying and purging redundant / unused resources, backups and storage.
Senior Software Engineer - M365 Core Engineering - IDEAs - Field Metrics
Aug 2019 - Jun 2020
11 mos
• 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.
SDE II - IDEAS - M365
Jan 2019 - Aug 2019
8 mos
• 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.
Data Engineer II / lead, WIND - CDnA
May 2018 - Jan 2019
9 mos
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.
Project Manager II, Azure - Customer Growth and Analytics: Data Engineering
Apr 2017 - May 2018
1 yr 2 mos
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.
Software Engineer II, Azure Direct: Cloud Intelligence Platform
Jul 2015 - Mar 2017
1 yr 9 mos
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.
Consultant (Slalom LLC)
Oct 2014 - Jul 2015
10 mos
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.
Senior BI Developer - Manufacturing Supply Chain, Hardware Quality
Jul 2011 - Sep 2014
3 yrs 3 mos
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 through prototyping and mentoring sessions onshore and offshore. • 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, provided component consumption rates for assembly and repair cycles. • 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.
B-Line, LLC
Apr 2001 - Jul 2011
SQL Server Database Administrator / BI Developer
Sep 2007 - Jul 2011
3 yrs 11 mos
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.
Report Developer / SQL Developer / Senior SQL Developer
Apr 2001 - Jul 2011
10 yrs 4 mos
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 improve coding practices and enabled peer review tracking. • 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 trust accounts and ACH file creation / upload to initiate bank transfers. • Incrementally refined, extended and scaled an algorithm based matching engine by several orders of magnitude. Enable expanded services; best match refinement, pre-file checks, refile monitoring, history capture and fuzzy match potential hits.
Senior Cystal Reports Developer
Herrick Douglas
Nov 2000 - Feb 2001
4 mos
Worked on Crystal Reports for a variety of third party companies until the company was bought and chopped.
Programmer / Analyst
Tidemark
Feb 2000 - Nov 2000
10 mos
Started as a Crystal Reports developer, worked part time as a PowerBuilder programmer and ended up on the Custom Solutions team.
Education
  • 2008 - 2009
    University of WashingtonCertificate, Business Intelligence: Building the Data Warehouse
  • 1996 - 1998
    Bates TechnicalAssociate's Degree, Technology: Computer Programming
  • 1995 - 1996
    Tacoma Community CollegeNone, Chemistry