Data Analyst Business Operation

Sabrina Alford

*** * ******** ** ****, Aurora, CO 80017

719-***-****/*******@*******.***

PERFESSIONAL SUMMARY

Proactive, results-driven purchasing professional with a solid track record in managing material needs and controlling inventory costs. Well-versed in operations and business systems that optimize production requirements, data management, customer focus delivery and quality. Special talent for acquiring data from different sources to ensure customer performance and business goals are meet at the highest levels.

SPECIAL ATTRIBUTES

•Well versed understanding of finance, marketing/sales, inventory, procurement, production, and business operation management.

•Strong knowledge of data management policies, procedures and widespread experience with technical tools and applications.

•Communicate with multiple levels of management and end users on technical opportunities.

•10+ years of Data Analyst experience with excellent planning and administrative abilities.

•Collect, understand, and translate business challenges into well-defined technical solutions.

•Strong Communication, customer service and written skills

CORE COMPETENCIES

• Data Analysis Techniques

• Project Management

• Engineering Documentation/BOMs

• MRP & ERP Databases

• CRM Applications

• Ad-hoc Reports Creation

• Problem Identifications

• MS Excel – formulas/dashboard/pivot tables/Macros

IT SKILLS

• Databases: Oracle, SQL Server, SAP

• Business Applications Software, QuickBooks

• E2 Shop Tech, Crystal Reports

• MS Office Suite (i.e. -Excel, Access, Word )

PROFESSIONAL EXPERIENCE

Cooper Lighting Solution, Aurora CO June 2021 – Present

Component Planner/ Buyer

•Prepare and process purchase orders using SAP.

•Maintain and promote strong relationships with vendors, suppliers, finance, quality, engineering, sales, marketing, strategic sourcing, and other internal customers.

•Work closely with internal and external stakeholders in sourcing unique materials, and resolving vendor material shortages, backlogs, quality issues and any other potential schedule interruptions or delivery delays.

•Monitor and ensure vendor implementation of supply chain stocking agreements on a timely basis.

•Develop and execute action on plans to eliminate or minimize risk from the designated supply base.

•Identify and manage annual cost reduction, invoicing discrepancies, inventory reduction and supplier consolidation projects that meet the individual and facility goals.

•Maintain standard work and business processes to manage customer past dues and on-time-delivery in accordance with demand plan, customer orders and internal KPI metrics.

•Provide forecasting reports to supplier and work directly with Commodity Managers to validate supply chain strategies and planning parameters, including vendor stocking programs.

Kloppenberg, Englewood CO July 2015 – April 2020

Operations/Inventory Analyst

•E2 Shop Tech Database Analyst involving all business operations from Purchasing,

sales/CRM, shipping, manufacturing labor-cost, BOMs/Product structures, Routing

operations, MRP/inventory management, and financial reporting.

•Design, create and maintain processes using MS SQL & Crystal Reports to establish

operation reporting and present financial data performance.

•Develop facility operational ad hoc reports which includes End of month/weekly sales,

manufacturing costs and profit margin reporting.

•Train staff members on the new system implementation

•SQL script writing and understanding of querying relational database tables.

•Provide accurate reporting and monitor data flows of multiple systems.

•Meets deadlines and works extremely well as a team member and independently.

•Develop audit queries and cross references that can be used for data analysis, problem solving and operation performance reporting.

Somellera Pro/CPI Communications, Centennial CO August 2014 – July 2015

Payroll/ Accounting Administrator

•Create and submit service completion accounts receivable QuickBooks invoices to various customers for payment.

•Develop, track and report past due open invoices and submit monthly reporting of open orders to service customers.

•Process weekly and bi-weekly subcontractor payroll utilizing QuickBooks application software

Sanmina-SCI Corporation, Colorado Springs/ October 2013 –Jan 2014 Contract

Inventory Data Analyst

•Monitor and problem solve inventory discrepancies daily.

•Generate reports from Oracle 11i exporting them to MS Excel to provide inventory oh-hand and upcoming shortages for customer orders.

•Maintain weekly Supply and Demand Inventory Order reports for weekly status meetings with management.

Siemens Water Technology, Colorado Springs CO April 2013 – August 2013/Contract

Material Planner/ Scheduler

•Scheduled and released work order to production for customer orders and shop floor orders.

•Data analysis utilizing SAP database reporting results utilizing Excel to validate and test data.

•Ordered required material utilizing MRP to ensure material was on-hand as required for current work orders to ensure on-time deliveries were meet to customer due dates.

Cumulus Media Network, Colorado Springs CO October 2010 – June 2012

Assistant Business Manager/Commercial Coordinator

•Assist Business Manager with processing daily Account Receivable and Payable responsibilities.

•Posted all checks and credit card deposits received into the Stratus system.

•Coordinated radio commercial slots to determined times to be aired and quantity per day on radio station purchased.

EDUCATION

•BS in Business Administration University of Phoenix, Colorado Springs, CO – 2004

•AA in Marketing Pikes Peak Community College, Colorado Springs, CO – 1997

Contact this candidate