Jagadeesh

Jagadeesh

Lead Bi
India

About Me

Skilled LEAD BI with record of success breaking down and improving business systems. Collaborates well to test, implement, refine and enhance systems and meet current and expected business needs. Excellent research, repo…

Experience

BI Manager

Expedia Group
Aug 2023 - Present · 3 years 2 months

Skilled LEAD BI with record of success breaking down and improving business systems. Collaborates well to test, implement, refine and enhance systems and meet current and expected business needs. Excellent research, reporting and communication strengths developed over 9-year career. Meticulous BI Analyst maintaining highly functional digital systems for uninterrupted workflows and consistent productivity. Oversees routine maintenance checks and software update schedules to reduce network downtime and likelihood of security compromises. Loves collaborating with customers and teammates to develop and implement creative technical solutions to challenging problems. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.

BI Lead

Koch Business Solutions, Bangalore
May 2021 - Jun 2023 · 2 years 1 month

<p>Leading Data Visualization Center of Excellence (COE) & help Koch companies to become data-driven<br>
Drive the delivery and evolution of visualization capabilities which empower Digital platforms (Data solutions) as well as serve as backbone to service offering in Customer Insights, Data Analytics & Customer Experience<br>
To standardize and govern data that is exposed to users, ensure that the company's BI strategy is aligned with their self-service model and be the driver for best practices and training programs<br>
Look for new opportunities across different business groups and champion the use of visualizing data to various teams across the organization<br>
Identify the right people who understand analytics, data visualization, can negotiate well with business and can explain the value<br>
Identify business requirements, translate them into Visualization requirements and collaborate with architecture, engineering, BI & Business Analysts, testing and customer implementation teams to drive execution of projects<br>
Ensure that solutions are correctly scoped, designed, built and launched on time, in alignment with client needs and business requirements and supported by the necessary documentation<br>
Monitor execution against business commitments<br>
Make workshops with internal stakeholders and clients<br>
Collaborate with other groups within the company to orchestrate successful product outcomes including business development, marketing, research and analytics teams<br>
Promote standardized documentation process to reduce Operational ambiguity and to act as Training material for new resources<br>
Work closely with product management and development teams to understand data and visualization requirements and translate business needs into deliverables<br>
Lead KTC DV COE as the preferred partner for all Koch industries for any BI Dashboarding requirements<br>
Focus on Quality deliverables in time bound manner leading to delighting our clients & meeting their expectations each time<br>
To hire strong talents with overall great Technical and Soft skills<br>
Motivate and generate scope for internal existing talents to plan for vendor certifications to keep themselves skilled<br>
To bring best practices and make this as a convention across all verticals<br>
Lead the development team to create and embed dashboards and complex analytical graphs into our existing applications<br>
Create business intelligence dashboards and visualizations to produce insights to complex program data in ways that assist in translating organizational problem statements into actionable decision-making practices<br>
Leading and managing standardization on user interface design by following established practices and standards<br>
Participates in the generation, experimentation, and implementation of new approaches and activities that improve and expand the client's mission and work<br>
Work with a team of engineers to help develop and deploy sophisticated data visualization solutions<br>
Train the interns on various aspects of Data visualization and tools<br>
Self Actualization<br>
Explore different Data Visualization tools available in the market and prepare POC's as a part of early adoption strategy<br>
Knowledge share sessions on Data Visualization & Engineering<br>
Build expertise in Advance analytics with ML<br>
White papers<br>
Target Certifications across Data visualization & Cloud platforms, Tableau Desktop 2020.2.2, Tableau Server, SSAS, SQL<br>
Identified needed business improvements and determined appropriate systems required to implement solutions<br>
Organized system operating procedures to strengthen controls<br>
Researched and adopted new technologies to add value to existing offerings<br>
Gathered, reviewed and reported on findings<br>
Created and maintained standard operating procedures governing system functions and features<br>
Produced charts and diagrams to assist with problem analysis<br>
Collected, defined and analyzed business requirements<br>
Improved systems with addition of new features and infrastructure</p>

BI Developer

Affine Analytics
Jul 2020 - Apr 2021 · 9 months

