Data Analyst Power Bi

Ashika Chattu Data Analyst

St. Louis, MO, USA +1-901-***-**** ************@*****.*** LinkedIn SUMMARY

Data Analyst with nearly 3 years of experience using SQL, Python, and Power BI to analyze user behavior, automate reporting, and improve business outcomes. Delivered measurable impact by increasing conversion rates, reducing churn, and supporting A/B testing. Experienced in cohort analysis, statistical testing, and ETL automation across Redshift, Snowflake, and Alteryx. Collaborated with product, UX, and marketing teams to build dashboards, validate experiments, and present insights that supported feature decisions and operational improvements. TECHNICAL SKILLS

Data Analysis: Exploratory Data Analysis (EDA), A/B Testing, Hypothesis Testing, Trend & Cohort Analysis Programming: Python (Pandas, NumPy, Seaborn, Matplotlib), SQL (Joins, CTEs, Window Functions) Visualization: Power BI, Tableau, Looker, Excel (Power Query, Pivot Tables, Charts) Data Handling: Data Cleaning, Transformation, Outlier Handling, Feature Engineering Databases: PostgreSQL, MySQL, SQL Server, Snowflake, Google BigQuery Cloud Platforms: AWS (S3, Redshift, Athena), GCP (BigQuery), Azure Data Studio ETL & Automation: dbt (basic), Apache Airflow (basic), Alteryx, SQL-based ETL pipelines Statistics & Modeling: Descriptive Stats, Regression, Clustering, Time Series Forecasting (basic) Tools & Collaboration: Git, GitHub, Jira, Confluence, Slack, Notion Soft Skills: Data Storytelling, Communication with Stakeholders, Business Insight PROFESSIONAL EXPERIENCE

Wayfair, TX, US Jan 2025 - Current

Data Analyst

• Analyzed 10M+ user sessions using SQL and Python to identify checkout friction points, implementing funnel improvements with stakeholders, driving a 12% increase in purchase conversion rate across platforms.

• Designed and executed A/B testing on homepage and landing page modules, applying t-tests and chi-square validation, resulting in an 8% improvement in click-through rates and 22% higher user engagement.

• Built and maintained Power BI retention dashboards tracking cohorts, enabling marketing teams to reduce churn by 10% over two quarters and create targeted re-engagement campaigns for inactive users.

• Automated recurring revenue and sales reporting using SQL queries and Power Query, eliminating manual Excel errors, reducing reporting effort by 8 weekly hours, and improving overall reporting consistency significantly.

• Integrated over 40 Redshift and Snowflake tables into Power BI dashboards using certified datasets, reducing dashboard load times by 35% and increasing refresh accuracy by 50% across business teams. Palantir, India Apr 2022 - Jul 2023

Data Analyst

• Cleaned and transformed public sector datasets using Python and SQL, increasing dashboard reliability and improving the downstream usability of data for logistics and operational analysis.

• Defined SLA monitoring dashboards using Power BI, improving visibility of response times and reducing SLA breach rate by 18% through faster issue escalation and resolution.

• Applied regression and clustering on transport behavior datasets, helping identify delay patterns and optimize route scheduling based on historical performance and operational KPIs.

• Automated daily ETL workflows using Alteryx and SQL scripts, reducing data refresh time from 24 hours to under six and improving real-time reporting capabilities.

• Maintained Confluence-based documentation for models, dashboards, and SQL logic, reducing analyst onboarding time and improving knowledge sharing across analytics and operations teams. Pinterest, India Aug 2021 - Mar 2022

Jr. Data Analyst

• Analyzed 5M+ user activity events using Pandas and SQL, identifying seasonal behavior trends and guiding content teams on strategic category placements.

• Supported 12+ A/B tests by tracking click-through rate, bounce rate, and time-on-site; delivered actionable summaries that decreased feature adoption by 18% and reduced bounce rate by 12%.

• Guided Excel dashboards with pivot tables and charts to track marketing campaign metrics, cutting report generation time by 35% and improving update accuracy.

• Created and maintained documentation for SQL queries, metric definitions, and dashboard instructions in Confluence to ensure consistent reporting practices and faster team onboarding.

EDUCATION

Masters in Information Systems Saint Louis University, USA May 2025 Bachelors in Information Technology KITS, India May 2023 CERTIFICATION

AWS Academy Graduate – Cloud Foundations Digital Credential: https://www.credly.com/go/NDLbSWE3 Microsoft Technology Associate – Introduction to Programming using HTML PROJECT

Job Market Trends and Salary Benchmarking for Cloud Architect Role

• Built a data-driven recruiter dashboard using React, Power BI, and JSON to analyze salary trends, job demand, and cloud skill distribution with filters, visualizations, and workforce planning insights.

• Implemented resume matching and parsing logic to improve talent screening accuracy, while collaborating in a five-member Agile team and contributing to UI/UX design, data routing, and Git-based project management.

Contact this candidate