Data Analyst & Business Intelligence Specialist

I find the signal in the noise. Transforming complex data into actionable business intelligence.

Technical expertise

Toolbox for insight generation

A comprehensive overview of my technical expertise and proficiency levels across key data analytics tools and methodologies.

Advanced

Power BI

Interactive dashboards, DAX modeling, storytelling layouts.

Developing

SQL

Query optimisation, stored procedures, audit-ready outputs.

Developing

Python

Pandas, NumPy, data-cleaning automations with AI copilots.

Advanced

Excel

Complex formulas, Power Query, executive reporting packs.

Expert

AI Workflow

Prompt-driven tooling to accelerate analysis 3x.

Strong

Business Insight

Commerce + marketing understanding for grounded insights.

AI Workflow Advantage

Leveraging AI-powered workflows to accelerate data analysis by 3x, enabling faster insights delivery and enhanced decision-making capabilities through intelligent automation and prompt-driven tooling.

Professional Journey

Hands-on history

A chronological overview of my professional journey, highlighting key achievements, responsibilities, and technical expertise gained at each position.

Entry 01May 2019 – Nov 2022

Bachelor of Commerce (Hons)

Amity University, Noida

Developed a strong foundation in business logic, accounting, and finance, which now informs my analytical approach to commerce-driven data insights.

Key Accomplishments

▹Major in Accounting and Finance with a CGPA of 7.55/10.0.
▹Built core competencies in financial modeling and business process understanding.

AccountingFinanceBusiness Logic

Entry 02May 2021 – Jul 2021

Marketing & Sales Trainee

IFortis Corporate

Built foundational business intelligence skills through consumer trend analysis, market segmentation, and the alignment of sales operations with corporate strategy.

Key Accomplishments

▹Leveraged market segmentation analysis to refine targeting approaches for active campaigns.
▹Managed sales operations to ensure seamless execution of strategic promotional plans.

Market AnalysisConsumer BehaviorStakeholder Ops

Entry 03Jul 2023 – Feb 2024

Claims Analyst

Xceedance Consulting India Pvt. Ltd.

Delivered high-velocity data processing and database maintenance for US-based healthcare clients, consistently outperforming production targets through rapid process adaptation.

Key Accomplishments

▹Maintained 99.9% data integrity for the Medical Provider Network (MPN) database with zero compliance errors.
▹Surpassed daily production KPIs by 15% within the first month of operations.

Data IntegritySLA ManagementHealthcare Ops

Entry 04Jul 2024 – Nov 2025

Certified Data Analyst

Ducat, Noida

Undertook an intensive, practical upskilling program focused on modern data architecture, bridging the gap between business logic and technical execution using AI-augmented workflows.

Key Accomplishments

▹Mastered the full data lifecycle: Extraction (SQL), Transformation (Python/Excel), and Visualization (Power BI).
▹Developed AI-assisted coding protocols to accelerate query generation and complex DAX formulation.

SQLPythonPower BIExcelVBAGenerative AI

Entry 05Jan 2026 – Present

AI-Analyst

Innodata Inc., Noida (Remote)

Spearheaded Multi-Modal Prompt Engineering across diverse AI models (text, image, audio, and video). Engineered and refined complex prompts, and conducted comparative evaluations to improve model performance.

Key Accomplishments

▹Achieved an average quality score of 3.29/4.00, surpassing the target benchmark of 2.00 by over 64%, as independently verified by senior QA reviewers.
▹Conducted rigorous comparative evaluations and A/B testing of AI-generated content to resolve factual and structural inconsistencies.

Prompt EngineeringQuality AssuranceAI TrainingProcess Standardization

Selected Works

Data Intelligence & Strategic Dashboards

A curated portfolio of high-impact Power BI solutions. Featuring fully interactive, real-time visualizations engineered with advanced DAX, high-performance query optimization, and strategic storytelling to drive data-led business intelligence.

Featured Project

Adaptive Weather Visuals

