Data Analyst Power Bi

Niharika

Phone: +1-848-***-**** Email: ********************@*****.*** Chicago, IL

Professional Summary

Highly analytical Data Analyst with 4+ years of experience transforming complex data into actionable business insights. Proficient in SQL, Python, Power BI, Tableau, Azure Data Factory, and advanced Excel functions. Expertise spans healthcare, insurance, finance, and energy sectors, enhancing decision-making capabilities through data-driven strategies, sophisticated data modeling, and visualization.

Core Competencies

Data Modeling & ETL

Business Intelligence & Analytics

Statistical Analysis & Predictive Modeling

Data Visualization & Dashboarding

Data Governance & Quality Assurance

Advanced Excel & VBA Automation

Stakeholder Engagement & JAD Sessions

Requirements Gathering & Documentation

Technical Skills

Area

Technologies/Tools

Data Visualization

Power BI, Tableau, Google Looker, Cognos

Programming & Scripting

Python, SQL, PL/SQL, R, VBA, UNIX Shell scripting

Data Integration & ETL

Azure Data Factory, Informatica, SSIS, AWS Glue

Databases

Oracle, SQL Server, DB2, Teradata, MySQL, NoSQL

Cloud Platforms

Azure (Databricks, Synapse, Data Lake), AWS

Data Modeling

Erwin, Star Schema, Snowflake Schema

Operating Systems

Windows, UNIX, Linux

Professional Experience

Senior Data Analyst - Kemper, Chicago, IL (Jan 2024 – Present)

Designed and implemented ETL pipelines using Azure Data Factory, achieving 30% improvement in data processing efficiency.

Developed comprehensive Power BI dashboards presenting KPIs such as Loss Ratio and Expense Ratio, facilitating informed business decisions.

Automated data extraction tasks with Python scripts and Excel VBA macros, reducing manual workloads by 40%.

Enhanced data models using Erwin, applying star and snowflake schemas, improving database query performance by 25%.

Coordinated with cross-functional teams to conduct detailed data profiling and gap analysis, enhancing data accuracy and reliability.

Senior Data Analyst - Press Ganey, Chicago, IL (May 2023 - Dec 2023)

Built data warehouse solutions leveraging Oracle Exadata and Informatica, reducing data retrieval times by 35%.

Designed and maintained interactive Tableau and Cognos dashboards, improving reporting clarity for stakeholders.

Conducted comprehensive gap analyses and data cleansing using Excel and T-SQL, improving overall data integrity by 50%.

Implemented Row-level security in Tableau dashboards, securing sensitive data and ensuring regulatory compliance.

Performed vendor management risk assessments, contributing to a 20% reduction in operational risk exposure.

Data Analyst - Puma Energy, Mumbai, India (June 2022 - Jan 2023)

Developed logical and physical data models using Erwin, enabling effective data architecture and database optimization.

Streamlined data profiling and cleansing processes with Informatica PowerCenter, enhancing data accuracy by 40%.

Created dynamic Power BI dashboards and Tableau visualizations, significantly improving executive decision-making processes.

Managed end-to-end ETL processes, ensuring seamless integration of data across diverse sources, resulting in enhanced operational insights.

Data Analyst - Deutsche Bank, Bengaluru, India (Mar 2021 - May 2022)

Analyzed and restructured data models, utilizing Erwin for forward and reverse engineering, reducing data redundancies.

Developed ETL processes using Informatica, significantly enhancing data migration efficiency.

Built and optimized Tableau dashboards and DOMO reports, delivering insightful visualizations leading to better decision-making.

Conducted rigorous data profiling and validation, ensuring 100% accuracy and completeness in data migration projects.

Education

Master's Degree - University of Bridgeport, Connecticut, USA

Certifications

Microsoft Certified: Data Analyst Associate (Power BI)

Azure Data Engineer Associate

Tableau Desktop Specialist

Google Looker Certified Data Analyst

Soft Skills

Analytical Thinking

Problem-solving

Effective Communication

Cross-functional Collaboration

Detail-oriented & Organized

Leadership and Teamwork

Contact this candidate