Summary
Overview
Work History
Education
Skills
Awards
Certification
Timeline
Generic

Amith G M

Senior Data Analyst/Senior BI Analyst
Bangalore

Summary

  • 6.2 Years in a corporate working environment which involves analyzing data, generating insights, creating and automating reports using Power BI, delivering ad-hoc requests, creating Dashboards and retrieving data from the Databases.
  • Develop integrated marketing plans and strategies for customer analytics and Retail loyalty program.
  • Create and optimize processes to make business evolve better.
  • Acquisition and analysis of data to give actionable insights and use algorithms to provide key insights.
  • Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
  • Managed data integrity and was involved in development of MDM of dimension tables.
  • Good knowledge of Azure Synapse Analytics,SQL and Python for Data analysis.
  • Excellent Knowledge of reporting tools like Power BI(Data-flow, Tabular Editor, and DAX) and Data management techniques.
  • Strong verbal and written communication skills.

Overview

6
6
years of professional experience
1
1
Certification
3
3
Languages

Work History

Senior Data Analyst(Team Lead)

M H Alshaya
05.2023 - Current
  • Supported strategic planning initiatives by providing insightful analysis of key performance indicators and trends.
  • Managed ecommerce strategic planning, reporting and data maintenance.
  • Built ecommerce data journey road map and managed stake holders expectations by planning the work priorities(product timeline).
  • Implemented data governance policies to ensure data security and reduce data quality issues(15 percent).
  • Built pipelines in azure(Synapse Analytics) to bring data from various different sources(S3 bucket, Oracle, SQL DB, Rest API).
  • Maintained and debugged pipelines in Azure Synapse Analytics to ensure seamless ETL of the data.
  • Built complex semantic models in Power BI using SQL capabilities(CTEs), which acts as self service model/ cube.
  • I have conducted various analyses, including cross-brand analysis and market basket analysis
  • Presented findings and recommendations to senior management to guide strategic planning and decision-making.

Senior Data Analyst

PVH
04.2022
  • Created dashboards for various domains within the organization and maintained those dashboards
  • Leveraging cutting-edge algorithms to produce customer insights driven by data
  • Examined the data for data integrity and connected with third-party vendors to make sure all the necessary checkpoints for data integrity are in place, resulting in a cleaner database
  • Worked exclusively on challenging initiatives like the Female Customer Journey and the Female Youth Customer Journey (Cross division purchases, first to second purchase)
  • Worked in conjunction with the marketing team to assess the loyalty program and determine its efficacy utilizing the data
  • The organization was presented with a new structure and loyalty program employing a data-driven approach
  • Developed and updated dataflow, additionally, the division's Power BI gateway was hosted and maintained.

Data Analyst

M H Alshaya
12.2020 - 03.2022
  • Worked on generating data-driven customer Insights using advanced analytics for several brands under M.H Alshaya's portfolio including Starbucks, Debenhams, American Eagle, Mothercare, H&M, The Body Shop, and devising end-to-end customer lifecycle marketing strategy
  • Developed and maintained dashboards from scratch for various areas within the organization (customer service, clothing, food, hospitality)
  • Generating data-driven customer insights using advanced algorithms
  • (RFME, MBA, Cluster Analysis)
  • Responsible for identifying trends, opportunities, and preferences using transaction-linked data
  • Built(clean data and insights) and worked on high-level projects such as carbon footprint analysis, customer profiling, and sentiment analysis
  • Analyze cross-brand sales opportunities that are non-branding conflicts
  • Segmented customers based on different parameters for executing campaigns and delivering customer insights based on customer loyalty data
  • Create, maintain and manipulate the data flow in the Power BI service.

Business Support(Compliance)

Amazon India
05.2018 - 11.2020
  • Retrieve data from the database using SQL to allocate work among peers and make business-driven reports
  • Analyze data above 3 lakh product catalogues and develop solutions or suggest automation based on the analysis report
  • Built monthly dashboards as per business needs using tools such as Microsoft Power BI
  • Publish a WBR report and Productivity report on a weekly/daily basis
  • Perform RCA(root cause analysis) for escalations and prepare 5Y reports as required by the organization
  • Create analysis reports (Deep dive) required by higher management for metrics management
  • Creating models that optimize the resources, inputs & outputs of Compliance operations
  • Provide guidance to Fulfillment centres on hazmat classification and configuration issues
  • Responding to stakeholders with guidance and flagging any updates to the Lead/Manager.

Education

MBA(Project management) -

Symbiosis(Distant Learning)
Pune, India
07.2020 - 2022.05

Mechanical Engineering -

Jawaharlal Nehru National College of Engineering
Shimoga, Karnataka
03.2012 - 2016.05

Skills

Excel/Advanced Excel

undefined

Awards

  • Won above and beyond award for the clash project(Amazon).
  • Employee of the month award(M H Alshaya).
  • Received praise from different stakeholders for exemplary work(Customer service & central operations).

Certification

Certified Power BI data analysts - PL 300

Timeline

Senior Data Analyst(Team Lead)

M H Alshaya
05.2023 - Current

Senior Data Analyst

PVH
04.2022

Data Analyst

M H Alshaya
12.2020 - 03.2022

MBA(Project management) -

Symbiosis(Distant Learning)
07.2020 - 2022.05

Business Support(Compliance)

Amazon India
05.2018 - 11.2020

Mechanical Engineering -

Jawaharlal Nehru National College of Engineering
03.2012 - 2016.05

Similar Profiles

CREATE PROFILE
Amith G MSenior Data Analyst/Senior BI Analyst