Kevin Johnston **** North Richland Blvd, North Richland Hills, TX 76180

Mobile: 817-***-**** email: ac8ryu@r.postjobfree.com SUMMARY

Senior IT professional with over 25 years of related IT experience, recognized for strong leadership, technical ability, team building, process management, action-oriented, customer-focused, on-time delivery, team inspiration and interpersonal skills utilizing the latest industry practices and best-of-breed tool set with proven track record of on-time delivery.

PROFESSIONAL EXPERIENCE

• Led multiple teams from 3 – 6 individuals (Developers, Data Architects, Technical Leads and Administrators)

• 10+ years Information Developer Builder

• 5 years Data Architecture

• Led and delivered multiple projects ranging in revenue from $100K to $3M on time within allocated budget

• 8 years Manager: architecture, design, planning

• 2 years ETL and data integration experience

• 13+ years SSRS Reporting experience • Projects completed using iterative & Agile SDLCs

• 8 years Vendor Management • 2 years implementing cloud-based BI SKILL HIGHLIGHTS

• Leadership/Communication Skills

• Team Leadership

• Vendor Management

• Negotiation Skills

• Team Building

• Team Player

• Project Planning

• Time and Resource Optimization

• Staffing

• Budget Forecasting

• Budget Allocation

• Fast Learner

• Self-Motivated

• Customer-Oriented

MANAGEMENT EXPERIENCE

• Vendor - BI Reporting Team delivering rich content for Tax Practice.

• Interns – Training and delivering rich SSRS / Power BI content for Tax Practice.

• Reporting Team delivering rich content to medical end users.

• Development team creating event registration and backend database tool on VS.NET, SSL, MapPoint, and Outlook integration platforms.

• Led organizational change management effort to align personnel and skills into an existing organization.

• On-site project management, lead architect, database designer consultant for T-Rex. TECHNICAL SKILLS

Databases:

Microsoft SQL Server 2016, 2012, 2008 R2, 2000/2005, Microsoft Access Programming:

T-SQL, C#, VB.NET, ASP.NET, XML, Web Services, HTML/DHTML, JavaScript, IIS, SharePoint, Outlook Integration, Database Design, Development Database, Maintenance and Production, Database Tuning, Data Warehouse, Business Intelligence, and ETL’s.

Software:

Tableau, Microsoft Power BI, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Visual Studio 2017, Microsoft Office Professional Suite (2000, 2003, 2007, 2010, 2016), Visio, Microsoft Project, Postman, Fiddler 4, and other various commercial off the shelf software packages. Operating Systems:

Windows 2010 Enterprise, Windows 7.x/2003/2000/98/95. Kevin Johnston 7608 North Richland Blvd, North Richland Hills, TX 76180 Mobile: 817-***-**** email: ac8ryu@r.postjobfree.com WORK HISTORY

Senior Manager - BI Project Manager for PricewaterhouseCoopers (PwC) 12/2017 to Present Improving services for our customers by using advanced reporting techniques and onboarding compelling new data set in the tax industry. Assisted in development / reporting process resulting in $3 Million ROI. Essential Functions

• Evaluate, acquire, implement and maintain all of the data platforms technologies and tools to support the Business Intelligence Reporting and Analytics.

• Participate in business strategic planning and decision-making at the program level.

• Direct management activities and initiatives at the program level through supervision of Vendors and Professional Staff.

• Communicate frequently with Transformation leadership and execution teams.

• Interact with management and provide strategic recommendations in regards to BI Reporting and Analytics.

• Manage the development and implementation of integrated IT initiatives to support business strategies.

• Manage vendor relationships to maximize business value.

• Ensure quality of deliverables using development testing methods, code reviews and user acceptance testing.

• Allocate resources and direct the development and delivery of training for internal and external users to ensure productive use of existing and new systems.

• Propose and drive improvements to data architecture, tools, and processes that contribute to more efficient delivery.

• Provide guidance and support to developers and team members on Power BI / SSRS development, dashboard usability, user experience design and design best practices.

• Conduct code walkthroughs / peer code reviews to verify that code is scalable, easily maintainable and meets company programming conventions / standards.

