*Developed and maintained an understanding of Business Intelligence technology and architecture, including data warehousing, dimensional modeling, OLAP functionality, reporting tools, and other methods of information delivery.*Analyzed and documented user needs to ensure accurate fulfillment of user story requests from internal business customers.*Developed full set of standard and custom reports, using the SSRS reporting tool.*Mentored teammates on BI and on reporting tools and methods.*Worked directly with customers to familiarize them with new product features and answer questions.*Wrote scripts and recorded video tutorials to introduce customers to new reporting features.*Resolved production issues and communicated results to internal Customer Success teammates.*Conducted and facilitated internal testing and user acceptance testing.*Constructed data models, data dictionaries, and report glossaries.

--Report Lead for major Campus-wide Administrative Systems o Advise/Support junior programmer on basic report creation, location of data, requirements, collection of information, etc o Analyze data needs and use standard reporting/data extraction tools to create complex reports and automated communication.--SQL Database Chief Support. o Understand structure of the underlying tables. o Design and maintain views and data warehouse/data mart solutions, which incorporate data models, back and front-end extraction processes, data transformation, and load processing. o Develops and runs scripts to modify data from the back-end. o Perform ad-hoc data investigation and analysis to address inquiries and monitor data quality. o Monitors processes on a regular basis and adds/removes/amends processes when necessary.--Integration of Campus-wide Administrative Systems. o Analyze, define, and document requirements for interfaces with other systems, internal and external checks and controls, and outputs. o Develop scripts to support new and modified data sources. o Design, create, populate, and integrate with legacy systems; report and extract data for a data warehouse system. --Collect/Develop specifications for large projects o Consult with project leaders and end users to analyze requirements and develop additional functionality to current administrative systems.--System Upgrades o Help CAS Group with System upgrades--Business Intelligence Developer o Responsible for interfacing with business users to gather requirements, database design and development, ETL design and development, BI solution design and development, testing, and solution implementation and maintenance utilizing SSAS, SSIS, and SSRS