Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

DURGA PRASAD DHAL SAMANTA

Mangalore

Summary

About 5 years of experience in Data Engineering and Data Analytics. Worked on optimization of high resource consuming queries,analysis of resource consumption by the business users,system monitoring on Teradata Viewpoint. Responsible for working in different business units and working with clients to prioritize their needs as per requirement. Data analyst responsible for working with the clients to solve the technical issues faced by their customers. Developed dashboards for the client which enable them to take business driven decisions. Seeking to leverage strong data analytic skills and expertise to increase the productivity of the organization.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Looker Admin

Walmart Global Tech Private Limited
01.2024 - Current
  • Working as a Looker Admin in Walmart.
  • Worked on creating LookML projects for different teams and users across Ecommerce, Enterprise, SupplyChain and Merchandise platform.
  • Worked on implementing data level security by the concept of Model sets in looker to enable the users to consume data from a single project without having to see the data the other users from different teams might be consuming.
  • Worked on developing a script to clean the inactive users schedule reports to save the resources that Looker might be using to run the schedules and this in turn helped in giving space for other active users schedules to run without any hindrance.
  • Worked on giving development related consultations to users to assist them in building visualizations.
  • Worked on LookML migration of the LookML code from development instance to production instance.
  • Worked on analyzing the looker logs to troubleshoot looker platform related issues.
  • Worked on creating dashboards from system activity to track overall health of looker platform.

Looker Developer

Persistent Systems
03.2022 - 01.2024
  • Worked as Looker Developer for Public Storage.
  • Gathered client requirements and developed more than 30+ dashboards from the scratch.
  • Experience in developing simple to complex level sql queries and converting them to derive tables for fulfilling the client requirements where the visualization tool fails to address the issue.
  • Designed the drills with the help of LookML and link parameter to enable the user interactivity and give the business users the leverage to move from one dashboard to another with the help of drills.
  • Created the Templated Filters and Parameter Filters to give the end business users the choice to filter as per the need and use.
  • Developed the functionality of performing the DML operations(Update,Delete,Insert) from Looker and having the changes affected in the database with the help of Looker Actions.
  • Developed the business use case of making the dashboards KPI driven with the help of filters.
  • Designed the use case of conditional drilling to enable the business users to drill and see only the required columns as per the condition.
  • Familiar with various LookML warnings and LookML Error enabling me to generate error free LookML code.

Looker Developer

Akili Inc
03.2022 - 07.2022
  • Worked as Looker Developer for Akili.
  • Gathered client requirements and developed more than 10+ dashboards from the scratch.
  • Experience in generating custom visualization with the help of available JS file.
  • Created the Templated Filters and Parameter Filters to give the end business users the choice to filter as per the need and use.
  • Developed the functionality of Tabbed Dashboards which gave the end users the feasibility to remain in the single tab and navigate to different dashboards with the help of developed tab thus enhancing good UI experience.
  • Designed the functionality of visual drilling which helped the business users to drill and visualize different visualizations available in Looker.
  • Designed joins with various explores to enable sharing of data between different explores.
  • Designed the Row Level and Column Level security with the help of User Attributes.

Data Analyst

Infosys
04.2020 - 03.2022
  • Worked as a Data Analyst for Looker,US(Offshore).
  • Providing the solutions for the customer facing issues with the results not getting displayed in the tiles of the dashboard/alerts not working for the dashboard/tiles not displaying the expected results.
  • Worked on the error faced looks of the customers by narrowing down to a particular field and fixing that in the Look ML.
  • Worked on checking the appropriate Look ML warnings at Look ML side and took required action to solve the issue.
  • Worked on making modifications to the query to fulfill the customer needs with the help of a derived table.
  • Worked closely with the engineering team in case of the bugs reported by the customer in the visualization tool by testing and reproducing the bug.
  • Worked closely with the clients in meetings for help in the unsolved customer issues to meet the customer needs.
  • Worked closely with the manager in taking into account the feedback for overall performance.

Data Performance Engineer

Apple Inc
04.2020 - 04.2021
  • Worked as a Data Performance Engineer for Apple Inc,US(Offshore).
  • Fine tuning various performance parameters to provide seamless experience to the business users and optimal performance of the system.
  • Well conversant with various ticketing system/production change request/Teradata Incident Management.
  • Worked on reviewing the stored procedures to prevent them from creating impact of the system.
  • Checked for the same Unique Primary Index for effective distribution of rows.
  • Reviewed set tables and checked for the options to convert to multiset to avoid costly duplicate row checking operation.
  • Worked on doing spike analysis of the resource consumption for business users
  • Monitored using viewpoint tool for Teradata system performance using different portlets. Focused on statistics management and optimization.

Education

Bachelor's - Electronics and Telecommunications Engineering

Kalinga Institute Of Industrial Technology

Skills

  • Generic Training - Python(Programming fundamentals,Object Oriented Programming,Data Structures)
  • Generic Training - Relational Database Management Systems(SQL)
  • Stream Training - Business Intelligence(SSMS,SSIS,SSAS,SSRS)
  • Data Performance - Teradata Architecture,Resource spike analysis,Query optimization
  • Tools - Eclipse IDE,Microsoft SQL Server,SQL workbench,Teradata Viewpoint,Quip, Microsoft Excel
  • Data analysis - Looker visualization tool(Looks,Dashboards,Look ML)
  • OS - Windows,Macintosh
  • Language - SQL(RDBMS)

Certification

  • GCP Certified Professional Data Engineer, 2022.
  • Hackerrank Certified in SQL(Basic,Medium,Advanced),2022.
  • Infosys Agile Developer Certification, 2019.
  • Internet of Things,ABLab Solutions,2017.

Timeline

Looker Admin

Walmart Global Tech Private Limited
01.2024 - Current

Looker Developer

Persistent Systems
03.2022 - 01.2024

Looker Developer

Akili Inc
03.2022 - 07.2022

Data Analyst

Infosys
04.2020 - 03.2022

Data Performance Engineer

Apple Inc
04.2020 - 04.2021

Bachelor's - Electronics and Telecommunications Engineering

Kalinga Institute Of Industrial Technology

Similar Profiles

CREATE PROFILE
DURGA PRASAD DHAL SAMANTA