Learn Data Skills
Beta
Charlene Malloy

Charlene Malloy

NA

NA

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

My New Track

SQL Fundamentals

My New Course

Introduction to SQL

Quantitative navigator, guiding decision-makers through the sea of data.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Intermediate SQL

course

Joining Data in SQL

course

Introduction to SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Intermediate SQL
Joining Data in SQL
Understanding Data Engineering

My Work Experience

Where I've interned and worked during my career.

Bulletproof 360 | Nov 2020 - Dec 2022

Master Data, Data Governance

Maintain Item Master, Bill of Materials, and Pricing. Data Governance. ▪ Assign SKUs and Item Master creation/maintenance. BOM changes. Identify Item Master inputs needed. Design and work with IT to add fields into NetSuite. Ensure Master Data accuracy between warehouse WMS, Amazon Seller Central, Shopify, and internal systems. Work with team leads to capture missing data. Publish Item Master changes company wide ▪ Maintain Customer Master with correct shipping/class of trade (Ecomm/retail/ wholesale). Identify duplicate accounts to merge. Deactivate closed locations ▪ Created Data Governance to standardize items including naming conventions, package size. Lead for New Item and Customer process/ requirements. Completed whole system cleanup and standardization of Master Data, Pricing, UPCs. Realigned all package dimensions grouping by same package size ▪ Maintain National List Price database - retail, wholesale, employee, club, and international pricing ▪ Lead Document control process for Supply Chain (SOP/Process Map/RACI). Standardize training documents. Maintain SOP library on SharePoint
Show More

Bulletproof 360 | Nov 2020 - Dec 2022

Warehouse Coordinator, Order Management

Coordinate Warehouse and Order Management activities ▪ Manage EDI process. Setup BPN. Customer specific pricing cross reference table ▪ UPC creation/maintenance in GS1.org. Setup Harmonized Tariff Schedule (HTSUS) research cross border issues. Calculate NMFC Freight Classification Codes for Master Case ▪ Create Master Case label and barcode templates in BarTender software for Brand Team/Supply Planning for vendor printing. Amazon specific Barcoding and labels ▪ Report Daily Sales Revenue company wide, daily FIFO shipping report, and Amazon Daily Inventory report. Communicate when SKUs are ready for launch after Quality Control is met ▪ Maintain Customer Master with correct shipping/class of trade (Ecomm/ retail/wholesale) to streamline ordering process. Identify duplicate accounts to merge. Deactivate closed locations ▪ Month End Close with Accounting. Manually close cancelled orders or correct ship dates to correct reporting month ▪ Partner with Supply Chain Lead on month end inventory discrepancies to identify root cause. Run Inventory reports for SKU deactivation. Work with Supply Planning on SKU inventory run out

Molson Coors Beverage Company | Mar 2019 - Jun 2020

Logistics Analyst

Master Data for Multi-Modal Logistics Team. Maintain all transportation lanes for awarded, backup, and spot carriers for each origin/destination throughout the network and update allocations as needed. Managed carrier network of 1,800 domestic distributors, 60 global customers, 8 domestic breweries, 5 craft/micro-breweries, 9 import breweries, and 9 distribution centers. SME support for the overall transportation team ▪ Align master data in SAP/TM systems and maintain data integrity throughout the transportation system. Import/Export Lane setup and maintenance, multi- port and route setup. Setup and maintain shipment tendering flags for +50k lanes. Setup and maintain condition tables and carrier freight agreements. Input and maintain all transportation rates during quarterly and annual RFPs and spot changes ▪ Assist Load Control team to fix errors for missing lanes and incorrect equipment types ▪ Audit lanes for correct miles and transit time using PC Miler ▪ Buy/Sell Territory Lane setup ▪ Business Objects Expert Users Group

Molson Coors Beverage Company | May 2017 - Apr 2019

Master Data Analyst

Supply Chain Planning of SAP product master data setup and ordering authorization based on distributor contracts, including promotional and seasonal authorizations. ▪ Product authorization audits for three systems on projects and new brand rollouts - domestic, export, and contract distributors Set activation dates for distributor/SKU pairs. Promotion activation dates. Setup manufacturing SKU and state deposit label assignments based on legal requirements. Load distributor authorizations with LSMW/Winshuttle. ▪ Database maintenance and data cleansing of phased out, inactive packages and brands. Life cycle end for ordering SKU or manufacturing SKU ▪ Pabst Brewing Company - product authorization and data audits. Worked directly with Pabst to ensure data quality ▪ Business Objects expert users group. Business Objects assistance for Supply Chain teams ▪ Business Objects report writing: Created and standardized general reports. Data analysis report creation. Project management related to SKU activation. Key mapping. Ad-hoc analysis ▪ User acceptance testing for Master Data universes ▪ Trained Global Business unit (Bucharest-HQ) in all functions of Master Data for Customer and Product Authorization

