Sustainable Data Architect and Analytics Specialist

Kyle S Messaros

Marion, Ohio ***** **********@*****.*** 254-***-****

Summary of Qualifications

More than ten years of experience with data integration, data management, and data analysis along with a keen development and understanding of scheduling, coordinating, and information tracking

Proficient system utilization of Excel, SharePoint, Power BI among additional database programs

Strong analytic, problem solving, and critical thinking skills with proven and praised results

Specialized training in logistics, communication, leadership, diversity, and safety

United States Military Veteran - Honorable Discharge - Service and Campaign Medals Recipient Work History and Experience

Union Tank Car Company 2016 – Present

Write-Up Pre-Processor

Created a cross-reference tool by condensing existing databases to find part numbers more efficiently and accurately by integrating repair kits with kitting table and material using Excel and Engineering Toolkit

Extensive knowledge and daily use of MARS, FLEET, SharePoint, Appropriation Letter, Bentley Viewer Drawings Database, Appropriations Database, AS400 Database, LinkNet Tracking, Star Query, SharePoint, and Excel

Analyze and manage logistics data for cars scheduled to Marion repair facility and coordinate reschedules and cancellations with relevant partner locations and material management departments

Pre-process material requirements for cars prior to their arrival and inform COE of valve requirements to assist scheduling and help acquire shorter lead times to expedite turnaround

Proactively developed and continue to utilize an independent method to compare and validate provided data against alternate data set to yield patterns of inconsistent data and mitigate reoccurring errors Mobile Technology Lead

Account for 90 iPads on-site and manage and maintain their serial numbers, area/dept assignment, and software updates and implemented their usage on the floor

Actively participate in weekly meetings with UTLX Manager of Write-Up Processes and other Mobile Technology Leads regarding ways to increase efficiency and usability of existing apps while continuing to maintain regulation standards

Conduct training for applicable on-site departments and/or individual team members for newly implemented applications and features as well as communicating all coming procedural changes and following up as needed

Create QR Codes for new personnel badges

Write-Up Inspector

Responsible for physical inspection of inbound tank cars while strictly adhering to UTC procedures, FRA regulations, and the AAR Field Manual

Create detailed, accurate work orders for necessary repairs Innotrac Corp 2014 - 2016

Operations Supervisor

Proficient use of Crystal Reports and Excel to run analyses of open orders, inventory movement and consolidations, shipment tracking, daily production details, and associate production numbers compared to standard

Consistently met fulfillment goals of shipping a minimum of 100,000 orders containing an average of 280,000 units within a three-day time frame for client’s monthly subscribers’ gift as set by the SLA

Supervised up to 95 people in high volume times assigning pick, pack, line work, etc. and continually assessed associate productivity to optimize performance in all positions

Through collaboration, developed processes establishing accuracy, efficiency, and organizational upkeep and set associate production standards upon acquisition of new client Kyle S Messaros

Marion, Ohio 43302 **********@*****.*** 254-***-**** Work History and Experience Continued

Kroger Great Lakes Regional Distribution Center 2014 - 2014 Administrative Support Personnel – Receiving/Inbound

Used cross-docking method to coordinate available space depending on type of product, perishability, etc.

Assessed priority of shipments based on product need and drivers’ schedules and arranged time slots accordingly

Balanced bill of lading(s) by comparing purchase orders to stated delivered values while adhering to protocol of checking drivers in and out

Provided receivers with necessary documents and support to ensure accuracy and efficiency Larada Sciences 2013 - 2014

Warehouse Manager

Restructured product tracking system and consolidated and refined preexisting spreadsheets from twelve down to three eliminating redundancies while maintaining functionality

Oversaw monthly inventory figures of raw material, replacement parts, and finished goods, and verified rented-out medical devices by serial number as well as ordering and maintaining supply

Responsible for production forecasting and managed and scheduled part-time workers at my discretion for preparation of cases of disposable “tips”

Tested devices for compliance within specific parameters and recorded collected data

Fulfilled orders by packaging and shipping product and provided customer service by telephone United States Army 2010 - 2013

Training Room Non-Commissioned Officer

Designed a Company implemented personnel action tracking system for Company consisting of 185 soldiers by eliminating redundant processes through data automation, decreasing paperwork turnaround time from three days to one

Trained and managed clerks by delegating responsibilities between them to optimize data processing efficiency and provide assistance to Company leadership while transitioning to the civilian workforce

Organized and managed overseas convex movement of equipment, weapons, and personal belongings - Awarded

Appointed as Company Safety Administrator and ensured all proper protocol was followed Education and Certifications

The Ohio State University 2004-2008

VT Level II Certified Aug 2016

Google Data Analytics Certificate May 2023

Google Advanced Data Analytics (In Progress)

o Anticipated Completion (Mar 2024)

Contact this candidate