Ed Schaefer Email & Phone Number

Evanston, Il, Us

Evanston, Illinois, United States

Within Facilities - Information Technology, leads, instructs, directs, and checks the work of other software developers using full technical knowledge and thorough understanding of business application of the project. Provides technical supervision to an oversees the work of junior staff. Guides and advises stakeholders of best practices for implementing or enhancing systems. Work with management to design high-level system integrations involving in-house development or off-the-shelf products. Assess architectural impact of projects on overall system and make recommendations to manager.

Chicago, Illinois, United States

• Establishes, administers, and coordinates the university's institutional research activities, including collecting, analyzing, interpreting, and reporting information on the characteristics of the University for use in decision making.• Monitors the overall integrity of data, complying with state and federal requirements and taking appropriate steps to correct data discrepancies when needed.• Prepares state, federal, and university accountability reports according to documented requirements, ensuring accuracy and timeliness.• Represents the university at federal, state, and local level meetings, seminars, or conferences as appropriate and at professional organizations related to institutional research within the state, taking a leadership role where appropriate. • Represents the Office of Institutional Effectiveness on campus-wide committees. Provide leadership to the campus community in the area of institutional data analysis for resource decisions and strategic actions.• Conducts analytical studies in response to internal and external data requests and prepares statistical reports and research briefs.• Oversees, mentors, and evaluates direct reports• Creates data visualization standards and explores new analytical products to periodically raise those standards.• Develops and administers survey instruments for data analysis of current and emerging issues in the university to inform policy and decision-making.• Maintains a variety of formats for disseminating key performance data about the university through reports, dashboards, scorecards, and other methods as appropriate.• Coordinates developing systems specifications and reporting structures pursuant to the changing reporting requirements of state and federal government agencies• Serves as liaison from the university to various authorities at the federal, state, and local levels for data reporting, institutional research studies, or surveys• Supports the accreditation process.

Fort Collins, Colorado, United States

• Develops SQL code to create efficiencies in state/federal mandated reporting, data submissions that serve institutional initiatives, and serves as the senior SQL support for staff within the office writing both simple and complex SQL code to extract data for use in research projects that inform institutional decision-making• With limited supervision, applies database architecture and management principles to oversee data extracts to the IRPE Oracle database and to edit/create tables/variables as necessary• Oversees the maintenance and scheduling of the jobs to import data from the source systems into the IRPE databases• Employs knowledge of university policies, process, and reporting calendars to ensure data is appropriately and cleanly captured includes auditing data prior to when extracts are created

Skokie, Illinois, United States

• Work with clinical experts and business leaders to analyze data that will help drive decisions on patient centered interventions and NorthShore’s quality goals and performance• Work with IT and data warehouse experts to design and develop new summary tables and data marts in NorthShore’s Enterprise Data Warehouse, to support end-user business requirements• Lead analytics-based quality improvement projects that leverage data collected from NorthShore’s electronic medical record to measure and predict patient outcomes.• Communicate complex technology solutions and challenges in a language accessible to operational leaders across the clinical enterprise• Serve as a liaison between clinical experts and IT professionals to determine feasibility, timelines, and priorities of quality improvement and research• Gather business requirements by conducting meetings/interviews, and facilitating large group/cross-functional sessions with customers, while containing the scope of the initiative• Produce datasets, visualizations, and reports that will facilitate evidence-based clinical and financial decisions

Chicago, Illinois

• Introduce, promote and cultivate a culture of analytics to drive and support strategic planning, data driven decisions making and business process improvements across the university. • Co-found and co-chair University Analytics Group to build partnerships across the university, promote culture of analytics and identify information needs and project opportunities• Work with Executive Director of IRA to establish Enrollment Forecasting Committee which taps mathematic and statistical experience in IRA to derive more reliable models of future university enrollment• Oversee procurement and rollout of Tableau Online• Establish stronger and more responsive data governance at the university by building partnership between institutional research and multiple functional areas• Automated Institutional Research & Assessment's census process including point-in-time captures and pre- and post-census validation• Migrate IRA staff from using multiple and inconsistent SPSS data files to a comprehensive relational database for both yearly, standardized reports and ad hoc requests• Business analyst and project manager to understand and document users' needs and related business processes, define project scope and deliverables and provide user training and support on deliverables• Develop suite of reports and dashboards for Provost/college dean's/department chairs and coordinators including course registrations and gross tuition, active and not enrolled students and program registration trends• Research data mining principles and techniques in regard to student success and retention; promote predictive analytics for student success, retention and enrollment forecasting• Develop enhancements to Ellucian Banner Operational Data Store (ODS) within Oracle including tables, views, stored procedures, functions and scheduled jobs• Serve on Budget Task Force, Strategic Planning and Presidential Transition committees

