Priyanka Belde

Priyanka Belde

Senior Analyst
United States of America

About Me

Experienced Senior Data Analyst in IT industry, working to transform raw data into actionable strategic knowledge to gain insight into business processes, and thereby guide strategic and tactical decision-making. Expert …

Experience

Senior Data Analyst and Data analyst

Kantar
Mar 2019 - Present · 7 years 4 months

Environment: MySQL, MS SQL Server, Python, Pandas, SciPy, NumPy, Matplotlib, Excel, Tableau, PL/SQL, PowerBI, R programming language, RStudio.
Responsibilities:
Develop a data platform from scratch and took part in requirement gathering and analysis phase of the project in documenting the business requirements.
Worked in designing tables in MYSQL and processing data like importing and exporting of databases involved in
processing large datasets of different forms including structured, semi-structured and unstructured data.
Implemented Custom data extraction using SQL scripts, SQL stored procedures, Functions, Views and Triggers
Imported the customer data into Python using Pandas libraries and performed various data analysis - found patterns in data which helped in key decisions for the company.
Performed Data Cleaning using Python packages such as Pandas, NumPy, Matplotlib, Sci-kit Learn to remove duplicates, errors and outliers.
Implemented data governance policies and procedures while processing the data.
Performed complex data analysis to analyze customer shopping data and proposed locations for future stores
using R programming language.
Used Python programming for managing and transforming and integrating with datasets in preparation for analytics.
Estimated existing and potential markets using statistical tools such as SQL, RStudio and PowerBI.
Created dynamic linear models to perform trend analysis using Python
Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Integrated data from different sources. Developed stored procedures, improved database design, created views, and derived tables to power data for user stories.
Documented entire process of data analysis in R Markdown.
Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
Mentored and assisted junior data analysts and interns.

Senior Data Analyst

Kantar, Hyderabad, India
Jan 2021 - Nov 2022 · 1 year 10 months

Developed a data platform from scratch.
Took part in requirement gathering and analysis phase of the project.
Documented the business requirements.
Worked in designing tables in MYSQL.
Processed data including importing and exporting databases.
Processed large datasets of structured, semi-structured and unstructured data.
Implemented custom data extraction using SQL scripts, SQL stored procedures, functions, views and triggers.
Imported customer data into Python using Pandas libraries.
Performed various data analysis and found patterns in data which helped in key decisions for the company.
Performed data cleaning using Python packages such as Pandas, NumPy, Matplotlib and Sci-kit Learn to remove duplicates, errors and outliers.
Implemented data governance policies and procedures while processing the data.
Performed complex data analysis to analyze customer shopping data and proposed locations for future stores using R programming language.
Used Python programming for managing, transforming and integrating datasets in preparation for analytics.
Estimated existing and potential markets using statistical tools such as SQL, RStudio and PowerBI.
Created dynamic linear models to perform trend analysis using Python.
Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Integrated data from different sources.
Developed stored procedures, improved database design, created views and derived tables to power data for user stories.
Documented entire process of data analysis in R Markdown.
Mentored and assisted junior data analysts and interns.
Performed root-cause analysis on data-related system problems to recommend or execute corrective action.

Data Analyst

Kantar, Hyderabad, India
Mar 2019 - Dec 2020 · 1 year 9 months

Participated in requirements meetings to understand business requirements.
Cleaned and processed datasets using advanced Excel spreadsheet functions.
Written complex SQL queries using joins and OLAP functions like Count, CSUM and Rank.
Developed complex T-SQL code such as stored procedures, functions, triggers, indexes and views for the business application.
Found outliers, anomalies and trends in given data sets.
Performed complex data analysis in support of ad-hoc and standing customer requests.
Used Python NumPy, SciPy, Pandas, Panda SQL, Mat plot and Stats packages to perform dataset manipulation, data mapping, data cleansing and feature engineering.
Built and analyzed datasets using R and Python.
Implemented data governance policies and procedures while processing the data.
Wrote Python routines to log into websites and fetch data for selected options.
Produced monthly visualized analysis reports improving managers’ problem diagnosing and decision-making processes.
Involved in extensive routine operational reporting, hoc reporting and data manipulation to produce routine metrics and dashboards for management.
Published interactive dashboards and scheduled auto-data refreshes.
Created publishing reports for stakeholders using Power BI.
Used Excel sheets, flat files and CSV files to generate Tableau ad-hoc reports.
Worked on creating filters and calculated sets for preparing dashboards and worksheets in Tableau.
Built, published customized interactive reports and dashboards, and scheduled reports using Tableau Server.

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) Data Analysis Skills Power BI R Programming Language (R) Tableau Databases Python R Programming PL/SQL Advanced Excel Data Analysis Statistics Modelling Predictive Analytics Deep Learning Oracle SQL/PLSQL MSSQL PostgreSQL ETL SQL Server Visual Studio Azure Data Studio Plotly Dash Matplotlib PowerBI Pandas NumPy XGBoost CatBoost LightGBM NLTK scikit-learn ggplot2 dplyr plyr SciPy Beautiful Soup Rpy2 Informatica Power Center MySQL MS SQL Server RStudio R Markdown Agile Methodologies Scrum Data Governance Data Cleaning Data Profiling Data Warehousing Amazon Redshift Oracle DB2 MongoDB
Report this Profile?