Stuti Singhal

• Developed Tech Ops Daily Business Review Report, Heavy Maintenance Reports automating manual processes and improving reporting efficiency
• Spearheaded cost analysis for damages, enhancing financial oversight driving data-informed discussions with station leaders
• Drove safety reporting by making Safety scorecard for TechOps and CASS Scorecard and automation initiatives, minimizing manual effort and streamlining processes with minimal guidance
• Built a live ATS tool (Available to Schedule Aircrafts) for real-time monitoring, accelerating data access and decision-making
• Led ETR (Estimated Time of Recovery) analyses for OOS aircraft, evaluating events between 4-7 AM, associated cuts, and AC damages
• Conducted deep-dive analyses on cabin workload deferrals
• Conducted Power BI and Power Automate training as part of the Power BI Center of Excellence (CoE) in IKC Brain Trust, fostering a data-driven culture and providing one-on-one support
• Led knowledge-sharing sessions to integrate best practices into BI processes and improve team collaboration
• Provided ongoing support for Line Mx BSC, optimizing KPI reporting to significantly reduce response times
• Modules and technologies involved are:

1) PySpark 2) SQL 3) PowerBI 4) Excel 5) Python

• Worked in Supply, Payouts
• Handled project of payouts which eventually got expanded to Pan India and increased company revenue by 10,00,000 INR
• Did scripting in python and monitored its goodness in SQL in an end to end project that involved placing training order to partners to the tune of 6 lacs aimed at reducing fraud
• Monitoring supply parameters partner through scripting for inventory distribution to partners, stock alignment with inventory and monitoring the funnel goodness in SQL and Tableau
• Sending IVR, push notifications and nudges (SMS) to partners through API’s at relevant stages of funnel to improve partner alignment with the business
• Improving order count by partners moving partners to high demand areas by use of kepler plots and pings analysis in python and sql to increase company revenue
• Partners collecting high COD, placing dummy order to them by use of API’s sending them to hubs saving revenue of more than 5 lacs per month
• Developed dashboards to track Key Performance Indicators (“KPI”) related to revenue supply in marketing involving various logistics parameters
• Automated all the escalations from ground team written on google sheets by reading and writing back to google sheets from python script in real time that benefitted business hugely
• Modules and technologies involved are:

1) Advanced SQL 2) Python 3) Excel and Google spreadsheet 4) Periscope

• Part of the BI team and worked extensively to analyze client needs and develop strategies for meeting those needs more efficiently
• Created visualizations, dashboards, filters
• Helped client in making custom changes on required visualization and reports using filter actions, context filters as per requirement
• Strong experience in using excel including pivots, lookup, formulas in excel to process the data and analyze based on business needs
• Modules and technologies involved are:

1) SQL 2) Tableau 3) Python 4) Advanced Excel

• Projects involved working on NLP and machine learning algorithm over classification problems which involved spam classification on quora questions marking the insincere questions and developing model for the same
• Deployment of model with flask

• Prediction of scores of students based on numbers of hours studied using simple linear regression in machine learning
• Exploring data analysis on IPL matches from 2008-19, in python involving visualization with python libraries

• Involved in various data analytics activities using Excel, Pivots & SQL
• Hands on experience in writing SQL queries to analyze data
• Worked for an e-commerce client in categorizing data based on customer’s responses
• Responsible for providing weekly and monthly navigation and browse reports
• Modules and technologies involved are:

1) SQL 2) Tableau 3) Python 4) SAP, ABAP Development

• Worked on various projects in spatial Interpolation, interpolation of geo-statistical data using QGIS and R language
• Involved in creation of prediction surface for satellite imagery which used concepts of collision detection and avoidance in game theory
• Prediction surface was compared with satellite image and final result was views in QGIS and Tableau
• Worked on SQL, Tableau, Python, R, QGIS