Summary
Work History
Education
Skills
Awards
Timeline
Generic

Mamatha Subrahmanya

Data Analyst
Bangalore

Summary

Analytical and business-focused Data Analyst with over 12+ years of experience in Retail, Merchandising, and E-Commerce analytics. Proven expertise in designing enterprise BI solutions, developing scalable semantic models using LookML, and building executive dashboards in Microsoft Power BI, Looker Studio Pro. Experienced in translating complex data into actionable insights that drive revenue growth, inventory optimization, and vendor performance improvement.

Work History

Analyst

Lowes India
10.2022 - Current
  • Managed enterprise item and vendor product data within the data warehouse, creating dashboards and reports to support merchandising strategy and cleanup initiatives.
  • Designed and implemented scalable semantic models using LookML, standardizing KPIs, and ensuring metric consistency across business units.
  • Rebuilt and optimized dashboards in Looker Studio Pro, enhancing performance, usability, and near-real-time reporting capabilities.
  • Led enhancements to vendor and product reporting processes, improving data accuracy, visibility, and decision-making efficiency.
  • Migrated legacy workflows from Alteryx to KNIME, reducing annual licensing costs, while maintaining operational efficiency.

Intern

Lowes India
05.2022 - 09.2022
  • Developed and implemented process automation solutions using Python and VBA, improving operational efficiency, and reducing manual effort.
  • Built automated reporting solutions using Python (win32com.client) to streamline email distribution and report delivery.
  • Designed and developed interactive dashboards in Microsoft Power BI to support data-driven decision-making.
  • Built scalable data pipelines using KNIME and Alteryx, ensuring efficient and reliable data processing.

System Analyst

Mahindra Retail
07.2015 - 01.2017
  • Converted data into actionable insights using MySQL and advanced MS Excel.
  • Developed and managed metrics, dashboards, and reports on NanoBI, a business intelligence tool.
  • Collected, analyzed, and generated reports for promotional products and fraud analysis.
  • Integration of eCommerce transactional data into a Business Intelligence application.

Trainee BI Developer

Target Corp Pvt. Ltd
01.2013 - 12.2013
  • Prepared, developed and tested reports according to the requirement using Webfocus, Ms Excel.

Sr. Merchandising Specialist

Target Corp Pvt. Ltd
04.2010 - 12.2012
  • Responsible for maintaining the items on Target systems (PRISM) as per vendor requirements and auditing the online launched items.
  • Automated part of merchandising process using excel macros, VBA and QTP - Quick Test professional which made to earn the ‘Annual Innovation Award’.
  • Involved in UAT testing and functional testing.

Programmer Analyst

Anagha Technologies Pvt Ltd.
04.2007 - 02.2008
  • Interacted with web design team to get the required design.
  • Involved in designing, updating the web pages using asp.net according to the client requirement.
  • Modified and Debugged the vb.net code.
  • Tested the webpage, logics and sql server queries.

Consultant

Symphony Services
10.2004 - 03.2007
  • Worked on IRI data using Workbech tool.
  • Classifying, analyzing and reporting new products to the clients using mainframe application Guts.
  • Designed, developed and tested new stub (database) according to the spec logics.
  • Compared the data using Excel macros.

Education

BE - Electronics and Communication

PES College of Engineering Mandya
Bangalore, Karnataka
06.2003

No Degree - Data Science

International School of AI And Data Science
Accredian
04.2001 -

Skills

SQL

GCP – BQ, Looker Studio, LookML

Python (Pandas, Numpy)

Microsoft – Power BI, Excel (Vlookup, Formulas), Macros/VBA

Alteryx, Knime

Bigdata - Hadoop/Hive

Awards

Innovation Award 2011 by Target: Saved one human resource by automating part of merchandising process using Macros, VBA, QTP

Timeline

Analyst

Lowes India
10.2022 - Current

Intern

Lowes India
05.2022 - 09.2022

System Analyst

Mahindra Retail
07.2015 - 01.2017

Trainee BI Developer

Target Corp Pvt. Ltd
01.2013 - 12.2013

Sr. Merchandising Specialist

Target Corp Pvt. Ltd
04.2010 - 12.2012

Programmer Analyst

Anagha Technologies Pvt Ltd.
04.2007 - 02.2008

Consultant

Symphony Services
10.2004 - 03.2007

No Degree - Data Science

International School of AI And Data Science
04.2001 -

BE - Electronics and Communication

PES College of Engineering Mandya

Similar Profiles

CREATE PROFILE
Mamatha SubrahmanyaData Analyst