Sashank Viduluri

• Led Proof of Concept (PoC) for Microsoft Fabric, evaluating its capabilities in data integration, real-time analytics, Power BI Copilot, and AI-powered insights to enhance BI solutions.
• Spearheaded migration from Cognos to Tableau and Power BI, improving data visualization, reporting efficiency, and decision-making.
• Developed KPI dashboards in Power BI to provide real-time operational insights.
• Created reports from multiple data sources in Tableau, Power BI, and Cognos, leveraging drill-down capabilities and DAX/SQL for in-depth trend analysis.
• Implemented Power Automate workflows for automated report delivery upon data availability.

• Designed and optimized database objects (tables, views, indexes, stored procedures) to support business intelligence needs.
• Ensured data integrity, accuracy, and completeness, resolving issues and maintaining quality standards.
• Tuned complex SQL queries for efficient data extraction, transformation, and analysis.
• Maintained version control for stored procedures, views, and functions within the BI environment.
• Implemented best practices in database design, query optimization, and error handling strategies.

• Gathered and documented reporting requirements, working closely with business users.
• Tested new software releases to ensure functionality before deployment.
• Collaborated with developers, DBAs, and support teams to optimize BI performance.
• Troubleshot and resolved BI report issues with the Production Support team, minimizing downtime.
• Mentored junior developers, enhancing team skill sets and knowledge sharing.

• Recommended workflow improvements, optimizing team efficiency and project execution.
• Developed a user-friendly portal for accessing reports across multiple platforms.
• Applied best practices in coding standards and BI development methodologies (Agile, Waterfall).
• Implemented exception handling to improve program stability and system reliability.

Tableau & Data Visualization Cognos & BI Development

• Researched innovative data visualization techniques in Tableau for enhanced insights.
• Developed complex LOD expressions and table calculations for advanced analytics.
• Collaborated with stakeholders to gather business requirements and build tailored dashboards.
• Optimized SQL queries and database connections for improved Tableau performance.
• Designed interactive dashboards with drill-down features, filters, and dynamic visuals.
• Integrated external APIs with Tableau for real-time data streaming and live insights.
• Implemented best practices for dashboard optimization and performance tuning.
• Created custom charts, graphs, and hierarchies for deeper financial and operational analysis.
• Managed full project lifecycle, from design and development to deployment and maintenance.
• Developed Cognos BI reports using Report Studio and Query Studio for enterprise reporting.
• Created complex report models in Framework Manager, integrating multiple data sources.
• Tested and validated reporting objects before production deployment to ensure accuracy.
• Configured Cognos Transformer cubes for use in Analysis Studio and Report Studio.
• Maintained metadata models, report specs, and data warehouse design documents.
• Implemented Agile & Waterfall methodologies to streamline BI development.
• Provided technical support for Cognos tools, troubleshooting installation and configuration issues.
• Conducted training sessions to enhance end-user adoption of Cognos and Tableau tools.
• Resolved customer issues by troubleshooting defects and implementing solutions.

• Developed complex report models in Framework Manager to support reporting needs.
• Designed, tested, and optimized Cognos reports using Report Studio, Query Studio, and Event Studio.
• Created SQL queries to extract and transform data from Oracle and MS-SQL databases for reports and cubes.
• Optimized Cognos packages for performance and scalability, resolving slow-running reports through indexing and query tuning.
• Implemented security measures to protect sensitive data within Cognos applications.
• Deployed and maintained Cognos packages across DEV, UAT, and Production environments.
• Configured and maintained content store databases to align with evolving business needs.
• Developed and optimized OLAP cubes for advanced data analysis in Analysis Studio and Report Studio.
• Collaborated with IT teams to troubleshoot Cognos upgrades, patches, and service pack installations.
• Provided end-user training and technical support for Cognos tools and dashboards.
• Led testing and validation of new software versions to ensure compatibility and integrity before deployment.
• Applied Agile and Waterfall methodologies to accelerate the BI development lifecycle.
• Communicated progress updates with stakeholders and clients, ensuring timely deliverables

