Skills
- Having over 10 years of experience in the IT industry with strong knowledge of Data Warehousing, Business Intelligence (IBM Certified Administrator)
- Proficient in Cognos 10 (DW-BI Tool) (Report Studio, Query Studio, Event Studio, Analysis Studio and Framework Manager).
- Work extensively as Cognos Administrator including Installing and Configuring of Cognos Software.
- Involved in migration of Cognos 8.4 to Cognos 10.2.1.
- Developed different kinds of Standard and Complex reports including List, Cross-tab, Charts, Conditional Formatting, Cascading Prompts, and Drill through reports and Burst Reports in Report Studio. (By using Relational Package as well as Dimensional Package (DMR functions)).
- Configured Cognos Audit Reports.
- Involved in incremental enhancements or changes in the existing reports.
- Configured Cognos using NTLM & LDAP.
- Good Knowledge of Java script.
- Work on SQL Profiler as well as query execution plan for performance optimization.
- Have good problem solving and analytical skills. Highly motivated, quick learner and extremely versatile.
- Highly skilled in managing the complete life cycle of projects including analysis of the client requirements, translating new ideas into clients’ solutions, requirements development, delivery, support, analysis and documentation.
- Consummate professional with excellent communication, planning, execution, monitoring and problem solving skills, as well as the ability to handle multiple tasks in high pressure environments and under tight deadlines.
- Enriched 2 years of Project Delivery, Client Communication and Offshore team management experience.
- Knowledge of Tableau Desktop 9.0
- Working as a Freelance Cognos Consultant for more than a year (May, 2017)
TECHNICAL SKILLS:
- Reporting Tools: COGNOS 8.4/10.2/11, Microsoft SQL Server Reporting, Services (SSRS), Tableau Desktop 9.0
- Databases: SQL-Server 2008, Oracle
- Languages: HTML, JavaScript, ASP.Net, C#
- Version Tool: VSS (Visual Source Safe)
- Defect Tool: HPQC 11
- Project Management Tool: Workfront
Project history
PROFESSIONAL SYNOPSIS
PROJECT:
Metrix - Team Lead
A business performance management system for the private banking arm of the Group – Phase 1 comprises of reporting KPI (Key Performance Indicators) such as AUM, NBI, NNMA, etc. of the group’s various entities into the Data Warehouse of the Head Office in Paris developed for the project. Phase 2 deals with generation and summarization of KPI data from transactional data (from operational systems). The project also involves development of a data warehouse, Cognos reporting, creation of ETL using SSIS, and design of a .NET application.
- Developed different kinds of Standard and Complex reports including List, Cross-tab, Charts, Conditional Formatting, Cascading Prompts, and Drill through reports and Burst Reports in Report Studio. (By using Relational Package as well as Dimensional Package (DMR functions)).
- Involved in migration of Cognos 8.4 to Cognos 10.2.1 and Cognos 10.2.2 to Cognos 11.0.6 (Cognos Analytics).
- Configured Cognos Audit Reports.
- Involved in incremental enhancements or changes in the existing reports.
- Designed dashboards for higher management.
- Experience in creating cubes using Power Play Transformer
- Experience in creating reports by using package which is published using cubes or TM1.
- Configured Cognos using NTLM & LDAP.
- Experience in writing with HTML/JavaScript in Cognos report studio reports as per the requirements.
- Convert CQM models into DQM.
- Deployment of reports.
- Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos (Good knowledge of SQL Profiler to check the query execution plan).
- Resolved issues resulting from User Acceptance Testing (UAT) and PROD.
- Performing Development test, UAT, preparing proof-of-concept testing and pre live and post live support.
- Highly skilled in managing the complete life cycle of projects including analysis of the client requirements, translating new ideas into clients’ solutions, requirements development, delivery, support, analysis and documentation.
- Consummate professional with excellent communication, planning, execution, monitoring and problem solving skills, as well as the ability to handle multiple tasks in high pressure environments and under tight deadlines.
- Have good problem solving and analytical skills. Highly motivated, quick learner and extremely versatile.
- Enriched 2 years of Project Delivery, Client Communication and Offshore team management experience.
- Data Analysis & Reporting on Tableau Desktop and Published on server.
- Created Dashboards in Cognos Analytics by using Data Module.
- Experience of Agile and Waterfall methodologies and Software Development life cycle SDLC
- Basic Knowledge of Power BI and Talend.
PROJECT:
Metrix - Team Lead
- BI Tools: COGNOS 10 BI, Cognos 8 BI and Framework Manager
- Platform: ASP.Net using C#, SQL Server 2008
- Other Tools: Stylecop, Fxcop, Visual Source Safe, NUnit
- Team Size: 30
A business performance management system for the private banking arm of the Group – Phase 1 comprises of reporting KPI (Key Performance Indicators) such as AUM, NBI, NNMA, etc. of the group’s various entities into the Data Warehouse of the Head Office in Paris developed for the project. Phase 2 deals with generation and summarization of KPI data from transactional data (from operational systems). The project also involves development of a data warehouse, Cognos reporting, creation of ETL using SSIS, and design of a .NET application.
Local Availability
Only available in these countries:
India
Any where
Other
I am a certified Cognos administrator
Professional certifications:
Professional certifications:
- IBM Certified Designer - Cognos Analytics Author V11
- IBM Certified Cognos 10 BI Administrator
- Tableau Desktop 9 Qualified Associate