Senior Cognos Developer
Shell Infotech
Skills
Cognos 10.2, SQL, Power BI, SSIS, ETL, Cognos v11
Project history
10/2013
-
12/2020
*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
*
12/2012
-
10/2013
Cognos Consultant
Optimum Solutions
*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
12/2011
-
11/2012
Cognos Consultant
Hypercube Consulting
*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
*
10/2009
-
10/2011
Developer
Responsibilities:
Website development using HTML, CSS. Accepted computer encoding jobs while enrolled in Masters
in Business Administration at University of Saint La Salle.
Website development using HTML, CSS. Accepted computer encoding jobs while enrolled in Masters
in Business Administration at University of Saint La Salle.
10/2008
-
10/2009
Business Intelligence Consultant
Ventus Global Pte Ltd
*Ventus Global Pte Ltd
Singapore
Industry: Pharmaceuticals
Job Title: Business Intelligence Consultant
October 2008 - October 2009
Responsibilities:
Provides Cognos development and support services for Ventus-Global clients. Upgrade Cognos 8.2
to 8.4, fixed reports affected by the upgrade and developed new ones as required by the
client.
Projects:
* Janssen-Cilag (Johnson and Johnson's)
* Upgrade of production reports from Cognos version 8.2 to 8.4.
* Continuous development of Cognos 8.4 sales reports and dashboards.
* Merial Singapore
* Reports development for Merial Korea package using Cognos 8.2.
Singapore
Industry: Pharmaceuticals
Job Title: Business Intelligence Consultant
October 2008 - October 2009
Responsibilities:
Provides Cognos development and support services for Ventus-Global clients. Upgrade Cognos 8.2
to 8.4, fixed reports affected by the upgrade and developed new ones as required by the
client.
Projects:
* Janssen-Cilag (Johnson and Johnson's)
* Upgrade of production reports from Cognos version 8.2 to 8.4.
* Continuous development of Cognos 8.4 sales reports and dashboards.
* Merial Singapore
* Reports development for Merial Korea package using Cognos 8.2.
02/2007
-
03/2008
Senior Systems Analyst
Satyam Computer Services Ltd
*Satyam Computer Services Ltd
Cyberjaya, Malaysia
Industry: Information Technology
Job Title: Senior Systems Analyst
February 2007 - March 2008
Responsibilities:
Support, development and consulting using PL/SQL and Cognos ReportNet. Assume Project Team
Lead role. Duties include SQL scripting, analysis and upgrade of Cognos Framework Manager and
Cognos 8 reports.
Projects:
* Alshaya-COGNOS Project (client based in Kuwait)
* Analysis and implementation of Phase I Cognos reports for finance department of MH
Alshaya Co.
* Verify data integrity using SQL scripting
* HDFC Bank Project (client based in India)
* Lead an offshore team to convert existing iDecisions Oracle based reports to SQL Server.
* Cognos Support for UNICA
* Provided Congos support for UNICA's POS software to client Kasikornbank, Bangkok,
Thailand
* Verify data integrity using SQL scripting
Cyberjaya, Malaysia
Industry: Information Technology
Job Title: Senior Systems Analyst
February 2007 - March 2008
Responsibilities:
Support, development and consulting using PL/SQL and Cognos ReportNet. Assume Project Team
Lead role. Duties include SQL scripting, analysis and upgrade of Cognos Framework Manager and
Cognos 8 reports.
Projects:
* Alshaya-COGNOS Project (client based in Kuwait)
* Analysis and implementation of Phase I Cognos reports for finance department of MH
Alshaya Co.
* Verify data integrity using SQL scripting
* HDFC Bank Project (client based in India)
* Lead an offshore team to convert existing iDecisions Oracle based reports to SQL Server.
* Cognos Support for UNICA
* Provided Congos support for UNICA's POS software to client Kasikornbank, Bangkok,
Thailand
* Verify data integrity using SQL scripting
05/2003
-
01/2007
Software Developer II
Deltek Systems Philippines Ltd.
*Deltek Systems Philippines Ltd.
Makati, Philippines
Industry: Information Technology
Job Title: Software Developer II
May 19, 2003 - January 31, 2007
Responsibilities:
Data analysis, report writing and catalog design using Cognos Impromptu and Cognos ReportNet
for Deltek's Costpoint, Time Collection and GCS Premiere softwares. Periodically upgrades
existing reports to new version of Cognos.
Achievements:
* Wrote java codes for add-on report deployment automation
* Analyzed and Repaired Impromptu Catalogs and Reports Interface for Deltek's Costpoint Software
* Developed Impromptu Catalogs and Reports for Costpoint's compliance to the Sarbanes-Oxley Act
* Data verification using PL/SQL
* Completed Training in Cognos Powerplay and Transformer (Cognos Ltd Singapore)
* Completed Training in Cognos ReportNet FastTrack Training (Cognos Corporation, Reston,
Virginia, USA)
* Completed first phase of writing Costpoint reports using ReportNet
* Completed Costpoint Software Training
* Completed Training in Centura/SQL Windows
* Completed Training in PL/SQL, SQL Base, Oracle and SQL Server
* Completed Training in Impromptu Report Writing and Administration (Cognos Ltd. Singapore)
* Obtained Certification on Microsoft SQL Server, XML and HTML
Makati, Philippines
Industry: Information Technology
Job Title: Software Developer II
May 19, 2003 - January 31, 2007
Responsibilities:
Data analysis, report writing and catalog design using Cognos Impromptu and Cognos ReportNet
for Deltek's Costpoint, Time Collection and GCS Premiere softwares. Periodically upgrades
existing reports to new version of Cognos.
Achievements:
* Wrote java codes for add-on report deployment automation
* Analyzed and Repaired Impromptu Catalogs and Reports Interface for Deltek's Costpoint Software
* Developed Impromptu Catalogs and Reports for Costpoint's compliance to the Sarbanes-Oxley Act
* Data verification using PL/SQL
* Completed Training in Cognos Powerplay and Transformer (Cognos Ltd Singapore)
* Completed Training in Cognos ReportNet FastTrack Training (Cognos Corporation, Reston,
Virginia, USA)
* Completed first phase of writing Costpoint reports using ReportNet
* Completed Costpoint Software Training
* Completed Training in Centura/SQL Windows
* Completed Training in PL/SQL, SQL Base, Oracle and SQL Server
* Completed Training in Impromptu Report Writing and Administration (Cognos Ltd. Singapore)
* Obtained Certification on Microsoft SQL Server, XML and HTML
09/2000
-
08/2002
Technical Associate (Programmer)
Corporate Information Solutions
*Corporate Information Solutions
Pasig City, Philippines
Industry: Information Technology
Job Title: Technical Associate (Programmer)
September 2000 - August 2002
Responsibilities:
Peoplelinks Payroll Management System maintenance and customization using Powerbuilder and
PL/SQL.
Achievements:
* Completed Basic Computer Systems Training
* Completed UNIX Operating System Training
* Completed PL/SQL Training
* Completed Developing Applications using PowerBuilder 6.0 Training
* Attended CIS Quality and Customer Service Orientation
* Completed JavaScript Training
* Attended CIS Business Orientation
* Attended Manufacturing and Distribution Overview
* Completed Amtrix Messaging System Programming
* Completed CMM - SPI Awareness Program
* Assisted payroll users from Lopez Inc and Adtel Inc in implementing Peoplelinks Payroll
Management System
* Fixed database problems during implementation of Peoplelinks Payroll Management System
* Maintained, Stabilized and Customized Peoplelinks Payroll Management System for Lopez Inc and
Adtel Inc users
Pasig City, Philippines
Industry: Information Technology
Job Title: Technical Associate (Programmer)
September 2000 - August 2002
Responsibilities:
Peoplelinks Payroll Management System maintenance and customization using Powerbuilder and
PL/SQL.
Achievements:
* Completed Basic Computer Systems Training
* Completed UNIX Operating System Training
* Completed PL/SQL Training
* Completed Developing Applications using PowerBuilder 6.0 Training
* Attended CIS Quality and Customer Service Orientation
* Completed JavaScript Training
* Attended CIS Business Orientation
* Attended Manufacturing and Distribution Overview
* Completed Amtrix Messaging System Programming
* Completed CMM - SPI Awareness Program
* Assisted payroll users from Lopez Inc and Adtel Inc in implementing Peoplelinks Payroll
Management System
* Fixed database problems during implementation of Peoplelinks Payroll Management System
* Maintained, Stabilized and Customized Peoplelinks Payroll Management System for Lopez Inc and
Adtel Inc users
Local Availability
Only available in these countries:
Philippines
