kalash negi

Junior Power BI / Data Analyst

AeonX Digital

Jan 2025 - Present

Design, build, and deploy interactive enterprise dashboards across Power BI Desktop/Service, Amazon QuickSight, Looker, and Grafana for real-time executive KPI and operational tracking. Author performant DAX measures, calculated columns, and Time Intelligence functions (YoY, MoM, YTD) along with visual tooltips, field parameters, and drill-through pages. Perform data validation, reconciliation, and dashboard performance tuning using Power BI Performance Analyzer to optimize visual rendering and query response times. Architect Star Schema data models and construct robust ETL data transformation pipelines using Power Query (M Language) and custom Python backend scripts. Write complex SQL scripts (CTEs, Window Functions, dynamic joins) across multi-cloud databases including Google BigQuery, PostgreSQL, and MySQL to drive dashboard datasets. Configure automated dataset refresh schedules and manage data source connectivity across hybrid cloud environments. Engineer AI-powered natural language QA interfaces over dashboard datasets using LLM APIs (Claude, Vertex AI, OpenAI) to allow non-technical users to query data via chat. Build vector search pipelines and indices using Amazon OpenSearch and Amazon Bedrock / Titan models for similarity matching and semantic search workflows. Integrate AWS intelligent services including AWS Textract for document parsing (invoices/resumes) and image generation models into live production chat applications. Develop and deploy production FastAPI/Python microservices for intelligent business tools, including resume analysis, interview scoring, and expense duplication detection. Architect granular Role-Based Access Control (RBAC) frameworks and Power BI Row-Level Security (RLS) rules to enforce multi-tenant data isolation and secure user permissions.