profile-pic

Shiv Kumar Agrawal

Results-driven IT professional with expertise in SQL, Python, and ADF, specializing in data management and ETL processes. Proficient in using SSIS and Pandas to optimize data workflows and boost analytical performance. Skilled in designing efficient database solutions, ensuring data integrity, security, and performance optimization. Strong problem-solving abilities and a focus on delivering high-quality results in dynamic, fast-paced environments.
  • Role

    Elasticsearch Data Engineer

  • Years of Experience

    3.00 years

Skillsets

  • Microsoft SQL - 3 Years

Professional Summary

3.00Years
  • Jul, 2022 - Present3 yr 4 months

    Software Engineer

    Kantar-Firefly
  • Jan, 2022 - Jul, 2022 6 months

    Analyst Trainee

    Cognizant

Applications & Tools Known

  • icon-tool

    VS Code

  • icon-tool

    SSMS

  • icon-tool

    MySQL

  • icon-tool

    ADLS

  • icon-tool

    Azure Databricks

  • icon-tool

    MS Excel

  • icon-tool

    MS PowerPoint

Work History

3.00Years

Software Engineer

Kantar-Firefly
Jul, 2022 - Present3 yr 4 months
    Developed and implemented Python-based automation scripts that streamlined workflows, significantly decreasing manual effort and improving overall task accuracy and processing speed. Architected and developed complex SQL queries, Stored Procedures, and Views to drive precise business logic, enabling efficient data manipulation and extraction to support key business operations. Engineered and refined database schemas for MSSQL and MySQL, achieving a 30% improvement in query performance through schema optimization and indexing strategies. Designed and deployed end-to-end data automation solutions using SSIS packages and Azure Data Pipelines, streamlining data processing, import/export workflows, and automating routine tasks by scheduling jobs in SQL Server Agent. Leveraged Python automation scripts to enhance project workflows, boosting overall operational efficiency by 40%. Collaborated closely with cross-functional teams in Agile and Scrum environments, actively participating in sprint planning, daily stand-ups, and requirements gathering to ensure timely and successful project delivery.

Analyst Trainee

Cognizant
Jan, 2022 - Jul, 2022 6 months
    Crafted and optimized SQL queries, Stored Procedures, and Function Views for robust data analysis, delivering tailored solutions that met client-specific needs and business objectives. Collaborated extensively with cross-functional teams in Agile settings, engaging in sprint planning, daily stand-ups, and requirements definition to drive smooth project execution and timely delivery.

Achievements

  • Recognized with Kantar Sirius Award (2023) for exceptional performance as an Individual contributor, showcasing strong problem-solving skills, work ethics, and initiative in resolving complex business challenges, resulting in significant organizational impact.
  • Automated the Crosstab Accelerator project by integrating Python and Elasticsearch, reducing process execution time by 40% and streamlining data retrieval and analysis.

Education

  • Bachelor of Technology

    Chandigarh University, Mohali (2022)