Summary
Overview
Work History
Education
Skills
Accomplishments
Additional Information
Work Availability
Work Preference
Timeline
BusinessAnalyst

Nandhini Ramakrishnan

Mississauga,ON

Summary

Business Intelligence Lead with 8.5 years of demonstrated expertise in providing comprehensive analytics solutions, spanning from initial product ideation to implementation using Tableau and Power BI. Proficient in steering teams of data analysts and visualization engineers, and delivering executive-level dashboards. Adept at fostering collaboration across diverse delivery units, to ensure effective communication and cultivate trust between clients and delivery teams. Successfully spearheaded 7 data projects, encompassing the development of over 270 business dashboards across finance, research and development, manufacturing & pharmaceutical domains. Skilled in translating business requirements into KPIs, establishing service-level agreements and scrutinize data to identify and highlight crucial metrics, facilitating real-time data-driven decision-making.

Overview

8
8
years of professional experience

Work History

Business Intelligence Lead Consultant

Infosys Limited
03.2024 - Current
  • Design dashboard templates adhering to organizational standards while accommodating data & business requirements
  • Apply analytics techniques (K-means clustering) to uncover hidden patterns and trends in data, providing valuable insights for strategic decision-making
  • Automate data extraction from Tableau views through a python script using pandas & tableauserverclient libraries eliminating complete manual intervention.
  • Work on OAuth setup for Tableau & Snowflake connectivity for service accounts
  • Extract the list of Tableau objects affected by database and schema migration using Tableau metadata.
  • Build a roadmap for subsequent migration of dashboard data sources.
  • Create Tableau data products to allow internal team to query relevant information faster rather than from legacy systems.
  • Support internal recruitment for business intelligence opportunities.

Business Intelligence Lead

Infosys Limited
03.2021 - 03.2024
  • Led a team of 5 engineers to solve visualization requirements and delivered interactive Tableau & Power BI dashboards for 3 projects
  • Developed and published complex Tableau dashboards for datasets with having than 60M records with optimized performance using the logical connection layers
  • Managed access to Tableau server for an 800+ user base through local server groups & sail point active directory groups
  • Supported Data Governance for published contents, role-based license model & frequent Tableau server health checkups
  • Leveraged Tableau Metadata to build a dashboard to provide insights for database/platform migration view the adoption & usage metrics of the products deployed
  • Engaged with the Tableau community to continuously enable the users with knowledge factory by organizing Webinars, hosting Lunch & Learns and sending a weekly tip mailer
  • Conducted Office Hours twice a week at IST & EST time zones to resolve any queries from the global Business Intelligence community
  • Facilitated scrum meetings, plan for sprints using the JIRA board & document technical specifications in Alation
  • Conducted thorough data gap analysis and data quality checks before creating wireframes for dashboards to validate data model accuracy.

Senior Business Intelligence Analyst

Infosys Limited
03.2021 - 03.2024
  • Built data models using customized Denodo SQL & Postgres for the dashboards to consume, leading to a 60% cost reduction
  • Work with the Data team for any support on complex modelling
  • Maintained the freshness of KPIs from the crucial data by directly connecting to Amazon S3 files via the Athena layer
  • Built a linear regression model visualization in Tableau for parent materials quality progression check
  • Increased user interactivity and garner more interest in Tableau dashboards by using iconography & designing non-native Tableau visualizations such as dual axes maps, calendar heat maps, dendrograms, rounded gradient bar graphs, box-plots, expand & minimized charts, waterfall charts, spark line indicators, word cloud, KPI cards & Tabular charts with conditional formatting
  • Used Tableau set-actions, parameter actions & URL actions for interconnectivity of the dashboards/workbooks to maintain the fluidity of the user workflow
  • Use of LoDs & context filters to achieve the desired visuals.

Business Intelligence Developer

Cognizant Technology Solutions
06.2019 - 03.2021
  • Managed a legacy system of 800+ WebFOCUS Reports single-handedly to continue user support until new equivalent Tableau dashboards with Snowflake, Actian Vectorwise & Oracle Data were developed and went live
  • Developed and published Tableau dashboards for clients from industry domains such as Insurance, Multi Media & Manufacturing
  • Used simple yet highly readable charts such as bar graphs, line charts, doghnut charts, lollipop charts & dual axes charts
  • Delivered year-over-year financial dashboards to executive leadership to provide insights on performance metrics % across all products and 2 regions with row-level security implemented
  • Automated content extraction process using Java that eliminated 80% of manual work on 5000+ files for a migration project that also reported the actual work & resources needed, leading to effective cost estimation
  • Automated Tableau server monitoring by building a dashboard over the metadata repository easing the analysis effort for the administrator and cutting the time spent in half
  • Extensively used parameters in Snowflake Custom SQLs to customize reports for current dates that enhanced UI functionality and usability.

