T G Jai Sai
Bengaluru
Summary
Logical Data Analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with 3 years of vast experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.
Overview
3
3
years of professional experience
Work History
Data Analyst
Dil Foods
Bengaluru
03.2023 - Current
- Established foundational technology infrastructure for the company by initiating and organizing the data storage system from the ground up, ensuring efficient and secure data management for optimal business operations.
- Implemented weekly automated payout system for restaurant partners using Python and SQL, optimizing efficiency through scheduled cron jobs to streamline financial processes
- Developed a robust gravy projections ARIMA model by leveraging order data from Swiggy and Zomato, enabling accurate forecasting and enhancing operational efficiency in the preparation process
- Recognized the significance of utilizing final data for informed decision-making during discussions, contributing to more effective and data-driven decision-making processes.
- Constructed efficient analysis dashboards using Metabase and SQL, facilitating swift access to critical data for accelerated decisionmaking and insights.
- Restaurant Partner Dashboard: Led the creation of a dynamic dashboard, providing restaurant partners with real-time insights into their orders analytics.Designed a user-friendly interface with customizable filters, allowing partners to efficiently monitor order details and analyze financial performance.
- Developed SQL queries to obtain complex data from tables in onsite and remote databases.
- Defined and documented system specifications for data capture, storage and analysis activities.
Data Analyst
Medisage e-learning private limited
Bengaluru
05.2022 - 03.2023
- Analyzing data using statistical techniques providing reports and monitoring user behaviour using Clevertap.
- Collected, organised and input information into databases for storage.
- Analysed operational improvements against KPIs to measure progress
- Understanding the business logic and writing queries in SQL.
- Monitoring data performance: You would need to monitor data performance to ensure that data is accurate, complete, and up-todate.
- Filtering and cleaning data with the help of Python(Pandas).
- Assist the board of directors in making decisions with data-driven solutions.
- Maintain pipelines from database to data warehouse
Procurement Analyst
Delphi TVS Technologies
Chennai
01.2021 - 12.2021
- Conducting research on market trends, supplier capabilities, and pricing to identify opportunities for cost savings and process improvements.
- Identifying potential suppliers, negotiating contracts, and maintaining relationships with key suppliers to ensure timely delivery and quality of goods/services.
- Analyzing procurement data to identify patterns, trends, and areas for improvement. This includes tracking spending, monitoring supplier performance, and identifying cost-saving opportunities.
- Identifying and mitigating risks in the supply chain, such as supplier disruptions, price fluctuations, and quality issues. This may involve developing contingency plans and monitoring supplier performance closely
Education
IIT M Certified Professional in Advanced in Data science -
GUVI
Chennai02-2021
Bachelor of Commerce - Corporate Scholarships
SRM Institute of Science And Technology
Chennai 04-2020
Skills
- MYSQL
- Python
- ETL Apache Airflow
- Power BI
- MYSQL
- Excel/Google Sheets
- Data Visualization
- Tableau
Accomplishments
- Implemented Predictive Analytics Model:
Timeline
Data Analyst
Dil Foods
03.2023 - Current
Data Analyst
Medisage e-learning private limited
05.2022 - 03.2023
Procurement Analyst
Delphi TVS Technologies
01.2021 - 12.2021
IIT M Certified Professional in Advanced in Data science -
GUVI
Bachelor of Commerce - Corporate Scholarships
SRM Institute of Science And Technology
Similar Profiles
Pavan Kumar A RPavan Kumar A R
Production Manager at Dil Foods Pvt LtdProduction Manager at Dil Foods Pvt Ltd
Wisdom NdlovuWisdom Ndlovu
Native English Teacher at Dil Akedemi MerkezNative English Teacher at Dil Akedemi Merkez
Antony AshilyAntony Ashily
General Manager – Operations | South at DIL (KFC)General Manager – Operations | South at DIL (KFC)
HARISH VADLAMANIHARISH VADLAMANI
Consultant at Affine AnalyticsConsultant at Affine Analytics
Srikanta K NSrikanta K N
Senior Python Developer / AI Integration Engineer at Wipro LTD (Daimler-AG Project)Senior Python Developer / AI Integration Engineer at Wipro LTD (Daimler-AG Project)