Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ganesan B

Senior Analyst
Chennai

Summary

Accomplished Senior Analyst with a proven track record at Lowes Service India Pvt Ltd, enhancing operational efficiency by developing a reporting framework that cut PO aging by 15%. Expert in SQL and Python, adept at data analysis and automation, significantly improving process efficiency. Demonstrates strong analytical skills and a commitment to driving business success through actionable insights.

Overview

5
5
years of professional experience
5
5
years of post-secondary education

Work History

Senior Analyst

Lowes Service India Pvt Ltd
12.2021 - Current
  • Developed a reporting framework and sql logic that decreased PO aging by 15%, enabling optimized prioritization of purchase orders.
  • Designed and developed data pipelines to acquire, clean and process data using Knime /Python.
  • Split Rate Analysis on the items for different Fulfillment Center, RDC and stores. To reduce the number of package count and reduce the Transportation cost and LTR.
  • Market Basket Analysis to understand the customer behavior to improve the inventory strategy.
  • Automation on Ecommerce operations which improved the processes efficiency and saved 8hrs/Week.
  • Focused on various key performance indicators (KPIs) like Resource Rate to enhance the efficiency of fulfilling orders at a specific store rather than obtaining resources from alternative stores.
  • Conducted a Split Rate Analysis for items across various Fulfillment Centers, RDCs, and stores to minimize package count, thereby lowering transportation costs and LTR.
  • Develop an Executive Scorecard to showcase values across various time frames, such as Month-to-Date (MTD), Quarter-to-Date (QTD), and Year-to-Date (YTD).
  • Collaborated with business-unit leaders to identify and prioritize problems.
  • Identified patterns and trends in large data sets and provided actionable insights.

Business Associate

Crown Solution India Pvt Ltd
08.2020 - 11.2021
  • Developed macros to streamline and minimize manual processes involved in updating the report.
  • Create ADHOC queries in SQL based on business requirements.
  • Contributed to projects involving Informatica Power Center (ETL), and created multiple mappings using Mapping Designer which included various transformations including Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter, and Sequence Generator to enhance data processing efficiency.

Trainee Software Engineer

IT Boundaries Technology Solutions
04.2019 - 08.2020
  • Analyzed the current application, collected new requirements, and defined business rules.
  • Used PL/SQL Tables and Cursors to handle large datasets, utilizing bulk collect for efficient mass updates.
  • Created backend application programs, including views, functions, procedures, and packages, using PL/SQL.
  • Conducted unit testing for the module.

Education

Bachelor of Engineering - Mechanical Engineering

St. Joseph's College Of Engineering
Chennai
06.2012 - 04.2017

Post Graduate Program - Data Science And Engineering

Great Lakes Institute Of Management
Chennai
10.2018 - 04.2019

Skills

SQL

Power BI

Knime

Python

Informatica powercenter

Timeline

Senior Analyst

Lowes Service India Pvt Ltd
12.2021 - Current

Business Associate

Crown Solution India Pvt Ltd
08.2020 - 11.2021

Trainee Software Engineer

IT Boundaries Technology Solutions
04.2019 - 08.2020

Post Graduate Program - Data Science And Engineering

Great Lakes Institute Of Management
10.2018 - 04.2019

Bachelor of Engineering - Mechanical Engineering

St. Joseph's College Of Engineering
06.2012 - 04.2017
Ganesan BSenior Analyst