ranil deo

Analyst, Analytics & Reporting

PVH Corp•  December 2021 - Present•  Bangalore

• Leveraged SQL, PL/SQL, SSRS, Power BI, and MicroStrategy Lighthouse for data reporting and analysis. • Optimized database performance and created interactive reports. • Managed SAP BW incidents and extracted custom reports from the POS database. • Provided Level 2 support for the Lighthouse platform. • Played a key role in developing and integrating new POS systems for the Japan market. • Led the maintenance of Calvin Klein and Tommy Hilfiger POS systems in APAC. • Managed data flow between POS and SAP systems. • Utilized data analysis and visualization skills to predict future sales and growth in the APAC region. • Developed new reports for the Tommy Hilfiger POS system migration in Japan. • Utilized Power BI and other BI tools to create compelling data stories. • Defined product roadmaps as Product Owner. • Ensured data integrity and managed databases. • Proficient in Python, Java, SQL, PL/SQL, and Oracle Xstore. • Implemented sprint management practices and fostered teamwork within agile development teams. • Drove the MicroStrategy reporting project. • Presented data-driven insights through interactive dashboards and reports. • Created SSIS packages for importing data and populating database tables. • Created views in Microsoft SQL Server for tables after transforming the data. • Used these views to create reports in SSRS and Power BI. • Developed Article Master with image, Sales Transaction Report, and Staff Performance Report. • Dealt with business stakeholders for support on reports. • Tested reports and handled access requests. • Managed SAP BW L1 and L2 support tickets.

Application Development Associate

accenture•  February 2021 - November 2021

• Played instrumental role in ensuring data accuracy, security, and performance optimization of database systems. • Leveraged SQL and PL/SQL for data manipulation and analysis, contributing to overall database efficiency. • Actively contributed to development and maintenance of Hyperion Financial Management (HFM) solutions. • Enhanced financial consolidation and reporting capabilities, driving actionable insights through effective reporting. • Demonstrated proficiency in Python, Java, SQL, PL/SQL, and data analysis. • Implemented sprint management practices to optimize project timelines and deliverables. • Provided effective people management, fostering teamwork and collaboration for innovation and productivity.