Kimberly Allman-Kay

Preferred Name: Kim Kay

Fort Worth TX 76179

860-***-****

ad4c0g@r.postjobfree.com

Kimberly Allman-Kay LinkedIn

1

Outstanding Business Logistics Data Reporting Analyst who brings many skills to the mobile supply chain industry. Including, but not limited to, SQL, creating dashboards, overseeing huge projects, administering company-specific programs, utilizing various software programs, troubleshooting, problem-solving, and project coordination. Excel at utilizing coding skills to obtain and analyze data from large databases, setting KPIs, as well as other locations, resulting in useful, coherent dashboards and reports per internal and external stakeholder requests. Since data is always involved, it is always sparking my engine. What information cannot be translated into a form of data? None! The world runs on data. It is everywhere, as far as that long white line can be seen and over the unseen horizon. A mobile phone is a piece of data, a receiving document is a piece of data, and all information in a WMS is data. Data that is collected, cleaned, scrubbed, well-organized, and free of imperfections, is wide open for processing, programming, deciphering, calculating, analyzing, forecasting, storing, trending, reporting, and dashboard creation. Additionally, programming is required to move the data to be stored in databases, on a network, mainframe, and in the Cloud.

Everyone in the organization touches the data. Maybe not physically, but if they are not touching it by doing their duties it may take an hour loss loading a customer’s delivery or a wayward package not shipped. Which will restrict the report creation until the root cause is identified and a fix is analyzed. This causes time, money, and customer satisfaction while the fix is analyzed, planned, programmed, tested, and implemented to get the engine purring. With my strong troubleshooting and problem-solving skills, I am the bomb at getting to the root cause and resolving issues in all parts of the processes and life of the data in exceptional time.

EDUCATION

IN Learning LinkedIn Member

LinkedIn learning platform that contains a multitude of professional online, top-rated courses. Including software, skills, and learning paths of all levels of abilities. Completed courses located on LinkedIn profile. DEVRY UNIVERSITY

Business - Intelligence and Analytic Management

SOUTHERN METHODIST UNIVERSITY

UNIX System Administrator, UNIX Network Administration, Shell Programing Certification Santa Theresa High School

Legal Medical Secretary Certification

SKILLS

• SQL SEQUEL (Structured Query Language)

• SQL Queries Advanced

• SSMS (SQL Server Management Studios)

• Advanced

• SSRS (SQL Server Reporting Services) Advanced

• SSIS (SQL Server Integrated Services) Advanced

• Azure DevOps Advanced

• JET Data Manager Advanced

• Tableau (dashboard) Intermediate

• TOAD for SQL Server Expert

• Microsoft Office Suite Expert

• MS Excel Expert

• MS Access Expert

• MS PowerPoint Expert

• VBA and Macros Advanced

• Visio Expert

• Analytical and Problem-Solving Thinker Expert

• Verbal and Written Communication Expert

• Team Management and Leadership Expert

• Strong Forecasting Abilities Advanced

Kimberly Allman-Kay

Preferred Name: Kim Kay

Fort Worth TX 76179

860-***-****

ad4c0g@r.postjobfree.com

Kimberly Allman-Kay LinkedIn

2

• LextEdit

• UNIX System Admin / Network Admin Intermediate

• SharePoint Advanced

• SAP Advanced

• WMS (Warehouse Management System) Advanced

o Solochain

o Oracle

• Rank Importance and Urgencies of priorities in a High Demand, Energetic Environment Expert

• ServiceNow Advanced

• Project Coordinator Advanced

• Project Documentation Expert

• Time Management Expert

• Self-Motivated Expert

• Team Player and Contributor Expert

PROFESSIONAL EXPERIENCE

OPERATIONS LOGISTICS ANALYST 6/2022 – 3/2023

EXPRESS EMPLOYMENT PROFESSIONALS / FEDEX SUPPLY CHAIN • Coppell, Texas

• Reverse Logistics Mobile Device Environment (T-Mobile on-site)

• Write SQL queries from large-volume data sets utilizing various internal and external data sources

