Vennela B Email & Phone Number

Stillwater, Oklahoma, United States

• Migrated large PDB files, research data, and databases to Google Cloud Storage and Cloud SQL for secure, scalable storage, enhancing data accessibility.• Set up Compute Engine instances with required OS dependencies for efficient data processing and analysis in GCP research workflows.• Configured Identity and Access Management (IAM) to ensure secure access, compliance, and streamlined permissions for research teams.• Utilized Google Kubernetes Engine (GKE) to containerize and… Show more • Migrated large PDB files, research data, and databases to Google Cloud Storage and Cloud SQL for secure, scalable storage, enhancing data accessibility.• Set up Compute Engine instances with required OS dependencies for efficient data processing and analysis in GCP research workflows.• Configured Identity and Access Management (IAM) to ensure secure access, compliance, and streamlined permissions for research teams.• Utilized Google Kubernetes Engine (GKE) to containerize and orchestrate research applications for scalable, complex data analysis.• Automated environment setup and provisioning with Terraform for efficient, repeatable GCP infrastructure deployment.• Monitored resource usage with Cloud Monitoring and Cloud Logging to optimize performance and manage costs. Show less

Stillwater, Oklahoma, United States

• Led data management for Rx Medical and Rok Sales, handling sales, stock levels, and supply chain data, leveraging Python for automating Excel file splits based on hospital demand and inventory levels, enhancing data accessibility and operational efficiency.• Improved reporting efficiency by 25% through automated SQL window functions (RANK, DENSE_RANK, CTE, Sub-queries) and ad-hoc queries, supporting critical business decisions related to stock levels, distribution, and inventory… Show more • Led data management for Rx Medical and Rok Sales, handling sales, stock levels, and supply chain data, leveraging Python for automating Excel file splits based on hospital demand and inventory levels, enhancing data accessibility and operational efficiency.• Improved reporting efficiency by 25% through automated SQL window functions (RANK, DENSE_RANK, CTE, Sub-queries) and ad-hoc queries, supporting critical business decisions related to stock levels, distribution, and inventory planning.• Designed Power BI dashboards with dynamic filters, drilldowns, and DAX calculations for real-time tracking of stock, expiration, and returns while creating scalable, self-service platforms providing key KPIs for faster sales tracking and loss analysis. Show less

India

• Migrated 1200 TB of on-premises data to Amazon S3 using AWS DataSync and AWS Snowball for efficient, secure transfer and a 30% reduction in storage costs.• Established a Data Lake on Amazon S3 for historical data storage, creating a centralized repository for structured and unstructured data.• Used Amazon Redshift and Redshift Spectrum to query data directly from S3, enhancing data accessibility and improving query by 30%.• Implemented RDS for new data records, automated backups… Show more • Migrated 1200 TB of on-premises data to Amazon S3 using AWS DataSync and AWS Snowball for efficient, secure transfer and a 30% reduction in storage costs.• Established a Data Lake on Amazon S3 for historical data storage, creating a centralized repository for structured and unstructured data.• Used Amazon Redshift and Redshift Spectrum to query data directly from S3, enhancing data accessibility and improving query by 30%.• Implemented RDS for new data records, automated backups and multi-AZ deployment for high availability, optimized database management.• Integrated Snowflake on AWS for advanced analytics, enabling data transformation and faster queries, improving data processing efficiency.• Configured Apache Kafka for real-time streaming and used Apache NiFi and Apache Airflow to orchestrate ETL workflows, reducing data processing.• Deployed the company website on Amazon EKS with backend services hosted in VPC subnets, using AWS Lambda for serverless applications.• Optimized network security with VPC configurations, Network Security Groups (NSGs), and Traffic Manager for secure traffic handling.• Monitored system performance with Amazon CloudWatch and configured AWS CloudTrail for tracking user activity and improving security.• Automated environment provisioning with AWS CloudFormation and Terraform, ensuring efficient and repeatable infrastructure deployments.• Established lifecycle policies on Amazon S3 to manage data archiving, optimizing storage costs and supporting long-term data retention. Show less

India

Healthcare Data Analytics Platform, Predictive Modeling for Patient Outcomes.• Led a project to analyze and visualize hospital patient data, focusing on enhancing data accessibility and supporting decision-making through business intelligence practices and robust data analysis.• Conducted in-depth analysis of patient records, operational data, and pharmaceutical stock using SQL, Google BigQuery, and Python, ensuring accuracy across JSON and CSV formats, and implemented Apache Kafka and… Show more Healthcare Data Analytics Platform, Predictive Modeling for Patient Outcomes.• Led a project to analyze and visualize hospital patient data, focusing on enhancing data accessibility and supporting decision-making through business intelligence practices and robust data analysis.• Conducted in-depth analysis of patient records, operational data, and pharmaceutical stock using SQL, Google BigQuery, and Python, ensuring accuracy across JSON and CSV formats, and implemented Apache Kafka and NiFi to automate reporting, reducing data latency by 70%.• Utilized R (hypothesis testing, correlation, regression) and created visualizations with Matplotlib, Seaborn, and ggplot2• developed interactive dashboards in Power BI, along with data quality frameworks and automated validation checks to ensure consistency. Show less