Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

Shivanshu Agrawal

Ahmedabad

Summary

Engineer with 2 years of experience in Data Visualization, Programming, Automation and end to end solution towards business requirement. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

2
2
years of professional experience
1
1
Certification

Work History

QA Automation Engineer

Einfochips
03.2022 - Current
  • Write, design, and execute automated tests by creating scripts that run testing functions automatically.
  • Maximize test coverage for the most critical features of the system
  • Determine the priority for test scenarios and create execution plans to implement these scenarios.
  • Write documentation for automated processes including test plans, test procedures, and test cases.
  • Build test automation frameworks.
  • Log and document bugs in the tracking system.
  • Set up Continuous Integration using Jenkins
  • Advised developers on problems with databases, performance and other issues.
  • Maintained high-quality standards with regular code reviews, identifying potential risks and areas for improvement.
  • Developed custom test tools to support unique project requirements, facilitating accurate evaluation of complex systems.
  • Implemented data-driven testing approaches for more efficient and accurate validation of application functionality.
  • Reduced manual testing time through the implementation of robust automation frameworks, optimizing resource utilization.
  • Resolved problems, improved operations and provided exceptional service.

Data Analyst

Einfochips
03.2022 - Current
  • Created analytical reports and provided valuable and relevant business insights for internal and external clients.
  • Created and modeled datasets from SQL Server, Azure Data Lake, Excel, CSV, JSON, and other sources.
  • Cleaned and transformed data using Power BIs Query Editor to prepare ETL processes to optimize reporting datasets.
  • Created data models, tables within Power BI to support efficient, optimized data warehousing and reporting workflows.
  • Built Measures and Calculated columns using DAX.
  • Implemented row-level security in Power BI workspaces depending on the type of access required.
  • Experienced with Power BI Incremental refresh.
  • Provided technical or functional guidance to project or work teams.
  • Collaborated on an on-going basis with the Business Systems Analyst.

Education

Bachelor of Technology, India - Electronics And Communications Engineering

Indus University
Ahmedabad
05.2017

Skills

  • Power Bi
  • SQL
  • Python
  • Pytest
  • Selenium
  • Appium
  • API Testing and API Data extraction
  • Azure Data Factory
  • Azure Data Bricks
  • Pyspark
  • C#
  • Data Visualization
  • Advanced Excel
  • Data Driven
  • Data Extraction

Accomplishments

  • Awarded and Appreciated by client for creating an end-to-end Flow by Automating an application and further extracting the data to Power bi to get most important insight for regular tracking.
  • Awarded for creating a most complex finance power bi dashboard with dynamic role-level security.
  • Awarded for creating a sustainability dashboard that really helped my company with important insights.


Certification

  • Microsoft PL-300
  • Udemy DAX, Python, Power Bi and SQL certifications

Timeline

QA Automation Engineer

Einfochips
03.2022 - Current

Data Analyst

Einfochips
03.2022 - Current

Bachelor of Technology, India - Electronics And Communications Engineering

Indus University

Similar Profiles

CREATE PROFILE
Shivanshu Agrawal