Ronald Iwanski Email & Phone Number

Schaumburg, Il, Us

Chicago, Illinois, Us

Us

• Serve as chief strategist and direct management of donor data and systems including planning, data analysis/reporting, quality control, research, internal and external stakeholder customer service and oversight of back-end development operations. • Create and implement data strategy including setting policies and practices for data collection, use and storage including setting project timelines and goals, policy recommendations and internal review process and implementation phase.• Oversight and direction of the Ellucian Advance database and supervision of staff and vendors administering the database to ensure that the database is complete and accurate and that data imports, uploads, queries, reports and extracts are performed according to established norms and protocols.• Serve as local leader and strategist for conversion from Ellucian Advance and legacy systems to Trinity Health’s enterprise BlackBaud CRM, BlackBaud BBIS and Luminate TeamRaiser including legacy data preparation, test run verifications, process and reporting development, as well as staff training and implementation planning.• Development of data systems, research and wealth screening for implementation of grateful patient fundraising process including extracts from Epic electronic medical records, screening through Target Analytics and WealthEngine, and report production for gift officers and physician referrers.• Support the development, implementation and execution of Lean Six Sigma stage gate donor development process through the integration of prospect management and donor interaction reporting into data systems and developing dashboard and portfolio reports.

Chicago, Illinois, Us

• Lead a team of programmers and web application analysts to serve the Loyola University Chicago Advancement Office and the Loyola University Health System Office of Development through a shared services contract. • Lead in the development of system tools and utilities to expand information available for all programs related to the fundraising operations including Oracle and donor CRM. • Designed and maintain patient screening database to assist with specialized health system fundraising initiatives• Lead integration of Lawson and Epic data into health system database• Ensure accurate coding, reporting and data integrity across all systems. • Information Builders Dashboard and Report Conversions.• Project Lead on upgrade from Convio to iModules Encompass web content management system.• Ellucian Client (AWA Web Leap Upgrade – Oct, 2013)• Support and Maintain Custom Microsoft Access Expense / Receipt Advancement Applications.• Assist with Advancement Data Warehouse table set-up for PMR and Alumni Relations. • Foster close working relationships between staff with both organizations to maintain shared database systems. Defined and separated central database model when two organizations split but maintained shared staffing.• Design and execute PL/SQL queries, exports and reports with multiple database software tools.

Us

Supervise, evaluate, and set goals for 4 Loyola University Chicago AIS Technical Staff. Work with them to ensure accurate coding, reporting, and data integrity across all Advancement Information Systems. Foster close working relationships between Loyola Medical Center Development Staff and Loyola University Advancement Staff to assist in maintaining shared database systems. Design and execute PL/SQL queries, exports and reports with multiple database software tools. Act as liaison for LUC Advancement, as a member of Information Security Advisory Council. Demonstrate Strong commitment and accountability for projects while looking for more effective and efficient ways of streamlining planning and implementation. Lead in the development of system tools and utilities to expand information available for all programs related to the fundraising operations. Provide LUMC Software support for Oracle and Advance applications. Assist with Departmental Fundraising Events and Activities.

Us

Assisted project team on migrating to SunGard Advance version 6.5 with upgrade to 8.2 from PeopleSoft - Designed, implemented and defined patient rolling solicitations to Pin (profile Builder) Screening software - Upgraded Solicitation profiles to Kinteria Sphere Web Environment – Defined and upgraded Patient database processes through Epic Patient Registration upgrade. Defined and developed reporting overview for 300 Million Dollar Hospital Campaign. Assist with Departmental Fundraising Events and Activities – Supported formation of new AIS (Advancement Information Services) team Structure to assist in shared service issues – Define, implement, and conform existing database coding in decentralized environment to support LUMC - Maintained Departmental Alumni Website.

Us

Assisted and maintained 2 Departmental Websites. Used SunGard BSR Advance, PL/SQL tools, and Crystal Reports to report, present, and query all requested data from Oracle 8i Database for Associated Vice President of Development - Developed and implemented a new Patient Database System - Developed and implemented new client database patient software for staff - Assisted in Departmental Strategic Planning and HIPAA compliance issues. Assist in departmental conversion to PeopleSoft Contributor Relations Software in 2004. Implemented prospect screening systems. Assist with Departmental Fundraising Events and Activities. Provide LUMC Software support for Oracle and Advance applications. Acted as computer application liaison and assisted in staff computer training.

Us

Supported new formation of the Office of Medical Center Development - Updated and maintained Departmental Websites (SSOM Alumni) - Utilized SunGard BSR Advance and PL/SQL tools to report, present, and query requested data from Oracle /Access Database for Development staff. - Maintained and organized On-line Newsletter using GroupWise 5.5 - Developed PowerBuilder 6.5 application for clients to query patient demographics. Acted as computer application liaison and assisted in staff computer training. Developed online web based data request tracking form system. Assist with Departmental Fundraising Events and Activities. Provide LUMC Software support for Oracle and Advance.

Us

Performed outpatient orthopedic rehabilitation daily in Clinic - Assisted with marketing and outreach programs - Performed elected leadership positions, which include outpatient physical therapy team leader, fire safety coordinator, infection control coordinator, United Way department contact, CPR instructor and department computer application liaison - Developed a Visual Basic 6 software system to assist in Functional Capacity Evaluations, along with Lymphedema circumferential volumetric circumferential measurement calculations - Contracted and served as Head Athletic Trainer for: Romeoville High School, Hillcrest High School, and Timothy Christian High School.

Master Of Science (M.S.), Exercise Physiology With Emphasis On Cardiac Rehabilitation

Bachelor Of Science (Bs), Information Technology

Introduction To Java Programming

Bachelor Of Science (Bs), Health And Physical Education/Fitness

3 Trimesters – Night School, Digital Electronics And Circuit Design