John Lyda Email & Phone Number

Billings, Mt, Us

• Designed and developed a suite of SSAS cubes using Kimball style star schema to provide detailed reporting information for a wide variety of customers with different needs to help them better understand their businesses.• Developed and enhanced over 120 complex SSRS reports for use in many different business areas to provide detailed analysis of critical business processes and help identify potential areas for improvement.• Researched, designed and optimized all database objects (Tables, Views, Functions, Stored Procedures) used in cube processing and reporting arenas.• Collaborated with developers and architects to enhance supportability and identify performance bottlenecks with existing database objects and improve them.• Created reports in Power BI using SQL and SSAS data sources to address ad hoc client requests.• Designed and implemented ETL processes to populate data warehouse for use in reporting and production environments.

Billings, Mt, Us

• Automated business critical extracts to external vendors while increasing the success rate from 12% to 99% and reducing manual interaction from 40 hours per week to 1.• Converted existing reporting from MS Access using ODBC to SSRS using a Data Warehouse. • Automated the report creation and reduced the processing time from 2 weeks to 3.5 hours.• Worked with vendors to create new data feeds based on varied file types and specifications using batch files created programmatically. • Integrated an internal audit using a SQL database to distribute reports to required recipients as desired.