Aswanth Kayampallath Varijakshan Email & Phone Number

Stockport, England, United Kingdom

Widnes, England, United Kingdom

• Conducted 10+ interviews with stakeholders from different functions and mapped business processes for the development of 2 Power BI dashboards and a data mart.
• Crafted an expansive sale monitoring dashboard, offering insights on strategic development and sales fluctuation.
• Developed a Power BI dashboard to assess order pick and pack efficiency, unveiling inefficiencies via KPIs for process improvements.
• Enhanced BI capabilities through the creation of a strategic data mart, comprehensive data modeling, data migration, insightful data capture suggestions, and database normalisation.

Kochi, Kerala, India

• Orchestrated the end-to-end execution of 9+ analytics projects spanning Inventory, Operations, HR, Finance, Customer Service, Supplier Management, E-commerce, and Procurement within the retail and supply chain sectors.
• Stakeholder Engagement: Spearheaded compelling stakeholder engagement through data training programs and the delivery of data-driven insights with high accuracy to senior stakeholders on a daily basis, prompting a 5x.
• SQL Expertise: Applied SQL expertise to access, transform, and manipulate relational databases. Orchestrated end-to-end ETL pipelines, designed schemas, implemented indexing strategies, and fine-tuned query performance.
• Data Discrepancy: Conducted root cause analysis of data discrepancies, resolving data quality issues and improving overall data accuracy through investigative techniques utilising SQL and Python.
• Mentoring: Guided and mentored 10+ new entrants, facilitating a seamless transition into the data analytics domain while ensuring the successful onboarding to diverse projects.
• Inventory Management: Engineered an advanced inventory optimisation solution with an automated Power BI dashboard. Achieved a 35% reduction in stock out-related opportunity loss and reduced inventory levels by over $4M.

Kochi, Kerala, India

• Standardised analytics approaches and designed 8+ scalable Data solutions/Products leveraging leading practices for ETL, data warehousing, and visualisation.
• Sales Forecasting: Boosted employee morale and trust in sales targets with accurate sales target forecasting and an automated KPI Power BI dashboard leading to an 8% revenue growth in the first quarter.
• Supplier Evaluation: Created a comprehensive supplier evaluation framework resulting in a remarkable 2x monthly increase in backend rebates and improved order fulfilment rate.
• Customer Analytics: Transformed Customer loyalty program, resolving fraud, and implementation of a customised marketing strategy utilising customer segmentation. Achieved a 55% target engagement rate and a $25 higher.
• Price Optimisation: Implemented automated pricing optimisation model using Excel and VBA, driving profit maximisation by 23% with precise pricing strategies, utilising advanced sales forecasting and price elasticity.
• E-commerce Analytics: Propelled E-commerce sales by a remarkable 25%, measured through increased order volumes, by strategically optimising Click and Collect operations, delivery slot management, improving order.

Msc Business Analytics And Bigdata, Distinction

Activities and Societies: Data & AI Society, Sustainability ClubCore Modules: Digital Business Technology & Management || Data Mining &.

Bachelor Of Technology - Btech, Computer Science, 71.8 (First Class)

Activities and Societies: Course representative, Student placement coordinator, Computer Science society