Sales Data

Daniel Diaz-Marta

Dallas, TX 214-***-****; ***************@*****.***;

https://www.linkedin.com/in/daniel-diaz-marta-285188b/

Strengths and Personal Summary

Motivated, driven, growth mindset, analytical professional.

Strong quantitative and interpersonal skills with excellent business and problem solving acumen. Highly adept at operations improvements, detail oriented, big picture thinking, accuracy, and driving growth and cost reductions analyses. Financial impact oriented. SQL (Updates, selects, joins), data mining, data integrity and cleansing, database relationship and no redundancy mindset, advanced excel (Pivot tables, vlookups, nested ifs, index match etc,Master tables), Access, and marketing skills. Able to work with complex and large data sets.

Education

UT Dallas Master’s in Business Analytics Courses (Cost accounting, Ops Management, Marketing, Database concepts, Data Analysis/statistics) (2017- Present)

DePaul University Bachelor of Business Administration (2005-2009)

Coursera: Data Analytics with Tableau (Excel to Mysql)

Certificates: Jim Cline ExcelCEO excel Master guide to Financial and Reporting Analysis certificate

Languages:

Native Spanish Speaker (100% Writing and Speech), Proficient in Portuguese and conversational in French

Professional Experience

Oki Data Dec 2018-Present

Business and Data Analyst

Perform Master data maintenance and created and maintained data integrity

Create purchase projections and constraint reports to determine purchasing escalations.

Improved agility and integrity of Ad Hoc reporting to executives by removing data redundancy and ensuring the right Master data sources for each field

Used SAP R3 Enterprise Operations and Sales Modules for automatic processes and reporting

Sales and Operations reporting using SAP. Sales analytics reporting working as liaison between IT teams and Business teams

Identify and report on constraints for air shipment and expedited requests, develop purchase projections working with Business Units and Supply Chain

Davaco July 2018-Nov 2018

Business Analyst -contract role

Reporting and Master tracker management, and uncovering KPIs for corrective action and process improvements. Assist in A/R and A/P reconciliations. Managed Project tracking using Clearthread ERP and logistics and client data.

Falcon Farms August 2017 – June 2018 Coppell, TX

Sales Operations Business Analyst

Responsible for managing inventory and shipment levels for Texas Costco stores, manage 15 stores. Used thorough analyses for each sku based on historic trends and seasonality to set optimal targets.

Led initial implementation of applying replenishment/Pull supply chain concepts using homegrown ERP and Customer Sales Data. Created master unifying table to be able to sync data across systems and create metrics on store and product performance.

Led rollout of ERP changes for invoicing and customer requests

Exceeded and achieved all goals and benchmarks, grew sales 20% YoY for assigned stores and reduced waste/shrinkage by 40%. Used sell through analysis from different data sources. Reported to and supported sales and merchandising teams. Grew Gross profit YoY for assigned stores by 40%

Perform analyses and propose optimal target reorder levels for all products by looking at sell thru, sales, and supply chain restraints. Negotiate product shipments based on availability.

Designed and reported on key KPI reports such as fill rate affecting store deliveries to improve product availability. Created streamline report based using one single source table and pivot table refreshes to update and report on Line-fill data, up to 50,000 rows of data

Created transportation costing model for use in P&L to load unto ERP for profitability analysis

Contract Role

Reddy Ice and Centrum Medical March 2017-August 2017 Dallas, TX

Special Data project (short term)

Performed Quickbooks reconciliation with bank transactions for tax reporting

Cleaned master data by identifying and reporting on data relationships using Access database queries

Identified and fixed $40K in stuck tickets by performing query between customer and accounting data revealing open tickets

Used access database to work with 80,000 rows of data, and excel to present findings and exceptions

Bowling Proprietors Association of America March 2016 to Jan 2017 Arlington, TX

Data Analyst

Managed Rebate program and all rebate checks to participating members. Served as client-facing analyst for contracts and partnerships

Developed online content based on partnerships and promotions. Updated rebate and customer databases using SQL statements.

Created excel market baskets spreadsheet and ad hoc reports as well as story board presentations to present to potential partners and vendors

Responsible for finding partner alignment opportunities based on purchase data, maintain and grow relationship with 60 vendors

Managed more than 60 partners and contracts, as well as 8500 skus for rebate and pricing agreements

Ensured client satisfaction and mutual benefit of pricing agreements. Performed routine contract reviews

Maintained website content and managed email blasts for the Sysco foods rebate program

Sprayboothsupplies.com May 2015 to March 2016 Dallas, TX

Business Analyst

Responsible for coordination with warehouses and customers to US, Mexico, and Canada.

Create monthly P&Ls and conduct profitability analysis. (Used sumifs, texts to columns, pivot tables) Performed accounting reconciliations.

Resolve customer and vendor issues, maintain great vendor relationship.

Conducted Marketing research, and strategic sales growth plans aimed at bringing back VIP customers that have led to 40% revenue increases MoM. Introduced new product lines resulting in more than 2K revenue per month.

Updated products and Content for better SEO and improved information

Robert Half International, May 2013 to August 2014 Dallas, Texas

Consultant

Projects through Robert Half:

Clickmotive/ DealerTrack Prepared financial metrics for Annual and quarterly reviews

Automated reporting for the Accounting department and improved accuracy by suggesting and applying approved business rules

Reduced costs by 15K/month through extensive reconciliations between billing and production

Worked closely with Sales Team in resolving accounting, billing, and pricing issues. Specifically was responsible for OEM revenue sharing agreement reporting, receivables, and payables

Designed Salesforce reports to capture where check production data and SAP data did match so as to capture process flows for the largest customer group

Led in data compilation and reconciliation data for SAP Data Migration and implementation of >$1.5 Million/ month recurring revenue contracts. This included all accounting related data, reconciled across different systems including Salesforce for a conclusive data load. Worked with various business groups to ensure all data and all contracts were properly loaded into SAP.

Trained team members on SAP Contracts and billing modules. Responsible for reports from SAP for customers.

Daltile (3 Months)

Automated and improved integrity of financial and marketing reporting for rebate program using Access Database queries and excel pivot tables

Excel Function Experience: Countifs, sumifs, vlookups, hlookups, pivot tables, match index, left, right, mid, concatenate etc

Database Experience: Simple and intermediate queries, updates, and joins

Contact this candidate