Melissa Rios Email and Phone Number

My current job is to obtain and transform data using Excel, Stata and SQL to create procedures, complete tasks and accomplish goals for multiple departments. I communicate with Directors, General Managers, and VPs regarding upcoming projects, schedules, and possible solutions for areas needing improvement. I manage pricing and data changes for the B2B, E-commerce and Purchasing departments, as well as, the brick-and-mortar retail locations. I also analyze weekly information from the Lights America database and interpret data to update all systems.

A main part of my job was to audit and correct any discrepancies on purchase orders and in the NetSuite system. I managed any pricing or data changes for all domestic and imported vendor lines, while delegating specific tasks to the E-commerce team, such as loading promotions and correcting IMAP breaks. I updated information for in-house products and the customer database on multiple platforms, while sending monthly updates to all Directors and General Managers associated with the in-house (B2B) line.

I worked on a 3-month project and improved the quality of the in-house brand’s data by recreating the master data sheet, customer portal and website. I analyzed data from vendors to create and load price updates based on cost changes or tariff increases. I audited all item data on the website quarterly for inaccuracies. I worked with my manager to create processes and trained a new data specialist in all rules, policies and tasks.

I assisted with adding new products to the website, along with any relevant data, images and PDFs. I created a “Light Finder” program from scratch to help assist customers by finding what they are interested in based on budget, style and room size. I cleaned up data from vendors to report and implement any price changes dealing with increases, decreases, tariffs and promotions.

This position for for Lights Online, which is the online sales division of Progressive Lighting. I started out by assisting the (1) customer service specialist at the time and also assisted the e-commerce manager with some projects regarding the website and products. I answered phone calls, emails, and engaged in a live chat online. I entered orders, made sure all the customer information was correct, created a purchase order and sent that to the vendor to have them dropship the item(s) to the customer. I gathered tracking information and passed this on to the customers. I invoiced orders and applied payments. With the e-commerce manager, I gave my assistance to adding new product to the website. I made sure all information for the product name, description, and associated parts was available for each item. I became a certified ALA Lighting Specialist (8/2015).

I answered any and all incoming calls to the showroom and directed them to the appropriate person. I confirmed all the shipping orders from the warehouse to make sure all the information was correct. Every time a salesperson had a purchase, I would gather all the information that had to do with the order and payment for the order, make sure everything matched, and put all invoiced orders together at the end of the day to make sure all product was picked up and paid for. On busy days, I helped out by entering sales into the system and made sure the showroom was clean, while also checking to switch any burnt out bulbs. Checked voicemail.

I assisted customers by using price/SKU numbers to locate items in the store and in other store's inventories. I used a POS system to complete sales, returns, and exchange transactions in person and over the phone. I used a Plan-o-gram to merchandise the items coming from the truck freight and to set up for sales. I used a price scanner to complete price changes and re-merchandise according to the sale catalog. I opened up Belk accounts and credit cards with customers while informing them of all necessary information. I received positive customer and managerial feedback due to my work ethic. I was recognized and promoted for going above and beyond my normal duties as a part-time employee.

My responsibilities included assisting customers with their needs. I completed any transactions involving sales, returns, and exchanges. I helped to merchandise the department and keep it clean. I was involved in community events, including Charity Day and KidsFest.

I was in charge of setting up any CPR classrooms with all paperwork and equipment for the instructors and multiple locations. I sanitized pieces of the CPR manikins after each use. I worked with any customers/clients that came into the office when my supervisor was busy or away. I helped to put together any CPR material orders for clients. I completed any office task given by supervisors including returning phone calls/emails, making copies, scanning, faxing, and look up client information. I accomplished over 500 internship hours.

Created and managed an after school health program for Sumter County 4H students called "Get Moving Mondays". Helped children learn health and exercise facts and tips to create a healthier lifestyle while also having fun. Assisted in giving positive feedback to children working on talents and speeches for competitions.