Shashank Singh

CookinGenie: Extracted, transformed, and loaded (ETL) data from Google Ads, Bing Ads, Google Analytics, and Postgres into Clickhouse data lake using Airbyte. Developed and maintained DBT data models and pipelines, optimizing data flows to data warehouse for efficient reporting and business insights. Innago: Migrated and synchronized data from MariaDB to Postgres using Airbyte, pgloader, and Python. Applied DBT transformations to ensure accurate data loading and streamlined data access for PowerBI-based visualizations and reports. PLC Direct: Integrated product data from eBay and Shopify APIs using Python scripts on AWS EC. Automated data extraction, transformation, and real-time synchronization across platforms using API integrations (PUT/POST). Managed version control and deployment with Bitbucket for seamless integration. Daylight: Extracted data from Jira, Bitbucket, Microsoft, and Keka and ingested it into PostgreSQL. Implemented DBT transformations to process and structure data in the warehouse, ensuring it was optimized and application-ready.

Developed interactive and dynamic Power BI reports and dashboards to track KPIs, providing actionable insights for business stakeholders to support decision-making. Wrote complex SQL queries to transform and load data from various sources into the reporting layer, ensuring data accuracy and reliability. Collaborated closely with business stakeholders to understand reporting requirements and deliver tailored solutions, enhancing data accessibility and decision-making.