Summary
Overview
Work History
Education
Skills
Websites
Projects
Timeline
Generic

Meghana Ramireddy

Kent,USA

Summary

Experienced Data Professional with 2.5+ years of combined experience in Database Administration and Data Analysis, specializing in data management, predictive analytics, and business intelligence. Proficient in SQL Server, NoSQL, Azure SQL, Python, R, and ETL pipelines, with expertise in data wrangling, visualization, and statistical analysis. Skilled in designing and maintaining scalable databases, optimizing performance, and implementing backup & recovery strategies. Strong knowledge of machine learning models, big data technologies, and cloud platforms (AWS, Azure, GCP) to optimize workflows and drive insights. Adept at automation using Ansible, database security, and stakeholder collaboration to enhance decision-making, efficiency, and business performance

Overview

4
4
years of professional experience

Work History

Junior Data Analyst

Doublene
, USA
01.2024 - Current
  • Optimized ARIMA-driven demand forecasting for internal products using 250K+ data points, validating trends through A/B testing across 12 key insights, resulting in a 10% improvement in inventory planning and a 7% rise in revenue
  • Analyzed HiveQL workflows by implementing predicate pushdown and vectorization, enhancing query efficiency and cutting execution costs by 40% on AWS EMR clusters
  • Improved data accuracy by resolving 90% of inconsistencies in a complex CRM dataset, ensuring enhanced data integrity and reliability
  • Streamlined data workflows by implementing Python algorithms, boosting processing speed 100%
  • Developed comprehensive business and functional specification documents, ensuring precise implementation and minimizing revisions by 30%
  • Guided 20+ analysts in using Alteryx workflows for entity resolution, accelerating client onboarding data refinement from 2 weeks to 4 days

Database Administrator

Techecy
, India
05.2021 - 07.2022
  • Managed and optimized SQL Server and NoSQL databases, improving query performance by 30% through indexing, partitioning, and tuning strategies
  • Implemented and maintained Azure SQL solutions, ensuring 99.9% uptime and enhancing cloud-based database efficiency
  • Automated database administration tasks using Ansible, reducing manual effort by 40% and improving deployment consistency
  • Designed and executed robust backup and recovery strategies, achieving zero data loss incidents and reducing recovery time by 50%
  • Monitored and troubleshot database performance issues, resolving critical bottlenecks and improving system reliability
  • Ensured database security and compliance, implementing role-based access control (RBAC) and encryption best practices
  • Managed database migrations and upgrades, minimizing downtime and ensuring smooth transitions across environments

Education

Master - Business Analyst

KENT STATE UNIVERSITY
Kent, OH, USA
12.2023

Bachelor of Commerce - Honors

AVINASH Degree College, Osmania university
Hyderabad, India
07.2021

Skills

  • Programming & Scripting: Python, R, SQL, T-SQL, SAS, Shell Scripting, VBA, Automation Script
  • Database & Data Management: SQL Server, NoSQL, Azure SQL, Database Backups & Recovery, Database Administration, Data Cleaning, Data Wrangling, ETL Pipelines, Data Modeling, DBT, Snowflake, MS SQL Server, PostgreSQL, RDS
  • Cloud & Big Data Technologies: Google Cloud Platform (GCP), Microsoft Azure, AWS (S3, EC2, Lambda, Redshift), Azure Synapse, Hadoop, Google BigQuery, Apache Spark, Databricks, Kafka
  • Automation & Infrastructure: Ansible, Apache NiFi, Talend, Fivetran, API Integration, Data Connectors
  • Data Visualization and Business Intelligence: Tableau, Power BI, Dash, Seaborn
  • Predictive Analytics & Machine Learning: Classification, Regression, Model Evaluation, SVM, k-Nearest Neighbors (k-NN), TensorFlow, PyTorch, Keras, Scikit-learn, XGBoost, Logistic Regression, Random Forest, Neural Networks, Clustering, Unsupervised & Supervised Learning
  • Tools & Version Control: Alteryx, JIRA, Confluence, Git, GitHub, Bitbucket
  • Methodologies: Applied Software Development Life Cycle (SDLC), Agile (Scrum, Kanban)
  • Reporting & Business Analytics: Excel (Advanced, VBA), Data Storytelling, DAX, Power Query, SSRS

Projects

  • Customer Relationship Management (CRM) System Implementation, Led the end-to-end implementation of a CRM system by collaborating with stakeholders to gather key business requirements and map current and future-state processes. Conducted user acceptance testing (UAT) and facilitated training sessions to ensure seamless adoption, improving customer engagement and operational efficiency.
  • Breast Cancer Tumor Classification Modeling, Developed a machine learning model to classify breast cancer tumors using K-Nearest Neighbors (KNN) and Decision Trees. Achieved a high classification accuracy of 95.26% with KNN and 92.04% with Decision Trees, optimizing predictive performance through feature engineering and hyperparameter tuning.

Timeline

Junior Data Analyst

Doublene
01.2024 - Current

Database Administrator

Techecy
05.2021 - 07.2022

Master - Business Analyst

KENT STATE UNIVERSITY

Bachelor of Commerce - Honors

AVINASH Degree College, Osmania university
Meghana Ramireddy