<p>Working with the Pre Sales in doing Analysis of Sub Set Of Data in Chuck E Cheese<br>
Working with stake holders to understand the requirements and create Dashboards accordingly and suggest the Best Practices of the Dashboards<br>
Created advanced reports in Power BI<br>
Using DAX functions in Power BI<br>
Creating newcolumn and newmeasures effectively using DAX functions<br>
Created different Visualizations in Power BI<br>
Designing, developing, and maintaining Power BI reports, dashboards, and data models<br>
Extracting and transforming data from various sources for analysis and visualization<br>
Collaborating with business stakeholders to understand their requirements and translating them into effective Power BI solutions<br>
Optimizing data models and query performance for efficient data retrieval<br>
Implementing security measures to ensure data privacy and access controls<br>
Providing training and support to end-users for Power BI adoption<br>
Overseeing the overall strategy and implementation of Power BI within the organization<br>
Managing a team of Power BI developers and analysts<br>
Setting up governance processes, standards, and best practices for Power BI development and usage<br>
Collaborating with business stakeholders to align Power BI initiatives with organizational goals<br>
Managing budgets, resources, and timelines for Power BI projects<br>
Evaluating new features and updates in Power BI and assessing their potential impact on the organization<br>
Gathering and analyzing data from various sources to identify trends, patterns, and insights<br>
Creating visually appealing and informative reports and dashboards using Power BI<br>
Collaborating with business users to understand their analytical requirements and translating them into actionable insights<br>
Conducting data modeling and creating relationships between different data sources<br>
Ensuring data quality and accuracy by performing data validation and cleansing<br>
Presenting findings and recommendations to stakeholders to drive data-driven decision-making<br>
Providing training and support to end-users for Power BI adoption<br>
Worked on Page Level Filters and Report Level Filters<br>
Used Drill Through functionality in Power BI</p>

Tableau Lead

Nityo Infotech Services, AS Watson Group, Hong Kong
Nov 2019 - Apr 2020 · 5 months

<p>Watson Group is the world's largest international health and beauty retailer with over 15,700 stores in 25 markets<br>
Every year, over 5 billion customers and members shopped with our 12 retail brands in stores and online<br>
Gained extensive knowledge in data entry, analysis and reporting<br>
Self-motivated, with a strong sense of personal responsibility<br>
Gained strong leadership skills by managing projects from start to finish<br>
Developed strong communication and organizational skills through working on group projects<br>
Understanding the functional and technical specification<br>
Deep experience with the design and development of Tableau ,Prep Builder<br>
Created different Dashboards for All Hubs Metrics<br>
Created advanced Batch Scripts to Automate Tableau Reports using Tableau Workflows<br>
Gathering information from different Countries Stake holders like Taiwan,Malayasia,Singapore ,Phillipines Etc<br>
Created Tableau WorkFlows with Advanced Techniques<br>
Created Future Alanytics Reports on Price Analysis<br>
Publishing Tableau Reports to Server<br>
Publishing Dataset to server<br>
Created weekly Reports, Monthly and Yearly reports etc, Power BI ,Tableau</p>

Tableau Developer

Genisys Group
Sep 2017 - Aug 2018 · 11 months

<p>Working with the Pre Sales in doing Analysis of Sub Set Of Data in Chuck E Cheese<br>
Working with stake holders to understand the requirements and create Dashboards accordingly and suggest the Best Practices of the Dashboards<br>
Created advanced reports in Power BI<br>
Using DAX functions in Power BI<br>
Extensively used M Query in Power BI<br>
Creating newcolumn and newmeasures effectively using DAX functions<br>
Created different Visualizations in Power BI<br>
Worked on Page Level Filters and Report Level Filters<br>
Used Drill Through functionality in Power BI<br>
Converted all the static reports to Dynamic reports for Daily,Monthly and yearly<br>
Created UI/UX designs using figma for Power BI Reports</p>

Tableau Developer

Proclan Technologies Pvt Ltd
Mar 2017 - Aug 2018 · 1 year 5 months

