Summary
Overview
Work History
Education
Skills
Extracurricular Activities
Projects
Timeline
Generic

Aanchal Bhambhani

Data Analyst
Melbourne,VIC

Summary

Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

4
4
years of professional experience

Work History

Data Analyst

Quinnox
10.2021 - 10.2023
  • Orchestrated design and execution of sophisticated ETL processes using Python, and enhanced them with Power Query for efficient, automated data extraction, transformation, and loading
  • This approach significantly enhanced data quality and accessibility, streamlining data workflows
  • Employed DAX to develop complex measures and calculated columns within Power BI, enabling creation of interactive and dynamic data visualizations
  • This initiative helped stakeholders quickly grasp complex data narratives and insights, driving informed strategic decisions
  • Demonstrated meticulous attention to detail in data handling and analysis, leveraging Power Query for data cleansing and preparation, thereby ensuring accuracy and reliability in reporting
  • Utilized advanced visualization tools, including Tableau, enhanced with DAX formulas, to present complex data in visually compelling and understandable manner, facilitating better decision-making
  • Optimized data pipeline for scalability and reliability, and employed Power Query to streamline data integration, reducing data processing time by 30%
  • Conducted detailed data analysis using DAX for sophisticated analytical models in Power BI, uncovering key insights that led to 20% improvement in waste management efficiency and operational cost reduction
  • Engaged in continuous collaboration with onsite clients to ensure effective status reporting and gather requirements
  • Translated functional needs into technical implementations, leveraging Power Query and DAX to enhance data models and reports
  • Played pivotal role in Peer-to-Peer code review, providing constructive feedback, and advocating for best practices in Python programming, Power Query transformations, and DAX measures optimization.
  • Utilized data visualization tools to effectively communicate business insights.
  • Improved decision-making processes with accurate data analysis and visualization techniques.
  • Participated in requirements meetings to understand business needs.
  • Used statistical methods to analyze data and generate useful business reports.
  • Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
  • Extracted and interpreted data patterns to translate findings into actionable outcomes.
  • Upheld security and confidentiality of documents and data within area of responsibility.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Managed large-scale databases to ensure timely access to critical information for key stakeholders.
  • Streamlined data processing for faster results by implementing advanced analytics tools.
  • Collaborated with business-unit leaders to identify and prioritize problems.
  • Developed and implemented data governance policies and procedures.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Developed data mining algorithms to identify and classify patterns in data.
  • Generated ad-hoc reports to evaluate specific business requirements.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Evaluated effectiveness of marketing campaigns using A/B testing methodologies, optimizing strategies for higher ROI.
  • Reduced operating costs by automating manual data processes using scripting languages such as Python or R.
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.

Data Analyst

Majesco
06.2018 - 02.2021
  • Proficient in presenting data in graphical or pictorial formats using advanced visualization tools such as PowerBI and Tableau
  • Demonstrated ability to identify and uncover patterns, correlations, and trends within datasets, contributing to creation of comprehensive reports and metrics using Tableau
  • Successfully migrated 10+TB of data using Talend, resulting in a seamless transition to a new data infrastructure with zero data loss or downtime.
  • Reduced data processing time by 40% by optimizing ETL processes, resulting in more efficient data analysis and reporting.
  • Leveraged Power Query within Tableau to extract, transform, and load (ETL) large volumes of insurance data from diverse sources, including SQL databases and cloud-based storages, streamlining data analysis workflow
  • Developed back-end components to improve responsiveness and overall performance using Pycharm
  • Worked with Python libraries like Pandas, NumPy, etc
  • Even used BD Talend ETL components to get insight from product
  • Familiarity with data models and relationships, particularly in context of financial services data, contributing to compilation of comprehensive reporting and metrics
  • Conducted training sessions on Power Query for data analytics team, improving team's proficiency in data manipulation and enhancing overall productivity in data-related projects
  • Designing and deploying software release bundle on client environment
  • Coding and debugging database program units using Oracle SQL/PLSQL.

