Power BI
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
Microsoft 365
Project Management Software (Jira, Trello, Workfront, Sharepoint, etc)
Power Apps
Power Automate
Power Flow
Power BI
CARS
Oracel SQL
DataBase Sql Server programming: Python, MATLAB and SQL
microsoft sql
microsoft Azure
Website optimization
Marketing Strategy Development
Data Modeling
SQL and Excel expertise
Segmentation analysis
KPI performance
Competitive Analysis
Product positioning
Quantitative Analysis
Statistical modeling
Trend Analysis
Salesforce Experience
Data Visualization
Problem-solving abilities
Marketing Analytics
Data collection processes
Problem-Solving
Marketing Strategies
Database Skills
Data Collection
Professionalism
Analytical Thinking
Time Management
Global Marketing
Statistical Analysis
Database Management
Decision-Making
Business Needs Analysis
International Marketing
Self Motivation
Team building
Competitive Research
Microsoft Office
Pricing Analysis
CRM Software
Software
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