Anil Lakku

Admin Responsibilities:

• Installed, configured, and upgraded Cognos 10.x, 11.x, and 12.x environments on Linux and Windows.
• Managed user authentication and authorization via LDAP/Active Directory.
• Monitored dispatcher services, gateways, and multi-server deployments.
• Maintained content store and audit databases with backup and recovery strategies.
• Applied fix packs, patches, and migrations with minimal downtime.
• Automated monitoring and log cleanup scripts for proactive issue detection.

Development Responsibilities:

• Designed and developed complex reports (lists, cross-tabs, drill-through, burst reports) using Report Studio.
• Built interactive dashboards in Cognos Analytics 11/12.
• Created Framework Manager models (relational and dimensional) to support business reporting.
• Worked with stakeholders to gather requirements and deliver BI solutions.
• Tuned reports and queries for faster execution.
• Designed and developed list, cross-tab, drill-through, dashboard, and burst reports.
• Configured bursting definitions (bursting keys, recipient queries, delivery options).

Key Achievements:

• Migrated from Cognos 10.2.2 to Cognos 11.2 to Cognos 12 with zero major incidents.
• Automated monthly reporting process, saving 85% of manual effort.

• Designed and developed complex reports, dashboards, and ad-hoc queries using Cognos Report Studio and Query Studio.
• Optimized queries and reports for better performance and scalability.
• Implemented drill-through and burst reports for management reporting.
• Configured row-level security and role-based access for Cognos reports.
• Supported migration and upgrade of the Cognos environment (e.g., Cognos 10.x to 11.x).

• Designed and maintained Framework Manager models across multiple projects for Finance and Sales departments.
• Created relational and dimensional models from underlying warehouse structures for use in report development.
• Built and maintained multiple namespace's, query subjects, query items, and business views.
• Developed parameter maps for localization and dynamic filtering in models.
• Implemented object-level and data-level security for user-specific access control.
• Conducted model validation, debugging, and version control throughout the development lifecycle.
• Packaged and published metadata models to the Cognos Connection portal for report authors.