Sales Lean Six

VENKATA ARYASOMAYAJULA

Email: ********@*****.*** Phone: 980-***-**** LinkedIn: www.linkedin.com/in/venkata-akhilesh

Address: *** ***** ***** *******, *** 200, Lake Mary, Florida, 32746

Summary

Experienced Professional holding a master’s degree in Engineering Management with background in Demand Planning, Logistics and Supply Chain Operation, statistical data analysis and predictive modeling. Major course work includes Business Intelligence and Analytics, Demand Forecasting, Supply Chain Management, Logistics Engineering and Lean Six Sigma.

Experienced working with SAS, ERP Systems.

Ranked among Top 10 in Big DEAL Forecasting Competition using SAS Enterprise Guide

Written and presentation skills with the ability to adapt to new technologies and environments faster.

Education

University of North Carolina at Charlotte, Charlotte, NC Jan 2017- Dec 2018

Master of Science in Engineering Management GPA: 3.612/4

GITAM University, Visakhapatnam, India Jul 2010 – May 2014

Bachelor of Technology in Mechanical Engineering GPA: 7.35/10

Technical Skills

Certifications: Lean Six Sigma (Green Belt), Advanced Excel

Technologies: SAS, R, Tableau, Power BI, SQL

Tools: SAS Enterprise Guide, Enterprise Miner, SAS Coding. SAP-APO, Power BI

Statistical Techniques: Exploratory data analysis, Time Series Analysis, ANOVA, Hypothesis testing, Advanced Excel (pivot table, Macros and VBA), Clustering, Classification, Regression, ARIMA, Neural Networks, Validation.

Professional experience

AZ Tech Technologies, Wilmington, Delaware Feb 2019- Mar 2019

Demand Planning Analyst

Partner with Finance and Purchasing Teams to project, track and control Excess and Obsolete Inventory levels.

Make forecast adjustments based on seasonal products, promotions and discounts.

Propose and implement solutions to improve Inventory accuracy and Tracking.

Analyze multiple sales data sources to more accurately predict new product launch volume expectations

Perform root cause analysis of demand issues and provide permanent resolutions.

Revise planning based on changes coming from both dependent and independent demands as well as from inventory adjustments and Bills of Material corrections.

Determine customer response for new products and price revisions and communicate the same to management.

Provide forecast updates, fill rates to management, inventory and sales teams on regular basis.

Created Ad Hoc Analysis and reporting as required with SKU level performance and forecasting trends.

Ensured that service level goals are met.

Environment: Advanced Excel (VBA & Macros), SQL, SAP-APO, MRP

University of North Carolina, Charlotte, NC Aug 2017 – May 2018

Graduate Teaching Assistant

Assist faculty in developing course plans, instructions, exams, record keeping, and other miscellaneous projects

Mentored students hand out assignments and grade papers

Degree Capstone Project

Obtained a long-term daily forecast of the electric load consumption for the year 2006, employing techniques including SAS Enterprise Guide, Advanced Excel.

Predicted the Load consumption of year 2006, with a Mean Absolute Percentage Error of 2.50%.

Environment: SAS Enterprise Guide, SAS Coding, SAS Enterprise Miner, MATLAB, R, Tableau, VBA, SQL.

M.K. Builders – India

Supply Chain Demand Planning Analyst Jan 2015 – Dec 2016

Review and analyze the Monthly sales and Inventory data, processes and activities to assist in developing recommendations to improve business workflows by using S&OPs (Sales and Operations process)

Conducted monthly capacity and performance analyses to ensure that forecasts and schedules are aligned and integrated with operations, sales, finance and marketing teams.

Created dashboards using key performance indicator (KPIs) such as employee headcount, employee turnover, employee on-boarded, etc.

Automated KPI reports to track purchases, sales and back orders, quality management and discontinued products by building queries to extract and analyze data.

Minimized lead-time by 30% and transportation & carrying costs by building full truck loads.

Life cycle management of existing products, phase in, phase out in the ERP software

Worked with sales and create production plans, to achieve industry-leading metrics, such as on-time delivery, service levels, quality, inventory on-hand, supplier response time

Development and execution of the logistics and distribution strategy to support the strategic growth and profitability of the company.

Collaborated with different cross functional teams from various departments to enhance product life cycle.

Reviewed sales trends and evaluated historical forecast performance.

Forecasted and updated demand information, including ongoing analysis over multiple time horizons to necessary departments of the company.

Participated in the inventory cycle count and audit process to ensure inventory accuracy across the company

Environment: Advanced Excel (VBA & Macros), SQL, SAP-APO, MRP

Supply Chain & Logistics Engineering Management Projects:

Lean Six Sigma

Improved Invoice Processing Procedure at Duke Energy using Lean Six Sigma and Lean Manufacturing.

Conducted Value Stream Mapping, Process Mapping and root cause analysis (Ishikawa diagram) and 6S for investigating the delay in incident’s resolution time averaged 19.08 days

Lean Supply Networks

Optimized Inventory Levels and Kanban Sizes, reduced the ordering Costs for oil filters In Crown Cabs

Reduced inventory Stock outs, JIT (Just in time0

Logistics Engineering and Management

Worked on last Mile Delivery project for Books in University City Area – Charlotte

Have Knowledge on Third Party Logistics(3PL) and warehouse SOPs

analytics Projects:

Load Forecasting

Implemented short-tern & long-term load and demand forecasting using supervised & unsupervised techniques in SAS Enterprise Guide, Excel and R

Improved error accuracy from 10% to 4% in term project

Reproduced "Electric load forecasting with recency effect: a big data approach," journal paper – Tao Hong, Pu wang.

Business Intelligence & Analytics

Performed Predictive Analysis on Organics data set with 22000 records using various decision tress techniques

Implemented Exploratory Data Analysis on a data set containing 44000 records using Logistic Regression and analyzed “t” & “p” values

Implemented Association Rule Mining Technique and analyzed the output based on support & confidence values.

Big DEAL (Big Data energy analytics laboratory) Forecasting Challenge 2018 organized by Dr. Tao Hong, University of North Carolina at Charlotte

Secured rank 10 globally for long term hourly load forecast in first phase of the challenge.

Ranked among top 10 for forecasting Peak hourly demand for the year 2008, using LOGISTIC REGRESSION.

Honors and rewards

Received “Emerging employee of the year” in M.K. Builders

Contact this candidate