Prem Ranjan Kumar

Cognos Administration

· Executed complete transition from third-party vendor, taking full ownership of the process to ensure seamless integration.

· Monitoring and cleaning the Cognos user license

· Providing Cognos and business objects user access and fixing the access issues

· Creating Audit reports as per business requirements

· Providing report.XML, Model.xml, DB connection details, report output, prompts to third party vendor (Cognos to MSTR Migration)

· Adding/Removing/Renaming the tables in the Package and publishing the package

· Archiving the reports and respective schedules

· Administered BI environment, overseeing development, testing, and reporting to ensure alignment with established standards.

· Fixing the report/event/job failure

· Monitoring the Job stream and Job in TWS web admin.

· Generated latest Business objects instances and provided to end user.

· Monitoring Cognos environments to provide usage and performance metrics.

· Deploying the packages and reports from lower to production environments and vice-versa

· Monitoring tickets or Service request/Incidents in Service now tool and finding quick solution for that to achieve 100% client satisfaction and SLA.

· Created Cognos license audit process for license clean up.

· Server decommission.

· Performed DR activity for Cognos 10 & 11, TM1, PowerCenter

· IBM TM1 Cube server backup

· Maestro server upgrade from 2003 to 2019 with Cognos installation

Informatica Administration

· Monitoring IDMC jobs, sessions, and integrations, resolving performance and execution issues.

· Managing Application setup, secure agents, connections, schedules, and user access.

· Pre-Release setup

· File system Alerts/permissions

· IDMC and CDI PC Access/Deployments

· Informatica weekly Maintenance- Services Recycle

· IDMC Major Release- Vendor Maintenance

· IDMC User/Group Role clean-up

· Vulnerability Management

· Informatica GCS Cases

· Analysing and reviewing business requirements and Technical Specifications for Report development.

· Monitoring Cognos environments to provide usage and performance metrics.

· Mentored client staff and facilitated knowledge transfer to enable independent task execution.

· Deploying the packages and reports from Dev to production environments and vice versa

· Cognos health check

· Performing administrative tasks such as scheduling and delivering reports in different formats (for example HTML, PDF and Excel), Connection creation, user access.

· Supporting an end user application (Star card online)

· Upgraded the Cognos Fix Pack from 10.2.2 to 10.2.2 FP10.

· Handling all weekly, Month end and year end activity without any escalation

· Automated few Cognos activities (like server space check and temp data clean-up) by using Windows PowerShell scripts.