RAMYA B

ETL Automation Pipeline (Python).

• Designed and implemented an automated ETL pipeline using Python and pandas to extract, clean, and transform structured data.
• Integrated push intelligence by triggering email alerts for insights and pipeline status.
• Scheduled tasks and managed push-to-release processes using cron/Task Scheduler for timely delivery.

E-commerce Product Performance Analysis (Power BI).

• Designed and implemented a Power BI dashboard that visualizes sales funnel progression, highlights high-performing products, and tracks cart abandonment trends.
• Integrated and transformed raw Excel/CSV data using Power Query for clean, structured reporting.
• Created custom DAX measures to calculate KPIs such as conversion rate, AOV, and return rate, enabling data-driven business decisions.

Query Optimization in E-commerce Databases (SQL)

• Tuned complex SQL queries fetching product, user, and order data by optimizing JOIN operations, refining WHERE clauses, and applying strategic index hints.
• Achieved a 4x improvement in analytics dashboard load time, enhancing performance and user experience for business stakeholders.

• Developed Android apps using Kotlin, MVVM architecture, and RESTful APIs
• Integrated Firebase, third-party SDKs, and handled Google Play publishing.

• Developed SIM Carrier Blocking, Jingles Management, and Offline Downloads modules for Caribbean music streaming platform.
• Constructed Customer Benefits module and executed full REST API integration for ProFoodies Recipe App.
• Designed UI for Customer Benefits module and integrated PayFort payment gateway with One Step Checkout in Purplebox E-commerce App.
• Implemented RESTful services with JSON parsing across all projects to support real-time data rendering.
• Collaborated with clients in Agile environments to deliver scalable, production-ready features.

• Developed and maintained Android apps using Firebase, SQLite, and Android Studio.
• Improved performance and fixed bugs based on QA feedback.