LAKSHMAN BAZARLA
AI-Assisted Automation Architect | Data Engineering | Analytics Systems
Hyderabad, India | +91 86862 06428 | bazaralalakshman@yahoo.com | linkedin.com/in/bazarla-lakshman-714a1659 | Open to Remote / Hybrid
Professional Summary
Automation & Systems Architect with 7+ years designing enterprise-scale data pipelines, modular automation platforms, and analytics systems across logistics, procurement, and fintech domains. Specialised in rule-based data normalization and entity resolution at 50K+ record scale, end-to-end automation workflows (email extraction → validation → reporting), and config-driven governance with audit logging.
Recent focus: financial intelligence platform design (FinWise) using Flutter + Riverpod, carrier rate intelligence systems (FedEx / DHL), and advanced logistics analytics. Consistently reduced manual effort by 60–95% while improving data quality. Currently seeking mid-level to senior roles in automation engineering, analytics engineering, or AI-assisted product architecture with product companies or fintech-focused organisations.
Core Technical Skills
Professional Experience
Automation & Data Pipeline Engineer, Carrier Technologies India Pvt. Ltd.
Hyderabad, India
Parcel Intelligence Analytics Platform — Python, Pandas, SQL
- Architected end-to-end Python pipeline integrating multi-source logistics data (shipments, invoices, services, carriers) into a unified cost-intelligence system.
- Built shipment–invoice relationship bridge with automated anomaly detection identifying cost variances for procurement teams.
- Implemented vendor concentration analytics providing cost optimization opportunities — 40%+ reduction in inquiry volume.
- Designed narrative-generation engine translating analytics into dynamic business insights for 50+ executive stakeholders.
- Developed risk-flagging system and Excel-safe export framework for board-level distribution.
Carrier Rate Intelligence Engine — Python, PDF Extraction, Pricing Analytics
- Engineered FedEx & DHL rate-card extraction system converting unstructured PDF pricing data into structured analytical datasets.
- Built automated zone-mapping and service-level pricing pipelines enabling programmatic carrier cost analysis.
- Impact: Enabled competitive rate analysis across 500K+ rate combinations; facilitated $2M+ in negotiated carrier savings.
Geo-Intelligent Logistics Distance Analytics — Python, Geopy, Geo-APIs
- Designed geographic enrichment system across 100K+ invoice records using 4-tier fallback strategy (Google/Mapbox geocoding → ZIP database → county inference → global drive-model fallback).
- Built latitude/longitude enrichment module mapping addresses to county-level geography.
- Implemented drive-distance calculation engine with structured logging and audit trail for compliance.
- Impact: Reduced manual invoice validation effort by 60%; improved logistics pricing accuracy.
TSP Logistics Automation Platform — VBA + Python, Workflow Orchestration
- Designed modular automation system integrating Outlook email extraction, attachment processing, and Python ETL.
- Built VBA module auto-downloading, organising, and queuing incoming TSP data files with error handling and retry logic.
- Engineered Python pipeline for fuzzy-match duplicate detection, business-rule tagging, multi-level grouping, and validated outputs (TSP Master & Email Master).
- Impact: Eliminated 8+ hours/week of manual processing; reduced data errors by 95%.
Global Supplier Normalization Engine — Python, Entity Resolution
- Architected rule-based entity-resolution system standardising 50K+ global supplier records across translation variants, inconsistent formats, and special characters.
- Built custom string-cleaning pipeline with multi-language support (English, Portuguese, Spanish, German).
- Implemented string-based bucketing (blocking strategy) grouping similar records before normalization.
- Designed governance framework with audit logging and rollback capability ensuring transformation traceability.
- Output: Clean supplier master dataset improving procurement accuracy by 95%; enabled cross-company consolidation.
Procurement Analyst – Reporting & Data Automation, Deloitte Support Services
Hyderabad, India
- Designed automated procurement analytics pipelines delivering spend reporting on daily / weekly / monthly / quarterly / annual cadence for global client firms.
- Developed Excel VBA automation for contract change tracking (comments, deletions, editions) — estimated monthly savings of $1,000+.
- Implemented data validation frameworks eliminating reporting errors; improved spend/revenue report accuracy.
- Built Power Query data-quality tools comparing month-over-month data availability across 4 years (100K–400K records/set).
- Migrated legacy MS Access databases to SQL Server, improving query performance, scalability, and reliability.
- Implemented contract data normalization consolidating multi-record contracts into single-line items for master/sub-agreement visibility.
- Contributed to automation initiatives supporting client savings exceeding $1M through improved data visibility.
- Key projects: Track Changes Macro (80% time saving), Member Firm Split Automation, Service Feedback Automation (1 month → 1 minute), Meld Access → SQL Server migration (4 yrs · 400K+ records), P2C Meld Validation Dashboard, Contracts Grouping & Normalization.
Analyst – Data Migration & Automation, Orion India Systems (Deloitte Project)
Hyderabad, India
- Supported enterprise data migration from legacy platforms to new procurement systems with zero data loss and minimal disruption.
- Built VBA automation for email attachment extraction, data consolidation, and Excel–Outlook workflows.
- Developed comprehensive Standard Operating Procedures for error-free migration processes.
HRIS – MIS Reporting Analyst, Orion India Systems
Hyderabad, India
- Generated enterprise HR analytics reports using SAP HANA, Crystal Reports, and SAP BI Launch Pad.
- Spearheaded standardisation and automation of reports/dashboards, improving operational efficiency.
- Conducted knowledge-sharing sessions identifying process automation opportunities.
Key Projects & Architecture Examples
FinWise — Financial Intelligence Platform (MVP Architecture · Flutter + Riverpod · SQLite · Offline-First)
- Architecting mobile-first financial intelligence platform helping individuals and business owners understand loan products, optimise credit, and make data-driven financial decisions.
- Components designed: Loan Intelligence Engine (EMI / closure / balance transfer modelling), Credit Report Analysis, Financial Risk Radar (rule-based scoring + anomaly detection), OCR Document Understanding, Action Engine, and Life Vault (secure document storage).
- Offline-first design with local SQLite and Firebase sync; Riverpod state management; modular per-domain feature structure.
- Used Claude / ChatGPT for architecture validation, workflow design review, and failure-mode analysis — not code generation.
Logistics Intelligence & Geo-Analysis Platform
- Multi-source data integration (shipments, invoices, carriers, services) with automated relationship detection and anomaly flagging.
- Geographic enrichment (lat/long, county, drive-distance) with executive dashboards and automated narrative insights.
- Modular pipeline (extraction → validation → transformation → export) with 4-tier fallback strategies; scales to 100K+ records daily.
Enterprise Automation Suite (Multi-project Portfolio)
- Email extraction automation (Outlook COM API); business-rule engine for tagging and categorization.
- Duplicate detection (exact + fuzzy); template generation and validation (NPI project); config-driven dynamic dropdowns (PSR system); weekly automation pipelines (Productivity WOW).
Education
Languages
English (Fluent) · Hindi (Fluent) · Telugu (Native)