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
2020.09 - 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
2016.10 - 2020.02
- 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
undefinedTimeline
Associate
Kinesso – IPG Media Brands
2020.09 - Current
Associate
Annalect – An Omnicom Media Group
2016.10 - 2020.02
B. Tech - Computer Science
Bharati Vidyapeeth College of Engineering
HSC CBSE -
Gulab Rai Montessori School
SSC CBSE - Science
Alma Mater Day Boarding School
Similar Profiles
Luis MendesLuis Mendes
Executive at Interpublic Group Media Brands (IPG)Executive at Interpublic Group Media Brands (IPG)
Steven MengSteven Meng
Senior Analytic Manager at IPG - KinessoSenior Analytic Manager at IPG - Kinesso
Omika ShethOmika Sheth
Performance Manager at Kinesso (IPG Mediabrands)Performance Manager at Kinesso (IPG Mediabrands)