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.

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.
• 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.
• 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.

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.
• 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

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

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:

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.
• 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

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.
• 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.
• 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