Data Analyst Power Bi

ANSHI AJAY RAI

+1-682-***-**** Houston, TX USA ************@*****.***

SUMMARY

Results-driven Data Analyst with 3+ years of experience in data analysis, ETL, SaaS, and business intelligence. Strong expertise in SQL, Python, R, Power BI, and Tableau for data visualization and reporting. Skilled in developing ETL pipelines, automating workflows, and performing data cleansing to enhance decision-making processes. Adept at collaborating with cross-functional teams to improve data integrity, governance, and operational efficiency. Graviti Energy Houston, TX

Information System Analyst NOV 2024 - PRESENT

• Analyze and report data using SQL and Power BI, delivering actionable insights for leadership.

• Designed and developed ETL pipelines to streamline data extraction, transformation, and loading for improved data processing.

• Analyzed and reported data using SQL, Power BI, and Excel, delivering actionable insights for leadership.

• Developed automated workflows to improve data integration and reduce manual efforts.

• Conducted data validation, cleansing, and transformation to ensure accuracy and consistency.

• Maintained SaaS-based analytics solutions, optimizing reporting processes and data storage.

• Design, develop, and maintain websites using WordPress, ensuring responsive design and seamless user experience. SSA Data Solution Plano, TX

Data Analyst Intern Jan 2023 - Oct 2024

• Developed interactive Power BI and Tableau dashboards to track business metrics and key performance indicators.

• Built Python and SQL scripts for automating data extraction, processing, and visualization.

• Conducted ETL operations, improving data integration across multiple sources.

• Implemented SaaS-based data solutions, ensuring secure access and streamlined data sharing.

• Collaborated with stakeholders to define data-driven strategies and enhance reporting accuracy. Aceline Tech Solution HYD, IN

Data Analyst JAN 2020 - JUN 2022

Managed ETL processes using Python and SQL to extract insights from large datasets.

Designed and optimized SQL queries and stored procedures for efficient data retrieval.

Built and maintained Tableau dashboards to visualize complex business trends.

Integrated SaaS analytics tools to enhance business intelligence reporting.

Conducted data integrity audits to maintain high standards of data quality and governance. EDUCATION EXPERIENCE

University of Texas at Arlington Arlington, TX

Master’s in information systems AUG 2022 - MAY 2024 Coursework: AWS Data Warehousing Web & Social Analytics Data Mining Analysis and Design Python Statistical Analysis Project Management.

University of Mumbai Mumbai, IN

Bachelor’s in Information Technology AUG 2015 - Dec 2019 SKILLS

Programming & Scripting: Python, R, SQL, PowerShell

Data Analytics & Visualization: Power BI, Tableau, Excel

ETL & Data Engineering: Data Extraction, Transformation, Loading, SQL Server Integration Services (SSIS)

SaaS & Cloud Solutions: AWS, Google Cloud, Azure

Database Management: MySQL, PostgreSQL, SQL Server

Process Automation: Workflow automation, data cleansing techniques

Soft Skills: Communication, Cross-functional Collaboration, Data Validation, Risk Analysis

Operating Systems: Windows, macOS, Linux

CERTIFICATIONS

• Databases and SQL for Data Science with Python

• AWS Cloud Technical Essentials

• Introduction to Information Technology and AWS Cloud

Contact this candidate