Business Intelligence Developer

Cognizant Technology Solutions
03.2016 - 05.2019
  • Streamlined Tableau reporting for existing SSRS reports with Snowflake data connection to migrate data visualization to higher environments and improve user satisfaction by 70%
  • Built WebFOCUS equivalent dashboards for SQR reports by connecting to PL/SQL
  • Developed a highly complex WebFOCUS report that involved column-by-column printing of the customer insurance record using the heavy looping concept
  • Delivered 98% 'apple to apple' results by replicating reports in WebFOCUS exactly as in SQR for an Insurance client.

Education

Master of Science - Software Engineering

Anna University
India
06.2015

Skills

  • Tableau Desktop (105 to 20234) & Tableau Server
  • Power BI
  • WebFOCUS
  • Qliksense concepts
  • SQL
  • Python for data analysis (Pandas, TableauServerClient & NumPy)
  • Java Basics
  • Snowflake
  • Denodo
  • PostgreSQL
  • AWS Redshift
  • AWS S3 - Athena
  • Oracle
  • MS Excel
  • Smart Sheets
  • Google Sheets
  • JIRA
  • Alation
  • Confluence
  • Data Analytics & Visualization
  • Data Modelling
  • Data Gap Analysis
  • Data validation
  • Technology Governance
  • Data Governance Support
  • Change Management
  • Client Engagement
  • Team Management & Agile Methodologies

Accomplishments

  • Led 3 Tableau projects in parallel and served as a single platform point of contact for Research and Development unit of the organization.
  • Played a consultant and built a roadmap for migrating Tableau reports to Qliksense and highlighted essential features to be preserved.
  • Worked with multiple delivery teams including business analysts, Business Intelligence developers, data engineers, stakeholders, end users, and executive leadership.
  • Strategically assign tasks to team members based on their expertise, fostering a collaborative work environment and optimizing productivity, leading to the successful achievement of delivery milestones within budget and exceeding client expectations.
  • Successfully migrated reports from Power BI to Tableau by comprehensively studying the implementation in Power BI and translating the exact requirements to achieve 0 loss of dashboard features.
  • Automated data extraction from Tableau server views through a python script using pandas & tableauserverclient libraries eliminating manual intervention.
  • Partnered with Data Governance Team to streamline the access management of the confidential data in Tableau dashboards.
  • Applied row-level security in Tableau for highly sensitive year-over-year financial performance dashboards for executive leadership and ensured that data confidentiality was maintained 100%.
  • Designed SQL models and queries in Denodo, Snowflake, Postgres to consume variable year values and eliminated manual intervention required for every 1 year.
  • Spearheaded the implementation of Tableau's empty extracts to optimize dashboard performance resulting in reduced processing time by 50% in data intensive reports.
  • Created a non-native feature of having a multiple metrics selection screen with histograms that act as a filtering panel for distinguishing the records that fall in and out of the selection for the rest of the tabs in Tableau dashboards.
  • Promoted automation by developing a Java tool for content extraction from files that reduced 80% of manual effort and days of work for planning a migration project, despite not having practiced since university days.
  • Organized and led an account level (1000+ people) technical event such as Ideathon, Quiz & Image Generation using AI tools to promote prompt engineering and artificial intelligence learning.

Additional Information

Visa Status: Permanent Resident - Canada

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Work Preference

Work Type

Full Time

Location Preference

Remote

Important To Me

Work-life balanceCompany CultureCareer advancementWork from home optionPaid time offPersonal development programsHealthcare benefits

Timeline

Business Intelligence Lead Consultant

Infosys Limited
03.2024 - Current

Business Intelligence Lead

Infosys Limited
03.2021 - 03.2024

Senior Business Intelligence Analyst

Infosys Limited
03.2021 - 03.2024

Business Intelligence Developer

Cognizant Technology Solutions
06.2019 - 03.2021

Business Intelligence Developer

Cognizant Technology Solutions
03.2016 - 05.2019

Master of Science - Software Engineering

Anna University
Nandhini Ramakrishnan