Indresh Kumar Email & Phone Number

Noida, Uttar Pradesh, India

Noida, Uttar Pradesh, India

• Build end to end data pipeline orchestration using digdag. Also setup the CI-CD pipeline using github actions which avoids the manual code deployment.
• Build the Time-Decay, W-Model Multi-Touch Attribution Model in SQL which increases the targeting of right customers which leads to increase in sale.
• Comfortable in writing the complex SQL queries as per business need.
• Build the Attribution dashboards to analyse the attribution result. Also build ID resolution dashboards using… Show more
• Build the Attribution dashboards to analyse the attribution result. Also build ID resolution dashboards using Sisense BI tool after unifying the data across different data sources using deterministic ID Unification.
• Ingested the data from heterogeneous source like JSON, flat-files, Facebook, Google, YouTube and Instagram to Plazma DB(No SQL) and performed the data profiling to get the insights of data quality. Created the real.

Noida Area, India

• Created ETL pipelines end to end of tasks to serve the client requirements like importing the data from Amazon S3 to Snowflake vice versa using Airflow tool.
• Loading and unloading the data to S3 buckets using Airflow and shell script from Snowflake, RDS (MYSQL) and Google Could.
• Migrated the data from Snowflake to Google Big Query.
• Build automation tool in python to monitor the newly and exiting process and suggested performance improvements in process.
• Worked on… Show more
• Worked on Python Flask and created an app (deployed AWS Elastic Beanstalk) which used to create/edit/delete the segments in/from Appnexus, Google DBM, Mediamath, TTD and Adobe source using REST API, collect the API.

Noida Area, India

• Converted the sequential process to support the parallelism, which increased performance of process by 80% which helps the customer to get reports in near real-time.
• Optimised 40% of SQL code by removing the redundant code.
• Created the python based tool called DTO (Data-Tie-Out) which helps to compare and process the large data according to the business requirements in optimised way.
• Worked on automating and improving the reporting process of existing system and publish the… Show more
• Worked on automating and improving the reporting process of existing system and publish the real time reports to vendors/retailers.
• Worked in application development to write complex Store Procedures, functions, Cursors and Triggers and logic in database to serve the client requirements.

Noida, Uttar Pradesh, India

• Database Design, Proficient in implementing business logic using the T-SQL Stored Procedures/Functions/Triggers/Jobs.
• Perform Unit Testing of Application, review of Test Cases.
• Migrating data from Excel/Flat Files/CSV/MDB/Back Ups/MS Access to SQL Server 2005/2008/2012 using SSIS packages and TSQL Scripts.
• Reviewing and Creating the SSIS packages, fixing the defects in existing packages.
• Responsible for team handling, code review.
• Developed parameterised reports which… Show more