Power Bi Data Analyst

Sameer Ahmed

+1-774-***-**** *.*****************@*****.*** Open to Relocation

Summary

Data Specialist with over 3+ years of experience in data analytics, ETL pipelines, and visualization tools, including Power BI and Tableau. Proven expertise in optimizing SQL workflows, automating processes using Python and VBA, and ensuring data compliance with (HIPAA, GDPR). Adept at building predictive models and leading Agile methodology-driven projects. Known for translating technical insights into actionable business solutions, driving cross-functional collaboration, and delivering scalable, measurable results.

Technical Skills

Programming: SQL, Python (Pandas, NumPy, Matplotlib), R, Java, VBA

Data Tools: Power BI, Tableau, Snowflake, Azure Data Factory, AWS, SPSS, Microsoft Excel

Databases and cloud: MySQL, Azure SQL, Snowflake, NoSQL, SQL Server, Microsoft Access

Methods & Concepts: ETL, Data Modeling, Data Governance, Story Telling, Machine Learning, Statistical Analysis, GIS Mapping

Soft Skills: Problem-solving, Cross-Functional Team Collaboration, Technical Communication

Work Experience

Data Analyst

Illinois Department of Human Services, Springfield, IL Feb 2023 – Aug 2024

•Data Visualization & Reporting: Designed interactive Power BI/Tableau dashboards to track KPIs for the Illinois Prescription Monitoring Program, reducing decision-making time by 25% and enhancing stakeholder engagement.

•Process Automation: Engineered Python scripts and Azure Data Factory pipelines to automate data validation, eliminating 45% of manual errors and saving 20+ hours/month.

•SQL Optimization: Refactored SQL queries and indexing strategies, accelerating data retrieval speeds by 30% for 50K+ records to improve reporting efficiency.

•Compliance & Governance: Conducted HIPAA-compliant audits across multiple databases, ensuring 100% data integrity and regulatory adherence.

•Cloud Migration: Led a strategic migration from legacy systems to Snowflake, centralizing data storage and reducing retrieval latency by 30% across teams.

•Cross-Functional Leadership: Collaborated closely with policy and GIS teams(ArcGIS) to integrate spatial analysis into dashboards. Additionally, designed and conducted training sessions and virtual workshops for junior employees and stakeholders, achieving a 20% increase in tool adoption while reducing support tickets.

Electronic Data Programmer

Hyderabad Metropolitan Water Supply & Sewage Board, Hyderabad, TS Nov 2020 - June 2022

•ETL Pipelines: Developed robust SQL workflows to process 50K+ daily records, cutting turnaround time by 30% for public service initiatives.

•Data Integrity: Implemented comprehensive data validation protocols achieving 99.8% accuracy in public infrastructure reporting.

•Process improvement: Automated routine Excel tasks using macros, saving 10+ hours/week and reallocating resources to strategic projects; built Excel dashboards to visualize key trends.

•Cross-functional workflows: Redesigned data workflows in partnership with analysts to boost system efficiency by 20% and ensure regulatory guidelines.

•Stakeholder collaboration: Utilized Agile methodology and coordinated continuous feedback sessions with stakeholders to refine and improve data workflows.

Data Analyst

Marri Laxman Reddy Institute of Technology, Hyderabad - TS Feb 2020 - Nov 2020

•Academic Insights Automation: Designed interactive Tableau dashboards (with iterative updates) to monitor student performance, faculty workloads, and admissions trends, reducing manual reporting efforts by 15 hours/month for department heads.

•Data Governance & Compliance: Audited 5,000+ student records using SQL and Excel, resolving 200+ inconsistencies to ensure 99% accuracy for NAAC/NIRF accreditation submissions.

•Process Streamlining: Automated recurring data workflows (e.g., exam results, attendance) with Python scripts, cutting manual processing time by 30% and minimizing errors for administrative teams.

•Collaborative Standardization: Worked with academic departments to transform legacy Excel templates into four standardized dashboards, improving cross-departmental data accessibility and KPI alignment.

Projects

Stock Market Prices Prediction and Analysis Python, Scikit-Learn, Machine-Learning Algorithms

Build a prediction model to predict the stock market’s value at risk, which will help analyze stock prices.

•Developed a predictive model to analyze stock market trends and assess risks, achieving a 90% accuracy rate in stock predictions. Implemented Monte Carlo simulations and Bootstrap algorithms to refine risk assessments and enhance prediction reliability.

•Employed advanced machine learning algorithms and statistical analysis to provide data-driven investment insights, leading to a 10% improvement in decision-making speed for investors.

Analysis of Google Play Store Apps Python, Tableau, Scikit-Learn, Machine-Learning Algorithms

Developed a model that tells us the best application available on Play store based on the reviews and downloads.

•Conducted a comprehensive analysis of Google Play Store apps, predicting app success factors with an 85% accuracy using random forest algorithms. This analysis helped developers optimize app features, resulting in a 12% increase in user engagement.

•Extracted, cleaned, and analyzed large datasets using web scraping techniques and Python libraries, providing valuable insights into app performance, user behavior, and market trends.

Education

University of Illinois, Springfield, IL

Master of Science in Computer Science Aug 2022 – Aug 2024

Jawaharlal Nehru Technological University, Hyderabad, IN

Bachelor of Technology in Computer Science and Engineering June 2016 – Oct 2020

Certifications & Accomplishments

Certifications:

Microsoft PowerBI Data Analyst – Microsoft Learn

Microsoft Azure Data Fundamentals – Microsoft Learn

Certified in Python Data Analysis – LinkedIn Learning

Certified in Visualizing Data using Tableau – LinkedIn Learning

Get started with Databricks for Data Engineering – Databricks

Machine Learning – NPTEL (National Programme on Technology Enhanced Learning)

Accomplishments:

Published and presented two IEEE Standard Research Papers on Mini and Major Academic Projects.

Presented a startup idea at a National Conference and participated in the TCS CodeVita coding competition.

Participated in the Artificial Intelligence & Cognitive Conference (AICC) at the MLR Institute of Technology.

Contact this candidate