Anand Sooroju

• Led BI & Data Warehousing projects, constructing a Data Federation Framework using Tibco Data Virtualization.
• Unified BI reporting capabilities by integrating data from multiple heterogeneous sources.
• Developed Logical and Physical Data Models for SaaS products within an in-house Data Warehouse.
• Built data marts and warehouses for comprehensive analytical reporting.
• Delivered end-to-end Cognos reporting solutions from MarkLogic (NoSQL) database.
• Created Dimensional Models for Self-Service Reporting with Cognos Framework Manager.
• Developed and managed workflows, data wrangling, and storage solutions in DataIku DSS.
• Conducted various cloud technology POCs utilizing Alteryx, Snowflake, and Databricks.
• Automated and streamlined Database and BI deployments with DevOps tools.
• Published internal blogs on Data Virtualization, promoting best practices.
• Completed Data Science Essentials certification using Python.

Key Achievement: Spearheaded analytics initiatives using Alteryx to enhance data preparation and blending, resulting in more efficient data workflows and insightful business analytics.

• Enhanced project documentation and adopted JIRA for agile project management.
• Analyzed business requirements, generating functional and technical documentation for the ETL development team.
• Developed a Data Quality Control framework and standardized the Release Management process.
• Implemented and maintained Cognos Framework Manager Models.
• Supported the Cognos Reporting and ETL team to produce high-quality reports.
• Onboarded Perforce P4 for version control.

Key Achievement: Streamlined data quality and ETL processes, significantly improving the accuracy and reliability of analytics outputs.

• Implemented Dimensional Models in Cognos Framework Manager to meet business outcomes.
• Mastered Tableau visualization tool and developed multiple POCs.
• Conducted data analysis and profiling to prepare data models.

Key Achievement: Introduced advanced analytics and visualization techniques, leading to improved data insights and decision-making.

• Acted as Technical SME for all Cognos reporting needs.
• Collaborated with database architects and system administrators for BI systems' seamless operation.
• Developed fleet reliability dashboards and KPIs for offline analysis.
• Created generic Cognos DMR models and implemented advanced reporting features.
• Coordinated with remote teams for daily activities.
• Eliminated manual Excel reporting by creating an automated Reporting Portal.
• Delivered end-user training sessions to promote Cognos reporting solutions.
• Provided production support for Cognos Datamart Reporting and EPM Transactional System.
• Developed complex Cognos reports and OLAP models using Cognos Transformer.

Key Achievement: Successfully transitioned from manual to automated reporting systems, enhancing reporting efficiency and accuracy.