SROMAN GUHA

Data Integration and ETL Processes

• Conceptual, Logical, and Physical Data Models: Developed and implemented data models (conceptual, logical, and physical) for various business applications, enhancing the scalability of data systems and ensuring 99% data integrity across multiple databases.
• Data Quality Enhancement: Ensured high data accuracy by enhancing data quality checks throughout the ETL process.
• ETL Process Management: Was involved in the design and execution of ETL pipelines , seamlessly integrating data from diverse sources into centralized data warehouses , increasing data processing efficiency by 25% .
• Performance Optimization : Spearheaded initiatives to improve data query performance by 30% through index optimization, query restructuring, and best practices implementation.

Data Analysis and Visualization

• Advanced Data Analytics: Analyzed datasets containing over 1 million records, providing insights that contributed to a 15% increase in revenue.
• Dashboard Creation: Designed and delivered 80+ Power BI , improving operational performance by 20% and enabling effective KPI tracking across multiple departments
• Reporting Solutions: Developed reporting solutions for 200+ users , improving the tracking and visualization of business performance by 30% .

Collaboration with Cross-Functional Teams

• Cross-Functional Collaboration: Partnered with business and technical teams to design and implement data strategies , building data flows that supported machine learning models, reporting, and data visualizations.
• Data Security and Compliance: Ensured data models met security and compliance requirements, addressing data access control, audit trails, and regulatory standards.

• Managed sponsorship team of 10+ members and oversaw several enhancements to club’s revenue models, resulting in substantial growth in brand collaborations and increased funding for events
• Major role in decision-making for Sponsorship, Management, and Promotional Teams of Geekonix (2017-2020).