Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Timeline
Generic

Shilpi Rani

Big Data Engineer(AVP) in Citibank
PUNE

Summary

Seasoned Data Engineer with over 15 years of experience, including 6+ years in fintech and investment banking, and prior exposure to the telecom domain. Proven expertise in building scalable Big Data solutions, real-time data processing pipelines, and ETL frameworks using Python, PySpark, Hadoop, Hive, HBase, and Kafka. Skilled in data lake architecture, streaming analytics, and machine learning pipeline integration for use cases such as fraud detection, trade surveillance, and regulatory reporting. Adept at handling large-scale structured and unstructured data, optimizing query performance, and ensuring data quality, lineage, and compliance across enterprise systems. Experienced in Agile/Scrum methodologies and a Certified Scrum Master (CSM) with strong focus on cross-functional collaboration and delivery excellence.

Overview

2026
2026
years of professional experience
1
1
Certification

Work History

AVP (Big Data & ML)

Citibank
02.2022 - Current

Working as a Data Engineer in the Equity Division, delivering scalable Big Data and Machine Learning solutions for fraud detection and trade surveillance.

  • Built and optimized data pipelines using PySpark, Hadoop (HDFS, Hive), and Airflow for large-scale trade data processing.
  • Developed anomaly detection models in Python using Scikit-learn and TensorFlow, improving fraud detection accuracy.
  • Integrated Kafka for real-time event streaming and alerting in surveillance systems.
  • Ensured regulatory compliance (SEC/FINRA) through proper data governance, logging, and audit-ready documentation.
  • Improved ETL performance via Spark tuning and advanced partitioning strategies.
  • Collaborated with compliance and quant teams to deploy AI/ML workflows at scale.

Data Engineer

IBM
1 2018 - 02.2022
  • Led data migration and standardization efforts in telecom, integrating large datasets into enterprise systems.
  • Improved data quality via cleansing and preprocessing using Python, PySpark, and Pandas.
  • Collaborated on ETL pipeline development and maintenance, ensuring data integrity and stability.
  • Drove process improvements through automation and analytics innovation.
  • Defined and communicated global data requirements for scalable solution design.
  • Delivered descriptive and predictive analytics, leveraging machine learning models for insight generation.

1. Cognitive Digital Intelligence
Digitized B2B financial documents (PDF, invoices) using OCR, Python, and machine learning. Implemented anomaly detection using Random Forest models.

Tech Stack: Python, ML, OCR, Shell Scripting, PDF parsing, Random Forest

2. CNEM – Customer Network Experience Management
Analyzed telecom complaints (call drops, speed issues) using PySpark, Hive, HBase, and PhoenixDB. Delivered actionable insights to network engineers to resolve cell-level issues.

Tech Stack: Python, PySpark, Hive, HBase, PhoenixDB, MySQL, Flask, Shell Scripting

System Adivisory Consultant

IBM
01.2014 - 01.2018
  • Gathered and analyzed Business and Functional Requirements (BRS/FRS) across EPC, CRM, and Telecom domains
  • Assessed technical feasibility and performed impact analysis on enterprise applications
  • Authored FRS documents and conducted walkthroughs with solution architects and business stakeholders
  • Delivered quality-assured solutions in Agile, Waterfall, and OneBox environments
  • Served as Certified Scrum Master (CSM), facilitating sprint planning, reviews, and retrospectives
  • Acted as an SME for Vodafone Billing Transformation (BSCS 6.0 to Amdocs 7.5) and CRM migration (Oracle Apps to Siebel).
  • Designed scalable technical architectures and contributed to solutioning, estimations, and proposal development
  • Coordinated cross-functional teams to deliver internal projects, ensuring business efficiency and stakeholder alignment

Software Engineer

Outworx ,Infogain
11.2011 - 06.2015

Project: Vodafone Essar – Oracle CRM and Amdocs Transformation (AMS Support and Rollout)

  • Acted as SME for Oracle CRM 11.5.10, handling analysis, design, and feasibility assessments for change requests
  • Led migration projects including billing migration, CRM migration, and MSG (Micro Subscription Gateway) migration
  • Developed PL/SQL interfaces, packages, and Oracle Forms; created reports using XML Publisher
  • Managed onsite production rollouts across 23 telecom circles during BSCS to Amdocs transformation
  • Created Detail Design Documents (DDD), Application Interface Documents (AIDs), and integration specs for external systems
  • Estimated project scope, mapped business requirements to technical solutions, and delegated tasks to the team
  • Reviewed project deliverables, managed risks, and resolved complex technical issues
  • Ensured smooth deployment and post-rollout support through structured planning and coordination

System Analyst in Operation

IBM
10.2008 - 11.2011

Project: Vodafone CRM Operations – Application Support

  • Managed Oracle CRM operations and ensured SLA adherence for Remedy tickets
  • Provided technical solutions for functional issues and supported UAT with test plans
  • Coordinated with Change Management, Incident Management, and Problem Management teams
  • Created standard operating procedures for CRM modules including Workflow, Metadata, TCA Upload, and Concurrent Programs
  • Implemented performance improvement strategies to enhance operational efficiency
  • Maintained inventory accuracy and supported production in a fast-paced environment

Education

B.E - Engineering

Nagpur University
07-2008

Skills

Apache Hadoop

Apache Spark / PySpark

Data Engineering

Machine Learning (ML)

Hive / HBase / PhoenixDB

Big Data Analytics

SQL / PL/SQL Development

Agile and Scrum Methodologies (CSM Certified)

Java and Shell Scripting

Certification

Certification Scrum Alliance CSM Certified.

Personal Information

Timeline

AVP (Big Data & ML)

Citibank
02.2022 - Current

System Adivisory Consultant

IBM
01.2014 - 01.2018

Software Engineer

Outworx ,Infogain
11.2011 - 06.2015

System Analyst in Operation

IBM
10.2008 - 11.2011

Data Engineer

IBM
1 2018 - 02.2022

B.E - Engineering

Nagpur University
Shilpi RaniBig Data Engineer(AVP) in Citibank