Gabor

Languages

Python, SQL, PL/SQL

Paradigms

Data Visualization

Platforms

Microstrategy, Tableau, AWS Quicksight, S3, Athena, Redshift, Spectrum

Framework

Amazon Web Services(AWS)

Storage

Redshift, PostgreSQL, Hive, Google BigQuery, SQL Server, MySQL

Industry Expertise

Music, e-Commerce - Automobile

BI Practice Head

Agilisium                                          

May 2022 – Current                                

‍Project 1

Role : BI Practice Head

Period : From May 2022- current

‍

Senior BI Engineer

TrueCar Inc.                             

Jul 2015 – Mar 2022                     

‍Project 2

Client : TrueCar Inc.                

Project Type : Web application

Tools :Tableau, Redshift, s3, Spectrum, PostgreSQL 

Team Size: 6

Role : BI Architect & Administrator

Period : Jul 2015 – Mar 2022

‍

Roles and Responsibilities:

• Built complex extract datasets using custom SQL for dashboard development.
• Architected data warehouse migration project from SQL Server to Amazon Redshift.
• Built Microstrategy schema for Redshift data from scratch and migrated Narrowcast services to Distribution Services.
• Optimized long running Tableau Dashboards and queries in Redshift.
• Designed new tables/datasets in Redshift as per reporting needs.
• Evaluated other BI tools like DOMO, Quicksight, Looker.
• Built dashboard and setup Alerts on Tableau to support Analytics team.
• Lead Migration project of BI Servers.
• Worked on Microstrategy and Tableau datasource connector. 
• Managing BI servers and supporting 200+ Tableau/Microstrategy users.

‍

Technologies : Microstrategy, Tableau, Redshift, s3, Spectrum, PostgreSQL

‍

Senior Software Engineer

Hewlett Packard                               

Jul 2010 to Jun 2015                               

‍Project 3

Client : Universal Music Group              

Project Type : Global Music Mart

Tools : Business Objects, Google BigQuery, SQL Server 

Team Size: 5

Role : Senior BI Engineer

Period : Jul 2010 to Jun 2015 

‍

Roles and Responsibilities:

• Manage BI servers and take care of App Server, Web Server.
• Handling production support requests from Microstrategy business users globally.
• Participating in DW development and enhancements.
• Web customization using SDK on web server UI.
• Automation of manual process.
• Took over onshore responsibility at client’s location in Los Angeles starting from March 2012.
• Provided solutions on architecture issues and played lead role in migrating Microstrategy environment.

‍Technologies : Microstrategy, Business Objects, Google BigQuery, SQL Server

‍

Senior BI Developer

Verizon Data Services India Pvt Ltd                                    

Dec 2005 to Jul 2010                          

‍Project 4

Client : Verizon           

Project Type : Customer Insight

Tools :  Microstrategy, Informatica, SQL Server

Team Size : 7

Role : Senior BI Developer

Period : Jun 2007 – Jul 2010

‍

Roles and Responsibilities:

• Design and Development of new requests in Microstrategy 
• Requirements Gathering and Documentation for new reports development 
• Build Stored Procedure to implement business logic and load into DB. 
• Create Test Cases and perform data and reports validation. 
• Build and Migrate packages from Dev/UAT to Production environment.

Technologies : Microstrategy, Business Objects, Google BigQuery, SQL Server

‍

Analyst

Verizon Data Services India Pvt Ltd                 

Dec 2005 to Jul 2010                          

‍Project 5

Client : Verizon

Project Type : Network Metrics Portal

Tools : Unix Shell Script, Informatica, Oracle

Team Size : 4

Role : Analyst

Period : Dec 2005 – Jun 2007

‍

Roles and Responsibilities:

• Production Support for User request. 
• Archiving by taking backup of history data from warehouse tables. 
• Monitoring Oracle table space and Unix file system. 
• Create Shell Scripts to automate archiving process.

Technologies : Unix Shell Script, Informatica, Oracle

• Certified Architect & Developer