Junior Data Analyst - SQL, Python, Power BI

GAURAB PANDEY

Beaumont, TX 423-***-**** ****************@*****.*** linkedin.com/in/gaurabpandeydata github.com/Gaurab294

PROFESSIONAL SUMMARY

Junior Data Analyst with experience in analyzing data to improve business decisions through SQL, Excel, Power BI, and Python. Passionate about operational analytics, workflow optimization, KPI reporting, and process improvement. Strong analytical mindset with the ability to transform data into actionable insights and support data-driven operational strategies.

TECHNICAL SKILLS

Languages and Databases: SQL (T SQL, SQL Server, SSMS, Azure Data Studio), Snowflake, Python (Pandas, NumPy)

Analytics and Visualization: Power BI (DAX, Dashboards), Tableau, Excel (Power Pivot, Pivot Tables, Power Query, XLOOKUP, INDEX/MATCH, Conditional Formatting), Google Sheets

Data Engineering and Methods: ETL Pipelines, Data Warehousing, Data Modeling, Medallion Architecture, Star Schema, KPI Development, Data Cleaning, Business Intelligence, Data Validation, Dashboard Development, KPI Reporting, Operational Reporting, Workflow analysis

Domain Knowledge: Statistical Analysis, Predictive Analytics, Data Governance, Data Visualization, Root Cause Analysis, Process Improvement, A/B Testing, Stakeholder Reporting, SAP ERP (Order to Cash, IBP, HANA), GitHub, Jira, Agile

WORK EXPERIENCE

Data Analyst Lamar University (Graduate Assistant, Part Time) Beaumont, TX Dec 2024 to May 2026

•Built a Python automation pipeline using Pandas to generate personalized acceptance letters as PDF and Word files for graduate program applicants, using Excel as the data source to auto-populate each letter with student specific information, saving approximately 2 to 3 staff hours per week.

•Maintained operational data accuracy across weekly graduate applicant datasets of 50 to 100 records by running automated Python validation checks across 10 plus fields, isolating and resolving data anomalies before processing to eliminate downstream errors and improve reporting reliability.

•Collaborated with administrative stakeholders to improve reporting workflows and ensure consistent, accurate data for operational decision-making

•Conducted competitive analysis on STEM undergraduate business programs across southern US states to support College of Business leadership in assessing potential STEM program expansion.

Business Operations Analyst SN International Kathmandu, Nepal May 2023 to Jul 2024

•Engineered advanced Excel financial models to calculate exact landed costs for imported containers from China, tracking all import cost components from factory gate to Nepal delivery, enabling data driven pricing decisions that protected net profit margins.

•Eliminated manual operational reporting by engineering automated Power BI dashboards connected to the company ERP system, delivering real time executive KPI metrics across sales, purchase, and inventory data to senior leadership.

•Performed inventory turnover and productivity analysis, developing seasonal demand forecasts aligned with Nepali market trends, improving planning accuracy by 15%.

Data & Research Associate Facts Research and Analytics (Internship) Kathmandu, Nepal Feb 2023 to Apr 2023

•Aggregated and structured multi source datasets in Excel for the Facts of Nepal 2023 annual publication, performing exploratory data analysis to extract key statistical trends and partnering with the graphics team to produce data driven infographics.

PROJECTS

End to End SQL Data Warehouse & Business Analytics System May 2026 to Jun 2026

github.com/Gaurab294/SQL-Data-Warehouse-Project

•Built a SQL Server data warehouse following Medallion Architecture, writing modular T-SQL ETL scripts to automate data ingestion and transformation from raw CSV sources into a structured analytical layer.

•Designed a star schema with fact and dimension tables; applied window functions and CTEs to generate business ready KPIs including revenue trends, customer segmentation, and product performance analysis.

Enterprise BI and Operational Performance Dashboard Lamar University Sep 2025 to Nov 2025

•Built an interactive Power BI dashboard for university leadership using DAX measures, slicers, and drill downs to consolidate fragmented operational metrics into a single decision ready view.

•Modeled multi source datasets into relational structures with calculated KPIs, turning complex operational data into stakeholder ready dashboards that enabled faster, evidence based decisions.

EDUCATION

Master of Science, Management Information Systems Lamar University May 2026

Beaumont, Texas GPA: 3.8 / 4.0 Coursework: Business Intelligence and AI, Data Mining and Predictive Analysis, Database Management, SAP ERP Systems, Accounting Data Analytics

Bachelor of Business Administration, Finance Tribhuvan University Jun 2023

Kathmandu, Nepal GPA: 3.64 / 4.0

Contact this candidate