**** ******* **** **.

Howell, MI *****

Jeremy R. Yager

Cell: 419-***-****

ac0qls@r.postjobfree.com

PROFESSIONAL PROFILE

Highly organized, “take charge” professional experienced in developing custom/Ad Hoc reports, relational database design, website development/maintenance, network communications support and troubleshooting with proven ability to coordinate people, systems and processes towards innovative solutions. Detail-oriented with strong problem-solving and interpersonal skills, talented in doing the job right the first time in managing complex, technical and comprehensive projects. Articulate and effective team player; builds synergy and rapport with individuals of all levels and backgrounds.

EDUCATION

THE UNIVERSITY OF TOLEDO, Toledo, OH

Master of Business Administration: Dual specialization in Human Resource Management and Marketing Management, Graduated December 2009 magna cum laude

Bachelor of Business Administration: Information Systems, Graduated May 2008

CORE TECHNICAL COMPETENCIES

Web Appl. Dev:

Client – CSS, Flash, HTML/XHTML, JavaScript, RSS/XML Server – ASP, ASP.NET, Java, .NET

Networks:

LAN/WAN support in a Cisco network environment including hubs, routers, switches and Wi-Fi

Databases:

SQL Platforms, Oracle SQL/iSQL Plus, MySQL, PL/SQL, SCT/SunGard Banner, PeopleAdmin, PeopleSoft, Microsoft Access Servers: MSSQL 2008, MSSQL 2014

Applications:

Global Shop Solutions (GSS), Epic OpTime (MiChart), GE Centricity Perioperative Manager (CPM), Business Objects Integration (SAP Crystal Reports), Microsoft Dynamics GP (Great Plains) – ERP, MSSQL, SQL Server Management Studio (SSMS), OrgPublisher

Software:

Training:

Epicor iVantage – HRMS, ADP, Lotus Notes, Microsoft Project, Microsoft Office Suite, Microsoft Visual Studio, Microsoft .NET Framework, ADO.NET, Microsoft Publisher, SAP CRM, Serena Collage – Website Content Management System (CMS) and Adobe Creative Suite 5 (CS5)

Epic Cogito Clarity, EPICOR (formerly SPECTRUM) SOFTWARE CORPORATION – iVantage 5.x HRMS Course Training, Denver, CO, iVantage 5.x; iVantage 5.x Administrator; iVantage 5.x Crystal Reporting

PROFESSIONAL EXPERIENCE

THE RYBAR GROUP, INC. Fenton, MI 2016 - 2016

Interim Database Analyst

Developed and maintained skills and knowledge relating to software (Access, Excel, Visual Basic, and SQL Server).

Participated in business and technical requirement gathering and analysis (including extracting, transforming, and loading data).

Converted client data from various formats (Excel, ASCII and/or text delimiter, etc.) to import into company systems, via Scripting and execution of various queries.

Provided technical guidance to management and other team members and supported consultant team with data scrubbing and manipulation.

Extracted data from Medicare HCRIS files with the intent to use them as performance benchmarks for Critical Access Hospitals and Medicare Dependent/ Sole Community Hospitals.

Performed data mining and statistical analysis on large datasets through MSSQL 2008 Server, MSSQL 2014 Server, MS Access database, and Excel macros through VBA for: Medicare Dependent/Sole Community Hospital Volume Payment Decline Analysis, Critical Access Hospital Reimbursement Review, Charge Master and Cost Report Review, Reimbursement Claims Review and BCBSM Payment Validation Review.

Backup for IT Managers responsibilities.

VENTURA AEROSPACE, LLC. Wixom, MI 2015 - 2016

Information Technology (IT) Manager

Responsible for installing and maintaining computer hardware, software and network operating systems.

Responsible for overseeing information technology projects.

Coordinated project phases from development to installation.

Acted as liaison between end user, vendors and consultants.

Maintained organization’s effectiveness and efficiency by defining, delivering and supporting strategic plans for implemented technologies.

Acted in alignment with user needs and system functionality to contribute to organizational goals and policy.

Managed information technology and computer systems.

Planned, organized, directed and evaluated the operations of information systems and electronic data processing.

THE UNIVERSITY OF MICHIGAN HEALTH SYSTEM, Ann Arbor, MI 2012 - 2015

Applications Systems Analyst/Programmer Sr. UMH Operating Rooms Informatics Department

Developed, documented, and supported numerous standardized and/or customized reports utilizing Crystal Reports, SQL queries and Excel spreadsheets for both Oracle and MSSQL databases.

