Divyanshu Ambesh
SYS.EXEC.TICKER // 408MSLOC.COORDS: 27.1767 N // 78.0081 ESTATUS: DETERMINISTIC_OPERATIONS_ACTIVETHEME: OBSIDIAN.Crimson.v4RADAR_RANGE: 1.5KMAZIMUTH_GRID_01
Divyanshu Ambesh — Systems Portfolio

I THINK IN
SYSTEMS.

I BUILD FOR
HUMANS.

"I value systems over chaos, clarity over assumptions, and execution over noise."

Scroll to exploreDiscover my work ↓
+
+
+
+
Operational Overview
408ms
Current Status
Seeking Roles: Business Analyst / Competitive Intel / Strategy & Operations / Consultant
Current: Competitive Intel Intern
Location: Gurgaon
Education: B.Arch @ MANIT Bhopal
Active Ambitious Available
01Strategy & Optimization
Pricing models & business unit economics
+18% Margin LeverageOPTIMIZED
02Operations Audit
Workflow standardisation & process mapping
-15% TAT ReductionRESOLVED
03Business Analysis
SQL queries, Power BI DAX, Excel models
10k+ Records AuditedACTIVE
04Spatial Architecture
Thinking structurally in multi-variable grids
B.Arch MANIT BhopalVERIFIED
Agra, India — 27.1767°N, 78.0081°EOnline
Architecture · Strategy · Operations · Visual SystemsMultidisciplinary thinker working across systems, operations, spatial design, and visual direction.
DB.SQL_SOURCE // TABLETRANSFORM // ETL.ENGINELOAD // PowerBI.DAXPRIMARY_KEY :: INTSLA_STAMP :: TIMESTAMPCLEANSE_NULLS()GROUP_BY_COHORT()RETENTION_RATE :: %COHORT_DECAY :: FLOATSYSTEMATIC GAP AUDITING MATRIXEFFICIENCY COEFFICIENT: +15% TARGET95.0%
01About

About

Analyzing complex data.
Designing efficient processes.

Divyanshu Ambesh

I am a data-driven Business Analyst specializing in SQL, Power BI, and advanced Excel. I bridge the gap between complex datasets, business operational workflows, and strategic stakeholder goals.

Business System Specs
• Data & Analytics: SQL (CTEs, Joins), Power BI (DAX, Modeling), Excel (XLOOKUP, Pivots)
• Core Analysis: Requirements Gathering, BRD/FRD, KPI Tracking, Gap Analysis
• Proven Impact: Audited 10,000+ SLA records & optimized operational workflows by 15%

Currently completing my Bachelor of Architecture (B.Arch.) at Maulana Azad National Institute of Technology (MANIT), Bhopal (Expected July 2026). I apply spatial structure, systematic logic, and rigorous design-thinking to data structures and process modeling, translating raw business noise into clear, actionable, data-driven decisions.

SQL joins the data. Power BI visualises the story. Excel structures the logic. — Removing operational friction.

Why Me?

“I combine analytical thinking, structured communication, visual problem-solving, and operational understanding to simplify complex systems.”

From Spatial Systems to Business Systems

“Architecture trained me to think structurally, communicate visually, and solve complex multi-variable problems. I now apply the same systems-thinking approach to business workflows, analytics, and operational optimization.”

Selected Achievements
+
+
+
+
NCC 'C' Certificate (CPL)

Leadership, coordination, and execution training within rigorous operational standards.

+
+
+
+
All India Trekking Camp

Endurance, discipline, high-altitude navigation & pressure handling.

+
+
+
+
Event Manager Logistics

Managed logistical coordination and scheduling for 100+ active event participants.

+
+
+
+
NASA G-SEN Trophy

Applied strategic design thinking methodologies and quantitative structural analysis.

