Edwin Rodriguez Email & Phone Number

Chicago, Illinois, Us

Chicago, Illinois, Us

- Responsible for Procurement departments monthly financial reporting. Which includes monthly spend cubes across all Business Units. - Create monthly Purchase Price Variance (PPV) reports and analysis, used to meet with managers to determine why we are deviating from budget standards set for materials.- Lead monthly PPV meetings with Procurements and Finance leaders.- Create savings tracker templates and update on a monthly basis with actual purchasing data. - Create/update Cost Saving Thermometers to show YTD target goals vs actuals. - Prepare monthly PowerPoint deck summaries for financial reviews. - Create and update budget templates for planning upcoming Fiscal year standards and baselines. - Part of analytical team that has gone through two different data set integrations, Nestle and Keebler. - Update monthly Commodity Market prices. - Test new reports/queries created in Business Objects and SAP before deployed into production. - Maintain Procurement Master Data tables up to date i.e. Master Vendor, Master Managers, Master Material Group, etc… - Update material pricing in SAP when needed. - Resolve blocked invoices due to quantity or pricing discrepancies.

Chicago, Il, Us

Analyst II in the Business Intelligence Team for TOPS Products, a division of LSC Communications.- Develop and maintain weekly Walmart reports based on Retail Link Metrics.- Assist the Walmart sales team in ensuring the highest number of sales are attained and continue to grow.- Discover new opportunities for sales growth for Walmart.- Create queries using Walmart's Retail Link .- Update Walmart and Sam's Club monthly forecasting, adjust to season trends.- Facilitate Supply & Demand issues that might arise.- Create Walmart's new items and maintenance existing items.- Manage inventory levels for our items in order to prevent cancellations on future Purchase Orders.- Ad hoc reporting for Walmart's buyers and replenishment managers.- Create sales and shipment reports using SAP Business Objects for our internal sales and marketing teams.- Extract sales and inventory data from large databases using queries and SQL.- Create reporting models to track KPI across multiple product categories, to insure optimal sales.- Analyze and communicate weekly Point of Sale data to product directors, sales reps, and respective customers.- Create Excel templates used for weekly and monthly sales reporting. - Create planogram store display heat maps in order to provide planogram productivity analysis. As well as make recommendations on add/drops.- Prepare sales data analysis for Annual Market Research Summits.- Track and update monthly supply inventory management files, to ensure product inventory is not accruing excess reserve dollars. - Track sales data for specific products during peak seasons i.e Back-to-School, Tax-Season, Back-to-Basics.

Chicago, Il, Us

Analyst in the Business Intelligence Team for TOPS Products, a division of LSC Communications.- Create sales and shipment reports using SAP Business Objects for our internal sales and marketing teams.- Create Excel templates used for weekly and monthly sales reporting. - Extract sales and inventory data from large databases using queries and SQL.- Analyze and communicate weekly Point of Sale data to product directors, sales reps, and respective customers.- Track sales data for specific products during peak seasons i.e Back-to-School, Tax-Season, Back-to-Basics.- Provide future advertisement recommendations to customers based on previous product performances and seasonal trends.- Prepare sales data analysis for Annual Market Research Summits.- Track and update monthly supply inventory management files, to ensure product inventory is not accruing excess reserve dollars. - Provide planogram productivity analysis.

• Perform Capability Studies that require the analyzing of the process and or processes used to make parts. Then determine if it is capable of producing parts that conform to the blueprint.• Use statistical analysis and compile statistical data through Gage Studies to prove that devices and techniques used to measure parts are accurate, reliable and remain constant. • Prepare PPAP (Production Part Approval Process) documents. A document that is required by most customers whenever a part is being made for the first time or when a customer makes changes in any way to an old part. • PPAPs are prepared using the Capability and Gage Studies along with very detailed documentation and certificates that serve as proof that we have complied with customer requirements.

Chicago, Illinois, Us

• Audited over 400 vendors as part of a MSP Auditing Project in less than 6 weeks.• Processed and entered associate data through various staffing systems and websites.• Confirmed that information received was accurate for auditing purposes.• Part of a small team in charge of staffing thousands of vacant job positions during peak season for Amazon.• Managed and updated client’s information across multiple databases.• Data Entry.

Full Stack Web Development Certification, Computer Software Engineering

Bs, Mathematics; Minor: Business Administration