Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Shashank Kumar

Engineering Lead
Noida

Summary

Shashank has over 6 years of experience in ETL and Business Intelligence. Skilled in development and implementation of Data Warehousing and Business Intelligence solutions using Informatica , Microsoft SQL Server, Databricks, Oracle and ADF.

Overview

6
6
years of professional experience
4
4
years of post-secondary education
1
1
Certification

Work History

Engineering Lead

Persistent Systems
05.2023 - Current
  • Enhanced team productivity by implementing agile methodologies, fostering a culture of adaptability and continuous improvement in workplace.
  • Established strong relationships with vendors, negotiating favorable terms that contributed to cost savings and improved supply chain management.
  • Collaborated with stakeholders to gather requirements and develop tailored engineering solutions that met business needs.
  • Managed multiple projects concurrently, effectively prioritizing tasks to achieve successful outcomes within budget constraints.
  • Worked on multiple internal projects
  • Good experience in Azure databricks
  • Developed etl pipeline using ADF as per requirement
  • extracting data from source and storing it into sink using ADLS
  • Converted SQL store procedure into databricks notebooks

Lead Software Engineer

Persistent System inc
6 2022 - 04.2023
  • Creating pipelines in ADF for pushing data from Synapse
    to ODS.
  • Bringing data from salesforce to Synapse using ADF
  • Modify existing pipeline and depending on schedule
    requirement make it an independent pipeline by extracting
    and readjusting existing old pipelines to not disrupt existing production pipelines.
  • Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders
  • Mentored junior developers, fostering talent development and growth within the company.

Software Engineer

Mediaagility
08.2018 - 05.2022
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability
  • Create data model in BigQuery to support existing reporting requirements.
  • One time historical data load to Google Cloud
  • Worked on Data migration project for migrating data from On premise to AWS.
  • Design and development of Data Warehouse by establishing ETL processes to load Transaction data through SQL Server Integration Services (SSIS) packages, SQL stored procedures (SQL Server) and SQL Agent jobs on daily/weekly/monthly basis, based on requirements received from business users.
  • Proficient in designing and implementing integrated solutions consisting of audit control processes and error handling mechanisms with proven abilities in performance optimization.
  • Development of reports to track and audit data load processes while verifying correctness of data.

Education

B.E - Information Science

Dayananda Sagar College of Engineering
Bangalore
08.2014 - 06.2018

Skills

Technical analysis

Code reviews

New employee mentoring

Project Management

Problem-Solving

Data analysis

Teambuilding

Certification

AZ-900: Microsoft Azure Fundamentals

Timeline

Engineering Lead

Persistent Systems
05.2023 - Current

AZ-900: Microsoft Azure Fundamentals

02-2020

Software Engineer

Mediaagility
08.2018 - 05.2022

B.E - Information Science

Dayananda Sagar College of Engineering
08.2014 - 06.2018

Lead Software Engineer

Persistent System inc
6 2022 - 04.2023
Shashank KumarEngineering Lead