Tim Coffey Email & Phone Number

Redmond, Wa, Us

Redmond, Washington, Us

Principal PM Manager, LeaderCloud Operations & InnovationCentral BI & Application Services LeadAccomplishmentsWith no Business Intelligence presence whatsoever supporting data center land acquisition, single-handedly built a solution utilizing Azure DevOps, to quickly support a quickly emerging global process. This project over time scaled to meet all land acquisition and land development activities which was later migrated to Dynamics 365, complete with data migration. This project allowed for the first time, rich Power BI tracking of all land projects around the world with major milestone KPIs created and visually represented.Tagging closely behind land acquisition project tracking was the requirement to also track energy delivery to all land and lease locations around the world. By utilizing the same ADO project for land tracking, built a parent - child work item structure to align multiple energy contracts to a single land parcel. This again, provided for the first time, rich intelligence utilized by the energy delivery teams and reduced manual effort across multiple segments.Confidential project management requires additional tools and non-disclosure agreements for employees and contractors to view and sign electronically. Built automated processes that automatically added newly on-boarded resources to our confidential project after successfully signing all required documents. Removing manual human interaction, the risk for human error was eliminated and timestamps were now provided for future audits.These and other programs are now under my oversight and leadership with multiple resources and managers with their own teams to support and drive future enhancements.

Issaquah, Wa, Us

For Microsoft, Corp.Sourced to build a custom Power BI application for external customers of Microsoft, Corp., that required background investigation and HBI tented project. Once launched, transitioned to the Azure organization, building from scratch executive Power BI solutions that are viewed at the exec VP level..Accomplishments• From Azure DevOps as a data source, built a custom burndown solution that required custom start/stop dates within the same project. Utilized Azure SQL Database to house historical burndown data while the most current 30 days came from the DevOps Analytics query. All sprints and phases of the project auto-rolled with a custom date table and multiple relationships to other data sources. Customer can view historical burndown data through the project, by each phase and sprint.• Brought in to development project where stored procedure was failing after previous resource had left role. Upon debugging, found a primary key duplication which was causing the 7-step procedure to fail. Rewrote new solution to include additional field for the primary clustered key which resolved the issue for the customer.• With no data available, worked with principal operations excellence lead on data collection and table creation with multiple attributes to be used for visualizations. Created Power BI reports, active directory security groups to publish in a single app workspace with user segregation. Executives now have reports that include financial tracking with % run total views, map views with custom tooltip tables and all auto-refresh enabled.

Bellevue, Washington, Us

Brought-in primarily for Power BI development, was quickly utilized for other skillsets including SSAS Tabular with live connection build and integration, SQL Server orchestration with table / view creation and PowerShell for datamining Power BI tenant data provided by Microsoft.Accomplishments:Customer had no BI presence to measure daily KPIs derived from Oracle-based application. Designed and built SQL Server 2016 Analysis Services (on-premise) tabular model with data model processing orchestration hooked in to SQL Server where Oracle data was landing via SSIS. Assisted customer with UPN integration within Power BI as the customer did not have UPN setup within Active Directory. This proof-of-concept concluded with a model in-place that the customer understood and could take to the next level per project deliverables and requirements.Tasked to reverse engineer a customer’s Power BI data model from excel spreadsheets to an Azure SQL Database and Azure Analysis Services solution, back in to a new Power BI template that was an exact replica of the original file. Customer went from a manual update and republish process, to a completely automated BI solution where data pipelines were created to ingest in to Azure SQL Database and thus a data model that auto-refreshed so that the end user always had the most up-to-date data.Wrote custom PowerShell to mine a mixture of Power BI, Workspace, User and Licensing and inserted in to SQL Server to build dimension tables that represent the customer’s tenant. Listings of all workspaces, users with access to workspaces and access level, datasets, reports and file imports utilized for a one-stop shop audit and compliance solution with customer’s own retention policies and utilizing O365 audit logging to monitor user activity within the tenant.

Redmond, Washington, Us

Chosen to architect a BI solution within XBOX Security, built an automated solution with only Microsoft products and within a challenging, secure environment that is not part of the corporate domain. With no data platform in existence to support security operations and multiple teams using multiple data-capturing tools, built an automated dashboard solution utilizing SQL languages that are used today for executive reviews along with scorecards and required analysis.Accomplishments:Security Incident Management was running tool from a desktop server with no reporting capabilities. Led a migration to a tented collaboration environment housed in an MS datacenter for reliability and scalability. Built from ground zero an automated dashboard with slicing capabilities, SSRS with subscriptions (and on-demand live data) all while providing data security to select audiences. This has now been onboarded to an Azure SQL warehouse with a Power BI automated platform and solution.Executive leadership requested a one year forecast of crypto-web volume and the amount of new server hardware that would be required. Utilizing predictive analytics based upon historical volume and predicted new feature attributes; provided 4 models with a recommended model that required no new funding. This was implemented successfully with a cost avoidance over $1M.Security Operations Monitoring team was spending cycles on chasing admin account checkouts via ERPM when the results always ended in being noise. Analyzed data from ArcSight monitoring to determine patterns of when accounts across (8) domains were being checked out. Statistical analysis delivered recommendations on detection creation based upon probability of time of day and the number of checkouts which reduced team churn and improved detection quality, and has been a standard onboarding model baseline for other new solutions.

