Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
Projects
Timeline
Generic

Saurabh Kanauji

Ghaziabad,UP

Summary

Highly skilled Business Intelligence Developer with over 5 years of experience specializing in ETL development, data analysis, and business intelligence reporting. Proficient in leveraging SQL Server Integration Services (SSIS) to design and maintain efficient ETL processes, and adept at using Power BI to create dynamic dashboards and reports that drive data-driven decision-making. Strong expertise in SQL for database management and optimization, with a proven track record of improving data processing efficiency and enhancing business insights.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Data Analyst with Power BI

Wipro technologies
12.2020 - Current
  • Utilized SQL Server Integration Services (SSIS) to design, implement, and maintain efficient ETL workflows, ensuring data integrity and accuracy across multiple data sources.
  • Created interactive and insightful dashboards and reports using Power BI, enabling stakeholders to make data-driven decisions.
  • Wrote complex SQL queries and optimized existing queries to enhance database performance, ensuring timely and accurate data retrieval.
  • Designed and implemented data models and integrated data from various sources to support business intelligence initiatives.
  • Worked closely with business analysts, data scientists, and other stakeholders to gather requirements and deliver customized BI solutions.
  • Identified, diagnosed, and resolved data-related issues, ensuring minimal disruption to business operations.
  • Documented ETL processes, data models, and BI solutions, and established best practices for data management and reporting.

Managed and Support Executive

Net4 Networks
09.2018 - 10.2020
  • Designed, created, and maintained relational databases and tables to support various business applications and data needs.
  • Created complex SQL queries using joins, subqueries, and set operations to extract meaningful insights from data.
  • Developed and maintained stored procedures, functions, and triggers to automate repetitive tasks and enhance database functionality.
  • Implemented data models and ensured database structures are optimized for performance and scalability.
  • Conducted regular database maintenance, including backups, indexing, and performance tuning.
  • Developed and optimized SQL queries to retrieve, manipulate, and analyze data as required by business processes and reporting needs.

Customer Support Executive

Karvy DigiKonnect
08.2016 - 05.2018

Worked as Backend Support executive for Shopclues process.

Customer Support Associate

Tech Mahindra
01.2016 - 06.2016

Worked as a Backend Support Executive for Paytm.

Customer Support Officer

Mphasis
04.2014 - 05.2015

Worked as a Customer Care Executive for Punjab National Bank Process.

Customer Support Associate

Tech Mahindra
03.2013 - 03.2014

Worked as a Customer Care Executive for Vodafone.

Education

MCA -

Indira Gandhi National Open University (IGNOU)
New Delhi, DL
01.2021

BCA -

Indira Gandhi National Open University (IGNOU)
New Delhi, DL
01.2017

12th -

Nehru Public School
Ghaziabad, UP
01.2007

10th -

Nehru Public School
Ghaziabad, UP
01.2005

Skills

  • ETL
  • SSAS
  • SSRS
  • SSIS
  • Power BI
  • GIT
  • DNS Server
  • IIS Server
  • HTML
  • CSS
  • SQL
  • Linux
  • Azure Sql
  • Devops

Certification

  • O Level from DOEACC
  • A Level from NIELIT(earlier DOEACC)

Languages

English
Hindi

Projects

  • Power BI project on Vehicles Report
  • Power BI project on Car Sales
  • Power BI project on Sales report
  • Power BI project on State wise Sales report
  • Power BI project on product sales
  • SQL Project on Fasoos
  • Database Management System Project on Hospital Management System
  • SQL project on Zomato
  • DBMS project on Blood Bank Management System

Timeline

Data Analyst with Power BI

Wipro technologies
12.2020 - Current

Managed and Support Executive

Net4 Networks
09.2018 - 10.2020

Customer Support Executive

Karvy DigiKonnect
08.2016 - 05.2018

Customer Support Associate

Tech Mahindra
01.2016 - 06.2016

Customer Support Officer

Mphasis
04.2014 - 05.2015

Customer Support Associate

Tech Mahindra
03.2013 - 03.2014

MCA -

Indira Gandhi National Open University (IGNOU)

BCA -

Indira Gandhi National Open University (IGNOU)

12th -

Nehru Public School

10th -

Nehru Public School
Saurabh Kanauji