Vikrant K.

Vikrant K.

BI Tools and Database Management

Bengaluru , India

Experience: 10 Years

Vikrant

Bengaluru , India

BI Tools and Database Management

10 Years

Now you can Instantly Chat with Vikrant!

About Me

10 Years of professional experience in IT, with emphasis on database management, business intelligence, design and development of Telecom network performance analysis set of products and enterprise applications with strong focus on dat...

Key Strength

  • Experience in Tableau Desktop, Tableau server and efficient in connecting various data sources.
  • As a Tableau Administrator, specializing in Server Worker Nodes Installation & Configuration Setting up.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
  •  Restricted data for users using Row level security and User filters.
  • Strong Data modeling experience using ER diagram, T-SQL, SQL, Stored Procedures, Functions, Packages, Triggers, and scripting languages.
  • Experience in SQL Database management, Dynamic Management views and Database Engine Tuning Advisor.
  • Expertise in designing & developing complex ETL’s (Extract, Transform & Load), Query Optimization plan, SQL Profiler, Performance Monitor, and performance tuning with strong knowledge of SQL servers and proven proficiency in writing and executing SQL queries.
  • Strong Knowledge SSRS. Design and development of dashboards and reports using BI tools. Good knowledge of Tableau server management and SSRS server management.
  • Practical experience and understanding of various development methodologies like Agile and Waterfall.
  • Good Knowledge of .NET web application development & Object oriented concept and design.
  • Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting etc. and Dashboard prompts.

Show More

Portfolio Projects

CEM Analytic Dashboards

Company

CEM Analytic Dashboards

Description

CEM Analytic Dashboards is tableau Packaged solution where service engineer use tableau reader/desktop to check performance of network operation. It comprises media, Web analyzer, Benchmarking dashboards.  
It helps Network Analytics team to monitor and analyze the network closely with respect to the performance    As Sr. Tableau Developer, primary activities included designing technology roadmap for Tableau; product solution and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
    Created interactive data visualizations in Tableau, using relational and aggregate data sources.
    Created a script to load data into CSV file and upload tableau package in physical location.
    Use data blending technique to blend data from different data source.
 

Show More Show Less

Skills

Green Plum

Tools

Tableau

Service Operation Center (SOC)

Company

Service Operation Center (SOC)

Description

SOC is a web based Customer Experience management tools developed by Ericsson and is used across multi Telecom service provider across the world. This product will help the telecom Network Optimization Engineer and Network Analytics team to monitor and analyze the network closely with respect to the performance.

    As Sr. Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
    Created interactive data visualizations in Tableau, using relational and aggregate data sources.
    Creating users, groups, projects, Data connections, settings as tableau administrator.
    Load data in SQL server from different sources using SSIS. Create package to load data in tables.
    Involved in custom SQL queries to import data from SQL server to Tableau.
    Monitor SQL database health and management. Designed ER diagrams and mapping the data into database objects.
 

Show More Show Less

Skills

SQL HTML JQuery

Tools

Tableau

IP Dashboard

Company

IP Dashboard

Description

IP Dashboard is an application which show uses of system and servers. It provides details of Idle ad running system. Using this dashboard business line take decision on system/server. 

    Built Strategic, Analytical, and operational dashboards using Tableau.
    Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to Tableau.
    Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
    Tested reports and uploaded Tableau dashboards on to server and provided production support for Tableau users.
    Created connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
    Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
    Administered user, user groups, and scheduled instances for reports in Tableau.
    Created SQL views to pull data from SQL Server and developed reports using advanced calculations, filters, and parameters
 

Show More Show Less

Tools

Tableau

Ericsson RAN & Core network Performance Analyzer (ESPA)

Company

Ericsson RAN & Core network Performance Analyzer (ESPA)

Description

ESPA is a Network Performance Analyzer tool which provides measurement of network quality.  All key quality indicators namely Integrity, Accessibility, retain ability, Capacity, Mobility, availability can be measured and analyzed under one roof using ESPA. This tool offers both UI and reporting features where the user can trend the performance of the network for specified period and generate the report for further analysis. This tools support multi-vendor (Ericsson, Nokia, and HWA etc.), multi-technology (2G, 3G and CDMA) and multi Domain (RAN & CORE).

    Designed ER diagrams and mapping the data into database objects.
    Database creation and management. Developed jobs, stored procedure for data aggregation. Analyzed long running queries and tuned the complex queries to optimize application and system performance.
    Involved in E2E design of Database layer, Mediation, performance tuning.
    Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries using MS SQL Server 2008/10.
    Generated parameterized/Drilldown, drill through & Cascaded reports using SSRS. SSRS server administration and maintenance.

Show More Show Less

Service Line Inventory Tool Management

Company

Service Line Inventory Tool Management

Description

Project involves development of a web Application which can track all inventory items. 
Key features of this application are
•    Inventory creation, reservation, transfer.
•    Mail alerts to all required stakeholders at all steps of inventory movement.
•    Inventory forecasting and reports of all inventory item including hardware and Software. 
    Understanding the Business requirement, design of the Database and reviewing the updates daily.
    Developed a web application for end users.  
    Requirement Analysis, Estimation, High level design.
    Application development, coding and stored proc creation
 

Show More Show Less

Intranet Collection Automation Tool

Company

Intranet Collection Automation Tool

Description

VSM (Volume Split Module) is an intranet web application used by JPMC IB division for account splitting. It is a sub module of ICAT (Intranet Collection Automation Tool) enterprise application for account splitting and movement across the regions

    Understanding the Requirements
    Preparing design (User Interaction Cases)
    User Interface Designing and Coding
    Creating optimized Stored Procedures for database interaction Code Review for
    Coding Standards and Code Optimization
 

Show More Show Less

Tools

C# Ajax