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 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 Sisense BI tool after unifying the data across different data sources using deterministic ID Unification Algo and then shows the result in unified customer view (C360 view). • 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 time dashboards on top of this using python plotly lib.• Pulled the third party API data using python and transformed as per business need and then ingest data into Plazma DB and do the analytics using Presto SQL or Hive query engine. Show less

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 • 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 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 response and store the same to RDS (MYSQL).• Created the new routine endpoints in flask app and tested using CURL input command. • Fetched and processed the data from MYSQL/Snowflake databases using python.• Comfortable in writing functions in Shell script. • Used Jira, Git tool to get the task and maintain the code.and created CICD pipeline.• Worked on Agile model.• Worked on various services of AWS like S3, EC2, RDS, Redshift, Route 53, EBS and Kinesis etc. Show less

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 • 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 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.• Written the business logic in SQL and publish the report in excel/csv/text files via email.• Enhancing the existing SQL scripts, SQL jobs and SQL Jobs creation. Migration of SQL Jobs from one server to another.• Worked on linked servers to communicate between same or different databases from SQL Server.• Issue troubleshooting including technical, data and system process related.• Monitor and suggest performance improvements in process.• Worked as a python developer and created whole module on python side includes connections to multiple databases by using factory method and then build dynamic SQL queries to fetch and process the data using multiple python libraries (e.g. pyodbc, pandas, petl, pyexcelerate etc.).• Fetched and processed the data from MSSQL/Oracle/Vertica databases using python.• Worked on JIRA and Stash/GIT tool to maintain the code versioning and Worked on agile methodology. Show less

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 • 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 were used for making current and future business decisions.• Developed Drill-through reports, parameterised reports, Tabular reports and Matrix reports using SSRS.• Used table variables and Common Table Expressions (CTEs).• Extract Transform Load(ETL) development Using SQL server 2008, Integration Services(SSIS). Show less