+
Systems DisciplinesStrategy · Operations · Visuals · Architecture
k+
Records AuditedSQL SLA and pricing analysis at DOEITY
%+
Process OptimizationWorkflow and efficiency improvements
PHASE_01 // DISCOVERY AUDITAudit SLA logs & operational noisePHASE_02 // SYSTEMIC MODELINGMap linear flows & clear bottlenecksPHASE_03 // EXECUTION CONTROLDeploy KPI dashboards & DAX triggersOPERATIONAL STANDARDIZATION MAPELIMINATING COURIER WAIT QUEUES // SLA_COMPLIANCE: 99.2%
02Problem Solving Framework

How I Solve
Problems.

A structured, engineering-grade methodology deconstructing complex organizational bottlenecks. I map active system pipelines, perform rigorous data audits, and output deterministic process improvements.

+
+
+
+
Input01

Understand System

Map operational baselines, trace active workflows, and gather core business and technical requirements (BRD/FRD).

+
+
+
+
Diagnose02

Identify Bottlenecks

Isolate operational friction points, pipeline delay zones, and data leakage channels using systematic gap analysis.

+
+
+
+
Process03

Analyze Patterns

Perform advanced exploratory data analysis (EDA) and data validation using complex SQL joins, CTEs, and Python.

+
+
+
+
Measure04

Quantify Impact

Calculate precise operational margins, SLA failure rates, pricing trends, and logistical inefficiencies.

+
+
+
+
Output05

Recommend Optimization

Model dynamic, scalable solutions and strategic process enhancements using interactive, DAX-driven Power BI dashboards.

PHASE_01 // DISCOVERY AUDITAudit SLA logs & operational noisePHASE_02 // SYSTEMIC MODELINGMap linear flows & clear bottlenecksPHASE_03 // EXECUTION CONTROLDeploy KPI dashboards & DAX triggersOPERATIONAL STANDARDIZATION MAPELIMINATING COURIER WAIT QUEUES // SLA_COMPLIANCE: 99.2%
03Case Studies

Business Case Studies.

A collection of data-driven operational audits and strategy models. Problem → Analysis → Insights → Recommendations.

Case Study 01
SQLPower BIOperations
RoleCompetitive Intel Intern // DOEITY

Zepto — Operational Analysis

Audited SLA delivery turnaround times and order routing inefficiencies over a high-volume quick-commerce dataset.

Case Study 02
Gap AnalysisFigmaWorkflow Logic
ScopeWorkflow Blueprinting

Restaurant Operations Analytics

Analyzed operational blockages, kitchen workflows, and staff allocations inside a high-throughput establishment.

Case Study 03
StrategyFinancial ModelingCAC Mapping
StrategyMargin Optimization Model

Rusooyi — Strategy & Margins

Constructed comprehensive financial models to track customer acquisition cost (CAC) and pricing tiers.

03.1Metrics & Dashboards

Dashboard Previews & Retention Matrices

Dynamic KPI trackers, cohort models, and operational SLAs mapped programmatically.

Executive KPI BoardSource: SLA Intern logs · Star Schema
Live
SLA Compliance94.2%Target: >95.0%
Order CAC₹48.40LTV Ratio: 3.8x
Logistics TAT14.2 minReduced by 15%
Margin Index+18.2%Pricing Stable
SLA Peak Compliance Timeline (12-hour queue)
1h
2h
3h
4h
5h
6h
7h
8h
9h
10h
11h
12h
Cohort Retention HeatmapActive User Decay Curves
Retention
CohortWeek 1Week 2Week 3Week 4
W1100%92%84%81%
W2100%89%78%72%
W3100%82%68%58%
W4100%78%61%49%
Cohort tracking identifies optimal reward trigger points immediately before the week-3 drop-offs.
ISOMETRIC_SCHEMATIC: Modular.Container.CabinTOLERANCE_CALIBRATION: <0.5MMCANTILEVERED_NODE_DELTASTEEL_REINFORCED_BEAMSINFRASTRUCTURE BLUEPRINT CAD SCALE 1:50CALIBRATION ENGINE // LUMION + V-RAY HIGH FIDELITYL: 12.00M
04Architecture & Visual Systems