Junior Data Analyst

Tata Consultancy Services
01.2015 - 12.2017
  • Developed comprehensive Spring MVC web application, incorporating data analytics modules to support mortgage management system enhancements, which boosted customer satisfaction by 25%
  • Implemented agile development practices to accelerate delivery of data-driven features, leading to 40% reduction in time-to-market for new analytics functionalities
  • Applied advanced data analysis techniques to identify patterns, correlations, and trends in large datasets, informing creation of new financial products that catered to unmet customer needs, resulting in 15% increase in product uptake
  • Introduced DAX measures in Tableau reports for mortgage management system, optimizing data queries and enhancing performance
  • Collaborated with financial analytics team to develop DAX-based solutions in Tableau for data analysis, contributing to more accurate assessment of customer segments and loan performance
  • Spearheaded automation of data reporting and analytics processes using Jenkins, enhancing operational efficiency and enabling real-time data insights for decision-makers.

Education

Masters - Data Science

University of Melbourne
Melbourne, Victoria
12.2023

Master of Engineering - Computer Science

Datta Meghe College of Engineering
Navi Mumbai, Maharashtra
09.2014

Bachelor's - Information Technology

Thadomal Shahani Engineering College
Mumbai, Maharashtra
04.2012

Skills

  • Python
  • MySQL, Oracle, SQL, NoSQL Databases
  • ETL processes, Talend
  • Data Visualization and Presentations
  • Data Analysis
  • Data Cleaning
  • Analytical Problem Solving & Data Storytelling
  • Statistical Analysis
  • R Programming
  • Data Validation
  • Tableau Software
  • Machine Learning
  • Data Modeling
  • Project Management
  • Clear and Concise Communication
  • Data quality assurance processes
  • Data profiling
  • Data programming
  • A/B Testing
  • Team Collaboration

Extracurricular Activities

Conducted multiple workshops on ETL programming tool at Majesco. Organized ‘Astro vaganza’ a treasure hunt event based on space theme in intercollegiate tech fest NEWTON. Carried out monthly Peer Mentoring workshop to navigate the freshers to complete their degree in timely manner at Thadomal Shahani Engineering College. Oversaw a team of 8 students to organize a Blood Donation drive event across 3 of the largest malls in Mumbai. Awarded as the best Orator to deliver a speech on “Truth” organized by DMCE College.

Projects

BushFire Simulation Project, The increasing prevalence and severity of Australian bushfires call for optimized fire management strategies. This study aims to identify the most effective fire suppression techniques under diverse environmental conditions., Agent-Based Modelling, The performance is examined through 4 performance aspects, including time efficiency, extend of fire, effectiveness, and ecological impact., The results are presented on an user-interactive website, providing easily interpretable visualizations. Bus Tracking System, Developed an android application to track buses in real time. Incorporated functionalities to locate the bus using the bus number, user’s location and the path of the bus. Explored various google API’s for real time tracking, Android, PhpMyAdmin, Designed a driver side application to update the server with accurate location of bus. ‘Mission Moon’ using C++, Developed an animation in C++ to demonstrate different line drawing and polygon rendering algorithms to depict CHANDRAYAAN – India’s maiden mission to moon. Oversaw different inbuilt methods of graphics class., C++, Bresenham, DDA for line drawing and Boundary fill for coloring figures.

Timeline

Data Analyst

Quinnox
10.2021 - 10.2023

Data Analyst

Majesco
06.2018 - 02.2021

Junior Data Analyst

Tata Consultancy Services
01.2015 - 12.2017

Masters - Data Science

University of Melbourne

Master of Engineering - Computer Science

Datta Meghe College of Engineering

Bachelor's - Information Technology

Thadomal Shahani Engineering College

Similar Profiles

CREATE PROFILE
Aanchal BhambhaniData Analyst