Ishan Shaikh
Pune
Summary
Highly analytical and scrupulous data analyst with more than 3.9 years of experience in leveraging SQL to extract insights and drive business growth. Skilled in data cleaning, data visualization, and statistical analysis to identify patterns and trends. Experienced in working with large datasets and developing data models to enhance decision-making. Proven ability to collaborate with cross-functional teams and communicate complex technical concepts to non-technical stakeholders and enabled reduced the company’s operating costs by 15%.
Overview
4
4
years of professional experience
Work History
DATA SPECIALIST
PURE KNOWLEDGE SOLUTIONS
06.2021 - Current
- Investigated historical data to extract pointers for the marketing and sales team, this helped increase sales by 19% resulting in US$23k revenue growth and reduce drop-off by 30%
- Identified changes to assortment distribution and marketing, using financial and behavioural analysis that enabled an upmarket service type to better target their customers
- Reduced delays in order delivery by 60% by analyzing order-related data and forecasting upcoming order flow
- Strategized operational capacity according to forecasted demand
- Improved conversion rate by 7% of sample orders and increased throughput (work done/hour) of Senior Editors by 15% by designing an algorithm for order allocation
- Enhanced editor throughput by 20% by recommending strategies based on patterns in data
- Saved over US$5K by facilitating a 45% reduction in customer refunds consequent to corrective action, suggested after investigating refund data on parameters like time and quality
- Refined leave management, especially during peak season, by reporting patterns in employee leave data to all managers and suggesting capping simultaneous leaves at 40% of the team strength
- Optimized report preparation, using Python and SQL, cutting down report generation time by 75%.
OPERATIONS ASSOCIATE
PURE KNOWLEDGE SOLUTIONS
07.2019 - 05.2021
- Guided and manage the company’s end-to-end operations to ensure significant cost savings and optimum resource utilization
- Spearheaded preparation of complex schedules of monthly order flow worth US$100K
- Devised and analyzed performance metrics to identify areas for improvement in operations
- Liaised with freelancers, and vendors to fulfil time and quality obligations
- Established and implemented process improvements to increase efficiency and reduce costs
- Conducted research and analysis to support business decisions and recommendations
- Collaborated with cross-functional teams, including marketing, Sales, and Editing team, to achieve business goals
- Projects
- Drone-enabled food delivery system
- Developed a drone-assisted food delivery system for Bangalore City
- Checked operational and financial feasibility by doing relevant calculations and created an interactive dashboard in Excel to envision various scenarios
- Figured out the new delivery structure that creates better economies of scale over the current delivery structure
- Designed a rollout plan for the new system including the investment schedule
Education
Bachelors of Technology -
VIT
06.2017
Skills
- SQL
- Microsoft Excel
- Tableau
- PowerBI
- Python
- Project Management
- Six Sigma
- Pattern and Trend Identification
Projects
1. Drone-enabled food delivery system
- Developed a drone-assisted food delivery system for Bangalore City
- Checked operational and financial feasibility by doing relevant calculations and created an interactive dashboard in Excel to envision various scenarios.
- Figured out the new delivery structure that creates better economies of scale over the current delivery structure.
- Designed a rollout plan for the new system including the investment schedule
2. DRDO (R&DE)
- Designed and manufactured text fixture for calculating the life cycle of Bush at DRDO (Defense Research and Development Organization, Government of India).
- Examined the life span of Bush by calculating the total rotations with the help of an Excel pivot table and the solver.
3. Swiggy's funnel business case
- Identified decreased hotel occupancy due to factors such as increased rates, negative reviews, and issues with hotel amenities.
- Evaluated factors affecting Swiggy’s order ratings, including inconsistent offers, poor product listings, and delivery discrepancies.
- Decreased operating costs in logistics due to factors such as fuel rate hikes, high transport rates, and limited vehicle capacity.
4. SQL Capstone project on Airline database
- Pioneered an airline database using SQL to store and manage data related to flights, passengers, and reservations.
- Utilized SQL queries to extract and analyze data from various tables in the database, providing insights on flight schedules, passenger demographics, and booking trends.
- Optimized SQL queries to improve performance and reduce query execution time by indexing, avoiding unnecessary joins, and optimizing subqueries.
- Constructed custom reports and visualizations
Affiliations
- Hall of fame receiver for excellent performance, 2019
- Employee of the year, 2020
Timeline
DATA SPECIALIST
PURE KNOWLEDGE SOLUTIONS
06.2021 - Current
OPERATIONS ASSOCIATE
PURE KNOWLEDGE SOLUTIONS
07.2019 - 05.2021
Bachelors of Technology -
VIT
Similar Profiles
Sowmya RSowmya R
Associate Director HR (HRBP) at Aquity Solutions (An Inventurus Knowledge Solutions (IKS) Health company)Associate Director HR (HRBP) at Aquity Solutions (An Inventurus Knowledge Solutions (IKS) Health company)
MAHIDHAR DWIVEDIMAHIDHAR DWIVEDI
Key Account Manager at Quadrant Knowledge Solutions Pvt. Ltd.Key Account Manager at Quadrant Knowledge Solutions Pvt. Ltd.
Shivam AgarwalShivam Agarwal
Senior Manager, Research - Consumer Goods at Benori Knowledge SolutionsSenior Manager, Research - Consumer Goods at Benori Knowledge Solutions
Soumyadeep GhoshSoumyadeep Ghosh
Graduate Engineer Trainee at Air ProductsGraduate Engineer Trainee at Air Products
Pooja Anil SuryawanshiPooja Anil Suryawanshi
Senior Software Engineer at FIS GlobalSenior Software Engineer at FIS Global