Sushant Rath

BI & Data Engineering | AWS, PostgreSQL, Sisense, Python

(Dec 2020 – June 2021 on GeoPITS payroll, June 2021 onwards on Cropin payroll)

• Data Pipeline Development & Architecture : Designed and managed an AWS-based Data Lake on Redshift , building scalable ETL pipelines using AWS Glue, Lambda, Step Functions, and EventBridge . Integrated AWS SNS, and SQS to support event-driven data processing.
• Data Warehousing & Modeling : Created and optimized PostgreSQL views, stored procedures, and functions for data transformation, indexing, and query optimization . Worked with Redshift and have an understanding of Snowflake-based architectures .
• BI & Reporting : Designed and maintained analytical reports & dashboards using Sisense, Power BI, SSRS, and Jasper Reports , providing real-time insights for business decision-making.
• Data Quality & Performance Optimization : Implemented data quality checks, monitoring , and query performance tuning (MySQL, PostgreSQL, Redshift) to ensure data accuracy, reliability, and efficiency .
• Data API Development & Automation : Developed data transformation automation in Sisense using Python, Sisense REST APIs, and Plugins . Customized dashboards with JavaScript, HTML, and CSS .
• Stakeholder Collaboration : Worked with business stakeholders, product owners, and data consumers to gather requirements, optimize data models, and translate business needs into technical solutions .

People & Project Management | Agile & Scrum

• Led and mentored a 6-member BI & Data Engineering team , driving hiring, training, resource planning, and sprint execution .
• Managed Scrum practices , ensuring smooth collaboration, backlog prioritization, and on-time sprint deliveries.
• Conducted technical reviews, R&D initiatives, and process optimizations to enhance team efficiency and project outcomes.

• Designed and managed relational (MSSQL, MySQL) and non-relational (MongoDB) databases on Azure & AWS Cloud .
• Developed data pipelines, stored procedures, and triggers to support application functionality.
• Built and optimized Power BI & Tableau dashboards using DAX & Python for data visualization.
• Led data migration & master data management for multiple applications.
• Developed REST APIs using Java, Node.js, and PHP for web and mobile applications
• Managed GitHub version control and deployed APIs on AWS cloud servers .

• Worked as a Senior Data Analyst for a US-based financial advisory firm , focusing on application monitoring, L1 DBA Tasks, data analysis, and reporting .
• Developed and optimized complex SQL queries to clean, transform, and analyze large datasets in MS SQL Server .
• Designed and deployed SSIS packages to automate data ingestion and transformation workflows.
• Created interactive reports and dashboards in SSRS and Power BI , improving data visualization and business decision-making.