Business Intelligence Analyst

HETAL ATUL GADA

781-***-**** ****.**@************.*** linkedin.com/in/hetalgada20/ github.com/hetalgada15 SUMMARY

Dynamic Business Intelligence Analyst skilled in ETL, data integration, and advanced analytics. Proficient in Python, SQL, Tableau, Power BI, and Alteryx, leveraging AWS and Big Data technologies to transform data into actionable insights that drive strategic growth. EDUCATION

Master of Science in Information Systems (GPA: 3.89/4) Northeastern University, USA Aug. 2024 Relevant Courses: Data Architecture & Business Intelligence, Data Science Methods & Tools, Data Mining, Database Management Bachelor of Technology in Electronics & Telecommunication Engineering University of Mumbai, India May. 2021 SKILLS

Databases & Cloud : MSSQL, NoSQL, Hive, Hadoop, Oracle, Spark, Snowflake, Postgres, AWS, AzureML Languages : Python, R Programming, SQL, C, Java, Linux, MATLAB Libraries : Pandas, NumPy, Scikit-Learn, SciPy, Plotly, Seaborn, Matplotlib, Keras, NLTK Analytical Toolkit : Classification, Forecasting, Causal Inference, Probabilistic reasoning, Statistical analysis, Hypothesis Testing Proficiency : Machine Learning, ETL Processing, Business Intelligence, Data Analytics, Data Warehousing Tools : Alteryx, Anaconda, Tableau, Power BI, NetBeans, Looker, ER Data Studio, Navicat, Jira EXPERIENCE

Business Intelligence Analyst Contentstack Inc, San Francisco, California Jun. 2023 – Dec. 2023

• Leveraged REST API for real-time data acquisition in ETL pipelines using Airflow, Python, and AWS Lambda, resulting in significantly reducing data ingestion time by 2 hours per cycle and ensuring seamless data transfer to S3

• Designed and implemented robust ETL pipelines using the Salesforce object model, reducing data redundancy and enhancing collaboration between Jira and Salesforce systems, streamlining workflows and improving communication among teams

• Implemented a Release Management System for Jira by writing Python scripts to automate and efficiently merge data transfers into Snowflake tables, streamlining project workflows, improving data consistency, and enhancing integration efficiency by 36%

• Improved decision accuracy through advanced SQL modeling in Snowflake, resulting in a noticeable increase in data quality

• Generated interactive Tableau dashboards that communicated key insights, contributing to a $2.5 million increase in top-line growth Senior Risk Analyst Deloitte, Mumbai, India Jun. 2021 – Jul. 2022

• Developed and implemented comprehensive strategies to effectively align cross-functional KPIs with overarching business goals, achieving a remarkable 30% reduction in processing time through targeted and actionable data insights

• Implemented advanced workflows with Power BI and Python for enhanced financial reporting accuracy and streamlined processes

• Led key projects to improve data access and reporting, delivering valuable insights that supported organizational objectives

• Optimized data analytics in the risk department by identifying and rectifying critical errors, improving decision-making efficiency Business Intelligence Analyst Coloreyes Eyecare Pvt. Ltd., Mumbai, India Feb. 2020 – Mar. 2021

• Engineered scalable ETL pipelines using AWS Redshift, Python, and Talend, automating data ingestion and transformation, reducing processing costs by 30% and saving $200K annually through improved operational efficiency

• Orchestrated the integration of Oracle, NoSQL, and S3 to optimize data warehousing processes, improving query performance and data accuracy, which resulted in a $500K revenue boost by enabling faster, more informed decision-making across departments

• Crafted automated Tableau dashboards integrated with ETL workflows, providing real-time insights into distribution trends and customer behavior. This optimization reduced excess inventory by 20% and saved $150K annually in supply chain costs PROJECTS

New York City Food Inspection (Python, Talend, AWS, Alteryx, SQL, Tableau) [Github] Jan. 2023 - Apr 2023

• Successfully managed a complex data pipeline utilizing Alteryx and Talend to process 200k records, facilitating comprehensive analysis of food inspection trends and patterns that informed public health decisions

• Optimized dimensional modeling techniques, achieving a remarkable 40% reduction in query response times, thereby significantly enhancing analytical capabilities and enabling data-driven decision-making across multiple stakeholders Twitter Sentimental Analysis (NLTK, Python, API) [Github] Jan. 2023 - Apr 2023

• Engineered a robust tweet classification system leveraging the Twitter V3 API to accurately assess toxicity levels in real-time

• Performed comprehensive dataset preprocessing by eliminating special characters and stopwords using NLTK and SnowballStemmer, ensuring high-quality input for analysis

• Developed a Word2vec model that achieved 84% accuracy in classifying 1.6 million tweets into negative, positive, and neutral categories, providing valuable insights into public sentiment trends Campus Recruitment Management System (Python, SQL, Tableau, Power BI) [Github] Sept. 2022 - Dec 2022

• Upgraded the university portal with a centralized database of 90k records, improving data quality and query performance by 30%

• Enhanced user engagement through advanced encryption and personalized recommendation features, resulting in a 20% increase in participation, while leveraging Azure Data Studio and Tableau for effective implementation and visualization

Contact this candidate