Preeti Pandey
Seattle,WA
Summary
Dedicated data analyst with over 5 years of experience in transforming complex data into actionable insights that drive strategic business decisions and enhance operational efficiency. Expertise in SQL, Python, R, and Tableau, complemented by strong skills in statistical analysis, data visualization, and reporting. Proven track record of improving data quality, streamlining reporting processes, and collaborating with cross-functional teams to develop innovative data-driven solutions. Committed to continuous learning and leveraging data to optimize business performance and profitability.
Overview
7
7
years of professional experience
Work History
Senior Business Data Analyst
Capillary Technologies
03.2020 - 05.2022
- Developed dashboards that improved decision-making efficiency.
- Collaborated with stakeholders to create cross-functional reports for better business alignment.
- Automated reporting workflows, significantly reducing manual effort.
- Conducted analysis to recommend products based on purchasing patterns.
- Built customer segmentation models to target marketing campaigns effectively.
- Review project progress and close-out reports to identify trends and collect data, to provide an early warning system for the identification of risks and potential/real changes to project baselines.
- Developed a linear regression model to predict store workload capacity for the USA's leading car tire servicing company using stores, geographic, labor and seasonal attributes.
- Developed a recommended model for customers using Random-Forest for tire/brake replacement based on previous visit trends and mileage.
- Worked on BI Report Tuning, Report Validation and SQL Tuning Involved in Data mapping, logical data modelling, create ER diagrams and used SQL queries to filter data within the database.
- Access to HBASE (Hadoop database) and running HiveQL/Spark SQL queries for data validation.
- Performed Data Analysis on the Analytic data present in Teradata, Hadoop/HIVE/Sqoop and AWS using SQL, Teradata SQL Assistant, Apache Spark, SQL Workbench.
Business Data Analyst
Charmboard
09.2017 - 02.2020
- Set up a data scrapping pipeline across various E-commerce platforms to extract attributes like product title, description, image URL, price etc. to be used across different verticals in the company.
- Analyzed the raw data to extract meaning by performing data mining and cleaning activities and creating common categories for each product in order to make data usable.
- Maintained a MySQL database which was an input feed to the machine learning team and helped build their visual and text search models.
- Ensure that the scope of a change is properly defined and timely movement of identified changes through the change management process.
- Track, document, facilitate and analyses project changes and impacts.
- Maintained and extracted large scale structured data for reporting and analytics purposes.
- Worked on Google analytics services to monitor various metrics related to user behavior and engagement.
Business Data Analyst
Oxigen Services India Pvt. Ltd.
06.2016 - 09.2017
- Involved in the movement of data warehouse and ETL jobs, redesigning of the existing ETL for Hadoop ecosystem using Sqoop and Hive, use of blob storage, and use of Shell and Python scripts to process the data.
- Performed Data Analysis on the Analytic data present in Teradata, Hadoop/HIVE/Sqoop and AWS using SQL, Teradata SQL Assistant, Apache Spark, SQL Workbench.
- Gathered client requirements then Created, Managed, and updated SP internal/external sites for them.
- Closely worked with Fraud and Risk data scientists in productionization of Random-Forest model output to predict the potential customer wallets in the entire base of active Oxigen wallets.
- Involved in data ingestion, data validation, management of multiple Ad-hoc requests, creation of requirement-specific and more generic data marts to cater business needs, and delivery of the reports and analysis.
Business Data Analyst
IBM
06.2015 - 06.2016
- Designed and developed test cases and quality assurance on data.
- Experience in integrating various data sources like logs, DB tables, flat files and JSON data.
- Worked with the business team and vendor to gather requirements.
- Created Excel spreadsheets for both functional and non-functional requirements for DocuSign.
Education
Master of Science - Data Science
Liverpool John Moores University
Liverpool, UK09.2024
Bachelor of Engineering - Computer Science
Swami Vivekananda Technical University
Chhattisgarh, India01.2014
Skills
- Explanatory Analysis: Tableau, Quicksight, Power BI, Big Data, Advance Excel
- Coding Languages: MySQL, PSQL, Apache Hive, Python (NumPy, Pandas, Math, Matplotlib, Seaborn, Scikit-learn)
- Advanced Excel
- Machine learning
- Data warehousing
- Business intelligence
- Big data analytics
- SQL programming
- Data cleaning
- Text analytics
- Python programming
- Tableau software
- Data analysis
- Cluster analysis
- Data visualization
- Technical writing
- Business acumen
- External market data tracking
- Pivot tables
- Natural language processing
- Report generation
Timeline
Senior Business Data Analyst
Capillary Technologies
03.2020 - 05.2022
Business Data Analyst
Charmboard
09.2017 - 02.2020
Business Data Analyst
Oxigen Services India Pvt. Ltd.
06.2016 - 09.2017
Business Data Analyst
IBM
06.2015 - 06.2016
Bachelor of Engineering - Computer Science
Swami Vivekananda Technical University
Master of Science - Data Science
Liverpool John Moores University