Consultant, Supply Chain Analyst/supply Chain Management Dept Resume
SUMMARY:
- Trained staff and clients on new marketing technology upgrades and business procedures; saved up to $15,000 on corporate consultant’s fees and materials
- Management upgrade and development of websites for businesses needing to improve e - commerce presence; marketing and sales improved on average of 23 to 55 percent
- Reduced technology spending by 25 percent; saved over $150,000 because of partnering with valued added suppliers and negating annual pricing contact; an approximate estimate cost savings of $27,000 because of effectively motivating, persuading, and influencing suppliers in conflict resolution issues (litigation resolution)
TECHNICAL SKILLS:
Technology and Tools: Microsoft Office Suite Applications - Highly Proficient (, New Horizons Computer Learning Center) MS Access, MS Excel (Macros, V Lookup, H Lookup, MS Project, Crystal Reports - Advanced Visio, Word, PowerPoint, Adobe Photoshop, SharePoint, Visio SAP, Oracle, Made 2 Man, SQL Queries Fully Trained - MRP ERP SAP, JD Edwards relational databases Familiar with Agile and Scrum Methodologies Lean Management, Kiazen, ISO, GMP, FDA Compliance, SOX, HIPAA Laws & Regulations, Six Sigma Familiar Strong analytical, conceptual thinking, and problem-solving skills
PROFESSIONAL EXPERIENCE:
Confidential
Consultant, Supply Chain Analyst/Supply Chain Management Dept
Responsibilities:
- Provided analysis of data for various Operations Team Senior Management; executed research and provided analysis using Advanced Excel, pivot tables, V-lookups, MS Access, SharePoint; used SQL queries for reporting of large data sets
- Assisted with recommending improvements, document processes, data validations and relationship management; weekly meetings and collaboration with cross-functional departments; maintained Dashboard and SharePoint data libraries
- Communicated to Confidential ’s internal and external stakeholders, cross functional teams, executive team, and program managers as the first line of communication for new product development projects / reporting
- Delivered supply chain data analyst reporting for all on-line orders and supplier orders for on-time delivery, possible back orders, inventory levels, fill rate (used SAP, Advanced Excel, Tableau)
- Supported Supply Chain Department in the following areas: purchase order entry and placement with Suppliers, internal and external processes and reporting to dashboards, gap analysis
- Supported process improvements for metrics reporting; updated information in master data; ad-hoc analysis
- Provided process support to internal customers and stakeholders
- Served as the liaison between the business units, technical teams, and third-party vendors
- Served in a functional role and gathering requirements and used documentation skills
- Created presentation of data reporting in MS-PowerPoint; gave weekly presentations to Operation Executives, Department Manager, Program Managers and Project Managers
- Assisted Supply Chain Management to qualify new suppliers for FDA regulations / cGMP / ISO standards
- Forecasted goods and materials need for capacity planning, demand planning, expediting production orders
- Used Project Management skills to keep assigned projects on-time, on budget and within scope
- Used SQL query for reporting of data of material management and inventory levels
- Used Tableau-based dashboard; gathered data from several data sources including Supply Chain and Finance; business analysis of supply chain-related activities (plan, make, deliver), including on-time performance and sales
- Used data to analyze corrective actions for delivery dates, identify process improvement opportunities
- Reviewed dashboard results with Senior Program Managers to analyze data trends
- Assisted and helped to developed existing business processes and cross-department interactions
- Worked with business leads and SMEs to understand and document current state, the challenges that exist within the operational infrastructure, including identification of business and technical gaps
- Used knowledge of production processes, quality control, costs and other techniques for maximizing the effective manufacture and distribution of goods
- Used knowledge of business and management principles involved in strategic planning, resource allocation, and production methods
- Used knowledge of Visual Basic and SQL to run weekly reports with Tableau
- Reviewed project plans to assist and escalate issues to Sr. Project Managers to stay on schedule while using OmniPlan
- Reviewed project plans to plan and coordinate project activity; managed backup, security and user help system
- Consulted with users, management, vendors, and technicians to assess computing needs, requirements
- Assisted with department heads, managers, supervisors, vendors, and others, to solicit cooperation, and resolve problems; managed and analyzed global sales orders while managing KPI Dashboard, Fogbugz Trouble Tickets, Issue Resolution and SLAs with service providers
- Demonstrated strong issue resolution with stakeholders, customers, and cross-departmental managers
- Assist with meeting facilitation for SDM and SDE conference meetings to improve business processes; mapped new business procedures in MS-PowerPoint; tracked project updates in OmniPlan
- Use Advanced Excel for spreadsheets, charts, graphs, and tables, macros and pivot tables
- Use Tableau Dashboard and Z View for business analytics and analysis reporting
- For more effective supply chain and effective marketing strategies Increased sales, decreased costs
Confidential, Costa Mesa, CA
Business Analyst/Data Analyst
Responsibilities:
- Acted as subject matter specialist for analyzing medical and other health
- Assisted Program Managers / Sr. Project Managers in Health Management Services department
- Performed analyses of client data stored in data analytics warehouse
- Communicated findings to the Health Management Services senior management
Confidential, Yorba Linda, CA
Business Analyst/Associate Project Manager
Responsibilities:
- Provided project management leadership for digital marketing solutions and analytics; enterprise analytics solutions; managed supply chain and marketing vendors; provided business analytics and business requirements
- Used enterprise analytics solution Tableau; such as, reports, dashboard, data mining and reporting
- Managed projects from initiation through product launch by planning and managing project schedules (Gantt charts), budgeting, and resourcing and identifying areas of project risk.
- Influenced multidisciplinary project teams to achieve maximum performance and efficiency; anticipated, escalated, and mitigated risks throughout the life cycle of the project
- Generated technical documentation, meeting notes, status reports, and presentations on behalf of the project made oral presentations to key stakeholders across the organization and company leadership.
- Used tag management for web sites and mobile apps; maintained analytics and marketing campaigns
- Managed work across projects and programs to influence, lead, identify issues and expedite solutions to common conflicts; demonstrated excellent mediation and facilitation speaking ability
- Primary responsibilities included: project management, scope definition, risk identification, methodology and resource allocation and meeting facilitation using Agile and Waterfall practices
- Used Advanced Excel to use data analysis to show performance of key suppliers and vendors
- Lead team in quality control and data analysis with large data sets in order to make key analytical business decisions and giving presentations to team and management
- Used Visio to draw business mapping processes and organizational charts
- Supported multiple customer projects simultaneously to meet customer and expectations; ensured project deliverables are on time, within budget and at high standards of quality
- Adhered to corporate policies and regulations; engaged in collection of process and impact metrics, in addition to other project management activities; established strong partnerships with team members, and internal cross-functional stakeholders in order to support the implementation of best practices and process standardization
- Coordinated the delivery of multiple projects, developing cost benefit analyses for the program
- Demonstrated self-motivation, good organization, strong innovation and facilitation / public speaking skills