Raunak Rathore
Hyderabad, India *************@*****.*** +91-940******* linkedin.com/in/raunak-rathore PROFILE
Senior Data Analyst Data Engineer BI Developer 5+ Years of Experience Python, SQL, Tableau, Power BI Senior Data Analyst with 5+ years of experience transforming business requirements into data-driven solutions. Adept at using Python, SQL, Tableau/Power BI, and Excel to automate reporting, visualize key metrics, and optimize ETL workflows across large datasets. Experience in AWS, Azure, data warehousing, and data governance across key sectors.
TECHNICAL SKILLS
Languages & Tools: Python (Pandas, NumPy), SQL, Tableau, Power BI, Excel, Dash, AgGrid, Airflow, Snowflake, Git, Docker, Jenkins, Putty
Data Engineering: ETL, API Integration, Automation, Stored Procedures, Data Warehousing Collaboration/DevOps: JIRA, Confluence, Bitbucket, SourceTree, CI/CD, Agile Development Cloud Platforms: AWS (EC2, S3), Azure (ADF, Synapse) Soft Skills: Stakeholder Communication, Agile Development, Team Collaboration EXPERIENCE
Senior Data Analyst Sept 2022 – Present
Clario, Bengaluru, India
• Created 15+ Tableau/Power BI dashboards, increasing reporting efficiency by 25%.
• Automated 30+ reports via Python, saving 25 hours/month and reducing manual effort by 40%.
• Designed 20+ SQL stored procedures and Airflow pipelines, cutting ETL runtime by 35%.
• Built real-time Dash + AgGrid dashboards, improving user interaction by 30%.
• Optimized Snowflake queries, halving dashboard load time for 100+ users.
• Delivered 10+ Agile sprints using JIRA, Confluence, Git, and Bitbucket.
• Reduced deployment time from 45 to 10 mins via Jenkins and CI/CD integration.
• Leveraged AWS S3 and EC2 for reporting automation & backups. Data Analyst Feb 2020 – Sept 2022
LTI Mindtree, Hyderabad, India
• Led analytics projects with cross-functional teams.
• Designed automated SQL Server Reporting Services.
• Advised on warehouse design, improved query speed by 40%.
• Developed 50+ SQL procedures/views/functions, reducing report time by 70%.
• Analyzed 10M+ row datasets and presented insights to stakeholders. PROJECTS
• KPI Dashboard: Built real-time dashboards using Dash + AgGrid to track adverse events, reducing compliance response time by 25%.
• ETL Automation: Automated trial data ingestion into Snowflake using Airflow and Python, improving data availability by 12 hours/day.
• Enrollment Analytics: Analyzed patient trends and built Tableau/Power BI dashboards, improving regional recruitment by 18%.
• Site Monitoring: Implemented SQL validation logic across 10+ studies to ensure protocol adherence and data accuracy. EDUCATION
B.Tech, Information Technology June 2015 – May 2019 SRM University, Delhi-NCR
GPA: 7.6/10 — First Class with distinction
CERTIFICATIONS
• Data Analyst Career Path – DataCamp (2022) — Skills: Python, Data Cleaning, Visualization
• Snowflake for Analysts – Udemy (2023) — Tools: Snowflake, SQL
• Python for Everybody – Coursera (Univ. of Michigan, 2022) — Tools: Python, Pandas, SQLite