r
rounak_lakhotia

Rounak Lakhotia

@rounak_lakhotia

Data Analytics and Dashboard Solutions for Business

Índia
Inglês, Hindi
Algumas informações são exibidas no idioma inglês.
Sobre mim
Hi! I'm Rounak, a Data Analyst with 4.5+ years of experience helping businesses make data-driven decisions. I specialize in creating dynamic Excel dashboards, automating reports, and analyzing trends using tools like SQL, Python, and Power BI. From raw data to actionable insights, I deliver solutions that drive results. Let's work together to unlock the value of your data!... Saiba mais

Habilidades

r
rounak_lakhotia
Rounak Lakhotia
offline • 

Conheça meus serviços

Painéis de dados
I will create professional excel dashboards with automation and ai
A partir deUS$ 25 /projetoMais detalhes

Experiência profissional

Amazon

Business Intelligence Analyst

Amazon • Período integral

Apr 2021 - Aug 2025 • 4 yrs 4 mos

Risk Architecture and Financial Impact: Created and implemented a Python-based fraud detection system that discovered high-risk anomalies in 285K+ transactions, decreasing routing failures by 80% and saving over $400K per year. Enterprise Dashboard Architecture: Led the design and deployment of advanced analytics dashboards (Power BI/QuickSight/Tableau); integrated ETL workflows for Weekly Business Reviews (WBRs), reducing manual effort by 580+ hours annually. Global Program Orchestration: Led end-to-end data strategy for 10+ international product launches in India, the EU, and North America; achieved 100% data integrity for partner onboarding and SLA compliance. Data Governance & Quality Assurance: Oversaw data integrity initiatives across the logistics network; engineered audit frameworks that optimized data quality from 95.6% to 99.99%, ensuring reliable insights for senior leadership. Strategic Turnaround: Recognized for delivering a 20% increase in team productivity using custom automation tools (DAX QueryVBA/Tampermonkey); addressed UK area backlogs with a 50% improvement in Turnaround Time(TAT). Stakeholder Advisory & Data Culture: Served as a trusted advisor to senior management, translating complex analytical concepts into impactful narratives; championed data literacy by training 150+ team members on visualization best practices.