Adam Zydek: Business Analyst in Chicago Ridge, IL

• Evaluate monthly KPIs to business standards to provide monthly detailed reporting • Perform daily financial analysis to comprehend spending and generate weekly/monthly financial statements • Create, maintain and monitor company dashboards in Power BI and Klipfolio, including international customers • Manage constantly changing unit detailed roster • Created reporting insights for general/operations managers to run the operation. Ex: Units maintenance statuses, utilization reports to optimize units lifespans, project statuses, resource manpower planning, etc. • All unit mileage tracking for reporting and billing

Finance/Sales and Accounting, Long Term Planning – Resource Planning, Short Term Planning – Manpower Planning • Analyze, create tools, enhanced and streamline reports created for distribution to management that enable productivity monitoring • Subject matter expert for Customer Service Vouchers auditing maintaining compliance with requirements and guidelines • Create and distribute a Sales and Accounting overview Scorecard to measure office functions and productivity • Created and distributed Customer Service Management performance report measuring and tracking for ORD airport • Building, evaluating, and executing employees bids for shifts, vacation, days off, and budget effecting areas • Assist in the development and maintenance of advance work schedules for station operations • Prepare and keep track of information and reports pertaining to budgets, office forecasts, operations and performance • Personnel-related duties including provisions of union agreements and company policy • Manage trades between union employees according to contract guidelines

• Updated customer and station cargo allotments from all regions • Allotment management requiring communication daily with Inside Sales Reps and Account Executives in every region to ensure cargo flight bookings, records and cargo could fit available capacity • Managed Corporate Cargo’s SalesForce and SharePoint accounts by uploading reports • Answered incoming capacity calls from the ISRs, international and domestic warehouses and the call center • Updated airway bills with required information, such as contract rates and allotment specification • Input customers into system, re-drive AdHocs and update system with historical data for forecast accuracy • Participated as admin in product testing and implementation of new allotment management system for Cargo Operations • Created a new tool imperative to flight schedule that showed dates, routes, widebody/narrowbody and specific aircraft type

• Accurately handled the sale and distribution of thousands of tickets, following program requirements and while providing fans information about the Chicago Bulls charities

• Website updates using HTML and CSS to complete customer products • Utilize WordPress content management system to build websites • Provide guidance on websites user interface to complete projects

• Utilizing rental operating systems to create accurate orders for customers while providing a positive experience • Improving marketing strategies in SEO development, website design, and Social Media Marketing

• Created over a dozen videos to promote new and existing products with Camtasia software • Website/file auditing to maintain current data and information integrity for the company • Analyze historical pricing data to help guide future pricing initiatives • Utilize Firebrand software to gather and organize information to update product information • Effectively managed social media communications, engaging with Facebook and Twitter followers with questions or comments • Took Control of email blasts for marketing campaigns and survey data • Assisted with textbook sampling by packing approximately 1,100 books for shipment

• Created and publish digital marketing blogs aimed to interest the SEO and SEM community • Built customer following and answered questions regarding the blogs and product information • Tracked, organized and reacted to analytical data generated to make the company’s plan more efficient • Represented a professional image for DGU at the 2013 Techweek Chicago – LAUNCH Competition

• Preparation of facilities for the Merger of United and Continental Airlines • Research and Prepare Employee Records for H.R. / Employees • Teach and train employees in the operation of the new equipment • Assist in the Technical repair of security badges as needed