Robert Kramer Email & Phone Number

Grove City, Oh

Investigate, plan, design, develop, troubleshoot, and support district business intelligence (BI) applications, reports, dashboard visualizations, and associated systemsSupporting all district ERP systems (e.g. Personnel, Payroll, Accounting, etc.)Interpret data, analyze results using statistical techniques and provide ongoing reports, data visualizations, and dashboardsAcquire data from primary or secondary data sources and maintain databases/data systemsIdentify, analyze, and interpret trends or patterns in complex data setsWork with district leadership and departments to prioritize business and information needsLocate and define new process improvement opportunitiesAdminister/manage all district GIS-related data and systems (e.g. county/district address information, attendance areas/boundaries)Develop and implement required customized scripts, queries, reports, processes, applications, etc. as required to meet the needs of district usersAssist with design, selection, installation, and management of future application systemsAssist with setting the future technical direction/vision for the South-Western City School DistrictProvide application system training to district staffMaintain expertise on current application system and database management technologies

Grove City, Oh

Developing Tableau dashboards for purposes of data analyticsAuthoring SQL scripts, queries, and views utilizing Microsoft SQL ServerAdministration of Infinite Campus - Student Information System (SIS)Designing Crystal ReportsAdministration of suite of Frontline Education products including Absence Management (formerly Aesop), Professional Growth (formerly PLM), Frontline Central, and Recruiting & Hiring (formerly Applitrack)Managing district addressing and school boundaries for 30+ schoolsProgrammatic processes for district use of Ohio's Uniform Staff Payroll SystemAssisting with Data Center Operations and EMIS reporting

Grove City, Oh

Coordinating day-to-day and cyclical Infinite Campus (SIS) setup, operations, and supportDesigning student and employee data visualizations and reports utilizing Crystal Reports and TableauDevelopment of queries and scripts utilizing Microsoft SQL ServerCreating reports within Infinite Campus such as ad hoc filters, report cards, interims, schedules, and transcriptsResponsible for recent projects including Ohio Graduation Points tracking and IS/ES Report Card redesignHighly engaged on team establishing a “Personnel Import Tool” to sync biographical data and User rights from our personnel database to Infinite CampusCreating processes and procedures to ensure accurate data entry district-wide and within Data Center operationsProviding an effective point of communication between the Data Center and school buildingsCoordinating the student information support team, including the IC Help Desk and IC EmailProviding technology training for new district/school administrators and front office staffAssisting EMIS Coordinator with school process issues, ESC reporting issues, and as neededSelecting, deploying, setting up, and maintaining Remark Office OMR district-wideAssisting in conversion from eSIS to Infinite Campus focusing on User rights and User GroupsRepresentative on the district Insurance Committee

Obetz, Oh

Worked to establish new and modernized council committeesDeveloped numerous Tableau dashboards to improve shift scheduling for Police Department, Parks and Recreation Department cost center analysis, and various fund line examinationsServing as Chairperson of the Intergovernmental Outreach Committee

Obetz, Oh

Columbus, Oh

Columbus, Oh

Obetz, Oh

Groveport, Oh (Subsequently Obetz, Oh)

Developing, building, qualifying, and producing custom computer systemsDeveloping tests to assist in validating board designs and to provide manufacturing supportDeveloping assembly and test procedures to ensure the quality of systems and components such as motherboards, hard drives, memory, and processorsSupporting production, repair, sales, and marketing through product life cycleDeveloping scripts for use in ease of testing in manufacturing and repairWorking with various technologies including Telco Servers, ATCA, AMC, COM Express, XMC, PMC, and cPCIAuthoring technical documentation such as user manuals, manufacturing procedures, engineering specification sheets, and validation proceduresUtilizing enterprise resource planning (ERP) and document control systemsProviding hardware, firmware, OS (Windows, Linux, Solaris, and DOS), driver, application, troubleshooting, and networking support to operationsDeveloping processes for conformal coating and ruggedization of PCBsSignificant involvement in coordination of product certifications effortsDepartment leader in company-wide Five S Lean Manufacturing Initiative

Toledo, Oh

Lock and secure campus buildings and facilities at nightAssist stranded motorists on campus with battery jumps, tire changes, and escortsSafeguard parking lots for special events and student groups

Kettering, Oh

Program testing and validationTranslating legacy military assembly languages into modern PowerPC assembly codeUnix Shell Script programmingMaintaining project code documentation