<p>Tableau 10.1.2, Project: NBN is the Australia's broad band network services is the public sector company by the Australian government they provide broad band services, Understanding the functional and technical specification<br>
Deep experience with the design and development of Tableau visualization solutions<br>
Created different kinds of dashboards according to the client requirement<br>
Created advanced Actions in tableau 10.1.2<br>
Created advanced calculations in tableau<br>
Gathering information and preparing the dashboards and created story points<br>
I have created different kinds of reports like Infra Structure Services report<br>
ITIO balanced Score Card report, C-SAT reports, ITCC Weekly reports, IT InfraStructure Services report, Network Services Balanced Score Card Reports, ITSMO Balanced Score Card Reports etc<br>
We load the data from Microsoft SQL Server Using SQL queries to Tableau<br>
We are Using Tableau 10.1.2 Version<br>
After Creating the reports we do unit testing<br>
We publish the Reports to DEV server and after reviewing the report by the Client we publish those reports into UAT environment<br>
We publish the reports into Tableau Server according to the time frequency of the reports like weekly reports , monthly and quarterly reports and YTD reports</p>

Tableau Developer

Proclan Technologies Pvt Ltd
Mar 2016 - Mar 2017 · 1 year

<p>Office depot & Office Max, Understanding the functional and technical specification<br>
Deep experience with the design and development of Tableau visualization solutions<br>
Created different kinds of dashboards according to the client requirement<br>
Created advanced Actions in tableau 9.1<br>
Gathering information and preparing the dashboards and created story points<br>
Created advanced calculations in tableau<br>
Created reports like CSAT trend, WBR, leadgen, Hourly KPI reports etc<br>
Retrieving the metrics from teradata and other portals like Service management tools<br>
Created parameters and calculated fields and quick table calculations<br>
Created reports like hourly, daily, monthly, quarterly, yearly<br>
Based on the frequency of the report used to retrieve the data and refresh in tableau workbooks<br>
Created WTD, MTD, QTD, YTD reports in different platforms<br>
Created different kinds of views<br>
Responsibilities as a Oracle SQL developer:<br>
Developed stored procedures to extract the data from different sources &load it into DW<br>
Involved in uploading of the data from flat files into Databases &validated the data with SQL Queries<br>
Maintaining daily batch cycle and providing 24 hour production support<br>
Analyze SQL statements, reorganize database objects &design indexes to improve response of queries<br>
Involved in handling the changes in compiling scripts according to the database changes<br>
Developed reports using complex queries as per client request as a part of production support<br>
Provided on call support, solved the user issues and made necessary changes<br>
Writing high quality and well documented code according to standards</p>

BI Lead & Tableau Lead

Proclan Technologies Pvt Ltd
Aug 2015 - Mar 2016 · 7 months

<p>IT Professional having 8+ years of experience in designing of Data Warehousing Projects using Tableau 8.1,8.2, Tableau 9.1,Tableau 9.2 and Informatica.Tableau 8.1/8.2, 9.1, 9.2,9.3, 10.1.2<br>
Power BI ,Tableau 2019.3.1,Tableau Prep Builder<br>
Created different types of dashboards according to the client requirement<br>
Created geographical views, pie charts,Custom geocoding, filledmaps, and symbol maps<br>
Having good knowledge on clipboards and data source formatting in tableau.Successfully created Sets, Annotation, and Dimension Hierarchies in Tableau<br>
Designed Hierachy's Implemented sorting, grouping, actions in Tableau<br>
Technical skills:<br>
ETL/Data Modeling Tools<br>
Informatica Power Center 8.6.1/8.1/x (Repository Manager, Designer, Work Flow Monitor, Work Flow Manager,Tableau 8.1 , Tableau 8.2,Tableau 9.1,9.2,9.3,10.3,Tableau 2019.3.1,Tableau 2021.4,Power BI,Qlik senseAlteryx,Webi Reports ., Roles and Responsibilities:<br>
Writing the complex SQL queries to convert the Excel reports into Tableau reports and creating the Tableau dashboards in different formats<br>
Understanding the functional and technical specification<br>
Deep experience with the design and development of Tableau visualization solutions<br>
Use Measure name &Value fields to create visualizations with multiple measures&dimensions<br>
Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports<br>
Regular involving in calls with customer &discussing about status & new requirements of the project<br>
Preparing Dashboards using calculations, parameters in Tableau<br>
Used TrendLines,Parameters, Aggregate Functions ,Filters<br>
Involved in requirement analysis gathering and developed functional document<br>
Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot)<br>
Exp<br>
In creating Filters, quick filters, table calculations, calculated measures & Parameters</p>

Developer

Proclan Technologies Pvt Ltd, Bharati Airtel
May 2014 - Dec 2014 · 7 months

