LiveCareer-Resume

supply chain planning analyst data analyst resume example with 6+ years of experience

JC J S S JS J S S JS J S S JS J S S JS J S S JS J S S JS
Jessica Claire
, , 100 Montgomery St. 10th Floor (555) 432-1000, resumesample@example.com
Summary

Highly analytical and goal-oriented supply chain data analyst with over 6 years of experience in process improvement, supply chain management, database types, procurement, research methodologies, big data capture, curation, manipulation, demand planning, and visualization. Accomplished in developing effective supply chain functions in resource planning, production planning, inventory parameter management, distribution network and project management. Proven track record of identifying cost reduction opportunities, business needs and developing data-driven strategic decision-making solutions to drive business process optimization and implementing change. Possession of great written and verbal communication skills, excellent team player and always eager to add value. Accustomed to working in a fast-paced business environment and successful at managing numerous projects and consistently meeting deadlines under pressure

Skills
  • Python
  • Tableau
  • Power BI
  • Jira
  • Big Data Analytics
  • Teradata
  • SharePoint
  • Google Sheets
  • SQL
  • JavaScript
  • HTML
  • Informatica
  • C++
  • CSS
  • SSRS
  • Redshift
  • Snowflake
  • SAP ERP
  • AWS Cloud
  • SAS Enterprise Miner
  • Minitab
  • Hadoop
  • ETL
  • Qliksense
  • Oracle Data Integrator
  • Microsoft Azure
  • Microsoft office suite (Outlook, Access, Word, Advanced Excel, PowerPoint, Visio, Pivot Tables, Vlookup, VBA, Power Query)
  • Google Analytics
  • Adobe Analytics
  • Master Data Management (MDM)
  • Adobe Experience Manager
  • Supply Chain
  • Procurement
  • Data Visualization
  • Data Quality
  • Data Integration &Mapping
  • Data Warehousing
  • Data Modeling
  • Data Mining
  • Trend Identification
  • Business Intelligence
  • Strategic Planning
  • Process Improvement
  • Agile Methodology
  • Requirements Gathering
Experience
04/2020 to Current Supply Chain Planning Analyst/Data Analyst Ibm Corporation | Lexington, KY,
  • Designed and implemented A/B experiments for products to improve the conversion rate by 21 basis points and reduce churn by 15 basis points.
  • Designed Supply Chain Planning Integrated Platform - one stop shop to provide visibility to SCM Planning, Scheduling, IT Developers, Demand Planning, and Customer Service Supply Chain Team.
  • Utilized predictive analytics to remove redundancies in forecasting models for 25 retail outlets, increasing efficiency and fulfillment rate by 75%.
  • Utilized Power BI to build automated reports and dashboards to monitor performance metrics and presented them to senior executives, directors and other stakeholders.
  • Initiated CSCM cost savings opportunities around case pick, full pallet ordering and internal network optimizations, which led to a significant reduction of wastage by around 2M within a span of 9 months.
  • Analyzed historical data (including transactional, survey, and behavioral) to identify trends and make predictions.
  • Partnered with cross-functional groups to conduct data reporting and analyze gaps across distribution functions, resulting in a 15% improvement to operational efficiency.
  • Created complex stored procedures, triggers, functions, indexes, tables, views, joins and other T-SQL code to implement business rules.
  • Introduced a new data collection system which improved database efficiency by 30%.
  • Evaluated supplier performance and identified and selected 7 new vendors to enhance operations which resulted in a 38% cost reduction for the sourcing & procurement of raw materials.
  • Utilized Power BI for advance analysis actions, calculations, parameters, background images, maps, trend lines, groups, hierarchies, detail level summary report sets, and KPI dashboards.
  • Performed data analysis on supplier performance using ERP software and Advanced Microsoft Excel functions to support process improvement initiatives, which prevented shipment delays for enterprise customers valued at up to $165,000.
  • Developed and reviewed simultaneous SQL queries with the use of join clauses (inner, left, and right) in Tableau desktop to validate static and dynamic data for data validation.
  • Worked with data quality analysts to develop validation rules and data quality scorecards for the material, customer, and vendor domains using SAP information steward which led to a 19% boost in operational efficiency.
  • Used advanced chart visualizations in Tableau such as dual axis, box plots, bullet graphs, treemaps, bubble charts, and waterfall charts to solve complex problems and to create interactive dashboards and visualizations.
  • Created a database and monthly review process that identified $85,000 worth of expired products in 1 year.
  • Developed 85% custom Microsoft Power BI dashboards, visualizations, and interfaces with Microsoft SSRS to deliver meaningful and actionable insights.
  • Built operational reporting in Tableau to find areas of improvement for contractors resulting in $40,000 in annual incremental revenue.
  • Created and managed master data objects ensuring data accuracy and integrity and successful execution in SAP within agreed timelines.
  • Partnered directly with the executive team as the first data hire to formulate and report on KPIs across their web properties that received 3000 visitors annually using SQL and Google Sheets.
  • Created SOP's, training guides, and manuals for SCM planning team to promote job efficiency, proper step by step instructions and guideline on several work processes.
  • Conducted several inventory discrepancy investigations and solved 65% of disparities within 36 hours.
  • Utilized advanced Microsoft Excel, VLOOKUP and XLOOKUP functions to efficiently create pivot tables and pivot reporting.
