Learn Data Skills
Beta
Shashank Vats

Shashank Vats

Certified

Business Intelligence Developer

University College Cork | Cork, Ireland

Technologies

My Portfolio Highlights

My New Track

Power BI Fundamentals

My New Course

Introduction to Python

Quantitative wordsmith, translating complex concepts into elegant equations.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to R

course

Introduction to Python

My Certifications

These are the industry credentials that I’ve earned.

Data Literacy

Data Literacy

AI Fundamentals

AI Fundamentals

Other Certificates

Microsoft Microsoft Certified: Azure Fundamentals

Alteryx Alteryx Designer Core Certification

Microsoft Microsoft Certified: Azure Data Engineer Associate

Microsoft Microsoft Certified: Power BI Data Analyst Associate

Microsoft Microsoft Certified: Azure Data Fundamentals

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Tata Consultancy Services | Sep 2020 - Aug 2022

Role: Business Intelligence Developer, Position: System Engineer

● Designed new pipeline architecture in Azure Cloud to transition the current on-premise system to the cloud, reducing expenses by 20% and increasing on-premise performance by 10%. ● Designed and built 17 new data factory pipelines and data warehouse tables in Azure Synapse Analytics for cloud migration. ● Conducted POC on Alteryx for self-service reports and integration with the current data platform, also built multiple workflows for the HR team, saving 15 hours of manual repetitive work each week. ● Deployed Data Lake storage system in Azure, helping data scientists with clean data, increasing productivity by 15%. ● Building Power BI reports and dashboards for daily sales reports with row-level security. Also building datasets to be used in self-service reports.
Show More

Tata Consultancy Services | Sep 2019 - Sep 2020

Business Intelligence Developer, Position: Assistant System Engineer

● Built new and modified existing ETL pipelines, UNIX shell scripts, and database tables for the addition of a new DC (Distribution Center) in the organization, increasing revenue by 15% annually. ● Addressed client’s business needs and converted those needs into actionable reports in OBIEE which took 5 hours of manual work each week. ● Developed a new system in ETL for the calculation of employee productivity at DC (Distribution Center) and also created reports based on DC, team, and employee level to help the business in weekly bonus payment, reducing around 250,000 euros per month in expense. ● Building and deploying Power BI reports and dashboards as per client’s request. Rebuilding OBIEE reports in Power BI for migration from on-premise to cloud.

Tata Consultancy Services | Sep 2018 - Sep 2019

Role: Business Intelligence Developer - Junior, Position: Assistant System Engineer - Trainee

● Built 15 SCD type-2 ETL pipelines in Informatica PowerCenter and 20 tables in SQL Developer to better maintain change historical data resulting in the creation of new detailed historic reports. ● Conducted the POC on Zephyr Plugin for digitizing test cases and results and implemented it in Jira for better tracking and managing test cases, reducing manual work done in Excel. ● Learned about the agile process and the development of new functional and performance testing skills.

DS Group | Nov 2016 - Dec 2016

Intern

● Developed a project ‘Customer Complaint Resolution’ built on ASP.Net which helped in managing, and monitoring complaints filed by customers. ● Learned and implemented Oracle 12c for the database, ASP.NET for web development, and C# for backend coding. ● Implemented Bootstrap and JavaScript to make the website dynamic and user-friendly.

My Education

Take a look at my formal education

Master in Science in Data Science and AnalyticsUniversity College Cork | 2023
Bachelor of Technology in Computer Science and EngineeringSRM University | 2018

About Me

Shashank Vats

System Engineer with 3 years of experience as a Business Intelligence Developer in Retail. Well-acquainted with Python, SQL, Data Structure, Database & Data Warehouse, ETL Pipelines, Data Modelling and Reporting.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free