Resume of V Radha Rani
avatar

V Radha Rani
Data Engineer - Big Data

About

A big data engineer with a love for building data pipelines, data science and statistics.Anything related to data and numbers interests me. My focus is to constantly challenge myself and solve problems.

Work Experience

Change Healthcare
Hyderabad
July 2021 – Present
Senior Data Engineer
A healthcare technology company with a focus on calculating risk analytics of individuals for insurance companies in the US.
Highlights
  • Successfully upgraded their existing commerical health insurance line of business that was previously hosted on-premise to AWS. This is primarily being done so their operational costs reduce as well as they are able to scale faster. Used a combination of lambdas, step functions, sqs, sns, glue, athena to acheive this.
  • Optimised pipelines by 7 times, their initial processing times were around 3 weeks, which is now close to 3-4 days. This was done by rewriting most of the systems to support concurrency.
  • Improved accessibility to data that previously lived in one data mart, which now is structured into multiple data lakes. The read queries were quicker which contributed to the faster pipelines.
Principal Global Services
Hyderabad
October 2018 – July 2021
Senior Data Engineer/Application Developer
Principal Global Services is a global delivery center for Principal Financial Group which is a global financial investment management and insurance company.
Highlights
  • Benefit Event Prediction and Propensity Models - Automated prediction models to predict retirement and job change of a customer with Principal.This helped save 19 billion dollars for Principal.
  • Campaign Metrics - Creating an omni channel marketing dashboard using Power BI,Spark,Hive and Scala on AWS for measuring marketing performance measurement across various channels like web, social media, email, banners etc.Earlier marketing teams had to manually check for these metrices in different systems. This integration helped save 60 working hours each quarter.
  • Email Sentiment Analysis - Developed an application to analyse sentiments on emails between employers and Principal. This helped marketing teams to classify employer sentiments which helped employer retention with Principal.
  • Advisor Lead Scoring - Automated scoring logic for scoring advisors based of which Principal can take decisions on future engagements. With this Principal was able to increase the advisor network by 3 times.
  • Log Analysis and Storage Prediction - Built an application using ELK stack and Filebeat which predicts the disk space,query metrics,time and CPU usage. This helped the DBAs to flag resource crunches on time, helping avoid incidents in production.
  • Tech Connects - Conducted 22 sessions to train 60 people on the Cloud, Python and other data engineering concepts.
Vietnamobile Telecommunications Ltd - Onsite (Tech Mahindra)
Hanoi,Vietnam
November 2017 – October 2018
Big Data Developer
Vietnamobile is a vietnamese mobile network operator,My Team helped them build their data platform
Highlights
  • Acted as a hadoop designer - Designed solutions to address issues pertaining to marketing, finance and BI teams. Educated teams on big data technologies, Hadoop infrastructure maintenance, Hadoop operations and the ETL stack on Hadoop. Also designed hadoop integration with other tools like Splunk,R and Tableau.
  • Implemented designs for various types of billing reconciliation and provided solutions to build APIs for balance movement tracking, revenue and bonus reconciliations for finance teams. This helped the finance teams reconcile 3 times better.
  • Automated a new process to accommodate mobile number changes of the entire country as per government norms, using CDC in hadoop datalake. This design helped us to make changes to around 12 million subscribers in a week's time, without any impact.
Tech Mahindra Ltd.
Pune
January 2016 – October 2017
BI Developer/Big Data Developer
Tech Mahindra is a services firm that helps clients deliver software better and faster.
Highlights
  • Provided enterprise solutions to a leading telecom provider of Vietnam by creating a visualization environment to aid them in viewing network traffic, revenue trends,subscriber categorizations, RGS and ARPU reports for taking business decisions.
  • Built and deployed two Hadoop clusters using Hortonworks distribution.These clusters could help process around 1-2 TB of data daily.
  • Designed and implemented a datalake in Hadoop which helped analyse data from 10 different source systems like Single View, Voucher Management Systems, Campaign Management Systems and Siebel CRM systems(these systems are commonly used in the telecom domain).
  • Created transformation logics and implemented optimisations on Hive, sqoop, yarn to transform around 1-2TB of data per day. Also used various compression techniques and file formats like Snappy and Bzip to achieve this.
  • Worked for a leading aerospace company in Canada to analyse maintenance data determining the stability of the aircraft using ETL tools-Talend, MySQL. Data received from the aircraft operator was classified into various buckets which was used to train models to predict these attributes better.

Awards

  • Principal Global Services

    Ace Performer

  • Analytics Code Jam - Principal Global Services

    Winner

Contact

Education

  • 2011 2015

    Jawaharlal Nehru Technological University, Kakinada

    Bachelors Of Technology

    Electronics and Communication Engineering

  • 2009 2011

    St Agnes Convent, Kharagpur

    ISC - Std 12th

  • 1998 2009

    St Agnes Convent, Kharagpur

    ICSE - Std 10th

Skills

Programming
Scala Python SQL MySQL Unix Shell Scripting
Tools
Tableau Power BI Talend IBM Datastage Qlikview Denodo
Technologies
Spark Airflow HDFS Sqoop Pig Hive Oozie Yarn Flume Kafka Nifi Kerberos Druid
Devops
AWS Docker Terraform Bamboo Github Actions High Availability Cluster Administration
Domains
Healthcare Aerospace Finance Telecom Marketing
Software Delivery Practices
Agile Dojo SAFE