Anjali Khare
Westford,MA
Summary
Highly motivated and detailed-oriented candidate passionate about using data to improve business performance and customer experience. Skilled at leveraging data to develop actionable solutions to business challenges and utilizing data mining and data visualization to create meaningful insights. Excellent technical aptitude and knowledge of programming languages, data analytics and data visualization.
Dedicated analytics professional with substantial experience in data analysis, statistical modeling, and data visualization. Adept at leveraging tools such as SQL, Python, and Excel to derive actionable insights and drive business decisions.Known for problem-solving skills, critical thinking, and proactive approach to challenges.
Overview
2026
2026
years of professional experience
1
1
Certification
Work History
Junior Data Analyst
Optiosys Technology LLC
01.2025 - Current
- I assisted in extracting, cleaning, and analyzing data from multiple sources using SQL, and formatted and visualized insights in Excel to support business operations.
- Built reports using pivot tables and advanced functions in Excel, ensuring data consistency, while utilizing SQL to query large datasets for actionable insights.
- Collaborated with team members to ensure accurate reporting, providing critical data to stakeholders to inform business decisions and improve process efficiency.
- Responsibilities:
- Extracted, cleaned, and organized data using SQL queries to ensure efficient analysis, while using Excel functions to validate and preprocess data for reporting.
- Created complex SQL queries to retrieve large datasets, applying filters and conditions to refine data, and utilized Excel to perform basic data analysis and generate reports.
- Developed dynamic dashboards and reports in Excel, utilizing pivot tables and charts, and queried data from multiple sources using SQL for deeper insights.
- Conducted thorough data validation using Excel formulas, while leveraging SQL to identify and remove inconsistencies from large data sets to maintain accuracy.
- Built and maintained interactive reports in Excel, applying conditional formatting and VLOOKUP, and used SQL to query relational databases for data extraction.
- Utilized SQL to query and filter datasets based on specified criteria, while utilizing Excel to analyze and present key findings in a clear, concise manner.
- Managed and transformed data using SQL queries, and conducted data manipulation tasks in Excel to prepare datasets for deeper analysis and visualization.
- Automated routine data extraction processes using SQL and formatted data in Excel to ensure consistent and accurate reporting for internal stakeholders.
- Designed and executed SQL queries to gather and filter data from various databases, and applied Excel functions to analyze trends and patterns for reporting.
- Produced summary reports in Excel, using pivot tables and advanced formulas, while querying large datasets with SQL to provide deeper insights.
- Assisted in generating daily and weekly reports by extracting data with SQL and conducting trend analysis using Excel to support business decision-making.
- Updated and maintained large datasets using SQL, ensuring data integrity, and leveraged Excel for visualizing results and creating user-friendly reports.
- Used SQL to connect and query data from different sources, while analyzing and visualizing key metrics in Excel to facilitate business insights.
- Created ad-hoc reports in Excel, incorporating advanced formulas and charting techniques, and extracted data using SQL to meet specific business needs.
- Conducted exploratory data analysis in Excel, using charts and statistical tools, and applied SQL to retrieve and filter necessary data for further analysis.
Junior Data Analyst
BCG Data for Decision Makers Job Simulation on Forage
- Completed a job simulation focused on advising a hypothetical client on multi-channel ad campaign performance.
- Analyzed customer conversion trends using simulated data to assess campaign effectiveness across channels and audiences.
- Synthesized insights and delivered a clear, data-backed recommendation tailored to the client’s marketing goals.
Junior Data Analyst
Deloitte Australia Data Analytics Job Simulation on Forage
2025 - 2025
- Completed a Deloitte job simulation involving data analysis and forensic technology.
- Created a data dashboard using Tableau.
- Used Excel to classify data and draw business conclusions.
- Conducted thorough data cleaning processes to ensure integrity and reliability of analytical results.
Data Analyst Intern
Decoder Bot
01.2024 - 01.2025
- Data collection and cleaning for accuracy.
- Analyzing data sets with statistical techniques to identify trends.
- Creating reports and visualizations for stakeholders.
- Collaborating with teams like marketing and finance.
- Utilizing tools such as Excel, SQL, Python, R, Tableau, or Power BI.
- Gaining hands-on experience and developing analytical skills.
- This internship offers a valuable opportunity to enhance data analysis skills and contribute to meaningful projects.
- Developed data visualization dashboards using Tableau, improving stakeholder engagement with actionable insights.
- Analyzed large datasets to identify trends and insights, enhancing decision-making processes.
- Documented analytical processes and created user guides to support team knowledge sharing and training efforts.
Data Science Trainee
Magnus Technology
01.2022 - 01.2023
- Analyzed data to identify trends for decision-making.
- Implemented predictive algorithms for strategic planning.
- Enhanced data quality using machine learning and deep learning.
- Applied NLP to analyze text data for insights.
- Developed data modeling approaches for product improvement.
- Provided data-driven solutions for operational efficiency.
- Analyzed datasets using Python and R to derive actionable insights for data-driven decision-making.
- Developed predictive models to enhance forecasting accuracy and support strategic planning initiatives.
Education
Master of Science - Analytics: Essential Tools and Methods
The Georgia Institute of Technology
Atlanta, Georgia01.2025
Bachelor of Technology - Computer Science & Engineering
National Institute of Technology
Raipur, India, India06.2008
Skills
- Proficient in Power BI and Tableau
- Skilled in SQL database management
- Data extraction and transformation
- Proficient in GitHub for data integration
- Statistical modeling expertise
- Machine learning expertise
- Cloud computing expertise in Azure and AWS
- Tableau software
- Data cleaning
- Python programming
- Data storytelling
- Data wrangling
- Data mining
- Predictive modeling
- Data integration
- Deep learning
- Text analytics
- Data and analytics
- SQL and databases
- Tableau
Certification
- Google Data Analytics Professional Certificate
- PCEP-Certified Entry Level Python Programmer
- Microsoft Certified Azure
- Data Fundamentals
- Google IT Support Specialization
- Google Advanced Data Analytics
Timeline
Junior Data Analyst
Optiosys Technology LLC
01.2025 - Current
Data Analyst Intern
Decoder Bot
01.2024 - 01.2025
Data Science Trainee
Magnus Technology
01.2022 - 01.2023
Bachelor of Technology - Computer Science & Engineering
National Institute of Technology
Junior Data Analyst
BCG Data for Decision Makers Job Simulation on Forage
Junior Data Analyst
Deloitte Australia Data Analytics Job Simulation on Forage
2025 - 2025
Master of Science - Analytics: Essential Tools and Methods
The Georgia Institute of Technology
Websites, Portfolios, Profiles
https://github.com/Anjali-Khare15