Mitchell Renner Email & Phone Number

Chicago, IL, US

Greater Chicago Area

• Lead developer for large-scale rebuild of monthly adjustment process involving: streamlining ETL processes; SQL Server stored procedures programming; SSIS packages; front end MS Access application buildout with user.
• Lead programmer for additional data processes involving mapping out existing data structures and workflows (Visio); SQL programming (SQL Server, Access); automating Excel reporting; creating Access front end forms with.
• Provided analytical reports and workflow documentation for existing large-scale data processes; produced dataset comparisons identifying data integrity issues
• Ran data processing tasks as backup administrator

Chicago, IL

• Primary developer and administrator for distributed multi-purpose Access front-end/back-end application in multi-user environment of over 100 users, used for tracking data, automated reports, generating notifications.
• Implemented Access application front end forms for users to navigate, enter and track data, view data in datasheet subforms, save customized user settings, run automated data procedures, and export parameterized reports
• Designed complex queries for data operations and reports using data from Access databases, bank data servers (DB2, SQL Server) and other data sources (Excel, delimited text files, SharePoint lists)
• Programmed automated data input/output procedures between Access databases and other data systems
• Designed automated, user-retrievable reports in Access for custom loan processing, client optimization, compliance, financial loan history, and administrative use, as Excel or Word exports
• Created Excel dashboard reports for managers to track progress of all custom lending products at regional, market and banker levels of breakdown

Bloomington/Normal, Illinois Area

• Developed Access 2007 & 2010 database applications and automated data import/export processes for technical support call center including reporting for historical statistics, scorecards, ticket auditing, performance.
• Created and deployed ticket auditing system in Excel for auditors to generate weekly ticket audits, fill out forms in Excel, programmatically distribute results to management and end users, and export results into an.
• Implemented automated report distribution processes through VBA, Outlook email, and exports to shared network directories and individual user SharePoint My Sites libraries
• Programmed Avaya CMS Supervisor scripts using VBScript to generate real-time phone statistics reports otherwise not available
• Administered SharePoint site including designing sites, navigation, themes, adding web parts and content; group and security administration; served as point of contact for major site migration; customized pages, lists.
• Provided technical support documentation in Word, Visio, Excel, and Adobe Acrobat including instructional guides, call flow diagrams, floor plan maps, and decision matrix tool

Morton, IL

• Developed Lotus Notes (5, 6) applications including company-wide policies and procedures compliance database and internal employee directory prototype; maintained and revised existing Lotus Notes databases
• Developed Access 2003 database for financial summary reports and maintained existing VBA code for Excel spreadsheet-based programs for monetary instrument purchases and other financial operations
• Revised and implemented automated daily data mining process using Monarch data capturing, Excel, and VBA to generate operational reports for Audit Department
• Completed large data conversion projects in Excel involving customer list and account number comparisons
• Ran mainframe operations, performed Cognos data queries, generated daily bank statements, designed new bank forms and documents, produced ad-hoc financial reports.
• Provided technical support for hardware and software and administered Lotus Notes email system

Canton, IL

New York City, NY

• Supervised presentation center workflow, logged jobs, and monitored work volume and progress
• Provided software operational support in Excel, Access, Word, PowerPoint, and Visio, creating documents, reports, graphs, tables, slideshow presentations, organizational charts, graphics, and other materials

M.A., Music Composition

B.A., Music