r
rounak_lakhotia

Rounak Lakhotia

@rounak_lakhotia

Data Analytics and Dashboard Solutions for Business

India
Inglés, Hindi
Parte de la información aparece en idioma inglés.
Sobre mí
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!... Lee más

Habilidades

r
rounak_lakhotia
Rounak Lakhotia
desconectado • 

Revisa mis servicios

Panel de datos
I will create professional excel dashboards with automation and ai

Experiencia laboral

Amazon

Business Intelligence Analyst

Amazon • Tiempo completo

Apr 2021 - Aug 20254 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.