● Open to Work

akratiGupta

Data Analytics Fresher | Python | SQL | Power BI
Delhi

About Me

Data Analytics Fresher with a background in Quality Assurance and healthcare operations, transitioning into the Data Analytics domain. Skilled in Python, SQL, Power BI, Excel, and data visualization with hands-on project experience in fraud detection, customer behavior analysis, statistical analysis, and dashboard development. Strong analytical thinking, attention to detail, and problem-solving abilities.

Skills & Technologies

PythonPandasNumPyMatplotlibSeabornSQLMongoDBMySQLPostgreSQLPower BIDAXPower QueryMicrosoft ExcelPivot TablesVLOOKUPAzure Data FactoryAzure DatabricksAzure SynapseExploratory Data AnalysisETL PipelinesData ModellingStatistical AnalysisHypothesis TestingData CleaningData TransformationBusiness IntelligenceCustomer SegmentationCohort AnalysisMachine Learning BasicsScikit-learnFraud DetectionRisk AnalysisCompliance ReportingData Governance

Work Experience

Quality Analyst

Ahuja Medicare
01/202001/2022

Monitored healthcare processes ensuring compliance with ISO, NABH, and internal quality standards. Conducted audits on patient records, lab reports, and clinical procedures with strong attention to detail. Prepared quality reports to improve transparency and collaborated with cross-functional teams maintaining compliance standards. Assisted staff training and supported internal and external audits.

Projects

Fraud Detection & Risk Analysis (SQL & MongoDB)

Developed fraud detection workflows using SQL and MongoDB to identify anomalies in financial datasets, creating analytical queries and aggregation pipelines to detect suspicious transactions and risk patterns. Applied indexing and data modeling to improve performance and reporting efficiency.

SQLMongoDB

Loan Portfolio & Customer Behavior Analysis – Hero FinCorp

Built Power BI dashboards and SQL-based workflows to evaluate customer repayment behavior and loan performance by cleaning and integrating multi-source datasets. Used statistical techniques and DAX measures to identify default trends and customer segments.

Power BISQLDAX

Retail Company Data Analysis (Python Project)

Automated sales reporting, inventory tracking, and customer segmentation using Python. Performed data cleaning, forecasting, and sentiment analysis generating business insights and utilities for reporting automation.

Python

Statistical Analysis for Decision Making

Conducted hypothesis testing and probability analysis using Python and real-world datasets to analyze seasonal property price trends and customer behavior, generating actionable insights with data-driven visualization.

Python

Airbnb Data Analysis (Power BI Project)

Created interactive Power BI dashboards analyzing Airbnb pricing, reviews, and guest satisfaction trends, producing visual reports identifying city-wise trends, location insights, and host performance metrics.

Power BI

Azure & Data Analytics | Smartgear Sales

Built Azure-based ETL and analytics workflows for retail sales reporting, working with Azure Data Factory, Databricks, and Synapse SQL for data ingestion, transformation, and generating validated insights for reporting.

Azure Data FactoryAzure DatabricksAzure SynapseSQL

Education

Bachelor of Science

Science

Chhatrapati Shahu Ji Maharaj University, Kanpur2022 - 2025

Diploma in Pharmacy

Pharmacy

Sharda University, Noida2018 - 2020
akratiGupta - Data Analytics Fresher | Python | | HiringAnt