Developed ad hoc reports/queries as requested, utilizing SQL statements/queries and Business Objects/Crystal Enterprise, i.e. Crystal Reports 8, 9, 10, 11 and 13.

Designed, wrote, and tested complex Crystal Reports for clients using SQL Database, customized views and stored procedures.

Developed and documented report specifications to ensure strong rapport with clients/end users/clinical leads to understand business/hospital requirements in order to facilitate his or her related needs.

Provided onsite reporting and interface training as needed/scheduled within internal and external locations.

Maintained Crystal Reports library and custom Crystal Reports for CPM Resource Catalog, O.R. Scheduler/O.R. Manager, Sterile Processing Management (SPM) and Epic/MiChart.

Assisted with and/or created SPM reports that are used throughout the health system by several end users.

Assisted with and/or implemented SPM reporting for instrument scanning/tracking systems.

Assisted with and/or created Supply Chain financial reporting for the entire hospital network.

Worked on multiple, complex projects simultaneously and provided business analysis and requirement definitions to senior management.

THE ANDERSONS INC. Maumee, OH 2011 - 2012

HRMS Analyst Human Resources Department

Developed and maintained a thorough understanding of the core Human Resource Management System (HRMS) from table and data structures for Compensation, Benefits, Training, and Employment to data-mining software and reporting tools.

Monitored, reviewed and coordinated the daily flow of Retail/Non Retail processing data-entry, reverse interfaces and end-user support.

Created, developed or supported miscellaneous Access databases, custom /Ad Hoc data reports, Organizational Chart Publications and Open Enrollment data-entry.

Coordinated and analyzed weekly/monthly Fidelity/401k and Preventure feeds.

Supported and maintained payroll services, time & attendance, and talent management solutions by utilizing ADP's Enterprise eTIME HRMS Management Service.

Developed and modified Internet (iConnect web portal) and Intranet (andeConnect) content management and Open Enrollment collaboration systems.

THE UNIVERSITY OF TOLEDO, Toledo, OH 2006 - 2011

HRIS Analyst Human Resources Dept., Labor & Employee Relations 2010 - 2011

Served as a liaison between HR and IT Departments to provide systems support, analysis and technical expertise to develop and implement technology-related projects and meet the needs of HR and users of HRIS systems.

Identified, tracked, monitored and communicated on project-related issues, scope changes, variances and contingencies that occurred during the course of projects.

Created test scenarios and assisted project team members in performing tests to insure all processes worked according to predetermined goals.

Created complex queries to provide program statistics for management and arranged data in spreadsheets to perform calculations; find percentages and interpret overview of findings.

Prepared and submitted the monthly Staff Information and Board of Trustees Reports.

Virtual Laboratory Manager Information Technology, College of Business 2008 - 2009

Supervised 14 student employees and helped to identify individual strengths and weaknesses; assessed and rated student employee performance and competency in IT development recommending areas for improvement.

Collaborated with UT HR/Payroll, Graduate School, Office of International Student Services, to prepare and process hiring paperwork that includes the following: Student Employment Personnel Action (SEPA) Form; Federal and State Tax Forms; I-9 Form; Ohio Public Employee Retirement System (OPERS) form; SSA 1945, and DMA.

Internship Information Technology, College of Business, Computing Dept. 2006 – 2008

Researched, developed and implemented Internet and Intranet content management and collaboration systems along with coordinating content across various departments for Polycom video conferencing and CD/DVD-ROMs.

Provided COBI with expert guidance on current and future technology; actively participated in the development of websites and relational databases for easier access to data for students, faculty and staff.

Assumed a leadership role for the setup and maintenance of approximately twenty Microsoft Dynamics GP servers.

Assisted faculty and staff in the research, development, and deployment of new technology to be integrated into their curriculum along with editing video and sound files for use in their multimedia projects and presentations.

MILITARY SERVICE

UNITED STATES MARINE CORPS

Defense Messaging System NCO

Instrumental in the successful installation of a configured and maintained multi-building network which included NT servers, Windows Internet Naming Service (WINS), Domain Name Service (DNS), Dynamic Host Configuration Protocol (DHCP) servers and Remote Access Servers (RAS).

Researched, developed and implemented both low and high-speed data network connectivity via satellite communications network to provide deployed forces Internet access, live chat and file transfer capabilities.

Extensive experience with Primary Domain Controllers (PDC) which created and managed Domain users and user groups as well as associated resource permissions.

Managed a Backup Domain Controller (BDC) to facilitate domain control rollover in the event that the (PDC) becomes unavailable.

Monitored e-mail and Internet usage of network users to ensure compliance within usage directories.

Contact this candidate