Real-Time Environmental Intelligence System

Dynamic weather monitoring dashboard featuring adaptive visualizations that respond to environmental conditions. Tracks temperature forecasts, air quality indices, visibility metrics, and sunrise/sunset data across multiple Indian cities with contextual alerts.

Preparing dashboard...

Adaptive Display

Visualizations

10+ Indian

Cities

15+ Environmental

Metrics

Actionable Insights

Intelligence

Key insights & features

▹Adaptive visualizations that dynamically change color and formatting based on environmental data severity (e.g., AQI levels, visibility warnings)
▹Actionable safety insights: Context-aware alerts convert raw metrics into practical guidance (e.g., 'Visibility reduced—drive slowly, use fog lights')
▹Multi-city comparative analysis across 10+ Indian cities with synchronized environmental metrics for strategic planning
▹Comprehensive environmental intelligence: 15+ metrics including air quality (PM10, PM2.5, O3), visibility, humidity, wind speed, and UV index

Power BIDAXWeather APIReal-Time DataAdvanced Visuals

Macro & Micro Level Analysis

Executive & Operational Intelligence Platform

Comprehensive dual-layer business analytics dashboard providing executive overview (macro) and granular operational insights (micro). Features geographic sales distribution, category profitability analysis, and segment-wise revenue breakdown with drill-through capabilities.

Preparing dashboard...

Dual-Layer Intelligence

Architecture

Profit-Driven Decision Making

Focus

Product Level Performance

Analysis

Multi-Variate Correlation

Logic

Key insights & features

▹Dual-layer intelligence architecture: Executive overview for strategic decisions and granular product-level analysis for operational managers
▹Profit-driven decision making: Prioritizes profitability metrics (Total Profit by Category, Profit Margin %) over revenue to guide bottom-line optimization
▹Product-level performance analysis: Drill-down from categories to individual products to identify winning products and underperformers
▹Multi-variate correlation analysis: Advanced scatter plots and combo charts correlate Profit, Sales, and Quantity to uncover hidden patterns

Power BIDAXData ModelingGeographic VizKPI Design

Distribution & Trend Analysis

Profit Health Monitoring & Operational Control Platform

Multi-dimensional business analysis dashboard examining quarterly performance, category distribution, expense ratios, and state-wise profit patterns. Features time-series profit trends, income categorization, and geographic bubble visualizations for India-specific insights.

Preparing dashboard...

Profit & Loss Monthly

Tracking

Cost Efficiency Ratio

Analytics

Volume vs. Value Category

Dynamics

Quarterly Drill-Down

Analysis

Key insights & features

▹Profit & Loss monthly tracking: Color-coded bar chart (Green/Red) instantly identifies loss months (May, July, Sept) for proactive health monitoring
▹Cost efficiency ratio analytics: Expense ratio of 0.99 indicates tight margins, enabling operational control to prevent expenses from overtaking revenue
▹Volume vs. Value category dynamics: Reveals high-effort vs. high-value product lines (e.g., Clothing: 62% volume but only 37% income share)
▹Trend spotting seasonal patterns: Timeline analysis identifies seasonal dips and peaks to optimize inventory and marketing strategies
▹State-level profitability mapping: Geographic bubble visualization pinpoints high-performing regions for strategic expansion

Power BITime SeriesStatistical AnalysisMap VisualsDAX Measures

⚡Technical implementation highlights

🎯

Advanced DAX

Complex measures, time intelligence, and calculated columns for dynamic insights.

🔄

Data Modeling

Star schema design, relationship optimization, and query performance tuning.

📊

Visual Storytelling

Color psychology, hierarchy design, and interactive drill-through experiences.

Get in touch

Let’s work together

I'm always open to discussing new opportunities, collaborations, or data analytics projects. Reach out via the form or through my direct channels.

Direct Channels

konarkofficial@gmail.com

Phone

+91 8800957178

Resume

Download PDF

Visit Profile