Michael Stegeman Email & Phone Number

Chicago, Illinois, United States

Using Sequel to write reports and data processes for Accounting. Converting legacy reports into Sequel. Extracting data from IBM i and SQL Server into Excel. Performing accounting duties as needed. Acting as an overall technical resource for the accounting department.

Schaumburg, Il

Worked with prospective clients to determine best use cases for Sequel and Showcase (Business Intelligence) in their business and system environments. Responsible for product demos, trial installations, getting started sessions, and proof of concepts to meet business requirements. Same for other products: Esend, Abstract, Anydate. Assisted with Sequel Data Warehouse (formerly Rodin). Business requirements often included integrating data from different databases and statistical analysis from relational database tables.Assisted in creating KPI dashboards, SQL definitions, and data gathering and transfer processes for large companies such as Skechers, Ralph Lauren, Republic Beverage, and more. And smaller companies such as Enstrom Helicopters, Cobalt Boats, Tony’d Fine Foods, and more.• Facilitated online sessions to get clients started with software as liaison to full support• Assisted clients with design and implementation of dashboards and reports• Worked with IT, departmental experts and c-level executives• Help clients connect to MS SQL Server, Oracle databases and Excel spreadsheets• Worked closely with Sales and Marketing to write and conduct online webinars. Wrote articles and marketing documents, attended vendor and industry conferences as a speaker• Developed and updated product demo process flow• Recorded and edited for marketing and internal product demo presentations• Spoke at Common (IBM i system) as subject matter expert helping company maintain industry presence• Worked with company partners on presentation and product training to their clients• Collaborated with partner and Help Systems development to design, test and document a PC to IBM i interface for Anydate product• Working knowledge of competing BI products: QlikView, Db2 Web Query, Tableau

Schaumburg, Illinois, United States

As a Technical Consultant, I supported clients via phone, email, and chat. I taught product education classes in-person to clients. Tested new versions of software working with development to find and fix software issues.• Also Level 3 (Research Technical Consultant) support for complex client issues and bug verification• Expanded product test script from 3 pages to over 40 to cover all areas and conducting testing• Maintained +95% satisfaction with client contact surveys (support and training)• Consulting with client to create reports and recommend best practices

Melrose Park, Illinois, United States

Manage and support IBM i system and all village PCs. Worked on Water Billing system to clean up existing data (with SQL) and generate water bills. Saved the village hundred of thousands of dollars in lost revenue. Added and supported a RF water meter reading system

Elk Grove Village, Illinois, United States

Managed and supported IBM i and all company PCs. Migrate company data from old ADP system to IBM i and Software2000. Train staff on new software. Reduce accounting month-end from 3 months to 2 weeks. Helped establish company presence on web.

Chicago, Illinois, United States

Managed BPCS ERP Support Financial Team. Also worked with BPCS Technical team covering installs and upgrades.