Archana Sabbarapu

• Built different ETL applications for Real Time & Batch streaming of large data from different sources like Apache Kafka, GCS etc
• Setup MLFlow pipeline to manage machine learning lifecycle & contributed to MLOps for different ML solutions we implemented
• Implemented a Ranking algorithm for hotels search which gave a conversion uplift of 2% in hotel bookings
• Powered dynamic origin & destination suggestions using Apache Druid insights
• Built an API for user profiling & personalisation using real time aggregations.
• Led end-to-end implementation of multiple high-impact projects like user profiling from requirements gathering through deployment and post-launch support stages.
• Worked on Azkaban for orchestrating flows & worked on CI/CD pipelines for various deployments
• Enabled facts for different analytical use cases which reduced the data warehouse querying cost by 20%.
• Fine-tuned query performance and optimized database structures for faster & achieved faster query response times through the implementation of appropriate indexing strategies in databases.
• Collaborated intra teams on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Enhanced data quality by performing thorough cleaning, validation, and transformation tasks & integrated great expectations framework.
• Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
• Migrated legacy systems to modern big-data technologies, Ex: Migrated one job in Apache Pig to Apache Spark.
• Provided technical guidance and mentorship to junior team members, fostering a collaborative learning environment within the organization.
• Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.

• Written ETL processes to load data from various sources to the BigQuery platform
• Built Google data studio dashboards for L0 business KPIs to track adoption of different ancillaries, monitoring booking trends & funnels.
• Increased automation in reporting processes by designing dynamic dashboards using visualization tools like Tableau or Power BI.
• Performed analysis for multiple A/B experiments & created funnels to monitor user behavior
• Worked on user click stream data & built a custom dashboard for funnel analysis
• Contributed on creating behavioral segments on CRM tools to enhance the targeted communications
• Built AB testing platform to run split tests.
• Reduced data discrepancies by implementing rigorous data validation techniques and automated error detection.
• Promoted code reusability, creating a library of common functions that could be easily integrated into different projects for both Java & Python.
• Mitigated risks associated with data breaches or unauthorized access by adhering to strict security protocols and implementing robust safeguards at every level of the data pipeline. Automated the process of granting access to Data platform via JIRA & Python.

GPA: 9.1

• Chat Bot-Moratorium Customers - Capstone Project

In the COVID-19 situation many customers avail moratorium on different types of
loans from the Bankers. We have build a chat bot application to collect data, scenarios
and the reasons.

Tech Stack: HTML5, CSS, Bootstrap, MySQL, JSP

• Object detection for visually impaired using template matching technique - Minor Project

To detect and classify objects in the input image and give a voice output to the end
user (visually impaired). We used Template matching algorithm to detect the
objects in the image.

Tech Stack: MATLAB