Mark Hecker Email & Phone Number

Chicago, Illinois, Us

Chicago, Il, Us

• Senior Analyst for the development and testing custom software for the creation of back-to-birth trace for aircraft parts. The system is capable of processing millions of pages of PDF’s and extracting information based on Optical Character Recognition (OCR) and AI-defined processes. The improvements have led to a 70% reduction in processing time and an increase in data accuracy. • Orchestrated the creation of data-driven dashboards and reports in Power BI and Excel by merging data from multiple internal and external databases, defining custom fields for JIRA project management, and effectively communicating project progress to ownership and potential investors. Created reports to highlight improvements in process speed and reduced costs while processing more documents. • Completed complex data analysis for assigned projects on time and effectively communicated those results back to the management and the client. Additionally, I am serving as ProvenAir’s direct Client Account Representative for multiple large multinational customers. • Communicated project progress, risks, and issues to stakeholders and senior management through regular Agile based updates and presentations.

Chicago, Il, Us

• Gathered requirements from external customers, performed custom data analysis, and delivered customized marketing reports and promptly using both provider data and extremely sensitive customer employee medical data with 95% accuracy.• Supervised a team of ten, ensuring adherence to quality control and accuracy standards. Led an initiative to monitor provider data validity, involving data scrubbing and reformatting and joining provider data from all fifty state plans across the country. Designed system of flag possible discrepancies and automatically alert to appropriate client representative. • Monitored project progress and reported issues and risks to the project manager

Chicago, Il, Us

* Business Requirements Gathering – worked with multiple user groups to gather and document system requirements for both internal and external program enhancements. Attended multiple training Business Analyst training classes detailing Use Cases and other SDLC requirement gathering techniques. System Data Conversion (ETL) – Lead the successful merger of system data between two CRM systems into a single custom-made system after the merger between CME and CBOT. Responsibilities included: gathering functional requirements needed for the development of the combined system from multiple user groups, developing the system requirements documentation for the IT team, leading the QA testing of the new system functionality and tracking the resolution of issues. * MS Access development – creation of multiple databases for processing data from multiple sources including ODBC, importing of flat files, and directly linking to Excel spreadsheets that automatically imported daily financial information from REUTERS and Bloomberg. Skilled in creation of complex SQL queries, Forms for user input and filtering, Macros, and VBA code. Also created a customized web server using Apache/MySQL to distribute the data. * Regulatory FIX API ISV (Independent Software Vendor) Review – functioned as the lead regulatory contact for questions regarding order entry into the GLOBEX order engine, requiring an extensive knowledge of the CME’s use of the FIX protocol and external and internal requirements for regulatory control. This required the ability to explain both technical and functional requirements to over 100+ external software vendors, clearing firms, and other CME departments.* Technical Troubleshooting – functioned as one of 2 lead contacts for a department of over 100 employees for all hardware and software related issues, solving 75% of issues before having to forward problems to the central Customer Support team.

Dublin 2, Ie

Employed as systems programmer and analyst during the development and installation of a world-wide financial system. Responsibilities included the coding and testing of customized General Ledger applications, system data conversion, developing interfaces with existing systems, and data modeling. System was developed and installed on an IBM mainframe utilizing the following tools: COBOL II, DB2, TSO / ISPF, Query Management Facility (QMF), File-AID, File-AID for DB2, JCL, and Design 1.