Data Analyst Power Bi

Dhruvin Patel

Data Analyst

Herndon VA 703-***-**** ************.******@*****.*** LinkedIn

SUMMARY

Results-driven Data Analyst with over 3 years of professional experience transforming raw data into actionable insights and interactive dashboards to support business goals. Proven ability to work with large datasets using SQL and Python, build compelling reports in Power BI and Tableau, and communicate complex findings to non-technical stakeholders. Strong background in statistical analysis, data modeling, and reporting automation. Known for delivering measurable improvements to processes, revenue, and customer engagement through data-driven strategies. SKILLS

Programming & Scripting: Python (Pandas, NumPy, Matplotlib, Seaborn), R (basic) Databases & Querying: SQL (MySQL, PostgreSQL, MS SQL Server), MongoDB Data Visualization: Power BI, Tableau, Excel Dashboards Data Wrangling & ETL: Pandas, Power Query, Alteryx, Talend Cloud & Platforms: AWS (Redshift, S3), Google BigQuery Statistical Analysis: A/B Testing, Hypothesis Testing, Forecasting, Linear/Logistic Regression Excel Expertise: Pivot Tables, VLOOKUP, INDEX-MATCH, Macros, Data Validation Tools & Collaboration: JIRA, Trello, Agile/Scrum, Confluence Soft Skills: Analytical Thinking, Stakeholder Communication, Business Acumen, Problem Solving WORK EXPERIENCE

Extended IT Arms Solutions Pvt Ltd., Ahmedabad, India Data Analyst March 2022 - Sept 2023

Designed and deployed Power BI dashboards for sales, inventory, and finance departments, increasing data visibility and reducing manual reporting by 60%.

Extracted, transformed, and loaded (ETL) datasets from MySQL databases, optimizing SQL queries that improved data retrieval time by 35%.

Automated weekly and monthly reports using Python scripts and Excel macros, reducing reporting effort by over 20 hours per month.

Conducted trend and correlation analysis on customer transaction data to uncover patterns that informed pricing and marketing strategies.

Collaborated with cross-functional teams to define KPIs and business metrics aligned with strategic objectives.

Performed root cause analysis using data mining techniques to support issue resolution and process improvements. The Pioneer Tech, Ahmedabad, India Data Analyst Aug 2021 - Feb 2022

Developed Tableau dashboards to monitor campaign effectiveness, funnel performance, and user engagement metrics.

Conducted segmentation analysis using K-means clustering on customer behavior data to optimize marketing strategies.

Cleaned and normalized unstructured datasets using Python (Pandas, Regex), enabling smoother integration into BI tools.

Delivered monthly data insights to product and marketing teams that directly influenced customer retention improvements.

Led requirements gathering sessions with internal stakeholders to translate business needs into analytical solutions. Tungsten Automation (formerly Kofax), India Data Analyst Apr 2020 - July 2021

Supported the development of operational KPIs and performance scorecards using Excel and Power BI.

Analyzed server logs and user activity data to identify process inefficiencies and propose automation opportunities.

Worked with IT and data engineering teams to build structured data pipelines from semi-structured inputs.

Conducted A/B testing for new feature rollouts and interpreted statistical significance using Python and Excel tools.

Authored technical documentation and training material for business users on dashboard usage.

Improved data reporting cycle by 50% by implementing data pipelines and auto-refresh dashboards. EDUCATION

Master of Science in Computer Science

University of North America, Virginia, US June 2025 Bachelor of Science in Computer Engineering

Gujarat Technological University, Ahmedabad, India July 2021

Contact this candidate