SUYOG SURANA

Master's

Business Analytics

Aicence IT Solutions Pvt. Ltd., Pune, India

Associate Software Engineer – Business Intelligence Developer

• Established and maintained procedural SQL logic within AWS Redshift and SQL Server, aligning code with specific business requirements. • Streamlined and optimized queries between SQL Server and Redshift platforms for seamless compatibility and enhanced system performance. • Utilized AWS Quicksight and Birst platforms to create 90+ data visualizations, developing metrics, data models, and logic for interactive dashboards and reports. Defined key performance indicators (KPIs) to quantitatively measure the impact of business and product decisions, contributing to informed decision-making processes. • Applied advanced statistical analysis techniques within the ETL workflow, improving data processing efficiency. • Implemented rigorous data quality checks to ensure the accuracy and reliability of dashboards and reports. • Oversaw security permissions for both external and internal clients, monitoring licenses, and assigning rights. • Engaged with clients from the USA and Europe, demonstrating developed user stories. • Pioneered the development and implementation of a dynamic compliance dashboard, enhancing employment productivity and payroll accuracy for clients. This solution, providing real-time insights into compliance status, has empowered clients to make informed decisions, fostering a more efficient and compliant workforce while facilitating precise payroll management. Contributions to this compliance solution underscore commitment to leveraging technology for improved productivity and regulatory adherence. • Utilized AWS Quicksight to perform rigorous data validation across three distinct databases, ensuring data integrity and accuracy.