d
dogra23

Shivam D

@dogra23

Data Analyst

Inde
Anglais, Hindi
Certaines informations sont présentées en anglais.
À propos de moi
I am a Data Analyst with strong SQL, Python, Power BI and Advanced Excel expertise. I am experienced in analyzing large-scale transaction datasets to identify profitability drivers, pricing inefficiencies, and operational risk patterns. I am also experienced in providing automated data pipelines and creating Fully Dynamic VBA code for creating reports and dashboards in JUST ONE CLICK. I am skilled in building end-to-end dashboards and developing advanced DAX metrics. ... Plus d’infos

Compétences

d
dogra23
Shivam D
hors ligne • 

Portfolio

Expérience professionnelle

Independent Data Analyst

NA

Dec 2023 - Present • 2 yrs 7 mos

•Designed multi-page retail profitability dashboards using SQL and Power BI to analyze 51K+ transactions across regions and product categories • Identified 2× profit variance across markets driven by pricing discipline and shipping cost allocation. Developed DAX metrics (Contribution %, Margin %, Discount Impact) to evaluate category-level performance • Built SQL-based fraud risk logic on 1M+ simulated banking transactions to detect anomalous behavior patterns. Carried out balance audits and data validation checks to ensure accuracy and consistency. • Designed end-to-end ELT workflow using Python and MySQL to clean, transform, and model user behavior datasets

Stellar

Data Annotator & Reviewer (LLM Training Project)

Stellar • Freelance

Feb 2026 - Mar 2026 • 1 mo

-Evaluated and labeled audio data to support Large Language Model (LLM) training and optimization -Assessed responses based on key parameters such as naturalness, persona alignment, tone, audio quality, and overall utility -Compared multiple model outputs against reference audio to identify the most accurate and high-quality response -Contributed to refining AI response quality through structured feedback and detailed evaluation