09/06/2022 updated
FM
100 % available
Senior Cognos Developer, Cognos Consultant, Cognos Consultant
Philippines
Philippines
BS Computer EngineeringCognos 10.2, SQL, Power BI, SSIS, ETL, Cognos v11
Languages
EnglishFluent
Project history
*Shell Infotech
Singapore
Industry: Manufacturing (client is Panasonic Singapore)
Job Title: Senior Cognos Developer
October 2013 - December 2106
Responsibilities:
Production Environment Administration for Cognos server and reports, Cognos 10.2 reports
development. Framework Manager Modeling, Transformer Cube design and development, Cognos
administrator for Panasonic (PISCAP)
Accomplishments:
* Brought back client trust and confidence to BI Team.
* Designed and developed Sales Cube for client. Developed Cognos reports from the cube.
* Developed Active Report Dashboard for demo to client factories
* Re-organized the Cognos Production Server security and put in place security system for new
groups of users
* Developed relational and dimensional reports as requested by Cognos users/clients. The reports
have high level of complexity
* Performs periodic bug fixing or change requests for users
* Perform SQL performance tuning for reports which are running slowly
* Conducts server maintenance (development and production) running on Linux
* Conducts Cognos seminar for users
* Performs data analysis using Oracle database
*
Singapore
Industry: Manufacturing (client is Panasonic Singapore)
Job Title: Senior Cognos Developer
October 2013 - December 2106
Responsibilities:
Production Environment Administration for Cognos server and reports, Cognos 10.2 reports
development. Framework Manager Modeling, Transformer Cube design and development, Cognos
administrator for Panasonic (PISCAP)
Accomplishments:
* Brought back client trust and confidence to BI Team.
* Designed and developed Sales Cube for client. Developed Cognos reports from the cube.
* Developed Active Report Dashboard for demo to client factories
* Re-organized the Cognos Production Server security and put in place security system for new
groups of users
* Developed relational and dimensional reports as requested by Cognos users/clients. The reports
have high level of complexity
* Performs periodic bug fixing or change requests for users
* Perform SQL performance tuning for reports which are running slowly
* Conducts server maintenance (development and production) running on Linux
* Conducts Cognos seminar for users
* Performs data analysis using Oracle database
*
*Optimum Solutions
Singapore
Industry: Pharmaceuticals (client is Boehringer-Ingelheim)
Job Title: Cognos Consultant
December 2012 - October 2013
Responsibilities:
Cognos 10, Framework Manager Model, Report Development, Datamart design and development for
client Boehringer-Ingelheim.
Accomplishments:
* Designed and developed Sales Datamart, Framework Manager Model and Sales Report for client's
Vietnam, Philippines and Middle East operations.
* Analyzed data warehouse in Oracle database.
* Designed data mart and helped in design and ETL implementation
* Develop Framework Manager Models using Cognos 10
* Develop sales report as required by clients.
* Data analysis and verification using Oracle
* Made the reports viewable in Cognos Mobile/iPad
* Designed and developed Framework Manager Model and Report for Market Share data.
* Developed Framework Manager Model and Market Share Reports.
* Developed Active reports to be viewed in iPad
Singapore
Industry: Pharmaceuticals (client is Boehringer-Ingelheim)
Job Title: Cognos Consultant
December 2012 - October 2013
Responsibilities:
Cognos 10, Framework Manager Model, Report Development, Datamart design and development for
client Boehringer-Ingelheim.
Accomplishments:
* Designed and developed Sales Datamart, Framework Manager Model and Sales Report for client's
Vietnam, Philippines and Middle East operations.
* Analyzed data warehouse in Oracle database.
* Designed data mart and helped in design and ETL implementation
* Develop Framework Manager Models using Cognos 10
* Develop sales report as required by clients.
* Data analysis and verification using Oracle
* Made the reports viewable in Cognos Mobile/iPad
* Designed and developed Framework Manager Model and Report for Market Share data.
* Developed Framework Manager Model and Market Share Reports.
* Developed Active reports to be viewed in iPad
*Hypercube Consulting
Singapore
Industry: Pharmaceuticals
Job Title: Cognos Consultant
December 2011 - November 2012
Responsibilities:
Cognos 10 development for client's China and Korea offices. Analyzed Cognos Transformer Cubes,
designed and developed Framework Manager models using design from the cubes. Developed reports
using Report Studio, Query Studio, Analysis Studio.
Projects:
* Project EDGE, Johnson and Johnson's Regional Consumer IT Division
* Analyzed existing Cognos Transformer Cubes.
* Develop Framework Manager Models for China and Korea Operations using Cognos 10.1
* Develop reports as required by clients.
* Data analysis and verification using Oracle 10g
*
Singapore
Industry: Pharmaceuticals
Job Title: Cognos Consultant
December 2011 - November 2012
Responsibilities:
Cognos 10 development for client's China and Korea offices. Analyzed Cognos Transformer Cubes,
designed and developed Framework Manager models using design from the cubes. Developed reports
using Report Studio, Query Studio, Analysis Studio.
Projects:
* Project EDGE, Johnson and Johnson's Regional Consumer IT Division
* Analyzed existing Cognos Transformer Cubes.
* Develop Framework Manager Models for China and Korea Operations using Cognos 10.1
* Develop reports as required by clients.
* Data analysis and verification using Oracle 10g
*