Systems
Schematics.

+
+
+
+
Hillside Modular Container Cabin
Exterior Rendering
Exterior Concept

Hillside Modular Container Cabin

+
+
+
+
Aashiyana Residential Entrance Portal
Detail Design
Detail Design

Aashiyana Residential Entrance Portal

+
+
+
+
Poolside Ambient Living Pavilion
Interior Design
Interior Lighting

Poolside Ambient Living Pavilion

+
+
+
+
Biophilic Library Tree Bookshelf
Furniture Design
Furniture Design

Biophilic Library Tree Bookshelf

+
+
+
+
Crafted Modular Kitchen Assembly
Interior Design
Interior Design

Crafted Modular Kitchen Assembly

+
+
+
+
Hillside Modular Container Cabin
Exterior ConceptHillside Modular Container Cabin

A double-story hillside concept engineered from structural shipping containers. Employs horizontal wood panels, cantilever structures, concrete foundations, and steel framing.

AutoCADSketchUpLumionV-Ray
SHOULDER_PANEL_DRAFT // SEC.05COLLAR_ARC: R240MMSEAM_TOLERANCE_4MMARMHOLE_DEPTH_VERIFIEDTACTILE TAILORING CALCULATOR SCHEMAJUKI LOCKSTITCH RIG AUDIT // STITCHES_PER_INCH: 12
05Apparel Design & Manufacturing

Tactile
Systems.

An entrepreneurial merger of physical design and process optimization. I treat apparel engineering like architectural drafting—patterning vector schematics, calibrating seam tolerances, and auditing industrial assembly lines.

+
+
+
+
Garment Architecture
01 — Pattern Drafting

Garment Architecture

Drafting structural garment patterns on heavy concrete grids using tape calipers and tailoring calculators. Every panel is engineered like an architectural schematic, optimizing seam tolerances and structural drape.

+
+
+
+
Industrial Manufacturing
02 — Precision Fabrication

Industrial Manufacturing

Executing heavy-knit seam stitches on industrial Juki lockstitch sewing rigs. Auditing stitch ratios, seam margins, and tension configurations to produce high-durability double-weave panel interfaces.

+
+
+
+
Distribution & Showcase
03 — Logistical Showroom

Distribution & Showcase

Designing clean, minimalist display spaces using custom industrial steel pipe racking. Balancing showroom aesthetics with warehouse batch releases, scheduling, and active catalog inventory flows.

+
+
+
+
Graphic Color Separation Systems
Print Production

Graphic Color Separation Systems

Deconstructing illustrative print layouts for multi-color screen operations. Calibrating vector line widths, print margins, dot gain, and film density to ensure high-contrast ink transfers on heavy textiles.

+
+
+
+
Fabric Performance & Wear-Testing
Print Production

Fabric Performance & Wear-Testing

Conducting real-world wear audits, material shrink testing, and graphics wash-endurance validation to refine cure temperatures, polymer selections, and weave densities before factory manufacturing runs.

TYPOGRAPHIC_ALIGNMENT_GRID // GROTESQUE.COREBASELINE_HEIGHT: 12PX // CAP_LIMIT: 44PXGOLDEN_RATIO_EXPONENTIAL_SPIRAL (1.618)VISUAL COMMUNICATIONS ASSEMBLY SYSTEM v1.2FONT_PAIRINGS: PLUS_JAKARTA_SANS + JETBRAINS_MONO
06Graphic Designing

Graphic
Designing.

Formulating brand collateral, editorial assets, and luxury packaging layout grids. I deconstruct visual hierarchies, typography combinations, and geometric shapes into high-fidelity tactile systems.

+
+
+
+
Glim Forever Brand & Care Collaterals
Glim Forever Brand & Care Collaterals
Typography & Collateral

Glim Forever Brand & Care Collaterals

A comprehensive brand-collateral system developed for a luxury candle brand. Formulates clean font pairings, high-end typographic hierarchy, and custom instruction icons that guide consumers to optimize candle burning integrity.

