Data Analyst Business

ANKITA PATIL

BUSINESS DATA ANALYST

USA +1-617-***-**** **************@*****.*** LinkedIn

SUMMARY

Business Data Analyst with around 4 years of experience in data analytics, business process optimization, and strategic decision- making. Adept at leveraging Python, SQL, and R to extract, clean, and analyze complex datasets, transforming raw data into actionable insights. Proficient in BI tools like Tableau and Power BI, enabling dynamic visualization and real-time reporting for enhanced decision-making. Skilled in requirements gathering and business process modeling, ensuring seamless collaboration between stakeholders and technical teams to align solutions with business objectives. Experienced in root cause analysis and predictive analytics, identifying patterns and inefficiencies to drive operational improvements. Passionate about automating reporting processes and implementing data-driven strategies to foster business growth and continuous optimization. SKILLS

Methodology: SDLC, Agile, Waterfall

Language: Python, R, SQL, SAS

IDEs: Visual Studio Code, Jupiter Notebook

Packages: Matplotlib, Seaborn, Plotly, ggplot2, SPSS Reporting & Visualization Tools: MS Project, MS Excel, PowerPoint, Tableau, Power BI Documentation: FRD, BRD, SRS, UML, RTM

Cloud & ETL Tools: AWS, Azure, GCP, DataBricks, Snowflakes, SSIS Statistical & Machine Learning: Linear/Logistic Regression, Decision Trees, Clustering, Time Series Analysis, A/B Testing Databases: SQL Server, MySQL, MongoDB

Analysis: Cost/benefit, Impact, GAP, Risk, SWOT

Tracking /Other Tools: JIRA, GIT, Test Director, MS Visio,HP Quality Center, ERP. Soft Skills: Project Management, Communication, Critical Thinking, Team Managing Operating Systems: Windows, Linux, Mac

EXPERIENCE

Costco, USA Business Data Analyst Jan 2024 – Current

Optimized resource allocation by utilizing SQL for data extraction and Power BI for visualization, driving a 30% improvement in operational efficiency by providing actionable insights from large datasets

Enhanced data security and quality by leading data governance initiatives, using Azure Data Lake for centralized storage and Role-Based Access Control (RBAC) for secure access management, improving compliance and data accuracy by 45%.

Developed and implemented a predictive analysis algorithm using Python and scikit-learn, boosting product forecasting accuracy by 20% and enabling better inventory and demand planning.

Conducted advanced data mining and visualizations with SAS, resulting in a 20% increase in ad revenue by refining targeted marketing strategies.

Designed and implemented a data correction framework using SQL and Python, reducing data discrepancies by 15% and enhancing the reliability of business intelligence reports.

Leveraged Snowflake for data warehousing, improving data integration and query performance, enabling advanced analytics across large datasets.

Utilized Alteryx for streamlining data preparation and automating complex workflows, achieving a 30% improvement in data processing efficiency.

Applied regression modeling techniques with R to analyze customer behavior, contributing to a 10% increase in customer retention through data-driven engagement strategies.

Refined sales predictions by implementing statistical modeling in Python, improving forecast accuracy by 18%, and enabling better revenue planning.

Led the design and implementation of a data collection system using MongoDB for efficient storage and Azure Data Factory for seamless ETL processes, boosting operational efficiency by 25% and streamlining reporting workflows.

Contributed to creating a data analytics roadmap that influenced new product development strategies, recapturing 15% of lost market share through data-driven decision-making. Inside Sherpa (Sunpharma Health, HDFC Bank, KPMG), India Business Data Analyst Mar 2020 – Aug 2022

Developed and deployed advanced analytics models, driving a 40% increase in market conversion rates through data-driven insights.

Developed and deployed advanced analytics models using Python (scikit-learn, TensorFlow), driving a 40% increase in market conversion rates by providing actionable data insights.

Implemented machine learning algorithms (e.g., decision trees, clustering) in Python, automating key processes and saving 30 hours per week in manual effort, resulting in improved operational efficiency.

Led a team of data analysts, implementing a data-driven culture using tools like Power BI and SQL, enhancing productivity by 25% and streamlining decision-making.

Optimized SQL queries and data warehousing strategies (Snowflake, Amazon Redshift), enabling deeper data analysis and contributing to a 15% increase in annual revenue through faster insights.

Defined data strategy and governance frameworks using Apache Kafka and Apache Airflow, improving system efficiency and data quality by 30%, ensuring seamless accessibility for stakeholders.

Designed and implemented a scalable ETL framework using Apache Spark and AWS Glue, reducing data processing time by 20% and enhancing pipeline efficiency.

Conducted deep-dive analyses using SQL and Python (Pandas, NumPy), extracting insights from product performance metrics, resulting in data-backed recommendations for strategic improvements.

Implemented A/B testing frameworks in Python and R, analyzing user behavior and optimizing product features, leading to a 15% increase in customer engagement.

Applied data mining and machine learning (Random Forest, XGBoost) to automate report generation, boosting reporting efficiency by 40% and reducing turnaround time.

Produced detailed data reports using Tableau and SQL, influencing strategic business decisions that led to a 10% improvement in operational performance.

Enhanced statistical procurement models using Python and forecasting techniques (ARIMA), reducing procurement costs by 10% through optimized demand forecasting and cost analysis. EDUCATION

Master of Science in Information Systems Sep 2022- Dec 2024 Northeastern University

Bachelor of Computer Engineering Aug 2017- May 2021 Mumbai University Mumbai, Maharashtra

PROJECTS

Data Analysis of HR Attrition Data

• Pre-processed data with 10M+ records using SQL; assembled Dimensional Model & reduced data duplication by 75% designing an optimized star schema with ER Studio. Generated slowly changing dimensions (Type 2) using Talend

• Enforced Data Ingestion using Alteryx for ETL pipelines & achieved data processing speed of over 75,000 records per minute. Deployed the database on Azure, created dashboard using Tableau to generate greater insights and KPIs Predictive Modeling and Analysis for Laptop Pricing

• Conducted Exploratory Data Analysis (EDA) and developed a linear regression model using Python,scikit-learn, pandas, and matplotlib, achieving an R^2 score of 0.85. Identified RAM as a pivotal factor increasing laptop prices per GB

• Leveraged diverse plotting techniques including Q-Q plots, histograms, boxplots, and bar plots for in-depth data analysis and visualization. These clarified the impact of RAM on laptop pricing and supported robust outlier detection Asset Mind Pro (Product Management, Agile Methodolgies, Gantt Charts)

• Utilized Agile methodologies and Gantt charts to develop clear development roadmaps, ensuring precise planning of product features and milestones while fostering innovation through the integration of emerging technologies

• Implemented Six Sigma principles, Kanban boards to enhance process efficiency, reduce defects & facilitate seamless communication and coordination among team members, resulting in timely project delivery and optimized workflows

Contact this candidate