Amit Singh Email & Phone Number

Noida, Uttar Pradesh, India

Manila, National Capital Region, Philippines

• Wrote a script for integrating Facebook Ads costing. Fetched various metrics for Facebook Ads using the API in Python, then cleaned the data and pushed it to the warehouse on BigQuery.
• Created an automation process for various scripts. Wrote scripts to fetch data from various sources such as POS, etc., and automated them on the main server using Windows Task Scheduler.
• Built dashboards for various stakeholders across the teams to help them overcome their data needs.
• Worked on ad-hoc requests. Worked closely with the CRM team to provide them with their daily data requests for targeting customers in various campaigns and creating flows and campaigns over Moengage.
• Worked on scrapper scripts to fetch the prices of competitor websites to match and provide better prices to our customers.

• Built the Dashboard for the highly anticipated Sleep Internship Dashboard. Fetched data from the backend, cleaned the data, and created the dashboard for various analysis purposes.
• Created a Data Mart from an AWS S3 dump. Worked with the AWS S3 data dump from Moengage and built the dashboard from it.
• Developed an automation script. Created an automated script to provide daily updates to various stakeholders, utilizing Crontab for automation.
• Provided insightful information and handled ad-hoc requests. Built dashboards and created, optimized SQL queries for internal stakeholders to meet their requirements.
• Worked on various automation processes using Apache Airflow and updated various scripts in a modular format, maintaining them in the BitBucket Repository.

• Built a dashboard for Return and Replacement Orders using Tableau. Retrieved the data from the database, cleaned it in Python using Pandas, and established a pipeline to upload the data to AWS.
• Developed an RFM model. Retrieved data from the database, constructed a clustering model to group customers, created a table to capture customer behaviour, established a pipeline to transfer the table to AWS Redshift.

Noida, India

New Delhi, Delhi, India