+
+
+
+
Wiyanjanam Hospitality Branding
Luxury Packaging

Wiyanjanam Hospitality Branding

Fine-line geometric brand crest and custom pattern sheets created for an elite culinary brand. Blends abstract cutlery elements (fork, spoon) into a symmetric gold-monogram logo, detailed against deep carbon backdrops.

+
+
+
+
Barchique Handmade Chocolates
Logotype Design

Barchique Handmade Chocolates

A bold, high-contrast typographic identity designed for an artisanal chocolatier. Implements custom-aligned grotesque letters inside high-contrast architectural framing guides, conveying timeless, clean structures.

+
+
+
+
The 5 Lotus Identity System
Corporate Identity

The 5 Lotus Identity System

A vector-calibrated corporate brand mark. Formulates an abstract symmetric lotus flower using clean bezier paths and high-saturation primary colors, creating a timeless geometric balancing act.

DB.SQL_SOURCE // TABLETRANSFORM // ETL.ENGINELOAD // PowerBI.DAXPRIMARY_KEY :: INTSLA_STAMP :: TIMESTAMPCLEANSE_NULLS()GROUP_BY_COHORT()RETENTION_RATE :: %COHORT_DECAY :: FLOATSYSTEMATIC GAP AUDITING MATRIXEFFICIENCY COEFFICIENT: +15% TARGET95.0%
07Skills & Capabilities

Core Capabilities.
Systems Expertise.

Core Business Impacts

Not just static skills — measurable operational outcomes engineered through quantitative data auditing.

+
+
+
+
12–%
Reduced Operational Inefficiencies

Standardised internal workflows and audited courier turnaround parameters at DOEITY and Glim Forever.

+
+
+
+
+
SLA Records Audited

Built optimized SQL queries to analyze SLA execution logs and pricing patterns during quick-commerce interns.

+
+
+
+
+%
Pricing Optimizations Identified

Uncovered structural margin leaks and pricing pattern improvements for The 5 Lotus using DAX cohort indicators.

+
+
+
+
Dynamic
Executive KPI Dashboards Built

Constructed high-fidelity Power BI and Excel report schemas that transform raw noise into executive decisions.

Operational Pillars
1

Data & Visualization

SQL (Joins, CTEs, Aggregates) · Power BI (DAX, Data Modeling, Star Schemas) · Advanced Excel (Pivot tables, XLOOKUP, Data Modeling)

→
2

Business Analysis

Requirements Gathering · BRD/FRD Documentation · KPI Auditing · Stakeholder Management · Systematic Gap Analysis

→
3

Data Processing

Exploratory Data Analysis (EDA) · Data Cleaning & Validation · ETL Pipelines · Cohort & Margin Calculations

→
4

Architecture & Spatial

Spatial Systemic Thinking · 3D Design Visualization · SketchUp Models · AutoCAD Blueprints · Adobe Photoshop

→
Tools & Technologies

Multidisciplinary toolkits bridging quantitative calculations and blueprint structural engineering.

SQLAdvanced

CTEs, Joins, Query Optimisation

Power BIAdvanced

DAX, Data Modeling, Star Schemas

ExcelExpert

Pivots, XLOOKUP, Financial Modeling

PythonIntermediate

Pandas, NumPy, Exploratory Analysis

FigmaIntermediate

UI Architecture, Wireframes

AutoCADAdvanced

Structural Blueprints & Logic

SketchUpAdvanced

3D Spatial Grid Systems

100%50%0%WEEK 0WEEK 3 (TRIGGER_POINT)WEEK 12CRITICAL COHORT DECAY LIMIT: -22%MITIGATION STATUS: LOCAL DISCOUNTS DEPLOYEDLTV_CURVE // FLAT_LINE_STABILIZED
08Business Insights & Briefs

Operational
Thoughts.

LinkedIn-style thought pieces and structural analyses deconstructing quick-commerce grids, cohort metrics, pricing economics, and dashboard logic.

