Jon Greising Email & Phone Number

Des Moines, Iowa, United States

West Des Moines, IA

• Designed process to validate tax liabilities of company's retail transactions. Used CCH Suretax tax engine to analyze existing transactions, and create exception report to identify discrepancies. First stage of.
• Gathered requirements and designed SSRS reports for Aureon HR client scorecard.
• Modeled circuit provision data from Oracle operational source into schema for SQL Server data warehouse. Produced ETL scripts to populate and update data.
• Analyzed customer datasets for implementation of Profisee master data product. Completed dataset integrated customer lists from seven major company systems and incorporated address standardization.

West Des Moines, IA

• Managed data migration and integration during implementation of Microsoft Ax to replace accounts payable system.
• Designed ETL package to extract data from MySQL staging layer to SQL Server reporting layer for cell tower SLA reporting. Designed schema for reporting layer.
• Created flexible report package for engineering team to track progress of cell tower and fiber builds, automating manual report compilation and delivery process.
• Created weekly tracking reports for sales team out of Microsoft CRM.

Booked speakers and planned programs for Des Moines chapter of Data Management Association

Des Moines, IA

• Member of Agile project team building interim database for processing agent payments.
• Developed dynamic file import processes.
• Designed dynamic reports for internal users and business partners.

Avivausa, West Des Moines, IA

• Created Access databases for compliance team at AvivaUSA, redesigned existing databases.
• Created supporting documentation.

Johnston, Iowa

Developed and revised data models for DB2 and Oracle data stores for Principal's health insurance division. Developed relational and dimensional models for data warehouse. Administered model repository and metadata resources.

Life and Health Compliance Department. Developed departmental databases and supporting Web documentation for the life and health compliance department. Trained staff in database usage. Led technical support efforts for 80-member department.

Piloted web-based documentation for central documentation department. Converted legal compliance guide for Group Health unit to standalone online resource, simplifying distribution and saving over $20,000 in annual printing and distribution costs.

Ba, English

Database Design