Nicholas Blenkush Email & Phone Number

Renton, WA, US

Seattle, Washington, US

Kirkland, WA, US

Supporting City of Kirkland’s municipal Enterprise Applications with emphasis on IT Stabilization, Human Resources, Finance/Payroll, and Emergency Services data processes and applications. Deployed, authored, and maintained project and departmental SharePoint sites with ongoing end-user training. Implemented citywide systems monitoring, business.

On contract to City of Kirkland for in-flight application project completion, SQL database optimization, data analysis, and full migration to the Azure cloud

Seattle, WA, US

Reporting Team Lead, Data Warehouse Architect, and SQL/SSRS Developer. Monitored client invoicing and sales metrics integrating Salesforce data extracts into daily report measures. Developed complex reporting datasets and SSRS Reports across multiple granularity levels for Billing, Sales, and Executive-level reporting. Managed project and report tracking.

Optimized multiple blocking SQL queries, reduced overnight ETL times by 75%, and stabilized BI systems for scalability and operational continuity with weekly reports to the Executive Team. Stabilized critical ETL data flow within week three, restored critical metrics within week four. Overall ETL processes reduced by 75% from baseline on completion of.

Seattle, WA, US

Lead investigator for a citywide high-profile Seattle Public Schools data breach. Extracted breach metrics into one SQL database for remediation and reporting to the Superintendent. Scanned and normalized compromised data across twelve data sources into one dataset.

Redmond, Washington, US

Authored Business Requirement Documents for Global Microsoft Sales Pipeline personnel in partnership with onsite UIX Development Team. Mocked up KPI indicators & graphs for UIX vendor development.

Menlo Park, CA, US

Supported a mission-critical systems stabilization project for a leading health insurance provider, providing technical documentation and tracking SCRUM project metrics through SharePoint & InfoPath. Researched and segmented over 1,000 service accounts for security remediation to meet strict HIPAA audit deadlines requiring large-scale discovery & tracking.

Menlo Park, CA, US

Authored Teradata & SQL Server queries for T-Mobile’s CRM Department supporting SAS Campaign Builders, Senior Management, and Campaign Managers. Authored a broad range of Teradata queries from scratch and updated existing query sets into scalable, efficient datasets.

Redmond, Washington, US

Developed scalable SQL solution for advertising and upsell metrics against a 50B record data warehouse. Supported partner game developers providing game usage, click-thru, and spend metrics. Developed custom datasets for the Xbox Business Intelligence Team.

Redmond, Washington, US

Business Analyst covering Microsoft Advertising revenue, click rate, and spend metrics. Synchronized multiple advertising data sources into one SQL database. Created customized Excel data connections with advertising metrics pivot tables. Restructured manual cube extraction processes into scalable MDX-based queries.

Redmond, Washington, US

Tracked worldwide Microsoft Evangelist Sales Pipeline wins with daily reports to Program Directors. Authored SQL stored procedures for direct and aggregate reporting metrics. Combined Siebel CRM, SharePoint, Excel, Access, and SQL Server data into one normalized SQL data store. Coordinated worldwide training events for partner clients.

US

Analyst and backend-support engineer on American Express’ B2C shopping portal (www.shopamex.com) and supply-chain cataloging and procurement system (CatalogPro)

MarineLED specializes in next-generation Light Emitting Diode (LED) marine lighting. Website - www.marineled.com

Dallas, TX, US

WNS Business analyst for Western, Great Lakes, and Eastern Regions for cellular network switch build and maintenance.Fixed Wireless (WLTG) New Markets Business Analyst for 13-market launch.

Certificate, Business Intelligence, Data Warehouse

Business Management

Education record