Shashank Singh Email & Phone Number

Hyderabad, In

Noida, Uttar Pradesh, India

PLC Direct:Extracted product data from eBay using the eBay API and Shopify using the Shopify API.Compared and modified product data based on business rules, ensuring accurate synchronization across platforms.Developed and deployed Python-based scripts on AWS EC2 instances for data extraction and transformation.Managed version control and pushed code updates from a Bitbucket repository, ensuring seamless deployment and code integration.Utilized API integration (PUT/POST) to update and synchronize data between Shopify and other systems.CookinGenie:Extracted data from Google Ads, Bing Ads, Google Analytics, and Postgres through APIs.Loaded extracted data into Clickhouse data lake using Airbyte for real-time data ingestion.Transformed and loaded data into Clickhouse warehouse using DBT (Data Build Tool) for efficient processing.Created a robust reporting layer from Clickhouse to support various business insights and data-driven decisions.Visualized key business insights using Apache Superset, catering to diverse stakeholder needs and improving reporting accuracy.Innago:Extracted and loaded data from MariaDB to Postgres for a real estate project using Airbyte, pgloader, and Python scripts.Performed data transformation using DBT and populated Postgres warehouse to optimize reporting and analysis.Developed a reporting layer to feed data into Power BI for visualization and reporting, enhancing real-time business intelligence.Researched and recommended data synchronization tools such as Apache NiFi for streamlining data processes across systems.

Noida, Uttar Pradesh, India

Developed interactive reports and dashboards in Power BI to track and measure key performance indicators (KPIs), providing actionable insights for decision-makers.Wrote complex SQL queries to extract, transform, and feed data into the reporting layer, ensuring accurate and efficient data retrieval for analysis.Worked closely with business stakeholders to understand reporting requirements and delivered tailored solutions to meet evolving needs.Automated and optimized data refresh schedules in Power BI, ensuring real-time data availability for KPIs and metrics.Collaborated with cross-functional teams to integrate data from various sources into the reporting pipeline, improving data accessibility and decision-making.