John Riesenberg Email & Phone Number

Cincinnati Area, Ky

Responsible for enhancements and fixes to company’s patient management software product- Programmed enhancements using Visual Basic and SQL Server.- Collaborated with business analysts on coding specifications.- Worked with customers resolving issues and meeting/setting expectations.

- Developed a customer equity model that calculated the profitability of 16+ million customers with over 4 billion transactions using Oracle PL/SQL. - Developed a VB program allowing a gas retailer produce charts depicting segments for credit card type and loyalty membership performance over several years. Program’s easy to use GUI allowed users to select various customer segments and produce pivot chart trends of the selected segments.- Developed migration models for tracking customer migration between client gasoline retail stores. Model compared customer behavior for buying gasoline in two distinct periods to evaluate the viability of new pricing strategies in major metropolitan markets. Calculations performed in Oracle PL/SQL with results viewed in cube files.- Created Java regression models for our proprietary Java Data Mining API as a framework for extending our proprietary data warehouse product’s functionality.- Developed modeling programs and ad hoc reports using SAS.

Responsible for generating new enhancements to a critical document management system that benefits Fidelity’s Emerging Corporate Markets business unit. Gathered requirements; coordinated communications between clients, management, and team. Performed release management for enhancements. Major accomplishment: - Analyzed, built and coordinated enhancements for a Visual C++ application that merges 401k plan information stored in a SQL Server database into MS Word and Adobe Acrobat documents. System is tightly integrated with company’s mainframe, CRM, web and external vendor systems.- Coordinated 5 release cycles.

Created and managed Data Warehouse and Data Mart projects for Risk Management and Energy Trading- Developed techniques to quickly manipulate large data sets using VB, SQL, Oracle and SQL Sever.- Created several Data Warehouse and Data Mart projects.- Developed a system to reduce the risk of losing millions of dollars in trading losses.- Saved company $100k in new software and hardware costs by utilizing existing equipment.- Dramatically reduced statistical analysis calculation time increasing the efficiency of decision support.- Pioneered creative solution for quick identification of potential trading loses.- Managed 120 GB database of energy trades, energy prices, historical weather, and energy usage.- Acted as development DBA and architect for Data Warehouse and Data Mart projects.- Collaborated with business analysts and managers to develop innovative solutions to meet objectives.- Recognized by company as a model mentor for developing employees.

Ma, Psychology

Bs, Computer Science

Ba, Mathematics