Ankit Bhawsar

• This project focuses on supporting existing Cognos 10 & 11 environments and smooth transition of content to Cognos 12
• Constant involvement in supporting the team in new report developments and content optimization as per business demand and maintaining optimal performance of BI applications, performance monitoring
• Worked closely with business users to define requirements and architect new technical solutions
• Responsible for supporting Cognos 10 content and managing Cognos 11/12 BI environments with new developments
• Formulating the plan of action for development and testing activities
• Conduct client reviews, delivery, and project signoff
• POC reporting in Power BI

Tools and Technologies: IBM Cognos 10.x, Cognos Analytics Cloud 11.x, Cognos Analytics Cloud 12.x, Windows server 2012/2019, Netezza, DB2, MS Power BI

• This project focuses on providing systematic approach to business for analyzing KPIs and responsible for designing and implementing BI solutions and maintaining optimal performance of BI applications, performance monitoring, and tuning for projects.
• Collaborating with principal Consultants to prepare project estimates and timelines.
• Responsible for supporting and managing Cognos 11 BI environment, Cognos 10 environment and user access.
• Conduct POCs for replacing the Transformer Cubes by TM1 Cubes as data source and using dashboards from Planning Analytics Workspace (PAW)
• Development and supervision of Cognos BI Reports, Dashboard along with the Framework Manager models and Transformer Cubes
• Conduct client reviews, delivery, and project signoff.

Tools and Technologies: IBM Cognos 10.x, Cognos Analytics Cloud 11.x, Cognos TM1, Windows server 2012/2019, SQL Server, Oracle DB

• This project focuses on upgrading the existing Cognos BI 10.1 version to the latest version of Cognos Analytics (11.0.7)
• This also includes migration of Cognos series 7 security to Active Directory based security
• This project also focused on setting up 2 parallel environments, one for Cloud and one for on-premises and comes with the evaluation of both the environments.
• Assist in building the upgrade strategy of the existing Cognos application.
• Design the new Cognos Analytics environment for on-premises and cloud setups.
• Develop the project handover document for the project having all the details of the reports and dashboards

Tools and Technologies: IBM Cognos 10.1, Cognos Analytics, Cognos cloud, Cognos Lifecycle Manager, Windows server 2012 R2

• The Canadian Association of Petroleum Producers (CAPP) is the voice of Canada's upstream oil and natural gas industry
• The Data Driven Decision making program enabled the members of association to take informed decisions and it also allowed them to benchmark against each other to build a healthy competitive environment
• While benchmarking was important aspect a complete measure was taken care on the security aspect as well and only the data/attribute opted in by the member was used
• Responsible for the complete analytical solution which basically involved Cognos BI, SQL Server DB and SSIS
• Management and support of user access and different data level securities
• Lead the end-to-end report development process

Tools and Technologies: IBM Cognos Analytics, IBM Cognos 10, Windows Server 2012, SQL Server 2012, SSIS, RSA 8, Erwin

• Performance Metrics Program provides injury and illness reports based on Alberta, British Columbia, and Saskatchewan Workers' Compensation Board (WCB) claims data
• These reports can highlight safety issues that impact frontline workers every day
• Solid focus on quality improvement - constantly assessing ways to improve processes, quality and increase transparency within teams
• Involved in Design and implementation of data models for OLTP systems, dimensional models OLAP systems and Cognos BI Suite
• Troubleshoot long running reports and improve performance
• Report enhancement/additional requirements with resolving QC

Tools and Technologies: Cognos 8/10, Windows Server 2008 R2, Oracle, SQL Server, MySQL Workbench