Agrata Mehta

Data Analyst Executive at Manhattan Communications India Pvt. Ltd
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Chandigarh, Chandigarh, India, IN
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Excel: Managing and Analyzing Data
    LinkedIn
    Oct, 2023
    - Nov, 2024

Experience

  • Manhattan Communications India Pvt. Ltd
    • India
    • Advertising Services
    • 1 - 100 Employee
    • Data Analyst Executive
      • Jun 2021 - Present

      * Experienced in Advanced Excel & Google Sheets - providing results using VLOOKUP, validation, filter and sorting techniques * Create multiple Times at required interval using formulas such as RAND, UNIQUE, INDEX etc * Hands on experience in SQL queries and ETL Process * Creating dashboards in Google Analytics and reports using Google Data Studio (Audience reports, Real Time reports, Acquisition reports and Behaviour reports) * Experienced in using MS Office and Google Docs * Experienced in Advanced Excel & Google Sheets - providing results using VLOOKUP, validation, filter and sorting techniques * Create multiple Times at required interval using formulas such as RAND, UNIQUE, INDEX etc * Hands on experience in SQL queries and ETL Process * Creating dashboards in Google Analytics and reports using Google Data Studio (Audience reports, Real Time reports, Acquisition reports and Behaviour reports) * Experienced in using MS Office and Google Docs

  • SourceMash
    • India
    • IT Services and IT Consulting
    • 100 - 200 Employee
    • Data Analyst
      • May 2019 - Aug 2019

      * Involved in planning, defining and designing database based on business requirements and provideddocumentation * Responsible for optimising indexes, SQL queries, stored procedures to improve the quality of software * Designed SSIS Packages to transfer data from flat files to SQL Server using Business IntelligenceDevelopment Studio * Used SSIS transformations such as merge, conditional split etc. to generate SSIS ETL Solution * Used MS Excel to create Pivot Tables as well as used VLOOKUP functions * Experienced in Salsify - A Product Experience Management Platform * Hands on experience to extract data in a variety of ways and across multiple visualisations usingPower BI Show less

  • Interface Education LLP
    • Gurgaon, India
    • Reporting Analyst
      • Nov 2014 - Feb 2019

      * Designing work database based on business requirements and provided documentation * Involved in planning, defining and designing employee database * Used MS Excel to create Pivot Tables as well as used VLOOKUP functions * Used MS Excel to create Visual Reports and presenting them to Management * Designing work database based on business requirements and provided documentation * Involved in planning, defining and designing employee database * Used MS Excel to create Pivot Tables as well as used VLOOKUP functions * Used MS Excel to create Visual Reports and presenting them to Management

Education

  • Panjab University
    Master of Business Administration - MBA, Computer/Information Technology Administration and Management
    2013 - 2015
  • Maharishi Markandeshwar University, Mullana
    Bachelor of Technology - BTech, Computer Science
    2009 - 2013

Community

You need to have a working account to view this content. Click here to join now