Data Analyst Power Bi

SIMRAN SINGH

+1-520-***-**** ***********@*******.*** LinkedIn GitHub Portfolio

Data Analyst with 2.5 years of experience across healthcare, finance, and operations, specializing in acquiring, analyzing, and

visualizing data from diverse sources. Skilled in SQL programming, Python, Power BI, and statistical techniques to develop predictive

models and deliver advanced analytics solutions. Experienced in collaboration with stakeholders and cross-functional teams.

SKILLS

Technical & Programming: SQL (advanced queries, joins, CTEs), Python (pandas, numpy, scikit-learn), R, VBA, Machine Learning

Data Visualization Tools & BI: Power BI, Tableau, MicroStrategy, Excel (macros, pivot tables, VBA), JIRA, Git

Data Handling & Cloud: ETL pipelines, data wrangling, AWS (S3, Redshift), Azure Data Factory, Snowflake, dbt, data modeling

WORK EXPERIENCE

Data Analyst Storied Data New Jersey, USA May 2024 - August 2024

• Analyzed large financial and operational datasets for 3+ clients, to perform report automation and automated python scripts for data cleaning

• Wrote advanced SQL queries to extract, perform data wrangling and data analysis, maintain ETL data pipeline improving accuracy to 95%

while adhering to GDPR and CCPA, saving teams 10+ hours weekly.

• Performed ad hoc statistical analyses and Power BI data visualization to validate hypotheses and develop predictive models, improving

forecast accuracy

• Collaborated with product, compliance, and data engineering teams to enhance dashboard usability through A/B testing

Business Intelligence Analyst Biotb December 2022 - August 2023

• Collected, cleaned, and analyzed large healthcare datasets from internal EMR systems and external sources using Python and SQL, ensuring

accuracy and compliance with HIPAA

• Extracted and manipulated complex healthcare datasets using Python and SQL, ensuring data governance by conducting audits and

troubleshooting discrepancies through thorough root cause analysis.

• Developed regression-based forecasting models using Python to predict patient no-shows and peak hours

• Worked cross-functionally with clinical, engineering, and product teams to support strategic initiatives and data-driven decision making.

Data Analyst Federation of Indian Chambers of Commerce & Industry May 2022 - September 2022

• Extracted, cleaned, and validated data from multiple internal and external sources using SQL and AWS tools to identify patterns

affecting event performance, enabling the team to uncover trends that improved planning strategies.

• Designed 8+ dashboards and reports in Power BI and Excel to visualize attendance, marketing results, and campaign effectiveness,

helping teams track and optimize 15+ event initiatives.

• Delivered ad hoc reports and visual stories to stakeholders, improving audience targeting and driving a 30% increase in registrations

and boost in workflow efficiency through effective report automation.

Business Analyst Intern The Sparks Foundation May 2021 - September 2021

• Applied Agile methodologies to analyze customer behavior and segment markets, helping the team tailor marketing strategies that

increased sales by 20% across retail groups.

• Developed 5+ interactive dashboards in MicroStrategy, providing stakeholders with actionable insights and trend visibility that drove a

30% boost in key product area sales.

• Collaborated with stakeholders and cross-functional teams to create KPI tracking reports for churn, engagement, and customer

lifetime values, reducing data processing time by 25% and supporting growth initiatives through in-depth customer insights.

• Created documentation for dashboard usage and data processes, supporting team training and best practices.

EDUCATION

University of Arizona, Tucson USA Master’s in Management Information Systems August 2023- December 2024

Vellore Institute of Technology, India Bachelor’s in Computer Science Engineering July 2019- July 2023

ACADEMIC PROJECTS

Data Analytics Challenge Arizona Accident Analytics: Innovations for Safer Travel

• Extracted and processed 5 years of real-time traffic fatality data from NHTSA using Python and ETL tools to ensure data quality and

identify critical risk factors impacting road safety.

• Developed compelling Tableau dashboards and statistical summaries that translate complex data into clear visual insights and

actionable recommendations for stakeholders focused on safer travel initiatives.

Business Intelligence Analyst Airbnb Market Insights & Optimization

• Analyzed a dataset of 50K+ Airbnb listings using R and machine learning techniques to detect pricing and engagement trends across

diverse global markets.

• Delivered PowerPoint presentation to communicate findings to technical and non-technical audience

Contact this candidate