01 — Logistics2 min read

Why Zepto Scales Faster

Deconstructing the micro-fulfillment logistics behind quick-commerce store networks.

02 — Cohort Dynamics2 min read

Retention Over Acquisition

The mathematical cost of losing active user cohorts vs bleeding acquisition budgets.

03 — Process Efficiency2 min read

Friction Bleeds Margins

How tiny localized operational inefficiencies act as silent margin-killers at scale.

04 — BI Systems2 min read

Why Dashboards Fail Executives

Moving beyond static historical charts to real-time, proactive business decision engines.

PLATE_VIEWFINDER // RAW_14BIT_SIGNALLENS: 50MM F/1.8 FIXED TELEMETRYISO_LIMIT: ISO_3200_CALIBAF_LOCKED // FOCUS_FACTOR: 1.0PHOTOGRAPHY LIGHT PHYSICS ALIGNMENT SCHEMAEXIF_SPEED: 1/125S // COLOR_SPACE: sRGB_D65_CALIBRATED
09Technical Lens Portfolio

How I See.

Photography is structural systems thinking applied to light physics, geometrical balance, and atmospheric composure.

Silence in Motion // Night Velocity
PLATE // 01
Agra, IN — Night Street Frame

Silence in Motion // Night Velocity

ISO 800 · 28mm · f/2.0 · 1/60s
Cooperative Transit // Active Flows
PLATE // 02
New Delhi Metro — Candid Frame

Cooperative Transit // Active Flows

ISO 320 · 35mm · f/1.8 · 1/125s
Structural Depth // Platform Geometry
PLATE // 03
New Delhi Metro — Platform Geometry

Structural Depth // Platform Geometry

ISO 200 · 24mm · f/2.8 · 1/80s
Oceanic Solitude // Sunset Silhouette
PLATE // 04
Kanyakumari Coast — Coastal Shadow

Oceanic Solitude // Sunset Silhouette

ISO 100 · 50mm · f/4.0 · 1/500s
Shoreline Reflections // Night Mood
PLATE // 05
Marina Beach — Midnight Tide

Shoreline Reflections // Night Mood

ISO 1600 · 35mm · f/1.8 · 1/15s
Structural Horizons // Hillside Contour
PLATE // 06
Chandigarh Hills — Modern Landscape

Structural Horizons // Hillside Contour

ISO 100 · 24mm · f/5.6 · 1/160s
Chroma & Contrast // Ambient Shadow
PLATE // 07
Stone Lounge — Intimate Frame

Chroma & Contrast // Ambient Shadow

ISO 1000 · 50mm · f/1.8 · 1/80s
Biophilic Overlay // Solar Flare
PLATE // 08
Agra, IN — Golden Hour Horizon

Biophilic Overlay // Solar Flare

ISO 100 · 85mm · f/1.4 · 1/1250s
Linear Velocity // Sunset Escape
PLATE // 09
Northern Railways — Motion Blur

Linear Velocity // Sunset Escape

ISO 200 · 28mm · f/2.8 · 1/320s
NODE_ALPHA: Gurgaon_Relay_StationSTATUS: LINK_ESTABLISHEDNODE_BETA: Agra_Central_CoordinatesAZIMUTH_GRID_LINKEDHUB // DIRECT_MAIL_RELAYSMTP: divyanshuambesh11@gmail.comGLOBAL COMMUNICATIONS OVERLAYSECURE SHELL PROTOCOL // CONNECTION: OPEN
10Connect

Let's Talk.

Building something worth building? No pitch decks required.

Emaildivyanshuambesh11@gmail.com
LocationAgra, India
Open for Opportunities
Roles: Business Analyst / Competitive Intel / Strategy & Operations / Consultant
Availability: Internships & Full-Time Roles
Locations: Gurgaon
Contact Form
x:0 y:0
Divyanshu Ambesh© 2026 · All Rights Reserved
LinkedInGitHubEmail
Structured thinking over noise.