Avirbhav Singh
Gurugram
Summary
Passionate Business Intelligence Engineer with a strong background in data mining, database management, and report development using SQL, AWS, and Tableau. Skilled in solving business problems, project management, and communication, with a meticulous and methodical approach.
Overview
3
3
years of professional experience
3
3
Certificate
Work History
Software Engineer
SHL
Gurugram
06.2023 - Current
- Managed end-to-end client requirement development, encompassing ETL setup, report creation, and Tableau dashboard building. Oversaw Tableau Server management, user administration, content organization, permissions, and issue troubleshooting as a Tableau Admin.
- Leading the migration project for a Global Financial Services client, transitioning their dashboards to Tableau, crafting dynamic dashboards for their hiring programs, and backend migration to a new data warehouse.
- Developed and maintained data pipelines to ingest, store, process, and analyze large datasets in AWS S3 buckets.
- Developed Python or Bash scripts to automate routine AWS Cloud operations tasks.
- Created custom views, charts, graphs, filters, parameters, and data sources to meet specific user requirements.
Associate Software Engineer (Business Intelligence)
SHL
10.2021 - 05.2023
- Extracting data from various sources and constructing/executing complex analyses to finally come up with data or reports that help solve the business problem, partnering with Account Owners and Product Owners globally.
- Analyzed business requirements and translated them into logical data models.
- Optimized query performance by creating indexes and materialized views in Amazon Redshift clusters.
- Managed Data Lake architecture based on Apache Parquet files stored in S3 buckets and queried via Athena.
Project Intern
CSIR-Central Scientific Instruments Organisation
06.2019 - 07.2019
- Worked on the project Prosthetic Gloves which caters to the needs of peripheral neuropathy patients
- Later the research work done in our this project got published in Elsevier journal.
Education
B.E., Electrical and Electronics Engineering -
08-2021
Skills
- SQL
- Tableau
- Microsoft SQL Server
- AWS Services (Amazon Redshift, Amazon Glue, Amazon Athena, Amazon S3)
- Business Intelligence
- Data Migration
- Data Analysis
- Data Modeling
- Procedure Development
- Data Warehousing
- Agile Methodology
Certification
- Kalam Program for IP Literacy and Awareness - MINISTRY OF EDUCATION, GOVERNMENT OF INDIA
- Advanced SQL for Analytics - Udemy
- Tableau Server Administration - Udemy
- Programming for Everybody (Getting Started with Python) - Coursera
Languages
Hindi
First Language
English
Proficient (C2)
C2
Accomplishments
- SHL Engineering Excellence Award
- Budding Technologist by SHL
- Sprint Champion - 120 and 122 by SHL
Publications
Design and Fabrication of Prosthetic Gloves, 05/26/20
Projects
Prosthetic Gloves, 2019-2020, The design and fabrication of cost-effective prosthetic glove prototype for hand rehabilitation. Three different design prototypes are modelled and analysed. The unique design feature of selected prototype is its half ring servomotor operated design which is easily adjustable with varying dimensions of patient fingers. In future, this device will be integrated with force sensitive resistors and controllers which need to be clinically tested on physiotherapy patients for different disability levels.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Software Engineer - SHL
06.2023 - Current
Associate Software Engineer (Business Intelligence) - SHL
10.2021 - 05.2023
Project Intern - CSIR-Central Scientific Instruments Organisation
06.2019 - 07.2019
- Kalam Program for IP Literacy and Awareness - MINISTRY OF EDUCATION, GOVERNMENT OF INDIA
- Advanced SQL for Analytics - Udemy
- Tableau Server Administration - Udemy
- Programming for Everybody (Getting Started with Python) - Coursera
Panjab University - B.E., Electrical and Electronics Engineering,
Similar Profiles
Terry KuoTerry Kuo
Quality Engineer at SHLQuality Engineer at SHL
Animesh AdhikaryAnimesh Adhikary
Executive at SHLExecutive at SHL
Ayushi Kapoor PMP®Ayushi Kapoor PMP®
Quality Assurance Specialist at SHLQuality Assurance Specialist at SHL