Redmond, Washington, Us

Own, drive and deliver the overall quality of support for the Windows Azure Platform for Microsoft’s most critical enterprise customers and partners. Built and maintained a methodology that would rely on quality-driven principles with identified primary areas of focus towards the customer.Accomplishments:Windows Azure (Microsoft’s Platform as a Service solution) required integration with the current commercial support processes for customers to allow for both paid technical support and non-paid administrative support. Worked directly with engineering teams across multiple organizations driving process flows supporting business requirements to ensure a seamless customer experience once released. The end result was a live purchase authentication process that is customer-focused globally in nine languages with continuous improvements and new service releases being launched on a monthly basis.Forecasting support volume month-over-month was not accurate and at best, a ‘lucky guess’. Over time, mathematically engineered a predictive model based upon subscription growth with existing support volume, identifying very strong relationships by way of regression testing. Today, there is an equation to be used that will assist in financial and operational readiness and based upon statistical methods using financial forecasts as the predictor.Overall satisfaction with Azure Support customers was not easily obtainable without any known drivers. Analyzing existing Voice of the Customer data displayed a strong correlation between engineer satisfaction with the customer and the overall satisfaction of the customer. Built a mathematical simulation model that drove a change in metrics and measurements focusing on the inputs of commercial support that now readily predict overall customer satisfaction with leading indicators that can successfully be mitigated during the customer experience.

Redmond, Washington, Us

Currently performing business manager and process quality functions within the Product & Price Data Governance (PPDG) organization at Microsoft dedicated to strategic management of the business and identifying process deficiencies with detailed data analysis accompanied with planning for correction. Commitments include owning and driving the Rhythm Of the Business for Lisa Reller and her Leadership Team, dotted-line report to Operations Services Chief of Staff, improving Employee Satisfaction, optimizing FTE resources thru 6 Sigma Black Belt Project, and Scorecard Ownership, Build and Management for Organization. This position did not exist previously.AccomplishmentsTheory was that organization was not operating efficiently. Owned and executed 6 Sigma Project focused on identifying all process tasks and cycle time spent performing non-value add and redundant work. Findings identified opportunities to reduce cycle time by (minimum) 200 hours per week with actual savings being 4 FTE headcount.FY08 Employee Satisfaction results were low in key areas. Improvement efforts utilized Six Sigma methodologies, targeting two specific areas of focus. FY09 results included increase of 21% and 17% in the %Favorable category for the two targeted areas. Overall %Favorable increased 17% (64% to 81%). * Published company-wide best practice for improving workgroup collaboration.Pricing Operations organization did not have a leading indicator for Partner Satisfaction. Identified Key Problem Indicators (KPIs) by interviewing SMEs and key stakeholders. Engineered a new metric based upon data analysis that is now a Tier 1 metric for VP in FY10 and is a leading indicator of Partner Satisfaction.

Redmond, Washington, Us

Selected to the Microsoft Support Lifecycle team tasked to collect qualitative and quantitative Voice Of the Customer data pertaining to custom product support, extended product support, and improving the current product support lifecycle policy. Commitments included the collection of continuous and attribute data, analysis of commercial and consumer products leaving support with any escalated recommendations, research and reporting of installed bases for both Microsoft’s and Competitors’ top revenue-generating products, tracking (impacted) products by licenses sold, tracking and reporting revenue for custom support and extended support agreements. This position did not exist previously.AccomplishmentsMicrosoft did not have any Voice Of the Customer data in regards to product support lifecycle. With 100K budget, executed project that delivered both quantitative and qualitative information, including competitive products. Results of study aided in Executive decision making around our product support policies.Limited product hotfix release trending information existed within the Windows Client Product Group. Collaborated directly with Windows Client Senior Developers to build out hotfix release model. This information was used at the Executive level (Microsoft Support Lifecycle Review Board) to improve existing operating system support policy.Detailed revenue reporting for custom and extended hotfix support did not exist. Drove detailed reports at the program level by product. This allowed the discontinuation of programs that were not profitable.

Redmond, Washington, Us