• Led the successful transition from Cognos 10.2 to Cognos 11.1, improving platform performance and capabilities.
• Migrated Framework Manager packages from CQM to DQM, optimizing query performance.
• Designed, developed, and tested reports in Report Studio, Event Studio, and Query Studio.
• Installed and configured Framework Manager for complex report modeling.
• Deployed Cognos packages and reports across DEV, QA, UAT, and Production environments.
• Provided technical support for Cognos Reporting tools, troubleshooting installation and configuration issues.
• Validated new and modified reporting objects before production deployment to ensure integrity.
• Enhanced report formatting using Drill Down, Crosstabs, Master/Detail, and Blocks in Report Studio.
• Implemented best practices for efficient report development and performance optimization.
• Performed maintenance tasks, including backups, dataset archiving, and log purging.
• Collaborated with IT teams to resolve technical issues related to Cognos upgrades, patches, and service packs.
• Applied coding best practices to ensure consistent and optimized development.

• Developed custom scripts to automate monthly financial report generation, improving efficiency.
• Maintained documentation for metadata models, report specifications, and data marts.
• Optimized Cognos packages for enhanced performance and scalability.
• Implemented best practices for Agile and Waterfall development methodologies.
• Designed complex report models in Framework Manager, integrating multiple data sources, calculations, and filters.
• Tested and validated reporting objects before production deployment to ensure data integrity.
• Provided technical support for Cognos Reporting tools, resolving installation and configuration issues.
• Developed BI reports using Report Studio and Query Studio, enhancing data visualization.
• Configured and managed Cognos TM1 cubes for Analysis Studio and Report Studio.
• Developed and implemented TM1 cubes for advanced financial analysis.
• Ensured smooth report generation by monitoring, debugging, and resolving issues proactively.
• Managed user access and strengthened TM1 cube security through necessary updates.
• Developed user-specific reports with Drill Down, Crosstabs, Master/Detail, and Blocks in Report Studio.
• Created and implemented new report formats to improve readability and insights.
• Coordinated system installations, testing, and code corrections for seamless deployments.
• Performed ad-hoc analysis on large datasets using complex SQL queries against SQL Server databases.

• Migrated BO reports to Cognos, optimizing efficiency and integrating BI technology into business operations.
• Developed Cognos BI reports using Report Studio and Query Studio with advanced features.
• Optimized report performance using sorting, ranking, and cascading prompts for improved data presentation.
• Customized reports with Drill Down, Crosstabs, Master/Detail, and Blocks to meet user requirements.
• Led estimation preparation, provided weekly client reporting, and coordinated team tasks.
• Analyzed reports using BO tools (Infoview, Webi, Crystal) for insights and decision-making.
• Designed complex report models in Framework Manager with multiple data sources and calculations.
• Implemented features like conditional formatting, bursting, prompts, bookmarks, and HTML elements for dynamic reporting.
• Maintained thorough documentation for future reference and knowledge sharing.
• Tested and validated reporting objects before production deployment to ensure data integrity.

• Monitored system performance metrics (CPU utilization, disk I/O activity) to ensure optimal BI platform functionality.
• Developed and deployed Cognos BI reports using Report Studio and Query Studio across multiple environments.
• Performed regular system status checks and automated report monitoring for smooth operations.
• Tested and validated reporting objects before production deployment to ensure data integrity.
• Diagnosed and resolved report errors through thorough analysis and issue remediation.
• Managed job creation, updates, and tracked manual task progress for efficiency.
• Optimized system performance by refreshing caches as needed.
• Implemented advanced report features like Conditional Variables, Drill-Through, and Cascading Prompts to enhance user experience.
• Utilized ReportNet features (Drill Down, Crosstabs, Master/Detail, Blocks) to develop dynamic reports tailored to user needs.