Molson Coors Beverage Company | Sep 2012 - Apr 2017

Data Quality

Store Level Analyst for Commercial Team. High volume data quality. Data integrity for sales and inventory ▪ Calculate and Publish estimates for missing sales volume to domestic sales team for accurate sales planning. Data support for three reporting systems. Manage realignment of sales volume and outlets for distributors or territories bought/sold. Store/Outlet accuracy address, open/closed, class of trade, validation of all info ▪ Work with BIS and Mainframe teams to resolve system issues and third party company to resolve distributor reporting issues. Manage data issues for distributor rebates. Work with Regional Pricing Analysts to resolve rebate issues due to sales or class of trade errors. Work with Master Data and Supply Chain teams to correct sourcing issues ▪ Create validation/audit reports in Business Objects ▪ Cross functional team member for item roll-outs and package changes. Lead meetings with Regional Sales Operations Managers ▪ Manage distributor self-audit process ▪ Standardize team processes to create efficiencies

Molson Coors Beverage Company | Jan 2011 - Aug 2012

Sales Collection Support Analyst

Distributor & Sales Team Services for Commercial Team Research and resolve data integrity issues for volume, inventory, and outlet data. Resolve distributor rebate issues. Support for two reporting systems. EDI Mapping store/outlet class of trade

Molson Coors Beverage Company | Sep 2010 - Dec 2010

Pricing Coordinator - Safeway Division

Coordinate updates to Price Planning database for MillerCoors Sales and Safeway Corporate. General Price Increases, Price Resets, Post Off dates. Create weekly sales ad analysis database for Safeway Division

HAVI Global Solutions | May 2005 - Feb 2010

Senior Managed Pricing Analyst

Manage pricing and supply lane data for McDonald’s supply chain (US/ Canada/Latin America/Asia Pacific). Package pricing and price adjustments for Chipotle, Noodles & Co., and Panda Express. ▪ Item Master Data setup/maintenance, price adjustments, freight/lane rates, order quantities, andproduct lead times. Determine distributor pricing to achieve target margins, update monthly customerprice list, communicate any changes outside of deadline, and resolve pricing issues with distributioncenters and vendors ▪ Managed Supply Line database, supervise benchmark freight changes with Logistics/LXPTransportation. Supervise price and freight changes on cross- border items during exchange ratechanges ▪ Create Siebel reports for internal/external management on gross margin, variances and price changeimpact scenarios. Collaborate with IT on system enhancements/upgrades to streamline process andcreate higher productivity. Design and testing, create test scripts and test functionality ▪ Pricing Team Lead on all major internal/external cross functional teams. Train Jr. Team members indaily operations and support during team deadlines ▪ Develop, document and maintain procedures for department ▪ Optimized purchase order quantities to maximize lane rates for each Warehouse/Distribution Center ▪ Saved company over $500,000 in freight costs by optimizing order quantities ▪ Achieved target margins on an on-going basis ▪ Received nine “High Five” awards for going above and beyond ▪ Received recognition for role in execution of JDE upgrade

HAVI Global Solutions | Dec 2001 - May 2005

Account Analyst

High volume analysis of Purchase Orders, for both A/R and A/P ▪ Receivables: Apply ACH/lockbox payments and analyze A/R based on a monthly price list, account reconciliations, aging reports, and month end close ▪ Payables: Research and resolve vendor discrepancies for over/short/ damaged goods ▪ Resolve short/over payments, payment term issues, and process credits/ debits/adjustments for both distribution centers and vendors ▪ Ensure appropriate taxes and duties are billed/paid by Canadian distribution centers and correctly paid to Canadian Suppliers

My Education

Take a look at my formal education

AA, Economics/FinanceCollege of DuPage | 2009

About Me

Charlene Malloy

Looking to increase my job skills on programming/coding. I have been working in the Supply Chain industry for +20 years but have found that the tools change quickly. Master Data, Data Quality, Logistics, Pricing, Account Analysis.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free