Data Analyst Power Bi

Gandam Shubham

Email: *****************@*****.*** Phone: +1-334-***-****

Professional Summary

Results-driven Senior Data Analyst with 4+ years of experience in data analysis, visualization, and reporting. Adept at gathering business requirements, designing insightful reports, and transforming complex datasets into user-friendly dashboards. Expertise in Power BI, SQL, data manipulation, and data warehousing concepts. Strong background in collaborating with cross-functional teams to deliver accurate and automated reporting solutions.

Skills & Competencies

• Data Visualization & Reporting: Power BI, Tableau, SSRS, Business Objects

• Data Analysis & Transformation: SQL (Oracle, Teradata, Snowflake, PostgreSQL), Python

• Data Warehousing & ETL: Informatica, Azure Data Factory, AWS Redshift, Snowflake

• Database Management: Writing queries, optimizing performance, managing datasets

• Cloud Platforms: Azure, AWS (S3, RDS, EC2, Glue, VPC)

• Business Intelligence & Automation: Dashboard creation, KPI tracking, workflow optimization

• Domain Expertise: Energy, Utilities, Finance, Healthcare

Professional Experience

Senior Data Analyst

Capital One, Montgomery, AL Sep 2023 – Present

• Collaborate with cross-functional teams to gather data requirements, enhance system functionalities, and support reporting needs.

• Develop and optimize Power BI dashboards for real-time business insights and operational performance tracking.

• Write complex SQL queries for data extraction, transformation, and validation.

• Conduct thorough data validation and testing to ensure accuracy, consistency, and reliability in reports.

• Identify automation opportunities to streamline reporting processes, increasing efficiency.

• Extract and transform data from AWS S3 to Snowflake for cloud-based data warehousing solutions.

Data Analyst

Option Care Health, Montgomery, AL Sep 2022 – Sep 2023

• Designed and developed Power BI dashboards with interactive visualizations to support business decision-making.

• Utilized SQL and Python for data extraction, transformation, and analysis.

• Conducted data validation and ETL testing to ensure consistency between source and target databases.

• Developed automated data pipelines for streamlined reporting and reduced manual efforts.

• Used AWS Glue to crawl the data lake in S3 and populate the Data Catalog.

Data Analyst

Pexway, Hyderabad, India Nov 2020 – Mar 2022

• Created data models and implemented ETL transformations for data quality and validation.

• Developed and maintained PL/SQL scripts for optimized database performance.

• Designed SSRS reports and worked with Cognos for BI reporting.

• Migrated repository objects and scripts from development to production environments.

Education

Master of Science in Management Information Systems - Auburn University at Montgomery, AL, USA (2022 – 2023)

Bachelor of Technology in Computer Science - JNTU, Hyderabad, India (2016 – 2020)

Certifications & Additional Training

• Microsoft Certified: Power BI Data Analyst Associate

• SQL for Data Science – Coursera

• AWS Certified Data Analytics – Specialty (In Progress)

Projects & Achievements

• Built custom Power BI dashboards for performance tracking, reducing manual report generation time by 50%.

• Led a data migration project from Teradata to PostgreSQL on AWS, improving query performance by 30%.

• Developed automated ETL processes using Informatica and Azure Data Factory, ensuring data consistency and reliability.

Technical Tools & Environment

• BI & Reporting: Power BI, Tableau, SSRS, Business Objects

• Databases: Oracle, SQL Server, Teradata, Snowflake, PostgreSQL

• Programming & ETL: SQL, PL/SQL, Python, Informatica, Azure Data Factory

• Cloud Technologies: AWS (S3, Glue, Redshift, RDS), Azure (Data Factory, Databricks)

Contact this candidate