Fabian Maes (He,Him,His)

Experience

• 

  Vectra Bank Colorado

  Jun 1997 - Jun 2000

  Lead Item Processor - Vectra Bank Processing Department

  • Assistant supervisor to a staff of 22 employees and generated weekly/monthly work schedules• Assisted as an overall troubleshoot between the Central Operations Department (COD), branches and vendors which included accumulated data on final board report for COD by updating volume schedules and service indicators. • Coordinated with Zion’s staff to update the Vectra Bank system and customer accounts.• Established and maintained personnel files on management and staff for Credit Operations Director. • Managed the Management Information Systems (MIS) Report by tracking installment loan applications from date received to final disbursement. • Train all employees on equipment operation (CRT, NCR 7780 Sorter, NCR7760 Single Pocket, multiple phone lines, fax, copier, and printers) Policy and Procedures. Show less

• 

  PacifiCare of Colorado

  Jun 2000 - Oct 2002

  Associate Assistant III - Member Appeals Department

  • Administered, reviewed, evaluated, designed, implemented and maintained the member Appeals and Colorado Measures Database. • Analyzed MS Access data for monthly, quarterly, and yearly reports for various interdepartmental and corporate personnel in order to trend and analyze data for functional measures that resulted in fewer member appeals.• Automate MS Access database to perform internal audits while reducing the amount of time to conduct manual internal audits. • Created accounts, passwords, and paths for end users. • Designed, produced, and updated various departmental forms and/or formats required for reports and work projects using MS Word, MS Excel, MS Access, and MS PowerPoint. • Implemented database designs, data access and table maintenance codes; resolved database performance issues and database capacity issues, which resulted in faster response time and effective use of memory management. • Managed, organized, coordinated, and monitored multiple projects to meet assigned deadlines.• Programed MS Access for modification and constructions including stored procedures via SQL and Visual Basic. • Provided data flow diagrams via Visio Professional and documented the process for Health Services and Medical Management, which produced a visible understanding on the flow of data. • Trained employees on MS Access functions, shortcuts in MS Office, office equipment, and Policy and Procedures. Show less

• 

  Exempla Healthcare

  Oct 2002 - Jun 2004

  Information Services Technology Liaison - Business Revenue Services

  • Analyzed and submitted EDI files for certification from ClarEDI for Exempla Saint Joseph Hospital, Exempla Lutheran Medical Center, and Lake Superior Systems. • Analyzed and corrected the 837I Hierarchical Level Structure for hospital and physical/residency. Corrected Errors from 997 Transaction Report from payers and resubmitted for certification prior to going “Live” via ClarEDI. • Conducted multiple training sessions on new HIPAA (Health Insurance Portability and Accountability Act of 1996) laws and the use of Medifax to employee’s facility wide. • I installed and maintained the Medifax Server and terminals at Exempla Healthcare and all physician/residency clinics. • I wrote SQL statements and produced financial reports for the Senior Finance Team, the Board of Directors, and the Managers of Patient Business Services of Exempla Healthcare.• Managed and implemented multiple projects, such as: TRAC, Medifax, and Blue Cross/Blue Shield. Show less

• 

  Colorado Department of Education

  Aug 2004 - Nov 2008

  • Communicated detailed complex information to other units and testing vendors in planning supportive data needs and functions related to state and federal assessments and accountability measures.• Managed the $1.6M Colorado ACT assessment (from contract negotiations, to assessment administration, data collection, and report distribution). • State trainer for the Unit of Student Assessment for Pre-Coded Labels Collection, School of Accountability, Student Biographical Data, and Student October. Show less • Administered annual surveys to public libraries, school libraries, and media centers throughout Colorado. • Administrator for the Learning Management System for Web Junction Colorado. • Created and managed an MS Access databases of survey recipients and responses. • Created, organized, and maintained shared print and electronic file for LRS. • Designed and produced reports, brochures, and other documents.• Developed online training course materials via Isoph Blue Instructor Learning Management System. • Followed-up with non-respondents, and answered questions from respondents to clarify survey contents or procedures. • Produced and processed purchases orders and memorandum of understanding. • Webmaster and content developer for the Library Research Service (LRS) department. Show less

  • Senior Consultant - Unit of Student Assessment

    Jan 2006 - Nov 2008

  • Administrative Assistant III - Library Research Service

    Aug 2004 - Jan 2006
• 

  Fabian Maes Photography

  Nov 2008 - now

  Photographer

  I specialize in Lifestyle photography.http://www.FabianMaes.com

• 

  Aurora Public Schools

  Sept 2009 - Mar 2012

  Analyst - Department of Accountability and Research

  Created and maintained several databases of student-and school-level assessment results for CSAP, MAP, ACT, DRA, DWA, and others as needed for research and analysis. Prepared custom data analyses and technical reports for school, departments, Board of Education, senior administrators, research programs and the public using multiple assessment instruments, demographic measurement, status measurement, data format conversion and integration of multiple software packages. Interpret and explain assessment information. Work closely with Public Relations, Information Technology and other departments to make assessment data and reports available in a timely manner. Show less

• 

  Seven20

  Jan 2013 - Jun 2019

  Manage a team of nine employees (six warehouse staff and three office staff) by providing training and oversight to ensure se7en20s operations run smoothly by implementing policies and procedures to increase productivity. Manage a 66,000 sq. ft. warehouse and inventory of approximately 2,300+ items valued at $2.5 Million. Logistically, I coordinate the international and domestic (ocean and air) deliveries of 20ft, 40ft, and 40ft HQ containers to and from ports such as: Los Angeles, Long Beach, Yantian, Shenzhen, Ningbo, and Hong Kong via UPS, DHL, Landstar, and JAS freight forwarders. Show less Perform data query, extraction, and compilation from multiple data sources. Manage, update and manipulate report generation and data structures with the use of advanced MS Access and MS Excel functions including Pivot Tables and VLOOKUPs. Generate weekly, monthly, quarterly and ad-hoc reports. • Company report writer utilizing MS Access (ODBC links, tables, queries, functions, and macros) to query data then export to MS Excel (VLOOKUPs, and Pivot Tables) to manipulate the data for the President, Chiefs, Finance Dept., and Operations Dept. to drive the business for increased sales and develop new exclusive products. Show less Responsible for the growth and retention of retail accounts on a national level. Manage 16 major accounts with an annual revenue over $3.3 million; manage 97 mid-tier accounts with an annual revenue over $100K; and manage 225 small-tier accounts with an annual revenue over $300K. Develop and maintain customer relationships while introducing new product lines. Built and manage the Master Product Line List of approximately 2,300 items (data types included are Property, Category, Sub-Category, Cost, Wholesale, Dimensions, HTS Codes, Inventory, Battery Info, Age Range, ETC.) Show less

  • Senior Operations Manager

    Jan 2018 - Jun 2019

  • Senior Data Analyst

    Jan 2016 - Jun 2019

  • Senior Account Manager

    Jan 2013 - Jun 2019
• 

  Naval Information Warfare Center Pacific

  Jun 2019 - now

  Project Business Financial Manager