Sruthi Pushadapu

Experience

1. Data Engineer

   Bosphorus Enterprises, Inc

   Nov 2023 — Present · Coraopolis, PA, US

   Automated Power BI Reporting Pipeline: Developed a Python Selenium-based automation to extract, store, and refresh Power BI dashboards on a local server, integrating with scheduled jobs to ensure real-time updates. This reduced manual reporting time by 80% and eliminated human errors.>>Built ETL Pipelines: Designed and optimized data extraction, transformation, and loading (ETL) pipelines using SQL, Python (Pandas, NumPy), and Power Query, streamlining data flow from multiple sources into Power BI dashboards.>>SQL Query Optimization: Optimized complex SQL queries and stored procedures, reducing query execution time by 50%, improving data retrieval speed for business reports.>>Advanced Data Modeling: Applied DAX calculations in Power BI and used feature engineering techniques to enhance data granularity and predictive analytics capabilities.>>Predictive Analytics & Machine Learning: Implemented forecasting models in Python using Scikit-Learn and Time Series Analysis, enabling proactive decision-making based on historical trends.>>Automated Reporting & Alerts: Integrated Python scripts with Power BI REST API to trigger email notifications for key business metrics, ensuring stakeholders received timely alerts on KPI deviations.>>Data Visualization & Dashboarding: Created interactive Power BI dashboards with advanced drill-down capabilities, optimizing reports for executive and operational teams.>>Data Cleaning & Preprocessing: Standardized large datasets, handled missing values, and performed data wrangling using Python (Pandas) and SQL, ensuring high data quality for accurate reporting.