Lekha Bobbala

ETL Development & Data Migration

• Built and maintained end-to-end ETL pipelines using Hadoop ecosystem tools (Sqoop, Hive, HQL, shell scripting, Automic Scheduler).
• Migrated legacy on-premise data pipelines to Google Cloud Platform (GCP), improving scalability, reliability, and reporting efficiency.
• Ensured high data quality and reliability, supporting accurate analytics and business decision-making.

Data Analytics & Business Intelligence

• Designed interactive dashboards and reports to monitor inventory, supply chain metrics, and operational KPIs.
• Created metrics to track stock levels, overstock conditions, and inventory movement patterns.
• Improved visibility for operations teams, helping reduce inefficiencies and optimize resource allocation.
• Developed financial and operational reports to monitor budget adherence, expenses, and investment trends.
• Built analytics tools for internal teams and external partners to share insights, collaborate, and identify revenue opportunities.
• Automated regular reporting workflows to reduce manual effort and improve timeliness of insights.

Technical & Analytical Tools

• Leveraged Python (Pandas, NumPy) and Excel for data transformation, analysis, and reporting.
• Utilized Tableau and Power BI for visualization, implementing best practices for interactive and actionable dashboards.
• Collaborated with cross-functional teams to translate business requirements into automated, reliable analytics solutions.

Data Analysis & Tableau Development

• Created Tableau scorecards and dashboards using stacked bars, bar graphs, scatter plots, geographical maps, Gantt charts, and heat maps.
• Worked extensively with advanced analysis actions, calculations, parameters, background images, and maps.
• Applied data blending in Tableau to combine multiple data sources for unified reporting.
• Developed dashboards in Tableau Desktop and published to Tableau Server with filters for on-demand user insights.
• Scheduled data refreshes on Tableau Server for weekly and monthly updates to ensure accuracy.
• Tested queries and dashboards prior to publishing; provided post-publish support for data or system changes.

Python & Excel Analysis

• Performed data cleansing, transformation, and analysis using Python (Pandas, NumPy).
• Created reports, pivot tables, and charts in Excel to support ad hoc business analysis.
• Collaborated with teams to validate data, uncover trends, and provide actionable recommendations.