Dhiraj Narkar

• Conducted comprehensive impact analysis and data lineage mapping across data pipelines, tracking data flow from source systems through AWS Glue ETL, Vertica data warehouse, to downstream Tableau dashboards and FastAPI services, documenting dependencies for customer review and migration projects.

• Developed Python-based forecasting solutions using Prophet, SARIMAX, Holt-Winters, and XGBoost to predict lab sample volumes and turnaround times, implementing custom utilities for model training, evaluation, automated forecast generation, and model versioning.

• Designed and deployed scalable data pipelines using AWS Glue and Apache Airflow to automate ingestion, transformation, and orchestration of lab operational data with integrated logging and exception handling.

• Built FastAPI-based microservices in Python to serve processed data and forecasting results to React UI applications, ensuring low-latency, high-availability APIs with robust error handling.

• Developed complex Tableau dashboards and KPI scorecards using Tableau Desktop, implementing advanced statistical methods including standard deviation, moving averages, and statistical process control to detect instrument errors and trend anomalies.

• Created Turn Around Time (TAT) monitoring dashboards in Tableau to track test and order volumes against threshold benchmarks, enabling proactive performance management and operational insights.

• Designed comprehensive QC analytics dashboards displaying Bias%, Coefficient of Variance%, Total Error metrics (90%/95%), QC result counts, error tracking, mean, and standard deviation calculations with interactive filters and parameters.

• Established data lineage documentation frameworks to trace data transformations from source databases through ETL processes, Vertica flat tables, and FastAPI endpoints to Tableau visualizations, ensuring traceability, compliance, and impact assessment capabilities.

• Performed data quality validation by comparing Tableau dashboard outputs with source database queries, ensuring accuracy and implementing automated Python-based validation scripts.

• Optimized Vertica SQL queries and designed denormalized flat tables for high-volume data processing, supporting forecasting and statistical aggregations at daily and hourly granularity, significantly reducing dashboard query execution time.

• Successfully migrated Tableau Server from single-node to multi-node architecture, ensuring enterprise scalability, high availability, and improved performance for reporting needs.

• Delivered prototypes, proof-of-concepts, and requirement estimates for large-scale projects and system migrations, collaborating with onshore teams and stakeholders.

• Led and coached a team of BI analysts, facilitating sprint planning and backlog refinement in Agile environments, fostering technical development and ensuring delivery excellence.

• Collaborated with UI developers to design interactive forecast visualization dashboards with confidence bands, average benchmarks, and drill-down capabilities.

• Deployed end-to-end machine learning and data solutions on AWS infrastructure (Lambda, S3, Athena, Glue), enabling near real-time insights for lab operations teams.

• As a BI lead, Perform the impact analysis and share it with customer and submit prototype, Proof of concept for larger projects and migration to new systems.
• Assist Technical Architect for System understanding and providing use-cases.
• Involved in Sprint planning and backlog refinement process
• Creating user stories and updating story points and assigning it to the individuals
• Providing the estimates for the requirement to onshore team
• Developed complex dashboards & KPI scorecards in Tableau using Tableau Desktop.
• Experience in Migrating Dashboards from Netezza DB to Athena (AWS) DB
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Data quality testing by comparing output of dashboard with database using manual SQL
• Publishing dashboards on server and giving access to users
• Designed, developed and tune queries in Complex SQL, which handle Large volume of data

• Sr. Tableau & Cognos developer

• Sr. Cognos developer

• Cognos developer

• ETL & Cognos developer

• Cognos developer