Reporting Manager / Team Lead for Visualutions 1/2014 to 12/2017 Focused on Enterprise Reporting across major medical companies. Led training efforts and mentoring for the reporting team on new technology (SSRS/VisAnalytics/TFS/Visual Studio) which improved the teams’ skillset resulting in increased productivity of 60%. The throughput of the team significantly increased resulting in a record low reporting queue. Backlog was reduced from a 6 month waiting period to a 30 day waiting period. Completed medical software reporting packages such as UDS, PCMH and HEDIS which brought in new clients that contributed $100,000 in company revenue. Essential Functions

• Led a 3-person technical team to provide strategic, technology and reporting support to hundreds of healthcare providers.

• Responsible for aggregating data from multiple data sources using ETL solution.

• SME for SSRS Reporting solutions including translating business needs to technical requirements.

• Participated in development of Operational Data Warehouse establishing a common defined set of medical data and measures.

• Responsible for understanding business process and designing the ETL flow for medical EMR system.

• Generated monthly and quarterly reports for clinical measure, daily job monitoring dashboards for client applications using SSRS.

• Utilized T-SQL and advanced database skills to develop and manage client’s large volume of data.

• Led on-site, hands on training for dozens of healthcare providers teaching how to build SSRS reports.

• Responsible for gathering, analyzing & writing requirements which may be transformed into detailed workflows, diagrams, technical & functional that identify, resolve and support immediate business needs.

• Wrote documentation for best practices, lessons learned and release notes.

• Provided peer review and unit testing on reports

• Acted as back up to other Leads on projects.

• Maintained, strengthened and developed reporting processes, policies and procedures. Kevin Johnston 7608 North Richland Blvd, North Richland Hills, TX 76180 Mobile: 817-***-**** email: ac8ryu@r.postjobfree.com Senior Application Developer for Greenway Medical 11/2011 to 1/2014 Focused on Enterprise Reporting across major medical companies building and delivering the most innovative solutions and services available.

Senior Developer for CySolutions 7/2010 to 11/2011 Focused on Enterprise Reporting across major medical companies. Operations Manager for Microsoft 1/2008 to 7/2010

Focused on cross-group collaboration, customer and partner satisfaction, direct and relationship marketing. Managed vendors, agencies and budget. Primary customer liaison establishing priorities and deliverables for data migration and implementation. Worked targeting a custom development approach, implementing a standard project design through proposal, statement of work, and requirements phases, while maintaining strict code and database design patterns and standards. Realized measurable progress through project plans, year-to-date reports, and weekly status meetings with clients, which allowed customers to become an active part of the development process. Trained and implemented new processes, procedures, technology, and methodologies to team members.

Worked with sales account managers analyzing needs and opportunities. Led organizational change management team, adopted a new department into existing organization. Worked with external IT organizations enabling impact assessment and collaboration.

Senior Applications Developer for ICData Solutions, LLC 7/2004 to 7/2008 On-site consultant for Microsoft working on a project for 4 years and managed development of a production application system. Created project plans and schedules for development. Monitored and tracked application system development metrics. Coded, tested, and troubleshot programs. Conducted system test. Created and maintained system feeds via web services. Performed system tuning. Maintained SharePoint application development and security model.

Senior Applications Developer for eLevel, Inc. 1/2000 to 7/2004 On-site consultant for Microsoft working on a project for 2 years. Consulted on multiple web and client applications. Applications developer building customer facing web applications. Information Specialist for Alcon Laboratories, Inc. 1/1998 to 1/2000 Completed development of Diner, an application used by system administrators to produce ADHOC reports for Custom Pak Equipment. Developed maintenance incident tool to record bugs, issues and enhancement requests. Developed COM and DCOM objects for Intranet Development Team.

Programmer, Systems Analyst for NCH Corporation 1/1991 to 1/1998 Designed and developed a language translatable sales support system providing accounts receivable, order entry, salesman, product, and customer information to users globally. Conducted estimating, analyzing, design, coding, walk-through, testing, implementation and follow-up. Developed a timecard tracking system for user timecard interface to CYBORG.

Education:

Bachelor of Science, Computer Information Systems, DeVry 1997 MCSD - Microsoft Certified Solutions Developer

Nielsen Norman Group UX Certificate

Essential Design Principles for Tableau

Fundamentals of Visualization with Tableau

Epidemiology: The Basic Science of Public Health

Exam 463: Implementing a Data Warehouse with Microsoft SQL Server 2012 Microsoft: DAT207x Analyzing and Visualizing Data with Power BI

Contact this candidate