Chandru S profile photo 1 on Tal

Chandru S

Data analyst @The Indian Garage Co | SQL| Advanced Excel | Power BI | Python | Ex- Amazon |

Bengaluru

5+ years of work experience

The Indian Garage Co.
Dec 20241 yr 8 mosPresent

Bengaluru, Karnataka, India

Developed automated dashboards in Power BI (Returns, Sales MoM/Quarter, Zone/Pincode, Daily Sales, Global Inventory, Top 200 SKU SOH, Discount Impact) reducing reporting time by 70%, improving forecast accuracy by 30%, increasing regional sales by 15%, reducing stockouts by 20%, and boosting replenishment planning accuracy by 25%. Migrated static Excel reports to Power BI and built Excel forecasting models, cutting preparation time by 60% and forecasts from 1 day to 1 hour. Automated e-commerce processes using Python & VBA (catalogue creation, image linking/extraction/renaming, PO consolidation, bulk data cleaning, workflow automation), reducing manual effort by 80–90%, saving 20+ hours/month, and increasing data accuracy to 98%. Designed SQL pipelines, ETL workflows, and complex JOIN queries to unify fragmented multi-channel sales/inventory data, cutting load time by 50%, providing a single source of truth, and improving BI dashboard refresh speed by 40%. make this more robust
Amazon
Feb 20245 mosJun 2024

Bengaluru, Karnataka, India

- Analyzed sustainability metrics, increasing efficiency by 15% through strategic decisions. - Improved data accuracy by 25% and reduced processing time by 40% through large dataset analysis. - Achieved 99.1% process efficiency using Advanced SQL and automated data collection processes. - Reduced errors by 20% by detecting outliers using advanced algorithms and contributed to demand forecasting models. - Increased predictive accuracy by 30% using Python for trend analysis, reducing error rates by 15%. - Created Pivot Tables and dashboards in Excel, and extracted data from Tableau for stakeholder reports. - Developed SQL queries and scripts to extract and manipulate data from multiple sources.
Seamak Hi-Tech Products
Sep 20221 yr 5 mosJan 2024

Bengaluru, Karnataka, India

Managed project documentation and requirements throughout the lifecycle. Conducted cross-departmental analysis supporting finance and market research. Built Power BI dashboards for purchase and sales analysis to optimize procurement data. Used Excel Pivot Tables to study customer behavior and project performance. Automated complex analyses using VBA macros for pivots, formatting, and data extraction. Developed SQL queries to assess risk factors and enable detailed reporting. Applied conditional formatting to highlight critical risk areas. Implemented data validation to ensure clean and accurate analytical outputs
Terra products
Jan 20229 mosSep 2022

Bengaluru, Karnataka, India

- Detailed rebar calculations and steel quantity estimation using Advance Excel. - Created spreadsheets for material takeoffs, cost estimation, and project tracking. - Streamlined rebar detailing processes with Excel Macros, improving accuracy and efficiency. - Accuracy, and efficiency when utilizing Advance Excel for tasks like quantity calculations and schedule management.
Rnc consultants
Oct 20201 yr 2 mosNov 2021

Bengaluru, Karnataka, India

Education

Dayananda Sagar College of Engineering, BANGALORE

Bachelor of Engineering - BE, Civil Engineering

Dayananda Sagar College of Engineering, BANGALORE

20173 yrs2020

Join Chandru and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Chandru S on Tal

Headline

Data analyst @The Indian Garage Co | SQL| Advanced Excel | Power BI | Python | Ex- Amazon |

About

Driven data analyst with a passion for extracting insights from complex datasets. Seeking an opportunity to leverage my analytical skills and contribute to an organization's growth through data-driven decision-making. Eager to collaborate in a dynamic team environment and deliver impactful solutions. Handled the complete plant maintenance like - Preventive, predictive & breakdown maintenance. To maintain optimum inventory, identify discrepancies and provide quick fixes for them. To ensure zero downtime of equipment and implement process improvement initiatives to increase efficiency. And also monitor daily operations related to all utility components. Ensuring that machine availability in proper condition is maintained at minimum cost.

Location

Bengaluru

Work experience

Data Analyst at The Indian Garage Co., Dec 2024 - Present · 1 yr 8 mos, Bengaluru, Karnataka, India, Developed automated dashboards in Power BI (Returns, Sales MoM/Quarter, Zone/Pincode, Daily Sales, Global Inventory, Top 200 SKU SOH, Discount Impact) reducing reporting time by 70%, improving forecast accuracy by 30%, increasing regional sales by 15%, reducing stockouts by 20%, and boosting replenishment planning accuracy by 25%. Migrated static Excel reports to Power BI and built Excel forecasting models, cutting preparation time by 60% and forecasts from 1 day to 1 hour. Automated e-commerce processes using Python & VBA (catalogue creation, image linking/extraction/renaming, PO consolidation, bulk data cleaning, workflow automation), reducing manual effort by 80–90%, saving 20+ hours/month, and increasing data accuracy to 98%. Designed SQL pipelines, ETL workflows, and complex JOIN queries to unify fragmented multi-channel sales/inventory data, cutting load time by 50%, providing a single source of truth, and improving BI dashboard refresh speed by 40%. make this more robust

Data Analyst at Amazon, Feb 2024 - Jun 2024 · 5 mos, Bengaluru, Karnataka, India, - Analyzed sustainability metrics, increasing efficiency by 15% through strategic decisions. - Improved data accuracy by 25% and reduced processing time by 40% through large dataset analysis. - Achieved 99.1% process efficiency using Advanced SQL and automated data collection processes. - Reduced errors by 20% by detecting outliers using advanced algorithms and contributed to demand forecasting models. - Increased predictive accuracy by 30% using Python for trend analysis, reducing error rates by 15%. - Created Pivot Tables and dashboards in Excel, and extracted data from Tableau for stakeholder reports. - Developed SQL queries and scripts to extract and manipulate data from multiple sources.

Project Engineer at Seamak Hi-Tech Products, Sep 2022 - Jan 2024 · 1 yr 5 mos, Bengaluru, Karnataka, India, Managed project documentation and requirements throughout the lifecycle. Conducted cross-departmental analysis supporting finance and market research. Built Power BI dashboards for purchase and sales analysis to optimize procurement data. Used Excel Pivot Tables to study customer behavior and project performance. Automated complex analyses using VBA macros for pivots, formatting, and data extraction. Developed SQL queries to assess risk factors and enable detailed reporting. Applied conditional formatting to highlight critical risk areas. Implemented data validation to ensure clean and accurate analytical outputs

Quantitative Analyst at Terra products, Jan 2022 - Sep 2022 · 9 mos, Bengaluru, Karnataka, India, - Detailed rebar calculations and steel quantity estimation using Advance Excel. - Created spreadsheets for material takeoffs, cost estimation, and project tracking. - Streamlined rebar detailing processes with Excel Macros, improving accuracy and efficiency. - Accuracy, and efficiency when utilizing Advance Excel for tasks like quantity calculations and schedule management.

Site Engineer at Rnc consultants, Oct 2020 - Nov 2021 · 1 yr 2 mos, Bengaluru, Karnataka, India

Education

Bachelor of Engineering - BE, Civil Engineering, Dayananda Sagar College of Engineering, BANGALORE