<p>Reliance CDMA/GSM, Vodafone, Informatica 8.6, Oracle 10g, Flat Files<br>
Description:It is a value-added service (VAS) company and offers content management, mobile advertising, ring back tones, phone backup, voice portals&voice SMS.It receives log files for each Telecom Operator based on new subscribers list, new subscriptions for various VAS services on Daily Basis which needs to be reformatted as per business logic &later will be loaded to Dimension and fact tables<br>
These data warehouse is mainly for purpose of data analysis, report generation based on various operators, various subscriptions during a span of time and helpful in decision making<br>
Source will be flat files which are logs generated on daily basis based on calls routed to server<br>
After receiving file, ETL loads data first to dimension table and then to fact table<br>
If the record is already available in<br>
Dimension table then it will be loaded directly to fact tables<br>
Once data is populated in tables, Java application will generates reports based on Operator requirement<br>
Roles, Responsibilities:<br>
Role:, Involved in Analysis, requirements gathering, technical specification, development, and testing.Used Informatica Designer to create complex mappings using different transformations to move data to a Data Warehouse<br>
Extensively used unconnected Lookups, Filter, Router, Aggregator, Expression, Update strategy for mapping Development<br>
Used Pre and Post-Session Command, Global objects and various other tasks to make sure data Integrity against same target warehouse<br>
Involved in transferring the data from IMS log files server to UNIX Server along with corresponding data files<br>
Involved in delimited flat files Source systems &archiving the same which were received on daily basis<br>
Developed mappings that incorporated logic needed to handle inserts and updates to the existing targets<br>
Responsible in handling the complex scenarios and mappings and debugging them to the core level in fixing the bugs<br>
Used mapping parameters and parameter files on different mappings and sessions, based on various business requirements<br>
Handled the performance tuning of Informatica Mappings at various level to get the maximum throughput.</p>

Team Member

Proclan Technologies Pvt Ltd, Garmin

<p>Garmin Electronics is Electronic equipments Manufacturing Company<br>
They have products including a wide range like household appliances, computer peripherals, entertainment, medical electronics etc<br>
The main objective of the project was assisting the senior and middle level management of the organization to improve the sales and get the knowledge of the new business opportunities<br>
Experience in tableau created Rapid Analytics and Reporting<br>
Developed work sheets, work books Dashboards using Tableau Desktop<br>
Delivered advanced/complex reporting solutions such as dashboards and standardized reporting using tableau 8.0<br>
Created views by using work sheets, work books Dashboards in Tableau<br>
Using Multiple Measures Data Blending, Individual Axis, Dual axis, Actions<br>
Created the reports using Charts like pie, bar, line, etc…<br>
Implementing table calculations, calculated measures and parameters<br>
Created Dash boards,Sets,Online,Offline maps,Calculations<br>
Charts are used in making reports more user friendly in analysis purpose<br>
Implemented Table calculations, calculated measures and parameters in Tableau<br>
Implemented Custom Geocoding,Filled maps,Symbol maps WMS Server<br>
Having good knowledge on clipboards and Data Source Formating in tableau<br>
Designed Hierachy's Implemented sorting, grouping, actions in Tableau<br>
Successfully created Sets, Annotation, Dimension Hierarchies in Tableau<br>
Having knowledge in Filters, quick filters, context filter in Tableau<br>
Created aggregates, Hierarchies, formatting, sorting in Tableau<br>
Having good knowledge on clipboards and Data Source Filters in tableau<br>
Design and delivery complex dashboards, Involved in wrote text</p>

Skills

Excel SQL Database Alteryx Artificial Intelligence Machine Learning Algorithms Qlik Natural Language Processing Power BI Tableau Qlik Sense Tableau Prep Informatica SQL Server Oracle HP Vertica UI/UX Python Machine Learning Deep Learning DAX M Query Figma SQL Tableau Server SSAS Informatica Power Center Webi Reports Teradata Oracle SQL Data Warehousing ETL Data Modeling Data Visualization Dashboarding Reporting Requirements Gathering Testing Production Support Data Analysis Communication Problem Solving Time Management Organizational Skills Leadership Training Governance Best Practices Documentation Data Validation Data Cleansing Performance Tuning Batch Scripts Tableau Workflows Custom Geocoding Calculated Fields
Report this Profile?