Data Analyst Power Bi

SHRADDHA SUNIL FALLE

Baltimore, MD **************@*****.*** 716-***-****

EDUCATION

University at Buffalo, Buffalo, NY GPA: 3.66/4.0 Jan 2023 - May 2024 Master of Science in Data Science

Pune University, Pune, India Jul 2015 – May 2019

Bachelor of Engineering

SKILLS

Languages: Python, R, SQL

Databases: MySQL, SQL Server, PostgreSQL

Visualization Tools: Power-BI, Tableau, Looker Studio, Qlik Technologies: Microsoft Azure, AWS, GCP, SSIS, SSAS, SSRS, Snowflake, Power Automate, Google Analytics Marketing Platforms: Google Ads, Amazon Marketplace, Facebook Ads, Shopify, Google Analytics, GA4 WORK EXPERIENCE

Data Analyst Trainee & Intern CCS Global Tech Remote Sep 2024 – Present

• Underwent intensive training in enterprise data tools, including SQL Server, SSIS, Power BI, Azure Data Factory, Azure Synapse, Databricks, Power Apps, and Snowflake, focusing on real-world applications in data analytics and engineering.

• Built interactive dashboards in Power BI and Tableau to visualize KPIs and business metrics, simulating client reporting scenarios.

• Practiced data extraction, transformation, and loading (ETL) techniques using SSIS and Azure Data Factory to automate data pipelines.

• Gained hands-on experience with Azure Synapse and Databricks for big data processing and analytics at scale.

• Developed end-to-end data workflows integrating Snowflake for cloud data warehousing and Power Apps for user-facing data entry tools.

• Cleaned and transformed datasets using SQL and Excel Power Query to prepare for analysis and machine learning models.

• Participated in guided client-simulation projects focused on predictive analytics, data storytelling, and stakeholder communication.

Digital Marketing Data Analyst ViralMint Media Pvt. Ltd., Pune, India Jan 2022 - Jan 2023

• Analyzed large datasets from marketing platforms (Meta Ads, Google Ads, Amazon Ads, Shopify, etc.) using SQL and Python to identify key drivers of performance and improve campaign outcomes.

• Designed interactive dashboards in Power BI and Looker Studio integrating SQL and DAX, enabling real-time tracking of KPIs such as Customer Acquisition Cost (CAC), Click-Through Rate (CTR), Conversion Rate (CR), Cost per Impressions (CPM), and ROAS leading to a 10% month-over-month increase in ROI.

• Performed Search Engine Optimization (SEO) and keyword analysis to improve organic visibility and performance tracking.

• Developed and optimized stored procedures and SQL queries to automate data extraction and transformation, reducing reporting time.

• Conducted customer segmentation, market basket analysis, and Customer Lifetime Value (CLV) prediction using SQL, Python, and Excel (Pivot Tables, Power Query, Macros, and VBA).

• Collaborated with marketing teams to define KPIs and attribution models, driving data-informed strategy that boosted customer engagement.

• Led A/B testing initiatives and exploratory data analysis to measure marketing impact and recommend optimization strategies.

• Automated reporting pipelines using SQL and Excel Macros, reducing manual work and improving data accuracy. Data Scientist Trainee (Intern) Devtown, Pune, India Aug 2021 - Dec 2021

• Trained in data preprocessing, statistical modeling, and various machine learning algorithms, gaining a solid foundation in data science methodologies.

• Developed predictive models and conducted in-depth data analyses, significantly enhancing technical skills and contributing to

• real-world projects.

• Utilized SQL and data warehousing tools such as Snowflake and Azure to efficiently manage, query, and organize large datasets.

• Created insightful data visualizations using Python and Power BI to effectively communicate analytical findings and trends. System Administrator Wipro Ltd, Pune, India Nov 2019 - Feb 2021

• Managed IT infrastructure for 10,000+ users, ensuring optimal performance and security.

• Reduced security breaches by 40% through effective measures and compliance.

• Applied Agile methodologies to enhance IT operations, enabling rapid adaptation to changing requirements and improving service delivery.

• Collaborating with cross-functional teams to prioritize and resolve user issues within SLA, resulting in a 25% decrease in average resolution time.

• Implemented and managed Azure cloud services, optimizing resource allocation and enhancing system reliability.

• Managed SQL databases to ensure data integrity, optimize performance, and support business-critical applications. ACADEMIC PROJECTS

Cloud-Based ETL Pipeline for Sales Analytics Azure Data Factory, Azure SQL Database, Synapse, Power BI Nov 2024 – Dec 2024

• Designed and implemented an end-to-end ETL pipeline using Azure Data Factory to automate data ingestion from multiple sources.

• Stored and processed sales data in Azure SQL Database and optimized analytical queries using Azure Synapse.

• Developed interactive Power BI dashboards to provide real-time insights into sales trends and business performance. Predicting CLV in Ecommerce Python, Jupyter Notebook, EDA, Predictive Modeling, Tableau Mar 2024 – May 2024

• Analyzed consumer transaction data from an e-commerce site using machine learning algorithms to predict CLV.

• Delivered actionable insights that informed strategic decision-making in a competitive e-commerce market.

• Developed interactive visualizations using Matplotlib, Seaborn, and Tableau to present trends, correlations, and model performance.

Sales Data Management System PostgreSQL, ER Diagram, Normalization Oct 2023 – Dec 2023

• Designed a normalized database schema in PostgreSQL to enhance data integrity, reduce redundancy, and improve data consistency.

• Optimized query performance by implementing advanced indexing strategies, such as B-tree and hash indexes, ensuring faster data retrieval and efficient query execution.

• Designed a normalized PostgreSQL database to enhance data integrity and query performance. CERTIFICATIONS

• Google Data Analyst

• Foundations of Data Science

Contact this candidate