A
Ayan Nisar Khan
About
Detail
Maharashtra, India
Résumé
Jobs
verified_user
0% verified
Data Analyst and EngineerWIN Home InspectionJul 2025 - Current (1 year 1 month)- SAssistant Manager - Data AnalyticsSNV Aviation Pvt Ltd (Akasa Air)Apr 2025 - Jul 2025 (4 months)
- DSenior Data AnalystDelphi Analytics Pvt. Ltd.,Jul 2024 - Current (2 years 1 month)• Leading end-to-end data initiatives and complex projects for e-commerce clients to improve operational efficiency and profitability. • Consulting Ed-tech analytics teams, for database architecture, and reporting • Managing and mentoring teams to design scalable data solutions that enhance business performance. • Hosted and Monitored Python & Flask code as a service to prevent code crashing and data loss. • Resolved the split shipment issue, leading to a cost reduction of 30%, which significantly improved operational efficiency.
- DData Analyst-IIDelphi Analytics Pvt. Ltd.,Jul 2023 - Jun 2024 (1 year)• Provided supply chain insights and post-order analysis to drive operational efficiency. • Executed changelog tracking and automated ETL pipelines to ensure data accuracy. • Researched and deployed webhooks for real-time data integration and streamlining system processes. • Designed dashboards using Superset, Grafana and Power BI for supply chain, inventory and sales reporting. • Optimized storage systems by compressing data and backing up tables to S3, enhancing resource utilization. • Extracted valuable insights through data mining from various platforms, including customer complaints data. • Automated hourly sync of GA4 Clickstream data from BigQuery to DWH, transformed raw data, and created interactive dashboards to deliver acti
- DData Analyst-IDelphi Analytics Pvt. Ltd.,Jul 2022 - Jun 2023 (1 year)• Combined diverse databases into a unified structure, enabling seamless cross-departmental collaboration. • Gained hands-on experience in data cleaning, network security, and data visualization with Power BI and Grafana. • Keen knowledge about parent and child product concept and cross-team data transfer. • Extracting CDC Data by Python. • Working on responsive data cleaning, manipulation, leveraging analytical tools for advanced analytics. • Extracted valuable insights through data mining from various platforms, including customer complaints data.
- DData Analyst InternDelphi Analytics Pvt. Ltd.,Dec 2021 - Jun 2022 (7 months)• Assisted in ETL, ETLT, and ELT processes to enhance data accessibility and availability. • Configured and deployed Docker-based tools for data orchestration, improving system reliability. • Facilitated daily sales reporting through automation, reducing manual effort and improving accuracy.
- NFront-end DeveloperNICHE Advocacy Foundation,May 2021 - Nov 2021 (7 months)• Designed mobile-based features to improve usability and enhance user experience. • Collaborated with back-end developers to improve code usability and troubleshoot issues.
Education
verified_user
0% verified
- GBachelor of EngineeringG. H. Raisoni College of EngineeringJan 2018 - Jan 2022 (4 years 1 month)
Projects (professional or personal)
verified_user
0% verified
- HHolistic Sales Dashboard for E-commerce ClientsOct 2024 - Jan 2025 (4 months)• Developed a unified sales dashboard and report for e-commerce clients across diverse domains like beauty, FMCG, and apparel. • Consolidated key metrics and performance indicators while enabling dataset swaps for adaptability. • Automated reporting processes, reducing manual effort and ensuring consistent, scalable insights.
- EE-commerce OMS Migration to Shared ServerAug 2024 - Sep 2024 (2 months)• Reduced 50 % cost by directing the migration of OMS and backend to a shared server, optimizing server usage, reducing costs, and ensuring data accuracy. • Directed a team to implement real-time webhooks, validate data pipelines, and deploy scalable reporting solutions.
- IInventory View Analysis System (IVAS)Dec 2023 - Jan 2024 (2 months)• Optimized inventory management at 1 place by combining varied datasets into incorporated dataset and crafting spontaneous Grafana dashboards for C-Level Executives, E-Commerce, Retail, and Store Managers. • Spearheaded the development of dashboards for real-time inventory tracking, resulting in improved turnover and reduced stockouts. • Boost client satisfaction and operational effectiveness ideally positioned to expand in the future, with room for more supply chain integration and predictive analytics.
- DDatabase Migration for Enhanced E-Commerce PerformanceJun 2023 - Aug 2023 (3 months)• Improving query retrieval speed 5x by migrating 700 tables and 200 views to a high-performance platform. • Reduced query latency, enhanced data availability, and built a scalable infrastructure for growth.