David Lyons is a highly skilled and experienced techno-functional consultant who specializes in bridging the gap between people and technology. With a focus on implementing database solutions that enable users to leverage data, David has earned a reputation for excellence in his field. His technical expertise includes Microsoft SQL Server, with experience working with various facets of the platform, including the database engine, Integration Services, Analysis Services, and Reporting Services.

David also has a strong background in database administration and is well-versed in areas such as maintenance, monitoring, performance tuning, security, and documentation strategies. Additionally, he has experience with data warehousing, using Kimball methodologies, as well as multidimensional and tabular modeling using the Microsoft stack. He also boasts exceptional skills in T-SQL query writing, MDX query writing, and DAX query writing, as well as experience with PowerShell and PowerShell scripting, and working with Azure and cloud platforms.

In terms of functional knowledge, David has worked with various ERP platforms such as MS Dynamics NAV/GP/AX, gathering user requirements and developing data warehouse and BI solutions. He also has experience with gathering functional requirements and translating them into technical specifications. David has a strong leadership track record, having led small functional and technical teams in developing data warehouse and BI solutions. Additionally, he has experience teaching classes and demoing technologies.

David holds a Bachelor's degree in Business Administration with a focus on Management Information Systems, Information Technology, and Business Administration from Washington State University. Currently, David is based in the United States, where he works as a Business Intelligence Professional Services Manager at insightsoftware. Prior to this, he has held various roles such as Business Intelligence Consultant at Jet Reports, Technical and Support Specialist at agiles North America, ERP Analyst Intern at Eclipse Consulting, Inc., Systems Analyst at Dublin Downs Irish Pub, Team Lead at Columbia River Quilting & Design, and Manager at Regal Entertainment Group.

Overall, David Lyons is a highly skilled and accomplished techno-functional consultant with extensive experience in various facets of Microsoft SQL Server, data warehousing, BI solutions, and ERP platforms. His strong leadership and problem-solving skills, combined with his exceptional technical and functional knowledge, make him an invaluable asset to any team.