Brian Ruffo Email & Phone Number

Bellevue, Washington, United States

Bellevue, Wa

Maintained and expanded relationships with major accounts around the Northwest.Gained insight into customer business process and requirements to better provide consulting resources who exceed customer expectations. I've personally interviewed all consulting resources we place with our customer base (approximately 150). These include BI Developers, Data Scientists, Data Engineers, Developers, Service Engineers, Project Managers, and Leads.Maintained existing customer and consultant relationships to keep customer satisfaction greater than 98% and consultant approval of DLI around about the same.

Bellevue, Wa

Our mission at DLI is: "To revolutionize consulting with a 'golden-rule' approach. We work with passion and intensity, remembering that life is too short not to have a sense of humor." DLI started with three of us and we now have 150 consultants. My role is both managing consultant and account manager. All of my "contract positions" since 2007 have been completed while working at DLI.

Redmond, Wa

Working in Microsoft's Operating System Group as an enterprise BI architect. Pushing a top-down business objective-driven methodology for defining title performance and in-game telemetry reporting requirements for Xbox Fitness, Nike+ Kinect Training, Project Spark, National Geographic, PlayFit, Kodu, and all of the new Microsoft HoloLens titles. Rolling out the necessary business process and technology to deliver actionable business intelligence. Responsible for all phases of the software development lifecycle within the project scope (I'll define, document, gain approval of business requirements, and write the code to transform, aggregate, and visualize the data). Methodology used: AgileTechnology used: Visual Studio 12/13/15, SQL Server, SSIS, SSRS, SSAS (MOLAP MDX and Tabular DAX), SSDT, ETL, Hadoop, MapReduce, HiveQL, Big Data, Azure HDInsight, Azure SQL Data Warehouse, Power BI, Power Query, Power Pivot, Power View, Power Map, SharePoint, and Tableau.

Redmond, Wa

Brought back into the organization (see position under Revel below) to assist the Product Manager with new “all up” implementation based on new business requirements. Worked with 8 countries to define a global events business process. Captured business requirements (BRD) from newly defined events process. Defined and clarified new global set of business requirements. Worked with the Microsoft UX team to streamline the event creation and customer registration UI. Defined BI strategy for the platform and assisted in implementation via code reviews. Wrote the BRD and FSD for tracking public employee attendance at Microsoft events (government gift compliance), managing events in a series, onsite check-in, and the implementation of business intelligence creating a holistic view of the customer based on upstream and downstream data warehouse data.Methodology used: WaterfallTechnology used: SQL Server, ETL, SSRS, C#, VB.NET, IIS Live Smooth Streaming, Microsoft Expressions, Visual Studio, VSTF, and Microsoft Test Manager

Seattle, Wa

Brought in to assist in the creation of a business intelligence solution for Amazon’s Flexible Payment System. Responsible for rolling out a central reporting solution to show aggregated and detailed accounting data from 3 disparate systems. Worked with stakeholders to identify issues created by cross-system dataflow between order to cash (OTC) and AR tied out to the GL. Wrote PL SQL for MYSQL and Oracle on Linux to perform complex enterprise data analysis. Mandated to manage the fix for any bugs identified as a result of this effort. Responsible for creating the operational process for BI data consumption by the accounting organization.Methodology used: AgileTechnology used: Oracle, MySQL, PL/SQL, VIM, and Linux

Redmond, Wa

Acted as Product/Program Manager for the implementation of a global Workshop management solution in the Microsoft Premier services organization. Starting with the requirements from five subsidiaries, performed business process modeling and a gap analysis to identify the best technical solution. Performed business process reengineering to create a signed off baseline Workshop management process for all five subsidiaries. Took the requirements from the baseline process and worked with IT to modify an existing internal system. The resulting system caused a massive increase in employee productivity as most previously manual tasks (data collection and tracking via email and Excel, etc.) were automated. The Workshop management system is now live in 23 countries.

Redmond, Wa

Performed product privacy reviews for internal and externally facing products. Made recommendations to product teams to keep software in compliance with Microsoft's privacy standards. Facilitated legal review and sign off of product compliance and privacy statements. Built a tool to automate privacy statement creation.Technology used: InfoPath, XML, and VBA

Bellevue, Wa

Redmond, Wa

