Lokender S.

Lokender S.

Lead Analyst

Shimla , India

Experience: 8 Years

Lokender

Shimla , India

Lead Analyst

28800 USD / Year

  • Immediate: Available

8 Years

Now you can Instantly Chat with Lokender!

About Me

8+ years of work experience in Analysis, Design, Development and Maintenance of various dashboards and reports using Tableau Desktop along with Tableau Server Having 5+ Years of Experience on the Tableau Development and Tableau Admin and 5 months of ...

Show More

Portfolio Projects

Description

  • Aid in developing style guide for development of BI visualizations, design of components, naming of items, data source creation and naming
  • Provide guidance to IT Infrastructure and Application teams on Architecture’s Frameworks, Patterns, Best Practices, and Programming concepts
  • Maintain the integrity of development work and underlying data through the use of version control systems
  • Assess performance, reward results, motivate and foster matrix management
  • Guiding and Mentoring Team Members and Business Stake Holders on the use of Tableau Desktop as well as Tableau Server and explaining them the web editing features of Tableau
  • Demonstrated translate a question into a visualization which provides insight and answers the question

Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)

Show More Show Less

Description

  • Created Tableau Dashboards with interactive views, trends, drill down along with the user level security
  • Prepared backups using Tabadmin and Tabcmd Commands for backup and restore data on the tableau server
  • Participated in performance tracking activity by evaluating server tasks
  • Worked on exporting data from views in different formats
  • Worked on Improving the Performance of the Tableau Dashboard
  • Worked on Tableau Server administrators to maintain user security and data security

Show More Show Less

Description

This project was based on the performance improvement of the tableau dashboards which were already present in the Tableau Production Server and were connected with the SQL Server database along with the up-gradation of the Tableau Server to Higher Version.

  • Migrated 60 -65 Tableau Dashboards from SQL Server 2012 to APS (Analytic Platform System)
  • Designing and develop Tableau Reports, Documents, Dashboards and Scorecards as per specified requirements and within timeliness
  • Since new environment doesn’t support some of the functions which are present in sql server so I have been involved in debugging the queries, modifying them for the custom sql queries in tableau to work properly.
  • Tableau Server migration from older version to latest version (i.e. from 9.0 to 9.2) by taking advantage of various features of the Tab CMD commands provided by tableau server
  • Used to maintain the Schedules, Permissions, Extracts published on the server along with providing access and adding users into the tableau Server

Show More Show Less

Description

This project was based on the performance improvement of the tableau dashboards which were already present in the Tableau Production Server and were connected with the SQL Server database along with the up-gradation of the Tableau Server to Higher Version.

Show More Show Less

Description

This project was based on the Automation of Excel Based Reports into Tableau to minimize human interaction

Show More Show Less

Description

This Project was related to the Mission Quality Team of Wipro whose main motive was to ensure the Quality of the Deliverables. My role over there was an Analyst creating various Monthly, Weekly, Half Yearly and Daily Reports related to various Metrics of Quality Team. Earlier i used to create Reprts in Excel and later migrated those Reports into Tableau for automating the Task which was manually updating and maintaining the Excel Reports which was quite tedious Task. With the Help of Tableau Migration the entire Reporting was made flexible in terms of delivery and adhoc analysis was faster as compared to earlier

Below are the roles and Responsibilities

  • Successfully ran POC by developing dashboard using Tableau Desktop within Business Intelligence Division
  • Gathered Reports requirement, collaborated with the business users for functionality and automation of reporting system using tableau
  • Involved in reviewing requirement and data sources from MS Excel and MS Access for design, development, testing and production rollover of reporting and analysis projects within Tableau Desktop
  • Made use of the Story Telling objects in some of the ad-hoc dashboard in tableau to tell each and every step what is happening with t
  • Applied User Filters, Sorting, Context Filtering on Views.
  • Assigned Different Roles for users creating users, Groups.
  • Creating ad hoc Reports to users by connecting to various sources
  • Created Data Extracts, Data Sets for Multiple Data Blended Views and Published on the Server

Show More Show Less

Description

They need monthly reports to analyze the business. They want to see monthly reports and analyze by the end of month to track the Customer Base (New/Active/Lapsed/Lapsed etc.)

Show More Show Less