Data Analyst Power Bi

Business Analyst

Boston, MA 617-***-**** LinkedIn

Summary

Highly motivated Data Analyst with 4+ years of experience transforming complex datasets into actionable insights to empower data-driven decision-making. Proficient in designing interactive dashboards, building ETL pipelines, and conducting advanced statistical analysis to optimize business processes and enhance performance. Adept at leveraging modern tools and technologies, including Power BI, Tableau, Python, SQL, and cloud platforms like Azure and AWS, to streamline workflows and unlock data potential. Skilled in crafting SQL queries, Python-based data analysis, and statistical modeling to support business and optimize operational workflows. collaborating cross- functionally to solve complex problems.

Skills

Methodologies: SDLC, Agile (Scrum), Waterfall

Data Visualization Tools: Tableau, Power BI, Plotly Dash

Databases: MySQL, MS SQL Server, Azure SQL Database, AWS RDS, MongoDB

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

ETL Tools: AWS Glue, Azure Data Factory, SSIS

Big Data Tools: Hadoop HDFS, Apache Spark, Hive, Spark SQL

Statistical Analysis: Hypothesis Testing, Regression Analysis, T-tests, ANOVA, MANOVA

Analysis: Cost/benefit analysis, Impact analysis, GAP analysis, Risk analysis, SWOT analysis

Machine Learning: Feature Engineering, Decision Trees, Logistic Regression, Random Forest

Version Control & CI/CD: Azure DevOps, Git

Data Analysis Techniques: A/B Testing, Segmentation, Cohort Analysis, EDA

Soft Skills: Problem-Solving, Critical Thinking, Business Acumen, Stakeholder Management, Analytical Thinking, Design Thinking Certifications

● Microsoft Certified: Data Analyst Associate

● AWS Certified Data Analytics Specialty

Experience

Allstate, USA Data Analyst Jun 2023 – Current

Developed Power BI dashboards to provide real-time insights into business metrics, integrating multiple data sources such as Azure SQL Database and Azure Data Lake, with a strong focus on Data Wrangling to clean and prepare raw data for analysis.

Leveraged Python for data preprocessing, cleaning, and analysis, which contributed to a 20% improvement in data accuracy.

Responsible for designing, developing, and deploying Business Analytics Dashboards using Microsoft BI technologies including SQL Server, Power BI, Excel etc.

Generated reports Managed and tracked project progress using project management and reporting tools, including MS Project, MS Excel, MS Access, MS SharePoint, and Tableau Services.

Automated deployment of Power BI datasets and reports using Azure DevOps pipelines, ensuring version control and CI/CD integration.

Pre-processed data for machine learning workflows, handling tasks like feature engineering, data normalization, and missing value imputation using Python.

Conducted data aggregation, data reconciliation, testing and analysis on complex transaction datasets using SQL and VBA in Excel, increasing data quality and data integrity by 40%

Communicated insights to stakeholders using Tableau dashboards, Jupyter Notebook, and detailed presentations in MS PowerPoint.

Utilized SQL for data extraction and analysis, producing reports and visualizations in MS Excel, and Tableau. Brightmind Technogies, India Data Analyst Aug 2019 - Jul 2021

Designed and maintained dynamic Tableau dashboards to monitor and visualize real-time KPIs, integrating A/B testing frameworks with external APIs and internal databases, while ensuring adherence to data governance standards.

Conducted in-depth data mining and data cleaning to analyze customer purchase behavior, leveraging AWS services (S3, RDS) for scalable data storage and management.

Built ETL pipelines to extract data from various sources, utilizing AWS Glue for data transformation, automated workflows, and ensuring compliance with data governance policies.

Engineered MySQL table schemas and implemented optimized stored procedures for efficient customer data processing.

Queried and validated large datasets using Python with Pandas and NumPy to ensure data integrity, detect inconsistencies, and perform data cleaning.

Developed and evaluated machine learning models (e.g., Decision Trees, Random Forest) to predict customer retention, using data stored in AWS Redshift.

Performed statistical analysis, including hypothesis testing and regression modeling, with R to derive actionable insights that increased GANESH BOGINENI

Data Analyst

Batavia, OH 937-***-**** ***********@*****.*** LinkedIn sales conversion rates.

Automated data ingestion workflows into AWS S3 using Python scripts and integrated data with Hadoop HDFS for distributed processing.

Leveraged Apache Spark for analyzing datasets exceeding 2TB, utilizing Spark SQL for advanced querying and aggregations.

Communicated insights to stakeholders using Tableau dashboards, Jupyter Notebook, and detailed presentations in MS PowerPoint.

Utilized various analysis techniques, such as cost/benefit analysis, impact analysis, GAP analysis, risk analysis, and SWOT analysis, to evaluate project feasibility and identify opportunities for improvement.

Steered Agile rituals, ensuring each project phase aligned with set benchmarks, heightening project uniformity by curtailing phase deviations by 14%.

Education

Master of Science in Computer Science Wright State University, Fairborn, Ohio Aug 2021 – Apr 2023 Bachelor of Computer Science Gitam University, Visakhapatnam, Andhra Pradesh Aug 2016 – Apr 2020

Contact this candidate