top of page

About

My name is Mandar Mhatre

Data Analyst / Engineer | software Engineer | Product Manager

  • hackerrank-icon-465x512-7x2nqr1n
  • GitHub
  • LinkedIn
IMG_3033.JPG
brands_edited_edited_edited.jpg

About Me.

In my capacity as a dedicated and results-driven data analyst, I bring a unique blend of technical expertise, analytical prowess, and a passion for transforming raw data into actionable insights. Armed with a solid foundation in statistical methods, data visualization, and machine learning, I have successfully navigated complex datasets to unearth meaningful patterns and trends. My proficiency in utilizing programming languages such as Python and R, coupled with my adeptness in data manipulation and database management, has allowed me to streamline and automate analytical processes, thereby significantly enhancing efficiency. Additionally, my experience in developing impactful visualizations using tools like Tableau and Power BI has effectively communicated findings to diverse stakeholders, facilitating informed decision-making. Whether engaging in exploratory data analysis or constructing predictive models, I consistently strive for excellence and innovation in transforming information into strategic assets.

Education

2022-2024

Masters of Science

Indiana University Bloomington

IU logo.jpg
MU Logo.png

2017-2021

Bachelors of Engineering

University of Mumbai

Experience

Jan 2024 - May 2024

Data Analyst
Indiana University Bloomington

  • Developed an ETL pipeline using DBT, leveraging Airflow DAGs for orchestration, creating a centralized data warehouse in Snowflake that enabled efficient querying and reduced analysis time by 60%

  • Conducted in-depth analysis of user behavior using Google Analytics, identifying pain points in the user journey and recommending UI/UX improvements that increased learning rates by 25%

  • Implemented A/B testing on various features, boosting program efficiency by 15% based on KPIs including test scores, knowledge retention rates, and module completion times

  • Generated monthly reports on volunteer performance using Power BI and DAX, facilitating data-driven decision-making for program improvements that resulted in a 20% increase in average test scores

Aug 2022 - May 2024

Associate Instructor
Indiana University Bloomington

  • Guided over 60 students in Unity development, providing instruction in C# scripting, material creation, and game design.

  • Assisted students in integrating AI concepts into their projects and ensured adherence to best coding practices.

Aug 2023 - Dec 2023

Data Analyst
Energy Justice Lab

  • Developed a dashboard using Dash and Plotly, visualizing utility service areas, enabling more granular outage analysis

  • Created integrated data models using python, combining Geospatial data with outage data of utility providers across 35 states, automating manual mapping processes, saving 20 hours monthly

  • Improved dashboard loading time by using Mapshaper to reduce polygon complexity resulting in 50% faster visualizations.

  • Developed a data dictionary and reference reports, leveraging tableau and Excel functions such as VLOOKUP and pivot tables, incresing data interpretability for the team resulting in 30% faster report generation

Jun 2021 - Dec 2021

Software Engineer

GEP

  • Automated inbound requisition mapping by building an ETL pipeline using C# and SQL, extracting data from REST APIs and loading it into a SQL Server database, resulting in 30% faster purchase order creation

  • Developed API endpoints to send spend data from the B2B e-procurement platform, facilitating AI-based spend analysis

  • Developed stored procedures to dynamically filter product data based on user-selected criteria, reducing load times by 50%

  • Leveraged Azure DevOps for CI/CD pipelines, deploying 35 critical releases across environments with a 100% success rate

  • Worked within a cross-functional team under an strict Agile (scrum) environment leveraging JIRA and Confluence ensuring productive collaboration and timely completion of milestones

SKILLS

Programming Languages: Python, R, SQL, C#, Java, HTML, CSS, JavaScript, TypeScript, Shell scripting, DAX, Cypher, XML, C++, Bash/Shell scripting.
Frameworks: ASP .NET Core, ASP .NET MVC, Microservices, React.js, Angular, Node.js, Express.js, Django, Flask.
Data Management and Databases: SQL Server, MongoDB, Neo4j, SQLite, Snowflake, PostgreSQL, Azure Data Lake, PySpark, MSSQL, T-SQL, MySQL, Redis, Apache Spark, Elasticsearch.
Tools: Power BI, Tableau, Looker, Excel, Apache Airflow, Azure Data Factory, DBT, Prefect, Redshift, Hadoop, MapReduce, Kafka, Git, Docker, Jenkins, JIRA, Confluence, Visual Studio, Jupyter, Alteryx, Figma, Unity, Blender, GitLab, Bitbucket, Postman, Swagger, IIS Server, Logstash, NuGet, Kibana.
Libraries: Pandas, NumPy, Matplotlib, Plotly, Seaborn, Scikit-learn, NLTK, SpaCy, Dplyr, Tidyr, ggplot2, Caret.
Cloud and API Services: Azure DevOps (CI/CD), AWS (S3, EC2, RDS, SQS, SNS), GraphQL, REST, OpenAPI.

GET IN TOUCH

Thanks for submitting!

bottom of page