Summary
Overview
Work History
Education
Skills
Software
Certification
Swimming
Timeline
Generic
Swathi dutt

Swathi dutt

Pricing analyst
Bengaluru

Summary

Meticulous marketing professional with proven history of collaborating with account managers and utilizing KPI knowledge to increase marketing performance. Thorough and driven with passion for fostering client satisfaction and promoting brand awareness. Dynamic Analyst with 8 years of marketing analysis experience. Accustomed to managing newsletter and email distribution to generate new sales leads and assist clients with continually exceeding goals.

Overview

8
8
years of professional experience
3
3
years of post-secondary education
8
8
Certification

Work History

PRICING ANALYST

TRELLEBORG SEALING SOLUTIONS
8 2023 - Current
  • Business Intelligence (BI) Expertise: Proficient in utilizing BI tools like ERP and Hubble to gather, analyse, and interpret pricing data for strategic decision-making, ensuring accurate and up-to-date information extraction from databases
  • Collaborative Market Analysis: Collaborate effectively with cross-functional teams to understand market dynamics and competitor pricing strategies, enabling optimization of sales and profitability through informed pricing decisions
  • Data Management and Analysis: Skilled in managing large datasets using Oracle databases, developing and maintaining pricing models, and conducting margin and pricing analysis to support business initiatives and new product introductions
  • Statistical Modelling and Insights: Utilize statistical modelling methods to analyse pricing strategies' potential impact, providing actionable insights to optimize product pricing and enhance overall profitability
  • Develop advanced DAX calculations for optimized Power BI models
  • Gathering and compiling data from various sources (suppliers, internal departments, production records) for cost estimation and pricing activities
  • Experienced in data modeling, warehousing, and constructing ETL pipelines
  • Build Power BI dashboard and generated reports.

MARKETING ANALYST

UISAT LLC (USA-REMOTE)
07.2023
  • Provided administrative support with payroll, calendars, meetings, and training events
  • Identified and executed improvement for processes, content, and lead generations
  • Conduct monthly training meetings on updated safety, training and privacy policies
  • Extracted 8+ Data Sources - REST APIs, Power BI Datasets, SQL, CSV, SharePoint, and Excel
  • MS SQL Server database administration including installation, configure scheduled task for regular database backup and maintenance activities, Create and modify table, sorted procedures, various clustered and non-cluster indexes, triggers, Check constraints and functions
  • Proficient in data mining, ETL processes, and database management within large-scale, complex business environments
  • Collaborate with both global functional and IT teams to develop robust requirements and processes in a boundaryless manner
  • Experienced in Azure Data Factory and Synapse Analytics for ETL and data warehousing
  • Develops connectors and custom visuals for Power BI; takes ownership of projects with high-quality deliverables and continuous learning mindset
  • Skilled in analyzing and interpreting data across Redshift, Oracle, and NoSQL platforms.

HR ANALYST

ST.MARY'S INTERNATIONAL SHOOL
10.2020 - 10.2022
  • Managing SharePoint system and content permissions, managing system changes, and enforcing policies to conform to firm operational standards
  • Effectively managing workload including; projects, trouble tickets and service request while communicating statuses to supervisor and business stakeholders
  • Identify and suggest existing or new emerging standards and best practice for the applications team
  • Managing and checking the overall server health and functionality
  • Developed visually compelling and intuitive reports and dashboards using Power BI, leveraging a variety of charts, graphs, maps, and other visualizations
  • Conducted user research and gathered feedback to iteratively improve the usability and effectiveness of Power BI reports and dashboards.

DATA ANALYSTS

ZETA GLOBAL, INDIA
11.2016 - 09.2020
  • Server Reporting services (SSRS)
  • Manipulated data using pivot table, pivot charts and macros
  • Facilitated discussions, decision making and conflict resolution
  • Performed Power BI Desktop Data Modelling, Which Cleans, transform, mash-up, from multiple sources
  • Develop SQL queries and system reports to analyze data to support project execution.

IT CONSULTANT

KARANJI INFOTECH, MANGALORE INDIA
09.2009 - 11.2011
  • Perform database defragmentation and optimize SQL queries, improving database performance and loading speed by 70%
  • Wrote SQL queries to obtain data from multiple tables to spool into CSV format and provide extract to business and users
  • Excellent analytical and problem-solving skills
  • Ability to develop applications
  • Utilized joins and sub-queries to simplify complex queries involving multiple tables while optimizing procedures.

Education

BACHELOR OF COMPUTER APPLICATIONS -

Mangalore University
05.2006 - 05.2009

Skills

Microsoft Azure

Software

Power BI

SQL

Python

Excel

Congos BI

Power apps

Power automates

SharePoint

Pandas

NumPy

Matlabplot

Seaborn

Scikitlearn

Data modeling

Reporting

Power Query

Visualization

Certification

Machine learning NLP License - 24/06/2024

Swimming

BoW and TF-IDF are commonly used for document analysis because they focus on word frequency rather than contextual meaning.

Tokenization, Lemmatazation , POS tags,

Timeline

MARKETING ANALYST

UISAT LLC (USA-REMOTE)
07.2023

HR ANALYST

ST.MARY'S INTERNATIONAL SHOOL
10.2020 - 10.2022

DATA ANALYSTS

ZETA GLOBAL, INDIA
11.2016 - 09.2020

IT CONSULTANT

KARANJI INFOTECH, MANGALORE INDIA
09.2009 - 11.2011

BACHELOR OF COMPUTER APPLICATIONS -

Mangalore University
05.2006 - 05.2009

PRICING ANALYST

TRELLEBORG SEALING SOLUTIONS
8 2023 - Current
Swathi duttPricing analyst