Matthew Kempe Email & Phone Number

Charlotte, Nc, Us

- Worked with DBA to build new reporting database. -- Performed analysis on what data is used in current reports -- Wrote SQL to create tables for new database -- Wrote SQL to populate static tables or to be used in nightly feed ETL processes to populate active tables.- Assisted BI Team in reporting conversion from Cognos to Power BI.- Wrote stored procedures to be used as part of frequently performed database updates or to partially automate manual data load process.- Work with departments to clarify reporting needs; identify current reports to address needs or work up specifications for new reports.- Recommend solutions based on data analysis to increase business efficiency, improve existing processes, and/or correct data issues.- Provide ongoing support and administration for existing deployments, including hot fixes in production environment and monitoring of audit reports.

Charlotte, Nc, Us

(Innovatix was fully bought by Premier)

New York, Ny, Us

- Worked with DBA to build new reporting database. -- Performed analysis on what data is used in current reports -- Wrote SQL to create tables for new database -- Wrote SQL to populate static tables or to be used in nightly feeds to populate active tables.- Create Cognos reports using Cognos framework, custom SQL or combination, as needed for business needs.- Design, build, and test IBM Cognos framework models and reports in conformance with the planning processes and report specifications. - Wrote stored procedures to be used as part of frequently performed database updates or to partially automate manual data load process.- Work with departments to clarify reporting needs; identify current reports to address needs or work up specifications for new reports.- Recommend solutions based on data analysis to increase business efficiency, improve existing processes, and/or correct data issues.- Provide ongoing support and administration for existing deployments, including hot fixes in production environment and monitoring of audit reports.

Handle accounting operation activities; Manage daily activities of warehouse & delivery service• Manage Account Payable and Receivable, payment of local vendors, expense reimbursements and member refunds.• Conduct expense analysis.• Monitor outstanding accounts, worked with company owner to determine action to be taken.• Conduct Ad Hoc qualitative analysis.• Handle Staff scheduling, vacation and submit payroll totals, schedule Daily Delivery jobs, Supervise warehouse & delivery personal.

Handled accounting activities and day-to-day operations of office.• Managed Account Payable and Receivable.• Compiled monthly profit and loss reports, custom spreadsheets and reports in Excel for president of company.• Analyzed workflow to determine causes for returned trips to jobs, to improve efficiency of workflow.• Answered telephones, and assist customers in showroom.

Monroe, La, Us

Provided analytical support to improve staffing and business operation efficiency by informing senior management and vice presidents of strategic impact.• Compiled and presented monthly metrics to team leads and managers, advising them of areas for improvement• Analyzed call data, detecting areas of staffing shortage; recommended adjustments to staffing schedule, resulting in improving customer service.• Designed daily reports with Excel spreadsheet program to track group metrics • Developed and updated force-to-load model that analyzed and monitored staffing efficiency and drivers, predicting the future staffing needs.• Authorized payment of contractor invoices, ensuring accuracy. Detected an error in an invoice, saving company $13,000.• Authorized vacation time for workgroups, ensuring sufficient staff to handle expected work levels.• Advised employees on interpretation of company policies, ensuring consistent application of policies.