Lana Saveleva Email & Phone Number

Long Beach, California, United States

• Supported, created and stored QVD files using tiers methodology;• Extracted data from different sources: DWH, ERP, Excel, Access, MySQL Server;• Administered access to applications and information using security rules and section access;• Supported app update schedule, app publishing and system health monitoring using QMC; • Created efficient data models and visualisation, including Set analysis;• Optimized applications to improve performance and data load efficiency;• Supported 50+ applications, developed 25+ custom applications; Developed an app that bundles sales reps face-to-face meetings with customers, analyses their impact on sales with map visualisation of both existing and potential customers. This helped to enhance our marketing strategies and improve customer engagement by 15%.Successfully improved the data loading speed of 12 applications by 19%.

• Maintained, analysed, and calculated the optimum inventory of end product required for uninterrupted supplies to customers across four warehouses; • Analysed the fulfilment of promotional campaigns;• Managed stock maintenance and facilitated forward buying of products from suppliers; Developed and implemented inventory maintenance algorithms for two regions. I automated and transitioned supplies and movements between warehouses to the ERP system.

• Enhanced and maintained existed tools for analysing undershipments, returns, order cancellations, service level analytics; • Provided informational support and training to co-workers on matters of service level analytics; Refined reporting for cancelled orders. Ensured accurate representation of commercial returns and their impact on service level.

Created returns reports methodology from scratch, which was technically challenging due to company’s transition to SAP. Organized and established the process of collecting delivery supervision comments for each unit, developed contacts with other departments, sales teams, warehouses and production team. As a result, the company gained accurate information regarding product returns for the region, along with action plans. This report and work principle were accepted as best practices in the country, leading other regions to adopt the same approach, ultimately reducing returns by 17%.

Data Analysis

Bachelor'S Degree, Logistics, Materials, And Supply Chain Management