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
• 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.

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.
• 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.
• 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.
• 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.

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
• 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.

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.
• 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.
• 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