Worked as Product Manager on the Microsoft World Wide Events platform. Started 80% into a troubled release as a smoke jumper resulting in a successful rollout within 1 month of the original go-live date. Grew system usage from 3000 to 5000 internal users. External customer registrations grew from 3 million to 6 million per year. These increases were due to increased subsidiary adoption based on better functionality and usability for Microsoft’s customers.Methodology used: WaterfallTechnology used: SQL Server, C#, and VB.NET

Worked with project team to refine business requirements and build technical designManaged project based on broad business requirements and a tightly defined scope and budget.Starting with a proof of concept, managed the design, build, test, and rollout of MS CRM.Methodology used: WaterfallTechnology used: MSCRM, Transact-SQL, and SQL Server

Bellevue, Wa

Built and managed a CRM practice with 15 consultants in the Northwest. This team successfully implemented MSCRM at Getty Images, DBSI, Alaska Federal Credit Union, Boeing (Military Division), and PAML (Pathology Associates Medical Laboratories).

Seattle, Wa

Managed the implementation and integration of MS CRM. Worked with project team to define, establish and ensure completion of all program milestones and to maintain a disciplined adherence to timelines and budgets. Drove team to meet revenue goals and other performance metrics. Worked with internal clients to develop and support the strategic vision for the program, including strategic and tactical planning as needed. Provided full and accurate program communication to project team and sponsors. Used scenario based training to train 145 pilot users nationwide. Project finished on time and ~$180k under budget. System rolled out to ~800 users worldwide.

Snoqualmie, Wa

Managed 4 direct reports and 2 - 10 consultants. Successfully implemented a Key User Group approach to project management and project prioritization.Ran global process consolidation project resulting in a single Marketing, Sales, Service, and Support processes in the UK, Germany, Benelux, Japan, and North America.Implemented SFA to facilitate sales pipeline management globally, resulting in accurate global sales forecasting. Successfully trained employees to be self-thinkers and risk takers as it relates to global project management. Integrated local internal IT processes with Philips standard global processes. Acted as a representative for Philips Oral Healthcare on a Philips-wide MySAP CRM implementation template team. Facilitated business buyoff on process definition globally in Germany, the UK, Benelux, Japan and North America. Was the Sarbanes-Oxley representative for IT.Methodology used: WaterfallTechnology used: Onyx Software, MySAP CRM, Transact-SQL, SQL Server, Visual Basic, and VBA.

During this time I spent two years working as an independent contractor. The companies below represent a highlight of my customer base. Aptimus, formerly FreeShop.com (12 month retainer)Conducted detailed sales modeling meetings to map out a formal sales process Customized Aptimus' Onyx CRM implementation to incorporate new sales methodology.Created sales forecast reports resulting in increased revenue predictabilityUsed Scribe Migrate to perform data conversions from 5 different data sources.Rolled out Onyx to a total of 100 users nationwideImplemented Onyx Enterprise Data Mart for business intelligenceCreated more than 20 web based data mart reportsChempoint.com (15 month retainer)Completely redesigned Chempoint's CRM implementation based on detailed Sales, Marketing and Customer Service modeling sessionsUpgraded system from Onyx Customer Center version 4.5 to Onyx Employee Portal 3.0Moved all legacy SQL customizations to the Onyx Web client using VB Script, Java Script and ASP codeUsed Access 2000 and Scribe Migrate to perform data conversion from 3 different sourcesRedesigned Chempoint's Onyx to Interworld integration using COM+Used remote SQL procedure calls to create an Onyx to Yantra order history integrationAppliant.com (3 month retainer)Moved 15 Sales revenue and Support effectiveness reports from Excel to the Web using SQL, IIS, ASP, DHTML and Onyx's Enterprise Data MartUsed ASP, HTML and SQL to create a web based amortized revenue forecast reportPerformed detailed business modeling meetings with Sales management and Account Executive teamsConfigured Onyx to more closely match Appliant's new sales process

Bellevue, Wa

Carlson Marketing - Budget Rental Car "Perfect Drive" Program (8 month project)Held detailed process modeling meetings to gain knowledge of Budget Rental Car's Perfect Drive loyalty programConfigured Onyx to track customer car rentals, points earned, customer service issues and point redemptionsImported over 4 million records from Budget's mainframe into OnyxDesigned automated new customer weekly import from Budget's mainframe to Onyx using database design and SQL Server stored proceduresUsed SQL to create automated system activity reports. These reports communicate system status back to Budget Rental CarConfigured Informatica to perform weekly imports of Budget Rental Car's customer data

Seattle, Wa

Federal Way, Wa