Jayanth Senior Engineer
No reviews yet

As an experienced BI Developer, I specialize in creating data-driven solutions that empower organizations to make informed business decisions. I design and develop interactive dashboards, reports, and scorecards that translate complex data into clear, actionable insights, tailored to business needs. With a strong foundation in both frontend visualization and backend data processing, I build efficient ETL pipelines, manage large-scale data integrations, and optimize data models for seamless reporting.

I have hands-on experience with Snowflake, utilizing Snow SQL for ETL workflows and building dynamic queries, stored procedures, tables, and views to improve data accessibility and performance. By configuring role-based security, I ensure that sensitive data is protected, providing access to reports only for the right users based on geography or brand. I also leverage Power BI’s cloud capabilities to ensure smooth data connectivity, with automated scheduled refreshes for consistent, up-to-date insights.

Additionally, I have a strong focus on performance optimization, applying advanced DAX techniques to enhance report speed and efficiency. I take pride in my ability to simplify complex data sets, reduce redundancy, and improve the overall user experience through interactive, intuitive reporting.

Subjects

  • Power BI Beginner-Expert

  • Data analysis and visualization Beginner-Expert

  • Data Analysis with Excel, Access and sql Beginner-Expert

  • Data analytics tools Beginner-Expert

  • Power BI Dashboards Beginner-Expert

Experience

  • Master Data Analyst (Aug, 2021–Present) at Cyient India, Bangalore
    BI Developer

    Data Visualizations and Reporting: Designed and developed interactive dashboards, reports, and scorecards based on business requirements, delivering clear insights and actionable data visualizations.

    Aggregations and Calculations: Implemented complex aggregations, calculated fields, table calculations, running totals, and percentage metrics, leveraging Key Performance Indicators (KPIs) and business measures to enhance reporting accuracy.

    Interactive Reports: Built dynamic and user-friendly interactive reports, utilizing bookmarks and actions for intuitive navigation and improved user experience.

    ETL Pipeline Development: Developed and maintained ETL pipelines within and outside a data warehouse environment, using Snowflake's Snow SQL for efficient data extraction, transformation, and loading.

    Database Management: Authored dynamic SQL queries and stored procedures to retrieve customized data. Designed and optimized tables and views to enhance database performance and streamline data retrieval processes.

    Data Integration: Managed data integration workflows by scheduling SQL jobs to facilitate periodic and incremental data loading. Developed a centralized data model using Dataflows to minimize redundant data refreshes and centralize administrative control.

    Security Implementation: Configured role-based security, applying restrictions on report access based on geography and brand, to meet business-specific security and compliance requirements.

    Data Connectivity: Established seamless data connectivity between Power BI Cloud and on-premises databases using the On-Premises Data Gateway, ensuring daily data synchronization through scheduled refreshes.

    Performance Optimization: Optimized DAX expressions (measures and columns) using DAX Studio, resulting in improved performance, faster report loading times, and more efficient data processing.
  • Master Data Analyst (Jun, 2019–Dec, 2019) at Hindustan unilever limited at Silvassa ( India)

Education

  • B.Tech (Jun, 2015–Apr, 2019) from Dayanada Sagar college of engineering Bangalore

Fee details

    ₹1,000–2,500/hour (US$11.88–29.71/hour)

    Prices are varied based on time and period of engagaement

Reviews

No reviews yet. Be the first one to review this tutor.