SHIVANANDA SUBBANNA

• Company Overview: Max Data & BI Squad in Landmark | United Arab Emirates.
• Lead analytical initiatives to drive data-driven decision-making across Planning, Merchandising, E-commerce, and Supply Chain functions.
• Understand the business problem and provide solution through data analytical solution.
• Develop interactive dashboards, Analytical tool like (MD recom, Discount Optimization), and Excel, enabling stakeholders to monitor business performance across regions and categories.
• Analyze the data using Python and Analytical tools and provide recommendation on the next step for business action.
• Perform data cleansing, transformation, and enrichment to improve reporting accuracy and consistency.
• Collaborate with business teams to understand key challenges, such as improving sell-through for newly launched products, and provide actionable data-driven insights to address these issues.
• Collaborate with Data Engineering teams to ensure efficient schema designs and query performance tuning.
• Analyze historical sales data, customer preferences, and market trends to create accurate demand forecasts, optimize inventory levels, and reduce stockouts or overstock situations for both offline and online channels.
• Ensure data lineage, governance, and documentation practices are maintained.
• Max Data & BI Squad in Landmark | United Arab Emirates.

• Developed a Data & BI Analytics for GMG's brand portfolio (Nike, Jordan, Timberland, Under Armour, SSS, and Drop Kick) to aggregate and analyze data from multiple marketing channels.
• The tool provides brand comparisons and detailed reports, supporting data-driven decision-making.
• Implemented real-time KPI monitoring and trend analysis to optimize campaign effectiveness and strategic planning.
• Technologies used include SQL, PL/SQL, Python, Power BI, Tableau, and AWS Redshift.

• Developed and optimized SQL queries, stored procedures, and ETL processes using Alteryx, Informatica, and Databricks notebooks to extract and load data from various sources into reporting databases.
• Installed and configured BI applications on on-premise servers and virtual machines, ensuring compatibility with the latest system requirements.
• Troubleshot and debugged code to maintain data stability, performance, and functionality for Data Lake and BI applications.
• Maintained and modified existing software applications based on user feedback and business requirements, implementing enhancements and updates.
• Implemented data governance and quality standards, including data cleansing, deduplication, and validation rules to ensure data accuracy and consistency.
• Developed and executed test cases, prioritized testing activities, and tracked defects using Azure DevOps and JIRA, ensuring quality and compliance.
• Optimized data models and query performance to enhance application efficiency and reduce data processing time using query optimization and data merging techniques.

• Developed SQL queries, stored procedures, and scripts to retrieve, manipulate, and analyze data in relational databases, data warehouses, and Azure Data Lakes.
• Provided technical support and troubleshooting for data-related issues in production BI applications using Qlik Sense, resolving anomalies reported by end-users and stakeholders.
• Collaborated with data architects, business analysts, and software engineers to design and implement end-to-end BI solutions.
• Automated data processing workflows and maintained data integrity across reporting system(Qlik and Power BI).
• Implemented data quality checks and cleansing procedures to ensure accurate and consistent data for reporting and analysis.
• Optimized application performance through indexing, partitioning, query folding, and other techniques, enhancing data processing speed and resource utilization.
• Developed and maintained data integration solutions for seamless data flow and interoperability across systems and platforms.
• Verified and deployed programs to production environments, coordinating with IT operations to ensure successful deployment with minimal downtime.

Designed and developed BI dashboards using QlikView to effectively visualize data and insights.
Actively participated in requirement gathering and technical grooming sessions with senior leads.
Created unit tests for application components to improve test coverage and validate dashboard data accuracy.
Troubleshot and resolved bugs during internal testing, addressing performance issues in BI applications.
Participated in system testing to verify the performance and functionality of BI dashboards within the data ecosystem.
Provided technical support and resolved data-related issues, addressing anomalies reported by end-users and stakeholders.
Collaborated with cross-functional teams to integrate BI solutions with other systems, ensuring seamless data flow.
Implemented data security measures and access controls using QlikView Section Access to protect sensitive data and ensure compliance with data privacy regulations.
Organized folder structures on Unix/Windows servers to maintain code dependencies for Qlik task monitoring.