Rishab Surana Email & Phone Number

Pune, MH, IN

An employee experience platform for today’s workforceBuilding analytics.

Bengaluru, Karnataka, India

• Owned and delivered complex data modeling and dashboard design projects for the BI team.
• Wrote multiple complex SQL queries in PostgreSQL to extract, transform, and analyze datasets ranging from 500,000 to 5 million rows, enabling the BI team to generate critical business insights.
• Designed and implemented ETL data pipelines using Python and AWS Lambda, automating the processing of 1 million records per day and reducing manual intervention by 80%.
• Leveraged Python and the Sisense API to automate the end-to-end data security setup for the Sisense BI platform, ensuring secure access to sensitive data for 200+ users and reducing manual configuration time by 90%.
• Converted reusable queries in View’s that helped my team to reduce report development time by 25% & also optimized previously written queries.
• Recognized for outstanding performance in Q1 of FY2021 at Cropin

Pune Area, India

• Executed advanced SQL queries to retrieve, transform, and store data, enabling the generation of critical business reports that drove key strategic decisions.
• Investigated and resolved production ABENDs by analyzing job logs and executing SQL and Python scripts, minimizing downtime and ensuring data integrity.
• Created new monthly, weekly, daily jobs using JCL & SQL, scheduled it as per the requirement.
• Completed Accenture's Tableau training program and used the acquired skills to enhance and maintain Tableau dashboards.
• Provided on-call support and resolved critical production issues during weekends, ensuring uninterrupted business operations and maintaining high customer satisfaction.