Evanston, Il

As Data Architect, project lead on building customized business intelligence solution for a consortium of community health centers. Duties included:• Business analyst to understand and document business needs, processes and definitions• Design star-schema for data warehouse including type-1 and type-2 slowly changing dimensions and fact tables• Develop extract-transform-load (ETL) processes using SQL Server and SSIS• Develop dimensional data cubes using SSAS and SSIS• Supervise 2 business intelligence developers using PowerBIAs Data Warehouse Specialist, design, develop, and deploy data marts with occasional report development. Duties included:• Data profiling and quality functions, dimensional modeling, ETL development (Cognos Data Manager), and metadata management• Business analyst role including interviews and information gathering sessions to elicit and assess needs, project planning and presentation of design options/prototypes, training, and follow-up/troubleshooting/retrospectives; conducted initial data quality and validation of source systems• Develop reports using Cognos Report Studio

Chicago, Il

Implement first data warehouse and build suite of advanced analytics to promote business intelligence within the university. Duties included:• Lead developer of interactive dashboards for operational and analytical/strategic needs using Information Builders WebFOCUS, InfoAssist, and Visual Discovery• Part of Data Warehouse team assigned to work with consultant to build new data warehouse (DW) at Loyola• Oversee and guide junior analysts in their projects and overall development• Business analyst to document university business practices and needs, set project goals, and develop project plan• Develop data model and ETL code to support dashboard front-ends using Cognos Data Manager

Chicago, Il

As Team Leader, oversaw information systems unit of Institutional Research and Market Analytics (IRMA) which included 4 FT direct reports and 2-3 student workers. Duties included:• Provide support and guidance on current projects working to create realistic goals and timeframes in order to meet objectives• Mentor staff and provide professional development opportunities in order to promote individual professional growth• Work with Director on defining overall department goals as related to the division and the university and develop short and long-term plans to meet these goals As Senior Applications Developer, develop, enhance and support a variety of information systems that support strategic planning, improve business processes and provide information to support decision making across the university. Duties included:• Project manager and design, develop, and deploy inter-departmental data warehouse using Informatica and Oracle• Business analyst performing user interviews, reviewing existing systems and reports, maintaining project timeline, data dictionary, and other project documents, and create training materials and provide end user training• Develop interactive dashboard to highlight findings using Tableau• Team member on research into non-cognitive variables in undergraduate admissions• Project manager for a variety of business intelligence and knowledge management systems using Microsoft SQL Server, SSIS, Access, Excel and SharePoint, Tableau, ASP.NET, HTML, JavaScript, and CSS• Member for Pay Equity Committee for Faculty and Staff which examined compensation patterns by gender and ethnic breakouts to achieve compensation equality

Chicago, Il

As Assistant Director, managed information systems and technology projects to automate data capture and reporting and develop websites for static and interactive content and surveying. Was Interim Director for a one year period with full budget and staff management responsibilities.• Design, develop, and deploy numerous applications that streamline data gathering and reporting procedures using Microsoft SQL Server, SSIS, and Access and FOCUS• Business analyst for data warehouse/business intelligence/knowledge management projects including user interviews, reviewing existing systems and reports and maintaining project timeline, data dictionary, and other project documents• Web site developer and administrator using HTML, CSS, JavaScript, and ASP. Projects include web surveys, departmental website, online course evaluations, and online placement exams• Responsible for reporting internal administrative and academic areas and external guidebook publications, professional societies, and other miscellaneous groups.• Supervise a team of part-time programmers

Ms, Information Systems

Bs, Psychology