DATA ANALYST

Accounting & Finance

• 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.

BUSINESS INTELLIGENCE ANALYST

• 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.

Find out detailed information about Marty Gwozdz, DATA ANALYST in Redondo Beach, CA

Marty Gwozdz: DATA ANALYST in Redondo Beach, CA

Marty Gwozdz

UNIVERSITY OF MISSOURI