LOOKERBI  DEVELOPER

    K.DINESH                                                                         

 SUMMARY:

• Software Professional with around 5 years of experience as Google Looker BI and SQL Server.
• Having experience in JIRA and SDLC tool.
• Having good experience to create Views and Explore in Looker BI.
• Experience on the Drill Down Feature, applying Label Parameter to view, fields and explores to give more meaning full name. Creating Hidden Parameters, Liquid Parameters.
• Experience on the Basic Filters, Advanced filters, Dimension Groups, Data Groups, Value Format.
• Experience on the Measures and Dimensions, Explore Filters. Worked on joins, Relationships.
• Strong Experience with GIT workflow for Version controlling using commands.
• Experience on creating Aggregate, Non-Aggregate and Post-SQL Measures.
• Experience on YTD, QTD and MTD measures in Looker. Worked on Date Columns.
• Strong hands-on experience in creating Derived tables in Looker BI. Experience on creating custom fields by using custom dimensions, measures and table calculations at explore level.
• Created visualization which is Pie chart, Column chart, Bar chart based on the user requirement.
• Applied the filters on aggregate measures to filter out the data based on end user requirements.
• Good experience in hiding the unnecessary dimensions and measures using hidden features in looker and made them visible again whenever it is necessary.
• Scheduling the looks and Dashboards at different times and creating alerts to schedules.
• Imported data from multiple data sources like Big query, SQL Server.

• Good in creating Queries and Joins for complex queries involving multiple tables.
• Experience in creating Views, Constraints, joins, Temp Tables, Table Variable, Functions and numerous Stored Procedures.
• Worked in a project following agile methodology and actively participated in SCRUM meetings, Sprint Planning meetings.
• Supporting to the internal team members mainly to create Ad hoc reports in timely delivery.

 

ACADEMIC PROFILE:

• B. Tech from AURORA COLLEGE OF ENGINEERING, (JNTUH).

 

EMPLOYMENT HISTORY:

• Working as a LOOKER BI developer from Sep 2020 to till date.
• Worked as a SQL Developer in EXOLVO TECHNOLOGIES PVT LTD, from May 2018 to July 2020.

TECHNICAL SKILLS:

 

Databases:

BIG Query,SQL Server

               Key Area

Looker BI,  SQL

Reporting Tool:

Looker BI,

Data sources

Big Query, SQL Server, Excel, CSV

Version Control

GIT

 

 

 

Project:  3

 

Client:  State Farm, US

Role:   Looker BI Developer 

 

Description:-

                     State Farm is the largest property and casualty insurance provider, and the largest auto insurance provider, in the United States. State Farm