Harshitha Gangasani

Experience

• 

  Tudip Technologies

  Jun 2020 - Jul 2022

  Data Analyst

  • Increased production efficiency by 15% and reduced operational costs by 10% through Python and SQL (PostgreSQL)-driven data extraction, cleaning, and analysis.• Streamlined data processing and advanced analytics using Azure and Databricks, improving scalability and efficiency of cloud data pipelines.• Optimized version control and CI/CD pipelines via GitLab, enabling continuous integration and efficient cross-team collaboration.• Delivered strategic insights through data analysis, improving business performance by 15%.• Built machine learning models with Scikit-learn, created visualizations using Seaborn and SciPy, and developed dashboards in Looker and Excel to support data-driven initiatives. Show less

• 

  University of Colorado Denver

  Jan 2023 - May 2024

  Instructional Assistant(Data Analyst)

  • Designed and optimized SQL architecture to streamline data transformation workflows, enhancing compliance and security for enterprise applications.• Automated workflows and improved data accessibility by developing Power Apps solutions integrated with SQL Server, SharePoint, and external APIs.• Improved data flow efficiency by 30% through ETL processes, data migrations, and integrations between SQL Server, Power Apps, and cloud systems.• Designed and developed interactive Alteryx dashboards and reports to visualize key business metrics, resulting in a 20% improvement in decision-making efficiency.• Boosted application performance by troubleshooting issues, fine-tuning system efficiency, and implementing best practices for scalability and reliability. Show less

• 

  Simaxive

  Jul 2024 - now

  Data Analyst

  • Optimized SQL queries for large datasets, improving query performance by 25% and enabling faster, more accurate reporting.• Automate data workflows by designing and refining ETL pipelines, reducing processing time by 40% and ensuring seamless data integration.• Cleaned and transformed data using Pandas and NumPy, improving data quality by 35%, and enhanced financial forecasting by 15% with time series models (stats models, scikit-learn).• Administer and optimize Oracle and MongoDB databases, enhancing data storage solutions and boosting query performance by 40%, leading to more efficient and accurate data retrieval.• Developed predictive models using Python and SAS to identify trends and support data-driven decision-making.• Created PowerBI and Tableau dashboards for real-time financial reporting and KPI tracking, cutting manual and fostering data-driven decision-making.• Led multi-channel A/B testing initiatives to refine customer engagement approaches, resulting in a significant boost in conversion rates Show less