Handling migration of columnar database with 10000+ columns (database used to manage multi trillion-dollar investments)Responsible for Client collaboration, Requirement Analysis, Project documentation, Requirement elicitation and defining Success criteria.Data Analysis: Splunk data analytics for data analysis, comparison and content breaks RCA. Data Standardisation: Computing and standardizing the data logics from as-is system table structures/Enterprise relationship diagram to to-be system tables and columns written in go and supported by go Kafka,Work across functional teams and senior stakeholders, mentor and coach other business analysts.Work with Product Management to understand requirements and translate into work items.UAT Testing: Defining the ETL data pipelines flow (extract to load flow with upstream downstream sources) from as -is state to to-be state and migrate/document the same. Established experience with Git, Continuous Integration and Continuous Delivery (CI/CD). Work on Application Development of Analytics Engine- feature addition using the Go-Language (IDE- Go Land) & SQL.Developed and implemented data pipelines using Azure Data Factory resulting in a 50% reduction in processing time. Collaborated with cross-functional teams to design and implement scalable data architectures. Implemented data governance policies resulting in a 30% reduction in data quality issues.Collaborated with Analytics and BI teams to develop globally adopted metrics and reporting-on-demand solutions, reducing manual data analysis by over 50%.Developed and maintained stored procedures, views, and functions in SQL server to optimize data extract, transform and load (ETL) processes by 35%Generated, maintained and analyzed Azure monitoring dashboards, reports, and trends, minimizing customer pain points by 20%.Cleaned and transformed data using Power BIs Query Editor to prepare ETL processes to optimize reporting datasets.