Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

Trina Bhattacharjee

Bengaluru,india

Summary

10 Years experienced Data Analyst adept in using Tableau, PowerBI, Python ,Excel , SQL in data collection, exploration and analysis to provide analytical solution to the business. Experience in performing in-depth analysis of information from multiple data sources & provide actionable visual insights like Key Customer Satisfaction, Customer Live chat, Campaign Effectiveness, Funnel reports to management and various teams while being a part of cross-functional domains like Marketing, Customer Service and Insurance projects. Skilled in Analysis & Exploration of data from both on-premises & cloud data warehouse

Overview

10
10
years of professional experience
4
4
Certifications

Work History

Senior Data Analyst

Lowe's
Bangalore
02.2022 - 10.2022
  • Conducted data modelling and statistical analysis to note trends and draw conclusions.
  • Made actionable recommendations based on data trends.
  • Worked on retail in store test & learn projects to help merchants maximize test understanding and minimize risks by quantifying the true incremental impact of an initiative
  • Collaborated with cross-functional teams to ensure timely reporting of the results and ensure right recommendations for strategic initiatives
  • Contributed to data capture, storage and forecast analysis projects.
  • Collaborated cross-functionally with business analysts, developers and testers.
  • Writing and analyzing MySQL queries on Google Cloud console before moving to reporting the Finance partners.

Senior Business Analyst

Akamai
Bangalore, Karnataka
07.2019 - 11.2021
  • Provide, consult, and design analytical support for internal business use cases and executive decision making.
  • Conducted interviews with key business users to collect information on business processes and user requirements.
  • Synthesized business intelligence data to produce reports using Tableau and polished presentations, highlighting findings and recommending changes.
  • Take database reporting needs and turn them into powerful SQL queries that will extract data and compile it into meaningful reports
  • Creation, updating, maintenance of databases using SQL.
  • To document business process by identifying stakeholders requirements.
  • Walkthrough with other Senior Analyst and stakeholders in order to ensure that Analysis/ test case meets its objectives.
  • Attending Stakeholder meetings.

Business Analyst

DellEmc
Bangalore, Karnataka
03.2017 - 07.2019
  • Developed team communications and information for meetings.
  • Handled day-to-day running of customer centric manual reports, ensuring high levels of productivity and progression.
  • Analyzed existing SQL queries to identify opportunities for improvements.
  • Produced monthly Customer Services reports using advanced Excel spreadsheet functions.
  • Created various Excel and Tableau dashboards to assist with pulling metrics data and presenting them to give concise understanding of best placement for needed resources.
  • Maintained existing Tableau applications and designed and delivered new applications.
  • Prepared test plans and test cases based on business requirement documents for testing Tableau Dashboards.

Consultant

Aon Asspl
Bangalore, Karnataka
09.2012 - 03.2017
  • Governance of large insurance & reinsurance placements data placed in SFDC database.
  • Involved in preparation of Test Data , Test Plans , Test Cases based on High level requirements and test analytics data ingestion ETL workflows.
  • Handling Data Analytics projects which focuses on collecting and documenting sales data to support insurance brokers by providing them with meaningful reports.
  • Evaluation and analysis of D&B dataset using Excel V-lookup engineering to support ongoing quantitative research.
  • Produce daily, weekly, monthly, and quarterly reports relating to outcomes based on data analysis for various audiences, including management and marketing.
  • Write Excel VBA macro to automate manual tasks.
  • Performed data munging activity using Excel lookups.

Education

Bachelor of Engineering - Information Technology

Lovely Professional University
Jalandhar

Skills

    Visualization :Tableau, Salesforce ,Google Data Studio, Excel , Advanced Excel

Databases: SQL Server, Oracle SQL Developer, MySQL

Languages : SQL , Python

Tools & Libraries: Jupyter Notebook, Numpy, Pandas, Matplotlib

Cloud: Google Cloud Platform

Others : Pragmatic Product Marketing Training (Foundation & Focus)

Accomplishments

  • Received 2 Akalades( Akamai Award Program) in a span of 2 years for building marketing dashboards.
  • Promoted within a year to a level 7 consultant in Aon Plc.
  • Awarded the Platinum Award for excellence in client value in DellEmc.

Certification

Foundation in Product Management, Pragmatic Institute

Timeline

Senior Data Analyst

Lowe's
02.2022 - 10.2022

Senior Business Analyst

Akamai
07.2019 - 11.2021

Business Analyst

DellEmc
03.2017 - 07.2019

Consultant

Aon Asspl
09.2012 - 03.2017

Bachelor of Engineering - Information Technology

Lovely Professional University
Trina Bhattacharjee