Marty Gwozdz: DATA ANALYST in Redondo Beach, CA

• Conduct data mining and analysis using SQL, Excel, Tableau and Power BI. • Used analytics tools such as Tableau and SQL to support the business in finding potential commercial testimonials. • Collaborate with Database team and Full Stack Developer to design custom reports and dashboards. • Created new data reporting processes using SQL querying to enable the business to stop running reports manually. • Identified and investigated data discrepancies, and resolved them. • Track and monitor contract payment processes, statuses and collections daily • Collaborate with Web Developer to create a tool sales agents use to assist in educating the potential customers. • Using R Programming to manipulate data and create a single file from multiple resources for tracking opted out emails.

• Data extracted and reported creation for Business Intelligence: There were 3 reports sent from NICE for credits and collections and 2 reports sent from Credit Calculator for Ops readiness. ? Created alerts for missing data to proactively prevent failures. ? Troubleshot and fix any file upload failures or reporting issues. ? Monitored for spikes in reporting and investigate the anomalies. ? Witness calls in ETS, analyzed data and application logs in Kibana to troubleshoot any production issue related to credits and collections. ? Migrated existing reports to use application data instead of logging data. • Monitored daily imports to NICE database. • Worked with billing design or field ops team to resolve import failures. • Monitored customer verification and agent compliance numbers twice a day. • Monitored adjustment history for last 30 days per legacy company and biller and escalated any variances in adjustment history. • Pulled data for our pilot users post deployment to monitor the new features. • Performed database cleanup activities for NICE and Credit Calculator. • Provided CSG and ICOMS test data from QA and Prod for both NICE and Credit Calculator. • Generated ad hoc reports requested for NICE and Credit Calculator by our clients. • Database work for new features, created new tables and data imports to feed the tables.

• Conduct data mining and analysis using SQL, Alteryx, and Tableau. • Built custom reports and automated distribution internally and externally using SAP Business Objects. • Collaborated with multiple teams (Operations, Procurement, Engineering Solutions, and Project Management) to design custom reports and dashboards. ? Reports were uniquely designed to measure the key performance indicators that drove our customer's business. ? Visualized the data into dashboards using Tableau to monitor processes and served as the platform to identity continuous improvement opportunities. • Worked as a dedicated analyst for Pfizer Pharmaceuticals, created a budget dashboard in Tableau used by the customer for their month end financial reporting. ? Customer was able to monitor spend variance and what factors impacted the spend variance to improve budgeting. ? There was a total of 9 dashboards broken down by transportation mode, budget groupings, and Carriers. ? Main data source was a custom SQL query that provided all paid Freight Bill data. ? Other data sources were Budget files created in Excel. ? Used Blended data by joining the data sources to monitor actual spend vs budget. ? Calculated VEMP based on three factors (mixed mode, volume, and price). VEMP helped them see what impact these three factors had on the spend variance. • Created Customer Facing Dashboards using Tableau for multiple clients such as Kimberly Clark, Pfizer, Buckman and IES. • Trained Pfizer's Chennai team during the transition of their Global business control tower. ? Was responsible for data quality reporting provided to their freight forwarders. ? Created SOP and trained the team virtually.

• Item Ratings - Defined service levels for each SKU by calculating each item's inventory score; a weighted average of unit sales and gross profit. ? The Inventory Score is ranked descending to assign item ratings and service levels. ? Created a job and store procedure in SQL to calculate the item ratings and update weekly. ? Report used by the Buyers to help replenish inventory and store managers used the item ratings to monitor top items to obtain inventory. • Demand Forecasting Optimization - Used five exponential smoothing forecasting algorithms (Moving Average, Moving Average Trend, Seasonal Additive, Seasonal Multiplicative, and Croston) to create demand used in inventory level calculations. ? Used SQL to extract the historical sales data by category. ? Used this data to run VBA Excel macros for each forecasting method. ? The coefficients were imported into a SQL table. ? Created a job and stored procedures that would use the coefficients table to replicate the forecasting from the macros to provide a monthly report with the demand for the next 30 days. ? This report also utilized the item ratings to provide the Buyers with Safety Stock and Reorder Points. • Product Recommendations (Baynote) - Increased revenue by using A/B testing within Baynote's interface. ? Using A/B testing helped turn around decreasing revenue year over year to a constant increase. • Site Search (Hawk Search) - Drove sales by creating a better user experience with boost and bury rules, setting up visitor targets, and merchandising. • Regression - extracted data from SQL database by building a query to use independent variables to predict probability of a purchase ("yes or no"). ? Independent variables' confidence levels are calculated by using R Programming. ? Evaluated over 100 possible predictor variables to include in the recommendation software program. • Skate Platform Design Hypothesis Testing- the goal of this analysis was to compare skate sales as a % to total sales between Total Hockey and newly acquired Player's Bench stores. ? Objective was to find out if the elevated skate platform improves skate sales as a % to total sales.