Venkatesh Rv

Senior Data Analyst

LinkedIn • Fulltime

Aug 2025 - Present • 9 mos

• Creating detailed forecasts for reactive and proactive contact volumes, handling time, shrinkage, and other workforce metrics based on trends and business drivers. • Developing short-term and long-term demand forecasts for Trust & Safety workloads using SQL, Python, and historical patterns. • Building and maintaining capacity planning models to determine headcount requirements and hiring needs. • Enhancing forecasting models by identifying patterns, anomalies, service-level risks, and workload seasonality. • Performing “what-if” scenario modelling to determine operational impact under different staffing or volume conditions. • Using NICE WFM tools to create, optimise, and evaluate reviewer schedules aligned with operational goals. • Monitoring intra-day schedules, queue performance, and staffing gaps to ensure consistent service and SLA adherence. • Managing shrinkage, real-time adherence, and schedule optimisation to drive workforce efficiency. • Developing skill-based routing logic using SQL/Python to direct the right tasks to the right reviewers. • Analysing large operational datasets to identify trends, patterns, and resourcing risks for Trust & Safety teams. • Creating automated dashboards and performance reports in Excel, Google Sheets, Power BI, and Python. • Delivering timely and actionable insights to leadership to improve decision-making. • Organising and maintaining detailed operational data, including SLA performance, response time, hiring, attrition, tenure, and internal transfers. • Improving data accuracy across WFM tools and internal systems through validation and QA checks. • Partnering with Trust & Safety, Operations, Finance, Legal, Product, and Engineering to align capacity plans with business priorities. • Collaborating cross-functionally to refine workflows, tools, and processes for operational efficiency. • Supporting onboarding of new projects or reviewers through forecasting and resource modelling.

Data Analyst - Supply Chain

L’Oréal • Fulltime

Mar 2025 - Aug 2025 • 5 mos

• Analyze Sunrise Power BI reports on ground reserve analysis, obsolescence management reports, and e-commerce re-slotting tools to support warehouse optimization and strategic decision-making. • Develop actionable stock movement reports to optimize picking efficiency by recommending relocation of items from higher to lower racks, based on stock availability and weight distribution across pallets, layers, and cases. • Integrated data from Manhattan WMS to track orders, improve pick/pack efficiency, and visualize stock levels down to individual bins — helping warehouse teams stay on top of daily operations. • Create and maintain inventory Power BI reports and dashboards including aging reports and investigation of inventory discrepancies and reconcile system vs. physical stock. • Built interactive Power BI dashboards to track key supply chain and warehouse KPIs, including hero product performance, active and retained customers, new customer trends, and stock-outs — providing teams with real-time visibility into operational performance. • Used GCP BigQuery to write and optimize SQL queries over large datasets, covering everything from transaction logs to shipment tracking to support faster, data-backed decisions across retail and e-commerce functions. • Build complex SQL queries in Google Big Query to efficiently handle large datasets, performing all data transformations at the source for optimized performance and seamless integration with Power BI, enabling smooth data refresh and minimizing the need for complex DAX. • Identify trends, risks, and opportunities through in-depth data analysis using SQL, recommending strategies to mitigate shrinkage, obsolescence, and excess stock. • Analyze stock data and forecasting trends to optimize inventory levels and identify opportunities for process improvements. • Wrote Python scripts to automate data cleaning, spot anomalies in sales trends, and prepare forecasting inputs. • Develop and migrate Power BI reports to new Manhatt

Workforce Solution Data Analyst

Healthscope

Oct 2024 - Apr 2025 • 6 mos

• Accessing and managing data across multiple internal HR systems, ensuring and compliance with company protocols and maintaining data integrity. • Transcribing and entering high-volume data into Workforce Solutions systems, including UKG Dimensions with precision and efficiency. • Conducted data reconciliation and validation of data to ensure the integrity and accuracy of records. • Developed and extracted data to support operations teams and decision-making accordance with workforce casual utilization using Power Query and DAX functions in Power BI. • Collaborate with business users to create data, queries and views using SQL queries and reports using Power BI, contributing to enhanced productivity. • Redeveloping and redesigning data tables, the data model, and visualizations in Power BI to enhance performance, usability, and insights delivery. • Collected, cleansed, and analyzed workforce data from various sources, including HR systems and surveys. • Preparing the UAT and LIVE production environment and the setup of test data, including any data masking. • Conduct user acceptance testing for the new data, including extensive validations and testing scenarios to ensure data integrity and performance. • Responsible for the development, implementation, and distribution of regular and ad-hoc data reporting. • Worked on MSP, data views, JTS and all job aids on UKG/Kronos Dimensions, ensuring all updates or changes to rosters due to personal leave, shift swap requests, or other unforeseen requirements were actioned. • Leveraged Power Apps & Power Automate to enhance efficiency by automating tasks and streamlining notifications for HR Officers. • Maintaining strict confidentiality and adhering to privacy policies during the handling of sensitive information. • Collaborated on pre and post-go-live phases of a project involving a software triage tool, addressing stakeholders' challenges by developing tailored reports to meet their business requirements and objective