Data Analyst Business Intelligence

DHWANI TANK

856-***-**** ************@*****.*** LinkedIn GitHub

SUMMARY

Experienced Data Analyst and Data Engineer with a strong background in building scalable data pipelines, data modeling, and advanced analytics. Expertise in leveraging machine learning, predictive modeling, and large-scale data systems to derive actionable insights and optimize business performance. Skilled in SQL, Python, R, and cloud technologies (AWS, Databricks) to handle complex datasets, design ETL processes, and implement data-driven solutions. Proficient in data visualization tools like Tableau and Power BI to communicate insights clearly and effectively to stakeholders. Adept at translating business needs into technical solutions, improving data quality, and ensuring the scalability and efficiency of analytical models. PROFESSIONAL EXPERIENCE

WSFS Bank, Data Analyst Intern, Philadelphia, Pennsylvania June 2024 - August 2024

● Led DLP solution implementation using Forcepoint and Varonis in a cross-functional team, ensuring compliance and effectively communicating strategies with stakeholders.

● Collaborated to automate user account creation with Bash scripts, reducing manual tasks by 80%, and analyzed DLP alerts to identify trends and enhance security measures.

● Partnered with analysts and stakeholders to manage large datasets, ensure data quality, and present insights using Tableau and Power BI for informed decision-making.

● Developed automated reporting workflows for DLP incidents, improving incident tracking and reducing report generation time by 40%.

● Cleaned and preprocessed data from multiple sources to ensure accuracy and consistency, providing high-quality inputs for statistical analyses and security investigations.

● Supported security audits and data analysis by identifying patterns in security alerts and providing recommendations to mitigate risks, enhancing data security strategies and policy compliance. Reliance Jio, Assistant Manager, Mumbai, Maharashtra November 2021 - December 2022

● Directed the QA process for JioMeet, focusing on diverse testing strategies like usability, functional, and cross-platform interoperability to uphold software quality.

● Streamlined agile development by reducing duplicate bug reports by 75% and prioritizing critical fixes, collaborating with cross-functional teams.

● Enhanced testing efficiency using automation tools and frameworks, aligning technical execution with user needs.

● Led defect management and tracking through Jira, ensuring efficient resolution of critical issues and optimizing product quality by maintaining clear documentation and communication with development teams.

● Coordinated user acceptance testing (UAT) with key stakeholders, gathering feedback and ensuring that features met business requirements, resulting in a smoother product release cycle. Ajackus, Software Engineer Intern, Mumbai, Maharashtra July 2021 - September 2021

● Developed user interfaces using HTML, CSS, JavaScript, and React, ensuring they were accessible and responsive.

● Provided mentorship on Git and front-end integration, enhancing overall team performance.

● Collaborated with back-end developers to ensure smooth integration of front-end components.

● Optimized front-end performance by implementing lazy loading and efficient state management in React, improving page load times by 30% and enhancing user experience. DATA ANALYST PROJECT EXPERIENCE

VAST Challenge MC2 Visual Analytics Tableau D3.js

● Identified anomalies in 138,824 rows of waterway data using OpenRefine, proposed improvements in sampling methods, and visualized findings with D3.js and Tableau.

● Created a radial chart with D3.js to track 112 chemicals and highlight 12 toxic variants, facilitating better understanding and decision-making. Big Data Project Management and Visualization Python Redis Tableau Data Visualization Video

● Managed a 100,000-row dataset with Redis, implementing caching strategies and optimizing data structures for enhanced performance and real-time access.

● Created interactive dashboards and visualizations in Tableau, transforming complex datasets into actionable insights to support strategic decision-making. Data Warehouse Integration and Business Intelligence Python ETL Data Profiling

● Directed the calculation, analysis, and consolidation of yearly sales data, ensuring accurate and comprehensive reporting while optimizing data integrity through profiling.

● Oversaw the ETL process for integrating data from multiple sources into a data warehouse, designed fact tables, and collaborated with teams to align data for reporting. Health Data Analysis and Predictive Model Python EDA Statistical Methods Visualization Project

● Selected and cleaned a health dataset, conducted exploratory data analysis (EDA) in Python, and applied statistical methods to uncover trends related to heart disease.

● Utilized machine learning techniques to build accurate heart disease models, leveraging insights from data analysis and visualizations to enhance performance. Document-Based Question Answering System with LLM-Driven Retrieval-Augmented Generation, Translation, and Sentiment Analysis Project

● Developed a document-based QA system that processes various file formats (PDF, DOCX, TXT), extracts relevant content using LangChain, and generates contextual answers through the Retrieval-Augmented Generation (RAG) model with Sentence Transformer and FAISS.

● Integrated multi-language support for French, Spanish, and German translations, along with sentiment analysis to assess response tone, providing users with a scalable, user- friendly solution for extracting insights from complex documents. SKILLS AND INTERESTS

Data Analysis & Interpretation: Teradata, Redshift, Oracle, NoSQL, MySQL, PostgreSQL, kubernetes Data Visualization Tools: Tableau, PowerBI, Quicksight, Excel (VLOOKUP, Pivot Tables), SSRS, D3.JS Big Data Tools: Redis, Databricks, Neo4j, Apache

Adjustment Software: EPIC, EZ-Cap, Cozeva (familiarity), Jupyter Notebooks Large Language Model: Ollama, Hugging face, LangChain Languages: Python, R, SQL, Pytorch, Tensorflow

Data Pipeline Design: ETL, Data Modeling, Automation, Data Profiling Statistical Analysis: t-test, Chi-squared, Correlation Analysis Tools & Technologies: SAS, Apache Hadoop, Spark SQL, Tableau, Python (Pandas, NumPy, Matplotlib), AWS (Redshift, QuickSight) Language Skills: English (Fluent), Hindi (Fluent), Gujarati (Fluent) Interests: Data Science and Analytics, Machine Learning, Predictive Modeling, Data Visualization, Business Intelligence, Big Data Solutions EDUCATION

Rowan University, Glassboro, New Jersey January 2023 - December 2024 Master of Science in Data Science

Relevant Coursework: Data Warehousing, Data Mining, Big Data Tools and Techniques, Large Language Model, Multivariate Data Analytics, Visual Analytics University of Mumbai, Mumbai, Maharashtra August 2017 - June 2021 Bachelor’s in Computer Engineering

Relevant Coursework: Machine Learning, Artificial intelligence, Database management system, Human Machine Interaction, Digital Logic Design & Analysis, Computer Organization and Architecture, Computer Graphics, Computer Network, Business Communication & Ethics CERTIFICATIONS

• • Getting Introduction Started to Data with Python Science (Coursera) in Python (Coursera)

Contact this candidate