Amrita Upadhyay
Data Analyst
Mumbai,MH
Summary
Data driven and detail oriented Reporting Analyst with 5+ years of extensive experience and comprehensive background in collecting and analyzing data, reviewing reports and developing new data analysis processes and procedures.
Overview
5
5
years of professional experience
2
2
Languages
Work History
Associate
Kinesso – IPG Media Brands
Mumbai
09.2020 - Current
- To handle and integrate large volume of Digital Marketing data from various sources across different channels such as Social, Display & Search
- To Create and Automate reports on digital marketing data with help of BI tools like, Alteryx, SQL Server, Advanced Excel .
- Structuring and Classification of data with help of using Input data, Output data, Data cleansing, Filter data, Formula in-order to update huge data and building end to end workflows for same with help of Alteryx
- Completing, maintaining and troubleshooting extract, transform, and loading functions using Alteryx and SQL Server
- Debugging existing workflows and resolving errors with help of using Summarize, Tool Container and Macros to optimize processes
- Established reports with help of tools like Select, Date &Time, Transpose, Union, Cross-tab and Joins while Orchestrating Alteryx workflows
- Developing automations for ETL of large and complex data sets, including conducting quantitative and qualitative analyses of various data sets , integrating and merging data sets, and have performed manipulations of data using tools like Python, SQL, Alteryx and Tableau
- Experience in extraction of data from various AD-Tech Systems such as Unified, Innovid, Atlas, DCM, 4 C Insights, Facebook Business Manager, Pinterest and Snapchat
- And to provide insights and recommendations to form strategic planning
- Deal with social and digital campaign measurement to translate insights regarding strong analytical thinking that leads to campaign effectiveness
- Collaborating with internal or external stakeholders to resolve data discrepancies and issues, and reviewing process efficiencies and making recommendations for process Improvement
- Python code updating and changes as per client requirement and classifications of data by running multiple scripts
- Quality assurance over deliverables, reports, insights, responses provided by remote team by reviewing outputs along with creating and reviewing QA plans.
- Researched and resolved issues regarding integrity of data flow into databases
- Used statistical methods to analyze data and generate useful business reports
- Utilized data visualization tools to effectively communicate business insights
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources
- Developed tables, views and materialized views using SQL
- Identified, analyzed and interpreted trends or patterns in complex data sets
- Documented effective and replicable methods for extracting data and organizing data sources
Associate
Annalect – An Omnicom Media Group
Gurgaon
10.2016 - 02.2020
- Built out data and reporting infrastructure from ground up using Advance Excel to provide real-time insights into product, marketing funnels and business KPIs
- Perform Manipulation of data, running pivot tables, V-lookups and formulas in Excel by creating weekly, Biweekly, Monthly and Quarterly reports
- Analyze business data to develop key performance Indicators and build dashboards to visualize important trends & goals for decision making
- Provide strategic recommendations to managers
- Prioritizing and handling multiple Tasks
- Utilizing problem-solving skills and communicating effectively to various audiences
- Performance Measure
- Accuracy at speed
- Proactive thinking
- Work closely with data partners
- Decision support
Education
B. Tech - Computer Science
Bharati Vidyapeeth College of Engineering
PuneHSC CBSE -
Gulab Rai Montessori School
Bareilly, UPSSC CBSE - Science
Alma Mater Day Boarding School
Bareilly, UPSkills
Basic SQL Server, Postgresql,Snowflake
Advanced Excel
Basic Python, Alteryx, Tableau
Timeline
Associate
Kinesso – IPG Media Brands
09.2020 - Current
Associate
Annalect – An Omnicom Media Group
10.2016 - 02.2020
B. Tech - Computer Science
Bharati Vidyapeeth College of Engineering
HSC CBSE -
Gulab Rai Montessori School
SSC CBSE - Science
Alma Mater Day Boarding School