Bekzod

Data Analyst Bekzod shomurodov - |- https://www.linkedin.com/AlexSample/ Khorezm,Uzbekistan Skills • • SQL • Python(Pandas NumPy) • Looker studio • Cognos Analytics • Communication • Data Analysis • Data Cleaning • ETL • Data Profiling • Data Normalization • Data Visualization • Relational Databases • Excel (VLookup, Conditional Formatting, Pivot Tables) • Microsoft Power BI Projects Financial data analysis – Personal Project – Urgench, UzbekistanApril 2024 • Finance team lacked real-time visibility into key profitability and cost metrics. • Build an automated dashboard to track KPIs like Net Profit Margin, OER, COGS, and Budget Variance. • Extracted and cleaned data using SQL, Excel, and Python; built an interactive Power BI dashboard with automated refresh and role-based access. • Reduced reporting time by 80%, identified $180K in savings, and improved budget variance by 22%.I was responsible for designing and delivering data-driven financial insights by developing dashboards and reports that tracked and analyzed critical Finance KPIs Cash Flow & Receivables Management Dashboard for Improved Liquidity – Personal Project – Urgench, UzbekistanJanuary 2025 • The company faced delayed payments and poor cash visibility, impacting liquidity and vendor relationships. • Build a dashboard to track Cash Conversion Cycle, Days Sales Outstanding (DSO), Accounts Payable Turnover, and Operating Cash Flow. • Pulled data from ERP using SQL, calculated KPIs in Excel, and built a Power BI dashboard with trends, targets, and alerts for overdue receivables and payables. • Improved cash conversion cycle by 15 days, reduced DSO by 12%, and enhanced cash flow forecasting accuracy. Procurement & Inventory Optimization –Personal Project – Urgench, UzbekistanJune 2025 • Utilized R Studio to perform sentiment analysis on 14,000 tweeter reviews of six major airlines • Performed data cleaning and text analysis to successfully identified the major complaints for each airline • Applied regression and machine learning to produce a final model with an accuracy of 88% and lift of 34% Supply Chain Efficiency & Delivery Performance – Personal Project – Urgench,Uzbekistan July 2025 • The company faced challenges in timely deliveries and inefficient production processes, impacting customer satisfaction and costs. • Build a dashboard to track KPIs such as On-Time Delivery Rate, Average Delivery Time, Production Cycle Time, and Capacity Utilization Rate. • Collected logistics and production data using SQL and ERP exports; transformed and cleaned data in Python; developed an interactive Tableau dashboard visualizing delivery punctuality, production efficiency, and capacity usage. • Enhanced on-time delivery rate by 20%, reduced production cycle time by 15%, and increased capacity utilization by 10% over four months. Work Experience Data Analyst – Data Puls – Urgench,Uzbekistan March 2025 - Present · Analyzed key financial KPIs such as revenue, profit margins, and operating expenses, enabling improved cost control and increasing gross profit margin by 12%. · Created cash flow and liquidity dashboards to track ratios like Current Ratio and Quick Ratio, helping reduce accounts receivable days by 18%. · Streamlined procurement and inventory processes by evaluating supplier performance, inventory turnover, and stockout rates, leading to a 22% reduction in stockouts. · Developed logistics and production efficiency reports tracking on-time deliveries and production cycle times, improving delivery accuracy by 20% and capacity utilization by 15%. · Automated data collection and visualization using Excel, SQL, and Tableau, cutting reporting time by 40% and supporting strategic decision-making across departments. Education High School Diploma Khorezm high school N45,Uzbekistan Graduated: 2026