02/2018 to 03/2020 Data Analyst Time Warner Cable | Industry, CA,
  • Developed complex SQL queries using 21 procedures, including Common Table expression (CTE), to support Power BI and SSRS reports
  • Maintained complete documentation including database libraries, best practices and performance and capacity metrics
  • Conducted business process analysis and identified critical issues, gaps, and needs for an established process center
  • Revised purchase ordering algorithm to minimize overstock and reviewed purchase orders compiled by a colleague, achieving savings of 15% per inventory purchase
  • Performed data cleansing processes to produce analytic data sets for use by a variety of downstream purposes.
  • Developed root cause reports to address problems with customer conversions, successfully revealing insights that boosted conversions by 35%
  • Extracted data for analysis from SAP databases utilizing SQL and wrote complex queries in DB Visualize
  • Worked with company management to ensure mission critical reporting and business intelligence reporting was being developed and delivered
  • Performed over 40 data profiling activities to provide statistics and informative summaries for integration of new source system data
  • Developed, documented, and maintained data quality goals, standards, processes and all data integration of information between internal and external applications
  • Assisted billing unitization group with the closure of 15,000 aged PO's and work order statuses.
  • Conducted professional data mapping, communicated with existing business clients, and participated in weekly team meetings with managers.
05/2016 to 01/2018 Business & Planning Analyst WFCU Credit Union | City, STATE,
  • Inputted SQL queries in the DB2 database to retrieve data during the testing of new technology.
  • Augmented process improvement methods utilizing process maps with Visio which improved efficiencies and led to a $45,000 reduction in operational costs.
  • Anticipated and identified business issues (including performance gaps, opportunities, and emerging needs) for management and developed appropriate action plans to maximize business profitability.
  • Reduced monthly forecast variance from 20% to 4% by thoroughly examining past expenses and collaborating with the budget owners to ensure the most up to date information was incorporated in the forecast.
  • Facilitated requirements gathering sessions to understand and document complex business needs, often eliciting hidden requirements and clarifying vague/unclear requirements.
  • Utilized SAP to gather, export and sort data for Excel and used the information to create over 150 reports.
  • Consolidated multiple departments and division yearly expense logs in preparation for annual year-end accrual packages.
  • Developed Use Cases using Rational Rose, Project Schedule using MS Project, and developed VISIO diagrams and PowerPoint presentations.
  • Performed ETL and multi-dimensional model processing using MS SQL and SAS EG.
Education and Training
Expected in 12/2019 to to MBA | Wayne State University, Detroit, MI GPA:
  • 3.51 GPA
Expected in 06/2015 to to BBA | Finance University of Windsor , Windsor, ON, GPA:
Certifications
  • Google Data Analytics Professional - February 2023
  • Professional Scrum Master I (PSM) - January 2022
  • Certified Supply Chain Professional (CSCP) - in progress

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Wayne State University
  • University of Windsor

Job Titles Held:

  • Supply Chain Planning Analyst/Data Analyst
  • Data Analyst
  • Business & Planning Analyst

Degrees

  • MBA
  • BBA

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: