Michael Leonard Email & Phone Number

My strong aptitude for technology has served me well in my professional career. I am goal driven and eager to learn material that will provide a clear benefit. I have done extensive data analysis for improving efficiency, productivity, budgeting, and for decision support. I have interfaced across all departments and all levels to meet their reporting and data management needs.My most recent position involved: -Maintaining an enterprise management system (Aderant Expert) -Writing SQL Stored procedures for a wide range of application including setting internal performance targets, tracking employee time-off, and evaluating attribution payments to external consultants. -Developed and expansive library of SSRS reports. -set up data flows between internal systems -Managed data feeds between our system and vendors -Automated processes using VB and proprietary scripting languages native to Aderant Expert along with jobs run on MS SQL Server. -An absolutely massive number of ad-hoc SQL data pulls from our systems dropped into MS Excel formatted to a highly polished standard and sent off to senior staff. -Mentored junior staff members on data analysis skills to build department’s capacity to meet there goals. I have done extensive development in MS Access and Excel using VBA for data handling and application automation. I am strongly proficient in MS Excel, having made use of, macros, lookups, pivot tables, and charts. I am proficient in Power Query and Power BI.

Listed skills include Vba, Access, Microsoft Sql Server, Data Analysis, and 7 others.

• 

  University Of California, Davis

  Bs