Ranjit Kumar Panuganti
Azure Databricks Architect @Smbc Nikko Securities America, Inc
Signup · Get unlimited contacts
WORK HISTORY
Azure Databricks Architect @Smbc Nikko Securities America, Inc
Manhattan, NY, US
Market Surveillance & Trading Reports• Architected and delivered a cloud‑native Azure Databricks platform for market surveillance and trading analytics, supporting large‑scale ingestion, transformation, and reporting of high‑volume trade, order, and market‑data feeds.• Bring around 10 trading platforms data like Bloomberg, Markit, ION, Wells Fargo, Tradeweb, Market Axess, R8Fin and some more to legacy systems. On board new venues to the existing process and delivery to downstream Teams.• Migrated legacy Python‑based pipelines to a modern Databricks PySpark framework, improving scalability, performance, and maintainability while reducing operational overhead.• Built robust PySpark pipelines for real‑time and batch surveillance, covering insider trading, spoofing, layering, Amended Trades and other market‑abuse detection scenarios.• Delivered regulatory and compliance reporting solutions including After‑Hours Rates, Credit Reporting, and Cancel & Amendments Reporting ensuring accuracy, auditability, Bucketing amendments, Cancels at Trader Level, Desk level and alignment with regulatory standards.• Report Writer Migration – Multi‑Layered Framework• Led the migration of a complex Report Writer system to Azure Databricks, implementing a modular, class‑driven architecture with clearly defined processing layers:• Handler Layer, Enrichment Layer, Post‑Enrichment Layer, Filtering Layer, Normalization Layer, Aggregation Layer, Summary Layer, Persistence Layer.• Refactored and implemented hundreds of reusable methods and classes, improving code modularity, testability, and long‑term maintainability across multiple reporting domains.• Performance, Governance & Best Practices,Tuned Spark clusters, caching strategies, partitioning, and job parallelization to significantly reduce processing time for daily and intraday trading reports.
EDUCATION
Velagapudi Ramakrishna Siddhartha Engineering College
B.TECH, Electronics and Communication
ABOUT RANJIT KUMAR PANUGANTI
As a Lead Data Engineer and Principal Databricks Consultant at SMBC Group, Wells Fargo I leverage my 19+ years of experience in data warehousing applications to design and develop ETL integration patterns using Azure Data Factory, Databricks, Delta Lake, Pyspark, Power BI, Snowflake, Datastage, Tableau, Collibra. I have extensive experience with various ETL tools such as IBM Infosphere/Websphere DataStage, ADF, Databricks, Pyspark, Snowflake, Matillion, Tableau and DBT. I also have expertise in Python scripts and analytics on different files.In addition to my technical skills, I have strong leadership abilities, having managed a team of 14 ETL developers and support persons, Tableau resources, and Business Analysts. I have also led a group of technical resources and onboarded 9 applications both in support area and development. I am passionate about delivering high-quality solutions that meet the needs of our clients and stakeholders. I hold certifications in Developing Microsoft Azure Solutions and Microsoft Certified: Azure Data Engineer Associate.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.