Dean Nykamp Email and Phone Number

* Communicated project details through verbal and written means such as steering committees, status reports, proposals, reports, policies, procedures and presentations for clear understanding and facilitation * Oversaw, and/or participated as a team member on assigned projects to provide support and ensure effective collaboration of efforts and timely completion of tasks* Analyzed, interpreted and audited data, processes and project plans to identify trends, draw conclusions, ensure compliance, and make recommendations for process / procedure improvements* Helped gather Business Requirements, define and create Use Cases and Acceptance Criteria* Facilitated regulatory audit by helping track and enforce compliance and collecting evidence* Completed special projects and other duties as assigned* Performed detailed gap analysis between existing and proposed software solutions* Responsible for budget / forecasting

* Created and implemented strategic vision for program success* Worked with cross-functional partners to understand complex customer pain points, challenges associated with solving those pain points (procedural / technical / financial) and formulated options for resolution* Created excel-based metrics / status reporting solution (SharePoint, InfoPath)* Presented complex issues and recommendations to executive leadership teams (Director & above)* Created documentation templates (Business Case, Workflows) * Set up SharePoint site / data & documentation repository* Established relationships with all pertinent external teams

* Built excel-based reports using pivot tables and Power Query (some Power BI) from multiple sources* Created executive-level presentations with PowerPoint* Wrote Knowledge Base (KB) articles* Worked independently with minimal guidance

* Held functional reviews with business and engineering teams * Managed scope, resources and schedule for upgrades and maintenance for applications * Improved existing risk management practices* Lead business objectives and strategy on continuing growth of the applications and solutions portfolio* Connected the business group with IT solutions and support models that met their needs* Improved business processes knowledge across the business group – including helping identify pain points and opportunities for IT* Maintained high customer satisfaction levels and drove improvements* Set up multiple Azure (cloud) subscriptions and ordered / procured Azure servers * Helped lead and transition projects from SDLC Waterfall to Agile

* Gathered and analyzed requirements for new reports with little-to-no guidance and built prototypes (SQL, Power BI) as required* Worked directly with global field offices to provide analysis and insight into existing reports* Wrote detailed documentation for both user education and functional specifications* Facilitated monthly business review meetings

* Developed strong working relationships/partnerships with business leaders, IT team members (development, test, operations), and across multiple groups using my strong oral/written communication, organizational, negotiating and leadership skills* Prioritized feature requirements with customers – both for internal applications and external (extranet)* Led team in maintaining, designing, developing and implementing feature requirements and tool enhancements. Some specific areas include: - Applications that provide training for field personnel to enhance the skills, knowledge and information needed to execute against their commitments and goals - Applications handling volume licensed downloads and product keys* Created detailed functional specifications and Business Requirement Documents (BRDs)* Tracked Production issues and reviewed them with the team on a weekly basis* Created test cases for use in SIT (Systems Integration Testing) and UAT (User Acceptance Training)* Facilitated UAT for all releases. This includes:- Ensured proper resources understood their roles and were available- Ran daily triage meetings- Executed test cases (tested)- Tracked issues & helped to prioritize them* Excelled in a fast-paced and constantly changing environment.

* Provided reporting services to the GPPR (Global Programs Planning & Readiness) team and partners* Developed a robust reporting framework to ensure scalability and availability of data* Consulted on a long term reporting strategy for GPPR* Analyzed/presented reports (SQL Reporting Services, some Power BI) to executive level audiences* Managed GPPR SharePoint sites including content, permissions and maintenance* Ran monthly metrics* Collaborated and partnered with other project teams as necessary* Provided status as needed to management Tester (as needed before software releases)* Proactively involved in test strategies, planning, and execution (across the OEM Channel OEMLite and OST space following the MSFT SDLC/ITLC discipline)* Collaborated and partnered with other project teams as necessary* Ensured appropriate test approach, methodology, and documentation were in place* Participated in LOB application compatibility and usability testing (Windows, Office, etc…) efforts as required* Contributed to building and maintaining test environments* Partnered with other SDLC groups to review specifications, insure timely resolution of issues, ensured thorough testing from a business perspective, and understood support issues* Provided leadership to the GPR (Global Programs Readiness) test team* Enabled the delivery of high-quality, reliable applications via tools, automation, standards, and best practices* Active involvement in test automation.

* Drove development of high level requirements and cost/benefit analysis* Managed issues logs, coordinated weekly team status meetings, issued weekly status reports* Drove deliverables according to the project plan and milestones* Identified, monitored and mitigated risks* Managed project websites, status report updates, and other communications processes and tools * Drove project status and other meetings * Facilitated cross-team collaboration to ensure holistic solution * Identified incremental business or process requirements in support of the program

Senior Program Manager 02/07 – 07/09* Led successful effort to incorporate Microsoft’s financial reporting system of record (aka MARS / Project Mercury) into a large Enterprise Data Warehouse (EDW) within the Business Intelligence (BI) IT group* Managed and owned the maintenance, design, development and implementation of the corporate finance data warehouses used to report and manage the consolidated financials of Microsoft Corporation* Included moving numerous existing data feeds and ETL to the new db system & structure* Implemented a reporting solution (for the MARS system described above) based on Microsoft’s BI (Business Intelligence) stack. Also maintained and enhanced existing MSRA (internal tool) reports.* Acted as Subject Matter Expert (SME) for financial reporting and fielded any business / customer escalations as appropriate.* Developed strong working relationships/partnerships with business leaders, IT team members (development, test, architects, operations), and across multiple groups using my strong verbal/written communication, organizational and leadership skills* Wrote detailed functional specifications, drove feature prioritization* Ensured compliance with SDLC and SOX (Sarbanes-Oxley) guidelines for every release* Created and maintained master project plans and owned the schedule of all releases* Provided weekly status reports (and updates as needed) for a wide audience on high-profile projects* Conducted risk assessment, mitigation strategies and tracked dependencies for every release* Managed budget, helped with forecasting* Developed good relationships with staffing vendors to bring in additional resources as needed.* Worked closely w/ Microsoft’s SQL team as a key contributor to their TAP (Technology Adoption Program - essentially an internal beta test) for both SQL 2005 and 2008