Chalapathi Rao

Summary
Designed and implemented a centralized data platform to support long-term analytical reporting, historical trend analysis, and enterprise-wide business insights. The system operates alongside an Investment Hub, forming a two-tier architecture that separates operational workloads from analytical processing.

Led the design and implementation of the Analytics Hub as a scalable, high-performance data warehouse.

Developed ETL pipelines to archive data periodically from the Investment Hub using incremental loads and Change Data Capture (CDC).

Created and maintained dimension and fact tables following data warehousing best practices.

Implemented support for Slowly Changing Dimensions (SCD Type 2) to preserve historical data changes.

Ensured data accuracy and performance optimization through indexing, partitioning, and tuning.

• Developed and maintained assets using DealCloud and Everest applications, ensuring accurate data management.
• Implemented daily checklists to track the completion of Aladdin Data and SQL reports.
• Actively resolved queries during the Live period, contributing to day-to-day operations.
• Cleared Data reports (EOD DIG Checks, Credit Data QC checks) to eliminate discrepancies with Aladdin data.
• Maintained dashboards with zero discrepancies, ensuring accurate reporting.
• Addressed CML, RML, and Efront failures promptly and prioritized them effectively.
• Resolved business queries in the PDM inbox to minimize impact on trades.
• Updated ratings manually in the Aladdin Sec Master and managed issues between Aspen and Aladdin.
• Created research entities in Aspen.
• Able to quickly learn new concepts and technologies.

Technologies:

Azure Data Factory, Azure SQL Database, Blob, ADLS Gen1 &Gen2,
Azure logic apps .

Summary:

Azure ADF data migration projects from On-Premise to Cloud.
 Worked in different applications with both development, support and production
project activities.
 Migrated data from Client data scope to Blob Storage and from Blob to Azure Data Lake
Gen2 and from ADLS Gen2 to Azure SQL server
 Migrated data from third party URL to blob using logic apps.
 Connected to SharePoint and placed file onto BLOB using Logic Apps.
 Worked on Parquet datafiles, json data files, XML datafiles and csv datafiles.
 Loaded Parquet data files into ADLS Gen2.
 Loaded json Datafiles into Cosmos DB.
 Fetching xml data files from client API to ADLS Gen2.
 Using Logic Apps have updated details in SQL server and triggered the notifications
through email.
 To copy data from BLOB to ADLS and from ADLS to ADLS using Azure Data factory.
 To pull data using API connection and send to BLOB storage.
 Monitoring and reporting Client data scopes on a daily basis, which consists of different
companies’ payment info to client.