About Me
Hi, I am Anjali. I am an experienced Data Analyst and a Software Developer with an MS in Computer Science. As a Data Professional, I am dedicated to converting raw data into actionable insights. With 3 years of experience, I am proficient in Python, SQL, Tableau, Power BI, , Data Engineering, ETL pipelining, Data Management and Governance, Statistical Modeling, Machine Learning, Cloud Technologies (AWS, Azure etc.), Project Management and Agile Methodologies. I focus on designing and implementing data pipelines, constructing data models, and optimizing data storage and retrieval for peak efficiency. I possess expertise in data modeling, designing data schemas, and developing data models suitable for reporting, analysis, and data science.
Additionally, I am proficient in creating data visualizations for business analysts, executives, and other stakeholders. Beyond my technical abilities, I am a collaborative team player with strong communication skills. I thrive in cross-functional team environments and excel at conveying technical concepts to non-technical stakeholders. My objective is to use my skills and experience to help organizations make data-driven decisions and achieve their business goals.
Experience
Research Intern
Indraprastha Institute of Information Technology, DelhiMay 2021 – Dec 2021 · IIITD Networks Lab | Delhi
Skills
Python
SQL
Power BI
Tableau
AWS
Azure
Google Cloud Platform
R Language
Google Colab
Salesforce
Google Analytics
Android
C#
C++
Java 8
Node JS
HTML
CSS
Javascript
MongoDB
Golang
Docker
Git
Linux
GitHub
SAP
Snowflake
Talend Studio
Hadoop
Terraform
Projects
E-commerce Analytics Dashboard
Performed exploratory data analysis (EDA) on Google Merchandise Sales Data to analyze key metrics like visitor behavior, website growth, and user engagement, utilized SQL and Python to extract data from Google BigQuery, and measured the overall goal conversion rate of 1.3%. Completed country-wise analysis and visualized using Google Looker Studio, determining the United States as largest market with 94.4% of customers and 59.8% of visitors, followed by Canada
Retail Analytics Dashboard
Architected data warehouse for retail analytics by consolidating sales, customer and supplier data using Oracle SQL Server employing dimensional modeling and star schema. Established optimized ETL workflows using Talend to develop Power BI dashboards for real-time insights and decision-making, leading to targeted marketing campaigns which boosted sales by 15%
Twitter Sentiment Analysis
• Built Twitter Sentiment Analysis project in Python, utilizing advanced techniques such as Tf-Idf, GloVe, and Word2Vec for in-depth analysis of Twitter data. Employed Logistic Regression, Naïve Bayes, SVM, and MLP classifier models to accurately predict sentiment in tweets, contributing to nuanced sentiment understanding.
Housing Price Prediction using Predictive Analytics
Executed predictive analytics on 100000 rows of housing prices data with 10+ attributes. Undertook data wrangling, cleansing, preprocessing, PCA, applied Logistic Regression, achieving 92% F1 score for price prediction, also deployed on hugging face
Education
Master of Science in Management Information Systems
University at Buffalo, New YorkJul 2023 – Jun 2024 · United States
Relevant Courses: Data Warehousing, System Design and Analysis, Relational Database Systems, Salesforce CRM, Predictive Analytics, Web Analytics, Cloud Computing and Data Visualization.
Master of Technology in Computer Science
Indraprastha Institute of Information Technology, DelhiAug 2020 – June 2022 · India
Relevant Courses: Graduate Algorithms, Machine Learning, Android Development, Data Mining and Information Retrieval.
Bachelor of Technology in Electronics and Communication
Deenbandhu Chhotu Ram University of Science and Technology, SonepatJun 2013 – May 2017 · India
Relevant Courses: Data Structures and Algorithms, Programming in C++, Database Systems, Operating Systems and Computer Networks.