VINAY GOLLAPALLY
Medak
Summary
Transportation Specialist with expertise in SQL, AWS, data analysis, and logistics operations, optimizing equipment distribution and enhancing operational efficiency.data analytics,ETL Development,ETL Process,data analysis,data extraction.
Overview
3
3
years of professional experience
4
4
years of post-secondary education
3
3
Languages
Work History
Transportation Specialist
AMAZON
09.2021 - Current
- To efficiently meet the demand for non-inventory equipment such as carts, totes, and UPP across North America (NA) and Central America (CA), utilizing diverse data sources and tools
- Managing Internal Data: Utilizing inventory management systems, analyzing usage logs, and maintaining procurement records
- Excel, python and SQL Data Management: Cleaning data, conducting basic analysis, and generating reports
- Routing and Scheduling Optimization: Streamlining delivery routes and schedules using GIS systems and other tools
- Enhanced transportation efficiency by optimizing route planning and scheduling.
- Cross-Functional Team Collaboration: Collaborating with procurement, logistics, and warehouse teams to ensure seamless operations
Education
GRADUATION - MECHANICAL ENGINEERING
BV RAJU INSTITUTE OF TECHNOLOGY
08.2014 - 09.2018
Skills
Amazon Web Services (AWS QuickSight): Expertise in creating dashboards, visualizations, and reports to derive business insightsDaily data extraction and analysis from AWS resources
SQL: Strong skills in querying and extracting data from AWS resources and other relational databasesHands-on experience in writing and optimizing SQL queries for routine and ad-hoc analysis
Python: Proficient in using Python for data manipulation and automationExperience with Pandas for filtering, applying conditions, and data transformationsRoutine automation tasks like VLOOKUP, filtering, and condition-based data segregation using Python scripts
Microsoft Excel: Daily use for data analysis, reporting, and automation of tasks like filtering and applying formulasIntermediate to advanced use of Excel for pivot tables, conditional formatting, and macros
Power BI: Recently started working on real-world projectsLeveraging Power Query Editor for data transformationExperience in creating data models and building dynamic dashboards and visualizations
CHATGPT
Accomplishments
- AWS Cloud Quest: Cloud Practitioner - Amazon Web Services (AWS)
- AWS Cloud Quest: Networking - Amazon Web Services (AWS)
- AWS Cloud Quest: Data Analytics - Amazon Web Services (AWS)
Timeline
Transportation Specialist
AMAZON
09.2021 - Current
GRADUATION - MECHANICAL ENGINEERING
BV RAJU INSTITUTE OF TECHNOLOGY
08.2014 - 09.2018