Gaurav Dhiman

Overview:

• Mars Petcare provides pet care products. The company offers pet health care and food products.
• The goal is to effectively provide ongoing results and analytics to stakeholders in the form of dashboards and reports

Responsibilities:

• Developing and Maintaining Looker Dashboards
• Building SQL-driven derived tables in Looker for complex requirements
• Building out views, models, and explores in LookML converting them into useful insights, and saving them in dashboard or as a look
• Using Google BigQuery as the data warehouse for the Looker Dashboards
• Implemented caching methodologies to optimize LookML performance resulting in reducing load time of the dashboards. Used datagroups and persist_for to accomplish the same
• Embedded Looker Looks in an HTML page and providing the single solution for multiple users
• Implemented templated filters and liquid parameters for the performance enhancement purpose
• Implemented advanced LookML methodologies like Hub and Spoke modeling, and PDTs
• Implemented access_filters and access_grant for security aspects of the dashboards and also created user_groups for the new users access.

Overview:

• Ciena is global leader in optical and routing systems, services, and automation software
• The project was to migrate their existing OBIEE reports to Looker using snowflake as the data warehouse

Responsibilities:

• Creating the project from the scratch and implementing the Hub and spoke modeling to achieve the desired results
• Analyzing the OBIEE reports and converting the existing SQL code to LookML code
• Adhering to the coding standards set by the client
• Optimizing then existing OBIEE Sql queries in Snowflake and creating views
• Documenting the complete procedure of migration

Overview:

• Cardinal Health multinational health care services company. The company specializes in the distribution of pharmaceuticals and medical products
• Goal was to create Looker/Tableau dashboards using ML obtained data to be displayed in all of their warehouses across US

Responsibilities:

• Developing and Maintaining Looker and Tableau Dashboards.
• Creating and maintaining Views in Big Query
• Embedding the Tableau dashboards in an HTML page that was shown on JAB (Job Assistance Board) in all of their distribution centers
• Optimizing SQL queries and Tableau dashboards to save time and money
• Restricting the data in tableau dashboards using user level and row level filters
• Created multiple LODs and calculated fields according to the requirement
• Used tableau extensions for the data refresh

Overview:

• Aviva is UK's leading Insurance, Wealth and Retirement businesses. They help customers in the UK, Ireland and Canada

Responsibilities:

• Developing and Maintaining SAS Stored Procedures, SAS Batch jobs for the GDPR project.
• Done the analysis of the datasets to check whether they contain any PII data or not.
• Optimized SAS jobs and stored procedures by reducing code run time and increasing output
• Used SAS Base and SAS DI for the project

Overview:

• Ooredoo is a Qatari multinational telecommunications company headquartered in Doha. It provides mobile, wireless, wire line, and content services in business and residential markets
• Creating and maintaining a Number Management System for the customer services people of Ooredoo

Responsibilities:

• Worked as a Java developer in the team and worked on the solution
• Used Oracle as the database and followed MVC architecture for the application
• Used Angular, Node for the frontend development