Tanish Rudroji Rao Ghorpade
Data Analyst | Backend Developer
Bengaluru, IN.About
Results-oriented Data Analyst with hands-on expertise in designing and optimizing data pipelines, advanced analytics, and business intelligence solutions. Adept in SQL, Python, and cloud platforms, I translate complex data into actionable insights and deliver high-impact dashboards using Power BI and Tableau. Passionate about leveraging modern data practices to drive data-driven decision-making and deliver measurable business value.
Work
Hyderabad, Telangana, India
→
Summary
Currently serving as a Data Analyst, I lead comprehensive data initiatives from pipeline design and optimization to advanced analytics and interactive dashboard development. My role focuses on leveraging real-time data to enhance monitoring, reporting, and forecasting accuracy for key stakeholders.
Highlights
Designed and implemented a real-time data pipeline for environmental sensors (rain, water level, humidity, wind, temperature), significantly improving monitoring, reporting, and forecasting accuracy.
Built and optimized ETL pipelines using Python and SQL, automating sensor data flow from ingestion to storage and enhancing data freshness.
Created and managed robust database schemas and designed efficient SQL views, improving data accessibility and performance for reporting and analytics.
Developed interactive dashboards with Power BI, Tableau, and Excel, delivering real-time insights that empowered stakeholders to make data-driven decisions.
Applied statistical analysis, data visualization, and forecasting models using Matplotlib, Seaborn, and Scikit-learn to uncover critical patterns and predict future trends.
Integrated diverse data sources (APIs, CSV, JSON, Excel) into centralized cloud databases, including AWS Redshift, Google BigQuery, and Azure SQL, ensuring comprehensive data availability.
Automated routine reporting tasks with Python scripts and Excel macros, reducing manual effort by an estimated X% and increasing reporting efficiency.
Collaborated with cross-functional teams to define key metrics, monitor performance, and deliver actionable insights, fostering a data-centric culture.
Bengaluru, Karnataka, India
→
Summary
As a Backend Developer Intern, I contributed to the development of scalable server-side applications and RESTful APIs using Python and Django, while also gaining foundational experience in frontend development with JavaScript.
Highlights
Developed scalable and efficient server-side applications using Python and Django, implementing RESTful APIs to facilitate seamless frontend-backend communication.
Designed and implemented robust API documentation using Swagger, enhancing clarity and accessibility for both internal developers and external stakeholders.
Applied Onion Architecture principles in Django projects, improving maintainability, scalability, and ensuring clear separation of concerns.
Contributed to frontend development using JavaScript, focusing on client-side scripting and foundational UI principles to support application functionality.
Languages
English
Hindi
Kannada
Telugu
Skills
Programming Languages
Python, SQL, JavaScript.
Data Engineering
ETL Design, Data Pipelines, Workflow Automation (Airflow, Cron), Data Warehousing (Redshift, PostgreSQL, MySQL), Data Quality, Data Validation, Data Governance, API Integration (APIs, CSV, JSON, Excel).
Databases
MS SQL, MongoDB, MySQL, PostgreSQL, AWS Redshift, Google BigQuery, Azure SQL, Schema Design, Performance Optimization, CRUD Operations, Indexing, Aggregations.
Business Intelligence & Analytics
Power BI, Tableau, Excel, Statistical Analysis, Data Visualization (Matplotlib, Seaborn), Forecasting Models (Scikit-learn), Real-time Insights.
Cloud Platforms & DevOps
AWS (EC2, VPC, S3, IAM), Google Cloud Platform, Microsoft Azure, Terraform, CloudFormation, Docker, Kubernetes, CI/CD (Jenkins, GitHub Actions), CloudWatch.
Backend Development
Django, RESTful APIs, API Documentation (Swagger), Onion Architecture.
Frontend Development
ReactJS, Client-side Scripting, HTML, CSS.
Big Data Technologies
Spark, Hive, Hadoop.
Tools & Methodologies
VS Code, Git, GitHub, Jira, Confluence, Version Control, Project Tracking, Cross-functional Collaboration.