Rupshana Ekka

• Working on the family business to modernize operations and accelerate growth using my skills in data engineering, automation, and digital content strategies.
• Performed sales pattern analysis to identify best-selling items and customer preferences, enabling data-backed decisions on pricing and product focus. Leveraged insights to design targeted campaigns and offers, achieving a record 15-day revenue of ₹1.8 Lakh — the highest since inception.
• Created and managed social media content generation, integrating AI-based tools to produce high-quality posts, captions, and insights 3× faster.
• Helped scale the business operations efficiently, cutting manual work by over 60% while boosting online visibility through consistent content generation and performance tracking.
• Currently, working on automating reporting and performance dashboards based on reviews, feedbacks and surveys, providing real-time visibility into sales, engagement, and growth metrics. Also, helping businesses modernize their operations through data engineering and automation solutions.

Automation of migration process

• Fully automated manual migration process from Snowflake to SAS datasets using SAS scripts and Shell Scripting, handling more than 150 tables of each brand.
• Reduced manual intervention by 87%.
• Carried out miscellaneous requests made by the client like monitoring and alerting using CloudWatch for CPU utilization and memory consumption which enabled proactive issue detection during migration and better system reliability by 25%.

Omnichannel Engine

• Developed 4 brand-agnostic kedro data pipelines on AWS cloud orchestrated on Kubernetes (EKS) to automate cross-brand ELT processes integrating 6 brands across 4 therapeutic areas with Kubernetes deployments and workflow components via Helm Charts.
• Improved campaign performance analytics accuracy by 92%.
• Implemented SonarQube for continuous code quality analysis, helping to identify bugs, vulnerabilities and code smells early in the development lifecycle of data pipelines, reducing post-deployment issues by 35%.
• Standardized data pipelines across brands, leading to a 20% improvement in operational efficiency.
• Reduced post-deployment issues by 35%.
• Set up a centralized logging and monitoring system using Grafana and Cloudwatch, providing real-time data pipeline insights, reducing memory consumption by 48%, minimizing system outages by 18%.
• Additionally, addressed AWS security violation, implemented IAM best practices and enhanced DevSecOps practices for secure data workflows.
• Enforced security best practices by automating IAM roles, VPC security groups, and S3 bucket policies via Terraform by 25%.
• Knowledge on optimized data migration process by implementing autoscaling and load balancing solutions under fluctuating workloads.
• Expertise on designing the overall Virtual Private Cloud (VPC), Subnets, Routing table, Internet gateway and NAT gateway to set up a VPC in AWS environment.
• Automated cloud infrastructure provisioning using Terraform (AWS VPCs, EC2, IAM, S3, RDS, EKS), reducing manual efforts from 2 days to 30 mins approximately and ensuring consistency across environments.
• Experimented with monitoring and scaling strategies (HPA, resource limits) to improve cluster efficiency.
• Proactively troubleshot Kubernetes pod errors (CrashLoopBackOff, ImagePullBackOff, OOMKilled, Pending) across AWS EKS clusters, reducing deployment failures by 35% and improving system reliability.
• Documented troubleshooting steps accelerated root cause analysis (RCA) by 40% during recurring pod failures.

• Created dashboard tracker of employees of PMT team using SQL and tracked weekly and monthly sales data for region-wise sales and profit analysis.
• Increased the decision-making efficiency by 45%.
• Reduced 80 hours of manual work per week by automating the image extraction process.