Michael Gresko Email & Phone Number

As an analyst for Calgon Carbon my role involves:Sales and Order reporting-Develop, build and distribute weekly sales report to the entire organization and parent company (Kuraray)-Build and distribute pending order report, order created reports, and other reports related to sales and ordering for entire organization or specific to certain business units-Maintain and update monthly and quarterly report showing impacts for accounts impacted by exchange rate differentials year over year for customers outside of the United States (mainly in Europe)-Maintain and update monthly and quarterly year over year variance reporting describing impacts to business based on fluctuations in sales within each business unit by product-Maintain reporting on product price increases throughout the year, conducting monthly conference calls with each business unit to accurately track and measure price increases on products by sales representative and their customers-Build ad-hoc reports based on requests from business unit leaders Excel/Power Bi-Advanced Excel knowledge with experience utilizing stacked data, creating advanced pivot tables, utilizing advanced formulas for data analytics (if, sumif, VLOOKUP, nested formulas etc...), creating tables, charts, graphs, and other visuals and views of data for end user to utilize effectively-In process of using and gaining expertise in PowerBI, converting and consolidating current and future reports into PowerBI Data Management-Update and maintain sales entries within the Lotus Notes sales database (Amending records, fixing errant records, creating new records, updating records)-Utilizing SAP to update customer records and creating new employee ID numbers-Assisting with sales plan data and load requirements into excel database system

Listed skills include Telecommunications, Management, Sales, Sales Operations, and 15 others.