Data Analyst Business Intelligence

HIMANSHU PRAJAPATI Data Analyst Business Intelligence SQL & Tableau Expert

Tampa, FL Open to Relocate *********************@*****.*** 656-***-**** LinkedIn GitHub SUMMARY

Data Analyst with 4 years of experience in Python, SQL, Tableau, and AWS. Proven record of transforming large datasets into actionable insights to support strategic business decisions. EDUCATION

MS, Artificial Intelligence & Business Analytics GPA 3.8 University of South Florida Aug 2023 - May 2025 PROFESSIONAL EXPERIENCE

Data Analyst GA University of South Florida Tampa, FL Aug 2024 - May 2025

• Crafted an interactive Tableau dashboard to track key performance indicators (KPIs), improving decision-making by 15% through real-time insights.

• Managed large datasets (100,000 records) using Python, R, Pandas, and SQL for data preparation and statistical analysis.

• Applied Excel functions and data governance practices to consolidate datasets and ensure data quality across reporting workflows.

• Used Git-based version control to manage Tableau workbook iterations and automate report delivery. Data Analyst Thomson Reuters India Jun 2021 - Jul 2023

• Automated Python coverage reporting for unit, integration, and XSLT tests on GitHub, reducing bug reporting time by 20%.

• Led a cross-functional team to optimize SQL queries and improve performance by 5%; used data modeling best practices for schema redesign.

• Automated recurring Tableau and SQL-based reports using scheduled scripts, reducing manual reporting time by 40% and ensuring on-time delivery.

• Built scalable ETL pipelines using AWS Glue, S3, and Snowflake, improving pipeline efficiency by 40% and lowering operational costs.

• Conducted profitability analysis across customer segments using Python and Excel, identifying key drivers impacting margins and revenue trends.

• Translated business requirements from cross-functional stakeholders into actionable insights, aligning dashboards and reports with decision-making needs.

Data Analyst SKYTEK India May 2020 - May 2021

• Automated pipelines using Python (NumPy, Scikit-learn) and SQL; improved report accuracy by 15%.

• Developed 10+ interactive dashboards in Power BI and conducted predictive modeling for HR compensation analysis.

• Devised statistical analysis pipelines (descriptive, predictive, and causal) using Python and SQL to uncover workforce trends and drive data-informed HR decisions, improving compensation strategy accuracy by 25%.

• Scraped and analyzed COVID-19 trends using Selenium and Beautiful Soup; visualized findings with Matplotlib and Seaborn.

• Collaborated in an Agile/Scrum environment with weekly sprints and sprint retrospectives.

• Constructed Python-based web scraping pipelines using Selenium and Beautiful Soup to extract 10,000+ COVID-19 data records, followed by data analysis to identify and visualize states most impacted by the pandemic. ACADEMIC PROJECT

Banking Data Analytics

• Imported and structured 50,000+ banking records from Excel into MySQL, handled data imputation for missing data.

• Performed EDA in Python to uncover customer risk factors and identify a 15% higher default rate among specific demographics.

• Designed an interactive Power BI dashboard tracking 10+ key risk indicators (KPIs), improving stakeholder visibility into risk trends and enabling timely, data-driven mitigation actions. Global Child Labor Trends (Data Visualization)

• Analyzed child labor data from 100+ countries, uncovering that lower GDP per capita correlated with up to 45% higher child labor rates; designed interactive Tableau dashboards with slicers and calculated fields for insights.

• Created KPI-driven visualizations (heatmaps, trend graphs, correlation plots) that reduced manual data analysis by 30% and supported NGOs in prioritizing targeted intervention strategies. SKILLS

Programming Languages: Python, R, SQL, Shell Scripting, C, MATLAB, C# Libraries/Frameworks: Pandas, NumPy, Scikit-learn, Matplotlib, Seaborn, Selenium, Beautiful Soup Cloud Platforms & Tools: AWS (EC2, Lambda, Glue, S3, CloudFormation, Redshift, Athena), Snowflake, Azure (basics) Databases: Oracle DB, MySQL, PostgreSQL, BigQuery (basic exposure), pgAdmin Cloud technologies & tools: AWS Lambda, Auto Scaling, EC2, CloudWatch, etc. Data Visualization Tools: Tableau, Power BI, Tableau Public, Matplotlib, Seaborn, Business Intelligence Other Tools & Concepts: Git, CI/CD, Big Data, Data Modeling, Data Governance, Data Quality, Data Lineage Methodologies: Agile, Scrum, Cross-functional collaboration, Stakeholder Communication CERTIFICATION

AWS Certified Associate Solutions Architect

Certified HL7 FHIR Foundational Implementer, V2.8 Control Specialist Certified

Contact this candidate