• Manipulate data in SQL queries as needed via LextEdit

• Serve as a Subject Matter Expert with WMS and LextEdit

• Uses proven problem-solving methodologies and statistical analysis to provide technical support to internal and external customer needs

• Communicate with senior management, operations, and cross-functional teams

• Research, investigate, and identify root cause problems and initiate corrective action

• Create and maintain the status of KPIs

• Daily, weekly, monthly, and ad-hoc reporting production

• Perform other duties as assigned

• Strong team player

DATA REPORTING ANALYST 2/2019 – 2/2021

GROUP O • Roanoke, Texas

• Mobile Device Logistics Industry (AT&T Mobile on-site)

• Write SQL queries in large data volume sets. Using various internal and external data locations

• Create tasks, functions, queries, and data sets with data in SQL queries and stored procedures as needed. Utilizing joins, filters, aggregate, sub queries, calculations, varchar, datetime

• Create user interface and dashboards in SSRS and Tableau

• Utilize advanced techniques in MS Excel, including macros

• Created end-user-requested reporting from initial request to finished product

• Apply excellent verbal and written communication with a variety of individuals and groups of various technical skills and levels

• Worked independently and within a team environment

• Coordinate project tasks and work closely with internal and external resources to execute against project tasks and maintain updated timelines and project documentation

• Track and report on the progress of projects

Kimberly Allman-Kay

Preferred Name: Kim Kay

Fort Worth TX 76179

860-***-****

ad4c0g@r.postjobfree.com

Kimberly Allman-Kay LinkedIn

3

PROJECT COORDINATOR 1/2018-1/2019

NEC CORPORATION OF AMERICA (VIA IFORWARDSOLUTIONS) • Irving, Texas

• Product Support and Retail Solutions Level III Call Center support (7-Eleven Stores)

• Utilizing MS Office Suite to design, create, and maintain reporting workbooks including complex formulas, pivot tables, charts, and graphs

• Scheduling and project planning, project task execution, assignment, and follow-up communications, manage daily project operations, analyze profitability, revenue, margins, bill rates, and utilization across projects by providing first- class accuracy and effective and timely customer service

• Provide distinct quality, follow-up skills, time management, problem-solving, and organizational skills OPERATIONS REPORTING ANALYST II / OPERATIONS ANALYST II 11/2011-8/2017 XPO LOGISTICS, INC. formerly NEW BREED LOGISTICS INC. • Fort Worth, Texas

• Reverse Logistics Mobile Devices (Verizon Mobile on-site)

• Strong analytical skills utilized to collect, organize, analyze, and trend large amounts of data with attention to detail and accuracy

• Transformed and analyzed data into meaningful, relevant, significant, and enlightening reports that are understandable by the end user

• Utilized SQL to retrieve and extract data from Oracle database

• Produced Ad Hoc reports on demand

• Created MS Excel workbooks including V-Look-up, complex formulas, pivot tables, charts, and graphs

• Constructed, sustained, and distributed metric reports for stakeholders and Operations

• Prepared and delivered daily, weekly, and monthly reports while meeting deadlines

• Participated in month-end and year-end processes

• Followed organizational and customer report standards

• Subject matter expert (SME)

• Verified data uploads to the dashboard

RMA SUPERVISOR / OPERATIONS ANALYST 11/2008-11/2011 NEWBREED LOGISTICS INC • Fort Worth, Texas

• Reverse Logistics Mobile Devices (Verizon Mobile on-site)

• Supervised twenty RMA (Return Merchandise Authorization) representatives and six Operations Analysts, in a call center setting, while working with the multiple vendors

• Worked with IT to implement Electronic Data Interchange (EDI). An electronic interchange of RMA information using a standardized format. Which allowed vendors to conduct business electronically, reducing headcount and eventually disbanding the RMA department

• Utilized SQL and MS Access for reporting needs from Oracle database

• Created MS Excel workbooks including V-Look-up, complex formulas, pivot tables, charts, and graphs

Contact this candidate