DATA ANALYST

Diksha Jagre

https://www.linkedin.com/in/dikshajagre/ 989-***-**** ad3e94@r.postjobfree.com SKILLS

Tools & Technologies: Python, SQL, Tableau, Advanced Excel, Power BI, Project Management, Data Quality (DQ), Master Data Management (MDM), Customer Mining, Data Cleansing, Data Analysis, Data Visualization, Data Wrangling, Requirement Gathering, Data Documentation, Detail Oriented, Collaboration, Communication Skills, Compliance, Proactive, Risk Management, Problem Solving Skills, Focus Driven, Team Player, Machine Learning, Deep Learning, Artificial Intelligence, Classification, Regression, Clustering, Optimization, SDLC, Agile, Teradata, R, Java, Jupyter Notebook, TensorFlow, Scikit-learn, PyTorch, Plotly, Spark, Big Data, Hadoop, Hive, Keras, Numpy, Pandas, Keynote, Quip, Pages. Educational Achievements: GOLD medal recipient for securing the first position in the University for BCA, SILVER medal recipient for securing the second position in the University for MCA.

EXPERIENCE

DATA ANALYST I, DEXIAN DISYS (APPLE INC.); AUSTIN, TX

- Conducting in-depth data cleansing process using Python, SQL, and Excel to optimize data accuracy for US Education Sales Accounts, resulting in a 60% reduction in data errors and a 50% improvement in data migration.

- Researching US Education Sales Accounts using CRM and MDM tools, creating a workflow that saved 80% of time for data cleaning and data quality processes.

- Working with 35,000 Education records using Tableau to provide quantitative insights for business decision-making.

- Follow SDLC life cycle to identify goals and problems accurately, ensuring precise and relevant implementation plans.

- Collaborate with the data management team to develop data management standards, and to maintain higher data quality for use in decision making.

- Analyze and visualize US Education Sales data using Tableau; identify patterns, and prioritize tasks accordingly based on business decisions.

- Working in the tight deadline; and to manage multiple activities and leading business analyst throughout this project.

- Create presentations summarizing analysis insights and effectively conveyed results to stakeholders, executives, and team members using Keynote.

- Enhance existing Tableau dashboards to align with business requirements, incorporating feedback and employing effective techniques.

- Building the plans, to prioritize and begin execution for data quality processes. 08/2022 - 11/2023

Relationship Management (CRM), Metadata Management, ETL, Data Exploration, Data

- Collaborate and communicate effectively with team members using Quip documents; share results, delegate tasks, and provide feedback to facilitate the next step.

- Validate data quality assumptions and provided 90% clean data by collaborating closely with Account Executives.

- Manage data quality assurance through data cleansing and quality rules, preventing bad data from entering the data warehouse.

- Automate manual tasks through the development of Python scripts, saving hundreds of manual man-hours.

- Guide career experience business analyst to automate repetitive process flows using Excel, reducing analysis time by 10+ hours per week. DATA ANALYST, ACCENTURE; PUNE, INDIA 01/2019 - 07/2021

- Led development of data pipeline of agent incentive system for one of the largest insurance clients using Hadoop Ecosystem tools, contributing to a saving of $1.2M.

- Migrated 120 Terabytes of customer data from mainframe systems to Hadoop Ecosystem and built Hive tables on decoded data to develop KPI metrics using SQL

- Supported auto claims incident management activities for one of the biggest Italian insurance companies using Microsoft Excel, contributing to a saving of $0.5M. SOFTWARE DEV TRAINEE, GR SOLUTIONS; NAGPUR, INDIA 01/2018 - 05/2018

- 22% quarterly increase in revenue for one of the e-Commerce giants by migrating data from Microsoft Excel to RDBMS using Python; involved from conception to implementation of project.

- Built SQL queries for analyzing Clickstream data, and providing technical and business recommendation, improving website traffic by 45% in a quarter. SOFTWARE TRAINEE, COJAG; NAGPUR, INDIA 05/2017 - 07/2017

- Translated business requirements into technical requirements using Agile methodologies.

- Developed more robust, secure, and durable data warehouse solution using Python and SQL for an auto insurance client, contributing to a saving equivalent of 100s of man-hours.

ACADEMIC PROJECTS

- Developed a vehicle speed tracking system using openCV in which a video of a car is sent as an input and the speed of the car is printed as output.

- Analyzed open-source datasets of unlocked mobile phones reviews on Amazon to perform sentiment analysis.

- Performed data ingestion, cleaning, transformation using ETL concepts and Python, and visualization using Tableau.

- Performed EDA on open source used cars datasets using python libraries like pandas, seaborn, and plotly.

- Investigated the most affordable and most sold cars and their body types in the US by using ETL concepts like extraction, cleaning, transformation, loading, and visualization.

- Performed data splitting, normalization, training, and prediction to come up with more accurate results.

EDUCATION

Central Michigan University, Mount Pleasant, MI, USA — MS in Computer Science Rashtrasant Tukadoji Maharaj Nagpur University, Nagpur, MH, India — MCA Rashtrasant Tukadoji Maharaj Nagpur University, Nagpur, MH, India — BCA

Contact this candidate