BIMALA PANT - Data Analyst Intern

BIMALA PANT

DATA ANALYST

Denton, TX 940-***-**** *************@*****.*** Linkedin

PROFESSIONAL SUMMARY

Data Analyst intern candidate with hands-on experience in SQL, Python, and data visualization tools including Tableau and Power BI. Proven track record of translating complex business questions into data-driven insights, supporting decision-making in finance and e-commerce environments. Experienced in data profiling, quality validation, stakeholder collaboration, and building dashboards that track KPIs.

TECHNICAL SKILLS

Data Querying & Databases: SQL (MySQL, relational & non-relational), NoSQL, data extraction, profiling, wrangling, PostgreSQL, Indexing, ETL/ELT

Microsoft Office: MS Access, MS Excel (Pivot Tables, VLOOKUP, Index-Match), MS Word, MS Power Point

Cloud & Big Data: Azure, AWS, Google Cloud Platform, Big Data

Data Visualization: Power BI, Tableau, Excel dashboards, Looker, Stata

Programming & Analysis: Python (Pandas, NumPy), R, EDA, statistical analysis, data modeling, KPI tracking Methodologies & Tools: Agile methodology, Git, Jupyter Notebook, metadata documentation, data quality management

Reporting & Analytics: Financial Planning & Analysis (FP&A), Data Analysis & Reporting, Business Intelligence Reporting, Dashboards & Visualization, Data Tracking & Reporting, Anaplan Model Building, Financial Modeling, Spreadsheet Software (Excel)

PROFESSIONAL EXPERIENCE

Finance Analyst Sanima Reliance Life Insurance Ltd. Aug 2022 – Oct 2024

•Analyzed large financial datasets using SQL and Python (Pandas, NumPy) to identify discrepancies and critical data elements, improving reporting accuracy and data quality management

•Collaborated with cross-functional stakeholders to define data requirements and translate business questions into actionable insights through Power BI dashboards and Excel reports, tracking KPIs aligned with business objectives

•Profiled and validated data using data wrangling and metadata documentation techniques to monitor quality; supported remediation efforts by partnering with business and data teams, mirroring data stewardship responsibilities

•Interpreted data models and converted user requirements into technical specifications for financial reporting systems, leveraging statistical analysis and Jupyter Notebook for exploratory data analysis

•Delivered data-driven presentations using MS PowerPoint and Tableau to business audiences, communicating complex findings in clear, accessible language

Data Analyst Intern Rastriya Banijya Bank Kathmandu, Nepal Feb 2022 – Apr 2022

•Performed data profiling, cleaning, and validation on banking datasets using SQL and PostgreSQL, ensuring integrity and data quality management across relational databases

•Conducted exploratory data analysis (EDA) with Python (Pandas, NumPy) to identify trends and anomalies, supporting risk analysis and business strategy

•Developed advanced SQL queries to extract, wrangle, and analyze financial data from relational databases, delivering structured reports for stakeholder decision-making

•Built interactive Excel dashboards with Pivot Tables and VLOOKUP to track key metrics, enabling informed decision-making for non-technical audiences

Business Data Analyst Intern Daraz Kathmandu, Nepal Sep 2021 – Dec 2021

•Cleaned and transformed large e-commerce datasets using SQL and Python (Pandas, NumPy), preparing data for downstream analysis and ensuring data quality management

•Built Tableau dashboards and Excel dashboards to track sales KPIs and customer behavior metrics, translating business requirements into actionable visual data products

•Conducted EDA using R and Python to uncover trends supporting marketing and operations strategies, enabling data-driven decisions aligned with Agile methodology workflows

•Automated data pipelines using Python and Git for version control, reducing manual data processing and improving team efficiency and delivery timelines

PROJECTS

E-Commerce Sales Dashboard

•Designed and built an end-to-end Tableau dashboard analyzing customer behavior and sales trends across product categories

•Used SQL for data extraction and Python (Pandas) for cleaning and transformation, then visualized KPIs for business stakeholders

•Identified key revenue drivers and anomalies, delivering actionable insights that informed inventory and marketing strategy

EDUCATION

Master of Science in Business Analytics (Expected) 2027

University of North Texas

Bachelor of Business Administration 2022

Padma Kanya Multiple Campus

CERTIFICATIONS

•Microsoft Power BI Desktop for Business Intelligence

•Joining Data in SQL — DataCamp

•Fundamentals of Business Analysis

•NoSQL Concepts

Contact this candidate