Sayan Nandi

About Sayan Nandi

Sayan is an accomplished IT Professional with 11 years of experience in Business…

Experience

1. Senior Business Intelligence Developer

   Wipro

   Oct 2019 — Present

   Designed and lead BI Report development using AWS Redshift Data Warehouse, Tableau Prep, SQL and Tableau • Optimize Tableau dashboard performance by tuning joins, calculations, and visuals to reduce load time • Built dashboards and reports in Tableau with drill through functionalities for easy analysis • Developed Parameterized Tableau reports and visualization with dynamic and context filtering • Enabled self-service reporting to pull/create adhoc reports based on their day-to-day needs • Lead and mentor team and solve technical problems to meet deadlines and quality of deliverable • Tracked, address and close change requests in change management tools in a timely manner • Tested all finished reports to ensure correct formulation of calculations in Tableau • Developed and deliver strategy for data extracts for tableau in hyper format for future reporting • Defined relation between hyper data extracts in tableau server to streamline data consumption • Maintain Tableau resources like users, permissions, refresh schedules and performance as site administrator • Develop SQL procedures to transform data and load it into temporary data lakes for sample reports • Write complex SQL queries using aggregate functions to verify that calculations for reports are done right • Eliminated memory-heavy table calculations from reports and replaced them with nested queries, CTEs, rank and partition to optimize report load time • Conduct Data workshops with business and IT stakeholders to prioritize use cases and build roadmap • Identify business flow, perform gap analysis, provide recommendations in key strategic operations • Create ETL Pipelines using Tableau Prep to extract data in required level of granularity as per the reporting needs • Develop and deliver strategy for data extracts for tableau in hyper format for future reporting • Provide necessary review comments to team members on their work-products and suggest improvements

Education

• Naveen Jindal School of Management, UT Dallas

  Master’s Degree, Information Technology & Management

  2014 — 2017

• National Institute of Technology Durgapur

  Bachelor of Technology (B.Tech.), Biotechnology

  2007 — 2011

• St. Joseph's College, Kolkata

  High School, Science

  2005 — 2007

• Texas McCombs School of Business

  Post Graduate Program in Data Science and Business Analytics, Data Science

• Lyce'e, Kolkata

  10th, Secondary Education

  1990 — 2005

Skills

• Java Enterprise Edition
• Db2
• Rational Software Architect
• Sap Netweaver Business Warehouse (Sap Bw)
• Software Project Management
• Test Planning
• Requirements Gathering
• Test Automation
• Requirements Analysis
• Java Database Connectivity (Jdbc)
• Oop
• Strategic Planning
• Tableau
• Webfocus
• Business Intelligence
• Management
• Team Management
• Data Analysis
• Software Development
• Mysql
• Business Strategy
• Agile Methodologies
• Microsoft Excel
• Manual Testing
• Consulting
• Quality Assurance
• Project Management
• Sdlc
• Data Warehousing
• Rational Functional Tester
• Power Bi
• Sql
• Selenium
• Jdbc
• C
• Bex Analyzer
• Python
• Visio
• Sas E-Miner
• Rational Performance Tester