Data Engineering

SAI HARSHA HANUMOLU

***** ******* *****, *** ***** Mobile: 269-***-**** Farmington Hills, MI 48335 Email: ******.**********@*****.***

SUMMARY:

Proficient in using SAP Warehouse management, Pro-model, Tableau.

Profound experience in developing and implementing logistic concepts in a fast-paced environment

Good working experience with data analysis skills and advanced knowledge in MS Office suite.

Strong multitasking skills and ability to work in a team environment.

Very hard working, eager to learn, flexible and highly adaptive mindset to changing needs.

EDUCATION:

Master of Science: Manufacturing Engineering – Western Michigan University; USA

Bachelor of Technology: Mechanical Engineering – Nagarjuna University; India

CERTIFICATION:

Six-sigma green belt certification - Institute of Industrial Engineers

ENGINEERING EXPERIENCE:

Network Analyst July 2018 – Present

UPS Supply Chain Solutions Dearborn, MI

Developed supply chain simulation application using Pro-model.

Worked with logistics service providers for quotations and contract renewals.

Provided network analysis to assist in contract negotiations and tracking actual versus planned vehicle shipment.

Created tableau reports and provided user support and training.

Maintained inventory standards for vehicle ramps present at 11 production plants of Ford.

Developed and published weekly and monthly Key performance indicators related to freight and freight service providers.

Assisted with expedited shipping of all types of fleets including cars, trucks, SUVs, and vans.

Managed the collection of data and created inventory/transit reports for Ford Motor Company North America vehicle assembly plants.

Proactively planned and implemented cost saving programs resulting in a prospect of $500K.

Logistics Planner June 2017 – June 2018

Brose Fahrzeugteile GmbH & Co. Warren, MI

Communicated with suppliers for scheduling shipment and receipt of goods.

Updated work instructions for the logistics team on production floor to standardize procedures and to facilitate training.

Created and maintained Kanbans for movement of materials within the production facility.

Created special spreadsheets to be able to upload information quickly and accurately.

Obtained proficiency in using several SAP transactions on a regular basis for production planning and warehouse management.

Scheduled and monitored 5S audit and maintained documentation for audits.

Supported material Planners in creating shipment schedules and answering tickets.

Participated in the annual inventory audit for the plant.

Changed rack layouts to utilize space in an effective and ergonomic manner.

Maintained IDEAS suggestion system and KPI data.

Data Analytics Intern April 2016 – May 2017

Soft Solv Inc Livonia, MI

Involved in application of statistical analysis methods and construction of explanatory and predictive visualizations to drive the decision-making process.

Performed statistical analysis of the reports developed using Mini-tab and Tableau.

Forecasted Data Trends using MS Excel VBA and Oracle Crystal ball.

Involved in identifying data relationships and finalizing the technical specifications of source-target mapping documents.

Created complex and compound calculations to large, complex data sets.

Created Dashboards with interactive views, trends and drill downs.

Designed and developed various analytical reports on a single worksheet in Tableau.

Contact this candidate