Daren (Dj) Johnson Email & Phone Number

Wichita, Kansas Area

Design and develop data analysis and reporting solutions for the organization as well as complete adhoc reporting requests. Responsible for the review and analysis of data from multiple internal and external sources that are communicated to all levels of management in the form of visually compelling business intelligence reporting solutions including reports, dashboards, interfaces, etc. Ensures that the use of business intelligence applications enhances business decision making capabilities.

Wichita, Kansas Area

• Project Server Subject Matter Expert responsible for the implementation, configuration, administration, integration, and support of Microsoft Project Server (MSPS)• Develop and present status reports using MSPS Business Intelligence (BI), to include coding SSRS reports, OLAP, and Performance Point dashboards and reporting tools• Configure Project Server to include enterprise project types and templates, modification of the Global Template, and managing workflows• Developed powerful custom reporting tool to easily visualize resource capacity and demand across multiple instances of Project Web App (PWA)• Configure enterprise resources and organizational structure. Manage users and permissions through the use of Active Directory Synchronization, project workspace permissions, settings, and configurations• Experience in SQL Server Database design developing T-SQL queries, functions, and stored procedures using SQL Server to create advanced SSRS reports• Implement, administer, and maintain multiple MSPS sites to include account and group administration and permissions. Create customized templates. Support the day-to-day operations of the Project Server• Designed and developed InfoPath Forms using InfoPath 2010 and SP Designer 2010• Designed and developed Workflows using Nintex Workflows in SharePoint 2010• Create ad-hoc queries and reports as requested and provide on-going support for these requestsAdditional Knowledge and Responsibilities• Exchange 2010 Administrator maintaining Exchange environment of 4,500, plus objects• Perform support and troubleshooting for multiple business applications. Tasks include performing work on service requests, incidents, and run and maintain• Visual Studio 2008, Visio 2010, SharePoint Designer 2010, Performance Point 2010, Microsoft Project Professional 2010, InfoPath 2010, SQL Server 2005, Microsoft Access 2010, JavaScript, VBScript, Perl, XML, Microsoft Service Center Service Manager (SCSM), PowerPivot

Wichita, Kansas Area

• Develop and maintain program plans of military aircraft from proposal to execution stage using Microsoft Project Professional and Project Server• Create and analyze daily metrics to create a better program flow• Develop and maintain Microsoft SharePoint sites for individual projects as well as functional groups• Successful implementation of Microsoft Project Server company wide • Conduct Microsoft Project Server and SharePoint user training

Mcconnell Afb, Ks

Computer Management • Responsible for development of unit SharePoint sites including Excel Services integration for online reporting• Lead professional in a team of nine individuals that designed, coded, and implemented comprehensive core automated financial management software used to analyze and distribute $750 million in annual budgets• Developed aircraft maintenance scheduling and tracking system using Microsoft Access. Gathered critical requirement data, developed a network permissions plan and successfully implemented product in under 30 days. Software implemented by four other Air Force bases as their standard• Designed, coded, and implemented a multi-functional system in Microsoft Excel that allows managers from all assigned agencies to easily account for and report status of all assigned personnel by updating a single Excel file within their individual offices Budgeting and Financial Management• Evaluated organizational funding requirements, prepared/lead formal budget presentations, managed complex financial analysis and reporting functions• Responsible for $50 million in annual budgets fulfilling daily worldwide operations• Program manager for unit’s government travel cards managing more than 300 official individual travel credit card accountsMaintenance Operations• Managed maintenance planning and scheduling, maintenance operations, aircraft maintenance, and developed maintenance training curriculum• Regulated communication and transportation systems supporting maintenance activities for the entire flight line maintenance complex• Directed and managed all scheduled and preventative maintenance processes on fleet of 50 year-old military aircraft. Coordinated activities between Active Duty, Reserve, and National Guard • Coordinated the day-to-day aircraft maintenance effort for a fleet of 63 KC-135s among 15 staff agencies, 40 maintenance shops and more than 1,300 personnel