Saranya Duraisamy

Examining the data model to facilitate the transition of the data source from one system to another

Evaluating the current dashboard to enhance performance and optimize load times

Designing and building new dashboards and reports aligned with business stakeholders' requirements

Collaborating with stakeholders to ensure requirements remain up-to-date and completing work within SLA timelines

Enhancing report performance by optimizing SQL queries for faster execution

• Collaborated with senior leadership to design and develop a centralised commercial performance dashboard
• I enabled complex analysis of customer behaviour alongside regional performance tracking across trading and marketing KPIs, empowering proactive decision-making processes within the business
• Leveraged expertise in SQL, Microstrategy and Databricks to combine multisource data into a tailored Customer Care dashboard
• Enabled a 12% increase in customer satisfaction by proactively tracking contacts, SLAs and service performance and highlighting areas for operating enhancements
• Acted as MicroStrategy application SME, overseeing four system upgrades, project architecture management and integration with AWS and Databricks
• Expert in the full MicroStrategy stack, I automated administrative tasks and set up monitoring of system utilization enabling a 25% efficiency within the data department
• Built strong relationships with stakeholders across Commercial, Marketing, Web, Private Shopping, Customer Care and Product teams and translated commercial challenges to roadmap projects managing cross-functional priorities
• Combining data from business systems, GA and external platforms, I built SQL and Python notebooks to conduct deep-dives in topics ranging from Campaign Performance, Email Engagement, Traffic and Listing Tracking, Customer Cohort and Churn analysis, providing actionable insights and visualizations that tell a story
• Fostered an empowered data community through targeted workshops, training sessions, and documentation initiatives that significantly enhanced data literacy across the organization

• Collaborated with business stakeholders to understand data requirements, facilitating the design and development of reports, dashboards, and visualizations using Power BI and MicroStrategy tools
• Proficiently resolved issues in Power BI and MicroStrategy reports/dashboards, showcasing adeptness in SQL and Data Warehouse concepts, alongside a comprehensive grasp of data modeling, data warehousing, and data visualization principles
• Designed and delivered a comprehensive dashboard focusing on return metrics such as Return Reason, Return Rate, % of Return, and SLA for return, ensuring data accuracy and preparation, thereby providing valuable insights to the business team regarding company returns
• Liaised with Product and Commercial departments, including collaboration with Data Engineering, Data Science, and Data Warehouse teams
• Collaborated with data science and marketing team to conduct market assessment deep dives that led continuous improvement of campaign performance
• Expert in creating bespoke DAX calculations, I defined and implemented department KPIs for centralized and individual business reporting
• Worked on the initial setups of SAS and MicroStrategy cloud platforms as an administrator, including migrating projects and scripts from on-premises to the cloud environment
• Led the SAS application migration project, overseeing the transition from SAS 9.4 to SAS Viya, which involved adapting existing SAS scripts for migration to Snowflake from Teradata
• Managed the MicroStrategy Application migration project, converting the conversion of projects from on-premises to cloud, and establishing Control-M jobs to run upon ETL completion daily

• Experienced in database migration from Teradata to Snowflake, with a focus on database connectivity, data quality assurance, and conducting thorough data accuracy testing
• Collaborated with source systems such as MDM, RMS, RDW, Online Reporting, Ab-initio, Salesforce, utilizing FTP/SFTP methods in Linux to both receive and transmit flat files efficiently
• As a MicroStrategy Subject Matter Expert (SME), I led MicroStrategy application-related issue resolution, facilitated Mobile reporting setup, managed license key activation, executed version migrations, and optimized environment settings
• This included fine-tuning reports using VLDP settings, configuring I-server, enhancing web server performance, managing project migrations, and overseeing package migration activities
• I provided expertise on hardware platforms, architecture, and delivered tailored solutions across the Sainsbury's group
• Served as the reporting lead for both MicroStrategy and SAS applications, leading a team of seven members
• My primary focus was on managing Business As Usual activities, ensuring the smooth operation of day-to-day tasks within the system
• Managed MicroStrategy server-related issues, license key activation, version migration, and environment optimization including report tuning, I-server configuration, web server performance tuning, and Narrowcast server services runtime performance tuning
• Oversaw current MicroStrategy Architecture, Product Suites, administration policies, and methodologies in Sainsbury's on-premises systems
• Automated manual activities in the MicroStrategy application through multiple Service Improvement Requests and created several reports for users to automate delivery to their mailbox which reduced the 30% of manual efforts from the business team
• Collaborated closely with stakeholders from diverse departments, including Commercial, Finance, Merchandise, Logistics, Marketing, and Customer Data
• I facilitated discussions to understand their requirements and emphasized the importance of timely report delivery, particularly on Monday mornings, focusing on Last Week Profit on Sales

• Developed reports and dashboards in both Business Objects and MicroStrategy, catering to diverse business requirements
• Analyzed, designed, and developed Web Intelligence and Crystal reports for high-profile business users
• Created various simple and complex reports using Business Objects universes as data providers
• Designed and implemented various dashboards using Xcelsius
• Conducted testing and validation of report data values to ensure accuracy and reliability
• Proficient in Business Objects versions 3.1 and 4.1, MicroStrategy versions 9.1 and 9.3, as well as MS SQL Server versions 2008 and 2012
• Resolved reporting issues in both Business Objects and MicroStrategy, focusing on improving performance and optimizing queries

• Collaborated with source systems such as MDM, RMS, RDW, Online Reporting, Ab-initio, Salesforce, utilizing FTP/SFTP methods in Linux to both receive and transmit flat files efficiently
• As a MicroStrategy Subject Matter Expert (SME), I led MicroStrategy application-related issue resolution, facilitated Mobile reporting setup, managed license key activation, executed version migrations, and optimized environment settings
• This included fine-tuning reports using VLDP settings, configuring I-server, enhancing web server performance, managing project migrations, and overseeing package migration activities
• I provided expertise on hardware platforms, architecture, and delivered tailored solutions across the Sainsbury's group