Limited number of 6 Sigma Black Belts in Operations Services meant a risk of decisions being made without proper information. Selected to enter Microsoft Quality & Business Excellence Black Belt Program. Immediate gains noticed around information quality allowing informed business decisions.No 6 Sigma Green Belts in Product Support Services (Charlotte) in 2004. Selected to participate in Green Belt program and assigned improvement project within PSS. Drove consistent case-logging processes in Developer Support that aligned with Windows and Exchange Support Teams, decreasing Minutes Per Incident (case labor) in cases 21 days and older by an average of 100 minutes; bug cases reduced by average of 4 days.With Microsoft beginning to offshore and globally expand select support offerings, Internet Information Services Support did not exist in Bangalore, India. Chosen to be one of a few select support engineers to interview, hire and train newly created support team. This aligned to Microsoft’s strategy – Global Reach, which allowed for global coverage of Microsoft customers in the Americas and redundancy in other regions.

Hanover, Maryland, Us

Supported Microsoft’s Alliance, Premier and Professional customer base on the Internet Information Services (IIS) web platform. Developed and reviewed technical training, white papers and knowledge base (KB) articles for internal and external use. Traveled to customer site when requested.Accomplishments• With Microsoft beginning to offshore and globally expand select support offerings, Internet Information Services Support did not exist in Bangalore, India. Chosen to be one of a few select support engineers to interview, hire and train newly created support team. This aligned to Microsoft’s strategy – Global Reach, which allowed for global coverage of Microsoft customers in the Americas and redundancy in other regions.• Chosen to travel to Munich to train Microsoft Escalation and Support Engineers• Consistently received Very Satisfied survey results from customers• Given responsibility to build and lead the first 24/7 team in IIS.• Viewed as a successful and knowledgeable engineer with both technical and soft skills

Assigned to support all Xerox print centers within Bank of America nationwide. Created web-based processes for the print operators, which in the end was a complete Distribute and Print process that connected the East and West Coast Operations at BoA. Also responsible for the Xerox networks within these print centers and the upkeep of these networks; worked cross-group continuously with the bank's Information Security, IIS, LAN/WAN OPS, Lotus Notes Support and others to create new solutions for the bank and its associates.Accomplishments• Bank of America required a global, web-based print solution. As a Business Process Manager with Xerox Business Services, created web-based processes for the print operators, which in the end was a complete Distribute and Print process that connected the East and West Coast Operations improving ease-of-use for the end user.• Built partnerships with BoA personnel to drive new, consistent operation processes• Offered full-time employment by BoA IT Ops Groups

Duties consisted of building, configuring, and installing Windows NT and Novell on file and print servers for clients. Also responsible for Exchange, Proxy, and IIS configurations in NT and SBS environments from beginning to completion. Worked with third parties (AT&T, Sprint, and other data communications companies) in setting up full-time Internet connections and wide area networks. Configured Cisco 1604 and 2501 routers; RIP, IGRP, Access-lists, IP and IPX routing, setup, configure, and admin. Frame Relay, ISDN, for customers. Also programmed and monitored Catalyst 2900 series switches with IP for WAN administration.

Hanover, Maryland, Us

Contract on-premise at Carolinas Healthcare SystemProvided helpdesk support to all internal CHS employees. Technologies included (but not limited to): windows 3.1, Windows 95, and Windows NT 4.0; knowledge of Novell, Microsoft and associated networking technologies. Troubleshoot Lotus, Corel, MS Office and other business applications.

Us

Assigned to patrol working temporary assignments with Vice/Narcotics, Homicide and Store Break-in; worked under-cover assignments on demand. Collaborated with federal agencies as needed; federal gun/drug charges, counterfeiting, bank robbery. Performed community policing activities: community watch, bicycle patrol, task forces. Skilled marksman with perfect firearms qualification scores. Case building: Presented Felony cases to District Attorney’s Office; sought Arrest and Search Warrants from Magistrate. Assigned to training academy to work on in-car computer project and first CPMP intranet.Lead Investigator on all Misdemeanor Investigations within Adam 3-8 Response Area. Assisted on Felony Investigations as Interviewer and as needed role throughout investigation.Accomplishments• City of Charlotte, NC had a serial rapist at large. Working as a Charlotte-Mecklenburg Police Officer, encountered a recent victim while on patrol. Transported victim to location of crime and suspect was still on scene, positively identified by victim. Arrested suspect who confessed to 19 rapes.• City of Charlotte, NC was experiencing heavy foot traffic involving prostitution. Drove sting operation with Vice and Narcotics, utilizing local NBC news affiliate to film activities along with surveillance officers. Working under cover, arrested 13 suspects in 8 hours, spanning 2 days, reducing criminal activity dramatically following broadcast of operation. Additional Roles and Responsibilities• Range Safety Officer• Field Training Officer• Numerous Written Commendations (viewable upon request)• CMPD Dive Team• Accident Reconstruction Officer• Certified in Railroad Accident Investigations• MPH K-55 and K-15 Radar Certified

General Education

Applied Mathematics