Laxman Dixit

• Designed SQL queries based on beverage company's business requirements.
• Developed and designed Power BI dashboard showcasing diverse graphs for the category team.
• Engineered GCP Cloud Functions to retrieve data from PostgreSQL database and Cloud Storage, seamlessly populating values into BigQuery

We hosted the asset and trading management application on AWS, leveraging Kafka and Dremio for optimized data pipelines, while utilizing PostgreSQL for seamless analysis and decision-making.

• Deployed and managed Java Spring Boot applications on AWS EC2, ensuring high availability and scalability.
• Utilized Airflow's DAG concept to initiate Dremio reflection via Airflow by creating dependency among the VDS based on upstream and downstream graph
• Created VDS,CTAS on source datasets and modified existing VDS as per requirements.
• Worked with spark data frames.
  

TSD provided a unified view of WMC Trading Desks, including KRI reports and real-time alerts for Trading Supervisors, allowing historical comment logging, trend analysis, and report generation.

• Worked closely with Business Analysts in the team to clarify business doubts on the various alerts logic created in TSD
• Modified existing alerts based on business requirements
• Worked on exposing new TSD datasets in Dremio and also worked on minor AWS infrastructure changes and defects in the application.